Oracle Designer

Oracle Designer
Oracle Designer 2000
Original author(s)	Oracle
Type	CASE
Website	Oracle Designer

Oracle Designer is Oracle's CASE tool for designing an information system and generating it. After generating the information system one is able to edit the generated code with Oracle Developer Suite.

As of April 2018 this product has reached its end of life and is now in sustaining support only. Alternative modeling and design tools are Oracle JDeveloper and Oracle SQL Developer Data Modeler.

History

The product's original name was Oracle CASE and it was developed in England.

The user interface was developed using Oracle Forms and Oracle Reports. This was a character mode user interface that was typically used in terminal sessions or MS-Dos.

It also included a GUI diagram editor that ran on X-Windows only.

A later version was redeveloped in Forms 4.0 and then redeveloped again as a Windows only program

Components

Business Process Modelling

• Process Modeller

Systems Analysis Modelling

• ER Diagrammer
• Dataflow
• Function Hierarchy

Design Wizards

• Database Wizard
• Application Wizard

Systems Design

• Data Schema
• Module Logic
• Module Data
• Preferences
• Module Structure

Client/Server Generators

• Server - Oracle database objects (tables, indexes, constraints etc)
• Oracle Forms
• Oracle Reports
• Visual Basic
• Web server
• Microsoft Help
• C++ Object Layer

Utilities

• Repository Object Navigator (RON)
• Matrix
• Repository Reports
• Admin Utility
• SQL*Plus
• Online help

Versions

Oracle CASE 1 Oracle CASE 2 Oracle CASE 3 Oracle CASE 4

Oracle CASE 5.1 was a major redevelopment where the screens were redeveloped in the new version of Oracle Forms 4.0

The version numbers get confusing at this point because the numbers go backwards. The software was renamed and the next version released was Oracle Designer/2000 6.0 (not to be confused with Designer 6 that was released years later).

The next minor release changed the numbering system to be in line with Oracle Developer, so it was named Designer 1.1

Designer 1 Designer 2 Designer 3 - TO DO: not sure if this existed

After this point the version numbers were changed to be in line with Oracle Developer so the version numbers juped

Designer 6 Designer 6i Designer 9i this was the last release of Designer

Publications

• Billings, Chris (1997). Rapid Application Development with Oracle Designer/2000. Harlow: Addison Wesley Pub. Co. ISBN 0-201-63444-9.
• Dorsey, Paul (1997). Oracle Designer/2000 Handbook. Berkeley: Osborne. ISBN 0-07-882229-7.
• Anderson, Carrie (1997). The Oracle Designer/2000 Handbook. Boston: Addison-Wesley. ISBN 0-201-63445-7.
• Dorsey, Dr (1998). Oracle Designer Handbook. New York: McGraw-Hill Companies. ISBN 0-07-882417-6.
• Lulushi, Albert (1998). Inside Oracle Designer/2000. Upper Saddle River: Prentice Hall PTR. ISBN 0-13-849753-2.
• Atkins, Kenneth (1999). Oracle Designer Generation. New York: McGraw-Hill Companies. ISBN 0-07-882475-3.
• Kramm, Mark (2000). Oracle Designer. Upper Saddle River: Prentice Hall PTR. ISBN 0-13-015343-5.

External links

• Tutorial for Designer/2000
• Oracle Designer Tutorial: Creating an Oracle Database, Elizabeth Gallas, Fermi National Accelerator Laboratory, November 2, 2000.
  PDF Version: Oracle Designer Tutorial: Creating an Oracle Database
• Fast Track Design and Development with Oracle Designer 6i