Chapter 4. Replicating Geometries
Replication is the process of copying and maintaining data across the different databases in a distributed system. The goal of this chapter is to present a few methods for replicating geometry data. Some of the traditional Oracle replication technologies do not directly support replication of tables with SDO_GEOMETRY
data. The examples given here show alternative ways of replicating tables with the geometry data. Replication does not always mean replicating the same data in different databases. In some cases, it also means copying the data from one database into a different database in a different form, for example, data in
Online Transaction Processing (OLTP) databases can be converted to Online Analytical Processing (OLAP) databases by replicating or combining data from different OLTP tables into a single table in the OLAP system. We will show how to do this conversion of data from a transactional OLTP database to a publication or OLAP database. Starting...