System and method for self tuning object-relational mappings

摘要

A system and method for database access by an application program includes a database interface that receives a request to access database data that includes a set of parameters. A mapping module determines the place in the application program code that requested the database data. A retrieval module reads a set of usage statistics and amends the set of parameters based on the usage statistics. A load module fetches the database data and data for related objects that are likely to be accessed from the requested data, based on the amended parameters. Once the database data has been loaded, a tracking module tracks the database data and updates the set of usage statistics accordingly.