SchemaModeler


SchemaModeler models and documents SYBASE SQL Server and ORACLE databases. With SchemaN fodder, the user reverse engineered a SYBASE or ORACLE database into a schema diagram. The user arranged tables, views and keys into a comprehensible display of the complete schema. The user chose from three display modes for tables and views and used multiple fonts, styles and sizes. Written documentation was entered for every database object.

With SchemaModeler, the user could model the schema, thereby making it available to Interface Builder with Database Kit. The user specified table, view and column aliases, column format and class values and relationship names and flags. SchemaModeler replaced the NEXTSTEP DBModeler with a graphical user interface.

The schema diagram with all of its modeling information and all of its documentation, was saved into five tables within SYBASE or ORACLE. The modeling information was also saved into a DBModel file. The five tables were referenced the next time the database was opened with SchemaModeler. Because the diagram was saved in tables, it's accessible with SQL queries.

SchemaModeler implemented the philosophy that the "design was the implementation." The compelete design along with its documentation was stored in the SYBASE or ORACLE database. SchemaModeler could be upgraded to SchemaE, which enlarges this philosophy to included changes to the schema itself.

Schema Research Corporation
$380
Qty in the collection: 0