Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What are the most commonly used acronyms among database administrators and what are their correlated meanings?

share|improve this question
    
This is for the community and those searching for meanings of commonly used terms and acronyms when working with databases, etc. –  nojak Aug 15 '12 at 16:18
3  
Please edit and update the original answer so that it's all contained in one post, if possible. –  nojak Aug 15 '12 at 16:40
1  
Some MS ones: SSIS (replaced DTS); SSMS; SQL Agent, jobs. Also: triggers, schema-bound views, clustered indexes. –  LarsH Aug 15 '12 at 19:36

14 Answers 14

up vote 36 down vote accepted

ACID – Atomicity, Consistency, Isolation, Durability

BASE - Basically Available, Soft-State, Eventually Consistent...essentially a counterpart to (though not really "opposite" of) ACID, this is the core principle of most NoSQL implementations.

BI - Business Intelligence

BLOB – Binary Large OBject

CAP – Consistency, Availability, Partition tolerance... The three requirements of a distributed system (as they apply to a database) according to Eric Brewer's CAP Theorem.

CLOB – Character Large OBject

CRUD – Create, Read, Update, and Delete

CS – Cursor Stability - an isolation level supported by different database management systems.

CTE – Common Table Expression

DBA – Database Administrator

DBMS – Database Management System

DCL – Data Control Language

DDL – Data Definition Language

DML – Data Manipulation Language

DMV - Dynamic Management Views

DR - Disaster Recovery

DRDA – Distributed Relational Database Architecture

DRI - Declarative Referential Integrity

DSS - Decision Support Systems

DTD – Document Type Definition

DW or DWH – Database Warehouse

EAV – Entity-Attribute-Value (aka. the archenemy)

ERD - Entity Relationship Diagram

ETL – Extract, Transform, Load

FLWOR – For, Let, Where, Order, Return - an expression form used within XQuery to query XML within a database (not sure if DB2 only)

GBP – Group Buffer Pool

HADR – High Availability Disaster Recovery

IOPS – IO Per Second

IOT – Index Organized Table (Oracle)

JDBC – Java Database Connectivity

LAMP - Linux, Apache, MySQL and PHP

LBAC - Label Based Access Control

LOB – Large OBject

LPAR – Logical Partition

LUN - Logical Unit Number

MDC – Multidimensional Clustering Table

MDX - Multidimensional Expressions

MQT – Materialized Query Table (IBM DB2)

MV – Materialized View

MVCC – Multiversion Concurrency Control

ODBC – Open Database Connectivity

ODS - Operational Data Store

OLAP – Online Analytical Processing

OLTP – Online Transaction Processing

OODBMS – Object-Oriented Database Management System

OOM – Out Of Memory

ORM – Object-Relational Mapping

QPS – Queries Per Second

PL/pgSQL – Procedural Language/SQL (PostgreSQL) used for writing stored procedures. Similar to PL/SQL.

PL/SQL – Procedural Language/SQL (Oracle) used for writing stored procedures. Also see SQL PL.

RAC – Real Application Clusters (Oracle)

RBAR – Row By Agonizing Row

RDBMS – Relational Database Management System

RPO - Recovery Point Objective - how much data you can afford to lose. If your server went down, this is the point at which you'd be able to recover the data.

RR – Repeatable Read - an isolation level supported by different database management systems.

RS – Read Stability - an isolation level supported by different database management systems.

RTO - Recovery Time Objective - how much time it would take you to recover the data to the RPO

SAN - Storage Area Network

SEQUEL – Structured English QUEry Language, which was IBM's precursor to SQL, which is why SQL is sometimes (often?) pronounced SEQUEL and not S.Q.L.

SP – Stored Procedure

SQL – Structured Query Language

SQL PL – SQL Procedure Language used for writing stored procedures. Also see PL/SQL.

SQL/XML – an extension of the SQL language used for querying XML.

TPS* - Transactions Per Second, a measurement of database performance.

UAT - User Acceptance Testing

UDF – User Defined Function

UR – Uncommitted Read - an isolation level supported by different database management systems.

XML – eXtensible Markup Language

XSD – XML Schema Definition

XSLT – XML Stylesheet Transformation

UDT – User Defined Type

share|improve this answer
    
This is just a start, in hopes that the community will add more. –  nojak Aug 15 '12 at 16:21
    
RBAR, DBMS, clustered index, covering index. –  ypercube Aug 16 '12 at 8:54
    
Added DBMS & RBAR. Perhaps terms that are not acronyms should be described in a separate answer. –  Andriy M Aug 16 '12 at 13:06
    
Agreed. There are more than enough acronyms to completely fill a few pages. Do you think it would be best if I modified the question title and question? –  nojak Aug 16 '12 at 16:36
    
Modified question to just acronyms. Terms would definitely take up an entirely new question. Thanks for the suggestion! –  nojak Aug 16 '12 at 16:39

ETL - Extract, Transform, Load

share|improve this answer

Also

QPS -- Queries Per Second

share|improve this answer
    
Added this to the main Community Wiki answer, since you don't have 100 rep to edit it. Thanks! –  nojak Aug 15 '12 at 17:49

EAV - Entity-Attribute-Value (aka. the archenemy)

UDF - User Defined Function

SP - Stored Procedure

share|improve this answer

LAMP = Linux, Apache, MySQL and PHP

share|improve this answer

MDC - Multidimensional Clustering table

MQT - Materialized Query Table (IBM DB2)

UDT - User Defined Type

share|improve this answer
    
added to main answer –  Chris Aldrich Aug 17 '12 at 17:45

TPS - Transactions per Second - measure database performance

share|improve this answer

TSQL (or T-SQL) : Transact-SQL (Microsoft's and Sybase's proprietary extension to SQL).

share|improve this answer

IOT - Index Organized Table (Oracle)

ACID - Atomicity, Consistency, Isolation, Durability

CAP - Consistency, Availability, Partition tolerance... The three requirements of a distributed system (as they apply to a database) according to Eric Brewer's CAP Theorem.

MV - Materialized View

BLOB - Binary Large OBject

CLOB - Character Large OBject

DDL - Data Definition Language

DCL - Data Control Language (GRANT,REVOKE)

DML - Data Manipulation Language

RAC - Real Application Clusters (Oracle)

share|improve this answer
    
added to main wiki answer –  BryceAtNetwork23 Aug 15 '12 at 19:49

SEQUEL - Structured English QUEry Language, which was IBM's precursor to SQL, which is why SQL is pronounced SEQUEL and not S.Q.L.

share|improve this answer
1  
SQL is also short for Structured Query Language, which is why it can be pronounced S.Q.L. –  datagod Aug 16 '12 at 13:45

LUN - Logical Unit Number

SAN - Storage Area Network

ODS - Operational Data Store

DR - Disaster Recovery

UAT - User Acceptance Testing

share|improve this answer

Don't forget

MVCC - Multiversion Concurrency Control

NAS - Network Attached Storage

DRBD - Distributed Replicated Block Device

share|improve this answer

ERD - Entity Relationship Diagrams

share|improve this answer

I didn't see it listed yet, but for those DBAs that don't bother putting together a proper recovery strategy I would offer this:

URLT - Update Resume; Leave Town

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.