| PART I |
KNOW THY DATABASE |
| SECTION |
Creating Robust Metadata |
| Topic 1: |
Thinking about design |
| Topic 2: |
Creating a concrete foundation |
| Topic 3: |
Designing for database replication |
| Topic 4: |
Using domains and datatypes |
| Topic 5: |
Creating data for international databases |
| Topic 6: |
Building intelligence with constraints and triggers |
| Topic 7: |
Manipulating data with stored procedures |
| Topic 8: |
Controlling access with SQL privileges |
| Topic 9: |
Optimizing data access with indexes |
| Topic 10: |
Extending the server with UDFs |
| Topic 11: |
Communicating with the client: Events and Exceptions |
| Topic 12: |
Importing and exporting text records using external files |
| SECTION |
Runtime Issues |
| Topic 1: |
Optimizing the server platform |
| Sub-Topic (1a): |
Windows |
| Sub-Topic (1b): |
Linux |
| Sub-Topic (1c): |
Solaris |
| Sub-Topic (1d): |
**nix |
| Sub-Topic (1e): |
Novell Netware |
| Topic 2: |
Configuring and testing the network |
| Sub-Topic (2a): |
TCP/IP |
| Sub-Topic (2b): |
Windows Networking |
| Sub-Topic (2c): |
IPX/SPX |
| Sub-Topic (2d): |
Mixed protocols |
| Topic 3: |
Understanding InterBase system tables |
| Topic 4: |
Securing the server |
| Topic 5: |
Encrypting a client/server system |
| Topic 6: |
Performing database maintenance |
| Topic 7: |
Using the Services API |
| Topic 8: |
Testing under load |
| SECTION |
Troubleshooting InterBase Clients and Servers |
| Topic 1: |
Determining a cause for a problem |
| Topic 2: |
Diagnosing error reports |
| Sub-Topic (2a): |
Errors in interbase.log |
| Sub-Topic (2b): |
Errors from the database (Events, Exceptions, BDE, IBObjects) |
| Topic 3: |
Diagnosing installation problems |
| Topic 4: |
Diagnosing performance problems |
| Topic 5: |
Diagnosing crash and corruption problems |
| Topic 6: |
Diagnosing memory leaks |
| Topic 7: |
Diagnosing network problems |
| SECTION |
Deploying InterBase Applications |
| Topic 1: |
Distributing & licensing |
| Topic 2: |
Installing & uninstalling |
| Topic 3: |
Updating after deployment |
| SECTION |
The Way InterBase Works |
| Topic 1: |
The on-disk structure and BLR |
| Topic: |
The Y-valve |
| Topic 3: |
The Lock manager |
| Topic 4: |
Versioning and multi-generational architecture |
| Topic 5: |
Transactions |
| Topic 6: |
Classic vs Superserver |
| Topic 7: |
The life of a SQL request |
| Topic 8: |
Internals of the Active Database |
| Topic 9: |
What Sweeps and Backups do
|
| PART II |
WRITING CLIENT APPLICATIONS |
| SECTION |
Understanding client/server methodology |
| SECTION |
The InterBase API |
| SECTION |
Selecting the client interface |
| Topic 1: |
Delphi, Borland C++ Builder and BDE |
| Topic 2: |
Delphi, Borland C++ Builder and the Interbase API |
| Topic 3: |
Delphi for Linux |
| Topic 4: |
Visual C for Windows |
| Topic 5: |
GNU C for Linux |
| Topic 6: |
IBPerl for Linux |
| Topic 7: |
JDBC and Ultra-thin Clients |
| Topic 8: |
Visual Basic (???) |
| SECTION |
Extending InterBase with multiple tiers |
| Topic 1: |
MIDAS |
| Topic 2: |
Visibroker |
| Topic 3: |
InterServer and InterClient |
| Topic 4: |
dbOvernet |
| SECTION |
Using transactions |
| SECTION |
Calling stored procedures |
| SECTION |
Writing multi-threaded clients safely |
| SECTION |
Using events for client notification |
| SECTION |
Handling errors gracefully |
| SECTION |
Optimizing query plans |
| SECTION |
Understanding InterBase Data Access Components |
| SECTION |
Internationalizing client applications |
| SECTION |
Developing Internet solutions |
| SECTION |
Writing applications for Replication |
| SECTION |
Integrating with the Open Source World |
| Topic 1: |
Apache Web Server |
| Topic 2: |
Enhydra |
| Topic 3: |
HP E-Speak |
| Topic 3: |
XML and XSL
|
| PART III |
SOLVING REAL-WORLD PROBLEMS
Topics from the Lists |
| SECTION |
SQL |
| SECTION |
Server-side tricks |
| SECTION |
Client-side tricks |
| SECTION |
Tuning and load balancing |
| SECTION |
Bugs and workarounds |
| SECTION |
Load Testing Techniques |
| SECTION |
Recovering corrupted data |
| SECTION |
Avoiding corruptions |
| SECTION |
FAQ
|
| PART IV |
APPENDIX |
| SECTION |
Working with Data from Another DBMS |
| Topic 1: |
Importing and exporting data |
| Topic 2: |
Converting Oracle databases to InterBase |
| Topic 3: |
Converting Microsoft SQL Server databases to InterBase |
| Topic 4: |
Converting XBASE and Paradox databases to InterBase |
| Topic 5: |
Understanding legacy databases |
| SECTION |
Using CASE tools |
| SECTION |
Design and Documentation Techniques |
| SECTION |
Using the Free Tools Shipped on the CD |
| SECTION |
Our Best Anecdotes |
