Database applications

Database applications

Software that facilitates communication between a human user and a database.

Industry: Software

Add a new term

Contributors in Database applications

Become a Contributors

Database applications

Extract processing

Software; Database applications

The process of selecting data from one environment and transporting it to another environment for use by individual users or departments.

Extraction

Software; Database applications

The process of selecting and pulling data from the operational and external data sources, in order to prepare it for a data warehouse.

Extraction, transformation, and loading (ETL)

Software; Database applications

The methods involved in populating a data warehouse. See also extraction, load, and transformation.

Extraction, transformation, and transportation (ETT)

Software; Database applications

The methods involved in accessing and manipulating source data and loading it into a data warehouse.

Fact data

Software; Database applications

Measurements within the core of a data warehouse on which all online analytical processing (OLAP) queries depend.

Fact table

Software; Database applications

A table in a star schema that contains facts, either detail-level or aggregated. (Fact tables that contain aggregated facts are often called summary tables).

Failover

Software; Database applications

An operational mode in which the functions of a system are assumed by a secondary system whenever the primary system becomes unavailable, through either failure or scheduled down time.