Automate database design and management using relational database techniques
DbGen is an IBM iSeries database management tool which provides the capability to organize and maintain a database. DbGen organizes your database files by application (set of related programs), and utilizes a data dictionary which provides a central definition of field attributes.
DbGen provides all the functions necessary to define, generate and create physical and logical files.
It also allows you to import your existing application files, enabling the product to be used for both new and existing application development. When file or dictionary definitions are changed, the changes ripple through all referencing files and dependent views. Files impacted by a change can then be recreated through a batch process.
Integration with ProGen Plus
DbGen integrates with ProGen Plus, our iSeries Application Generator and Report Writer, which has it's own interface to DbGen. Per field in the dictionary/file, you can add help text and validation modules, call a pop-up window program, additional edit codes and edit words.... ProGen will then automatically populate this information into the programs you develop. DbGen makes Application Development with ProGen Plus even faster and more productive. And now it even manages referential integrity!
Why Choose DbGen
- It masks the complexities of designing database files and their relationships, so you can focus on high-level design issues rather than the mechanics of describing databases.
- It standardizes your database design to eliminate inconsistencies and redundances, so application development is more productive.
- It makes it easy to work with existing database files, so changes to file layouts require little effort, freeing up valuable time for more advanced tasks.
- It eliminates the need for programmers to know DDS.
- It automates many routine steps involved with maintaining databases, including recompiling files, and insuring that correct file authority and attributes are assigned to objects, so your system can manage tasks you previously had to handle.
- It provides documentation and cross-referencing of database systems, so you call readily see the impact of changes to your file designs.
- It interfaces directly to ProGen Plus, so program design in ProGen Plus can automatically include many extended attributes of files provided through DbGen. This makes Application Development with ProGen Plus even more productive.
DbGen At a Glance
- DbGen manages database files. New or existing database files can be organized by Applications. (An application represents a group of database objects). Files can be copied to files with new names,within the same Application or to another Application. Extensive screens and reports provide information about the relationships between files within Applications. The attributes of files, such as number of records, access path maintenance, level check defaults, etc. can be changed directly through DbGen.
- DbGen describes database files. DbGen provides functions to create new database files or modify existing files. Creating a file is a simple process: Type a file name, then select fields from a dictionary to include in the file layout. The user interface is flexible and easy to use, to make designing files as productive a process as possible.Logical files are also simple: Select a physical, type the name of the logical file, then type a key field number next to the fields to designate as keys.Full support of physical and logical file DDS keywords is provided, including:RENAME, CONCAT, SUBSTR, join logical files, select/omit coding, ascending or descending keys, date, time and timestamp DDS field types, etc.
- DbGen Re-engineers existing database files. Extensive support for re-engineering existing applications is provided.Existing Physical and logical files can be loaded into DbGen through commands and a PDM interface. From then on, DbGen can be used exclusively to describe,maintain and manage the files.
- DbGen Cross-references Files and Fields. Cross-referencing functions are an integral part of DbGen. Fields are defined in dictionaries, and files designed by selecting fields from dictionaries. DbGen provides cross-reference screens and reports showing fields used by files and views (logical files). So, when you change a dictionary field, the change takes effect in all files and views that reference the field, even if the file field names are different across files.
- DbGen automates creating or recreating Files. DbGen tracks all changes to dictionary, file and view definitions. When you want to create or rebuild a file, DbGen performs many management steps to insure the process is automatic and safe. DbGen prevents you from accidentally losing any data and from leaving your database in an incomplete condition.
- DbGen provides advanced Application Development. Database description functions. For any physical file, you can describe field validations, window lookup programs, help text and edit codes or words. An interface between DbGen and ProGen Plus allows these extended definitions to be automatically referenced by ProGen Plus when designing programs.
- DbGen can re-engineer information from ProGen Plus. Files in DbGen can be populated with extended field information directly from existing ProGen Plus program definitions. For example, you can provide Help text for any field in a file described to DbGen by running a command that extracts the information from ProGen Plus and applies it automatically to the DbGen descriptions.