A data warehouse is an architectural construct, not a technology. A data warehouse contains integrated, historical detailed data that is available to a wide set of sources that need to access and analyze the data. A data warehouse is built on different technologies. To build a data warehouse you need an operating system, a database management system (DBMS) and one or more tools for accessing the data.

In addition, you probably need an extract, transform and load (ETL) tool, a data-cleansing tool, multiple access and analysis tools, and perhaps a data monitor. If your warehouse is large enough, you need some form of alternate storage and a cross-media storage manager. However, in spite of all the technologies required to build a data warehouse, it is still an architectural component, not a technology.

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