MOSKittGeo: from UML to Spatial Databases and back

Probably some of you do a real engineering process to build your GIS projects, I mean, the classical analyse-design-implement cycle. As a GIS is in fact an Information System with the (complex of course) spatial component, one should expect that the common tools and methodologies of «normal Information Systems» are available for GIS engineers but on the case of database modelling that’s not so common.

So, what happens when you want to design a GIS data model? Well, one usually had to use a “fake” geometry type on your CASE tool of choice and afterwards create the geometry columns by hand or using custom post-processes.

Until now, because my smart colleagues at Prodevelop have developed an extension to the MOSKitt software called MOSKitt Geo that adds the spatial data type to the UML and Entity-Relationship models so you can perform the regular design process on MOSKitt: you do your UML model, then you convert it to the Entity-Relationship model and then you select your target database and MOSKitt creates the DDL scripts automatically.

MOSKitt ER designer

Even more, you can also do reverse engineering of your spatial database and redesign or improve you data models using excellent MOSKitt graphical tools!

Take a look on these videos from the new Prodevelop YouTube channel to see how it works and go (and comment!) to the Carlos post about MOSKitt Geo at Prodevelop blog.

8 thoughts on “MOSKittGeo: from UML to Spatial Databases and back

  1. Luca

    very interesting project! however, I’m not able to download the plugin GEO … seems you should be logged. it’s charges plug?
    good job!

  2. Luca

    Hi Jorge,
    tnx for answer me.
    following your link “instructions”, it seems that I should register and then login to see the slides? correct?

    tnx again

  3. Jorge Post author

    Sorry Luca, it was our fault, the wiki page is not published 😦

    I’ve uploaded a PDF export of the howto while the sysadmins republish the thing so you can see the document right now.

    Here it is

  4. Luca

    thank you so much Jorge!
    now I have read and understood, I hope in the coming days to be able to test this interesting software.

    tnx again.

  5. Luca

    Hello Jorge,
    Excuse me if I always ask yourself, following your guide in pdf when I go to open moskitt.exe I get a screen displaying various procedures and then the installation does not start.
    There are particular pre-requisites of the system?
    In prodevelop site I found nothing!

    thank you again and sorry!

Comments are closed.