US6282570B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Monitoring a large parallel database through dynamic grouping and sequential sampling
Assignee: International Business Machines Corp
•
Filing: 1998-12-07
•
Granted: 2001-08-28
•
Expires: 2018-12-07
Abstract
Abstract The present invention discloses a method, apparatus, and article of manufacture for monitoring performance of a parallel database in a computer. In accordance with the present invention, the parallel database is stored on a data storage device in the computer. Groups of database nodes are identified. Collection time periods for collecting performance statistics from the identified group of database nodes are determined. Performance statistics are periodically collected from a subset of each identified group of nodes during the collection time periods. The collected performance statistics are stored in a memory connected to the computer and re-used when collecting performance statistics from one or more groups of database nodes in a succeeding collection time period.
Inventors
- 👤 Tony Kai-Chi Leung
- 👤 Siu Nang See
- 👤 Stan Wong
- 👤 Cheung-Yuk Wu
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 05:17
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/30; G06F11/34; G06F11/3409; G06F11/3466; G06F11/3495; G06F11/3452; G06F2201/00; G06F2201/80; G06F2201/835; G06F2201/885; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 30
Claim 1
Independent Claim
107 words
A method of monitoring performance of a parallel database in a computer, the parallel database being stored on a data storage device in the computer, the method comprising the steps of: identifying one or more groups of database nodes; determining collection time periods for collecting performance statistics from the identified groups of database nodes; and periodically collecting performance statistics from a subset of each identified group of nodes during the collection time periods, wherein the collected performance statistics are stored in a cache memory of the computer and re-used when collecting performance statistics from one or more groups of database nodes in a succeeding collection time period.
Claim 2
Independent Claim
107 words
A method of monitoring performance of a parallel database in a computer, the parallel database being stored on a data storage device in the computer, the method comprising the steps of: identifying one or more groups of database nodes; determining collection time periods for collecting performance statistics from the identified groups of database nodes; and periodically collecting performance statistics from a subset of each identified group of nodes during the collection time periods, wherein the collected performance statistics are stored in a cache memory of the computer and re-used when collecting performance statistics from one or more groups of database nodes in a succeeding collection time period.
Claim 3
Dependent Claim
22 words
The method of claim 1 , further comprising a step of dynamically grouping one or more user selected nodes into a group.
Claim 4
Dependent Claim
21 words
The method of claim 1 , further comprising a step of using the stored statistics to calculate a database performance value.
Claim 5
Dependent Claim
30 words
The method of claim 1 , further comprising collecting additional performance statistics from an identified group of nodes so that statistics from all the nodes in each group are collected.
Claim 6
Dependent Claim
30 words
The method of claim 1 , wherein the step of collecting database performance statistics further comprises the step of collecting database performance statistics from each group of nodes in parallel.
Claim 7
Dependent Claim
29 words
The method of claim 1 , wherein the step of collecting database performance statistics further comprises the step of collecting database performance statistics from each group of nodes sequentially.
Claim 8
Dependent Claim
65 words
The method of claim 1 , wherein the step of collecting database performance statistics further comprises the steps of: defining a sample interval, wherein the sample interval defines how often database performance statistics are collected from each group; and at each defined sample interval, collecting database performance statistics from a portion of the nodes in each group of nodes as the collection time period allows.
Claim 9
Dependent Claim
91 words
The method of claim 1 , wherein the stored database performance statistics are expired data, and wherein the step of collecting further comprises the steps of: identifying nodes without stored performance statistics; and during the collection time period, performing the following steps: collecting database performance statistics from a portion of the identified nodes as the collection time period allows, wherein the collected performance statistics are stored in the cache memory; and refreshing the expired data as the collection time period allows, wherein refreshed data is stored in a new memory location.
Claim 10
Dependent Claim
92 words
The method of claim 1 , wherein each group of database nodes has a group number, the method further comprising the steps of: for each node in each numbered group of nodes, tracking a user's request for monitoring, wherein tracking comprises the steps of: for each node in each numbered group of nodes, storing a node number in a node list; and for each entry in the node list, storing one or more bits in a snapshot buffer list that references performance statistics for each of the nodes of the identified group.
Claim 11
Independent Claim
130 words
An apparatus for monitoring performance of a parallel database in a computer, the parallel database being stored on a data storage device in the computer, comprising: a computer having a data storage device connected thereto, wherein the data storage device stores a database; and one or more computer programs, performed by the computer, for identifying one or more groups of database nodes, determining collection time periods for collecting performance statistics from the identified groups of database nodes, and periodically collecting performance statistics from a subset of each identified group of nodes during the collection time periods, wherein the collected performance statistics are stored in a cache memory of the computer and re-used when collecting performance statistics from one or more groups of database nodes in a succeeding collection time period.
Claim 12
Independent Claim
130 words
An apparatus for monitoring performance of a parallel database in a computer, the parallel database being stored on a data storage device in the computer, comprising: a computer having a data storage device connected thereto, wherein the data storage device stores a database; and one or more computer programs, performed by the computer, for identifying one or more groups of database nodes, determining collection time periods for collecting performance statistics from the identified groups of database nodes, and periodically collecting performance statistics from a subset of each identified group of nodes during the collection time periods, wherein the collected performance statistics are stored in a cache memory of the computer and re-used when collecting performance statistics from one or more groups of database nodes in a succeeding collection time period.
Claim 13
Dependent Claim
26 words
The apparatus of claim 10 , further comprising a means, performed by the computer, of dynamically grouping one or more user selected nodes into a group.
Claim 14
Dependent Claim
25 words
The apparatus of claim 10 , further comprising a means, performed by the computer, of using the stored statistics to calculate a database performance value.
Claim 15
Dependent Claim
37 words
The apparatus of claim 10 , further comprising a means, performed by the computer, for collecting additional performance statistics from an identified group of nodes so that statistics from all the nodes in each group are collected.
Claim 16
Independent Claim
34 words
The apparatus of claims 10 , wherein the means performed by the computer for collecting database performance statistics further comprises the means for collecting database performance statistics from each group of nodes in parallel.
Claim 17
Dependent Claim
33 words
The apparatus of claim 10 , wherein the means performed by the computer for collecting database performance statistics further comprises the means for collecting database performance statistics from each group of nodes sequentially.
Claim 18
Dependent Claim
70 words
The apparatus of claim 10 , wherein the means performed by the computer for collecting database performance statistics further comprises: means for defining a sample interval, wherein the sample interval defines how often database performance statistics are collected from each sub-group; and at each defined sample interval, means for collecting database performance statistics from a portion of the nodes in each group of nodes as the collection time period allows.
Claim 19
Dependent Claim
104 words
The apparatus of claim 10 , wherein the stored database performance statistics are expired data, the apparatus further comprising: means performed by the computer for identifying nodes without stored database performance statistics; and means performed by the computer during the collection time period: means performed by the computer for collecting database performance statistics from a portion of the identified nodes as the collection time period allows, wherein the collected performance statistics are stored in the cache memory; and means performed by the computer for refreshing the expired data as the collection time period allows, wherein refreshed data is stored in a new memory location.
Claim 20
Dependent Claim
107 words
The apparatus of claim 10 , wherein each group of database nodes has a group number, the apparatus further comprising: for each node in each numbered group of nodes, means performed by the computer for tracking a user's request for monitoring, wherein tracking comprises the steps of: for each node in each numbered group of nodes, means performed by the computer for storing a node number in a node list; and for each entry in the node list, means performed by the computer for storing one or more bits in a snapshot buffer list that references performance statistics for each of the nodes of the identified group.
Claim 21
Dependent Claim
131 words
An article of manufacture comprising a computer program carrier readable by a computer embodying one or more instructions executable by the computer to perform method steps for monitoring performance of a parallel database in a computer, the parallel database being stored on a data storage device in the computer, the method comprising the steps of: identifying one or more groups of database nodes; determining collection time periods for collecting performance statistics from the identified groups of database nodes; and periodically collecting performance statistics from a subset of each identified group of nodes during the collection time periods, wherein the collected performance statistics are stored in a cache memory of the computer and re-used when collecting performance statistics from one or more groups of database nodes in a succeeding collection time period.
Claim 22
Dependent Claim
131 words
An article of manufacture comprising a computer program carrier readable by a computer embodying one or more instructions executable by the computer to perform method steps for monitoring performance of a parallel database in a computer, the parallel database being stored on a data storage device in the computer, the method comprising the steps of: identifying one or more groups of database nodes; determining collection time periods for collecting performance statistics from the identified groups of database nodes; and periodically collecting performance statistics from a subset of each identified group of nodes during the collection time periods, wherein the collected performance statistics are stored in a cache memory of the computer and re-used when collecting performance statistics from one or more groups of database nodes in a succeeding collection time period.
Claim 23
Dependent Claim
24 words
The article of manufacture of claim 19 , further comprising a step of dynamically grouping one or more user selected nodes into a group.
Claim 24
Dependent Claim
23 words
The article of manufacture of claim 19 , further comprising a step of using the stored statistics to calculate a database performance value.
Claim 25
Dependent Claim
32 words
The article of manufacture of claim 19 , further comprising collecting additional performance statistics from an identified group of nodes so that statistics from all the nodes in each group are collected.
Claim 26
Dependent Claim
32 words
The article of manufacture of claim 19 , wherein the step of collecting database performance statistics further comprises the step of collecting database performance statistics from each group of nodes in parallel.
Claim 27
Dependent Claim
31 words
The article of manufacture of claim 19 , wherein the step of collecting database performance statistics further comprises the step of collecting database performance statistics from each group of nodes sequentially.
Claim 28
Dependent Claim
67 words
The article of manufacture of claim 19 , wherein the step of collecting database performance statistics further comprises the steps of: defining a sample interval, wherein the sample interval defines how often database performance statistics are collected from each group; and at each defined sample interval, collecting database performance statistics from a portion of the nodes in each group of nodes as the collection time period allows.
Claim 29
Dependent Claim
93 words
The article of manufacture of claim 19 , wherein the stored database performance statistics are expired data, and wherein the step of collecting further comprises the steps of: identifying nodes without stored performance statistics; and during the collection time period, performing the following steps: collecting database performance statistics from a portion of the identified nodes as the collection time period allows, wherein the collected performance statistics are stored in the cache memory; and refreshing the expired data as the collection time period allows, wherein refreshed data is stored in a new memory location.
Claim 30
Dependent Claim
94 words
The article of manufacture of claim 19 , wherein each group of database nodes has a group number, the method further comprising the steps of: for each node in each numbered group of nodes, tracking a user's request for monitoring, wherein tracking comprises the steps of: for each node of each numbered group of nodes, storing a node number in a node list; and for each entry in the node list, storing one or more bits in a snapshot buffer list that references performance statistics for each of the nodes of the identified group.
References Cited (Backward Citations)
US4463424A
Cited
US5935216A
Cited
US5524253A
Cited
US5325530A
Cited
US5649198A
Cited
EP0646883A1
Cited
US5579515A
Cited
US5497486A
Cited
US5870608A
Cited
WO1996026488A1
Cited
JPH09179834A
Cited
US5938729A
Cited
US5958009A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2004-08-27 | 2005-02-26 | 2005-08-28 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-08-27 | 2009-02-26 | 2009-08-28 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-08-27 | 2013-02-26 | 2013-08-28 | $7700.00 | Window Closed / Lapsed |