Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

ID: 19162, DBSystem Creator

by Calin Lukas Email: Anonymous

Graphic database development environment with database object generation in java and visual basic. It is full integrated with our reports development environment, Optimal Report Generator.
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For JBuilder, Version 4.0  to 8.0 76 downloads
Copyright: All rights reserved

Size: 9,902,157 bytes
Updated on Fri, 01 Nov 2002 17:32:23 GMT
Originally uploaded on Fri, 01 Nov 2002 16:42:16 GMT
SHA1 Hash: 44C3A7185F0940F6CBFBF6E4D27043CE56B254EF
MD5 Hash: 77ABE63075AB4F290751A83D689AAC4F

    Explore the files in this upload

Database System Creator is a powerful tool, which combines graphic design and code generating for a wide range of database management systems. This product is an application based on components: it is composed of three modules (Structured Designer, Code Generator and Reengineer), which can also be obtained separately. DSC also offers cross-platform portability that derives from its JAVA implementation.

Database System Creator Structured Designer
In order to achieve a higher level of intelligent design and knowledge management, a structured organization of data is necessary. Designing large databases is a complex task performed by DBAs and System Designers in the implementation and reengineering of software systems and applications.
Database System Creator Structured Designer is a powerful tool for both sides of the brain (graphic design and code generating), that can be used for a wide range of database management systems. It also offers cross platform portability that derives from the fact that it is written in JAVA. Our product supports the huge impact of Internet in computer technology by making accessible the database generating on the WEB.
- offers a surface where the database objects (tables, relations, queries) can be placed and handled as graphic entities (components)
- structured design refers to the possibility of grouping the graphic entities (database objects) in bigger blocks, which reflects a higher level of logical abstraction; blocks inherit the relations between tables, thus reflecting the logical organization of the entire database at different conceptual levels, depending on the user's necessities
- provides an easy way to create tables by filling in the fields and the table structure is automatically created
- two points of view are available for each graphic object on the workplace: a "black box" one and a detailed one; while the detailed view displays all the informations about the entity, the "black box" view contains only the type of the entity in order to enhance the readability of the entire database structure hiding the rest of details
- the design and the effective database generating are separated
- a task list which helps the work team to keep the tasks that need to be completed in the future, in order to finish the database structure design
Structured design is a characteristic that makes the difference between our product and other database design applications, making the design process easier and more powerful

Database System Creator Code Generator
- being written in Java it is portable across all Java Virtual Machines
- module which can be integrated in any stand-alone application
- generates Java/C/C++ source files for accessing a database
- converts SQL data types to Java/C/C++ data types
- provides access methods

Once the database structure has been created (tables, relations between tables, queries etc.) in an intuitive graphic way, the next step is to create the physical database with the help of a database management system. Because of the large number of DBMS available today, you must have a middle tier level that allows generating the database on any DBMS, transparently for designing level. Optimal Middleware is used to accomplish this necessity. Therefore, having the database structure created and saved, it is possible to create the physical database on your favorite DBMS, making no changes to the design.

In addition, it has also the possibility to debug generated SQL statements, providing step-by-step execution of statements and indicates the first failed statement in the run execution mode.

Another major task is accessing the database from high level programming languages like JAVA or C++. In order to help programmers have an easier access to a database, Database System Creator Code Generator has modules that generate the classes for each table or query that belongs to the database structure. The generated classes have data members corresponding to each field of the table/query and access methods for inserting new records, deleting records, updating records and selecting records based on a custom filter. These classes can be generated for C++ and JAVA for now, but it is also possible to extend the class generation to other programming languages.

Database System Creator Reengineer
- Database System Reengineer
- multiplatform
- visual reengineering mode
- supports a wide range of DBMS
- extraction of database structure from existing programming code
- allows application globalization

The huge amount of data stored on enterprise databases needs to be restructured and reengineered for today's rapid evolution and transformation in software systems. In order to help the reengineering of the existing databases, Database System Creator Enterprise has a component named Database System Creator Reengineer that provides DBAs and Systems Designers with the needed tools. It brings the database structure in our database design application (Database System Creator Enterprise/Lite) and redesigns it accordingly to your needs.

The structure of existing databases can be modified using the advantages offered by Database System Creator Enterprise and Database System Creator Code Generator. Our product Optimal Middleware gives the facility to import the database structure from any DBMS which supports JDBC clients.

Another way to extract database structure is from existing programming code. User defined data types, user classes and relations between them can be mapped in an efficient way in tables and relations between the tables of a database. Using the Class2DB wizard Database System Creator Reengineer looks for classes and relationships between them in selected source files and generates database structure that can be modified later in Optimal DBSystems Creator. Optimal DBSystems Reengineer proves to be a powerful tool for updating your existing project for the globalization of your applications.

System requirements
- Java ™ 2, JRE Standard Edition Version 1.3.x enabled platforms:
- Microsoft Windows 9x/NT4/2000
- Mac OS
- Linux
- Sun Solaris and various other UNIXes
- Optimal Middleware Java Version 1.0

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC03