HP OpenView System Administration Handbook [Electronic resources] : Network Node Manager, Customer Views, Service Information Portal, HP OpenView Operations

Tammy Zitello

نسخه متنی -صفحه : 276/ 153
نمايش فراداده

18.1 DATABASE TERMINOLOGY

  • Archive log mode Keep copies of all transactions from the redo logs.

  • Cold backup Shuts down the database prior to performing a backup.

  • Control file Used to test the database integrity during startup.

  • Database Program that manipulates one or more data files.

  • Data dictionary Tables and views that are a read-only database reference.

  • Data warehouse Repository of data about related objects.

  • Hot backup Database is running while performing a backup.

  • Instance A set of server processes that has its own

    Shared Global Area (SGA), an area of shared memory.

  • Index Mini copy of table entries used for rapid access to the data.

  • Non-arvhive log mode No save of redo log before it is overwritten.

  • Redo logs Keep track of database changes.

  • System Identifier (SID) Identifies each database interface.

  • Table A database object that holds the data.

  • Tablespace A collection of one or more datafiles.

  • Transaction Sequence of SQL statements that manipulate the database.

  • View A custom presentation of the database table information.

  • Import and export Used to perform logical backup and recovery of database objects. Allows extraction of database objects into flat files that can be stored or moved to another database.