Concept | Data extraction (retrieval, query, etc.) from a large number of data as the market competition intensifies and the development of information society needs.
It becomes more and more important to develop the information of marketing strategy. This requirement requires both online services and a large number of
To the data of the decision, and the traditional database system is unable to meet this requirement. Its concrete manifestation in three aspects:
The amount of historical data is large.
Ancillary decision information involves data from many departments, and data from different systems is difficult to integrate.
Due to insufficient access to data, the performance of its access to large amounts of data is significantly reduced.
With the maturity of C/s technology and the development of parallel database, the development trend of information processing technology is from a large number of
The transaction database extracts the data and cleans it up and transforms it into a new storage format, which is the data for the decision target
Aggregation in a special format. With the development and refinement of this process, the special data that supports decision making
Storage is called a data Warehouse (Warehouse, DW).
W. H. Inmon The Data Warehouse is defined as a data warehouse that supports the management decision process, the theme-oriented, integrated
, stable, different time data collection.
Topics are standards for data collation, each subject corresponding to an objective analysis area, such as customers, stores, etc., which can be
Auxiliary decisions integrate large amounts of data from different systems in multiple departments. The Data warehouse contains a lot of historical data,
Cheng data entry into the Data warehouse is rarely updated. Data in the data warehouse within the time limit of 5 years to 10, mainly
Used for time trend analysis. Data Warehouse data volume is very large, generally 10GB or so. It's a general database.
(100MB) 100 times times the volume of data, and large data warehouses reach terabytes.
Data Warehouse is mainly used in two aspects:
Use the Browse Analysis tool to find useful information in the DW.
The Data Warehouse system supports the application on DW and Forms Decision Support System (DSS).
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
