Measure (data warehouse)

In a data warehouse, a measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made.

Example

For example if 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 sold.

Use of ISO representation terms

When entering data into a metadata registry such as ISO/IEC 11179, representation terms such as Number, Value and Measure are typically used as measures.

gollark: And the catch block will be exited on exception.
gollark: No, catch only catches exceptions and isn't a convenient operator.
gollark: The error silencing operator makes it so that if an error (not exception) occurs in a given scope it will be ignored and execution will continue after it.
gollark: We're simplifying this in Macron 5.505.050 by adding the error silencing operator.
gollark: Which can be compile time compile errors or compile time runtime errors.

See also

References
  • Kimball, Ralph et al. (1998); The Data Warehouse Lifecycle Toolkit, p17. Pub. Wiley. ISBN 0-471-25547-5.
  • Kimball, Ralph (1996); The Data Warehouse Toolkit, p100. Pub. Wiley. ISBN 0-471-15337-0.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.