Method for identifying a workload type for a given workload of database requests

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 7499908
APP PUB NO 20040225631A1
SERIAL NO

10425171

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

Workload type to be managed by a database management system (DBMS) is a key consideration in tuning the DBMS. Allocations for resources, such as main memory, can be very different depending on whether the workload type is Online Transaction Processing (OLTP) or Decision Support System (DSS). The DBMS also experiences changes in workload type during the normal processing cycle of the DBMS. It would be preferable for the database administrators to recognize the significant shifts of workload type that demand reconfiguring the DBMS to maintain acceptable levels of performance. Disclosed is a workload type classifier module, used by a DBMS, for recognizing workload types so that the DBMS may then manage or adjust its performance and reconfigure its resources accordingly. The classifier may be constructed based on the most significant workload characteristics that differentiate OLTP from DSS. The classifier is then used for identifying changes in workload types contained in a workload.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
INTERNATIONAL BUSINESS MACHINES CORPORATIONNEW ORCHARD ROAD ARMONK NY 10504

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Elnaffar, Said Kingston, CA 1 53
Horman, Randall W Toronto, CA 7 175
Lightstone, Sam S Toronto, CA 41 672
Martin, Pat Kingston, CA 1 53
Schiefer, Bernhard K Pickering, CA 3 70
Van, Boeschoten Robin D Kitchener, CA 4 118

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation