O/R Type Mapping

One of the problem in writing database application is the mapping the data types between the programming language and the database. Since there are so much databases in our world and each have it’s own set of data types. This is a real trouble and make your application almost impossible to become portable across different platforms. In VP Suite 2.2 SP1, we do the automatic type mapping for your class model and ER model, thus you do not need to handle this mundane work and we help making your application portable across different database.

Number type in oracle can used to represent multiple data types in our programming languages, for example, number(1) can use to represent boolean and number (5) can represent a variable with type short. VP Suite 2.2 SP1 helps you to map the number type into compatible data type for your programming language. Even number with length between 2 data type, we will pick the suitable type for you automatically.

With VP Suite 2.2 SP1, no matter you are working on the object model or the ER model, we will help you to synchronize the model with the correct data type.

Example:

1. Update the type from Integer to Long, then synchronize to ERD.
   
   
   
2. A dialog is shown to ask for changing data type.
   
   
   
3. The ERD is updated.