MIS 6443 Inmon Exam 1 Information

1
MIS 6443 Inmon Exam 1 Information

• Dr. Segall Fall 2003
• Wednesday, October 22, 2003
• In-Class Open Book Open Notes

2
In Class Exam on Inmon Chapters 1-3 Acxiom Talk

• 40 questions
• Worth a total of 100 points
• 20 Multiple choice _at_ 3 points each 60 points
• 20 TRUE/FALSE _at_ 2 points each 40 points

3
In Class Exam on Inmon Chapters 1-3 Acxiom Talk

• Inmon Chapter 1 Handouts
• 10 TRUE/FALSE
• 4 Multiple Choice
• Acxiom Presentation of October 15,2003
• 3 TRUE/FALSE
• Inmon Chapter 2
• 5 Multiple Choice
• Inmon Chapter 3
• 7 TRUE/FALSE
• 11 Multiple Choice

4
In Class Exam on Inmon Chapters 1-3 Acxiom Talk

• Handouts used in preparing Exam Questions include
  those posted on course web page of
• For Chapter 1 of Inmon
• 9 Data Warehouse Evolving to The Corporate
  Information Factory
• 24 Managing the Data Warehouse
• 6 Data Warehouse 2000 Evolving to the
  Corporate Information Factory
• 7 Building the Data Mart or the Data Warehouse
  First?
• 13 Data Management The Evolution
• 22 ERP and Data Warehouse
• 23 An Enterprise Architecture

5
In Class Exam on Inmon Chapters 1-3 Acxiom Talk

• Handouts used in preparing Exam Questions include
  those posted on course web page of
• For Chapter 2 of Inmon
• Team 1 PowerPoint slides (Jim McGinnis, Kris
  Williams, Matt Crook)
• Team 2 PowerPoint slides (Amresh Mohan Lal, Kumar
  Neti, Susan Shanlever)
• For Chapter 3 of Inmon
• Team 3A PowerPoint slides (Shane Brown, Angela
  Daniels, Charl Welman)
• Team 3B PowerPoint slides (Michael Watson, Steve
  Gibson, Alicia Stevenson)

6
QUICK REVIEW OF INMON CHAPTER 1

• Chapter 1 Title Evolution of Decision Support
  Systems
• Be able to understand The Spider Web on pages
  6-9 and Figures 1.3, 1,4 and 1.5 on pages 7-10.
• From Data to Information (also on handouts)
• A Change to Approach
• 2 Kinds of data in an architected environment
  (Figure 1.9 on page 15)
• PRIMITIVE DATA/OPERATIONAL DATA
• DERIVED DATA/DSS DATA

7
QUICK REVIEW OF INMON CHAPTER 1

• The Architected Environment on pages 16-19
• Be able to understand Figure 1.10 Levels of the
  Architecture on page 16
• The Development Life Cycle on pages 21-22
• CLDS is the reverse of SDLC
• BE FAMILIAR WITH MATERIAL ON INMON HANDOUTS 9,
  24, 6, 7, 13, 22 23!!!
• E.g. An Enterprise Architecture, Building the
  Data Mart or the Data Warehouse First?

8
QUICK REVIEW OF INMON CHAPTER 2

• Chapter Title The Data Warehouse Environment
• From page 31 A data warehouse is a
  subject-oriented, integrated nonvolatile, and
  time-variant collection of data in support of
  managements decisions. The data warehouse
  contains granular corporate data.
• Be able to understand Figure 2.1 on page 32
  Subject orientation
• Be able to understand Figure 2.2 on page 33 The
  issue of integration

9
QUICK REVIEW OF INMON CHAPTER 2

• Be able to understand Figure 2.7 on page 38 The
  collections of data that belong to the same
  subject area are tied together by a common key.
• Be able to understand Figure 2.10 on page 42
  Day 1-day n phenomenon
• Be able to understand major design issues of the
  data warehouse
• 1. Granularity - pg. 43, Figure 2.11 on
  page 44
• The Benefits of Granularity , pg. 45
• Example on pages 47-48
• Dual Levels of Granularity on pages 49-53

10
QUICK REVIEW OF INMON CHAPTER 2

• 2. Partitioning of Data on pages 56-59
• 3. Proper Design by Structuring Data in the Data
  Warehouse
• Be able to understand Figures 2.20-2.25 on pages
  60-63
• (a.) Simple cumulative structure
• (b.) Rolling Summary Data
• (c.) Simple Direct File
• (d.) Continuous File
• 4. Data Homogeneity/Heterogeneity on pages 69-72.
• 5. Operational Reporting vs. Data Warehousing
  Reporting in Figure 2.31 on page 73.

11
QUICK REVIEW OF INMON CHAPTER 3

• Chapter Title The Data Warehouse and Design
• Data warehouses can NOT be designed the same way
  as the classical requirements-driven system. (p.
  81)
• Be able to understand
• Figure 3.1 on page 82 not as simple as mere
  extraction,
• Figure 3.2 on page 83 Unintegrated Data
• Figure 3.3 on page 84 Integrated Data
• Figure 3.4 on page 86 Five common techniques
  that are used to limit the amount of operational
  data scanned at the point of refreshing the data
  warehouse.

12
QUICK REVIEW OF INMON CHAPTER 3

• Be able to understand
• The differences between (See Figure 3.7 on page
  89)
• The corporate model
• The operational model
• The data warehouse model
• Stability Analysis (See Figure 3.9 on page 91.)
• 3 Levels of Data Modeling (p. 92-101)
• High-Level Modeling (ERD, entity relationship
  level)(p.92-94)
• Midlevel Modeling ( Data item set of DIS)
  (p.94-98)
• Low-Level Modeling (physical model) (p.98-101)

13
QUICK REVIEW OF INMON CHAPTER 3

• Be able to understand
• Normalization/Denormalization (p. 102-110)
• Figure 3.29 on page 107 Description is
  redundantly spread over the many places it is
  used.
• Figure 3.32 on page 109 Creative
  indexes/profiles
• Management of referential integrity (p. 109)
• Snapshots in the Data Warehouse on pg. 110-112.
• Cyclicity of Data The Wrinkle of Time on
  pages 115-118
• Complexity of Transformation and Integration on
  pages 118-122.

14
QUICK REVIEW OF INMON CHAPTER 3

• Be able to understand
• Profile Records (p. 124-125)
• Going from the Data Warehouse to the Operational
  Environment (p. 128)
• DIRECT Access of Data Warehouse Data (p. 129)
• INDIRECT Access of Data Warehouse Data (p.
  130-135).
• INDIRECT USE of Data Warehouse Data (p. 136-7).
• Star Joins (p. 137-143).
• Be able to understand Figure 3.54 (p.140) and
  Figure 3.55 (p.141).

15
MIS 6443 Inmon Exam 1 Information

• Dr. Segall Fall 2003
• Wednesday, October 22, 2003
• In-Class Open Book Open Notes