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.

  • D

    data structure

    A data structure is a specialized format for organizing and storing data.

  • data warehouse

    A data warehouse is a central repository for all or significant parts of the data that an enterprise's various business systems collect.

  • database (DB)

    A database is a collection of information that is organized so that it can be easily accessed, managed and updated.

  • database administrator (DBA)

    A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment.

  • database management system (DBMS)

    If the database is a file of information, then the DBMS is the file folders, the file labels and the file cabinet.

  • database normalization

    Database normalization is intrinsic to most relational database schemes. It is a process that organizes data into tables so that results are always unambiguous.

  • database replication

    Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of information... (Continued)

  • Database: Glossary

    This is a glossary of database-related terms.

  • DDBMS (distributed database management system)

    A DDBMS (distributed database management system) is a centralized application that manages a distributed database as if it were all stored on the same computer.

  • drilldown

    As currently used in information technology, to drill down (verb) is to focus in on something.

  • DSTP (Data Space Transfer Protocol)

    DSTP (Data Space Transfer Protocol) is a protocol that is used to index and retrieve data from a number of databases, files, and other data structures using a key that can find all the related data about a particular object across all of the data.

  • E

    ECMAScript (European Computer Manufacturers Association Script)

    ECMAScript is a standard script language, developed with the cooperation of Netscape and Microsoft and mainly derived from Netscape's JavaScript, the widely-used scripting language that is used in Web pages to affect how they look or behave for the user.

  • EDM (Electronic Document Management)

    EDM (Electronic Document Management) is the management of different kinds of documents in an enterprise using computer programs and storage.

  • entity-relationship model (ERM or ER model)

    The entity-relationship model (or ER model) is a way of graphically representing the logical relationships of entities (or objects) in order to create a database.

  • F

    Fast Guide: SQL Server 2000 commands

    Here are ten commands you need to know!

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close