Home Explore Blog CI



postgresql

7th chunk of `doc/src/sgml/glossary.sgml`
9aa1de99fbda2a81cc68697da7bd28905c0d94d16efa0d8f0000000100000fa9
 linkend="glossary-mvcc">multiversion concurrency control</glossterm>
     mechanism.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-connection">
   <glossterm>Connection</glossterm>
   <glossdef>
    <para>
     An established line of communication between a client process and a
     <glossterm linkend="glossary-backend">backend</glossterm> process,
     usually over a network, supporting a
     <glossterm linkend="glossary-session">session</glossterm>.  This term is
     sometimes used as a synonym for session.
    </para>
    <para>
     For more information, see
     <xref linkend="runtime-config-connection"/>.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-consistency">
   <glossterm>Consistency</glossterm>
   <glossdef>
    <para>
     The property that the data in the
     <glossterm linkend="glossary-database">database</glossterm>
     is always in compliance with
     <glossterm linkend="glossary-constraint">integrity constraints</glossterm>.
     Transactions may be allowed to violate some of the constraints
     transiently before it commits, but if such violations are not resolved
     by the time it commits, such a transaction is automatically
     <glossterm linkend="glossary-rollback">rolled back</glossterm>.
     This is one of the <acronym>ACID</acronym> properties.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-constraint">
   <glossterm>Constraint</glossterm>
   <glossdef>
    <para>
     A restriction on the values of data allowed within a
     <glossterm linkend="glossary-table">table</glossterm>,
     or in attributes of a
     <glossterm linkend="glossary-domain">domain</glossterm>.
    </para>
    <para>
     For more information, see
     <xref linkend="ddl-constraints"/>.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-cumulative-statistics">
   <glossterm>Cumulative Statistics System</glossterm>
   <glossdef>
    <para>
     A system which, if enabled, accumulates statistical information
     about the <glossterm linkend="glossary-instance">instance</glossterm>'s
     activities.
    </para>
    <para>
      For more information, see
      <xref linkend="monitoring-stats"/>.
    </para>
   </glossdef>
  </glossentry>

  <glossentry>
   <glossterm>Data area</glossterm>
   <glosssee otherterm="glossary-data-directory" />
  </glossentry>

  <glossentry id="glossary-database">
   <glossterm>Database</glossterm>
   <glossdef>
    <para>
     A named collection of
     <glossterm linkend="glossary-sql-object">local SQL objects</glossterm>.
    </para>
    <para>
     For more information, see
     <xref linkend="manage-ag-overview"/>.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-db-cluster">
   <glossterm>Database cluster</glossterm>
   <glossdef>
    <para>
     A collection of databases and global SQL objects,
     and their common static and dynamic metadata.
     Sometimes referred to as a
     <firstterm>cluster</firstterm>.
     A database cluster is created using the
     <xref linkend="app-initdb" /> program.
    </para>
    <para>
     In <productname>PostgreSQL</productname>, the term
     <firstterm>cluster</firstterm> is also sometimes used to refer to an instance.
     (Don't confuse this term with the SQL command <command>CLUSTER</command>.)
    </para>
    <para>
     See also <glossterm linkend="glossary-cluster-owner">cluster owner</glossterm>,
     the operating-system owner of a cluster,
     and <glossterm linkend="glossary-bootstrap-superuser">bootstrap superuser</glossterm>,
     the <productname>PostgreSQL</productname> owner of a cluster.
    </para>
   </glossdef>
  </glossentry>

  <glossentry>
   <glossterm>Database server</glossterm>
   <glosssee otherterm="glossary-instance" />
  </glossentry>

  <glossentry id="glossary-database-superuser">
   <glossterm>Database superuser</glossterm>
   <glossdef>
    <para>
     A role having <firstterm>superuser status</firstterm>

Title: PostgreSQL Database Concepts and Terminology
Summary
This section defines several key PostgreSQL concepts and terms. Connection is described as a communication line between client and backend processes. Consistency is explained as a property ensuring data complies with integrity constraints, and is one of the ACID properties. Constraint is defined as a restriction on data values in tables or domain attributes. The Cumulative Statistics System is mentioned as an optional feature for collecting instance activity statistics. The term Database is defined as a named collection of local SQL objects. Database cluster is described as a collection of databases, global SQL objects, and their metadata. The text also clarifies the use of the term 'cluster' in PostgreSQL contexts. Finally, it begins to define Database superuser as a role with superuser status.