On assisting domain and not null constraint management with DBDetective 2.0 for Oracle

DBDetective for Oracle is a metadata mining tool for detecting and correcting possible violations of some crucial database (db) design, implementation, usage, and optimization best practice rules (bprs); its 1.0 version considers two bprs related to domain and not null constraints, but does not allow storing corresponding decision data for them: as, for example, investigated db current instances may not be typical for all tables, db architects might not validate DBDetective findings and /or even force db scheme changing, although DBDetective did not recommend them. Its 2.0 version considers other bprs, out of which three related to domain constraints, provides storing decision data for all of them, as well as mechanisms for automatic generation of corresponding db scheme enhancement PL/SQL scripts, based on these decisions. This paper presents only those related to not null and domain constraints. Any advanced RDBMS should include these facilities too.