Database Design and Modeling 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).
-
bit bucket
Computer jargon users say that data which has been lost or thrown away has gone in the bit bucket.
-
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.