Practical Issues in Database Management: A Reference for the Thinking Practition
Fabian Pascal
- 出版商: Addison Wesley
- 出版日期: 2000-05-23
- 售價: $1,660
- 貴賓價: 9.5 折 $1,577
- 語言: 英文
- 頁數: 288
- 裝訂: Paperback
- ISBN: 0201485559
- ISBN-13: 9780201485554
-
相關分類:
資料庫
已絕版
買這商品的人也買了...
-
GoLive CyberStudio 3.1 for Macintosh: Visual QuickStart Guide (Paperback)$960$912 -
$590MySQL and mSQL -
Practical Internet Groupware (Paperback)$1,240$1,178 -
PHP Pocket Reference$630$599 -
Jini in a Nutshell$1,240$1,178 -
$399The Guru's Guide to Transact-SQL (Paperback) -
Software Architecture for Product Families: Principles and Practice$1,830$1,739 -
Learning Java$1,540$1,463 -
Debugging Perl: Troubleshooting for Programmers$1,570$1,492 -
JavaServer Pages$1,540$1,463 -
$299XML in a Nutshell: A Desktop Quick Reference (Paperback) -
$280Mod_Perl Pocket Reference (Paperback) -
高流量網站應用程式開發秘笈 (Designing for Scalability with Microsoft Windows DNA)$650$650 -
Director 8 Primer$1,490$1,416 -
FreeHand 10 中文版繪圖新視代$680$612 -
Learning Unix for Mac OS X$940$893 -
Java 設計模式實作 (Design Patterns Java Workbook)$560$448 -
CorelDRAW 11 中文版繪圖 VS 動畫大作戰$550$435 -
JBuilder 實用技術手冊 (第二版)$600$474 -
鳥哥的 Linux 私房菜－伺服器架設篇$750$675 -
鳥哥的 Linux 私房菜─基礎學習篇增訂版$560$504 -
Unix 超級工具(上冊) + Unix 超級工具(下冊) (A015+A016)$880$695 -
Perl 食譜(上) + Perl 食譜(下)增訂版 (A097+A085)$760$600 -
Perl 學習手冊, 3/e + Perl 程式設計, 2/e(A100+A017)$760$600 -
Java 技術手冊第三版 + Java 經典範例第二版 (A069+A104)$1,050$830
商品描述
Description
This book addresses the core, commonly recurring issues and problems that even the most experienced database professionals—seem to systematically misunderstand, including: unstructured data and complex datatypes, business rules and integrity enforcement, data hierarchies and recursive queries, redundancy. Fabian Pascal examines these critical topics thoroughly, comparing the severe costs of mishandling them to the practical benefits of implementing the correct solutions. With an emphasis on both principles and practice, this book employs numerous examples to provide an assessment of current technology—SQL and the DBMS products based on it—and, whenever possible, offers concrete recommendations and workarounds. 
Advanced Topics in Database, Database Management and Design, Database Design.
Table Of Contents
Foreword.Preface.
1. Careful What You Wish For: Data Types and Complexity.
The Issue.
Fundamentals.
Practical Implications.
Conclusion and Recommendations.
Appendix 1A: Possible Representations for Image Types.
Appendix 1B: Graphics File Follies.
Appendix 1C: Biometric Tools Ready to Take Off.
Appendix 1D: Search Engine Failures.
Appendix 1E: “Complex” Types and Operators: An Internet Illustration.
Appendix 1F: Java and Database Synergy.
Fundamentals.
“Simple” Types.
System-Defined Types.
User-Defined Types.
Data Type Support.
On Type “Atomicity.”
“Complex” Types.
System-Defined Types.
User-Defined Types.
Data Type Support.
On Type “Atomicity.”
“Complex” Types.
Practical Implications.
Relational Domains versus Object Classes.
Database Design.
Relational Structure versus Object Manipulation.
DBMS Implementation.
“Domains.”
“Universal” DBMSs.
Database Design.
Relational Structure versus Object Manipulation.
DBMS Implementation.
“Domains.”
“Universal” DBMSs.
Conclusion and Recommendations.
Appendix 1A: Possible Representations for Image Types.
Appendix 1B: Graphics File Follies.
Appendix 1C: Biometric Tools Ready to Take Off.
Appendix 1D: Search Engine Failures.
Appendix 1E: “Complex” Types and Operators: An Internet Illustration.
Appendix 1F: Java and Database Synergy.
2. The Rule of Rules: Integrity.
The Issue.
Fundamentals.
Practical Implications.
Conclusion and Recommendations.
Appendix 2A: A Note on SQL's OVERLAPS Operator.
Fundamentals.
Business Rules.
Integrity Constraints.
Domain Constraints.
Column Constraints.
Table Constraints.
Database Constraints.
Database Correctness.
Base versus Derived Constraints.
Integrity Enforcement.
Integrity Rules.
DBMS Support.
Integrity Constraints.
Domain Constraints.
Column Constraints.
Table Constraints.
Database Constraints.
Database Correctness.
Base versus Derived Constraints.
Integrity Enforcement.
Integrity Rules.
DBMS Support.
Practical Implications.
SQL and Integrity.
Domain Rules.
Column Rules.
Table and Database Rules.
Procedural Support.
Domain Rules.
Column Rules.
Table and Database Rules.
Procedural Support.
Conclusion and Recommendations.
Appendix 2A: A Note on SQL's OVERLAPS Operator.
3. A Matter of Identity: Keys.
The Issue.
Fundamentals.
Practical Implications.
Conclusion and Recommendations.
Fundamentals.
Simple versus Composite Keys.
Natural versus Surrogate Keys.
Candidate versus Primary Keys.
Foreign Keys.
Referential Integrity and Primary Keys.
DBMS Support.
Natural versus Surrogate Keys.
Candidate versus Primary Keys.
Foreign Keys.
Referential Integrity and Primary Keys.
DBMS Support.
Practical Implications.
SQL and Keys.
Conclusion and Recommendations.
4. Don't Get Duped by Dupes: Duplicate Rows.
The Issue.
Fundamentals.
Practical Implications.
Conclusion and Recommendations.
Appendix 4A: Duplicate Removal in SQL.
Appendix 4B: Language Redundancy and Duplicates.
Fundamentals.
Determining Entity Types.
“Hidden” Information.
A Relational Bonus.
“Hidden” Information.
A Relational Bonus.
Practical Implications.
SQL and Duplicates.
Duplicate Removal.
Countability.
Addressability.
Correctness and Interpretability of Results.
Essential Order and Performance Optimization.
Duplicate Removal.
Countability.
Addressability.
Correctness and Interpretability of Results.
Essential Order and Performance Optimization.
Conclusion and Recommendations.
Appendix 4A: Duplicate Removal in SQL.
Appendix 4B: Language Redundancy and Duplicates.
5. The Key, the Whole Key, and Nothing but the Key: Normalization.
The Issue.
Fundamentals.
Practical Implications.
Conclusion and Recommendations.
Fundamentals.
Repeating Groups.
First Normal Form.
Column Dependencies.
Functional Dependencies.
Second Normal Form.
Third Normal Form.
Multivalued Dependencies.
Fourth Normal Form.
Join Dependencies.
Fifth Normal Form.
First Normal Form.
Column Dependencies.
Functional Dependencies.
Second Normal Form.
Third Normal Form.
Multivalued Dependencies.
Fourth Normal Form.
Join Dependencies.
Fifth Normal Form.
Practical Implications.
SQL and Multivalued Columns.
“Denormalization” and Performance.
“Denormalization” and Performance.
Conclusion and Recommendations.
6. Neither Distinct nor the Same: Entity Supertypes and Subtypes.
The Issue.
Fundamentals.
Practical Implications.
Conclusion and Recommendations.
Fundamentals.
Entity Types, Attributes, and Relationships.
A Special Case.
DBMS Support.
A Special Case.
DBMS Support.
Practical Implications.
Multikey References.
SQL Subtables and Supertables.
SQL Subtables and Supertables.
Conclusion and Recommendations.
7. Climbing Trees in SQL: Data Hierarchies.
The Issue.
Fundamentals.
Practical Implications.
Conclusion and Recommendations.
Fundamentals.
Nodes and Links.
“Explode” Queries.
Recurring Nodes.
“Explode” Queries.
Recurring Nodes.
Practical Implications.
SQL and Trees.
Conclusion and Recommendations.
8. Not Worth Repeating: Redundancy.
The Issue.
Fundamentals.
Indirect Dependency.
Practical Implications.
Conclusion and Recommendations.
Fundamentals.
Duplicate Rows.
Within-Table Duplicates.
Cross-Table Duplicates.
Entity Subtypes and Supertypes.
Column Dependencies.
Functional Dependencies.
Dependency on Part of the Key.
Within-Table Duplicates.
Cross-Table Duplicates.
Entity Subtypes and Supertypes.
Column Dependencies.
Functional Dependencies.
Dependency on Part of the Key.
Indirect Dependency.
Multivalued Dependencies.
Join Dependencies.
Derived Information.
Redundancy Control.
Denormalized Designs.
Derived Information.
Join Dependencies.
Derived Information.
Redundancy Control.
Denormalized Designs.
Derived Information.
Practical Implications.
SQL and Keyless Tables.
SQL and Cross-Table Duplicates.
SQL and “Denormalization.”
SQL and Derived Information.
SQL and Cross-Table Duplicates.
SQL and “Denormalization.”
SQL and Derived Information.
Conclusion and Recommendations.
9. Will SQL Come to Order: Quota Queries.
The Issue.
Fundamentals.
Practical Implications.
Conclusion and Recommendations.
Fundamentals.
Ambiguities.
The Declarative Solution.
The Declarative Solution.
Practical Implications.
SQL and Quota Queries.
Conclusion and Recommendations.
10. What You Don't Know Can Hurt You: Missing Information.
The Issue.
Fundamentals.
Practical Implications.
Conclusion and Recommendations.
Fundamentals.
Meaningless Assertions.
Empty Assertions.
Missing Information as Metadata.
DBMS Support.
Many-Valued Logic.
Empty Assertions.
Missing Information as Metadata.
DBMS Support.
Many-Valued Logic.
Practical Implications.
SQL NULLs.
NULLs and 4VL.
NULLs and 3VL.
2VL and Metadata.
NULLs and 4VL.
NULLs and 3VL.
2VL and Metadata.
Conclusion and Recommendations.
Index. 0201485559T04062001
