Object-relational mapping

To implement the object concepts, Netsilon works out an object-relational mapping whose semantic is particular. Each object is identified by an object id whose column is found in each table. An object identifier carries also an identification of the class of the corresponding object. A particular table, instances, is at the same time used to check the class of an object and to find the whole of the definite objects. An other table, reference, when it exists, is used internally by Netsilon to store information needed in the incremental modification process of a database schema.

Each deployment site has a specific object-relational mapping. Netsilon converts the name of the model elements to a name valid in an SQL context. A name of a table can be prefixed if a prefix is defined in the database properties. During incremental schema modification, Netsilon only considers the tables whose name starts with the prefix. It keeps the name it first gave to a model element weather the name of this element is changed or not in the future.

Netsilon authorizes the modification of the naming of the tables and the attributes in the generated schema and has a command to edit the mapping. The table name should be prefixed with the prefix specified in the database properties or else Netsilon will recreate the table during the next deployment. The modifications made to the mapping must also be made manually to the schema before the next deployment or existing data will be destroyed.

When a class is deleted from the business model, it is of primary importance to let Netsilon update the data base under penalty of obtaining null objects during execution. If the database is not accessible on line, a local copy can be made, updated and reinstalled on the site.

 
TOC ] Previous ] Next ]