Skip to main content
SpringerLink
Log in

Research of Semi-automated Database Development Using Data Model Patterns

  • Conference paper
  • First Online:
Information and Software Technologies (ICIST 2020)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 1283))

Included in the following conference series:

  • 752 Accesses

Abstract

The paper focuses on the idea to semi-automate relational database development. Various approaches to ease, automate conceptual data modeling discussed. A chosen method to semi-automate conceptual data model development was pattern based-approach. This paper introduces a data model patterns library and a CASE tool to use it. Furthermore, an experiment was conducted to test the abilities of a CASE tool. The purpose of the experiment was to test the coverage and time aspects of an actual database schema reproduction using a CASE tool. Experiment results showed that patterns cover a large portion of a conceptual data model, and a new CASE tool reduces the time required to develop a conceptual data model by hand.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Exact entities – entities that have same identical name in the examplary database and in data model patterns for example “Person”, “Employee”.

  2. 2.

    Entities with the same semantic value – entities that are named the same or use synonyms or more generic names for example “Store” and “Organization” or “Customer” and “Party”.

  3. 3.

    Adventure works conceptual data model - https://github.com/vytautas101/Data-modelling/blob/master/adventure%20works/adventure%20works.png.

  4. 4.

    Reproduced conceptual data model - https://github.com/vytautas101/Data-modelling/blob/master/adventure%20works/reproduced%20model.png.

References

  1. Simsion, G.: Data Modeling Theory and Practice. Technics Publications, LLC, New York (2007)

    Google Scholar 

  2. Simsion, G., Witt, G.: Data Modelling Essentials. Morgan Kaufmann, San Francisco (2004)

    MATH  Google Scholar 

  3. Batra, D.: Cognitive complexity in data modeling: causes and recommendations. Requirements Eng. 12(4), 231–244 (2007). https://doi.org/10.1007/s00766-006-0040-y

    Article  Google Scholar 

  4. Mich, L., Franch, M., Inverardi, P.: Market research for requirements analysis using linguistic tools. Requirements Eng. 9(1), 40–56 (2004). https://doi.org/10.1007/s00766-003-0179-8

    Article  Google Scholar 

  5. Neill, C.J., Laplante, P.A.: Requirement engineering: the state of the practice. IEEE Softw. 20(6), 40–45 (2003)

    Article  Google Scholar 

  6. Song, I.-Y., Trujillo, J., Yano, K., Lujan-Mora, S.: A taxonomic class modeling methodology for object-oriented analysis. In: Information Modelling Methods and Methodologies. Advanced Topics in Databases Series, pp. 216–240. Idea Group Publishing, Hershey (2004)

    Google Scholar 

  7. Namgyu, K., Sangwon, L., Songchun, M.: Formalized entity extraction methodology for changeable business requirements. J. Inf. Sci. Eng. 24, 649–671 (2008)

    Google Scholar 

  8. Hay, D.C.: Data Model Patterns: Conventions of Though. Dorset House Publishing, New York (1996)

    Google Scholar 

  9. Chen, P.P.-S.: English sentence structure and entity-relationship diagram. Inf. Sci. 29(2–3), 127–149 (1983)

    Article  Google Scholar 

  10. Embley, D.W.: Toward semantic understanding: an approach based on information extraction. In: Proceedings of the 15th Australasian Database Conference, vol. 27, pp. 3–12 (2004)

    Google Scholar 

  11. Fowler, M.: Analysis Patterns: Reusable Object Models. Addison Wesley, Menlo Park (1997)

    Google Scholar 

  12. Coad, P., North, D., Mayfield, M.: Object Models: Strategies, Patterns, Applications. Yourdan Press, New Jersey (1995)

    Google Scholar 

  13. Shanks, G.: Conceptual data modeling process: a study of novice and expert. In: Proceedings of the 1st International Conference on Object-Role Modeling (1994)

    Google Scholar 

  14. Solomon, A., Vidya, M.: Data modeling patterns: a method and evaluation. In: Proceedings of the Fifteenth Americas Conference on Information Systems, San Francisco, California (2009)

    Google Scholar 

  15. Silverston, L.: The Data Model Resource Book, Volume 1: A library of Universal Data Models for All Enterprises. Wiley, Hoboken (2001)

    Google Scholar 

  16. Hay, D.C.: Enterprise Model Patterns: Describing the World (UML Version). Technics Publications, New Jersey (2011)

    Google Scholar 

  17. Hay, D.C.: Data Model Patterns: A Metadata Map (The Morgan Kaufmann Series in Data Management Systems). Morgan Kaufmann, San Francisco (2006)

    Google Scholar 

  18. Blaha, M.: Patterns of Data Modeling. CRC Press, Cambridge (2010)

    Book  Google Scholar 

  19. Giles, J.: The Nimble Elephant: Agile Delivery of Data Models Using a Pattern-Based Approach. Technics Publications, New Jersey (2012)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Kaunas University of Technology, Kaunas, Lithuania

    Vytautas Volungevičius & Rita Butkienė

Authors
  1. Vytautas Volungevičius
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Rita Butkienė
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Vytautas Volungevičius .

Editor information

Editors and Affiliations

  1. Kaunas University of Technology, Kaunas, Lithuania

    Audrius Lopata

  2. Kaunas University of Technology, Kaunas, Lithuania

    Rita Butkienė

  3. Kaunas University of Technology, Kaunas, Lithuania

    Daina Gudonienė

  4. Kaunas University of Technology, Kaunas, Lithuania

    Vilma Sukackė

Rights and permissions

Reprints and permissions

Copyright information

© 2020 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Volungevičius, V., Butkienė, R. (2020). Research of Semi-automated Database Development Using Data Model Patterns. In: Lopata, A., Butkienė, R., Gudonienė, D., Sukackė, V. (eds) Information and Software Technologies. ICIST 2020. Communications in Computer and Information Science, vol 1283. Springer, Cham. https://doi.org/10.1007/978-3-030-59506-7_5

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-59506-7_5

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-59505-0

  • Online ISBN: 978-3-030-59506-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation