资料整理——Oracle基本概念、术语（Glossary from Oracle Concepts）——第一部分

资料来源：

https://docs.oracle.com/database/121/CNCPT/toc.htm

中文部分为本人的翻译，仅供参考。

概念	中文	描述
access driver	访问驱动程序	In the external table infrastructure, the API that interprets the external data for the database. The access driver runs inside the database, which uses the driver to read the data in the external table.
access path	访问路径	The means by which data is retrieved from a database. For example, a query using an index and a query using a full table scan use different access paths.
ACID properties	ACID属性	The basic properties of a database transaction that all Oracle Database transactions must obey. ACID is an acronym for atomicity, consistency, isolation, and durability.
active online redo log file	在线活动重做日志文件	An online redo log file that may contain data that is required for database instance recovery.
active session	活动会话	A database session that is using CPU and is not waiting for an event in the idle wait class.
ASH (Active Session History)	活动会话历史	A part of the database self-management framework that samples active database sessions each second, writing the data to memory and persistent storage.
active transaction	活动事务	A transaction that has started but not yet committed or rolled back.
adaptive query optimization	适应性查询优化	A set of capabilities that enables the adaptive optimizer to make run-time adjustments to execution plans and discover additional information that can lead to better optimizer statistics. Adaptive optimization is helpful when existing statistics are not sufficient to generate an optimal plan.
ADDM (Automatic Database Diagnostic Monitor)	数据库自动诊断监视程序	An Oracle Database infrastructure that enables a database to diagnose its own performance and determine how identified problems could be resolved.
ADR (Automatic Diagnostic Repository)	自动诊断仓库	A file-based hierarchical data store for managing information, including network tracing and logging.
ADR base	ADR根目录	The ADR root directory. The ADR base can contain multiple ADR homes, where each ADR home is the root directory for all diagnostic data—traces, dumps, the alert log, and so on—for an instance of an Oracle product or component.
ADR home	ADR home	The root directory for all diagnostic data—traces, dumps, the alert log, and so on—for an instance of an Oracle product or component. For example, in an Oracle RAC environment with shared storage and Oracle ASM, each database instance and each Oracle ASM instance has its own ADR home.
advanced index compression	高级索引压缩	An extension of prefix compression that exploits shared intra-column level prefixes, duplicate key elimination, and rowid compression.
aggregate function	聚合函数	A function such as COUNT that operates on a group of rows to return a single row as a result.
alert log	警告日志	A file that provides a chronological log of database messages and errors. The alert log is stored in the ADR.
analytic function	分析函数	A function that operates on a group of rows to return multiple rows as a result.
analytic query	分析查询	A "what if" query that answers a business question. Typically, analytic queries involve joins and aggregation, and require scanning a very large amount of input data to produce a relatively small amount of output.
antijoin	反连接	A join that returns rows from the left side of the predicate for which there are no corresponding rows on the right side of the predicate.
application architecture	应用架构	The computing environment in which a database application connects to an Oracle database. The two most common database architectures are client/server and multitier.
application context	应用背景	An attribute name-value pair in a specified namespace. Applications set various contexts before executing actions on the database.
Application Continuity	应用连续性	A feature that enables the replay, in a nondisruptive and rapid manner, of a request against the database after a recoverable error that makes the database session unavailable.
application domain index	应用域索引	A customized index specific to an application.
application server	应用服务器	Software that provides an interface between the client and one or more database servers, and hosts the applications.
archived redo log file	存档重做日志	A member of the online redo log that has been archived by Oracle Database. The archived redo log files can be applied to a database backup in media recovery.
ARCHIVELOG mode	存档日志模式	A mode of the database that enables the archiving of the online redo log.
archiver process (ARCn)	存档进程	The background process that archives online redo log files.
archiving	存档	The operation of generating an archived redo log file.
ascending index	升序索引	An index in which data is stored in ascending order. By default, character data is ordered by the binary values contained in each byte of the value, numeric data from smallest to largest number, and date from earliest to latest value.
attribute-clustered table	属性聚合表	A heap-organized table that stores data in close proximity on disk based on user-specified clustering directives.
audit trail	审计跟踪	A location that stores audit records.
automatic memory management	自动内存管理	The mode in which Oracle Database manages the SGA and instance PGA memory completely automatically.
ASSM (automatic segment space management)	自动段空间管理	A method of storage space management that uses bitmaps to manage segment space instead of free lists.
automatic undo management mode	自动撤销管理模式	A mode of the database in which it automatically manages undo space in a dedicated undo tablespace. See also manual undo management mode.
AWR (Automatic Workload Repository)	自动负载仓库	A built-in repository in every Oracle database. Oracle Database periodically makes a snapshot of its vital statistics and workload information and stores them in AWR.
autonomous transaction	自治事务	A independent transaction that can be called from another transaction, called the main transaction.
AWR baseline	AWR基准	A collection of statistic rates usually taken over a period when the system is performing well at peak load
AWR snapshot	AWR快照	A set of performance statistics captured in AWR at a specific time.
B-tree index	B-tree索引	An index organized like an upside-down tree. A B-tree index has two types of blocks: branch blocks for searching and leaf blocks that store values. The leaf blocks contain every indexed data value and a corresponding rowid used to locate the actual row. The "B" stands for "balanced" because all leaf blocks automatically stay at the same depth.