SchemaScanner is a Java/JDBC tool designed to assist developers and DBAs in examining and understanding Oracle database schemas and database contents. It automatically scans an Oracle database, verifies that the database design conforms to generally accepted design principles, and samples the attributes of all specified entities to determine basic data mining elements, including uniqueness, percentage null, and data variance. It produces an XML output file which can be formatted using supplied XSL output formats to generate a reverse-engineered schema, an attribute usage profile, or document schema structure exceptions. Since the output format is well-formed XML, custom reports can be easily constructed from the generated XML file using XSL. A limited use version is available as freeware for non-commercial and educational use.
|Tags||Database Software Development Testing Quality Assurance|
|Operating Systems||OS Independent|