The standard data structuring and access language used by relational databases. Staging Area Buffer area used to accumulate data from multiple data sources prior to processing the data with an ETL tool. Staging Data Data packaged for delivery to data warehouse or data mart. A relational database schema for representing multidimensional data. The data is stored in a central fact table, with one or more tables holding information on each dimension.
Dimensions have levels, and all levels are usually shown as columns in each dimension table.
Static Capture A method of capturing a time-independent or static view of all or a subset of the data in a source data set. An executive group, drawn from all parts of the business, responsible for prioritizing projects in the data warehouse. Stovepipe Data Mart Also called an independent data mart, is not integrated with central metadata. There are no common business rules, semantics, and definitions. Stovepipe data marts support the needs of individual business units, but do not support an enterprise data warehousing strategy.