Duplicate
Export
Register
Inmon Architecture
1 PDF
2 Flashcard Decks
1 / 1
100%
View
Untitled Flashcards
Study
Lect2_ DWArchitectures..pdf Flashcards
Study
What is a data warehouse according to Bill Inmon?
A data warehouse is a subject-oriented integrated time-variant and non-volatile collection of data in support of management's decision-making process.
What does 'Non-Volatile' mean regarding a data warehouse?
Once information is saved in a Data Warehouse, it should stay there.
What does 'Integrated' mean in the context of a data warehouse?
Data is standardized no matter how it is stored in the source systems.
What does 'Time-Variant' mean in relation to data warehouses?
The data collected and stored in the Data Warehouse changes with time.
What are the necessary attributes of a data warehouse?
Subject-oriented, integrated, time-variant, and non-volatile.
What is the first step in Inmon's approach to data warehouse architecture?
Start with the corporate data model.
What should be identified as part of Inmon's approach?
Identify all the different sources of data available to the enterprise.
What is the purpose of understanding business needs in Inmon's approach?
From the data and understanding of business needs, identify the key entities and their mutual relationships.
What should the entity structure be used for in Inmon's approach?
Use the entity structure to build a detailed logical model.
What is the role of the physical model in the data warehouse architecture?
Build the physical model using the information captured in the detailed logical model.
What processes are used in building a data warehouse?
Use ETL (Extract, Transform, Load) processes.
What is the core of the normalized data model described in the text?
3NF (Third Normal Form) is the core of the normalized data model.
What does 1NF (First Normal Form) state?
Each table cell should contain only a single value and each column should have a unique name.
What does 2NF (Second Normal Form) mean?
Each column should be directly related to the primary key and not to other columns.
What does 3NF (Third Normal Form) signify?
Each column should not be related to any other columns in the same table.
What should be built for specific departments according to the text?
Build data marts for specific departments.
What does the data warehouse act as in an enterprise?
The data warehouse acts as a single source of truth.
What are some advantages of Inmon's Corporate Information Factory architecture?
Flexibility due to ETL process design, less prone to errors from normalization, and completeness in covering all enterprise data for reporting needs.
What are some disadvantages of Inmon's Corporate Information Factory architecture?
Costs and setup complexity, the necessity of highly skilled engineers, and needing more ETL due to the separation of Data Marts from Data Warehouse.
Scholarly Assistant's Insights
Explore Inmon Architecture, focusing on data warehouse principles, design, and ETL processes.
Data Warehousing
Inmon Architecture
Etl Processes
Data Management
Business Intelligence
+2 more
Ask Scholarly Assistant
Similar Pages
Login to Leave a Comment
Give your feedback, or leave a comment on a page to share your thoughts with the community.
Login