"Seegrid will be due for a migration to confluence on the 1st of August. Any update on or after the 1st of August will NOT be migrated"

UML to Database tool

Related pages

Contents

Description

This tools provides a configrurable ability to transform an information model - i.e. a PIM (Platform Independent Model) to a specific database schema ( DDL ).

Most UML tools provide some ability to do this, but this tool specifically supports the concept of a shared domain model, made of libraries or re-usable model components.

This tool provides the ability to create a database schema for each model package, allowing isolation of changes when the model is used to document and maintain complex databases.

This tool allows complex data types (such a spatial and temporal) to be mapped to multiple database columns. Tables are created for each featureType class. Inheritance is handled by extension tables and views to implement joins.

The goal is to provide a template for a database designer to optimise the database design, having captured every part of the source model. Schemas can be optimised

  • Allow user to customize the data type mapping between ISO defned conceptual data types and database data types.

  • Current library of mappings supports several different database technologies, including Oracle, PostgresSQL, MySQL and SQLServer database.

  • Automatically generate primary keys and foreign keys for a PIM (Platform Independent Model)

  • Creates views to join base and extension tables to support specialisation (inheritance)

  • Support for dependencies - locate and include imported model packages, (in future use pre-defined database schemas from libraries).

(Much more description is required here of the specific strategies)

Tutorial

From Confluence wiki page.

To use this function, follow steps below:

1. Right-click on the selected package in the Project Browser. Select the "UML to Database" item from the "AHGF Modelling Toolset" Add-in.

2. Select the database vendor type. When you generate SQL DDL for your UML model, it conforms to the database type that you select here.

3. Select one of more packages which you want to transform to a database schema from the "Select working Packages" window

4. Specify the data type mapping file. This data type mapping file is a XML file. It tells the application how to map a UML data type to the selected database data type. For example, To map the ISO 19100 data type "CharacterString" to Oracle data type "VARCHAR2", the following xml element need to be added in the mapping file.
  • you may provide your own customised datatype mapping file
  • in future, each model library can provide mapping files for the packages contained in the library, or one per package

5. Provide the target location and name for the generated DDL file.

6. A set of DDL files will be generated after you click on the "Run" button * NB - at this stage the user needs to execute multiple files in the correct order to address dependencies.

 
Topic revision: r4 - 15 Oct 2010, UnknownUser
 

Current license: All material on this collaboration platform is licensed under a Creative Commons Attribution 3.0 Australia Licence (CC BY 3.0).