附录 K. 首字母缩写词

在PostgreSQL的文档和讨论中有很多常用的首字母缩写词。

ANSI : American National Standards Institute

API : Application Programming Interface

ASCII : American Standard Code for Information Interchange

BKI : Backend Interface

CA : Certificate Authority

CIDR : Classless Inter-Domain Routing

CPAN : Comprehensive Perl Archive Network

CRL : Certificate Revocation List

CSV : Comma Separated Values

CTE : Common Table Expression

CVE : Common Vulnerabilities and Exposures

DBA : Database Administrator

DBI : Database Interface (Perl)

DBMS : Database Management System

DDL : Data Definition Language, SQL commands such as CREATE TABLE, ALTER USER

DML : Data Manipulation Language, SQL commands such as INSERT, UPDATE, DELETE

DST : Daylight Saving Time

ECPG : Embedded C for PostgreSQL

ESQL : Embedded SQL

FAQ : Frequently Asked Questions

FSM : Free Space Map

GEQO : Genetic Query Optimizer

GIN : Generalized Inverted Index

GiST : Generalized Search Tree

Git : Git

GMT : Greenwich Mean Time

GSSAPI : Generic Security Services Application Programming Interface

GUC : Grand Unified Configuration, the PostgreSQL subsystem that handles server configuration

HBA : Host-Based Authentication

HOT : Heap-Only Tuples

IEC : International Electrotechnical Commission

IEEE : Institute of Electrical and Electronics Engineers

IPC : Inter-Process Communication

ISO : International Organization for Standardization

ISSN : International Standard Serial Number

JDBC : Java Database Connectivity

JIT : Just-in-Time compilation

JSON : JavaScript Object Notation

LDAP : Lightweight Directory Access Protocol

LSN : Log Sequence Number, see pg_lsn and WAL Internals.

MSVC : Microsoft Visual C

MVCC : Multi-Version Concurrency Control

NLS : National Language Support

ODBC : Open Database Connectivity

OID : Object Identifier

OLAP : Online Analytical Processing

OLTP : Online Transaction Processing

ORDBMS : Object-Relational Database Management System

PAM : Pluggable Authentication Modules

PGSQL : PostgreSQL

PGXS : PostgreSQL Extension System

PID : Process Identifier

PITR : Point-In-Time Recovery (Continuous Archiving)

PL : Procedural Languages (server-side)

POSIX : Portable Operating System Interface

RDBMS : Relational Database Management System

RFC : Request For Comments

SGML : Standard Generalized Markup Language

SPI : Server Programming Interface

SP-GiST : Space-Partitioned Generalized Search Tree

SQL : Structured Query Language

SRF : Set-Returning Function

SSH : Secure Shell

SSL : Secure Sockets Layer

SSPI : Security Support Provider Interface

SYSV : Unix System V

TCP/IP : Transmission Control Protocol (TCP) / Internet Protocol (IP)

TID : Tuple Identifier

TOAST : The Oversized-Attribute Storage Technique

TPC : Transaction Processing Performance Council

URL : Uniform Resource Locator

UTC : Coordinated Universal Time

UTF : Unicode Transformation Format

UTF8 : Eight-Bit Unicode Transformation Format

UUID : Universally Unique Identifier

WAL : Write-Ahead Log

XID : Transaction Identifier

XML : Extensible Markup Language