Advertisement

Constraints

  • Dmitri Korotkevitch
Chapter

Abstract

It is important to design databases in a way that makes efficient processing and querying of the data possible. That by itself, however, it is not enough. We must make sure that the data we get from the database can be trusted. Think about the Order Entry system, for example. We can query the OrderLineItems table to get the information about products we sold, but we cannot trust the results unless we know that the table has no orphaned rows, which do not belong to any orders in our system.

Keywords

Unique Constraint Execution Plan Unique Index Check Constraint Order Entry System 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Dmitri Korotkevitch 2014

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.FLUnited States

Personalised recommendations