Abstract
The Third Manifesto (TTM) presents the principles of a relational database language that is free of deficiencies and ambiguities of SQL. There are database management systems that are created according to TTM. Developers need tools that support the development of databases by using these database management systems. UML is a widely used visual modeling language. It provides built-in extension mechanism that makes it possible to extend UML by creating profiles. In this paper, we introduce a UML profile for designing databases that correspond to the rules of TTM. We created the first version of the profile by translating existing profiles of SQL database design. After that, we extended and improved the profile. We implemented the profile by using UML CASE system StarUML™. We present an example of using the new profile. In addition, we describe problems that occurred during the profile development.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
C.J. Date and H. Darwen, Databases, Types and the Relational Model, 3rd ed.. Addison Wesley, 2006.
J. Melton (Ed.), IWD 9075-2:200x (E) Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation). April, 2006.
Object Management Group, Unified Modeling Language: Superstructure, version 2.1.1, formal/2007-02-03. February 2007.
MDA Guide Version 1.0.1, OMG document omg/03-06-01, 2003.
E. Marcos, B. Vela, and J.M. Cavero, “A Methodological Approach for Object-Relational Database Design using UML,” Journal on Software and Systems Modeling, vol. 2, pp. 59-72, 2003.
S.W. Ambler and P.J. Sadalage, Refactoring Databases: Evolutionary Database Design. Addison Wesley, 2006.
D. Gornik, “UML Data Modeling Profile,” Rational Software White Paper TP162, 05/2002.
D. Voorhis, “An Implementation of Date and Darwen's Tutorial D database language,” [Online document] [2009 June 29], Available at http://dbappbuilder.sourceforge.net/Rel.php
“Dataphor,” [Online document] [2009 June 29], Available at http://dataphor.org
E. Eessaar, “On Translation-Based Design of UML Profiles,” in Proc. SCSS 07, 2008, pp. 144-149.
S.L. Mora, J. Trujillo, and I.Y. Song, “Extending the UML for Multidimensional Modeling,” in Proc. UML 2002, 2002, LNCS 2460, pp. 290-304.
E. Eessaar, Relational and Object-Relational Database Management Systems as Platforms for Managing Software Engineering Artifacts, Ph.D. thesis, Tallinn University of Technology, 2006. Available at http://digi.lib.ttu.ee/i/?85
C.J. Date, An Introduction to Database Systems, 8th ed.. Boston: Pearson/Addison Wesley, 2003.
C.J. Date, The Relational Database Dictionary. O'Reilly, 2006.
“StarUML – The Open Source UML/MDA Platform,” [Online document] [2009 June 29], Available at http://staruml.sourceforge.net
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer Science+Business Media B.V.
About this paper
Cite this paper
Eessaar, E. (2010). A UML Profile for Developing Databases that Conform to the Third Manifesto. In: Sobh, T., Elleithy, K. (eds) Innovations in Computing Sciences and Software Engineering. Springer, Dordrecht. https://doi.org/10.1007/978-90-481-9112-3_12
Download citation
DOI: https://doi.org/10.1007/978-90-481-9112-3_12
Published:
Publisher Name: Springer, Dordrecht
Print ISBN: 978-90-481-9111-6
Online ISBN: 978-90-481-9112-3
eBook Packages: Computer ScienceComputer Science (R0)