M-zulkifli.blogspot.com Website Review

M-ZULKIFLI.BLOGSPOT.COM DO*NLOAD FILE ARTICLES, STORIES & KNOWLEDGE. According to Innon in 2002, h.31-35, Data warehouse is a collection of data that is subject-oriented, integrated, non-renewable, has a dimension of time, which is used to support management processes in making business decisions and intelligence. : A. SUBJECT ORIENTED (SUBJECT ORIENTED. Subject-oriented data warehouse means that the data warehouse is designed to an*lyze data based on certain subjects in the organization, not on certain application processes or functions. B. INTEGRATED (INTEGRATED) Data Warehouses can store data that come from separate sources into a format that is consistent and mutually integrated with each other, thus data cannot be broken down because the existing data is a unit that supports the whole concept of the data warehouse itself C. TIME VARIANT (TIME VARIANT) All data in the data warehouse can be said to be accurate or valid in rent a certain amount of time. Data does not provide current status, they are stored for five or ten years or more and are used for trends, forecasting and comparison. that means data in the data warehouse is not updated in real time but is refreshed from the operational system on a regular basis. New data is always added as a supplement to the database itself rather than as a change. The database continuously absorbs this new data, then incrementally unites with the previous data. Building a data warehouse certainly provides more benefits for a company, because the data warehouse can provide strategic benefits to the company over their competitors. The advantage is obtained from several sources (Sean 1. Ability to access large data 2. Ability to have consistent data 3. Ability to an*lyze fast performance 4. Knowing that there are repeated results