System and method for adaptively optimizing queries

Abstract

The performance of a database system can be improved by tracking the way in which data is accessed. By tracking such information, it is possible to load frequently-accessed fields of an entity bean, as well as related beans that are frequently accessed, by optimizing a field group for that entity bean. It is also possible to use the tracking information to prevent infrequently accessed fields from being automatically loaded. Information to be monitored can include how often each field is accessed, how many times a particular entity or application accesses a field, and how often a field is accessed for a given transaction context. By using this information to periodically optimize field groups, the fields and associated entity beans that are most often accessed, such as by the entity and/or transaction causing the entity bean to be loaded, can be automatically loaded when an entity bean is loaded into a container. This lowers database traffic and the volume of data transfer by simultaneously loading the fields most likely to be accessed, and not loading data unlikely to be accessed.

Dependencies are inferred from the claim text.