Data Management/Data Warehousing Definitions

This glossary explains the meaning of key words and phrases that information technology (IT) and business professionals use when discussing data management and related software products. You can find additional definitions by visiting WhatIs.com or using the search box below.

Search Definitions
  • R

    RDBMS (relational database management system)

    A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database.

  • relational database

    A relational database is a collection of information that organizes data points with defined relationships for easy access.

  • RFM analysis (recency, frequency, monetary)

    RFM analysis is a marketing technique used to quantitatively rank and group customers based on the recency, frequency and monetary total of their recent transactions to identify the best customers and perform targeted marketing campaigns.

  • S

    semantic technology

    Semantic technology is a set of methods and tools that provide advanced means for categorizing and processing data, as well as for discovering relationships within varied data sets.

  • snowflaking (snowflake schema)

    In data warehousing, snowflaking is a form of dimensional modeling where dimensions are stored in multiple related dimension tables. 

  • sparsity and density

    Sparsity and density are terms used to describe the percentage of cells in a database table that are not populated and populated, respectively. The sum of the sparsity and density should equal 100%.

  • SQL (Structured Query Language)

    SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them.

  • SQL-on-Hadoop

    SQL-on-Hadoop is a class of analytical application tools that combine established SQL-style querying with newer Hadoop data framework elements.

  • star schema

    A star schema is a database organizational structure optimized for use in a data warehouse or business intelligence that uses a single large fact table to store transactional or measured data, and one or more smaller dimensional tables that store attributes about the data.

  • stream processing

    Stream processing is a data management technique that involves ingesting a continuous data stream to quickly analyze, filter, transform or enhance the data in real time.

  • synthetic backup

    Synthetic backup is the process of generating a file from a complete copy of a file created at some past time and one or more incremental copies created at later times... (Continued)

  • T

    T-SQL (Transact-SQL)

    T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables.

  • TensorFlow

    TensorFlow is an open source framework developed by Google researchers to run machine learning, deep learning and other statistical and predictive analytics workloads.

  • three-phase commit (3PC)

    Three-phase commit (3PC) is a protocol that consists of a distributed algorithm used to ensure all transactions in a system are agreed upon and are committed to.

  • tree structure

    A tree structure is an algorithm for placing and locating files (called records or keys) in a database. The algorithm finds data by repeatedly making choices at decision points called nodes. A node can have as few as two branches (also called children)...

  • U

    USA Patriot Act

    The USA Patriot Act is a law enacted in 2001, granting new and extended data-collection abilities to federal agencies in an effort to combat terrorism after the September 11 attacks.

  • V

    virtual cube

    A virtual cube is a subset of one or two existing cubes in a database. Database administrators create virtual cubes for security purposes and/or to enable analysis of the shared data.

  • VoltDB

    VoltDB is an in-memory database. The software is available in an open-source community edition and in a commercial release from vendor VoltDB Inc.

SearchBusinessAnalytics
SearchAWS
SearchContentManagement
SearchOracle
SearchSAP
SearchSQLServer
Close