Working with Database Links |
|
DBMaker effectively links multiple client applications and multiple database servers. Each client has a direct connection to a single database server, which is known as the Coordinator Database to that client. Through the Coordinator Database, the client can connect to other remote databases, which are also known as Participant Databases. You can access a remote database by using database links defined in the Coordinator Database. A database link creates a connection to a remote database, and contains the login information and password necessary for connecting to the remote database. This allows you to connect to a remote database with a different user name than you are using in the Coordinator Database, or to connect to a remote database where you do not have an account but can still connect using a public link. It also makes data in a distributed database environment location transparent. The link definition, which also contains the login information and password, is stored in the Coordinator Database. Database links are also useful for the management of synchronous table replication, and can be used to define the connection between source and destination tables.
Related topic:
Synchronous
Table Replication
Creating a Database Link
Dropping a Database Link