ClearDB Documenter has a built in Code Analyzer fulfilling several purposes: Code Illustration draws diagrams and matrices based on relations between code elements (Flowcharts, Call Trees, CRUD) and DB objects (R&D, ER diagrams). Code Review checks PL/SQL against predefined rules, detecting syntax and logical errors, poor programming practices, orphaned objects, legacy code, etc., and gives recommendations on how to improve the code. Code Metrics calculates systems maintainability and complexity based on industry-standard measurements. ClearDB Documenter runs a policy-enforced security audit of an Oracle database, scanning it against 630 potential risks. The audit results are outlined in a report, always password protected on a mandatory basis.
ClearDB Documenter compares two database reports or an existing instance snapshot with its current state to indicate differences and changes. The comparison is carried out at four levels (DB, Schema, Object Type, Object) and includes Security Audits as well. ClearDB Documenter installs with docuVIEWER a tool to open password protected reports and draw instant diagrams. docuVIEWER is also available as a FREE standalone app.