Conventional recommendations for Object Oriented application design include the concept of Object-Relational Mapping and suggest clear separation of business logic from interaction with the database. While these requirements seem natural to application developers, it prevents them from using the full power of the database engine, and thereby become the most essential source of application performance degradation. Acknowledging the widespread usage of the above concepts, new approach developed at Enova provides an algorithm for “splitting” logic between different layers of classes.

We identify the parts of logic that are essential for data retrieval and thereby belong to the database, and the parts of logic that drive the computation or other data transformation and can reside in the application model. Although the splitting logic algorithm, as yet, is not implemented in any tool, we consider it an important part of the application design process. This presentation provides examples of redesigned methods as well as before-and-after performance data from the production system.

Bio

Henrietta Dombrovskaya is a database researcher and developer with over 30 years of academic and industrial experience. She holds a Ph.D. in Computer Science from University of Saint Petersburg, Russia. She taught Database and Transaction theory at the University of Saint - Petersburg (Russia), at the Computer Systems Institute in Skokie, IL and at Spherion Consulting in Chicago. Her professional experience includes consulting for a number of government projects in Chicago and New York, and providing IT services in the financial sector, manufacturing, and distribution. She is a co-author, with B. Novikov, of the book "System Tuning", BHV, S.-Petersburg, Russia. Currently with Enova, she is working closely with the application developers on creating new efficient methods of Postgres and Rails interaction.

Презентация в формате PDF: dombrovskaya20140227.pdf.

Видеозапись доклада: http://www.youtube.com/watch?v=hnvHI2e2UA4.

Литература:

1. AppSleuth: a Tool for Database Tuning at the Application Level Wei Cao and Dennis Shasha. In Proceedings of IBDT/ICDT‘13
2. Ireland, C., Bowers, D., Newton, M., Waugh, K. Exploring the Essence of an Object-Relational Impedance Mismatch - A novel technique based on Equivalence in the context of a Framework, The Third International Conference on Advances in Databases, Knowledge, and Data Applications - DBKDA 2011
3. SQLAlchemy: http://www.sqlalchemy.org/
4. Dbridge: http://www.cse.iitb.ac.in/dbms/dbridge/
5. PG Open 2013 Conference Chicago IL September 16-18 2013; abstract at http://postgresopen.org/2013/schedule/presentations/312/; presentation at http://www.youtube.com/watch?v=hamQIe9YZJw&feature=youtu.be