Make structure and contents of relational databases.
Edit By BS Editor: jocDBInsight was developed targetting the goals to make structure and contents of Relational databases accessible to developers, but also interested laymen, in an unparalleled easy way. The possibilities to modify structure or data was intentionally left out, so you can be sure that there are no modifications to the investigated database using jocDBInsight.
Structural elements of your datebase like e.g. Tables, Columns, Indices, Views, Procedures, Foreign Key Constraints and so on including their mutual dependencies can be observed any way you like using a new, uniquely developed browser.
jocDBInsight analyses the contents of your tables regarding many properties like e.g. present NULL-Values, uniqueness and value distribution if desired and displays the results in well arranged and freely sortable tables. These properties derived from data analysis are called Metrics in jocDBInsight.
Icons play an important role in jocDBInsight, as you can see at a glance the essential characteristics simply by looking at the icons of the displayed structural elements. Any analysis results (Metrics) already computed are of course also reflected in the icons.
Despite the FACT that Foreign Key Constraints form an essential part of the structural information needed to understand a relational database, they are unfortunately in Reality often missing in part or altogether. Therefore in jocDBInsight you can Create own relationships called Column Correlations in addition to the existing Foreign Keys. Metrics can be computed for the existing Foreign Keys as well as for Column Correlations.
An automatically layouted Database Diagram gives you the overview you need without extended pushing around of elements. Of course you can select the diagram elements using the mouse. you can free download jocDBInsight 1.10 now.