Data Warehouse systems

A Data Warehouse system is a database. This type of database is mainly distinguished from other databases by the following aspects:

  • It provides integration of data accross system boundaries and time.
  • It stores large quantities of data and efficiently processes complex statements.
  • It implements special strategies and physical structures to get homogeneous data, which can be easily manipulated.

Data Warehousing is a process of designing (architecture), building (development), and maintaining (administration/support) a data warehouse system.

Data Warehouse systems software