Briefly describe the relationship between database, data warehouse and data mining

Let’s first talk about the relationship between data warehouse and data mining, and then talk about the relationship between database and data warehouse

The relationship between data warehouse and data mining

(1) Data warehouse provides better and wider data sources for data mining.

(2) Data warehouse provides a new support platform for data mining.

(3) Data warehouse provides convenience for better use of data mining tool.

(4) Data mining provides better decision support for data warehouse.

(5) Data mining puts forward higher requirements on the data organization of data warehouse.

(6) Data mining also provides extensive technical support for data warehouses.

The difference between data warehouse and data mining

(1) Data warehouse is a data storage and data organization technology that provides data sources.

(2) Data mining is a data analysis technology that can analyze data in a data warehouse.

1. Database: It is a logical concept, a warehouse used to store data, implemented through database software. The database is composed of many tables. The tables are two-dimensional and there are many fields in one table. The fields are arranged in a row, and the data is written into the table row by row. Database tables are capable of expressing multidimensional relationships in two dimensions. Such as: oracle, DB2, MySQL, Sybase, MSSQL Server, etc.

2. Data warehouse: It is an upgrade of the database concept. Logically speaking, there is no difference between a database and a data warehouse. They are both places where data is stored through database software. However, in terms of data volume, the data warehouse is much larger than the database. The data warehouse is mainly used for data mining and data analysis to assist leaders in making decisions;

The differences are mainly summarized in the following points:

1. The database only stores the current value, while the data warehouse stores Historical values;

2. The data in the database changes dynamically. As long as business occurs, the data will be updated, while the data warehouse is static historical data and can only be added and refreshed regularly;

3. The data structure in the database is relatively complex, and there are various structures to suit the needs of the business processing system, while the data structure in the data warehouse is relatively simple;

4. Data in the database The access frequency is high, but the access volume is small, while the access frequency of the data warehouse is low but the access volume is high;

5. The purpose of the data in the database is for business processing personnel, for business processing personnel Provides support for information processing, while the data warehouse is oriented to senior managers and provides them with decision-making support;

6. The database requires a fast response when accessing data, and its response time is generally within a few seconds. , and the response time of the data warehouse can be as long as several hours