/
Linstedt Architecture
Save to my account
Sign up
Report Bug
Linstedt Architecture
View
Lect2_ DWArchitectures..pdf Flashcards
Study
Question
What is a Data Vault?
Answer
A detail-oriented historical tracking and uniquely linked set of normalized tables that support functional areas of the business. It is a hybrid approach of 3NF (Third Normal Form) and Star Schemas.
Question
What are the pillars of a Data Vault Methodology?
Answer
The pillars of a Data Vault Methodology include emphasis on Agile principles and practices, architecture, and modeling.
Question
What does the Architecture pillar of Data Vault focus on?
Answer
The Architecture pillar focuses on the systems and structures that handle and store data, combining the best of 3NF and star schema techniques.
Question
What does the Modeling pillar of Data Vault emphasize?
Answer
The Modeling pillar emphasizes the representation of data, ensuring that the data remains consistent, resilient, and accessible even in complex environments.
Question
What is the first step in Linstedt's approach to creating a Raw Vault?
Answer
Identify the core business concepts and select a grain of abstraction that the organization is using.
Question
What are the core concepts for the architecture in Linstedt's approach?
Answer
The core concepts for the architecture are Hubs, Links, and Satellites.
Question
What is the process of ETL in the Data Vault methodology?
Answer
ETL involves first adding Hubs for defining business IDs, followed by Links, and then additional data through Satellites.
Question
What should be done with necessary IDs in a Data Vault?
Answer
Encrypt necessary IDs as needed for maintaining security and privacy.
Question
What role do Data Marts play in relation to the Data Vault?
Answer
Data Marts are used as a presentation layer since the Data Vault has many connections.
Question
What are some advantages of the Data Vault approach?
Answer
Advantages include incremental builds that are adaptable to change, data lineage through core concepts that keep track of historical data, and a quicker and easier ETL process due to core components.
Question
What are some disadvantages of the Data Vault approach?
Answer
Disadvantages include added overhead due to complexity with fewer data sources, an explosion of tables compared to 3NF, and a lack of focus on performance due to a large number of relationships making complex joins.
