The Firebird Book: A Reference for Database Developers

Throughout this guide, the language examples use the sample database that can be found in the examples directory beneath the Firebird installation root. In the Firebird 1.0.x distribution, its name is employee.gdb. In Firebird 1.5, it is employee.fdb.

Đã lưu trong:

Chi tiết về thư mục
Tác giả chính:	Borrie, Helen
Định dạng:	Sách
Ngôn ngữ:	English
Được phát hành:	Apress 2013
Những chủ đề:	Database Computer
Truy cập trực tuyến:	http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34977
Các nhãn:	Thêm thẻ Không có thẻ, Là người đầu tiên thẻ bản ghi này!

Thư viện lưu trữ:	Thư viện Trường Đại học Đà Lạt

id	oai:scholar.dlu.edu.vn:DLU123456789-34977
record_format	dspace
institution	Thư viện Trường Đại học Đà Lạt
collection	Thư viện số
language	English
topic	Database Computer
spellingShingle	Database Computer Borrie, Helen The Firebird Book: A Reference for Database Developers
description	Throughout this guide, the language examples use the sample database that can be found in the examples directory beneath the Firebird installation root. In the Firebird 1.0.x distribution, its name is employee.gdb. In Firebird 1.5, it is employee.fdb.
format	Book
author	Borrie, Helen
author_facet	Borrie, Helen
author_sort	Borrie, Helen
title	The Firebird Book: A Reference for Database Developers
title_short	The Firebird Book: A Reference for Database Developers
title_full	The Firebird Book: A Reference for Database Developers
title_fullStr	The Firebird Book: A Reference for Database Developers
title_full_unstemmed	The Firebird Book: A Reference for Database Developers
title_sort	firebird book: a reference for database developers
publisher	Apress
publishDate	2013
url	http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34977
_version_	1757678177963999232
spelling	oai:scholar.dlu.edu.vn:DLU123456789-349772014-01-20T01:28:27Z The Firebird Book: A Reference for Database Developers Borrie, Helen Database Computer Throughout this guide, the language examples use the sample database that can be found in the examples directory beneath the Firebird installation root. In the Firebird 1.0.x distribution, its name is employee.gdb. In Firebird 1.5, it is employee.fdb. About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiii Part One Boot Camp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Chapter 1 Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Chapter 2 Network Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Chapter 3 Configuring Firebird . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Chapter 4 Operating Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 Part Two Client/Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 Chapter 5 Introduction to Client/Server Architecture . . . . . . . 75 Chapter 6 Firebird Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Chapter 7 Firebird Clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Part Three Firebird Data Types and Domains . . . . . . . . . . . 111 Chapter 8 About Firebird Data Types . . . . . . . . . . . . . . . . . . . . . . . 113 Chapter 9 Number Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Chapter 10 Date and Time Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 Chapter 11 Character Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 Chapter 12 BLOBs and Arrays . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 Chapter 13 Domains . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191 Part Four A Database and Its Objects . . . . . . . . . . . . . . . . . 205 Chapter 14 From Drawing Board to Database . . . . . . . . . . . . . . . . . . 207 Chapter 15 Creating and Maintaining a Database . . . . . . . . . . . . . 231 Chapter 16 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 261 Chapter 17 Referential Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . 297 Chapter 18 Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 315 Part Five Firebird SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345 Chapter 19 Firebird’s SQL Language . . . . . . . . . . . . . . . . . . . . . . . . . 347 Chapter 20 DML Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353 Chapter 21 Expressions and Predicates . . . . . . . . . . . . . . . . . . . . . . 387 Chapter 22 Querying Multiple Tables . . . . . . . . . . . . . . . . . . . . . . . . 431 Chapter 23 Ordered and Aggregated Sets . . . . . . . . . . . . . . . . . . . . . 467 Chapter 24 Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 485 Part Six Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 503 Chapter 25 Overview of Firebird Transactions . . . . . . . . . . . . . . . 505 Chapter 26 Configuring Transactions . . . . . . . . . . . . . . . . . . . . . . . . 521 Chapter 27 Programming with Transactions . . . . . . . . . . . . . . . . . . . 535 Part Seven Server Programming . . . . . . . . . . . . . . . . . . . . . . . . . . 561 Chapter 28 Introduction to Firebird Programming . . . . . . . . . . . . 563 Chapter 29 Developing PSQL Modules . . . . . . . . . . . . . . . . . . . . . . . . . 573 Chapter 30 Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 601 Chapter 31 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 641 Chapter 32 Error Handling and Events . . . . . . . . . . . . . . . . . . . . . . . 665 Part Eight Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 687 Chapter 33 Security in the Operating Environment . . . . . . . . . . . 689 Chapter 34 Server Protection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 697 Chapter 35 Database-Level Security . . . . . . . . . . . . . . . . . . . . . . . . . 713 Chapter 36 Configuration and Special Features . . . . . . . . . . . . . . 739 Part Nine Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 777 Chapter 37 Interactive SQL Utility (isql) . . . . . . . . . . . . . . . . . . 779 Chapter 38 Database Backup and Restore (gbak) . . . . . . . . . . . . . . 813 Chapter 39 Housekeeping Tool (gfix) . . . . . . . . . . . . . . . . . . . . . . . . 835 Chapter 40 Understanding the Lock Manager . . . . . . . . . . . . . . . . . . 855 Appendices Appendix I External Function Summary . . . . . . . . . . . . . . . . . . . . . . . 881 Appendix II Solving Network Problems . . . . . . . . . . . . . . . . . . . . . . . . 915 Appendix III Application Interfaces . . . . . . . . . . . . . . . . . . . . . . . . . . 923 Appendix IV Database Repair How-to . . . . . . . . . . . . . . . . . . . . . . . . . . 933 Appendix V Administration Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . 937 Appendix VI The Sample Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 943 Appendix VII Firebird Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 945 Appendix VIII Character Sets and Collations . . . . . . . . . . . . . . . . . . . 951 Appendix IX System Tables and Views . . . . . . . . . . . . . . . . . . . . . . . . 957 Appendix X Error Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 981 Appendix XI Reserved Words . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1011 Appendix XII Readings and Resources . . . . . . . . . . . . . . . . . . . . . . . . . 1015 Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1021 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1047 2013-07-25T03:15:10Z 2013-07-25T03:15:10Z 2004 Book 1-59059-279-4 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34977 en application/pdf Apress

The Firebird Book: A Reference for Database Developers

Những quyển sách tương tự