Corporate Information Factory

, by Inmon, W. H.; Imhoff, Claudia; Sousa, Ryan

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780471399612 | 0471399612
Cover: Paperback
Copyright: 1/1/2001

Buy New

Print on Demand: 2-4 Weeks. This item cannot be cancelled or returned.

$68.29

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.

Preface

xiii

Acknowledgments

xix

Creating an Information Ecosystem

(10)

Information Ecosystem Briefly Defined

(1)

Shifting Business Landscape

(2)

Consumer Demand

(1)

Competition and Complexity

(1)

Operating Efficiencies

(1)

Responding to Change

(2)

Corporate Information Factory

(1)

People and Processes

(1)

Summary

(2)

Introducing the Corporate Information Factory

(38)

Data in the Corporate Information Factory

(13)

External Data

(2)

Reference Data

(3)

Historical Data

(2)

The Decision-Support System to Operational Feedback Loop

(2)

The Flow of Data

(2)

Variations to the Corporate Information Factory

(1)

Operational Processing and DSS Processing

(2)

Reporting in the Corporate Information Factory

(1)

Corporate Information Factory Users

(7)

Applications Users

(2)

Decision-Support System/ Informational Users

(5)

Types of DSS Usage in the Corporate Information Factory Environment

(1)

Centralized or Distributed?

(4)

Data Modeling and the Corporate Information Factory

(2)

Migrating to the Corporate Information Factory

(3)

Structuring Data in the Corporate Information Factory

(2)

Summary

(3)

The External World Component

(6)

Transaction Producers

(1)

A Taxonomy of Transactions

(1)

Consumers of Information

(1)

Who Are the Participants?

(1)

Summary

(3)

The Applications Component

(8)

Dated Applications

(1)

Unintegrated Applications

(1)

Applications' Response Times

(1)

Migrating from an Unintegrated State

(1)

External Data, Metadata, and Applications

(1)

Feeds into and out of the Applications Environment

(2)

Summary

(2)

The Integration and Transformation Layer Component

(16)

What Is the Integration and Transformation Layer?

(1)

An Unstable Interface

(1)

Feeds into and out of the Interface

(2)

Complex Integration and Transformation Interface

(1)

The Role of the Data Model

(1)

Creating Metadata

(1)

Automatic Creation of I & T Code

(1)

Processing in the Integration and Transformation Interface

(4)

Performing Key Transformations

(2)

Creating Profile/Aggregate Records

(1)

Encoding Structures

(1)

Simple Reformatting

(1)

Mathematical Conversion

(1)

Resequencing Data

(1)

Assigning Default Values

(1)

Handling Multiple Data Sources

(1)

Log Tapes As a Source

(1)

Changing Platforms

(1)

Who Is in Charge?

(1)

Summary

(3)

The Operational Data Store Component

(14)

What Is an Operational Data Store?

(2)

Volatility

(1)

Current-Valued

(1)

Detailed Data

(1)

Feeds into and out of the Operational Data Store

(2)

The Integration and Transformation Layer Feed

(2)

Different Classes of the Operational Data Store

(2)

Class I Operational Data Store

(1)

Class II Operational Data Store

(1)

Class III Operational Data Store

(1)

Class IV Operational Data Store

(1)

Determining the Class

(1)

Dynamic Summary Data

(1)

Static Summary Data

(1)

The Operational Data Store Workload

(2)

Load Processing

(1)

Update Processing

(1)

Access Processing

(1)

DSS Analysis Processing

(1)

Different Processing Windows

(1)

What Is a Homogeneous Workload?

(1)

External Data in the Operational Data Store

(1)

Summary

(3)

The Data Warehouse Component

(16)

What Is the Data Warehouse?

(5)

Subject Orientation

(1)

Integration

(1)

Time Variancy

(1)

Historical Data

(1)

Nonvolatility

(1)

Containment of Summary and Detailed Data

(1)

Data Warehouse Administration

(1)

The Data Warehouse Drawn to Scale

(1)

Feeds into and out of the Data Warehouse

(4)

The Operational Data Store Feed

(1)

The Integration and Transformation Layer Feed

(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)

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Corporate Information Factory

Summary

Author Biography

Table of Contents

Supplemental Materials