Concept of data warehouse-PHP Tutorial

Source: Internet
Author: User
Concept of data warehouse. With the intensification of market competition and the development of the information society, it is increasingly important to extract (retrieve, query, and so on) information from a large amount of data to develop market strategies. This requirement requires that, with the intensification of market competition and the development of the information society, a large amount of data be extracted (retrieval, query, etc)
It becomes more and more important to develop market strategies. This requirement requires both online services and a large number of applications.
But traditional database systems cannot meet this requirement. It is embodied in three aspects:
The historical data volume is large.
 
Auxiliary decision-making information involves data from many departments, which is difficult to integrate with data from different systems.
 
Due to insufficient data access capabilities, its access performance to a large amount of data is significantly reduced.

With the maturity of C/S technology and the development of parallel databases, the development trend of information processing technology is from a large number
The transaction database extracts data and clears and converts it to a new storage format, that is, the data is
Aggregation in a special format. With the development and improvement of this process, such special data that supports decision-making
Storage is called Data Warehouse (DW ).
W. H. Inmon defines data warehouse as a topic-oriented and integrated data warehouse that supports management decision-making processes.
.
A topic is the standard for data classification. each topic corresponds to an objective analysis field, such as a customer or store.
Assists decision-making in integrating a large amount of data from different departments and systems. The data warehouse contains a large amount of historical data.
The data that enters the data warehouse is rarely updated. Data in a data warehouse can be divided into 5 to 10 years.
Used for time trend analysis. The data volume of a data warehouse is large, generally about 10 GB. It is a general database
(100 MB) the data volume is 100 times, and the size of a large data warehouse reaches TB.
Data Warehouse is mainly used in two aspects:
Use the browser analysis tool to find useful information in DW.
 
The data warehouse system supports DW applications to form a decision support system (DSS ).
 

Token (search, query, and so on) is becoming more and more important to develop market strategies. This requirement is both...

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.