SQL Server Definitions

  • 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)

    (DBA is also an abbreviation for doing business as - a term sometimes used in business and legal writing.

  • 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!