Enterprise Architect version 13

download
purchase

English Chinese (Simplified) Czech Dutch French German Italian Korean Polish Portuguese Russian Slovak Spanish Swedish

My Profile

Social Media Channels

facebook google plus twitter youtube linkedin

Wednesday, 03 February 2016 21:47

Introduction to the Database Builder

Written by 

enterprise architect for database administrator roles banner

Enterprise Architect’s Database Builder provides interactive connectivity to a DBMS,  supporting both the initial creation of a database and the ongoing update of tables, views, triggers and procedures – all from within the design model.

 

This tutorial paper works through a simple database example (attached in .ZIP file) using the Database Builder to create tables within a new Database, then make modifications in both the model and the Database and use the compare functionality to update the Database and the model respectively.

Read 3707 times Last modified on Monday, 08 February 2016 22:33
Rate this item
(0 votes)
sparxsystems

Sparx Systems


99 Albert Street
Creswick,
Victoria
3363
Australia
P: +61 3 5345 1140
F: +61 3 5345 1104
 
Sparx Systems specializes in high performance and scalable visual modeling tools for the planning, design and construction of software intensive systems. A Contributing Member of the Object Management Group (OMG), Sparx Systems is committed to realizing the potential of model-driven development based on open standards. The company’s flagship product, Enterprise Architect, has received numerous accolades since its commercial release in August, 2000. Enterprise Architect is the design tool of choice for over 380,000 registered users world-wide.

Website: community.sparxsystems.com

2 comments

  • Comment Link sparxsystems Monday, 08 February 2016 22:40 posted by sparxsystems

    Hello Phil and thanks for the info, we've identified a bug in the MDA transform in the latest build. The issue has been prioritized and I'm confident that it will be addressed in an upcoming release if it hasn't been resolved in one of our current development builds.

  • Comment Link philchudley Thursday, 04 February 2016 13:33 posted by philchudley

    Interesting

    I am using version 12.1 build 1227 and when I perform the MDA transformation of the supplied logical data model as shown in the paper, the UML types of String, Integer etc do not get transformed into VARCHAR etc as shown in the paper.

    When attempting the use Database datatyppes I have noticed that for all DBMS you can only specify a mapping from Common Types to Data Types

    BUT the UML types of String, Integer, Boolean etc are NOT listed hence it is not possible to specify a mapping from UML to DBMS.

    If this paper is followed, the result of the MDA to MySQL results in UML String types being transformed into String (that is a verbatim transform)

    Any advice/comments on how you can transform UML types to DBMS types (eg String -> VARCHAR(50) would be most appreciated.

Login to post comments