Page 359
might also show the views, snapshots, and columns of the tables. The DSD is created during the design stage and uses the ERD from the analysis stage. Figure 15.4 shows a schema obtained from this diagrammer.
FIG. 15.4
An example of a
schema.
Several code generators are provided by Designer/2000, and these are repository utilities that allow the generation of complete, bug-free code to be used in the build phase of the System Development Life Cycle. The collection of generators can be classified into two types: Server Code Generator and Front-End Code Generator.
Forms GeneratorThis DES2K component allows Developer/2000 applications to be built quickly based on repository information. Forms generator has a lot of features, including
Page 360
Figure 15.5 shows the forms generator in use.
FIG. 15.5
An example of the forms
generator in use.
Reports GeneratorThe reports generator is a DES2K component that enables Oracle
reports applications to be built quickly, based on repository information. Its many
features include:
Page 361
Server GeneratorThis Designer/2000 component allows for the creation of database objects and PL/SQL modules based on repository information. Its features include:
Basically, you define the objects in the repository and then use this generator to specify the object for which you want the script created.
Figure 15.6 shows the server generator used to generate DDL.
FIG. 15.6
An example of the use
of the server generator.
Visual Basic GeneratorThis generator is similar to the forms generator. The code from this generator can be loaded into Visual Basic 4.0 and is used to create an executable file.
Figure 15.7 shows a Visual Basic generator.
WebServer GeneratorThe WebServer Generator can be used to create Web applications. To create a Web application:
Page 362
FIG. 15.7
An example of a Visual
Basic generator.
MS Help GeneratorThe MS Help Generator creates help files in MS Help file format that can be used with forms and Visual Basic applications. The MS Help Generator puts help text in a file and creates the necessary links and jumps. You will also need the MS Help Compiler, a separate product, to generate the WinHelp format files.
C++ Object Layer GeneratorThis generator allows you to access object-relational
databases by creating C++ class definitions and code using the systems modeler tools. It can be used
to produce the classes for both the data and the functions that form the object. You will need
to compile the generated classes with the rest of the C++ code and also link it with the C++
libraries.
All the post-generation work should be implemented in such a way that module regeneration can take place more or less in a painless manner. The following strategies can be used to accomplish this task:
Oracle CASE Exchange is a utility that allows bidirectional exchange of information between Designer/2000 and CASE tools from other vendors. This can be very useful for people who have been using CASE tools from other vendors and are now interested in using Designer/2000. It is especially useful if an organization does its analysis using another CASE tool like
Page 363
LBMS Automate Plus and now wants to finish the project using Designer/2000. One limitation of DES2K is that it does not generate 3GL code; by using CASE exchange, one can transfer the information from the repository into another CASE tool and generate 3GL from that tool.
Oracle CASE exchange supports the CASE tools described in the following lists.
Upper CASE support includes:
Lower CASE support includes:
Validation checks are provided by CASE exchange for the following before loading:
The following are the steps involved in CASE studies: Strategy, Analysis, Design, and Implementation: