ISDS 2001 : ISDS Test 3 Study Guide
15 Mar 2019
School
Department
Course
Professor
Document Summary
Data warehouse: a pool of data produced to support decision making, a repository of current and historical data of potential interest to managers throughout an organization. Four major characteristics of data warehousing and what each means: subject oriented. Data are organized by topics, such as sales, products, customers, etc. Best for providing a more comprehensive view of organization. Not only how a business is operating, but why! Data from different sources are stored in a consistent format. Must deal with naming conflicts and discrepancies among units of measure: time variant (time series) Provides data at various points in time: nonvolatile. Users cannot change the data once entered into the data warehouse. Additional characteristics of data warehousing: web based. Designed to provide an efficient computing environment for web-based applications: relational/multidimensional structure, client/server. Used client/server architecture to provide easy access to end-users: real time. Provides real-time data access and analysis capabilities: metadata.
