granicus.if.org Git - postgresql/blob - doc/src/sgml/acronyms.sgml

   1 <!-- doc/src/sgml/acronyms.sgml -->
   2
   3 <appendix id="acronyms">
   4  <title>Acronyms</title>
   5
   6  <para>
   7   This is a list of acronyms commonly used in the <productname>PostgreSQL</>
   8   documentation and in discussions about <productname>PostgreSQL</>.
   9
  10   <variablelist>
  11
  12    <varlistentry>
  13     <term><acronym>ANSI</acronym></term>
  14     <listitem>
  15      <para>
  16       <ulink url="http://en.wikipedia.org/wiki/American_National_Standards_Institute">
  17       American National Standards Institute</ulink>
  18      </para>
  19     </listitem>
  20    </varlistentry>
  21
  22    <varlistentry>
  23     <term><acronym>API</acronym></term>
  24     <listitem>
  25      <para>
  26       <ulink url="http://en.wikipedia.org/wiki/API">Application Programming Interface</ulink>
  27      </para>
  28     </listitem>
  29    </varlistentry>
  30
  31    <varlistentry>
  32     <term><acronym>ASCII</acronym></term>
  33     <listitem>
  34      <para>
  35       <ulink url="http://en.wikipedia.org/wiki/Ascii">American Standard
  36       Code for Information Interchange</ulink>
  37      </para>
  38     </listitem>
  39    </varlistentry>
  40
  41    <varlistentry>
  42     <term><acronym>BKI</acronym></term>
  43     <listitem>
  44      <para>
  45       <link linkend="bki">Backend Interface</link>
  46      </para>
  47     </listitem>
  48    </varlistentry>
  49
  50    <varlistentry>
  51     <term><acronym>CA</acronym></term>
  52     <listitem>
  53      <para>
  54       <ulink url="http://en.wikipedia.org/wiki/Certificate_authority">Certificate Authority</ulink>
  55      </para>
  56     </listitem>
  57    </varlistentry>
  58
  59    <varlistentry>
  60     <term><acronym>CIDR</acronym></term>
  61     <listitem>
  62      <para>
  63       <ulink
  64       url="http://en.wikipedia.org/wiki/Classless_Inter-Domain_Routing">Classless
  65       Inter-Domain Routing</ulink>
  66      </para>
  67     </listitem>
  68    </varlistentry>
  69
  70    <varlistentry>
  71     <term><acronym>CPAN</acronym></term>
  72     <listitem>
  73      <para>
  74       <ulink url="http://www.cpan.org/">Comprehensive Perl Archive Network</ulink>
  75      </para>
  76     </listitem>
  77    </varlistentry>
  78
  79    <varlistentry>
  80     <term><acronym>CRL</acronym></term>
  81     <listitem>
  82      <para>
  83       <ulink
  84       url="http://en.wikipedia.org/wiki/Certificate_revocation_list">Certificate
  85       Revocation List</ulink>
  86      </para>
  87     </listitem>
  88    </varlistentry>
  89
  90    <varlistentry>
  91     <term><acronym>CSV</acronym></term>
  92     <listitem>
  93      <para>
  94       <ulink
  95       url="http://en.wikipedia.org/wiki/Comma-separated_values">Comma
  96       Separated Values</ulink>
  97      </para>
  98     </listitem>
  99    </varlistentry>
 100
 101    <varlistentry>
 102     <term><acronym>CTE</acronym></term>
 103     <listitem>
 104      <para>
 105       <link linkend="queries-with">Common Table Expression</link>
 106      </para>
 107     </listitem>
 108    </varlistentry>
 109
 110    <varlistentry>
 111     <term><acronym>CVE</acronym></term>
 112     <listitem>
 113      <para>
 114       <ulink url="http://cve.mitre.org/">Common Vulnerabilities and Exposures</ulink>
 115      </para>
 116     </listitem>
 117    </varlistentry>
 118
 119    <varlistentry>
 120     <term><acronym>DBA</acronym></term>
 121     <listitem>
 122      <para>
 123       <ulink
 124       url="http://en.wikipedia.org/wiki/Database_administrator">Database
 125       Administrator</ulink>
 126      </para>
 127     </listitem>
 128    </varlistentry>
 129
 130    <varlistentry>
 131     <term><acronym>DBI</acronym></term>
 132     <listitem>
 133      <para>
 134       <ulink url="http://dbi.perl.org/">Database Interface (Perl)</ulink>
 135      </para>
 136     </listitem>
 137    </varlistentry>
 138
 139    <varlistentry>
 140     <term><acronym>DBMS</acronym></term>
 141     <listitem>
 142      <para>
 143       <ulink url="http://en.wikipedia.org/wiki/Dbms">Database Management
 144       System</ulink>
 145      </para>
 146     </listitem>
 147    </varlistentry>
 148
 149    <varlistentry>
 150     <term><acronym>DDL</acronym></term>
 151     <listitem>
 152      <para>
 153       <ulink
 154       url="http://en.wikipedia.org/wiki/Data_Definition_Language">Data
 155       Definition Language</ulink>, SQL commands such as <command>CREATE
 156       TABLE</>, <command>ALTER USER</>
 157      </para>
 158     </listitem>
 159    </varlistentry>
 160
 161    <varlistentry>
 162     <term><acronym>DML</acronym></term>
 163     <listitem>
 164      <para>
 165       <ulink
 166       url="http://en.wikipedia.org/wiki/Data_Manipulation_Language">Data
 167       Manipulation Language</ulink>, SQL commands such as <command>INSERT</>,
 168       <command>UPDATE</>, <command>DELETE</>
 169      </para>
 170     </listitem>
 171    </varlistentry>
 172
 173    <varlistentry>
 174     <term><acronym>DST</acronym></term>
 175     <listitem>
 176      <para>
 177       <ulink
 178       url="http://en.wikipedia.org/wiki/Daylight_saving_time">Daylight
 179       Saving Time</ulink>
 180      </para>
 181     </listitem>
 182    </varlistentry>
 183
 184    <varlistentry>
 185     <term><acronym>ECPG</acronym></term>
 186     <listitem>
 187      <para>
 188       <link linkend="ecpg">Embedded C for PostgreSQL</link>
 189      </para>
 190     </listitem>
 191    </varlistentry>
 192
 193    <varlistentry>
 194     <term><acronym>ESQL</acronym></term>
 195     <listitem>
 196      <para>
 197       <ulink url="http://en.wikipedia.org/wiki/Embedded_SQL">Embedded
 198       SQL</ulink>
 199      </para>
 200     </listitem>
 201    </varlistentry>
 202
 203    <varlistentry>
 204     <term><acronym>FAQ</acronym></term>
 205     <listitem>
 206      <para>
 207       <ulink url="http://en.wikipedia.org/wiki/FAQ">Frequently Asked
 208       Questions</ulink>
 209      </para>
 210     </listitem>
 211    </varlistentry>
 212
 213    <varlistentry>
 214     <term><acronym>FSM</acronym></term>
 215     <listitem>
 216      <para>
 217       <link linkend="storage-fsm">Free Space Map</link>
 218      </para>
 219     </listitem>
 220    </varlistentry>
 221
 222    <varlistentry>
 223     <term><acronym>GEQO</acronym></term>
 224     <listitem>
 225      <para>
 226       <link linkend="geqo">Genetic Query Optimizer</link>
 227      </para>
 228     </listitem>
 229    </varlistentry>
 230
 231    <varlistentry>
 232     <term><acronym>GIN</acronym></term>
 233     <listitem>
 234      <para>
 235       <link linkend="GIN">Generalized Inverted Index</link>
 236      </para>
 237     </listitem>
 238    </varlistentry>
 239
 240    <varlistentry>
 241     <term><acronym>GiST</acronym></term>
 242     <listitem>
 243      <para>
 244       <link linkend="GiST">Generalized Search Tree</link>
 245      </para>
 246     </listitem>
 247    </varlistentry>
 248
 249    <varlistentry>
 250     <term><acronym>Git</acronym></term>
 251     <listitem>
 252      <para>
 253       <ulink
 254       url="http://en.wikipedia.org/wiki/Git_(software)">Git</ulink>
 255      </para>
 256     </listitem>
 257    </varlistentry>
 258
 259    <varlistentry>
 260     <term><acronym>GMT</acronym></term>
 261     <listitem>
 262      <para>
 263       <ulink url="http://en.wikipedia.org/wiki/GMT">Greenwich Mean Time</ulink>
 264      </para>
 265     </listitem>
 266    </varlistentry>
 267
 268    <varlistentry>
 269     <term><acronym>GSSAPI</acronym></term>
 270     <listitem>
 271      <para>
 272       <ulink
 273       url="http://en.wikipedia.org/wiki/Generic_Security_Services_Application_Program_Interface">Generic
 274       Security Services Application Programming Interface</ulink>
 275      </para>
 276     </listitem>
 277    </varlistentry>
 278
 279    <varlistentry>
 280     <term><acronym>GUC</acronym></term>
 281     <listitem>
 282      <para>
 283       <link linkend="config-setting">Grand Unified Configuration</link>,
 284       the <productname>PostgreSQL</> subsystem that handles server configuration
 285      </para>
 286     </listitem>
 287    </varlistentry>
 288
 289    <varlistentry>
 290     <term><acronym>HBA</acronym></term>
 291     <listitem>
 292      <para>
 293       <link linkend="auth-pg-hba-conf">Host-Based Authentication</link>
 294      </para>
 295     </listitem>
 296    </varlistentry>
 297
 298    <varlistentry>
 299     <term><acronym>HOT</acronym></term>
 300     <listitem>
 301      <para>
 302       <ulink
 303       url="http://git.postgresql.org/gitweb?p=postgresql.git;a=blob;f=src/backend/access/heap/README.HOT;hb=HEAD">Heap-Only
 304       Tuples</ulink>
 305      </para>
 306     </listitem>
 307    </varlistentry>
 308
 309    <varlistentry>
 310     <term><acronym>IEC</acronym></term>
 311     <listitem>
 312      <para>
 313       <ulink
 314       url="http://en.wikipedia.org/wiki/International_Electrotechnical_Commission">International
 315       Electrotechnical Commission</ulink>
 316      </para>
 317     </listitem>
 318    </varlistentry>
 319
 320    <varlistentry>
 321     <term><acronym>IEEE</acronym></term>
 322     <listitem>
 323      <para>
 324       <ulink url="http://standards.ieee.org/">Institute of Electrical and
 325       Electronics Engineers</ulink>
 326      </para>
 327     </listitem>
 328    </varlistentry>
 329
 330    <varlistentry>
 331     <term><acronym>IPC</acronym></term>
 332     <listitem>
 333      <para>
 334       <ulink
 335       url="http://en.wikipedia.org/wiki/Inter-process_communication">Inter-Process
 336       Communication</ulink>
 337      </para>
 338     </listitem>
 339    </varlistentry>
 340
 341    <varlistentry>
 342     <term><acronym>ISO</acronym></term>
 343     <listitem>
 344      <para>
 345       <ulink url="http://www.iso.org/iso/home.htm">International Organization for
 346       Standardization</ulink>
 347      </para>
 348     </listitem>
 349    </varlistentry>
 350
 351    <varlistentry>
 352     <term><acronym>ISSN</acronym></term>
 353     <listitem>
 354      <para>
 355       <ulink url="http://en.wikipedia.org/wiki/Issn">International Standard
 356       Serial Number</ulink>
 357      </para>
 358     </listitem>
 359    </varlistentry>
 360
 361    <varlistentry>
 362     <term><acronym>JDBC</acronym></term>
 363     <listitem>
 364      <para>
 365       <ulink
 366       url="http://en.wikipedia.org/wiki/Java_Database_Connectivity">Java
 367       Database Connectivity</ulink>
 368      </para>
 369     </listitem>
 370    </varlistentry>
 371
 372    <varlistentry>
 373     <term><acronym>LDAP</acronym></term>
 374     <listitem>
 375      <para>
 376       <ulink
 377       url="http://en.wikipedia.org/wiki/Lightweight_Directory_Access_Protocol">Lightweight
 378       Directory Access Protocol</ulink>
 379      </para>
 380     </listitem>
 381    </varlistentry>
 382
 383    <varlistentry>
 384     <term><acronym>LSN</acronym></term>
 385     <listitem>
 386      <para>
 387       Log Sequence Number, see <link linkend="datatype-pg-lsn"><type>pg_lsn</></link>
 388       and <link linkend="wal-internals">WAL Internals</link>.
 389      </para>
 390     </listitem>
 391    </varlistentry>
 392
 393    <varlistentry>
 394     <term><acronym>MSVC</acronym></term>
 395     <listitem>
 396      <para>
 397       <ulink
 398       url="http://en.wikipedia.org/wiki/Visual_C++"><productname>Microsoft
 399       Visual C</productname></ulink>
 400      </para>
 401     </listitem>
 402    </varlistentry>
 403
 404    <varlistentry>
 405     <term><acronym>MVCC</acronym></term>
 406     <listitem>
 407      <para>
 408       <link linkend="mvcc">Multi-Version Concurrency Control</link>
 409      </para>
 410     </listitem>
 411    </varlistentry>
 412
 413    <varlistentry>
 414     <term><acronym>NLS</acronym></term>
 415     <listitem>
 416      <para>
 417       <ulink
 418       url="http://en.wikipedia.org/wiki/Internationalization_and_localization">National
 419       Language Support</ulink>
 420      </para>
 421     </listitem>
 422    </varlistentry>
 423
 424    <varlistentry>
 425     <term><acronym>ODBC</acronym></term>
 426     <listitem>
 427      <para>
 428       <ulink
 429       url="http://en.wikipedia.org/wiki/Open_Database_Connectivity">Open
 430       Database Connectivity</ulink>
 431      </para>
 432     </listitem>
 433    </varlistentry>
 434
 435    <varlistentry>
 436     <term><acronym>OID</acronym></term>
 437     <listitem>
 438      <para>
 439       <link linkend="datatype-oid">Object Identifier</link>
 440      </para>
 441     </listitem>
 442    </varlistentry>
 443
 444    <varlistentry>
 445     <term><acronym>OLAP</acronym></term>
 446     <listitem>
 447      <para>
 448       <ulink url="http://en.wikipedia.org/wiki/Olap">Online Analytical
 449       Processing</ulink>
 450      </para>
 451     </listitem>
 452    </varlistentry>
 453
 454    <varlistentry>
 455     <term><acronym>OLTP</acronym></term>
 456     <listitem>
 457      <para>
 458       <ulink url="http://en.wikipedia.org/wiki/OLTP">Online Transaction
 459       Processing</ulink>
 460      </para>
 461     </listitem>
 462    </varlistentry>
 463
 464    <varlistentry>
 465     <term><acronym>ORDBMS</acronym></term>
 466     <listitem>
 467      <para>
 468       <ulink url="http://en.wikipedia.org/wiki/ORDBMS">Object-Relational
 469       Database Management System</ulink>
 470      </para>
 471     </listitem>
 472    </varlistentry>
 473
 474    <varlistentry>
 475     <term><acronym>PAM</acronym></term>
 476     <listitem>
 477      <para>
 478       <ulink
 479       url="http://en.wikipedia.org/wiki/Pluggable_Authentication_Modules">Pluggable
 480       Authentication Modules</ulink>
 481      </para>
 482     </listitem>
 483    </varlistentry>
 484
 485    <varlistentry>
 486     <term><acronym>PGSQL</acronym></term>
 487     <listitem>
 488      <para>
 489       <link linkend="postgres"><productname>PostgreSQL</></link>
 490      </para>
 491     </listitem>
 492    </varlistentry>
 493
 494    <varlistentry>
 495     <term><acronym>PGXS</acronym></term>
 496     <listitem>
 497      <para>
 498       <link linkend="extend-pgxs"><productname>PostgreSQL</> Extension System</link>
 499      </para>
 500     </listitem>
 501    </varlistentry>
 502
 503    <varlistentry>
 504     <term><acronym>PID</acronym></term>
 505     <listitem>
 506      <para>
 507       <ulink url="http://en.wikipedia.org/wiki/Process_identifier">Process Identifier</ulink>
 508      </para>
 509     </listitem>
 510    </varlistentry>
 511
 512    <varlistentry>
 513     <term><acronym>PITR</acronym></term>
 514     <listitem>
 515      <para>
 516       <link linkend="continuous-archiving">Point-In-Time
 517       Recovery</link> (Continuous Archiving)
 518      </para>
 519     </listitem>
 520    </varlistentry>
 521
 522    <varlistentry>
 523     <term><acronym>PL</acronym></term>
 524     <listitem>
 525      <para>
 526       <link linkend="server-programming">Procedural Languages (server-side)</link>
 527      </para>
 528     </listitem>
 529    </varlistentry>
 530
 531    <varlistentry>
 532     <term><acronym>POSIX</acronym></term>
 533     <listitem>
 534      <para>
 535       <ulink url="http://en.wikipedia.org/wiki/POSIX">Portable Operating
 536       System Interface</ulink>
 537      </para>
 538     </listitem>
 539    </varlistentry>
 540
 541    <varlistentry>
 542     <term><acronym>RDBMS</acronym></term>
 543     <listitem>
 544      <para>
 545       <ulink
 546       url="http://en.wikipedia.org/wiki/Relational_database_management_system">Relational
 547       Database Management System</ulink>
 548      </para>
 549     </listitem>
 550    </varlistentry>
 551
 552    <varlistentry>
 553     <term><acronym>RFC</acronym></term>
 554     <listitem>
 555      <para>
 556       <ulink
 557       url="http://en.wikipedia.org/wiki/Request_for_Comments">Request For
 558       Comments</ulink>
 559      </para>
 560     </listitem>
 561    </varlistentry>
 562
 563    <varlistentry>
 564     <term><acronym>SGML</acronym></term>
 565     <listitem>
 566      <para>
 567       <ulink url="http://en.wikipedia.org/wiki/SGML">Standard Generalized
 568       Markup Language</ulink>
 569      </para>
 570     </listitem>
 571    </varlistentry>
 572
 573    <varlistentry>
 574     <term><acronym>SPI</acronym></term>
 575     <listitem>
 576      <para>
 577       <link linkend="spi">Server Programming Interface</link>
 578      </para>
 579     </listitem>
 580    </varlistentry>
 581
 582    <varlistentry>
 583     <term><acronym>SP-GiST</acronym></term>
 584     <listitem>
 585      <para>
 586       <link linkend="SPGiST">Space-Partitioned Generalized Search Tree</link>
 587      </para>
 588     </listitem>
 589    </varlistentry>
 590
 591    <varlistentry>
 592     <term><acronym>SQL</acronym></term>
 593     <listitem>
 594      <para>
 595       <ulink url="http://en.wikipedia.org/wiki/SQL">Structured Query Language</ulink>
 596      </para>
 597     </listitem>
 598    </varlistentry>
 599
 600    <varlistentry>
 601     <term><acronym>SRF</acronym></term>
 602     <listitem>
 603      <para>
 604       <link linkend="xfunc-c-return-set">Set-Returning Function</link>
 605      </para>
 606     </listitem>
 607    </varlistentry>
 608
 609    <varlistentry>
 610     <term><acronym>SSH</acronym></term>
 611     <listitem>
 612      <para>
 613       <ulink url="http://en.wikipedia.org/wiki/Secure_Shell">Secure
 614       Shell</ulink>
 615      </para>
 616     </listitem>
 617    </varlistentry>
 618
 619    <varlistentry>
 620     <term><acronym>SSL</acronym></term>
 621     <listitem>
 622      <para>
 623       <ulink url="http://en.wikipedia.org/wiki/Secure_Sockets_Layer">Secure Sockets Layer</ulink>
 624      </para>
 625     </listitem>
 626    </varlistentry>
 627
 628    <varlistentry>
 629     <term><acronym>SSPI</acronym></term>
 630     <listitem>
 631      <para>
 632       <ulink url="http://msdn.microsoft.com/en-us/library/aa380493%28VS.85%29.aspx">Security
 633       Support Provider Interface</ulink>
 634      </para>
 635     </listitem>
 636    </varlistentry>
 637
 638    <varlistentry>
 639     <term><acronym>SYSV</acronym></term>
 640     <listitem>
 641      <para>
 642       <ulink url="http://en.wikipedia.org/wiki/System_V">Unix System V</ulink>
 643      </para>
 644     </listitem>
 645    </varlistentry>
 646
 647    <varlistentry>
 648     <term><acronym>TCP/IP</acronym></term>
 649     <listitem>
 650      <para>
 651       <ulink
 652       url="http://en.wikipedia.org/wiki/Transmission_Control_Protocol">Transmission
 653       Control Protocol (TCP) / Internet Protocol (IP)</ulink>
 654      </para>
 655     </listitem>
 656    </varlistentry>
 657
 658    <varlistentry>
 659     <term><acronym>TID</acronym></term>
 660     <listitem>
 661      <para>
 662       <link linkend="datatype-oid">Tuple Identifier</link>
 663      </para>
 664     </listitem>
 665    </varlistentry>
 666
 667    <varlistentry>
 668     <term><acronym>TOAST</acronym></term>
 669     <listitem>
 670      <para>
 671       <link linkend="storage-toast">The Oversized-Attribute Storage Technique</link>
 672      </para>
 673     </listitem>
 674    </varlistentry>
 675
 676    <varlistentry>
 677     <term><acronym>TPC</acronym></term>
 678     <listitem>
 679      <para>
 680       <ulink url="http://www.tpc.org/">Transaction Processing
 681       Performance Council</ulink>
 682      </para>
 683     </listitem>
 684    </varlistentry>
 685
 686    <varlistentry>
 687     <term><acronym>URL</acronym></term>
 688     <listitem>
 689      <para>
 690       <ulink url="http://en.wikipedia.org/wiki/URL">Uniform Resource
 691       Locator</ulink>
 692      </para>
 693     </listitem>
 694    </varlistentry>
 695
 696    <varlistentry>
 697     <term><acronym>UTC</acronym></term>
 698     <listitem>
 699      <para>
 700       <ulink
 701       url="http://en.wikipedia.org/wiki/Coordinated_Universal_Time">Coordinated
 702       Universal Time</ulink>
 703      </para>
 704     </listitem>
 705    </varlistentry>
 706
 707    <varlistentry>
 708     <term><acronym>UTF</acronym></term>
 709     <listitem>
 710      <para>
 711       <ulink url="http://www.unicode.org/">Unicode Transformation
 712       Format</ulink>
 713      </para>
 714     </listitem>
 715    </varlistentry>
 716
 717    <varlistentry>
 718     <term><acronym>UTF8</acronym></term>
 719     <listitem>
 720      <para>
 721       <ulink url="http://en.wikipedia.org/wiki/Utf8">Eight-Bit Unicode
 722       Transformation Format</ulink>
 723      </para>
 724     </listitem>
 725    </varlistentry>
 726
 727    <varlistentry>
 728     <term><acronym>UUID</acronym></term>
 729     <listitem>
 730      <para>
 731       <link linkend="datatype-uuid">Universally Unique Identifier</link>
 732      </para>
 733     </listitem>
 734    </varlistentry>
 735
 736    <varlistentry>
 737     <term><acronym>WAL</acronym></term>
 738     <listitem>
 739      <para>
 740       <link linkend="wal">Write-Ahead Log</link>
 741      </para>
 742     </listitem>
 743    </varlistentry>
 744
 745    <varlistentry>
 746     <term><acronym>XID</acronym></term>
 747     <listitem>
 748      <para>
 749       <link linkend="datatype-oid">Transaction Identifier</link>
 750      </para>
 751     </listitem>
 752    </varlistentry>
 753
 754    <varlistentry>
 755     <term><acronym>XML</acronym></term>
 756     <listitem>
 757      <para>
 758       <ulink url="http://en.wikipedia.org/wiki/XML">Extensible Markup
 759       Language</ulink>
 760      </para>
 761     </listitem>
 762    </varlistentry>
 763
 764   </variablelist>
 765  </para>
 766
 767 </appendix>