Understanding of Data Warehouse based on six characteristics of a Data warehouse

Data Warehouse technology usage almost needed by all organizations, Library is no exception. Data warehouse allows the integration of various types of data from a wide range of applications or systems. Data Warehouse is a concept as well as a combination of technologies that provide facilities on an organization in the management and maintenance of historical data obtained from the system or application operations. Data warehouse technology needed by most organizations or companies, which allows performing some sort of integration of data from different systems and applications. Data warehouse has six characteristics among others.

Some basic concepts about data warehouse:

• Data warehouse is a data subject-oriented, integrated, has a time dimension, and is a collection of fixed (non-volatile), used in support of the process of decision-making by managers at every level (but especially on the managerial level has high ratings).
• Data warehouse is a new paradigm of strategic decision-making surroundings. The data warehouse is not a product but rather an environment where users can find strategic information. Data warehouse is a collection of logical data is separated from the operational database and is a summary.
• Data warehouse data is obtained from the process by which organizations extract meaning from information asset they have. Data warehouse is a new innovation in terms of information technology. Since its inception about 15 years ago, the concept of a data warehouse is growing rapidly so as to when this data warehouse concept ni is the concept of the most talked about by experts in the field of information technology.
• Data Warehouse is the central repository of information that is subject-oriented database capable of providing for the historic nature of the information that supports the DSS (Decision Support System) and EIS (Executive Information System).
• A copy of transaction data specifically structured on the query and analysis.
• A copy of transaction data specifically structured for query and report.

As the meaning of the data warehouses that have been described previously. Data warehouses have six characteristics that exist in the data warehouse that includes Subject Oriented, Integrated, Time-Variant, Non-Volatile, Process Oriented, and Accessible.

Advertisement

Related Content: