Chapter 4-Intro to DW Architecture

Question 1

What is the Value of Architecture

Answer 1

-Communication
-Planning
-Flexibility and Maintenance
-Learning
-Productivity and Reuse

Question 2

Communication

Answer 2

-excellent communication tool at several levels, providing a way to help management understand the magnitude and complexity of project

Question 3

Planning

Answer 3

-Provides cross check for the project plan
-Brings all the architecture details in one place and prescribes how they fit together
-uncovers tech requirements and dependencies that do not come out as part of the planning process for a specific project

Question 4

Flexibility and Maintenance

Answer 4

-Helps anticipating as many issues as possible
-semantic layer added to the warehouse and used in processes to create, navigate and maintain the warehouse
-Layer makes DW flexible and easier to maintain

Question 5

Learning

Answer 5

-Arch is an important role as documentation for the system
- can help new team members get up to speed with components contents and connections

Question 6

Productivity and Reuse

Answer 6

-Takes advantage of tools and metadata
-Helps automate parts of the warehouse process
- makes it easier to understand warehouse process and database contents

Question 7

Arch Framework: Column headings

Answer 7

-Data
-technical
-Infrastructure

Question 8

Arch Framework: Rows

Answer 8

-Business requirements
-Arch Models
-Detailed models
-Implementation

Question 9

Columns: Data

Answer 9

• The “what” DW is all about
  -List of data that is important to the business
  -Data stores that make up warehouse environment
  -Design of physical and logical data models
  -Defines granularity, volume, and timing of the data at various oints in the warehouse

Question 10

Column: Tech Arch Area

Answer 10

Answers the “How” how we get data at this source

Question 11

What is tech Arch made up of?

Answer 11

-Tools
-Utilities
-Code
-Places where data is moved from and to
-Brings Warehouse to life Using two areas, back and front Room

Question 12

Back Room

Answer 12

Responsible for gathering and preparing the data

Question 13

Front Room

Answer 13

Responsible for delivering the data to the user community

Question 14

Columns: Infrastructure Arch Area

Answer 14

-Platforms that host the data and processes
-hardware and the operating-level software
-needs to be examined carefully to make sure any special needs are addressed

Question 15

Defining Rows: Business Requirement Level

Answer 15

• explicitly non-technical
  Analyst should understand the major business forces and boundary conditions

Question 16

Defining Rows: Arch Models Level

Question 17

Row: Arch Model Level

Answer 17

-Proposes major components of arch that must be available
-all types of tech must be named specifically and argued hoe tech will fit together
-It addresses whether tech components can communicate with each other

Question 18

Rows: Detailed Models Level

Answer 18

-functional specifications of each of the arch components ( Very Detail)
-Include enough info to serve as a reliable implementation guide for the team member or contractor
-Help check whether implementation is complete and conforms to the specification

Question 19

Rows: Implementation Level

Answer 19

-response to detailed models
-code software deliverable

Question 20

Logical Model

Answer 20

-Vision of what the warehouse should be- Ideal that we would like to attain

Question 21

Characteristics of Logical Model

Answer 21

-Simple
-Understandable
-solves the problem
-Top row of Framework

Question 22

Physical Models

Answer 22

-Face the real world
-Some of our business requirements might rely on data
-reflect changes that were made to the logical model to get to work
-Create bottom rows of the framework

Question 23

Framework Summary

Answer 23

• Breaks arch task into manageable pieces
• 3 Columns- Data, tech and infrastructure

Question 24

Services

Answer 24

-functions needed to accomplish the required tasks of the warehouse

Question 25

Data Stores

Answer 25

Temporary or permanent landing places for data

Question 26

Key Tech Arch Features

Answer 26

-metadata Driven
-Flexible Service Layers
-Caveats

Question 27

Metadata Driven

Answer 27

• Drives the warehouse
  -Provides flexibility by buffering components
  -catalog holds mapping info from source target
  -Crucial to have a single source for metadata within DW

Question 28

Flexibel Service

Answer 28

Data Staging services and data query services add flexibility of arch

Question 29

Caveats

Answer 29

-not all tools and services support of metadata catalog
-phased approach to implementing the arch recommended
-