Buy Practical Issues in Database Management - Bookswagon
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Practical Issues in Database Management: A Reference for the Thinking Practitioner
Practical Issues in Database Management: A Reference for the Thinking Practitioner

Practical Issues in Database Management: A Reference for the Thinking Practitioner


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

"The aim of this book is to provide a correct and up-to-date understanding of--and appreciation for--the practical aspects of crucial, yet little-understood core database issues. It identifies and clarifies certain fundamental concepts, principles, and techniques that persistently trouble users and vendors. It assesses the treatment of those issues in SQL (both the standard and commercial implementations) and gives specific guidance and practical advice on how to deal with them (and how not to). It covers, carefully and thoroughly, several particularly tricky and misunderstood topics--complex data types, missing information, data hierarchies, quota queries, and so forth--in a succinct and concise form for the busy database practitioner." --C. J. Date Three decades ago relational technology put the database field on a sound, scientific foundation for the first time. But the database industry--vendors, users, experts, and the trade press--has essentially flouted its principles, focusing instead on a "cookbook, " product-specific approach, devoid of conceptual understanding. The consequences have been costly: DBMS products, databases, development tools, and applications don't always perform up to expectation or potential, and they can encourage the wrong questions and provide the wrong answers. Practical Issues in Database Management is an attempt to remedy this intractable and costly situation. Written for database designers, programmers, managers, and users, it addresses the core, commonly recurring issues and problems that practitioners--even the most experienced database professionals--seem to systematically misunderstand, namely: *Unstructured data and complex data types *Business rules and integrity enforcement *Keys *Duplicates *Normalization and denormalization *Entity subtypes and supertypes *Data hierarchies and recursive queries *Redundancy *Quota queries *Missing information 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, Practical Issues in Database Management employs real-world examples to provide an assessment of current technology--SQL and the DBMS products based on it--and, whenever possible, offers concrete recommendations and workarounds. With the insight provided by Practical Issues in Database Management, you will be in a far better position to evaluate specific products, exploit their capabilities, and avoid their deficiencies. 0201485559B04062001

Table of Contents:
Foreword. Preface. 1. Careful What You Wish For: Data Types and Complexity. The Issue. Fundamentals. “Simple” 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. 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. Business Rules. 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. Conclusion and Recommendations. Appendix 2A: A Note on SQL's OVERLAPS Operator. 3. A Matter of Identity: Keys. The Issue. Fundamentals. Simple versus Composite Keys. 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. Determining Entity Types. “Hidden” Information. A Relational Bonus. Practical Implications. SQL and Duplicates. 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. 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. Practical Implications. SQL and Multivalued Columns. “Denormalization” and Performance. Conclusion and Recommendations. 6. Neither Distinct nor the Same: Entity Supertypes and Subtypes. The Issue. Fundamentals. Entity Types, Attributes, and Relationships. A Special Case. DBMS Support. Practical Implications. Multikey References. SQL Subtables and Supertables. Conclusion and Recommendations. 7. Climbing Trees in SQL: Data Hierarchies. The Issue. Fundamentals. Nodes and Links. “Explode” Queries. Recurring Nodes. Practical Implications. SQL and Trees. Conclusion and Recommendations. 8. Not Worth Repeating: Redundancy. The Issue. Fundamentals. Duplicate Rows. 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. Practical Implications. SQL and Keyless Tables. 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. Ambiguities. 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. Meaningless Assertions. Empty Assertions. Missing Information as Metadata. DBMS Support. Many-Valued Logic. Practical Implications. SQL NULLs. NULLs and 4VL. NULLs and 3VL. 2VL and Metadata. Conclusion and Recommendations. Index. 0201485559T04062001

About the Author :
Fabian Pascal is an independent industry analyst, consultant, author, and lecturer specializing in database management. He is the author of two previous books, Understanding Relational Databases and SQL and Relational Basics, and has contributed extensively to many industry publications. 0201485559AB04062001


Best Sellers


Product Details
  • ISBN-13: 9780201485554
  • Publisher: Pearson Education Limited
  • Publisher Imprint: Addison Wesley
  • Height: 100 mm
  • No of Pages: 288
  • Spine Width: 100 mm
  • Weight: 100 gr
  • ISBN-10: 0201485559
  • Publisher Date: 02 Jun 2000
  • Binding: Paperback
  • Language: English
  • Returnable: N
  • Sub Title: A Reference for the Thinking Practitioner
  • Width: 100 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Practical Issues in Database Management: A Reference for the Thinking Practitioner
Pearson Education Limited -
Practical Issues in Database Management: A Reference for the Thinking Practitioner
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Practical Issues in Database Management: A Reference for the Thinking Practitioner

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!