Neon Enterprise Software Blog

Welcome to Neon Enterprise Software Blog Sign in | Join | Help
in Search

Data Management Today by Craig Mullins

News, views, and issues involved in managing data as a valuable corporate asset.

Participate in a Survey on Database Constraints

Today I'd like to point my readers to an interesting survey being conducted on the usage of referential integrity and database constraints in your database implementations. The survey should take about 5 minutes or so to complete.

It is being conducted by a practicing Database Administrator/Database Developer (18+ years) who is a graduate student in the newly developing science of “Information Quality”. (The world’s first graduate program was started Fall 2006 by the University of Arkansas at Little Rock in collaboration with the Massachusetts Institute of Technology).

The survey is being conducted because of the perception that the implementation of database integrity constraints is deficient in many production databases. The intent of the survey is to discover why this might be so. The results of this survey should be of interest to practitioners and theorists in the areas of relational database development as well Information/Data quality.    

The database constraints being referred to include referential integrity constraints, check constraints (or rules) and triggers. To some, triggers may seem odd choice for business rules enforcement. However they offer a rich capability of rule enforcement besides it was also the only choice in certain RDBMs at one time. Questions have skip logic and your answers affect what further questions you are asked.     

Confidentiality and anonymity is guaranteed in our survey. No personal information is required to complete the survey. None of the questions in the survey are mandatory. You may quit from the survey at any time by closing the browser window. A copy of the results will be available upon request. This survey is not sponsored by any commercial entity.

To start the survey, please follow the link http://www.ualr.edu/tkdasgupta/dbquality.htm

Published Tuesday, May 15, 2007 12:44 PM by cmullins

Comments

 

Doug's Oracle Blog said:

It's my turn again and, looking back at Log Buffer #4, I was amazed to realise that we're up to number 45 already and that my previous attempt was last August. Good work from Dave Edwards, who bears the organisational burden every week. Sooner him tha

May 19, 2007 4:50 AM
Anonymous comments are disabled

About cmullins

Craig S. Mullins is a data management strategist for NEON Enterprise Software. Craig has extensive experience in the field of database management having worked as an application developer, a DBA, and an instructor with multiple database management systems, including working with with DB2 for z/OS since Version 1. Craig is also an IBM Information Champion and is the author of two books: "DB2 Developer’s Guide" and "Database Administration: Practices and Procedures."

This Blog

Syndication

News

Be sure to visit my web site at http://www.craigsmullins.com
Powered by Community Server, by Telligent Systems