LADM Specification of a Relational Database for the Republic of Cape Verde

Abstract

The Land Administration Domain Model - LADM describes the relations between person and land regarding rights, restrictions and responsibilities. This relation is described through diagrams of UML classes, a graphic language which focuses on objects, and represents different levels of abstraction of the real world by visualizing the work flux of the database and its planning. In this article the classes and their relationships were modeled using a unified modeling language, which considered the national reality and the law decree that establishes the judicial regime of the Cadastre of the Republic of Cape Vert. The transformation of this model into a relational database by using the Postgres and PostGis, was not an easy task due to compatibility problems. The study was based on the application of the OMG (Object Management Group) models, MDA (Model Driven Architecture) and the CASE (Computer-Aided Software Engineering) tools. As a result, the study presents the transformation of the model into a relational database and consequent generation of SQL Codes. For this specification the Visual Paradigm for UML was used, which is a CASE tool with various modeling options with the UML2 diagrams, offering support for specific transformations for source codes of some programming languages, such as C++ and Java etc. Despite the fact that this platform offers a direct solution for the transformation of UML into a Java code, and consequently into SQL commands, it has a great disadvantage which is the absence of the OCL language, used as one way of validating the model.