A publication is a definition of a set of data to be downloaded from the master database to a subscribing replica database. It is completely separated from the transactions that change the data. Note that “traditional” replication methods typically rely on sending transactions (inserts, updates, and deletes) from master to replicas, but solidDB® instead sends a snapshot of the updated data to the replicas.
Advanced replication publication definitions may include:
▪Data from one or multiple tables
You can define relations between the tables of a publication
▪All or subset rows of a table
A publication can contain a normal SELECT statements for selecting data for a publication
By limiting a subset row of tables with parameters, you can specify fixed or dynamic search criteria for the publication
▪All or defined columns of a table
A publication can contain normal SELECT statement for selecting columns for a publication
▪Full or incremental data
A full publication sends all data contained in a publication. An incremental publication sends only data that has changed since the previous refresh.
Note To save resources and increase performance, we recommend that you use incremental publications. You must set up tables for incremental publication before creating the actual publication: see Creating incremental publications.