Introduction to the Database Builder

Written by sparxsystems

font size decrease font size increase font size
Print
Email

Rate this item

(0 votes)

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 8758 times Last modified on Monday, 08 February 2016 22:33

Published in White Papers

Tagged under

Download attachments:

Introduction_to_Enterprise_Architects_Database_Builder.zip (1857 Downloads)

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 740,000 registered users worldwide.

community.sparxsystems.com

Latest from sparxsystems

Related items

More in this category: « Migrating COOL:Teamwork models into a modern CASE tool Branch / Merge with EA V13 »

2 comments

Comment Link 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 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.