Invention Grant
US07647296B2 Method for estimating a first access time of transactions accessing a database object
失效
用于估计访问数据库对象的事务的第一访问时间的方法
- Patent Title: Method for estimating a first access time of transactions accessing a database object
- Patent Title (中): 用于估计访问数据库对象的事务的第一访问时间的方法
-
Application No.: US11376937Application Date: 2006-03-15
-
Publication No.: US07647296B2Publication Date: 2010-01-12
- Inventor: Robert W. Lyle , Michael J. Winer
- Applicant: Robert W. Lyle , Michael J. Winer
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Sawyer Law Group, P.C.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
A method for estimating the first access time of a plurality of currently active transactions accessing at least one database object are disclosed. In one aspect, the method may include providing a storage area of a particular size to store data for a plurality of groups corresponding to the at least one database object. Each of the plurality of groups corresponds to a particular time interval. The method includes placing each of the currently active transactions in a group of the plurality of groups based upon a time of a first access of the at least one database object by each of the currently active transactions and the particular time interval. The method also includes storing a group first access time for the group. The group first access time corresponds to the earliest first access time for any of the currently active transactions in the group. The method may also include defining the object's first, or earliest access time, to be the earliest group first access time for currently active groups.
Public/Granted literature
- US20070219998A1 Method and system for estimating a first access time of transactions accessing a database object Public/Granted day:2007-09-20
Information query