Oracle Designer
Oracle Designer was 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.
Oracle Designer 2000 | |
Original author(s) | Oracle |
---|---|
Final release | 10.1.2.6
/ 2010 |
Type | CASE |
Website | Oracle Designer |
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.[1]
History
The product's original name was Oracle CASE and it was developed in England.
A product called SQL Data Dictionary (SDD) was a precursor to Oracle CASE.
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
- 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 - developed using SQL*Forms 3 character mode screens
Oracle CASE 5.1 was a major redevelopment where the screens were redeveloped using the Oracle Forms 4.0 which provided a GUI interface
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
Designer 6
Designer 6i - the pre-release version number was 6.5. The production release was changed to 6i to keep in sync with the Oracle Developer version name
Designer 9i
Designer 10gR2 (10.1.2.6) – this was the last release of Designer[2]
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.
References
- "Oracle Designer - Product Information". Oracle Designer - Product Information. Retrieved 24 April 2018.
- https://download.oracle.com/otn_hosted_doc/designer/des10gr2_10126/designer-repos/rn-designer-specifics.htm
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