As the name implies, a database data set is a place where a large amount of data is stored, and data is put into the database or the contents of the data structure in the database are accessed.

A database is equivalent to a container data structure, which is equivalent to a way of putting things into the container and a way of taking things out. Without a data structure, things (data) in the container will be taken out in disorder and troublesome.

1. Data storage layer

Data storage is designed to the concept and language of the database, which is not necessarily the case. SQL query language is essential and proficient is the best. We can start with the basic structure and reading of selece query, update modification, delete deletion and insert insertion.

Aess23, Aess7, etc., which are the most basic personal databases and are often used for personal or partial basic data storage; MySQL database, which is necessary for departmental or internet database applications, is the key to master the database structure and data query ability of SQL language at this time;

SQLServer25 or higher, for small and medium-sized enterprises, some large enterprises can also use SQLServer database. In fact, this time, in addition to data storage, it also includes data reports and data analysis, and even data mining tools are included;

DB2 and Oracle databases are large-scale databases, mainly enterprise-level, especially large enterprises or large-scale data storage requirements are necessary, and generally large database companies provide very good data integration application platforms;

BI level, in fact, this is not a database, but a data warehouse for enterprise applications based on the previous database. DataWarehouse, the data storage based on DW computer is basically a business intelligence platform, which integrates all kinds of data analysis, report, analysis and presentation. BI-level data warehouse combined with BI products is also a major trend in recent years.

2. Report /BI layer

Enterprises need to read and display stored data, and report tools are the most widely used tools, especially in China. In the past, traditional reports mostly solved the problem of presentation. Nowadays, FineReport, like windsurfing report, will also cross with other applications to make data analysis reports. Through the functions of interface opening, reporting and decision-making reports, data can be accessed, covering the functions of early business intelligence.

BI tools such as p>Tableau, Qlikview and FineBI can be divided into report layer and data presentation layer, covering data integration, data analysis and data presentation. FineBI and Tableau are both excellent softwares in recent years, which can be used as visual data analysis software, and FineBI can be used to fetch data from the database for report and visual analysis. Relatively speaking, visual Tableau is better, but FineBI has another identity-business intelligence, so its ability in big data processing is better.