The Firebird Book: A Reference for Database Developers
by:
Helen Borrie
|
On-line Price:
$84.00 (includes GST)
Paperback package 1092
20%Off Retail Price
You
save: $21.00
_____________________
N.Sydney : On Order (reserve your copy)
|
Retail Price:
$105.00
Publisher:
APRESS,2004/08/04
Category:
DATABASE TECHNOLOGY Level:
ISBN: 1590592794
ISBN13: 9781590592793
|
| Add to Shopping Cart |
Although less publicized than other open source database management systems, Firebird continues to gain a dedicated following of professional users. Figures have already reached hundreds of thousands worldwide, in Firebird's short three-year history in open source. And until now, no other book has been available.
This is the first, official book on Firebird--the free, independent, open source relational database server that emerged in 2000. Based on the actual Firebird Project, this book will provide you all you need to know about Firebird database development, like installation, multi-platform configuration, SQL language, interfaces, and maintenance.
This comprehensive guide will help you build stable and scalable relational database back-ends for all sizes of client/server networks. The text is well-stocked with tips, code examples, and explanations to reinforce the material covered. This book concentrates on Firebird edition 1.5--complete with updated language, security and optimization features--without neglecting the needs of Firebird 1.0 users.
Author Information
Helen Borrie - Helen Borrie is a database and application developer, a member of the Firebird project team, and a former journalist who doubles as a technical writer. She is a frequent contributor to support lists for Firebird, InterBase, and Delphi database programming.
Table of Contents
Introduction to Firebird
Part One: Firebird Boot Camp
Chapter 1: Installation
Chapter 2: Network Setup
Chapter 3: Configuring Firebird
Chapter 4: Operating Basics
Part Two: Understanding Client/Server
Chapter 5: Introduction to Client/server Architecture
Chapter 6: Firebird Server
Chapter 7: Firebird clients
Part Three: Data Types and Domains
Chapter 8: About Firebird Data Types
Chapter 9: Number types
Chapter 10: Date and Time Types
Chapter 11: Character Types
Chapter 12: BLOBs and Arrays
Chapter 13: Domains
Part Four: A Firebird Database and its Objects
Chapter 14: From Drawing board to Database
Chapter 15: Creating and Maintaining a Database
Chapter 16: Tables
Chapter 17: Referential Integrity
Chapter 18: Indexes
Part Five: Firebird SQL
Chapter 19: Types of SQL Statements
Chapter 20: Queries
Chapter 21: Expressions and Predicates
Chapter 22: Querying Multiple Tables
Chapter 23: Ordered and Aggregated Sets
Chapter 24: Views and Other Derived Tables
Part Six: Transactions and Concurrency
Chapter 25: Overview of Firebird Transactions
Chapter 26: Record Versions, Concurrency and Isolation Levels
Chapter 27: Programming with Transactions
Part Seven: Programming on the Server
Chapter 28: Introduction to Firebird Programming
Chapter 29: Developing PSQL Modules
Chapter 30: Stored Procedures
Chapter 31: Triggers
Chapter 32: Error Trapping and Handling
Chapter 33: Events
Chapter 34: External Code Modules
Part Eight: Security
Chapter 35: Securing the Operating Environment
Chapter 36: Server Access Protection
Chapter 37: Database-level Security
Part Nine: Tools
Introduction: Summary of Firebird's Command-line Tools
Chapter 38: Interactive SQL Utility (isql)
Chapter 39: Database Backup and Restore (gbak)
Chapter 40: Housekeeping Tool (gfix)
Chapter 41: Server Statistics Tools
Glossary
Appendices
Appendix I: SQL Statements Summary
Appendix II: Migrating to Firebird
Appendix III: Implementing Auto-incrementing Keys
Appendix IV: Solving Network Problems
Appendix V: Application Interfaces
Appendix VI: Database Repair How-To
Appendix VII: Administration Tools
Appendix VIII: Sample Databases
Appendix IX: Character Sets and Collations
Appendix X: System Tables
Appendix XI: Error Codes
Appendix XII: Reserved Words
Appendix XIII: Firebird Limits
|
