Oracle CASE Dictionary 5.1

In my last posting I promised to briefly outline the major new features of Oracle CASE Dictionary 5.1 which is due for production availability in September 1993 on MS-Windows. Other platforms will follow shortly afterwards.

This new version of Oracle CASE Dictionary will extend integration with the ORACLE server through additional ORACLE7 support, will offer a full Graphical User Interface via Oracle Forms 4 and will introduce an open Application Programmer Interface (API).

ORACLE7 Support

Additional element types and properties will be introduced to record and maintain design decisions regarding:

o       Database and Rollback Segments 
o       Declarative Data Integrity Constraints (e.g.
	PRIMARY, FOREIGN and UNIQUE Keys and CHECK Constraints)
o       Stored Procedures, Functions & Packages
o       Database Triggers
o       Database Security (e.g. Access Roles and Privileges)

Declarative data integrity may be enforced by the server, using SQL DDL generation, or by the client-side application, using the Generator technology, or, if required, by both.

Support for Design of Distributed Systems

ORACLE7 introduces additional support for distributed processing including distributed transactions and table replication. The DDL Command Generator will generate commands to create database links and synonyms and will generate the appropriate node specific definitions (e.g.TABLE, STORED PROCEDURE) for each node in the distributed system.

Open API

CASE Dictionary 5.1 will feature an open API allowing programs to access repository definitions. The API will initially cater for analysis level definitions and will be implemented using PL/ SQL Stored Procedures.

Extended Reverse Engineering

To further aid the developer reverse engineering existing systems a new Table to Entity Retrofit utility will be introduced. This takes tables and foreign key definitions and delivers corresponding Entity Relationship information which can be shown graphically via Oracle CASE Designer. Received on Thu Apr 22 1993 - 12:31:37 CEST