SQL Server Development Definitions
-
D
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
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.
-
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.