Corporate Rollup

The corporate rollup model has distributed primary fragments and a single, centralized consolidated replicate table.

The table at each primary site contains only the data that is primary at that site. No data is replicated to these sites. The corporate rollup table is a “roll-up” of the data at the primary sites.

This figure illustrates the flow of data for a corporate rollup application model:

Distributed Primary Fragments with Corporate Rollup

Figure 1-5 illustrates the flow of data for a corporate roll up application model. It has distributed primary fragments in Chicago, New York, and San Francisco and a single, centralized consolidated replicate table in the headquarters. The table at the three sites contains only the data that is primary at that site. The corporate roll up table in the headquarters is a roll up of the data at the primary sites.

The corporate rollup model requires distinct replication definitions at each primary site. The site where the data is consolidated subscribes to the replication definition at each primary site.

Creating a Corporate Rollup Application
You can create a corporate rollup application from distributed primary fragments.

Parent topic: Other Distributed Data Models