Remote DBA Plans
Remote DBA Service

Oracle Tips

by Burleson Consulting

The Data Warehouse Development Life Cycle

Distributed Oracle Data Warehouses Oracle Domains And Location Transparency

Many Oracle warehouse designers recognize the need to track the locations of remote databases while, at the same time, provide location transparency to end users and programmers. Oracle domains are especially important in situations of horizontal partitioning, where tables with identical names are kept at numerous locations. Domains establish a logical hierarchy of physical locations for an enterprise. The sample database depicted in Figure 9.7 shows how a domain hierarchy can be established for remote databases.

Figure 9.7 An Oracle TNS domain name hierarchy.

Each database in a distributed federation can have a synonym assigned for all unique tables within the distributed network. In situations where duplicate table structures exist at many locations, abbreviated domains can be created. For example, assume that both Japan and Ohio have a CUSTOMER table, identical in structure but containing different rows. We could assign Oracle synonyms as follows:

CREATE SYNONYM georgia_customer FOR
customer@georgia;

CREATE SYNONYM arizona_customer FOR
customer@arizona;

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.

You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.