ClearDB Documenter documents an Oracle database and generates a comprehensive report with analysis results of code quality, logical structure of the system, database security and its overall efficiency. Its a Windows 32- and 64-bit application working with Oracle Databases, supporting versions 9i - 18c. ClearDB Documenter supports 59 schema and non-schema object types and can collect such information as object properties, DDL, their source code, database instance properties, parameters, and the like. It works with data at four system levels: Database Schema Object Type Object. 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.
