Glossary

agent

See Oracle GoldenGate Veridata Agent.

client

An interface to Oracle GoldenGate Veridata Server, from which you configure or execute comparison work. Oracle GoldenGate Veridata provides a GUI client named Oracle GoldenGate Veridata Web and a command client named vericom, which provides a subset of the functions that can be performed from the web interface.

column mapping

An Oracle GoldenGate Veridata Web configuration object that establishes the correct structural relationship between the source and target objects in a compare pair.

compare group

See group.

compare pair

A configuration object in Oracle GoldenGate Veridata Web that associates one source table or file with one target table or file for the purpose of comparing their data. The source table typically contains data that is known or presumed to be up-to-date and accurate. The target table is a different table which contains identical data, such as a backup, that is synchronized with that of the source by some mechanism, such as replication.

comparison format

A standardized format to which Oracle GoldenGate Veridata transforms the native data type of a column. The use of standardized formats enables Oracle GoldenGate Veridata to support heterogeneous comparisons (those between different types of databases) where source and target data types are different, but similar.

comparison report

A report that is created at the conclusion of a comparison that contains information about the objects that were compared, the number of rows that are out-of-sync, and statistics about performance.

confirmation step or confirm-out-of-sync (COOS) step

A follow-up comparison that is performed after the initial comparison step to confirm a row's status as in-sync or perpetually out of synchronization. The confirmation step waits until after a specified replication latency threshold has expired, to give a replication mechanism time to post any change that was in-flight.

connection

A configuration object in Oracle GoldenGate Veridata Web that stores information about how the Oracle GoldenGate Veridata Server process will connect to a Veridata Agent process. It consists of a DNS host name or IP address, a Manager port number, and a data source type.

data source

A set of stored data, such as a relational or hierarchical database.

delta processing

A performance feature that Oracle GoldenGate Veridata supports on the NonStop platform by which Oracle GoldenGate Veridata detects which data blocks in the database were modified since a previous comparison and only compares the rows in those blocks. Rows in unchanged blocks are skipped.

digital signature

A message signed with a private key that can be verified by a person or process that has the public key, thereby proving that the message is unchanged and authentic.

GGSCI

The command line interface to the Oracle GoldenGate replication software, which also is used as the command interface to the Manager process of the Oracle GoldenGate Veridata Agent.

GLOBALS file

A parameter file that is required on some platforms where Oracle GoldenGate Veridata Agent is installed. It stores parameters that may be required in some installation conditions.

group

A configuration object in Oracle GoldenGate Veridata Web that is a logical container for one or more compare pairs (sets of related source and target tables) and their associated data source connections.

hash

A method of converting data into a unique numeric value (hash value) by substituting or transposing the data. If two hash values are different, then the degree of certainty that the two original input values are identical is extremely high (but not absolute). To be absolutely certain that values are identical, you can use a literal comparison.

in-flight

One of the possible states of a row during a comparison. The target row was out-of-sync in the initial comparison step, but was since updated and still do not match those of the source.

in-sync

One of the possible states of a row during comparison. The target row values match the source values that were retrieved during the initial comparison step.

initial comparison step, or row-hash step

The first step in a comparison, in which rows are retrieved from the source and target tables with a query and then compared. Target rows that appear to be out-of-sync are stored in a maybe out-of-sync (MOOS) queue in memory. The rows will be assessed further by the confirmation step.

install

A program that is used on Windows platforms to install Oracle GoldenGate Veridata programs as a Windows service.

job

A unit of work that is linked to one or more compare groups that are processed together.

key, or key columns

A unique identifier that Oracle GoldenGate Veridata uses to order rows for comparison. This could be a primary key, a unique index, or a user-defined identifier.

latency

The difference in time between when a change is made to source data and when that change is reflected in the target data.

literal comparison

A comparison that is performed value for value, as opposed to a comparison that uses a hash.

Manager

Coordinator program of the Oracle GoldenGate Veridata Agent component. It coordinates requests sent to the agent process by the Oracle GoldenGate Veridata Server process.

Maybe-out-of-sync queue, or MOOS queue

A section of memory that stores rows that were determined to be out-of-sync in the initial comparison step, until they can be confirmed as in-sync or out-of-sync in the confirmation step.

Oracle GoldenGate Veridata Agent

Runs on the system where a source or target database resides. It fetches and returns blocks of rows, determines whether rows are out-of-sync, returns column-level detail, and executes requests on the database. The agent is started at the request of the Oracle GoldenGate Veridata Server and is controlled by the Oracle GoldenGate Veridata Manager process.

Oracle GoldenGate Veridata Server

The comparison engine that coordinates Oracle GoldenGate Veridata tasks, compares data, confirms out-of-sync data, and produces reports. Row sorting also can be performed by the server if the server-side sorting option is selected.

out-of-sync

The data values in a source row are not identical to those of the corresponding target row.

out-of-sync report

A report that is created at the conclusion of a comparison that provides summary and column-level details about out-of-sync rows and the operations that are needed to bring them back into synchronization.

partition

A selection criteria that is defined within Oracle GoldenGate Veridata Web or the vericom interface, which enables comparisons to be performed against a subset of the rows in a table or file.

persistently out-of-sync

One of the possible states of a row during comparison. During the confirmation step, the target values have not changed since the initial comparison step and still are not the same as those of the source.

profile

A configuration object in Oracle GoldenGate Veridata Web that is a stored set of global processing parameters, each containing unique settings for a specific purpose.

replication

The process of duplicating sets of data to one or more other locations in near real-time for such purposes as recovery or decision support.

repository

A collection of database objects that persists configuration information created by Oracle GoldenGate Veridata Web users to disk, saving it permanently as a user environment.

row partition

See partition.

row-hash step

See initial comparison step.

server

See Oracle GoldenGate Veridata Server.

server-side sorting

The sorting of source and target rows for comparison when performed by Oracle GoldenGate Veridata Server.

source

The database or location that is trusted to contain the most accurate and current version of data in an environment that contains replica versions of that data.

target

A database or location that contains a secondary or replica set of data that corresponds to a primary, or source, set of data.

validation

Performed by Oracle GoldenGate Veridata to test source and target table structures for compatibility.

vericom

The command line interface to Oracle GoldenGate Veridata.