UML2SQL—A Tool for Model-Driven Development of Data Access Layer

  • Leszek Siwik
  • Krzysztof Lewandowski
  • Adam Woś
  • Rafał Dreżewski
  • Marek Kisiel-Dorohinicki
Part of the Studies in Computational Intelligence book series (SCI, volume 260)


The article is a condensed journey over UML2SQL: a tool for modeldriven development of data access layer. UML2SQL includes an object query language and allows for behavior modeling based on UML activity diagrams, effectively linking structural and behavioral aspects of the system development. From the general idea of UML2SQL and its origins, we go through the details of its architecture and beyond the processes and schemes which make UML2SQL a distinct tool in the data access domain. Finally, an example of developing an application using UML2SQL is given as an illustration of its practical usage.


Class Diagram Activity Diagram Database Schema Business Logic Object Query 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
  2. 2.
  3. 3.
    Apache Ant 1.7.0 Manual,
  4. 4.
  5. 5.
  6. 6.
    Hibernate Reference Documentation,
  7. 7.
  8. 8.
  9. 9.
  10. 10.
    Ibm rational rose realtime. IBMGoogle Scholar
  11. 11.
    Linq: NET Language-Integrated Query,
  12. 12.
  13. 13.
  14. 14.
  15. 15.
  16. 16.
  17. 17.
  18. 18.
    Ambler, S.W.: Agile Database Techniques. John Wiley and Sons, Chichester (2003-2007)Google Scholar
  19. 19.
    Andrzejak, A.: Modelling system behaviour by abstract state machines. Technical report, ZIB Berlin (2004)Google Scholar
  20. 20.
    Ashley McNeile, N.S.: Methods of behaviour modelling - a commentary on behaviour modelling techniques for mdaGoogle Scholar
  21. 21.
    Charles, M.B., Krueger, W.: Leveraging the model driven development and software product line engineering synergy for success. Technical report, Telelogic (2008)Google Scholar
  22. 22.
    Dave Minter, J.L.: Pro Hibernate 3. Apress (2005)Google Scholar
  23. 23.
    Erich Gamma, R.J., Helm, R., Vlissides, J.: Design Patterns: Elements of Reusable Object-Oriented Software. Addison-Wesley, Reading (1994)Google Scholar
  24. 24.
    Engels, S.S.G., Hucking, R., Wagner, A.: Uml collaboration diagrams and their transformation to java (1999)Google Scholar
  25. 25.
    Harrington, J.L.: Object-Oriented Database Design. Academic Press, London (2000)Google Scholar
  26. 26.
    Warmer, J., Kleppe, A.: The Object Constraint Language: Getting Your Models Ready for MDA. Addison-Wesley, Reading (2003)Google Scholar
  27. 27.
    James Rumbaugh, I.J., Nooch, G.: The Unified Modeling Language Reference Manual. Addison-Wesley, Reading (1999)Google Scholar
  28. 28.
    Miller, J., Mukerji, J.: MDA Guide Version 1.0.1. OMG (2003)Google Scholar
  29. 29.
    OMG. Object Constraint Language. 2.0 edn. OMG (2006)Google Scholar
  30. 30.
    OMG. Unified Modeling Language: Superstructure, 2.1.1 edn. OMG (2007)Google Scholar
  31. 31.
    Sims, O.: Mda: The real value (2002),
  32. 32.
    Balker, M.J., Mellor, S.J.: Executable UML. Addison-Wesley, Reading (2002)Google Scholar
  33. 33.
    Cormen, T.H., Leiserson, C.E., Rivest, R.L., Stein, C.: Introduction to Algorithms, 2nd edn. MIT Press, Cambridge (2001)zbMATHGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2010

Authors and Affiliations

  • Leszek Siwik
    • 1
  • Krzysztof Lewandowski
    • 1
  • Adam Woś
    • 1
  • Rafał Dreżewski
    • 1
  • Marek Kisiel-Dorohinicki
    • 1
  1. 1.Department of Computer ScienceAGH University of Science and TechnologyKrakówPoland

Personalised recommendations