SQL Server Definitions

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

  • F

    flat file

    A flat file contains records that have no structured interrelationship. A flat file typically consists of a text file, from which all word processing or other structure characters or markup have been removed.

  • full-text database

    A full-text database is a compilation of documents or other information in the form of a database in which the complete text of each referenced document is available for online viewing, printing, or downloading. In addition to text documents, images are often included, such as graphs, maps, photos, and diagrams. A full-text database is searchable by keyword, phrase, or both.

  • G

    GIS (geographic information system)

    A GIS (geographic information system) enables you to envision the geographic aspects of a body of data.

  • H

    hashing

    Hashing is the transformation of a string of characters into a usually shorter fixed-length value or key that represents the original string.

  • hybrid online analytical processing (HOLAP or Hybrid OLAP)

    Hybrid online analytical processing (HOLAP) is a combination of relational OLAP (ROLAP) and multidimensional OLAP (usually referred to simply as OLAP).

  • I

    In-Memory OLTP

    In-Memory OLTP is a Microsoft in-memory technology built into SQL Server and optimized for transaction processing applications.

  • information

    Information is stimuli that has meaning in some context for its receiver.

  • Ingres

    Ingres is a relational database management system (RDBMS) that evolved from a research project at the University of California at Berkeley in the 1970s.

  • initial extent

    The initial extent is a set of contiguous blocks in a database segment that is automatically allocated when the segment is created.

  • intelligent database

    An intelligent database is a full-text database that employs artficial intelligence (AI), interacting with users to ensure that returned items (hits) contain the most relevant information possible. This is in contrast to a traditional database, which is searchable only by keywords and verbatim phrases connected by Boolean operations such as AND, OR, and NOT. Intelligent database technology is in its infancy, and is evolving as AI becomes more advanced.

  • L

    library

    In computing, a library is a collection of similar objects that are stored for occasional use - most frequently, programs in source code or object code form, data files, scripts, templates, fonts, and physical storage units such as tape cartridges.

  • M

    meta

    Metadata is a description of data.

  • Microsoft Azure Cosmos DB

    Azure Cosmos DB is a Microsoft cloud database that supports multiple ways of storing and processing data. As such, it is classified as a multimodel database.

  • Microsoft GeoFlow

    Microsoft GeoFlow is a three-dimensional data visualization mapping tool for Microsoft Excel.

  • Microsoft PowerPivot

    PowerPivot is a free Microsoft Excel tool that increases the capabilities of Excel's pre-existing pivot table tool by allowing users to import data from multiple sources.  

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close