1 / 12

Resolving Database Structure Deficiencies for Improved Data Integrity

Presentation by Dr. Rueen-Fang Wang on fixing implementation gaps in database structure. Topics include deficiencies identified, steps to resolve them, current status, and remaining tasks.

evangeline-sweeney
Télécharger la présentation

Resolving Database Structure Deficiencies for Improved Data Integrity

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Fix Implementation Deficiencies of Database StructurePresenter: Rueen-Fang Wang, Ph.D., P.E.

  2. Topics • Purpose of this task • Deficiencies identified • Steps to resolve deficiencies • Current status • Remaining tasks 2

  3. Purpose • To address issues discussed in the Panel’s subcommittee presentation (June 2007 ): • Enforce meaningful referential integrity • Enforce meaningful data uniqueness

  4. Deficiencies Identified in the Initial Implementation • Related to referential integrity: • Arc relationship • Logical deletion • List Item reference • Related to meaningful uniqueness • Database Uniqueness rules

  5. Identified Deficiency 1 –Arc Implementation

  6. Identified Deficiency 2 –DELETED_DATETIME column

  7. Identified Deficiency 3 –List Item Implementation

  8. Identified Deficiency 4 –Meaningful Data Uniqueness

  9. Steps to Resolve Deficiencies • Review and develop adequate database rules as necessary • Identify existing problematic data and the associated causes • Develop solutions to clean up the data and fix application • Develop and impose DB constraints and triggers to enforce database rules

  10. Current Status

  11. Remaining Tasks

  12. Questions?

More Related