Skip to main content
SpringerLink
Log in
Book cover

East European Conference on Advances in Databases and Information Systems

ADBIS 2009: Advances in Databases and Information Systems pp 330–346Cite as

Conceptual Universal Database Language: Moving Up the Database Design Levels

  • Conference paper

Part of the Lecture Notes in Computer Science book series (LNISA,volume 5739)

Abstract

Today, the simplicity of the relational model types affects Information Systems design. We favor another approach where the Information System designers would be able to portray directly the real world in a database model that provides more powerful and composite data types, as those of the real world. However, more powerful models, like the Frame Database Model (FDB) model, need query and manipulation languages that can handle the features of the new composite data types. We demonstrate that the adoption of such a language, the Conceptual Universal Database Language (CUDL), leads to higher database design levels: a database modeled by Entity-Relationship (ER) diagrams can be first transformed to the CUDL Abstraction Level (CAL), which can be then transformed to the FDB model. Since, the latter transformation has been previously studied, to complete the design process, we present a set of rules for the transformation from ER diagrams to CAL.

Keywords

  • Entity Type
  • Logical Schema
  • Generic Data Modeling
  • Binary Relationship
  • Information System Designer

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.

This is a preview of subscription content, access via your institution.

Chapter
USD   29.95
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (Canada)
  • 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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Atzeni, P., Del Nostro, P., Paolozzi, S.: Ontologies And Databases: Going Back And Forth. In: 4th International VLDB Workshop on Ontology-based Techniques for DataBases in Information Systems and Knowledge Systems (ODBIS 2008), Auckland, New Zealand (2008)

    Google Scholar 

  2. Atzeni, P., Cappellari, P., Torlone, R., Bernstein, P.A., Gianforme, G.: Model-independent schema translation. The VLDB Journal 17(6), 1347–1370 (2008)

    CrossRef  Google Scholar 

  3. Anhøj, J.: Generic Design of Web-Based Clinical Databases. Journal Medical Internet Research 4 (2003), http://www.jmir.org/2003/4/e27/

  4. Cai, J., Johnson, S., Hripcsak, G.: Generic Data Modeling for Home Telemonitoring of Chronically Ill Patients. In: American Medical Informatics Association - Annual Symposium 2000 (AMIA 2000), Los Angeles, CA, pp. 116–120 (2000)

    Google Scholar 

  5. Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 3rd edn. Addison Wesley Publishing Company, Reading (2000)

    MATH  Google Scholar 

  6. Fischer, P.C., Van Gucht, D.: Determining when a Structure is a Nested Relation. In: 11th Int. Conf. on Very Large DataBases (VLDB 1985), pp. 171–180. Morgan Kaufmann, Stockholm (1985)

    Google Scholar 

  7. Johnson, S.B.: Generic data modeling for clinical repositories. Journal of American Medical Informatics Association 3(5), 328–339 (1996)

    CrossRef  Google Scholar 

  8. Johnson, S.B., Chatziantoniou, D.: Extended SQL for manipulating clinical warehouse data. In: American Medical Informatics Association Symposium (AMIA 1999), pp. 819–823. AMIA (1999)

    Google Scholar 

  9. Karanikolas, N.N., Nitsiou, M., Yannakoudakis, E.J., Skourlas, C.: CUDL language semantics, liven up the FDB data model. In: 11th East-European Conf. on Advances in Databases and Information Systems (ADBIS 2007), local proceedings, pp. 1–16. Technical Univ. of Varna, Varna (2007)

    Google Scholar 

  10. Karanikolas, N.N., Nitsiou, M., Yannakoudakis, E.J.: CUDL Language Semantics: Authority Links. In: 12th East-European Conf. on Advances in Databases and Information Systems (ADBIS 2008), pp. 123–139. Tampere Univ. of Technology, Pori (2008)

    Google Scholar 

  11. Karanikolas, N.N., Nitsiou, M., Yannakoudakis, E.J., Skourlas, C.: CUDL Language Semantics: Updating Data. Journal of Systems and Software 82(6), 947–962 (2009)

    CrossRef  Google Scholar 

  12. van Keulen, M., Vonk, J., de Vries, A.P., Flokstra, J., Blok, H.E.: Moa: extensibility and efficiency in querying nested data. Technical Report TR-CTIT-02-19. Centre for Telematics and Information Technology, Univ. of Twente, The Netherlands (2002)

    Google Scholar 

  13. Martins, J., Nunes, R., Karjalainen, M., Kemp, G.J.L.: A Functional Data Model Approach to Querying RDF/RDFS Data. In: Gray, A., Jeffery, K., Shao, J. (eds.) BNCOD 2008. LNCS, vol. 5071, pp. 153–164. Springer, Heidelberg (2008)

    CrossRef  Google Scholar 

  14. Nadkarni, P.M.: Clinical Patient Record Systems Architecture: An Overview. Journal of Postgraduate Medicine 46(3), 199–204 (2000)

    Google Scholar 

  15. Nadkarni, P.: An introduction to entity-attribute-value design for generic clinical study data management systems. Presentation in: National GCRC Meeting, Baltimore, MD (2002)

    Google Scholar 

  16. Pavković, N., Štorga, M., Pavlić, D.: Two Examples of Database Structures in Management of Engineering Data. In: 12th Int. Conf. on Design Tools and Methods in Industrial Engineering, pp. 89–90. ADM-Associazione Nazionale Disegno di Macchine, Bologna (2001)

    Google Scholar 

  17. Schek, H.J., Pistor, P.: Data Structures for an Integrated Data Base Management and Information Retrieval System. In: 8th Int. Conf. on Very Large DataBases (VLDB 1982), pp. 197–207. Morgan Kaufmann, Mexico City (1982)

    Google Scholar 

  18. Worboys, M.F., Hearnshaw, H.M., Maguire, D.J.: Object-Oriented Data Modelling for Spatial Databases. Int. Journal of Geographical Information Systems 4(4), 369–383 (1990)

    CrossRef  Google Scholar 

  19. Yannakoudakis, E.J., Tsionos, C.X., Kapetis, C.A.: A new framework for dynamically evolving database environments. Journal of Documentation 55(2), 144–158 (1999)

    CrossRef  Google Scholar 

  20. Yannakoudakis, E.J., Diamantis, I.K.: Further improvements of the Framework for Dynamic Evolving of Database environments. In: 5th Hellenic – European Conf. on Computer Mathematics and its Applications (HERCMA 2001), Athens, Greece (2001)

    Google Scholar 

  21. Yannakoudakis, E.J., Nitsiou, M., Skourlas, C., Karanikolas, N.N.: Tarski algebraic operations on the frame database model (FDB). In: 11th Panhellenic Conf. in Informatics (PCI 2007), pp. 207–216. New Technologies Publications, Patras (2007)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Informatics, Technological Educational Institute of Athens, Greece

    Nikitas N. Karanikolas

  2. Department of Computer Science and Biomedical Informatics, University of Central Greece, Lamia, Greece

    Michael Gr. Vassilakopoulos

Authors
  1. Nikitas N. Karanikolas
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Michael Gr. Vassilakopoulos
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institute of Applied Computer Systems, Riga Technical University, Kalku iela 1, LV 1658, Riga, Latvia

    Janis Grundspenkis

  2. Institute of Computing Science, University of Technology, Piotrowo 2, 60-965, Pozna´n, Poland

    Tadeusz Morzy

  3. European Research Center for Information Systems, University of Münster, Leonardo Campus 3, 48149, Münster, Germany

    Gottfried Vossen

Rights and permissions

Reprints and Permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Karanikolas, N.N., Vassilakopoulos, M.G. (2009). Conceptual Universal Database Language: Moving Up the Database Design Levels. In: Grundspenkis, J., Morzy, T., Vossen, G. (eds) Advances in Databases and Information Systems. ADBIS 2009. Lecture Notes in Computer Science, vol 5739. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03973-7_24

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-03973-7_24

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-03972-0

  • Online ISBN: 978-3-642-03973-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Search

Navigation