Error loading page.
Try refreshing the page. If that doesn't work, there may be a network issue, and you can use our self test page to see what's preventing the page from loading.
Learn more about possible network issues or contact support for more help.

Database Design and Relational Theory

ebook

What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understand—drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place.

Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional information, or ask you to prove some simple theoretical result. If you’re a database professional familiar with the relational model, and have more than a passing interest in database design, this book is for you.

Questions this book answers include:

  • Why is Heath’s Theorem so important?
  • What is The Principle of Orthogonal Design?
  • What makes some JDs reducible and others irreducible?
  • Why does dependency preservation matter?
  • Should data redundancy always be avoided? Can it be?
  • Databases often stay in production for decades, and careful design is critical for avoiding subtle errors and processing problems over time. If they’re badly designed, the negative impacts can be incredibly widespread. This gentle introduction shows you how to use important theoretical results to create good database designs.


    Expand title description text
    Publisher: O'Reilly Media

    Kindle Book

    • Release date: August 1, 2012

    OverDrive Read

    • ISBN: 9781449330200
    • File size: 3103 KB
    • Release date: August 1, 2012

    EPUB ebook

    • ISBN: 9781449330200
    • File size: 3103 KB
    • Release date: August 1, 2012

    Formats

    Kindle Book
    OverDrive Read
    EPUB ebook

    Languages

    English

    What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understand—drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place.

    Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional information, or ask you to prove some simple theoretical result. If you’re a database professional familiar with the relational model, and have more than a passing interest in database design, this book is for you.

    Questions this book answers include:

  • Why is Heath’s Theorem so important?
  • What is The Principle of Orthogonal Design?
  • What makes some JDs reducible and others irreducible?
  • Why does dependency preservation matter?
  • Should data redundancy always be avoided? Can it be?
  • Databases often stay in production for decades, and careful design is critical for avoiding subtle errors and processing problems over time. If they’re badly designed, the negative impacts can be incredibly widespread. This gentle introduction shows you how to use important theoretical results to create good database designs.


    Expand title description text
    • Details

      Publisher:
      O'Reilly Media

      Kindle Book
      Release date: August 1, 2012

      OverDrive Read
      ISBN: 9781449330200
      File size: 3103 KB
      Release date: August 1, 2012

      EPUB ebook
      ISBN: 9781449330200
      File size: 3103 KB
      Release date: August 1, 2012

    • Creators
    • Formats
      Kindle Book
      OverDrive Read
      EPUB ebook
    • Languages
      English