Data warehouse is a bunch of data that is produced to support decision making is also a repository of current and historical data of potential interest managers throughout the company. The third characteristic is in the Data Warehouse is Time Variant. Time-Variant means that all data in the Data Warehouse are collected from various sources of data from the different application then identified from the holding period. In other words, the process of data storage – the collected data based on time. As for the information presented by the data – data in the Data Warehouse as seen from the viewpoint of history of storage or commonly called a Historical Point Of View.
The characteristics of Time-Variant appears as a form of application of the system of OLAP (On Line Analytical Processing) that is embraced by the Data Warehouse. Compared with OLTP system (On Line Transactions Processing) embraced by database, OLAP Data Warehouse does not require the existence of archiving. OLTP systems, while the need for archiving for data – historical data as a condition for increasing the performance of database systems. Data Warehouse only focuses to changes that occur in the data – the data at regular intervals, so that it appears the time variation.
The characteristics of Time-Variant appears as a form of application of the system of OLAP (On Line Analytical Processing) that is embraced by the Data Warehouse. Compared with OLTP system (On Line Transactions Processing) embraced by database, OLAP Data Warehouse does not require the existence of archiving. OLTP systems, while the need for archiving for data – historical data as a condition for increasing the performance of database systems. Data Warehouse only focuses to changes that occur in the data – the data at regular intervals, so that it appears the time variation.
Advertisement
No comments