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.
About the session
The session is approved.
The presenter will not allow another presenter.
There are 16 people interested in this session.
- 3:30 PM - 4:30 PM
- Calendar File
Heads up! Log in to sign up to teach or attend this session.