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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access