What are the most commonly used acronyms among database administrators and what are their correlated meanings?
Tell me more
×
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.
|
|
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 |
|||||||||||
|
|
Also QPS -- Queries Per Second |
||||
|
|
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 |
||||
|
|
