Home Page Icon
Home Page
Table of Contents for
Footnote
Close
Footnote
by Ryan Sousa, Claudia Imhoff, W. H. Inmon
Corporate Information Factory
Cover Page
Title Page
Copyright Page
Contents
Preface
Acknowledgments
Chapter 1: Creating an Information Ecosystem
Information Ecosystem Briefly Defined
Shifting Business Landscape
Consumer Demand
Competition and Complexity
Operating Efficiencies
Responding to Change
Corporate Information Factory
People and Processes
Summary
Chapter 2: Introducing the Corporate Information Factory
Data in the Corporate Information Factory
External Data
Reference Data
Historical Data
The Decision-Support System to Operational Feedback Loop
The Flow of Data
Variations to the Corporate Information Factory
Operational Processing and DSS Processing
Reporting in the Corporate Information Factory
Corporate Information Factory Users
Applications Users
Decision-Support System/Informational Users
Types of DSS Usage in the Corporate Information Factory Environment
Centralized or Distributed?
Data Modeling and the Corporate Information Factory
Migrating to the Corporate Information Factory
Structuring Data in the Corporate Information Factory
Summary
Chapter 3: The External World Component
Transaction Producers
A Taxonomy of Transactions
Consumers of Information
Who Are the Participants?
Summary
Chapter 4: The Applications Component
Dated Applications
Unintegrated Applications
Applications’ Response Times
Migrating from an Unintegrated State
External Data, Metadata, and Applications
Feeds into and out of the Applications Environment
Summary
Chapter 5: The Integration and Transformation Layer Component
What Is the Integration and Transformation Layer?
An Unstable Interface
Feeds into and out of the Interface
Complex Integration and Transformation Interface
The Role of the Data Model
Creating Metadata
Automatic Creation of I & T Code
Processing in the Integration and Transformation Interface
Performing Key Transformations
Creating Profile/Aggregate Records
Encoding Structures
Simple Reformatting
Mathematical Conversion
Resequencing Data
Assigning Default Values
Handling Multiple Data Sources
Log Tapes As a Source
Changing Platforms
Who Is in Charge?
Summary
Chapter 6: The Operational Data Store Component
What Is an Operational Data Store?
Volatility
Current-Valued
Detailed Data
Feeds into and out of the Operational Data Store
The Integration and Transformation Layer Feed
Different Classes of the Operational Data Store
Class I Operational Data Store
Class II Operational Data Store
Class III Operational Data Store
Class IV Operational Data Store
Determining the Class
Dynamic Summary Data
Static Summary Data
The Operational Data Store Workload
Load Processing
Update Processing
Access Processing
DSS Analysis Processing
Different Processing Windows
What Is a Homogeneous Workload?
External Data in the Operational Data Store
Summary
Chapter 7: The Data Warehouse Component
What Is the Data Warehouse?
Subject Orientation
Integration
Time Variancy
Historical Data
Nonvolatility
Containment of Summary and Detailed Data
Data Warehouse Administration
The Data Warehouse Drawn to Scale
Feeds into and out of the Data Warehouse
The Operational Data Store Feed
The Integration and Transformation Layer Feed
Feeds into the Data Mart
Alternative Storage Feeds
Exploration Warehouse Feeds
Data in the Data Warehouse
Processing Data in the Warehouse
Managing Technological Challenges
Archiving Data out of the Data Warehouse
Summary
Chapter 8: The Data Mart Component
What Is a Data Mart?
The Appeal of the Data Mart
The Data Warehouse to the Data Mart Interface
Different Kinds of Data Marts
MOLAP Data Marts
ROLAP Data Marts
Star Join Schema and Data Marts
Processing at the Data Mart
Repetitive Processing
Unpredictable Processing
First Order, Second Order Data
Metadata
Summary
Chapter 9: The Exploration and Data Mining Data Warehouse Components
How the Explorer Handles Large Queries
The Need for an Exploration Warehouse
The Evolution of the Exploration Warehouse
Feeding the Exploration Warehouse
Isolating Explorer Processing
When Is the Exploration Warehouse Needed?
Freezing Exploration Data
Granular Data in the Exploration Warehouse
Loading Data into the Exploration Warehouse
Skunk Works—the Only Way to Fly
Data Marts and the Exploration Warehouse
Exploration Warehouses and Technology
Some Not So Obvious Benefits of the Exploration Warehouse
Summary
Chapter 10: The Alternative Storage Component
Growth of Dormant Data
Managing Dormant Data
Finding the Dividing Line
Where the Activity Monitor Fits
Alternative Storage Technology
Meta Content Data
Cross Media Storage Manager
Alternative Storage and Exploration Processing
Why Use Alternative Storage?
Saving Money
Better Query Performance
Keeping Lowest Level of Granularity
Vendor Implementations
Alternative Storage: Filetek
Cross Media Management: Unitree
Summary
Chapter 11: The Internet/Intranet Components
Issues of Communication
Volume of Data
Speed of Data
Capacity of the Network
Mode of Transport
Cost of Telecommunication Lines
Nature of the Transport
Availability of the Fabric
Who Uses the Communications Facilities?
Summary
Chapter 12: The Metadata Component
What Is Metadata?
The Conflict within Metadata
Is Centralization the Answer?
Is Autonomy the Answer?
Achieving a Balance
Differentiating Sharable and Autonomous Metadata
Defining the System of Record
Using Metadata
Operational versus DSS Usage
Versioning of Metadata
Archiving and Metadata
Capturing Metadata
Meta-Process Information
Uses at the Integration and Transformation Layer
Uses within Applications
Uses from the Data Warehouse to the Data Mart
Summary
Chapter 13: The Decision Support Capabilities
Putting the Role of the Data Warehouse Into Context
The Data Warehouse Adds Depth to Data
The Dimension of History
Easily Accessible Data
Putting the Data Mart into Context
Departmental Data Marts
DSS Application Data Marts
Similarities and Differences between Marts
Pros and Cons of Each Type of Data Mart
Database Designs for Data Marts
Commercial Decision Support Applications
ERP Analytical Applications
e-Business Analytic Applications
Interaction of the Data Warehouse and the Operational Data Store
Examples of Class IV Operational Data Stores
What Is an "Oper-Mart"?
Off-the-Shelf Applications
Guidelines for Choosing the Right Off-the-Shelf Decision Support Application
Summary
Chapter 14: Variations to the Corporate Information Factory
Should We Build the Data Mart or the Data Warehouse First?
Building the Data Mart First
Building the Data Mart in Conjunction with the Data Warehouse
Should We Combine the Data Warehouse and the Operational Data Store?
The Combination of Incompatible Transaction Types
The Forced Combination of Incompatible Workload Types
Summary
Chapter 15: Building the Corporate Information Factory
The Strategic Plan
Applications Environment
Operational Data Store
Data Warehouse and Data Mart
The Strategic Action
Development Lifecycles
Managing Different Organizational Units
Deploying Databases
The General-Purpose DBMS Strategy
Different Hardware Platforms
Displaying Information
Summary
Chapter 16: Managing the Corporate Information Factory
Ongoing Management—Applications
Ongoing Management—The Integration and Transformation Layer
Creating and Maintaining the Interface
Executing the Code
The Production of Metadata
Ongoing Management—The Operational Data Store
Ongoing Management—The Data Warehouse
Ongoing Management—The Data Mart
Ongoing Management—Internet and Intranet
Monitoring the Corporate Information Factory
Security within the Corporate Information Factory
Archival Processing
Application Archiving
Operational Data Store Archiving
Data Warehouse Archiving
Data Mart Archiving
Archiving Medium
Summary
Chapter 17: Multiple Data Warehouses across a Large Enterprise
Define the Need for Integration
Define the Enterprise Framework
Business Domain
Occurrences and Types of Data
Owned Data
Shared Data
Sharing Data across Multiple Data Warehouses
Related Occurrences of Data
Other Relationships
Define the System of Record
Local Data Warehouses
A Variation of a "Pure" Local Data Warehouse
Global Data Warehouses
Types of Warehouses in the Enterprise
A Simple Local Data Warehouse
A Simple Global Data Warehouse
Multiple Unrelated Local Data Warehouses
Relationship between Business Domains
Intersecting Interests
An Extended Global Warehouse
Other Important Issues in Enterprise-Wide Architecture
Summary
Appendix A CIF Architecture Guidelines
Glossary
Recommended Reading
Index
Footnote
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Index
Footnote
Chapter 13: Decision Support Capabilities
1
Inmon, Imhoff, and Battas.
Building the Operational Data Store,
John Wiley & Sons, 1996.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset