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 replica databases, but solidDB instead sends a snapshot of the updated data to the replica databases.
Advanced Replication publication definitions can include:
▪ Data from one or multiple tables
You can define relationships between the tables of a publication.
▪ All rows (or a subset of rows) of a table
A publication can contain a normal SELECT statement 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 a normal SELECT statement for selecting columns for a publication.
▪ Full or incremental data
A full publication sends all data that is contained in a publication. An incremental publication sends only data that has changed since the previous refresh.
Note To save resources and increase performance, it is recommended that you use incremental publications. You must set up tables for incremental publication before creating the actual publication: see Creating incremental publications.