Kylin中常用术语

数据仓库

Data Warehouse: a data warehouse (DW orDWH), also known as an enterprise data warehouse (EDW), is a system used forreporting and data analysis

 

商业智能

Business Intelligence: Businessintelligence (BI) is the set of techniques and tools for the transformation ofraw data into meaningful and useful information for business analysis purposes

 

OLAP

在线分析处理

OLAP: OLAP is an acronym for onlineanalytical processing

 

OLAP立方

一个OLAP立方是一个数据数组，按照它的0维或者多维来理解的。

OLAP Cube: an OLAP cube is an array of dataunderstood in terms of its 0 or more dimensions, Wikipedia

 

星型架构

星型结构由一个或者多个事实表和相关联的一些维度表组成。

Star Schema: the star schema consists ofone or more fact tables referencing any number of dimension tables

 

事实表

一个事实表由特征，度量或者一个业务流程的事实组成

Fact Table: a Fact table consists of themeasurements, metrics or facts of a business process

 

查找表

查找表是用一个简化的阵列索引操作代替运行时的计算的一个阵列。

Lookup Table: a lookup table is an arraythat replaces runtime computation with a simpler array indexing operation

 

维

一个维是一个能分类事实与测量值并帮助用户回应业务问题的结构。经常使用的维度是人、产品、地点与时间。

Dimension: A dimension is a structure thatcategorizes facts and measures in order to enable users to answer businessquestions. Commonly used dimensions are people, products, place and time

 

度量

它是一个那些可以被生成的性质（例如 ）

Measure: a measure is a property on whichcalculations (e.g., sum, count, average, minimum, maximum)can be made

 

Join：

一个SQL语句join联合了来自二个或者多个关系型数据库表中的记录。

Join: a SQL join clause combines recordsfrom two or more tables in a relational database