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
• Forms
• Reports
• Graphics
• Visual Basic
• Web server
• Microsoft Help
• C++ Object Layer

Utilities

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

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