O'Reilly logo

Architecting the Industrial Internet by Carla Romano, Robert Stackowiak, Shyam Nath

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Management considerations for data warehouse

Since a data warehouse is a historical copy of data, the storage requirements will increase over time. In the case of an upgrade of the source system, the data warehouse may need to be updated accordingly.

Some application vendors provide a corresponding integrated data warehouse, but this is not typical. Most data warehouse systems are custom-built.

Advantages of data warehouses are as follows:

  • Integrate data from heterogenous sources
  • Perform historical analysis over large amounts of data without impacting operational systems
  • Enable cross-functional analysis
  • Improved data quality
  • Converge disparate systems to a common semantic

Disadvantages of data warehouses are as follows:

  • Usually require ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required