inmon data warehouse architecture

First, the Data WarehouseThe standard definition of the Data Warehouse concept is relatively high in the industry, as proposed by Bill Inmon, the father of the Data Warehouse, in the book "Building The

First, the Data WarehouseThe standard definition of the Data Warehouse concept is relatively high in the industry, as proposed by Bill Inmon, the father of the Data Warehouse, in the book "Building The

1. Warehouse Style In the repository style. There are two different components: the central data structure shows the current state. The independent component is executed on the central data storage. The interaction between the warehouse and the external component is greatly changed in the system. If a process execution

indicators that need to be identified in this step include:L ability to manage large data volumes;• Ability to perform flexible data access;• Ability to reorganize data based on data models;L Transparent data transmission and reception capability;• Ability to periodically l

Label:There are two kinds of database design models widely used in Data warehouse: Relational type and multidimensional type. It is generally believed that the relational model in the design method of Data Warehouse is "Inmon" method and multidimensional model is "Kimball" m

: The time base change is difficult to grasp. The existing operational data is usually the current value, precision controllable, can be updated, but the data in the data warehouse can not be updated, so these data must be accompanied by time elements, when the actual operat

Original address I. Definition of metadata According to the traditional definition, metadata (Metadata) is data about data. In the Data warehouse system, metadata can help data warehouse administrators and developers of

inconsistent operation data into integrated and unified information. 5. provides basic information sources and auxiliary tools for marketing and customer analysis. 6. You can analyze the profits and costs of products, departments, and institutions. 7. Standardized management processes, optimized business processing, and improved capital utilization. 　　　　 2. Data

called the second paradigm, and so on. Therefore, Paradigms at all levels are backward compatible.　　What is star mode?　　　　The star schema is a multidimensional data relationship that consists of a Fact Table and a set of dimension tables.. Each dimension table has a dimension as the primary key. All these dimensions are combined into the primary key of the fact table. In other words, each element of the primary key of the fact table is a foreign key

1. The concept of Data Warehouse began in the 1980s S and first appeared in the book William H. Inmon, known as "the father of Data Warehouse. With Profound recognition and continuous improvement in system research, management, and maintenance. After summing up, enriching, a

-makingStorage 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

The methods for modeling SQL Server four data warehouses are mainly grouped into the following four categories. The first class is the three-paradigm modeling of relational databases, and we usually use the three-normal modeling method to build various operational database systems. The second type is the three-paradigm Data warehouse model advocated by

Data WarehouseThe purpose of the Data Warehouse is to build an integrated data environment for analysis, providing decision support for the Enterprise (decision supports). In fact, the data warehouse itself does not "produce" any

dimension 9 series of data warehouse-Dimension Data Processing Methods -- Snowflake About Data Warehouse ETLA series of articles on data extraction and data SummarizationSimula

According to the Informix Data Warehouse System implementation methodology, we can divide the data warehouse implementation into the following steps: 1. Business Demand Analysis Business Requirement analysis is the basis for data warehou