Granularity in data warehouse

Source: Internet
Author: User
What does the granularity in the data warehouse mean?

Granularity is one of the most important aspects of data warehouse design. Granularity refers to the level at which the data stored in the data unit of the Data Warehouse is refined or comprehensive.
The higher the level of refinement, the smaller the level of granularity. On the contrary, the lower the level of refinement, the larger the level of granularity.
Data granularity has always been a design issue. In an early operating system, the granularity is used for Access authorization. When detailed data is updated, it is almost always stored at the minimum granularity.
However, in the data warehouse environment, the granularity is not assumed.
In the data warehouse environment, granularity is the main design problem because it deeply affects the size of the data stored in the data warehouse and the query type that the Data Warehouse can answer.
The data volume in the data warehouse must be weighed against the query details.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.