book

Corporate Information Factory

Name: Corporate Information Factory
ISBN: 9780471399612

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

January 2001

Intermediate to advanced

400 pages

9h 6m

English

Wiley

Read now

Unlock full access

Cover Page
Title Page
Copyright Page
Contents
Preface
Acknowledgments
Chapter 1: Creating an Information Ecosystem
Information Ecosystem Briefly DefinedShifting Business LandscapeConsumer DemandCompetition and ComplexityOperating EfficienciesResponding to ChangeCorporate Information FactoryPeople and ProcessesSummary
Chapter 2: Introducing the Corporate Information Factory
Data in the Corporate Information FactoryExternal DataReference DataHistorical DataThe Decision-Support System to Operational Feedback LoopThe Flow of DataVariations to the Corporate Information FactoryOperational Processing and DSS ProcessingReporting in the Corporate Information FactoryCorporate Information Factory UsersApplications UsersDecision-Support System/Informational UsersTypes of DSS Usage in the Corporate Information Factory EnvironmentCentralized or Distributed?Data Modeling and the Corporate Information FactoryMigrating to the Corporate Information FactoryStructuring Data in the Corporate Information FactorySummary
Chapter 3: The External World Component
Transaction ProducersA Taxonomy of TransactionsConsumers of InformationWho Are the Participants?Summary
Chapter 4: The Applications Component
Dated ApplicationsUnintegrated ApplicationsApplications’ Response TimesMigrating from an Unintegrated StateExternal Data, Metadata, and ApplicationsFeeds into and out of the Applications EnvironmentSummary

Chapter 5: The Integration and Transformation Layer Component
What Is the Integration and Transformation Layer?An Unstable InterfaceFeeds into and out of the InterfaceComplex Integration and Transformation InterfaceThe Role of the Data ModelCreating MetadataAutomatic Creation of I & T CodeProcessing in the Integration and Transformation InterfacePerforming Key TransformationsCreating Profile/Aggregate RecordsEncoding StructuresSimple ReformattingMathematical ConversionResequencing DataAssigning Default ValuesHandling Multiple Data SourcesLog Tapes As a SourceChanging PlatformsWho Is in Charge?Summary
Chapter 6: The Operational Data Store Component
What Is an Operational Data Store?VolatilityCurrent-ValuedDetailed DataFeeds into and out of the Operational Data StoreThe Integration and Transformation Layer FeedDifferent Classes of the Operational Data StoreClass I Operational Data StoreClass II Operational Data StoreClass III Operational Data StoreClass IV Operational Data StoreDetermining the ClassDynamic Summary DataStatic Summary DataThe Operational Data Store WorkloadLoad ProcessingUpdate ProcessingAccess ProcessingDSS Analysis ProcessingDifferent Processing WindowsWhat Is a Homogeneous Workload?External Data in the Operational Data StoreSummary
Chapter 7: The Data Warehouse Component
What Is the Data Warehouse?Subject OrientationIntegrationTime VariancyHistorical DataNonvolatilityContainment of Summary and Detailed DataData Warehouse AdministrationThe Data Warehouse Drawn to ScaleFeeds into and out of the Data WarehouseThe Operational Data Store FeedThe Integration and Transformation Layer FeedFeeds into the Data MartAlternative Storage FeedsExploration Warehouse FeedsData in the Data WarehouseProcessing Data in the WarehouseManaging Technological ChallengesArchiving Data out of the Data WarehouseSummary
Chapter 8: The Data Mart Component
What Is a Data Mart?The Appeal of the Data MartThe Data Warehouse to the Data Mart InterfaceDifferent Kinds of Data MartsMOLAP Data MartsROLAP Data MartsStar Join Schema and Data MartsProcessing at the Data MartRepetitive ProcessingUnpredictable ProcessingFirst Order, Second Order DataMetadataSummary
Chapter 9: The Exploration and Data Mining Data Warehouse Components
How the Explorer Handles Large QueriesThe Need for an Exploration WarehouseThe Evolution of the Exploration WarehouseFeeding the Exploration WarehouseIsolating Explorer ProcessingWhen Is the Exploration Warehouse Needed?Freezing Exploration DataGranular Data in the Exploration WarehouseLoading Data into the Exploration WarehouseSkunk Works—the Only Way to FlyData Marts and the Exploration WarehouseExploration Warehouses and TechnologySome Not So Obvious Benefits of the Exploration WarehouseSummary
Chapter 10: The Alternative Storage Component
Growth of Dormant DataManaging Dormant DataFinding the Dividing LineWhere the Activity Monitor FitsAlternative Storage TechnologyMeta Content DataCross Media Storage ManagerAlternative Storage and Exploration ProcessingWhy Use Alternative Storage?Saving MoneyBetter Query PerformanceKeeping Lowest Level of GranularityVendor ImplementationsAlternative Storage: FiletekCross Media Management: UnitreeSummary
Chapter 11: The Internet/Intranet Components
Issues of CommunicationVolume of DataSpeed of DataCapacity of the NetworkMode of TransportCost of Telecommunication LinesNature of the TransportAvailability of the FabricWho Uses the Communications Facilities?Summary
Chapter 12: The Metadata Component
What Is Metadata?The Conflict within MetadataIs Centralization the Answer?Is Autonomy the Answer?Achieving a BalanceDifferentiating Sharable and Autonomous MetadataDefining the System of RecordUsing MetadataOperational versus DSS UsageVersioning of MetadataArchiving and MetadataCapturing MetadataMeta-Process InformationUses at the Integration and Transformation LayerUses within ApplicationsUses from the Data Warehouse to the Data MartSummary
Chapter 13: The Decision Support Capabilities
Putting the Role of the Data Warehouse Into ContextThe Data Warehouse Adds Depth to DataThe Dimension of HistoryEasily Accessible DataPutting the Data Mart into ContextDepartmental Data MartsDSS Application Data MartsSimilarities and Differences between MartsPros and Cons of Each Type of Data MartDatabase Designs for Data MartsCommercial Decision Support ApplicationsERP Analytical Applicationse-Business Analytic ApplicationsInteraction of the Data Warehouse and the Operational Data StoreExamples of Class IV Operational Data StoresWhat Is an "Oper-Mart"?Off-the-Shelf ApplicationsGuidelines for Choosing the Right Off-the-Shelf Decision Support ApplicationSummary
Chapter 14: Variations to the Corporate Information Factory
Should We Build the Data Mart or the Data Warehouse First?Building the Data Mart FirstBuilding the Data Mart in Conjunction with the Data WarehouseShould We Combine the Data Warehouse and the Operational Data Store?The Combination of Incompatible Transaction TypesThe Forced Combination of Incompatible Workload TypesSummary
Chapter 15: Building the Corporate Information Factory
The Strategic PlanApplications EnvironmentOperational Data StoreData Warehouse and Data MartThe Strategic ActionDevelopment LifecyclesManaging Different Organizational UnitsDeploying DatabasesThe General-Purpose DBMS StrategyDifferent Hardware PlatformsDisplaying InformationSummary
Chapter 16: Managing the Corporate Information Factory
Ongoing Management—ApplicationsOngoing Management—The Integration and Transformation LayerCreating and Maintaining the InterfaceExecuting the CodeThe Production of MetadataOngoing Management—The Operational Data StoreOngoing Management—The Data WarehouseOngoing Management—The Data MartOngoing Management—Internet and IntranetMonitoring the Corporate Information FactorySecurity within the Corporate Information FactoryArchival ProcessingApplication ArchivingOperational Data Store ArchivingData Warehouse ArchivingData Mart ArchivingArchiving MediumSummary
Chapter 17: Multiple Data Warehouses across a Large Enterprise
Define the Need for IntegrationDefine the Enterprise FrameworkBusiness DomainOccurrences and Types of DataOwned DataShared DataSharing Data across Multiple Data WarehousesRelated Occurrences of DataOther RelationshipsDefine the System of RecordLocal Data WarehousesA Variation of a "Pure" Local Data WarehouseGlobal Data WarehousesTypes of Warehouses in the EnterpriseA Simple Local Data WarehouseA Simple Global Data WarehouseMultiple Unrelated Local Data WarehousesRelationship between Business DomainsIntersecting InterestsAn Extended Global WarehouseOther Important Issues in Enterprise-Wide ArchitectureSummary
Appendix A CIF Architecture Guidelines
Glossary
Recommended Reading
Index
Footnote

Overview

The "father of data warehousing" incorporates the latest technologies into his blueprint for integrated decision support systems

Today's corporate IT and data warehouse managers are required to make a small army of technologies work together to ensure fast and accurate information for business managers. Bill Inmon created the Corporate Information Factory to solve the needs of these managers. Since the First Edition, the design of the factory has grown and changed dramatically. This Second Edition, revised and expanded by 40% with five new chapters, incorporates these changes. This step-by-step guide will enable readers to connect their legacy systems with the data warehouse and deal with a host of new and changing technologies, including Web access mechanisms, e-commerce systems, ERP (Enterprise Resource Planning) systems. The book also looks closely at exploration and data mining servers for analyzing customer behavior and departmental data marts for finance, sales, and marketing.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780471399612Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills