Corporate Information Factory,9780471399612

Corporate Information Factory

by ; ;
Edition: 2nd
ISBN13: 9780471399612
ISBN10: 0471399612
Format: Paperback
Pub. Date: 2001-01-01
Publisher(s): Wiley
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $72.80

Buy New

Arriving Soon. Will ship when available.
$69.33
Add to Cart

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$62.40
$62.40
Add to Cart

Used Textbook

We're Sorry
Sold Out

Buy from our Marketplace starting at $13.74

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

The father of the data warehouse incorporates the latest technologies into his blueprint for integrated decision support systemsHaving invented the corporate information factory (CIF) to help IT and database managers cut through the jungle of information technologies out there, bestselling author Bill Inmon again teams up with experts Claudia Imhoff and Ryan Sousa to show you how to integrate all key components of the modern information system architecture in a way that meets your evolving business needs.

Author Biography

W. H. INMON, the acknowledged "father of data warehousing," is a partner in www.billinmon.com, a Web site for the corporate information factory and modern systems architecture. He has written over 40 books on databases, database management, and data warehouse technology, including the recently published Exploration Warehousing (Wiley). Inmon is also a frequent speaker at leading industry conferences and contributes to DM Review.

Table of Contents

Preface xiii
Acknowledgments xix
Creating an Information Ecosystem
1(10)
Information Ecosystem Briefly Defined
2(1)
Shifting Business Landscape
3(2)
Consumer Demand
3(1)
Competition and Complexity
4(1)
Operating Efficiencies
4(1)
Responding to Change
5(2)
Corporate Information Factory
7(1)
People and Processes
8(1)
Summary
9(2)
Introducing the Corporate Information Factory
11(38)
Data in the Corporate Information Factory
12(13)
External Data
14(2)
Reference Data
16(3)
Historical Data
19(2)
The Decision-Support System to Operational Feedback Loop
21(2)
The Flow of Data
23(2)
Variations to the Corporate Information Factory
25(1)
Operational Processing and DSS Processing
26(2)
Reporting in the Corporate Information Factory
28(1)
Corporate Information Factory Users
28(7)
Applications Users
28(2)
Decision-Support System/ Informational Users
30(5)
Types of DSS Usage in the Corporate Information Factory Environment
35(1)
Centralized or Distributed?
35(4)
Data Modeling and the Corporate Information Factory
39(2)
Migrating to the Corporate Information Factory
41(3)
Structuring Data in the Corporate Information Factory
44(2)
Summary
46(3)
The External World Component
49(6)
Transaction Producers
50(1)
A Taxonomy of Transactions
50(1)
Consumers of Information
51(1)
Who Are the Participants?
51(1)
Summary
52(3)
The Applications Component
55(8)
Dated Applications
56(1)
Unintegrated Applications
56(1)
Applications' Response Times
57(1)
Migrating from an Unintegrated State
57(1)
External Data, Metadata, and Applications
58(1)
Feeds into and out of the Applications Environment
59(2)
Summary
61(2)
The Integration and Transformation Layer Component
63(16)
What Is the Integration and Transformation Layer?
64(1)
An Unstable Interface
64(1)
Feeds into and out of the Interface
65(2)
Complex Integration and Transformation Interface
67(1)
The Role of the Data Model
68(1)
Creating Metadata
69(1)
Automatic Creation of I & T Code
70(1)
Processing in the Integration and Transformation Interface
70(4)
Performing Key Transformations
70(2)
Creating Profile/Aggregate Records
72(1)
Encoding Structures
72(1)
Simple Reformatting
72(1)
Mathematical Conversion
73(1)
Resequencing Data
73(1)
Assigning Default Values
74(1)
Handling Multiple Data Sources
74(1)
Log Tapes As a Source
74(1)
Changing Platforms
75(1)
Who Is in Charge?
75(1)
Summary
76(3)
The Operational Data Store Component
79(14)
What Is an Operational Data Store?
79(2)
Volatility
80(1)
Current-Valued
81(1)
Detailed Data
81(1)
Feeds into and out of the Operational Data Store
81(2)
The Integration and Transformation Layer Feed
81(2)
Different Classes of the Operational Data Store
83(2)
Class I Operational Data Store
83(1)
Class II Operational Data Store
84(1)
Class III Operational Data Store
84(1)
Class IV Operational Data Store
84(1)
Determining the Class
84(1)
Dynamic Summary Data
85(1)
Static Summary Data
86(1)
The Operational Data Store Workload
87(2)
Load Processing
87(1)
Update Processing
88(1)
Access Processing
88(1)
DSS Analysis Processing
88(1)
Different Processing Windows
89(1)
What Is a Homogeneous Workload?
89(1)
External Data in the Operational Data Store
90(1)
Summary
90(3)
The Data Warehouse Component
93(16)
What Is the Data Warehouse?
93(5)
Subject Orientation
94(1)
Integration
95(1)
Time Variancy
95(1)
Historical Data
96(1)
Nonvolatility
96(1)
Containment of Summary and Detailed Data
97(1)
Data Warehouse Administration
98(1)
The Data Warehouse Drawn to Scale
98(1)
Feeds into and out of the Data Warehouse
98(4)
The Operational Data Store Feed
99(1)
The Integration and Transformation Layer Feed
99(2)
Feeds into the Data Mart
101(1)
Alternative Storage Feeds
101(1)
Exploration Warehouse Feeds
102(1)
Data in the Data Warehouse
102(1)
Processing Data in the Warehouse
103(2)
Managing Technological Challenges
105(2)
Archiving Data out of the Data Warehouse
105(2)
Summary
107(2)
The Data Mart Component
109(14)
What Is a Data Mart?
110(2)
The Appeal of the Data Mart
110(2)
The Data Warehouse to the Data Mart Interface
112(2)
Different Kinds of Data Marts
114(1)
MOLAP Data Marts
114(1)
ROLAP Data Marts
114(1)
Star Join Schema and Data Marts
115(1)
Processing at the Data Mart
116(2)
Repetitive Processing
116(1)
Unpredictable Processing
116(2)
First Order, Second Order Data
118(1)
Metadata
119(1)
Summary
120(3)
The Exploration and Data Mining Data Warehouse Components
123(16)
How the Explorer Handles Large Queries
124(1)
The Need for an Exploration Warehouse
124(9)
The Evolution of the Exploration Warehouse
125(2)
Feeding the Exploration Warehouse
127(2)
Isolating Explorer Processing
129(1)
When Is the Exploration Warehouse Needed?
129(2)
Freezing Exploration Data
131(1)
Granular Data in the Exploration Warehouse
132(1)
Loading Data into the Exploration Warehouse
133(2)
Skunk Works---the Only Way to Fly
134(1)
Data Marts and the Exploration Warehouse
135(1)
Exploration Warehouses and Technology
135(1)
Some Not So Obvious Benefits of the Exploration Warehouse
136(1)
Summary
137(2)
The Alternative Storage Component
139(18)
Growth of Dormant Data
140(4)
Managing Dormant Data
141(1)
Finding the Dividing Line
142(1)
Where the Activity Monitor Fits
143(1)
Alternative Storage Technology
144(3)
Meta Content Data
145(1)
Cross Media Storage Manager
145(2)
Alternative Storage and Exploration Processing
147(1)
Why Use Alternative Storage?
148(3)
Saving Money
148(1)
Better Query Performance
149(1)
Keeping Lowest Level of Granularity
150(1)
Vendor Implementations
151(4)
Alternative Storage: Filetek
151(4)
Cross Media Management: Unitree
155(1)
Summary
155(2)
The Internet/Intranet Components
157(12)
Issues of Communication
158(4)
Volume of Data
159(1)
Speed of Data
159(1)
Capacity of the Network
160(1)
Mode of Transport
160(1)
Cost of Telecommunication Lines
161(1)
Nature of the Transport
161(1)
Availability of the Fabric
162(1)
Who Uses the Communications Facilities?
162(5)
Summary
167(2)
The Metadata Component
169(20)
What Is Metadata?
169(1)
The Conflict within Metadata
170(5)
Is Centralization the Answer?
171(1)
Is Autonomy the Answer?
172(1)
Achieving a Balance
173(2)
Differentiating Sharable and Autonomous Metadata
175(1)
Defining the System of Record
175(2)
Using Metadata
177(4)
Operational versus DSS Usage
179(2)
Versioning of Metadata
181(1)
Archiving and Metadata
182(1)
Capturing Metadata
183(2)
Meta-Process Information
185(1)
Uses at the Integration and Transformation Layer
186(1)
Uses within Applications
186(1)
Uses from the Data Warehouse to the Data Mart
186(1)
Summary
186(3)
The Decision Support Capabilities
189(24)
Putting the Role of the Data Warehouse Into Context
190(5)
The Data Warehouse Adds Depth to Data
191(2)
The Dimension of History
193(1)
Easily Accessible Data
194(1)
Putting the Data Mart into Context
195(4)
Departmental Data Marts
195(1)
DSS Application Data Marts
196(1)
Similarities and Differences between Marts
196(1)
Pros and Cons of Each Type of Data Mart
197(2)
Database Designs for Data Marts
199(3)
Commercial Decision Support Applications
202(4)
ERP Analytical Applications
202(3)
e-Business Analytic Applications
205(1)
Interaction of the Data Warehouse and the Operational Data Store
206(2)
Examples of Class IV Operational Data Stores
206(2)
What Is an ``Oper-Mart''?
208(1)
Off-the-Shelf Applications
209(2)
Guidelines for Choosing the Right Off-the-Shelf Decision Support Application
210(1)
Summary
211(2)
Variations to the Corporate Information Factory
213(20)
Should We Build the Data Mart or the Data Warehouse First?
213(9)
Building the Data Mart First
215(1)
Building the Data Mart in Conjunction with the Data Warehouse
215(7)
Should We Combine the Data Warehouse and the Operational Data Store?
222(10)
The Combination of Incompatible Transaction Types
224(2)
The Forced Combination of Incompatible Workload Types
226(6)
Summary
232(1)
Building the Corporate Information Factory
233(18)
The Strategic Plan
234(2)
Applications Environment
235(1)
Operational Data Store
236(1)
Data Warehouse and Data Mart
236(1)
The Strategic Action
236(1)
Development Lifecycles
237(2)
Managing Different Organizational Units
239(3)
Deploying Databases
242(3)
The General-Purpose DBMS Strategy
242(3)
Different Hardware Platforms
245(3)
Displaying Information
248(1)
Summary
248(3)
Managing the Corporate Information Factory
251(16)
Ongoing Management---Applications
253(1)
Ongoing Management---The Integration and Transformation Layer
254(2)
Creating and Maintaining the Interface
254(1)
Executing the Code
255(1)
The Production of Metadata
255(1)
Ongoing Management---The Operational Data Store
256(1)
Ongoing Management---The Data Warehouse
257(1)
Ongoing Management---The Data Mart
257(1)
Ongoing Management---Internet and Intranet
258(1)
Monitoring the Corporate Information Factory
258(2)
Security within the Corporate Information Factory
260(3)
Archival Processing
263(3)
Application Archiving
263(2)
Operational Data Store Archiving
265(1)
Data Warehouse Archiving
265(1)
Data Mart Archiving
265(1)
Archiving Medium
265(1)
Summary
266(1)
Multiple Data Warehouses across a Large Enterprise
267(24)
Define the Need for Integration
268(1)
Define the Enterprise Framework
269(8)
Business Domain
269(1)
Occurrences and Types of Data
270(1)
Owned Data
271(2)
Shared Data
273(1)
Sharing Data across Multiple Data Warehouses
274(1)
Related Occurrences of Data
275(1)
Other Relationships
276(1)
Define the System of Record
277(2)
Local Data Warehouses
279(2)
A Variation of a ``Pure'' Local Data Warehouse
280(1)
Global Data Warehouses
281(1)
Types of Warehouses in the Enterprise
282(6)
A Simple Local Data Warehouse
282(1)
A Simple Global Data Warehouse
282(3)
Multiple Unrelated Local Data Warehouses
285(1)
Relationship between Business Domains
286(1)
Intersecting Interests
287(1)
An Extended Global Warehouse
288(1)
Other Important Issues in Enterprise-Wide Architecture
288(1)
Summary
289(2)
Appendix A CIF Architecture Guidelines 291(44)
Glossary 335(30)
Recommended Reading 365(12)
Index 377

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.