Database Design and Modeling Definitions

Search Definitions

A
ActiveX Data Objects (ADO)

ActiveX Data Objects (ADO) is an application program interface from Microsoft that lets a programmer writing Windows applications get access to a relational or non-relational database from both Microsoft and other database providers.
AdventureWorks Database

AdventureWorks Database is a sample OLTP database that Microsoft ships with all of its SQL Server database products.
AlwaysOn Availability Groups

AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together.
AS1 (Applicability Statement 1)

AS1 (Applicability Statement is a specification for Electronic Data Interchange (EDI) communications between businesses using e-mail protocols.
Azure Data Studio (formerly SQL Operations Studio)

Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems.

B
B-tree

A B-tree is a method of placing and locating files (called records or keys) in a database.
binary tree

A binary tree is a method of placing and locating files (called records or keys) in a database, especially when all the data is known to be in random access memory (RAM).
BLOB (binary large object)

In computers, a BLOB (binary large object), pronounced BLAHB and sometimes spelled in all lower case, is a large file, typically an image or sound file, that must be handled (for example, uploaded, downloaded, or stored in a database) in a special way because of its size.
block

A block is a contiguous set of bits or bytes that forms an identifiable unit of data.
C
C++

C++ is an object-oriented programming (OOP) language that is viewed by many as the best language for creating large-scale applications.
catalog

In computing, a catalog is a directory of information about data sets, files, or a database.
D
data structure

A data structure is a specialized format for organizing, processing, retrieving and storing data.
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) is the information technician responsible for directing or performing all activities related to maintaining a successful database environment.
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: Glossary

This is a glossary of database-related terms.
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.
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.
I
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.
M
Microsoft Visual FoxPro (Microsoft VFP)

Microsoft Visual FoxPro (VFP) is an object-oriented programming environment with a built-in relational database engine.
multidimensional expressions (MDX)

multidimensional expressions (MDX)
O
ODL (Open and Distance Learning)

Open and Distance Learning (ODL) is a general term for the use of telecommunication to provide or enhance learning.
OPAC (Online Public Access Catalog)

An OPAC (Online Public Access Catalog) is an online bibliography of a library collection that is available to the public.
P
primary key (primary keyword)

A primary key, also called a primary keyword, is a key in a relational database that is unique for each record.
R
record standardization

In data management, record standardization is a process in which files are first parsed (assigned to appropriate fields in a database record) and then translated to a common format.
S
schema

In computer programming, a schema (pronounced SKEE-mah) is the organization or structure for a database.
segment

A segment is a defined portion or section of something larger such as a database, geometric object, or network.
T
tablespace

In a database management system (DBMS), a tablespace is a logical group of data files in a database. A typical database contains at least one tablespace, and usually two or more. In a database, a tablespace plays a role similar to that of a folder on the hard drive of a computer. (Continued)
transcription error

A transcription error is a specific type of data entry error that is commonly made by human operators or by optical character recognition (OCR) programs.
V
Versioned Object Base (VOB)

A Versioned Object Base (VOB) is a centralized database that stores version information about the files and folders in a software configuration management (SCM) system.
view

In a database management system, a view is a way of portraying information in the database.