/
Inmon Architecture
Save to my account
Sign up
Inmon Architecture
View
Untitled Flashcards
Study
Lect2_ DWArchitectures..pdf Flashcards
Study
1
Question
What is a data warehouse according to Bill Inmon?
Answer
A data warehouse is a subject-oriented integrated time-variant and non-volatile collection of data in support of management's decision-making process.
2
Question
What does 'Non-Volatile' mean regarding a data warehouse?
Answer
Once information is saved in a Data Warehouse, it should stay there.
3
Question
What does 'Integrated' mean in the context of a data warehouse?
Answer
Data is standardized no matter how it is stored in the source systems.
4
Question
What does 'Time-Variant' mean in relation to data warehouses?
Answer
The data collected and stored in the Data Warehouse changes with time.
5
Question
What are the necessary attributes of a data warehouse?
Answer
Subject-oriented, integrated, time-variant, and non-volatile.
6
Question
What is the first step in Inmon's approach to data warehouse architecture?
Answer
Start with the corporate data model.
7
Question
What should be identified as part of Inmon's approach?
Answer
Identify all the different sources of data available to the enterprise.
8
Question
What is the purpose of understanding business needs in Inmon's approach?
Answer
From the data and understanding of business needs, identify the key entities and their mutual relationships.
9
Question
What should the entity structure be used for in Inmon's approach?
Answer
Use the entity structure to build a detailed logical model.
10
Question
What is the role of the physical model in the data warehouse architecture?
Answer
Build the physical model using the information captured in the detailed logical model.
11
Question
What processes are used in building a data warehouse?
Answer
Use ETL (Extract, Transform, Load) processes.
12
Question
What is the core of the normalized data model described in the text?
Answer
3NF (Third Normal Form) is the core of the normalized data model.
13
Question
What does 1NF (First Normal Form) state?
Answer
Each table cell should contain only a single value and each column should have a unique name.
14
Question
What does 2NF (Second Normal Form) mean?
Answer
Each column should be directly related to the primary key and not to other columns.
15
Question
What does 3NF (Third Normal Form) signify?
Answer
Each column should not be related to any other columns in the same table.
16
Question
What should be built for specific departments according to the text?
Answer
Build data marts for specific departments.
17
Question
What does the data warehouse act as in an enterprise?
Answer
The data warehouse acts as a single source of truth.
18
Question
What are some advantages of Inmon's Corporate Information Factory architecture?
Answer
Flexibility due to ETL process design, less prone to errors from normalization, and completeness in covering all enterprise data for reporting needs.
19
Question
What are some disadvantages of Inmon's Corporate Information Factory architecture?
Answer
Costs and setup complexity, the necessity of highly skilled engineers, and needing more ETL due to the separation of Data Marts from Data Warehouse.