Glossary

Definitions of terms related to Replication Server Data Assurance Option.

Adaptive Server – the Sybase version 11.5 and later relational database server. If you choose the RSSD option when configuring Replication Server, Adaptive Server maintains Replication Server system tables in the RSSD database.
DA agent – fetches and compresses data from databases into the DA server.
comparesets – sets of tables and columns that define what is being compared in a particular job.
connection profiles – information required to establish a database connection.
database – a set of related data tables and other objects that are organized and presented to serve a specific purpose.
Data Assurance System Database (DASD) – the DA server database that stores system and configuration settings.
Data Transfer Stream (DTS) – an application protocol used by DA agent during a comparison to stream data.
Hypertext Transfer Protocol (HTTP) – the communications protocol used to connect to Web servers on the Internet or on a local area network.
Java Database Connectivity (JDBC) – is a specification for an application program interface (API) that allows Java applications to access multiple database management systems using Structured Query Language (SQL).
jConnect – the Sybase high-performance JDBC driver.
jobs – a collection of one or more comparison tasks.
inconsistent row – a table row that is present both in primary and replicate databases, but has different values for one or more of the columns being compared.
local area network (LAN) – a system of computers and devices, such as printers and terminals, connected by cabling for the purpose of sharing data and devices.
missing row – a table row that is present in the primary, but not in the replicate database.
orphaned row – a table row that is present in the replicate, but not in the primary database.
parameter – an identifier representing a value that is provided when a procedure executes. Parameter names are prefixed with an @ character in function strings.
primary key – a set of table columns that uniquely identifies each row.
quoted identifiers – object names that contain special characters such as spaces and non-alphanumeric characters, start with a character other than alphabet, or correspond to a reserved word and need to be enclosed in quote (single or double) characters to be parsed correctly.
reconciliation – the process of updating the target database tables to match with the source database tables.
replication – a process by which the changes to the data in one database—including creation, updating, and deletion of records—are also applied to the corresponding records in another database.
Remote Method Invocation (RMI) – is a remote procedure call used for communication between DA server and DA agents.
Replication Server – the Sybase server program that maintains replicated data, typically on a LAN, and processes data transactions received from other Replication Servers on the same LAN or on a WAN.
Replication Server Data Assurance Option – the Sybase server program that compares row data and schema between two or more Adaptive Server databases, and reports discrepancies.
Replication Server System Database (RSSD) – the Adaptive Server database containing a Replication Server system tables. You can choose whether to store Replication Server system tables on the RSSD or the SQL Anywhere® ERSSD.
row comparison job – is a job used for row comparison.
schema – the structure of the database.
schema comparison job – is a job used for comparing database object schemas.
Tabular Data Stream™ (TDS) – is an application protocol by which Open Client™ and Open Server™ applications exchange information.
wide area network (WAN) – a system of local area networks connected together with data communication lines.