Advertisement

Connecting Galaxies: Bridging the Gap Between Databases and Applications

  • Henrietta Dombrovskaya
  • Jeff Czaplewski
  • Boris NovikovEmail author
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 12011)

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

Database connectivity Complex objects Impedance mismatch Performance 

References

  1. 1.
    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/
  2. 2.
    Baxter, R.: Improving site speed - talk about the business benefit, October 2017. https://builtvisible.com/improving-site-speed-talk-about-the-business-benefit/
  3. 3.
    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)Google Scholar
  4. 4.
    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)Google Scholar
  5. 5.
    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)Google Scholar
  6. 6.
    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)Google Scholar
  7. 7.
    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)Google Scholar
  8. 8.
    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)Google Scholar
  9. 9.
    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 Scholar
  10. 10.
    Google’s push to speed up your web site, October 2017. https://searchengineland.com/googles-push-to-speed-up-your-web-site-42177/
  11. 11.
    Hibernate web site (2017). http://www.hibernate.org/about/
  12. 12.
    How loading time affects your bottom line, March 2015. https://blog.kissmetrics.com/loading-time/
  13. 13.
    Speed is a killer? Why decreasing page load time can drastically increase conversion, March 2015. https://blog.kissmetrics.com/speed-is-a-killer/
  14. 14.
    Kumar, A.: Ml/Ai systems and applications: is the SIGMOD/VLDB community losing relevance? August 2018. https://wp.sigmod.org/?p=2454
  15. 15.
  16. 16.
    MongoDB (2018). https://www.mongodb.com/
  17. 17.
  18. 18.
    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)Google Scholar
  19. 19.
    SQLAlchemy (2015). http://www.sqlalchemy.org/
  20. 20.
    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

Copyright information

© Springer Nature Switzerland AG 2020

Authors and Affiliations

  1. 1.Braviant HoldingsChicagoUSA
  2. 2.National Research University Higher School of EconomicsSaint PetersburgRussia

Personalised recommendations