System and method for adaptively optimizing queries
US6748373B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 17, 2002 |
| Grant date | Jun 8, 2004 |
| Priority date | — |
| Expiry date | Nov 10, 2022 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99944
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.