Data warehouse common noun

xiaoxiao2021-03-06  104

Data warehouse common noun

Data Warehouse defines the concept of data warehouses in its "Father of Data Warehouse", "Data Warehouse", which is defined in its "establishing data warehouse" book, and then gives a more accurate definition: Data warehouse is In business management and decision-oriented, integrated, time-related, invisible data collection. Different from other database applications, data warehouses are more like a process, and the process of integrating, processing and analysis of business data distributed across the enterprise. Not a product that can be purchased. Data Mart Data Market, or called "Small Data Warehouse". If the data warehouse is built on the enterprise-level data model. Then the data market is a subset of the enterprise-class data warehouse, and he mainly facing the department-level business and is just a specific topic. Data markets can mitigate the bottleneck access to the data warehouse to a certain extent. The concept of OLAP Online Analysis (OLAP) was earliered by the Father E.f.codd of the Relational Database. At that time, CODD considered online transaction processing (OLTP) that the terminal user needs to query the database query analysis, and the simple query of SQL to large databases does not meet the needs of user analysis. User's decision analysis requires a lot of calculations for relational databases to get results, and the results of the query do not meet the needs of decision makers. Therefore, CODD proposes the concept of multi-dimensional database and multi-dimensional analysis, that is, OLAP. CODD proposes 12 guidelines for OLAP to describe OLAP systems: Guidelines 1 OLAP model must provide multidimensional conceptual view guidelines 2 Transparent guidelines 3 Access capacity speculation criteria 4 Stable report capabilities 5 Customer / Server architecture standards 6D, etc. Interactive Standards Guidelines 7 Dynamic Sparse Matrix Treatment Guidelines 8 Multi User Support Ability Criterion 9 Non-restricted Cross-Dimensional Operations Guidelines 10 Flexible Report Generation Guidelines 12 Unfinished Dimensional Gauge Rating ROLAP Based on CODD's 12 guidelines, various software development manufacturers see the benevolence, one of the genre, believes that can store multi-dimensional data along the relational database, so that the star structure of the sparse matrix representation method will appear. Later, I evolved the snow structure. In order to distinguish between the multi-dimensional database, the OLAP based on the relational database is referred to as RELATIONAL OLAP, referred to as ROLAP. Representing products include Informix Metacube, Microsoft SQL Server Olap Services. MOLAPARBOR SOFTWARE strictly follows the CODD definition, and the multi-dimensional database is created, and the online analysis system data has created the first river of cube, and many companies have used multi-dimensional data stores. It is called Muiltdimension OLAP, referred to as Molap, represents the product has Hyperion (formerly Arbor Software) EssBase, Showcase Strategy, etc. Client OLAP is relative to Server OLAP. Some analysis tool manufacturers recommends downloading some data to the local, providing users with local multi-dimensional analysis. Representing the product has Brio Designer, Business Object. DSS Decision Support System (DISION Support System) is equivalent to a data warehouse based application. Decision support is to collect all relevant data and information. After processing, it provides information to provide information for the company's decision-making management, providing a basis for decision-making. ETL Data Extract, Transform, Cleansing, Loading (LOAD) process. An important part of building a data warehouse, the user draws the required data from the data source. After data cleaning, the data is finally loaded into the data warehouse in a pre-defined data warehouse model.

转载请注明原文地址:https://www.9cbs.com/read-97458.html

New Post(0)