ClearDB Documenter 3
ClearDB 3 easily and quickly documents a complete set of 54 schema (tables, views, procedures, functions, packages, types, triggers, etc.) and non-schema (contexts, directories, profiles, users, roles, etc.) object types with all their properties, source code, DDL, privileges, synonyms, references, dependences as well as database instance properties, options and initial parameters for Oracle versions up to 11gR2.
ClearDB 3 is empowered by a PL/SQL Analyzer that reviews, measures, checks the quality of Oracle PL/SQL used in stored objects and gives recommendations for better coding style. Additionally, each stored object is analyzed for its structure and architecture. A set of quality control metrics about the code is generated to identify possible error prone procedures based on complexity, size and modularity.
ClearDB 3 helps to keep PL/SQL code reliable, testable and manageable. Industry accepted complexity measures (McCabe, Halstead and Maintainability Index, MI) are used. The code review module catches over 60 common coding mistakes and gives suggestions for good programming practices. Our PL/SQL Parser supports up to 99% of SQL and PL/SQL documented keywords and reserved words.
ClearDB 3 is the only Oracle database documentation program known to date, which provides PL/SQL code formatting, analyzing and visualizing (Flowcharts and Call Tree diagrams and CRUD1 and CRUD2 type matrices) while at the same time creates database documentation. The primary output format of the database documentation is HTML. In addition to HTML, ClearDB 3 produces documentation in CHM (Microsoft's Compiled HTML Help) format as well.
ClearDB 3 is bundled with a set of powerful features to: compare documentation with a database or with other documentation and vise/versa; automate documentation generation by using integrated scheduled jobs and command line interface; actualize the content of documentation by synchronizing it with the database; extract database DDL from documentation; extract a subset from documentation; convert documentation to another format; and generate new documentation based on the content and options settings of previously created documentation.