Home / Products / Prosasql



Prosasql SQL generator

Prosa is an unbeatable tool environment for developing database applications. Prosa ensures complete and verified path from user requirements to UML modeling, validation, documentation and implementation. When the implementation contains a database, Prosasql realizes in practice the living connection between requirements and implementations.

Visual database development

Prosa UML modeler visualizes database requirements with the UML model. By this way the UML model of the database is in a unique way connected with business process, markets and user requirements. Visualization clarifies communication between all interest groups of the development.

Click to enlarge
Click to enlarge

Databases automatically from UML diagrams

Prosa Prosasql produces SQL code from UML class diagrams. The produced SQL code contains creation statements for database tables, views and indices. Prosasql produces also basic queries in C++ format.

SQL standards and dialects are supported

Prosasql conforms to ISO and ANSI SQL standards and supports directly the common commercial database management systems like DB2, Oracle and SQL Server. The user easily can define new dialects to Prosasql generator.

Prosasql supports abstract data types, which gives possibility to generate both database and C++ or Java classes from the same model.

Excellent checking functions

Prosasql produces database integrity maintenance statements automatically from diagrams. Prosasql offers powerful checking and reporting support for database development and normalization.



Databases will be documented concurrently

Prosa Prosacdm document manager and web publisher realizes concurrent documentation of databases. Documentation and development will be continuously in synch, which improves total quality and productivity.

Simulator tests database applications visually

Prosa Prosasim simulator makes the static UML model dynamic, living model. Prosasim shows the real functionality of the model graphically. The modeling power of database applications increases essentially and the errors will always be detected in the earliest possible phase.

C++ and Java generators produce data processing portions and user interfaces

Prosa Prosacpp C++ generator and Prosaj Java generator automate the development of the functional parts of the application. Generators produce C++ and Java member functions with a single mouse click from UML statechart and activity diagrams.

Click to enlarge






To the point:

Seamless path from requirements to SQL database implementation.

Concurrent documentation of databases.

SQL-DDL and SQL-DML generation from UML class diagrams.

Checking of the relational model.

DB2, Oracle, SQL Server, ANSI and ISO standard support.

User may easily define new SQL dialects.

Simulation of database applications with Prosasim simulator (option)

Complete C++ generation with Prosacpp generator (option)

Complete Java generation with Prosaj generator (option)

Prosasql visualizes database development