Complete Materialization

You are looking at an older version of the documentation. The latest version is found here.

Materialization, or complete replication, is the simplest type of replication. It creates a copy of the source objects in the analytical storage, and all changes in the source are applied to the materialized table with each subsequent running of the job.

It is also very easy to set up: you only need to create the job and add a schedule, or run it manually.

Internally, the Data Virtuality Server manages the table to be queried when a statement is executed against the source. If any rows in the source are altered or removed, these changes are visible as soon as the replication has been rerun.

The Data Virtuality Server also keeps older versions in case there is some problem with a materialized table, and there is an automatic fallback to the last working state of the table. It is possible to find out which table corresponds with a specific view or table that uses complete replication, but in general, there is no need to do that.

Setting Up Complete Materialization

To create a new complete replication job in the Data Virtuality Studio:

1. Go to the Optimizations tab (icon with light bulb).

2. Right-click on the view or table to be stored as a local copy.

3. Select 'Create replication job' from the context menu.

4. Click the 'Complete' tab and then click 'OK'.

The first run creates a local copy of the source which will be updated in case of any changes to the source when the job is rerun, automatically or manually.

One drawback of complete materialization is that the job runtime may be very long if the source is very large. We recommend setting up schedules with reasonable time frames to avoid permanent network load or machine load for a single replication and to consider using the more efficient incremental materialization.