公开(公告)号：CA2426640A1

公开(公告)日：2004-10-28

申请号：CA2426640

申请日：2003-04-28

Applicant: IBM CANADA

Inventor： HELLERSTEIN JOSEPH L ,  ROSE KEVIN R ,  LIGHTSTONE SAM S ,  PAREKH SUJAY S ,  HURAS MATTHEW A

IPC: G06F9/44 ,  G06F11/30 ,  G06F11/34

Abstract: An adaptive throttling system for minimizing the impact of non-producti on work on production work in a computer system. The adaptive throttling system throttles production work and non-production work to optimize production. Th e adaptive throttling system allows system administrators to specify a quantified limit on the performance impact of non-production or utility work on production work. The throttling rate of the utility is then automatically determined by a supervisory agent, so that the utilities' impact is kept within the specifie d limit. The adaptive throttling system adapts dynamically to changes in workloads so as to ensure that valuable system resources are well utilized and utility work is not delayed unnecessarily.

公开(公告)号：CA2426439A1

公开(公告)日：2004-10-23

申请号：CA2426439

申请日：2003-04-23

Applicant: IBM CANADA

Inventor： VAN BOESCHOTEN ROBIN D ,  SCHIEFER BERNHARD K ,  MARTIN PAT ,  ELNAFFAR SAID ,  HORMAN RANDALL W ,  LIGHTSTONE SAM S

IPC: G06F16/90 ,  G06F9/50 ,  G06F17/30 ,  G06F17/60

Abstract: 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. Database administrators must therefore recognize the significant shift s of workload type that demand reconfiguring the DBMS in order 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 reconfiguring its resources accordingly. The classifier may be constructed based on the most significant workload characteristics th at differentiate OLTP from DSS; then, the classifier is used for identifying changes in workload types contained in a workload. One aspect, there is provided, for an information retrieval system, a method of identifying a workload type for a given workload, including selecting a sample of the given workload, and predicting identification of the workload type based on a comparison between the selected sample and a set of rules.

公开(公告)号：CA2279119C

公开(公告)日：2004-10-19

申请号：CA2279119

申请日：1999-07-29

Applicant: IBM CANADA

Inventor： MCARTHUR CATHERINE S ,  FLASZA MIROSLAW A ,  LIGHTSTONE SAM S ,  O'CONNELL WILLIAM T

IPC: G06F17/30

Abstract: A computer system for the indexing of data in which a heuristic determinatio n function is applied to predict an efficient index updating approach. The system is able to updat e an index relating to a first data set by incrementally updating the index or by a rebuild of the index at the completion of the addition of a second set of data to the first set of data. The system applies a heuristic determination function to the characteristics of the first set of data, its index, and the second set of data, to predict whether an incremental update or a rebuild update of the index will result in a more efficient rebuild of the data. The system applies this approach to a restore and rollforward recovery or a data load operation to improve the efficiency of these operations.

公开(公告)号：CA2365692A1

公开(公告)日：2002-12-21

申请号：CA2365692

申请日：2001-12-19

Applicant: IBM

Inventor： ZILIO DANIEL C ,  CHEUNG KIT MAN ,  LIGHTSTONE SAM S ,  ZUZARTE CALISTO P ,  BEYER KEVIN S ,  VALENTIN GARY ,  ZAHARIOUDAKIS MARKOS ,  LEUNG TING Y ,  LOHMAN GUY M ,  SIMMEN DAVID E ,  PIRAHESH MIR HAMID ,  COCHRANE ROBERTA J

IPC: G06F17/30 ,  G06F17/60

Abstract: The invention herein provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of a database in a data processing system to be created for one or more users of the database. The method and apparatus provide method and means for evaluating a workload presented by a user to th e database; evaluating the data processing system characteristics; evaluating the databa se characteristics; and, using the above evaluations for recommending a set of suitable materialized views or indices to the user. Another aspect of the invention, which may be used for a workload presented by a user of a database in a data processing system, provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of the database, by: generating a plurality of materialized view candidates from evaluation of the workload, data processing system characteristics and database characteristics; estimating statistics for the materialized view candidates such as the numbe r of rows, row size, and column statistics; generating a plurality of potential index candidates by evaluating the workload, data processing system characteristics, database characteristics a nd the materialized view candidates; and, from the materialized view candidates and index candidates selecting a set of suitable materialized views and/or indices for submission to the user.