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. A measure can either be categorical, algebraic or holistic.

## Contents

* 1 Example
* 2 Use of ISO representation terms
* 3 See also
* 4 References

## 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 or the 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.

## See also

* Data warehouse
* Dimension (data warehouse)

## 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.
* Han, Jiawei Pei, Jian Tong, Hanghang. (2023). Data Mining Concepts and Techniques (4th Edition) - 3.2.4 Measures: Categorization and Computation. (pp. 105). Elsevier.

* v
* t
* e

Data warehouses

Creating a data warehouse

| Concepts|

* Database
* Dimension
* Dimensional modeling
* Fact
* OLAP
* Star schema
* Snowflake schema
* Reverse star schema
* Aggregate

|

Variants|

* Anchor modeling
* Column-oriented DBMS
* Data vault modeling
* HOLAP
* MOLAP
* ROLAP
* Operational data store

Elements|

* Data dictionary/Metadata
* Data mart
* Sixth normal form
* Surrogate key

Fact|

* Fact table
* Early-arriving fact
* Measure

Dimension|

* Dimension table
* Degenerate
* Slowly changing

Filling|

* Extract-Transform-Load (ETL)
* Extract
* Transform
* Load

Using a data warehouse

| Concepts|

* Business intelligence
* Dashboard
* Data mining
* Decision support system (DSS)
* OLAP cube
* Data warehouse automation

|

Languages|

* Data Mining Extensions (DMX)
* MultiDimensional eXpressions (MDX)
* XML for Analysis (XMLA)

Tools|

* Business intelligence software
* Reporting software
* Spreadsheet

Related

| People|

* Bill Inmon
* Ralph Kimball

|

Products|

* Comparison of OLAP servers
* Data warehousing products and their producers

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Measure (data warehouse). Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Measure_(data_warehouse)&oldid=228303"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template