CASE STUDY: DATA WAREHOUSING—PART OF THE INFORMATION LOOP AT SCOTIAMCLEOD 77
INTRODUCTION 78
BUSINESS INTELLIGENCE 78
THE RELATIONAL DATABASE MODEL 80
Collections of Information 80
Created with Logical Structures 80
With Logical Ties Among the Information 82
With Built-In Integrity Constraints 82
DATABASE MANAGEMENT SYSTEM TOOLS 83
TEAM WORK: Primary Keys, Foreign Keys, and Integrity Constraints 84
Data Definition Subsystem 85
Data Manipulation Subsystem 86
INDUSTRY PERSPECTIVE: Company Pushes to Put More Canadian Content on the Web 87
THE GLOBAL PERSPECTIVE: Floating Databases Aboard Royal Caribbean Cruise Ships 91
Application Generation Subsystem 91
ON YOUR OWN: DBMS Support for OLTP, OLAP, Information Management 92
Data Administration Subsystem 92
INDUSTRY PERSPECTIVE: Should You Have Access to Medical Malpractice
Databases? 93
DATA WAREHOUSES AND DATA MINING 94
What Is a Data Warehouse? 94
What Are Data Mining Tools? 96
THE GLOBAL PERSPECTIVE: Cross-Selling Insurance Products in Australia 97
Data Marts—Smaller Data Warehouses 97
Important Considerations in Using a Data Warehouse 98
INDUSTRY PERSPECTIVE: Future Shop Implements Data Warehousing with the
Help of Burntsand Inc. 99
TEAM WORK: How Up-to-Date Should Data
Warehouse Information Be? 100
MANAGING THE INFORMATION RESOURCE IN AN ORGANIZATION 100
INDUSTRY PERSPECTIVE: Do You Want to Be a CIO? 101
Who Should Oversee the Organization’s Information? 101
ON YOUR OWN: CRUD—Defining Information Ownership 102
How Will Changes in Technology Affect Organizing and Managing Information? 102
INDUSTRY PERSPECTIVE: Do Movies Affect Your View of Ethics? 103
Is Information Ownership a Consideration? 103
What Are the Ethics Involved in Managing and Organizing Information? 103
CLOSING CASE STUDIES 105
REAL HOT ELECTRONIC COMMERCE: Searching Online Databases and Information Repositories 111