What are the most commonly used acronyms among database administrators and what are their correlated meanings?
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
|show 3 more comments|
EAV - Entity-Attribute-Value (aka. the archenemy)
UDF - User Defined Function
SP - Stored Procedure
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
DML - Data Manipulation Language
RAC - Real Application Clusters (Oracle)
MDC - Multidimensional Clustering table
MQT - Materialized Query Table (IBM DB2)
UDT - User Defined Type
SEQUEL - Structured English QUEry Language, which was IBM's precursor to SQL, which is why SQL is pronounced SEQUEL and not S.Q.L.
LUN - Logical Unit Number
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