Object Relational Mapping

VP's Products support the generation of persistence code, including Java code and .NET source. You are allowed to generate code from database schema, class diagram and entity relationship diagram. VP's products provide an ORM Wizard to help you to configure the settings for generating persistence code step by step.

Learn more:

Generating Java Code from MySQL Database Schema guides you to generate the Java code from the MySQL database schema.

Top

The generated Java persistence code is capable of manipulating the relational database; i.e., inserting, updating, retrieving and deleting records.

You can learn how to use the generated Java persistence code by
Using Generated Java Persistence Code.

New Persistent API (DAO)

Top

Model API of Java persistence code refers to the code which is capable of manipulating the properties of the object model in terms of attributes and associations.

Using Model API with Java Persistence Class shows you how to make use of the Model API to manipulate the attributes and associations of the object models.

Top

Persistent API refers to the persistent code which is used to manipulate the persistent data; i.e. inserting, retrieving, updating and deleting records. There are four types of persistent API available, Static Method, Factory Class, POJO and Data Access Object (DAO).

You can learn more on the Persistent API:

Using Persistent API with Java Persistence Class gives a brief introduction to the Persistent API.

Using Java Persistence Class with Static Method Persistent API shows you how to use the static method persistent API to manipulate database

Using Java Persistence Class with Factory Class Persistent API shows you how to use the factory class persistent API to manipulate database

Using Java Persistence Class with POJO Persistent API shows you how to use the POJO persistent API to manipulate database

Using Java Persistence Class with DAO Persistent API shows you how to use the DAO persistent API to manipulate database

Top

Criteria class is a helper class for querying database without writing query language. It simplifies the way to query data from database.

Using Criteria Class shows you how to generate and use the criteria class.

Top

DB-VA SQL is a full featured SQL development environment for most of the popular databases in the market. DB-VA SQL enhances productivity by providing a set of useful features for database development.

Read DB-VA SQL for more details.

Top

Resource-centric interface provides the valid editing resources listing around the diagram elements which enables the easy creation of diagrams.

Learn more from Using ORM Resources of Resource Centric Interface.

Top

ORM diagram is provided to show the object relational mappings between ORM-Persistable class and its corresponding entity in two views, named as class mapping and attribute mapping.

Class mapping shows the mapping between the objects and entities while attribute mapping shows the mapping between the attributes and columns.

Learn more:

Showing Object Relational Mapping between Object and Data Models demonstrates how the ORM diagram shows the object relational mapping between object and data models.

Using ORM Diagram shows the usage of ORM diagram.

Top

An ORM pane is provided to generate the persistent model and entity from an existing object model in Java classes and database respectively such that you can modify the generated ORM-Persistable classes and entities for further development.

Learn from Using ORM Pane.

Top

Database connection must be specified in order to support the object-relational mapping and the generation of persistent code and database. Database driver is required for database connection.

VP's products provide you a feature for downloading database driver automatically. With the downloaded driver, it will be detected and specified in the database settings for any other new projects with the same type of database.

Automatic Download Database Driver shows you how to download the database driver automatically.

It is well-known that MySQL database does not support foreign key constraint by default. Supporting foreign key constraint is only available in MySQL 4 or above which consists of InnoDB engine.

Enabling Foreign Key Constraint on MySQL Database shows you how to enable foreign key constraint on MySQL Database.

VP's products allow you to select desired libraries to be included in the generated orm.jar. These libraries include cache, logging and etc.

Optimum Libraries Bundling Selection shows you how to select the optional libraries.

Top

VP's products support two types of inheritance strategy, including table per class hierarchy and table per subclass.

Learn more on the table per subclass inheritance strategy:
New Inheritance Strategy (Table per Subclass) shows you how to specify the inheritance strategy.

Top

VP's products support code engineering. There are two types of code engineering supported. VP products provide Instant Reverse facility to reverse engineer eleven types of source into UML class models. On the other hand, VP prodcusts support reverse engineering Java class and hibernate model into object models which have the capability of persistent database data.

Learn more about code engineering to class models from:
Reverse Engineering using Instant Reverse
Reverse Engineering PHP Source by Instant Reverse

Learn more about code engineering to object models from:
Reverse Engineering Java Classes to Object Models
Reverse Engineering Hibernate Model to Object Model