Home > Computing and Information Technology > Databases > Designing Effective Database Systems
27%
Designing Effective Database Systems

Designing Effective Database Systems

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

“Riordan covers core skills for any developer—database design and development—in a perfect amount of detail. This book should be on every professional developer’s reading list.” —Duncan Mackenzie, developer, Microsoft (MSDN)“Designing a database is not a trivial subject. Riordan brings experience and clear explanations to a fundamental part of software development.” —Patrick Birch, database and technical writing consultant“If you buy only one book on database design, make it this one. Riordan has a talent for explaining technical issues in simple language, without over simplifying.” —Brendan Reynolds, developer, Dataset IT Systems and Microsoft Access MVP“A book that will expertly guide you in how to develop a database for a client— and how to do it right the first time!” —Kenneth D. Snell, Ph.D., ACCESS developer and Microsoft Access MVP “Riordan has produced a unique book that brings together a formal, yet commonsense, approach to relational database design...and then goes further! Many database designers will find immense value in the steps to developing practical data warehouse designs. If you are seeking a framework for designing transactional databases, or want to step out into the world of analytical databases, Riordan’s book excels at bridging both worlds.” —Paul Irvine, vice president, engineering, Via Training“Riordan takes a complex subject and makes it easy. If you’re over your head on a database design project, this book will help bail you out!” —Mike Gunderloy, contributing editor, Application Development Trends“This book covers a wide range of database design and data modeling topics in a well-organized, easy to understand format.” —Amy Sticksel, Sticksel Data Systems, Inc.“In Designing Effective Database Systems, Riordan’s style, wit, and attention to detail are outstanding.” —Sandra Daigle, Microsoft Access MVP The Software Developer’s Step-by-Step Guide to Database DesignWorld-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren’t database experts. No matter how messy or complex your data challenge, Designing Effective Database Systems shows you how to design an effective, high-performance database to solve it. Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer. Next, she offers the field’s clearest introduction to dimensional database modeling—practical insight for designing today’s increasingly important analytical applications. One task at a time, the author illuminates every facet of database analysis and design for both traditional databases and the dimensional databases used for data warehousing, showing how to avoid common architectural pitfalls that complicate development and reduce extensibility. The book concludes with comprehensive, expert guidance on designing databases for maximum usability. This book will teach you to Understand relational database models, structures, relationships, and data integrity principles Define database system goals, criteria, scope, and work processes Construct accurate conceptual models: relationships, entities, domain analysis, and normalization Build efficient, secure database schema Master the elements of online analytical processing (OLAP) design: fact tables, dimension tables, snowflaking, and more Architect and construct easy, efficient interfaces for querying and reporting Learn from practice examples based on Microsoft’s Northwind sample database Riordan has helped thousands of professionals master database design and development, earning Microsoft’s coveted MVP honor for her exceptional contributions. Nobody is more qualified to help you master database design and apply it in your real-world environment.

Table of Contents:
Preface. Acknowledgments. I. RELATIONAL DATABASE THEORY. 1. Basic Concepts.     What Is a Database?     Database Tools     The Relational Model     Relational Terminology     The Data Model     Summary 2. Database Structure.     Eliminating Redundancy     Ensuring Flexibility     Basic Principles     First Normal Form     Second Normal Form     Third Normal Form     Further Normalization     Summary 3. Relationships.     Terminology     Modeling Relationships     One-to-One Relationships     One-to-Many Relationships     Many-to-Many Relationships     Unary Relationships     Ternary Relationships     Relationships of Known Cardinality     Summary 4. Data Integrity.     Integrity Constraints     Implementing Data Integrity     Summary 5. Relational Algebra.     Nulls and Three-Valued Logic (One More Time)     Relational Operations     Set Operators     Special Relational Operators     Summary II. DIMENSIONAL DATABASE THEORY. 6. Basic Dimensional Concepts.     The Dimensional Database Model     Terminology     A Potted History of Business Intelligence     Summary 7. Fact Tables.     The Structure of a Fact Table     The Characteristics of a Fact Attribute     Summary 8. Dimension Tables.     The Structure of a Dimension Table     Snowflaking     Changing Dimensions     Summary III. DESIGNING DATABASE SYSTEMS. 9. The Design Process.     Life Cycle Models     The Database Design Process     A Note on Design Methodologies and Standards 10. Defining the System Parameters.     Determining the System Goals     Developing the Design Criteria     Determining the System Scope     Summary 11. Defining the Work Processes.     Determining Current Work Processes     Analyzing Work Processes     Documenting Work Processes     User Scenarios     Summary 12. The Conceptual Data Model.     Identifying the Data Objects     Defining Relationships     Reviewing Entities     Domain Analysis     Restricting the Range of Values     Normalization     Summary 13. The Database Schema.     Systems Architectures     Database Schema Components     Security     Summary 14. Communicating the Design.     Audience and Purpose     Document Structure     Executive Summary     System Overview     Work Processes     Conceptual Data Model     Database Schema     User Interface     Change Management     Summary IV. DESIGNING THE USER INTERFACE. 15. The Interface as Mediator.     Effective Interfaces     Interface Models     User Levels     Putting Users in Charge     Minimizing the Memory Load     Being Consistent     Summary 16. User Interface Architectures.     Supporting the Work Processes     Document Architectures     Summary 17. Representing Entities in Form Design.     Simple Entities     One-to-One Relationships     One-to-Many Relationships     Hierarchies     Many-to-Many Relationships     Summary 18. Choosing Windows Controls.     Representing Logical Values     Representing Sets of Values     Representing Numbers and Dates     Representing Text Values     Summary 19. Maintaining Database Integrity.     Classes of Integrity Constraints     Intrinsic Constraints     Business Constraints     Summary 20. Reporting.     Sorting, Searching, and Filtering Data     Producing Standard Reports     Producing Ad Hoc Reports     Summary 21. User Assistance.     User Levels     Passive Assistance Mechanisms     Reactive Assistance Mechanisms     Proactive Assistance     User Training     Summary Bibliography. Glossary. Index.


Best Sellers


Product Details
  • ISBN-13: 9780321290939
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison-Wesley Educational Publishers Inc
  • Depth: 19
  • Language: English
  • Returnable: Y
  • Spine Width: 22 mm
  • Width: 176 mm
  • ISBN-10: 0321290933
  • Publisher Date: 20 Jan 2005
  • Binding: Paperback
  • Height: 235 mm
  • No of Pages: 384
  • Series Title: Addison-Wesley Microsoft Technology
  • Weight: 720 gr


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Designing Effective Database Systems
Pearson Education (US) -
Designing Effective Database Systems
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.

Designing Effective Database Systems

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

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA