Introduction:The main content of this article is not to introduce some data models of the existing popular main industries, but to share some of my experiences in data warehouse construction projects. We hope to help you summarize a set of methods that meet the current industry standards and meet the data
determines its representation of external data. To decide what products and technologies to use to build the core of the data warehouse, we need to analyze the technical features of the Data Warehouse. For the existing business system d
General Purpose = Take account of both OLTP and OLAPTransaction processing =OLTPData Warehouse =olapCustom DATABASE = Custom
Gold dividing line (deep analysis) *******************************
Data processing can be roughly divided into two main categories: online transaction processing OLTP (on-line transaction processing), online analytical processing OLAP (O
How data builds a bank data warehouse
Song Yuchang, No. 11th Xinhua East Road, Dengzhou, Henan, China.
As a new technology in data management field, the essence of Data Warehouse technology is to put forward a comprehensive solut
: Business topic description, including data, queries, and reports;
Metadata provides an information directory to access the data warehouse. This directory fully describes the data in the data warehouse, how the
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
Perhaps many people understand that the data warehouse is built on the basis of multidimensional data model for OLAP data platform, through the previous article-the basic architecture of the data
A brief explanation of common nouns in data data Warehouse
Data Warehouse in the middle of the 80 's, Mr. William H.inmon, the "Father of the warehouse", defined the concept of data war
effectively perform analytics, you need a data warehouse. A data warehouse is a database of a different Kind:an OLAP (Online analytical Processing) database. A data warehouse exists as
personnel. Data Warehouse
It is mainly used in the decision support system. Its main purpose is to "extract" Information and expand it for Processing decisions based on data warehouses.
Policy Support System (DSS) applications.
2 Data Warehouse-based decision support system
dimension
9 series of data warehouse-Dimension Data Processing Methods --
Snowflake
About Data Warehouse ETLA series of articles on data extraction and data SummarizationSimula
system to open Data Warehouse connection for external system to use data in Data Warehouse, Data Warehouse connection management module to control the access
Differences between OLAP and OLTP Environments
1 The performance tuning in the DB2 data warehouse environment is different from that in the OLTP environment, mainly manifested in the following aspects:
1.1 transaction length. Transactions in the OLTP environment are usually short transactions, including multipleSQLStatements, which can often be completed within s
Data warehouses are subject-oriented, integrated, non-updatable, and changing over time, which determines that the system design of a data warehouse cannot be designed with the same design method as the traditional OLTP database.The original requirements of the Data Warehouse
Data Warehouses are subject-oriented, integrated, non-updatable, and constantly changing over time, these features make sure that the system design of the data warehouse cannot be the same as that of the traditional OLTP database.
The original requirements of the data warehouse
dimension and geographical dimension. Therefore, the application of multidimensional data model is generally based on online analytical processing (online analyticalprocess, OLAP), and the data mart for a specific demand group is built on the basis of multidimensional data model.
business model : refers to the
and load data into programs and develop data mining and analysis programs. If you do not have an ERP platform yet, you need to purchase a storage device and use the extract-transform-load (ETL) software to import data to the data warehouse, and the software used for
a common subject or business field.
The following describes how to create an information package chart through information packaging technology to determine the topic and metadata in the data warehouse.3.4.1 information packaging technology1. Basic use of information packaging technology
The information packaging method is a top-down design method, which focuses on one or more topics of an enterprise from
Data warehouse and data mining are two big concepts. They are very mature in foreign countries. In China, with the accumulation of enterprise data and the maturity of ERP in the past few years, data warehouse and
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 Data
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.