Granularity refers to the level of detail of the data stored fact tables in a data warehouse. High granularity refers to data that is at or near the transaction level. Data that is at the transaction level is usually referred to as atomic level data. Low granularity refers to data that is summarized or aggregated, usually from the atomic level data. Summarized data can be lightly summarized as in daily or weekly summaries or highly summarized data such as yearly averages and totals.
Granularity refers to the level of detail or summarization in the units of in the data warehouse (Inmon, WH 2002). For example, one of the dimension might be a date/time dimension which could be at the year, month, quarter, period, week, day, hour, minute, second, hundredths of seconds level of granularity. High granularity means that the data is at or near the transaction level, which has more detail. Low granularity means that the data is aggregated, which has less detail.
Data marts are combined into a data warehouse cannot be built alone without considering data marts. Both has equal importance to built proper data warehouse.
One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.
What are the three most common forms of data warehouses? is a smaller form of a data warehouse that is often used by a single department or function. An independent data mart is a tiny warehouse that is built for a strategic business unit (SBU) or a department, but it does not have a central data source (EDW). To learn more about data science please visit- Learnbay.co
A data warehouse functions as a repository for all the data held by an organisation. The main functions are to reduce cost of data storage, facilitate data mining, and facilitate ability to back up data at an organisational level.
Granularity refers to the level of detail or summarization in the units of in the data warehouse (Inmon, WH 2002). For example, one of the dimension might be a date/time dimension which could be at the year, month, quarter, period, week, day, hour, minute, second, hundredths of seconds level of granularity. High granularity means that the data is at or near the transaction level, which has more detail. Low granularity means that the data is aggregated, which has less detail.
it's data warehouse....data warehouse: it is a collection of multiple databases or it it is repository of data.data mining it is the process of extracting data from data warehouse.
lowest level of data
Data warehouse is the database on which we apply data mining.
A data warehouse stores structured data from various sources for analysis and reporting. It typically includes historical data, organized into tables, aimed at supporting decision-making processes. Data warehouses are optimized for complex queries and data aggregation.
Data marts are combined into a data warehouse cannot be built alone without considering data marts. Both has equal importance to built proper data warehouse.
Data warehouse is a house where current as well as historical data can be stored.
Every data structure in the data warehouse contains the time element. Why?
One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.
catch important data from data warehouse.
Pilot data is the controlling data in the data warehouse which is found by combining different data mart.
Data about other data is metadata.