Data Warehouse & Business Intelligence Glossary (C)

C

Central Repository

Location of a collection of documentation, customizations, modifications, or enhancements designed to alleviate the recreation of successfully completed work.

Change

A deviation from a currently established baseline.

Change Management

1. The complete set of processes employed on a project to ensure that changes are implemented in a visible, controlled and orderly fashion.

2. The activity, or set of activities, undertaken to govern systematically the effects of organizational change.

Change Request

1. A request for a change to the required behavior of a system, usually from a user as a result of reviewing current behavior.

2. The mechanism by which a change is requested, investigated, resolved and approved;

Client/Server

A type of technical architecture that links many personal computers or workstations (clients) to
one or more large processors (servers). Clients generally manage the user interface, possibly with some local data. Servers usually manage multiple-access databases, including ensuring data integrity and other invariants.

Cluster

A means of storing data together from multiple tables, when the data in those tables contains common information accessed concurrently.

Column

A means of implementing an item of data within a table. It can be in character, date, or number format, and be optional or mandatory.

Computer-Aided Systems Engineering (CASE)

The combination of graphical, dictionary, generator, project management, and other software tools to assist computer development staff engineer and maintain high-quality systems, within the framework of a structured method.

Computer Network

An interconnected group of computers.

Critical Success Factor (CSF)

A business event, dependency, product, or other factor that, if not attained, would seriously impair the likelihood of achieving a business objective.

Custom Code

Coding added to a packaged application or module generated by a CASE tool to implement functionality that the application or generator has not provided.

Catalog

A component of a data dictionary that describes and organizes the various aspects of a database such as its folders, dimensions, measures, prompts, functions, queries and other database objects. It is used to create queries, reports, analyses and cubes.

Cross Tab

A type of multi-dimensional report that displays values or measures in cells created by the intersection of two or more dimensions in a table format.

Conformed Dimension

A dimension that has exactly the same meaning and content when being referred from different fact tables.

OR

A dimension that is shared between tow or more fact tables. This helps in integration of data from different fact tables at query time. This is the foundational principle that enables the longevity of a data warehouse environment.

Conformed Fact

 

A fact or measure whose definition is consistent across fact tables and Data Marts. A conformed fact, such as revenue, can be correctly added and compared across different fact tables.

Changing Dimension

 

If the attributes of the dimension table changes over a period of time, the dimension is called the changing dimension. For example, in the location dimension, the address fields any change over a period of time if the person changes his address. Some attributes do not change at all, for example, data of birth in time dimension.

Click Stream Data

Data collected by web servers when the users browse a website. The click stream data is used to find out the user profile, their preferences and behavioral patters for business activities such as sales promotion campaigns.

Coding Standards

Guidelines created or formulated by an organization to be followed by all programmers while doing the coding. The coding standards for different programming languages, databases etc. will be developed by the COE teams or the central technology teams.

Configuration Management

Managing different versions and releases of documents and code base. Whenever any change is made to any of the work products such as software requirements specification document, design document, test plans, source code etc, a well defined procedure has to be followed. This Procedure or process is known as configuration management.

Cube:

It’s a structure that represents multi- dimensional data. A cube contains dimensions, hierarchies, levels and facts (measures). The dimensional model can be viewed as a cube, each side corresponding to a dimension.

Cache

This can be closely related to the internet cache files which are stored locally on personal computers to make the user experience faster. It is a method to improve the system performance by creating a secondary memory area with access speeds closer to the processing speed. A disk cache is a section of main memory set apart to cache data from the disk. A memory cache is a section of high speed memory to cache data from main memory.

Clustering

A method of keeping database files physically close to one another on the storage media for improving performance through sequential pre-fetch operations.

Composite Key

A key for a database table made up of more than one attribute or field.

CIO

Chief Information Officer. The executive who heads the information services division of an organization. The CIO, usually reports directly to the CEO  and has the responsibility for all the organization’s computing needs and data communication needs.