Abstract
“ODBDetective is an Oracle database (Oracle) metadata mining tool for detecting violations of some crucial database (db) design, implementation, usage, and optimization best practice rules (bpr). This paper presents the set of bprs that is considered by the first full version (1.0) of ODBDetective, the db axioms from which they are derived, the corresponding tool’s facilities, and the essentials of its actual architecture, design, development, and usage, including the results of a case study on an Oracle production db. Moreover, even this first ODBDetective version also allows for storing semantic decision data on desired db scheme improvements, which will prove very useful to automatic improvement code generation in subsequent versions of this tool.”
Highlights
Too often, databases are very poorly designed, implemented, queried, and manipulated
Embarcadero Technologies includes in its DB PowerStudio for Oracle [3] a dedicated tool called DB Optimizer
The 3-tier architecture of ODBDetective is presented in Figures 1 and 2: The light GUI, developed in MS Access 2010, provides users with a simple, three levels menu and forms/reports for displaying/printing mainly investigation results, and for accepting corresponding parameter values, as well as managing Oracle target servers and dbs needed data, and additional semantic decision support data; it provides radio buttons for selecting desired detection options and buttons for launching metadata mining, investigations, etc
Summary
Databases (dbs) are very poorly designed, implemented, queried, and manipulated. Significant efforts were made for designing and developing panoply of tools for investigating db issues, proposing better solutions to be carried out by db administrators (DBA), and even for automatic db schemes improvement They range from those provided by db relational management systems (RDBMS) manufacturers to third party ones. From all db axioms and best practice rules presented in [7], only the following small subsets (see sub-sections 2.0 and 2.1) were considered by ODBDetective 1.0. It provides only the 32 investigation types listed in sub-section 2.2
Sign-in/Register to view highlights & summary 
Published Version
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call