利用者:MarleneThorton725のソースを表示



What makes a data warehouse essential for a business is being able to gather information from different parts and then making them just one a part of a centralized database. It's a collection of data, that is further utilized by employees for an simple and easy , smooth working process. Learn more about data warehousing by reading the content.

Data warehouse is definitely an asset for a corporation because it maintains the efficiency, profitability and competitive graph. A business collects data from sources like inventory manageable, answering services company, sales leads etc., that is then passed through the Data Life Cycle Management policy. It is primarily the policy of the organization that determines the design and methodology from the data warehouse.

The primary motive of the data warehouse is to create front-end analytics which will offer the operation staff and other employees from the organization. Here are a few of the elements of a data warehouse:

Pre-Data Warehouse

This zone provides data for that data warehousing and the team of designers filters the data which has business value for insertion. Operational data is kept in OLTP database, which resides in transactional computer programs like supply chain, ERP etc. OLTP's are equipped for high transaction speed and accuracy.

It's the metadata that ensures accuracy of information that will be entered into the warehouse. Most of the organizations reduce cost for that ETL stage by choosing a metadata policy.

Data Cleansing

Data skin cleansing is the extraction, transformation and cleaning process that are done to ensure the excellence of the data before it is entered in the warehouse.


[http://www.emanio.com/data-warehousing/DataWarehousingSoftware.html emanio] 

Data Repository

Data repository is a database where active data of an organization is stored. This will make it optimized for data analysis.

There are two types of data warehouses - ODS and Data Marts. Although data marts are no different from data warehouses in physical terms however they can be smaller and are built on departmental level rather than company level.

One drawback of data warehouse is it collects data and has older data as well, which means you won't get an up-to-date analysis. Operational Data Stores can be handy with regards to storing recent data before migrating to the data warehouse.

Front-End Analysis

Front-end application that'll be used by employees is the most critical part of an information warehouse. They'll use it to extract information and connect to the data stored in the repositories.

Data Mining

It is the discovery of many useful patterns within the data. Data mining can be used for analyzing and the classification process.

Data Visualization Tools

These tools are used for displaying the information in the data repository. Designers often blend it with data mining and OLAP tools. The entire process of data visualization helps users in manipulating data according to its relevancy and pattern.