How does data warehousing apply to machine monitoring information? The automobile company I work for collects machine states and events real time and stores this information for later analysis for productivity improvements. After a year's worth of data is collected, the data is purged. What value can data warehousing provide?

Chuck Kelley's Answer: Keeping a long-term view of the states and events of your machines provides the ability for lots of different types of analysis. Remember that once the data is purged, it is lost. You might use a longer-term view for analysis of productivity improvements and/or quality analysis. For example, if you found that a change to widget A was needed and you did it (along with forecasting the expected results), then after collecting the new widget A data you can compare how much you have gained. Then you may make other improvements. You might be able to understand the effects of changes over the rest of the machine. Sometimes, there is an unexpected loss in one machine due to a productivity performance of another.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access