Multi-database Applications - Firebird
Interview Questions
All Tutorials
Job SearchUnlike 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.
