[postgis-users] UML Profile using PostGIS geometry types and SQL-MMtopology functions

[Norman Barker]

Hi,

 

I am not sure that UML to database is going to achieve that much in
terms of mapping, but certainly UML to object (so ejb3 or geodjango)
and hence database might be interesting.  To this end hibernate tools is
useful (and generates schematics) and just changing the free marker
templates allows geometry mappings.

 

Most of the work in this area has been in UML to xml schema mapping, and
to this end the models (including EA Architect) from
http://www.isotc211.org/ might be of use.

 

If I were doing this work, then the tool I would use would be the new
eclipse UML tools, just because these are publicly available to
everyone, and the XMI they output would be useful in a lot of projects.

 

ERD tools such as dbdesigner for mysql already support spatial
functions, hence why I am struggling to see the benefit of your approach
- can you explain some more?

 

Thanks,

 

Norman

 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Fonseca Hespanha de Oliveira, Joao da
Sent: Thursday, November 08, 2007 11:12 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] UML Profile using PostGIS geometry types and
SQL-MMtopology functions

 

Hello all! 
 
As part of my current PhD research, I am trying to specify a new UML
Profile to apply to UML Class diagrams representing spatial features,
that is, using geometry types. 
 
I am using PostgreSQL's PostGIS extension as reference for the actual
geometry types, but I think it could be applied to any spatial database
system which complies to the Simple Features Access for SQL
specification. 
 
Currently, also geometry types from SQL/MM ISO/IEC standard are also
being supported by such databases, and at least some will be added to
the Profile. 
 
I would like to receive any suggestions this forum members might have, I
am currently using Enterprise Architect (EA) as UML Modeling Tool and I
plan to present (attach) PDF files with the class diagrams and the final
Profile. Maybe the profile could be added to the EA add ons later on,
otherwise it could be transposed to other UML Tools.
 
If somebody has a suggestion on any other way to interact, with or
without EA software, ideas are also most welcome. 

 

The final aim of this research component is to define a CASE tool which
can use a UML model with the mentioned profile to generate a PostGIS
schema through an automatic generated SQL script (a process generally
known as Model-to-Text transformation).


Looking forward to hear from you, 
Joao Paulo Hespanha 
PhD Student, OTB Research Institute, 
TUDelft 
The Netherlands

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071108/b1ea8ca2/attachment.html>