Abstract
An incompatibility of object-oriented application code and relational database engine often causes performance problems, known as Impedance Mismatch, which negatively affect business-critical application functions. The incompatibility can also over-complicate application design and increase the costs of development.
We address these issues, applying a concept of the API contracts to the interaction between the application and the database. We introduce a new technique providing for the transfer of complex objects rather than low-level records. We describe the implementation of the proposed solution in industrial settings and show how suggested techniques streamline the application development, at the same time providing significant performance gains.
Keywords
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
How one second could cost amazon \$1.6 billion in sales, March 2015. http://www.fastcompany.com/1825005/how-one-second-could-cost-amazon-16-billion-sales/
Baxter, R.: Improving site speed - talk about the business benefit, October 2017. https://builtvisible.com/improving-site-speed-talk-about-the-business-benefit/
Cao, W., Shasha, D.: AppSleuth: a tool for database tuning at the application level. In: Proceedings of the 16th International Conference on Extending Database Technology, EDBT 2013, pp. 589–600. ACM, New York (2013)
Celko, J.: Joe Celko’s Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL. Data Management Systems, 1st edn. The Morgan Kaufmann, San Francisco (2008)
Chaudhuri, S., Narasayya, V., Syamala, M.: Bridging the application and DBMS divide using static analysis and dynamic profiling. In: Proceedings of the 2009 ACM SIGMOD International Conference on Management of Data, SIGMOD 2009, pp. 1039–1042. ACM, New York (2009)
Dombrovskaya, H., Lee, R.: Talking to the database in a semantically rich way. In: Amer-Yahia, S., Christophides, V., Kementsietsidis, A., Garofalakis, M.N., Idreos, S., Leroy, V. (eds.) Proceedings of the 17th International Conference on Extending Database Technology, EDBT 2014, Athens, Greece, 24–28 March 2014, pp. 676–687. OpenProc.org (2014)
Dombrovskaya, H., Rangarajan, S., Marks, J.: FastFunction: replacing a herd of lemmings with a cheetah a ruby framework for interaction with PostgreSQL databases. In: 32nd IEEE International Conference on Data Engineering, ICDE 2016, Helsinki, Finland, 16–20 May 2016, pp. 1275–1286. IEEE Computer Society (2016)
Emani, K.V., Deshpande, T., Ramachandra, K., Sudarshan, S.: DBridge: translating imperative code to SQL. In: Proceedings of the 2017 ACM International Conference on Management of Data, SIGMOD 2017, pp. 1663–1666. ACM, New York (2017)
Emani, K.V., Ramachandra, K., Bhattacharya, S., Sudarshan, S.: Extracting equivalent SQL from imperative code in database applications. In: Proceedings of the 2016 International Conference on Management of Data, SIGMOD 2016, pp. 1781–1796. ACM, New York (2016)
Google’s push to speed up your web site, October 2017. https://searchengineland.com/googles-push-to-speed-up-your-web-site-42177/
Hibernate web site (2017). http://www.hibernate.org/about/
How loading time affects your bottom line, March 2015. https://blog.kissmetrics.com/loading-time/
Speed is a killer? Why decreasing page load time can drastically increase conversion, March 2015. https://blog.kissmetrics.com/speed-is-a-killer/
Kumar, A.: Ml/Ai systems and applications: is the SIGMOD/VLDB community losing relevance? August 2018. https://wp.sigmod.org/?p=2454
Language-Integrated Query (LINQ) (2017). https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/linq/
MongoDB (2018). https://www.mongodb.com/
NoSQL (2018). http://nosql-database.org/
Pavlo, A.: What are we doing with our lives?: nobody cares about our concurrency control research. In: Proceedings of the 2017 ACM International Conference on Management of Data, SIGMOD 2017, p. 3. ACM, New York (2017)
SQLAlchemy (2015). http://www.sqlalchemy.org/
Stonebraker, M.: The “NOSQL” discussion has nothing to do with SQL, November 2009. https://cacm.acm.org/blogs/blog-cacm/50678-the-nosql-discussion-has-nothing-to-do-with-sql/fulltext
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
Dombrovskaya, H., Czaplewski, J., Novikov, B. (2020). Connecting Galaxies: Bridging the Gap Between Databases and Applications. In: Chatzigeorgiou, A., et al. SOFSEM 2020: Theory and Practice of Computer Science. SOFSEM 2020. Lecture Notes in Computer Science(), vol 12011. Springer, Cham. https://doi.org/10.1007/978-3-030-38919-2_54
Download citation
DOI: https://doi.org/10.1007/978-3-030-38919-2_54
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-38918-5
Online ISBN: 978-3-030-38919-2
eBook Packages: Computer ScienceComputer Science (R0)