Database Management Systems

This is one of the types of data warehouse. They are updated every time an operational system performs a transaction.

OLTP (On-Line Transaction Processing) is a system to handle day-to-day business transactions. These systems handle tremendous amount of data daily.

A data warehouse is a relational database, which is designed for query and analysis rather than for transaction processing.

These servers support multidimensional views of data through array based multidimensional storage engines.

This type is the integration of heterogeneous business intelligence systems set to provide analytical capabilities across different functions of an organisation.

Non-volaitle means that once entered into the data warehouse, data should not change. 

Data scrubbing is the act of detecting and correcting corrupt or inaccurate records from a record set, table or database.

This category of data comes from the various operational systems of the enterprise based on the information requirements in the data warehouse.

This component of data warehouse architecture sits on top of all the other components. This co-ordinates the services and activities within the data warehouse.

Meta data in a data warehouse is similar to the data dictionary or data catalog in a data management system.

Data mining is the practice of examining large databases in order to generate new information.

This service is a Microsoft technology service used in combination with ActiveX data objects that allows the retrieval of a set of data from a database server.

This form of data can be used by XML to store data into files and databases.

Schema is a logical structure that can classify or group database objects.

Data dictionary stores the information about both the logical and physical structures of the database.