Skip to main content
SpringerLink
Log in

Solving the Relational Data Access Problem with Data Access Services

  • Conference paper
  • First Online:
Good Practices and New Perspectives in Information Systems and Technologies (WorldCIST 2024)

Part of the book series: Lecture Notes in Networks and Systems ((LNNS,volume 989))

Included in the following conference series:

  • 14 Accesses

Abstract

The object-relational impedance mismatch problem consists of two sub-issues: language impedance and data structure mismatch. Solution to the first issue is to abstract away the programming language from SQL; to the second issue is to abstract away the object-relational transformation from developer. This paper presents three standardized data access services, query, command and repository, collectively as a preferable solution to relational data access. These services are specified declaratively with SQL and JSON. The hard object-relational transformation is delegated to service engine. This paper also presents a reference implementation of the service engine for service execution. The complexity test proves that this reference service engine is capable of handling highly complex objects up to the 5x5 level on the complexity scale developed in this research.

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 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 249.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

References

  1. Fowler, M.: ORM Hate. https://www.martinfowler.com/bliki/OrmHate.html. Accessed 09 Nov 2023

  2. Neward, T.: The Vietnam of computer science. https://www.semanticscholar.org/paper/The-Vietnam-of-Computer-Science-Neward/331e490c55ee72d6011bbceb323c03f0572a5235 (2006). Accessed 09 Nov 2023

  3. DB-Engines DB-Engines Ranking, https://db-engines.com/en/ranking. November 2023, Accessed 09 Nov 2023

  4. Bauer, C., King G.: Java Persistence with Hibernate. Manning Publications Co., 209 Bruce Park Ave. Greenwich, CT 06830 (2007)

    Google Scholar 

  5. Ireland, J.: Object-relational impedance mismatch: a framework based approach, PhD thesis The Open University (2011)

    Google Scholar 

  6. Oracle Data Access Object. https://www.oracle.com/java/technologies/data-access-object.html. Accessed 09 Nov 2023

  7. GitHub Service Builder. https://github.com/bklogic/ServiceBuilder. Accessed 09 Nov 2023

  8. GitHub data access service example. https://github.com/bklogic/data-access-service-example. Accessed 09 Nov 2023

  9. GitHub Complexity Test. https://github.com/bklogic/complexity-test. Accessed 13 Nov 2023

Download references

Author information

Authors and Affiliations

  1. BackLogic LLC, Chino Hills, CA, 91709, USA

    Ken Wang

Authors
  1. Ken Wang
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ken Wang .

Editor information

Editors and Affiliations

  1. ISEG, Universidade de Lisboa, Lisbon, Portugal

    Álvaro Rocha

  2. College of Engineering, The Ohio State University, Columbus, OH, USA

    Hojjat Adeli

  3. Institute of Data Science and Digital Technologies, Vilnius University, Vilnius, Lithuania

    Gintautas Dzemyda

  4. DCT, Universidade Portucalense, Porto, Portugal

    Fernando Moreira

  5. Institute of Information Technology, Lodz University of Technology, Łódz, Poland

    Aneta Poniszewska-Marańda

Rights and permissions

Reprints and permissions

Copyright information

© 2024 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Wang, K. (2024). Solving the Relational Data Access Problem with Data Access Services. In: Rocha, Á., Adeli, H., Dzemyda, G., Moreira, F., Poniszewska-Marańda, A. (eds) Good Practices and New Perspectives in Information Systems and Technologies. WorldCIST 2024. Lecture Notes in Networks and Systems, vol 989. Springer, Cham. https://doi.org/10.1007/978-3-031-60227-6_18

Download citation

Publish with us

Policies and ethics

Search

Navigation