Database technology articles
This section offers a more in-depth view of the Firebird/InterBase® database and how it functions.
| IBExpert & Firebird/InterBase® |
| The Firebird/InterBase® server |
- 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
| Firebird/InterBase® character sets & collations |
| Working with Firebird/InterBase® |
| Firebird/InterBase® ODS (On Disk Structure) |
- 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
- Firebird for the database expert: episode 6: Why can't I shrink my databases
| Database development |
| Miscellaneous database articles |
- 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
back to top of page
<< Basic introduction to the Firebird Security Database, port redirection and multi-instances | Documentation | White Paper: Identify unusually high database load: take two >>
Any comments? Send an email to register@ibexpert.biz
COPYRIGHT © 2002-2024 HK-Software, IBExpert Ltd. All rights reserved.
All IBExpert brand and product names are trademarks or registered trademarks of IBExpert Ltd in Malta and other countries. InterBase, Delphi, CodeGear, C++Builder, Delphi/400, Delphi for PHP and JBuilder are trademarks or registered trademarks of Embarcadero Technologies Inc. in the United States and other countries. Firebird is a registered trademark of the FirebirdSQL Foundation. Turbo Pascal is a registered trademark of Borland International, Inc. Sun, Java, JavaScript and Solaris are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and other countries. UNIX is a registered trademark in the United States and other countries, exclusively licensed through “The Open Group”. Oracle is a registered trademark of Oracle Corporation in the United States and other countries. All Microsoft brand and product names are trademarks or registered trademarks of Microsoft Corporation in the United States and other countries. AS/400, DB2, IBM, Informix and iSeries are trademarks or registered trademarks of IBM Corporation in the United States and other countries. Linux is a registered trademark of Linux Torvalds. dBASE is a trademark of dataBased Intelligence, Inc. All other product names mentioned herein and throughout the entire web site are trademarks of their respective owners.
