Data warehouse is a collection of data that support management decision-making that has subject-oriented, integrated, time-variant and non-volatile.Data Warehouse is a storage place of subject-oriented historical data organized in order to be accessible in a form ready to be presented for the analysis process. Star schema in Data Warehouse is a logical structure that has fact tables containing factual data at its center and is surrounded by dimension tables containing reference data (which can be normalized). The star schema is a fact table located in the middle, which is connected to a set of dimension tables. Star schemes exploit characteristics of factual data such as facts generated by events in the past, and are unlikely to change, regardless of how they are analyzed.
Advantages of Using Star Schemes
The following are the advantages of using a star schema in a Data Warehouse environment:
The advantages of using a star scheme are:
1. Form a database design that provides quick response time.
2. Simplify understanding and navigation of metadata for developers and users.
3. Extend the choice of tools to access front-end data.
Advantages of Using Star Schemes
The following are the advantages of using a star schema in a Data Warehouse environment:
- Efficiency. The core database structure consistency allows more efficient access to data by multiple tools including report writers and query tools.
- Ability to handle ever-changing needs. Star schema can adapt to changes in user needs, as all dimensions are equivalent in terms of providing access to fact tables. This means that the design can better support ad-hoc user queries.
- Predictable query processing. The drill down data warehouse application will simply add more dimension attributes from within a single star schema. Drill across application will link separate fact tables through shared dimensions. Although the whole set of star schemes in complex enterprise dimensional models, query processing can be predicted because at the lowest level, every fact table must be queried independently.
- Can narrow the scope of data for processing Decision Support Systems making it simpler to access and analyze it.
The advantages of using a star scheme are:
1. Form a database design that provides quick response time.
2. Simplify understanding and navigation of metadata for developers and users.
3. Extend the choice of tools to access front-end data.
Advertisement
No comments