Information technology new findings 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. Too often, databases (dbs) are very poorly designed, implemented, queried, and manipulated. As a consequence, they allow storing implausible data, sometimes even do not accept plausible data, are very slow when data accumulates, and need too much unneeded disk and memory space, as well as, especially, programming and maintenance effort. Consequently, 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.
Last date updated on November, 2020