Another Day’s worth of MIS “Terms” CPU Memory (RAM, Disk) File Database Database Management System

1. Another Day’s worth of MIS “Terms” CPU Memory (RAM, Disk) File Database Database Management System Integrated Database (vs. non integrated) Data Warehouse Extraction, Translation, Cleaning Data Mart Data Access Tools Data Cube Multi-Dimensional Data Cubes Infrastructure (hardware, software, data) Operating System Application System ERP System (Enterprise System)

3. Application Programs Payroll Order Entry Inventory Mgmt Data Customer Data Inventory Data, Etc. B U S Central Processing Unit Memory (RAM) Operating System* Other Utilities Database Management Syst Telecomms Application Programs (Currently Running) Data (Being Used in Currently Running Programs) Input (keyboard, etc.) Communications Controllers Printers

4. IT (Application) Infrastructure Exec Support Decision Support Transaction Processing Telecomms HW/SW IT Infrastructure (common use) Data Inventory Operating Systems/DBMS, etc. Computer Hardware

5. Data Bill of Materials Product/Part Inventories Vendors Economic Order Quants Data Bill of Materials Machine Usage Labor Charges Cost Allocations Data Forecast Demand Machine capacities Bill of Materials Routings Data Prospects Quotes Sales Forecasts Data Customers Products/Configurations Employee Data Cost Accounting Application Programs Production Scheduling Application Programs Supply Chain Management Application Systems and Data Sales Force Automation Application Programs Order Entry Application Programs Materials Management Application Programs

6. Application Program Payroll Data Employee Data Time Clock Data Application Program Order Entry Data Order Data Customer Data Employee Data Application Program Cost Accounting Data Bill of Materials Machine Costs Employee Costs Production Stats Application Program ESOP Tracking Data Employee ESOP Data Employee History Application Program Production Scheduling Data Bill of Materials Machine Capacities Employee Data Order Data LA Division Systems and Data

7. Application Program Payroll Data Employee Data Time Clock Data Application Program Order Entry Data Order Data Customer Data Employee Data Application Program Cost Accounting Data Bill of Materials Machine Costs Employee Costs Production Stats Application Program ESOP Tracking Data Employee ESOP Data Employee History Application Program Production Scheduling Data Bill of Materials Machine Capacities Employee Data Order Data San Jose Division Systems and Data

8. Application Programs Payroll Order Entry Inventory Mgmt ESOP Accounts Payable Production Scheduling Data Customer Data Inventory Data, Order Data Employee Data Accounting Data If the whole organization used a single integrated database for all its data.

9. Application Program Payroll Data Employee Data Time Clock Data Application Program Order Entry Data Order Data Customer Data Employee Data Data Order Data Customer Data Employee Data Product Data Application Program Cost Accounting Data Bill of Materials Machine Costs Employee Costs Extract Translate and Clean Application Program ESOP Tracking Data Employee ESOP Data Employee History Application Program Production Scheduling Data Bill of Materials Machine Capacities Employee Data Order Data Data Access Tools Data Warehouse

10. Figure 3: The VISION Data Warehouse Architecture

11. Data Customers/Prospects Orders/Quotes Product/Part Inventories Bill of Materials / Routings Machine capacities Production Schedules Vendors Economic Order Quants, Etc. ERP Supply Chain Management Production Scheduling Application Programs Cost Accounting Application Programs Materials Management Application Programs Order Entry Application Programs Sales Force Automation Application Programs