Multi-database Applications - Firebird

Unlike many relational databases, Firebird applications can be connected to more than one database simultaneously. The Firebird client can open and access any number of databases at the same time. Tables from separate databases cannot be joined to return linked sets, but cursors can be used to combine information.

If consistency across database boundaries is required, Firebird can manage output sets from querying multiple databases inside a single transaction. Firebird implements automatic two-phase commit when data changes occur, to ensure that changes cannot be committed in one database if changes in another database, within the same transaction context, are rolled back or lost through a network failure.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Firebird Topics