Introduction to the English abbreviation of Data Warehouse

Endorsement

With the advent of big data, often hear the relevant vocabulary, dimensions, indicators, BI, PV, UV, and so on, if you do not know what the meaning, embarrassed to come out mixed, today I tidied up these words, can let everyone quickly into the relevant topics.

Dw

DW is the abbreviation for Data Warehouse, which is the database warehouse. Data warehouses are mostly stored in a variety of databases.

DW is different from the ordinary database, the Data warehouse is used to support decision-making, analytical data processing, and the general database is mainly used for software/website use.

BI

BI is the acronym for Business Intelligence, which is a process of drilling information and knowledge from a large amount of data by explaining it as a technology set that helps enterprises better utilize data to improve decision quality. Simply speaking is the process of application of business, data and data value. Graphically, it can be understood as:

Index

My understanding is that the result numbers, such as PV, UV, and the corresponding dimensions

Dimension of

My understanding dimension is the attribute of the indicator. For example: "2015-01-12 PV is 1000", then the date (is the 2015-01-12 abstract) is the dimension, PV is the indicator, 1000 is the value

Latitude table

The dimension table puts the data table that holds the dimension, or the data table of the dimension relationship

Real-time Tables

The fact table holds the data to query the dimension. For example: Daily PV, UV

Etl

is an acronym for English extract-transform-load that describes the process of extracting data from the source (Extract), transpose (Transform), loading (load) to the destination. ETL is an important part of building a data warehouse, the user extracts the data from the data source, after the data cleansing, finally according to the pre-defined Data warehouse model, the data load into the Data warehouse.

OLAP

OLAP is an abbreviation for online analytical processing (On-line Analytical Processing).

Baidu explains: OLAP is a kind of software technology that enables analysts, managers, or executives to access information quickly, consistently and interactively from multiple angles to gain a deeper understanding of the data.

Translate adult speech: The process of displaying the data in real-time and dimension tables.

For the concept of data Warehouse layering, you can refer to: http://www.cnblogs.com/liqiu/p/4013743.html

Introduction to the English abbreviation of Data Warehouse