How to publicize the Data Warehouse?

Data topic: How to Advertise Data Warehouse?
Author: hem
Affiliated Forum: Data Warehouse
Problem points: 300
Number of replies: 1
Popularity Index: 6
Publish Time: 2001-9-13 16:38:32
Data warehousing is a theme-oriented, integrated, and time-changing, non-volatile collection of data that supports management's decision
Strategy analysis.

The Data Warehouse analyzes the historical data to get the development trend of the analysis topic to support decision analysis of decision-making. For online analytical processing.
Database common relational database is mostly used for online transaction processing, dealing with current transactions and transactions.

Examples of integration:

Take a department store, the company has a lot of branches, each branch has its own daily transaction records data.
There is a real detailed transaction history, as well as monthly and annual belongs data. The head office needs to know the operation of the company
To determine how to expand business, understand customer shopping trends, promote new products and other series of decisions. Just imagine, if
Each subsidiary will send all the historical data to the head office, how many disks and how many resources does the head office need to store
The data? What does the head office want these data for? The head office does not need these detailed data if the subsidiary is under a
After the fixed cycle belongs to the head office, thus, the data quantity is small, is advantageous to the analysis. But, so many children
Within a company, each company's data structure may be defined differently. A unified data definition is required.
The data sent to the head office is quite comprehensive. In this way, the company can the user shopping trends, shopping ability and other topics
Do a more comprehensive analysis to explore customers, expand the size of the company.

Theme-oriented:

A communications company may simply record a user's receivables, advance payments, call records, and rates. If you set up a customer theme area
Domain, which is used to record the user's purchase of the service, the user's geographical location. This topic area can help communications companies predict customers
Growth rates, geographical distribution of customers, customers ' propensity to buy services to add new services, what communications are sold in those areas
Decisions about products and so on.

Change over time:

This is mentioned in the above two examples. Department store accounting system, communications company's accounting system is the most change over time
A good example, the accounting system periodically belongs data, and then add belongs data to the data warehouse, so that the data bin
The library is the change over time.

of a non-volatile nature:

Generally, the data appended to the data warehouse is not allowed to change, it is different from the online transaction processing system and allows the database records to be modified. This data warehouse data is generally not lost.
The Data Warehouse has several main points:

Integrated (extract, transform, load) ETL
Meta-data (data that describes the data) MetaData
Theme Star Structure

The data query in the Data warehouse is the most important. Views, indexes are the choice to improve the query.
Code base is the prerequisite of unification and integration.