Moskitt-GEO Modelling Spatial Databases

Nowadays it's very common the use of UML2 for designing new databases.

The use of UML Case Tools that allow the schema generation could be a big help for database administrators. However, there isn't a good support for geospatial databases yet. Geospatial databases are a special design case not covered by most popular UML design tools.

Modelling Software KIT (MOSKitt) is a free Case Tool, built on Eclipse which is being developed by the Valencian Regional Ministry of Infraestructure and Transport (for the purpose of this document referred to as CIT) to support the gvMétrica methodology (adapting Métrica III to its specific needs). gvMetrica uses techniques based on the UML modeling language.

MOSKitt's plugging architecture makes it not only a Case Tool but also a free modelling platform to develop this kind of tools.

MOSKitt is being developed within the gvCASE project framework. This is one of the projects integrated in gvPontis, the CIT’s global project for the migration of its entire technological environment to free Software.

Prodevelop is the main development leader of the project, with a high-skilled team of software engineers specialized on modelling tools and projects on top of eclipse frameworks. Prodevelop is also company with years of experience developing Geospatial solutions mainly in the open-source arena.

From the sinergy of combining the modelling and geospatial realms, we started the development of a new Moskitt plugging which will add geometry support for spatial databases.

The goal was to allow the design from UML class diagrams. Now it's available a new primitive type named Geometry. This special primitive type can be configured for the selected spatial database adding restrictions as the following ones:

  • Geometry Type.
  • Coordinate Dimension.
  • Reference System (using EPSG codes).
  • Spatial Indexes.
  • Oracle Coordinate Tolerance.
  • Oracle Coordinate Bounding Box.

Moskitt-GEO Class Diagram

Once the UML diagram has been finished with the structure of the database, the next step is to apply and automatic transformation to generate a database diagram, and check the database design with the new Geometry types included as columns inside the generated tables.

Finally, the last step is to generate an spatial database DDL (Data Description Language). Oracle Locator 10g and PostGIS extension for PostgreSQL are supported.

Moskitt-GEO also adds geospatial databases support for the reverse engineering process, generating a datase model out from an existing geospatial database, including geometries and its restrictions. So good news for spatial databases designers.

Finally, the next video shows how to create an spatial database using Moskitt-GEO from UML Diagram with geometry data, doing the right spatial transformations until generate a DDL.

The second video explains how to get a database schema diagram from existing database.

 

Hi there, very interesting

Hi there,
very interesting project but i have a problem, following the instruction on how to install when I go to duble klik moskitt.exe I get a screen displaying various procedures and then the installation does not start.
There are particular pre-requisites of the system? (I have Win xp32 in notebook)
I downloaded the latest version from moskitt.org.

tnx
Luca

Imagen de csanchez

Hi Luca, Can't you unzip

Hi Luca,

Can't you unzip Moskitt, run it after unzip or maybe fails the GEO extension installation?
If your problem it's the second one, and you are using Win XP follow these steps.

-After unzip MOSKitt, go to "moskitt" created folder.
-Edit MOSKitt.ini file.
-Find next line "-Xmx1024m" and change it with "-Xmx512m"
-Save MOSKitt.ini file.
-Try to execute MOSKitt.exe again

(This bug only appears on Win, with last Moskitt version)

I would like that you give me more information about the bugs or problems you found and your testing experience.

There are a Moskitt support mail list, where you can send mails with all your doubts and bugs. Send the mail to
moskitt-support [at] lists [dot] moskitt [dot] org
Moreover if you want subscribe to this list follow the link
https://moskitt.org/lists/mailman/listinfo/moskitt-support

Thanks very much for your interest on this project, the incoming version will add MySQL spatial support :-)
You could check for it soon.

Kind Regards!

hi there!! sorry sorry sorry

hi there!!

sorry sorry sorry for the late response...with all the changes you indicated, now it's works fine!!!

I found an alternative method but do not start Mosskitt on geo-mode (starting directly the *.jar file)!

So tnx a lot...to date have not been able to test well the geo mode, but I hope to do so in the coming months.

I use postgreSQL + qgis + vfront for tring to build a managing land for farms.

Tnx again for solution.

I hope soon to give you some feedback.

bye and
Good work
Luca

Hi all, thx for these very

Hi all,

thx for these very interesting instructions.
I have a problem when i'm trying to transform UML class diagramm to spatial database (1st step in my goal to generate a DDL to create an sql script for postGIS).
- right click on my uml file --> Moskitt transformations --> UML2 class diagramm to spatial database transformation
- I enter my input and output parameters
- default configuration
- Moskitt tells me that my parameters are valid
- in the last window after clicking "next" Moskitt tells in a 1st message "The transformation has been executed." and in the same window at the bottom "transformation result Something went wrong when executing the transformation" and there is no error script...

I don't really know where is the source of my problem... if it happens for someone can you help please

thx in advance

Vivien
Montpellier - France

ps : sorry for my french-english

I have exactly the same

I have exactly the same problem. Can anyone help us to solve it please? Thanks!

I have spent all the noon

I have spent all the noon dealing with same problem, after watching this page (https://confluence.prodevelop.es/display/MOSG/How-To+Install+Moskitt+Geo...) i had and idea (downgrade the moskitt), on the page says 1.3.0....and that works for me.

Juan David

Bogotá, Colombia

Now i must say sorry for my spanish-english too

Opciones de visualización de comentarios

Seleccione la forma que prefiera para mostrar los comentarios y haga clic en «Guardar las opciones» para activar los cambios.

Enviar un comentario nuevo

  • Las direcciones de las páginas web y las de correo se convierten en enlaces automáticamente.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <span> <img>
  • Saltos automáticos de líneas y de párrafos.
  • Each email address will be obfuscated in a human readble fashion or (if JavaScript is enabled) replaced with a spamproof clickable link.

Más información sobre opciones de formato

Distribuir contenido