A statistically-significant subset selected and analyzed to estimate the characteristics of a larger group or population; a set of individuals within an organization assessed to provide information on the preferences, opinions, attitudes, and practices of the group they represent.


The ability to increase volumes of data and numbers of users to the data warehouse solution. This is a critical capability for the data warehouse architecture and technical architecture.


An information model implemented in a database. A schema may be a logical schema, which will define, for example, tables, columns, and constraints, but which may not include any optimization. It may be a physical schema that includes optimization, for example, table clustering.


The boundaries of a project expressed in some combination of geography, organization, applications and/or business functions.

Scope Change

A change to project scope. A scope change requires an adjustment to the project work plan, and nearly always impacts project cost, schedule or quality.

Scope Creep

The common phenomenon where additional requirements are added after a project has started without reconsidering the resourcing or timescale of the project. Scope creep arises from the misapprehension that such small additions will not affect the project schedule.

Scoping Workshop

A workshop, usually attended by the project sponsor and developers, with the objective of defining the boundaries of the scope for an intended project and prioritizing requirements within the scope.

Security Profile

A list of role-based security specifications.

Service Level Agreement (SLA)

A binding contract which formally specifies end-user expectation about the solution and tolerances. It is a collection of service level requirements that have been negotiated and mutually agreed upon by the information providers and the information consumers. The SLA has three attributes: STRUCTURE, PRECISION, AND FEASIBILITY. This agreement establishes expectations and impacts the design of the components of the data warehouse solution.

Sign-off Agreement

with a client of the successful completion of a project, project phase, or deliverable.


The attribute or capability of a database to significantly expand the number of records that it can manage. It also refers to hardware systems and their ability to be expanded or upgraded to increase their processing speed and handle larger volumes of data.

Snowflake Schema:

A common form of dimensional model. In a snowflake schema, different hierarchies in a dimension can be extended into their own dimensional tables. Therefore, a dimension can have more than a single dimension table.

Source Module

A physical program unit. An application system’s repository of source code is controlled at the source module level.

Source System

The internal or external computer system which provides the source data for the warehouse.


A person, group, or business unit that has a share or an interest in a particular activity or set of activities.


A set of rules for ensuring quality. Usually standards are defined for products, deliverables or deliverable components and processes.

Success Criteria

The metrics and measurements established to determine whether the data warehouse solution has satisfied its objectives and met the requirements.

Subject Area

An area of major interest or importance to the enterprise. It is centered on a major resource, product, or activity. The subject areas provide reference information when conducting detailed requirements gathering.

Structured Query Language (SQL)

The ANSI internationally accepted standard for relational database systems, covering not only query but also data definition, manipulation, security, and some aspects of referential and entity integrity.

Summary Data

The data that has been aggregated or transformed from the atomic level data. Summary data may reside in all of the database objects of the data warehouse.

Star Schema:

A common form of dimensional model. In a star schema, each dimension is represented by a single dimension table.


The process by which the data in two or more separate database are synchronized so that the records contain the same information. If the fields and records are updated in one database the same fields and records are updated in the other


1. A name assigned to a table or view that may then be used more conveniently for reference.

2. An alternate name for an entity.

System Test

A project activity that tests an application system over its complete lifecycle, using scripts and associating scenario test specifications into chronological sequences.