Measure (data warehouse)
Encyclopedia
In a data warehouse
, a measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made using precomputed aggregates.
, representation term
s such as Number, Value and Measure are typically used as measures.
Data warehouse
In computing, a data warehouse is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations before it is used in the DW for reporting.A data warehouse...
, a measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made using precomputed aggregates.
Example
For example if a retail store sold a specific product, the quantity and prices of each item sold could be added or averaged to find the total number of items sold and total or average price of the goods.Use of ISO representation terms
When entering data into a metadata registry such as ISO/IEC 11179ISO/IEC 11179
ISO/IEC 11179 is an international standard for representing metadata for an organization in a metadata registry.- Intended purpose :...
, representation term
Representation term
A representation term is a word, or a combination of words, that semantically represent the data type of a data element. A representation term is commonly referred to as a class word by those familiar with data dictionaries...
s such as Number, Value and Measure are typically used as measures.