Database technology articles

This section offers a more in-depth view of the Firebird/InterBase® database and how it functions.

• Import & export using IBExpert (1)
• Import & export using IBExpert (2)
• Firebird replicated
• Distributed applications with Firebird
• Using IBExpert and Delphi applications in a Linux environment, accessing Firebird
• Bidirectional replication for InterBase and Firebird

• Firebird Classic server versus Superserver
• Space management in InterBase
• Garbage collectors
• Optimize database cache utilization to improve database performance
• Selecting the right datatype to improve database performance
• The Firebird server and VARCHARs
• Record versions as an undo log
• Request handles
• Multi-generational architecture and record versioning
• Multi-version concurrency control
• Tracking down crashes on Win32 systems
• Tracking down crashes on Linux
• Database corruption
• How to analyse and repair a corrupted database
• Transaction options explained
• The mystery of RDB$DB_KEY
• How to lock a record in InterBase/Firebird
• Conceptual architecture for InterBase/Firebird
• High-level description of the InterBase 6.0 source code
• A cut out and keep guide to the Firebird source code

• character-sets-and-unicode-in-firebird
• Convert your Firebird applications to Unicode

• Generic triggers for InterBase?
• InterBase, Firebird and Blobs -a technical overview
• Stream blobs
• Declarative referential integrity versus triggers
• How to write an internal UDF function
• Using descriptors with UDFs
• Creating UDFs in Delphi
• Implementing a Soundex function

• Structure of a header page
• Structure of a data page
• Where do data pages come from?
• Firebird for the database expert: episode 1 - Indexes
• Firebird for the database expert: episode 2 - Page types
• Firebird for the database expert: episode 3 - On disk consistency
• Firebird for the database expert: episode 4 - OAT, OIT and sweep
• Firebird for the database expert: episode 5 - Locking and record versions

• Database design and database normalization
• Enterprise-wide data model
• Firebird databases as the back-end to enterprise software systems

• Choosing a file system on Linux for Firebird
• Beginners' guide to Firebird and PHP
• Using Apache, PHP and InterBase to develop websites
• InterBase and Java: making the connection
• InterBase and Java: storing and retrieving BLOB data
• Java UDF functional specification
• Using Firebird with Open Office and Windows
• Migration from MS SQL to Firebird