Holistic Data Access Optimization for Analytics Reports
Object-Relational Mappers (ORMs) enable single language access to both the main memory data and the database data of an application. Unfortunately, they also lead to performance inefficiencies, especially in analytics applications with information-rich reports involving nested and aggregated results over large data volumes. Past database research suggests that a report over a database can be modeled by a single semi-structured query, i.e. a query involving nesting and heterogeneity. Thus, the report's data accesses can be holistically optimized through a single query.