Date for Desert Code Camp - 2014.1  Saturday, April 5, 2014 8:00:00 AM - Saturday, April 5, 2014 6:00:00 PM

Data Integrity: the Row Spanning Dependency antipattern.

We start out with a brief discussion of Data Integrity as applied to databases. Quick, what role does data normalization play in Data Integriry? We know what to do when an attribute has a dependency on another, non-key Attribute. But what if that dependency is to a column of a different row in the table? This happens when an unbroken sequence of values (mostly datetime) is maintained with each row representing one interval of the sequence. Look for columns with names like "FROM_xxx" and "TO_xxx". This leads to data manipulation anomolies (fancy word that means *the data integrity cannot be maintained") that cannot be fixed through normalization. Fortunately, it can be fixed and surprisingly easily. This session is encouraged for anyone signing up for "Data Modeling: Implementing Bi-Temporal Access to Data",

Track

Database (SQL/NoSQL)

About the session

The session is approved.

The presenter will not allow another presenter.

There are 20 people interested in this session.

Presenters

Tomm Carr

Scheduled

Room
IRN-219
Time
9:45 AM - 10:45 AM
Calendar File
 Download

Files

Heads up!  Log in to sign up to teach or attend this session.
Edit Session