Outline - ENGLISH



19 March 2000

This is a first outline of parts, sections and topics proposed for the IBDH. At present, it's a mix of ideas from several quarters, strongly influenced by an outline prepared last year by Bill Karwin, Markus Kemper, Ann Harrison, Brett Bandy, Paul Beach and Jenny Li.

We now invite you to for what you would like to see included. Please start the email Subject with the word "IB-BOOK" so that the mails can be filtered.

If there is sufficient response to warrant it, feedback messages will be published and linked back to this page.

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


SECTION Understanding client/server methodology
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


Topics from the Lists
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 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