Bi-kipedia Compound key or composite key A compound key uses multiple columns within a table in order to uniquely identify a single record. Thursday, 17 July 2014
Bi-kipedia Primary key A primary key is the key of a table in order to uniquely identify a single record. It can consist of one column or a combination of columns. Thursday, 17 July 2014
Bi-kipedia Foreign key A foreign key is the connecting link between two tables which enables the possibility to use the related information together. In a proper setup, the foreign key is pointing to the primary key of the connected table and it thus ensures the referential integrity of the data. Thursday, 17 July 2014
Bi-kipedia Natural key or Business key The natural key or business key is the key of a table as defined within a source system. Thursday, 17 July 2014
Bi-kipedia Surrogate key or technical key A surrogate key or technical key is an artificially created numerical key without any business meaning. These keys are used within a data warehouse environment in order to easily combine tables. Thursday, 17 July 2014
Bi-kipedia Slowly changing dimension Slowly changing dimensions are a set of data warehouse techniques to deal with history within a dimension.Dimensions are related to facts and while the facts are basically always transaction oriented with an associated date, a dimension is not. Therefore a dimension may require history as well.3 basic types exist: Thursday, 17 July 2014
Bi-kipedia Metadata Metadata is data about data. Metadata is used to describe the properties of data such as dimensions, hierarchies, performance metrics and report layout objectsA distinction can be made between business and technical metadata. Thursday, 17 July 2014
Bi-kipedia Dimension A dimension table contains all information for one single entity in context of one or more related fact tables. Within a business question it deals with the "by” part. E.g. a customer dimension contains a customer number, name, address, contacts etc. Thursday, 17 July 2014
Bi-kipedia Measure or metric A measure is a numeric expression, which can be used and displayed –by dimension- on reports and consist of base facts, aggregated values or mathematical functions. Thursday, 17 July 2014
Bi-kipedia Fact table A fact table contains all numeric information for one single business process in context of multiple related dimensions.eg. a sales fact contains number of sold quantities, revenue, margin, etc. The granularity is ideally kept as low as possible in order to enable a variety of reports and analyses. Thursday, 17 July 2014