Projects / SchemaScanner

SchemaScanner

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
Operating Systems
Implementation
Screenshot

Project Spotlight

OpenStack4j

A Fluent OpenStack client API for Java.

Screenshot

Project Spotlight

TurnKey TWiki Appliance

A TWiki appliance that is easy to use and lightweight.