Data Warehousing - Exam III

a pool of data produced to support decision making  - a repository of current and historical data

a physical repository where relational data are specially organized to provide enterprise-wide, cleansed data in a standardized format

a collections of integrated, subject-oriented databases designed to support DSS functions, where each unit of data is non-volatile (doesn't change) and relevant to some moment in time

a smaller subset of a data warehouse that is focused on a particular subject or department typically consisting of a single subject area

a subset that is created directly from a data warehouse - ensures that the end user is viewing the same version of the data that is accessed by all other data warehouse users

a small data warehouse designed for a strategic business unit or a department - an alternative to high cost data warehouses

three main types of data warehouses

provides a fairly recent form of customer information - an interim staging area for a data warehouse contaning only very recent information

a data mart created when operational data needs to be analyzed multidimentionally

a large-scale data warehouse that is used across the enterprise for decision support - to provide data for many types of DSS

describe the structure of and some meaning of the data

three types of metadata

three major processes in data integration

comprises three major processes: data access, data federation, & change capture

a technology that provides a vehicle for pushing data from source systems into a data warehouse (shares applications - not data as its focus)

an evolving tool space that promises real-time data integration from a variety of sources

process that consumes 70% of time in a data-centric process and consists of reading data from one or more database, converting the extracted data and putting it into the data warehouse

systems that monitor the data flowing into the warehouse and inform all key people who have a need to know as soon as a critical event occurs

benefits to an organization that can be expressed in monetary terms

type of data warehouse used for strategic decisions only and uses highly restrictive reporting to confirm or check existing processes & patterns

type of warehouse used for both strategic & tactical decisions - allowing  a high number of users - and allows for flexible ac hoc reporting