Date for   Saturday, April 20, 2013 8:00:00 AM - Saturday, April 20, 2013 5:00:00 PM

Data Integrity: the Row Spanning Dependency pattern

A Row Spanning Dependency is where the value of a field is linked to the value in a field in a different row of the same table. This can be easily identified when a row contains fields named something like "begin_xxx" and "end_xxx" where the end value must match a corresponding begin value in another row. It can quietly wreak havoc with data integrity in a relational database and complicates CRUD operations. Fortunately, it can be completely and cleanly eliminated because, as it turns out, it is not at all necessary. This session covers identifying and eliminating row spanning dependencies and the changes needed in queries.

Track

Database (SQL/NoSQL)

About the session

The session is approved.

The presenter will not allow another presenter.

There are 16 people interested in this session.

Presenters

Tomm Carr

Scheduled

Room
IRN-127
Time
3:30 PM - 4:30 PM
Calendar File
 Download
Edit Session