#DICE project: latest video available now online

Find out all about the #DICE project in our latest video available now online

DICE video

DICE is a new Horizon 2020 research and innovation action started in February 2015, funded under the ICT-09-2014 sub-call. DICE aims at defining a framework for quality-driven development of Big Data applications. DICE will offer a novel UML profile and tools that will help software designers reasoning about reliability, safety and efficiency of data-intensive applications. The DICE methodology will cover quality assessment, architecture enhancement, continuous testing and agile delivery, relying on principles of the emerging DevOps paradigm.

Please visit:

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.


Y llegó MOSKitt 1.0.0

Para todo aquel que no se haya enterado, este pasado verano se publicó sin mucho ruido la versión 1.0.0 de MOSKitt. Y se hizo sin mucho ruido porque así es cómo hemos llegado a este primer gran hito del proyecto: poco a poco, dando pequeños pasos firmes y sin grandes sobresaltos. De manera que cuando mira atrás no puede sino confirmar que esta versión no podía haber sido de otra manera.

Cuando empezó el proyecto en 2007, el objetivo de MOSKitt (entonces gvCASE) era proporcionar las herramientas necesarias para que los analistas de sistemas informáticos de la MOSKitt DB EditorConselleria de Infraestructras y Transportes (CIT) de la Generalitat Valenciana pudieran realizar su trabajo aplicando el método gvMétrica. Pero no sólo eso, sino que las distintas piezas de esta gran herramienta debían ser suficientemente genéricas para poder ser utilizadas en organizaciones con métodos de producción de software distintos. Llegados a la versión 1.0.0, MOSKitt cuenta con un amplio abanico de herramientas para el modelado de sistemas software, transformaciones entre modelos para agilizar la ejecución de los proyectos de desarrollo y diferentes mecanismos de extensión y configuración que facilitan su adaptación a cualquier organización.

Distribuir contenido