Data Modeling - (Integrity) (Constraints|action assertions)

> (Data|State) Management and Processing > Data Modeling (RDBMS or Code)

1 - About

The declared consistency rules

Every enterprise constrains behavior in some way, and this is closely related to constraints on what data may or may not be updated. To prevent a record from being made is, in many cases, to prevent an action from taking place.

But even at one-third the size, nine thousand lines, being able to recite the poem is impressive: at one second per line, the verses would take two and one-half hours to recite. It is impressive even allowing for the fact that the poem is re-created as opposed to memorized, because neither the singer nor the audience expect word-for-word accuracy (nor would either have any way of verifying that). Most of us do not learn epic poems. But we do make use of strong constraints that serve to simplify what must be retained in memory. Don Norman (The Design of Everyday Things: Revised and Expanded Edition)


3 - Purpose

Constraints are used for these purposes:

  • Data Quality

Constraints verify that the data conforms to a basic level of data consistency and correctness, preventing the introduction of dirty data. They are the key part to ensure referential integrity.

  • Query optimization

The Database utilizes constraints when optimizing SQL queries. Although constraints can be useful in many aspects of query optimization, constraints are particularly important for query rewrite. (for instance on materialized views. See query rewriting)

data/modeling/constraint.txt ยท Last modified: 2017/09/17 18:31 by gerardnico