Abstract
It is important to design databases in a way that makes efficient processing and querying of the data possible. That by itself, however, is not enough. We must make sure that the data we get from the database can be trusted. Think about an 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 that do not belong to any orders in our system.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Dmitri Korotkevitch
About this chapter
Cite this chapter
Korotkevitch, D. (2016). Constraints. In: Pro SQL Server Internals. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1964-5_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1964-5_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1963-8
Online ISBN: 978-1-4842-1964-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books