The following are the OLAP database objects:
1. Cubes: Data in cubes are persisted in a summarized version that helps to analyze data quickly. The data is persisted, through which reporting can be done easily.
2. Data Sources: The data source is location, from which data comes in data warehousing. Data is collected from different resources and cleaned. This data source could be internal or external. Cleansing of source data and efficient analysis is the prime process for data warehousing.
3. Fact Tables: Fact table consists of facts and / or measures in data warehousing. Usually the data is stored in numeric fashion. For example, the number of resources used for a task is stored as actual measure.
4. Database roles: The database security is managed by utilizing database level roles. These roles may be fixed or flexible. The fixed roles are predefined where as flexible roles can be created.
Cubes.
A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily. E.g. using a data cube a user may want to analyze weekly, monthly performance of an employee. Here, month and week could be considered as the dimensions of the cube.
Data Sources.
Data source is where the data comes from in data warehousing. The data collected from various sources and is cleaned. The data source can be internal or external. Efficient Analysis and cleansing of source data is the key success to data warehousing.
Fact Tables.
Data in a warehouse comes from the transactions. Fact table in a data warehouse consists of facts and/or measures. The nature of data in a fact table is usually numerical. e.g. If I want to know the number of resources used for a task, my fact table will store the actual measure (of resources) while my Dimension table will store the task and resource details.
Database roles.
Database level roles are used to manage the security of the database. The role can be either fixed or flexible. Fixed roles are predefined while flexible roles can be created. Examples of some fixed database level roles are db_owner, db_securityadmin, db_datawriter etc
1. Cubes: Data in cubes are persisted in a summarized version that helps to analyze data quickly. The data is persisted, through which reporting can be done easily.
2. Data Sources: The data source is location, from which data comes in data warehousing. Data is collected from different resources and cleaned. This data source could be internal or external. Cleansing of source data and efficient analysis is the prime process for data warehousing.
3. Fact Tables: Fact table consists of facts and / or measures in data warehousing. Usually the data is stored in numeric fashion. For example, the number of resources used for a task is stored as actual measure.
4. Database roles: The database security is managed by utilizing database level roles. These roles may be fixed or flexible. The fixed roles are predefined where as flexible roles can be created.
Cubes.
A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily. E.g. using a data cube a user may want to analyze weekly, monthly performance of an employee. Here, month and week could be considered as the dimensions of the cube.
Data Sources.
Data source is where the data comes from in data warehousing. The data collected from various sources and is cleaned. The data source can be internal or external. Efficient Analysis and cleansing of source data is the key success to data warehousing.
Fact Tables.
Data in a warehouse comes from the transactions. Fact table in a data warehouse consists of facts and/or measures. The nature of data in a fact table is usually numerical. e.g. If I want to know the number of resources used for a task, my fact table will store the actual measure (of resources) while my Dimension table will store the task and resource details.
Database roles.
Database level roles are used to manage the security of the database. The role can be either fixed or flexible. Fixed roles are predefined while flexible roles can be created. Examples of some fixed database level roles are db_owner, db_securityadmin, db_datawriter etc
No comments:
Post a Comment