Granularity (data)
The granularity ( Latin "granum" , translated as "graininess") of data provides information about their degree of compression. Data is often compressed according to spatial (e.g. geographical), temporal and organizational aspects, i.e. H. summarized or aggregated. The compression of individual numerical data can be done by means of addition, averaging or other arithmetic operations such as minimum or maximum formation or by merging several objects into a new one.
Are z. If, for example, the sales figures of an international trading company are presented at the level of the individual branches, the sales figures can be condensed at the city, state and continent level. The fine-grained data at the branch level become coarse-grained data at the continent level. The branch level provides the finest granularity of sales data, but has the highest level of detail, while the continent level has the coarsest granularity and the lowest level of detail.
The granularity of data plays a particularly important role in data warehousing . The data stored in the data warehouse can e.g. B. selected using OLAP according to different aspects and summarized and presented on different levels of compression with the corresponding degree of compression.
literature
Individual evidence
- ↑ A. Totok: Modeling of OLAP and data warehouse systems. Deutscher Universitätsverlag, 2000, ISBN 3-8244-7110-8 , p. 113.
