# US 2008/0189288 A1 · Query governor with network monitoring in a parallel computer system > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2008/0189288 A1 - Document ID: US20080189288A1 - Status: Published application - Kind: A1 - Application number: 11/671,546 - Filed: 2007-02-06 - Published: 2008-08-07 - Earliest claimed: 2007-02-06 - Assignees: International Business Machines Corporation - Inventors: Eric Lawrence Barsness; David L. Darrington; Amanda Peters; John Matthew Santosuosso - Web page: https://patentgrep.com/patent/US20080189288A1 ## CPC - H04L 43/0852: Delays - G06F 16/2455: Query execution - H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M) - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract An apparatus and method for a query governor to govern query execution in a parallel computer system with one or more networks. The query governor uses a network monitor to gather network status information to determine how to govern query execution. The query governor may also use historical information of previous query execution stored in a query file to determine if the query should be allowed to execute. The query governor may also use node and network restrictions to determine what networks the query can use. ## Claims ### Claim 1 A computer apparatus comprising: a plurality of nodes each having a memory and at least one processor; a database residing in the memory; at least one network connecting the plurality of nodes; a network monitor that monitors the at least one network and stores network data in a network file; and a query governor that governs whether a query can access the database over the at least one network based on the network data in the network file. ### Claim 2 (depends on 1) The computer apparatus of claim 1 wherein the network file includes information selected from the following: byte count, latency, retransmits, packets dropped, and resets. ### Claim 3 (depends on 1) The computer apparatus of claim 1 further comprising a query file with historical information regarding query execution and wherein the query governor uses the query file to determine whether to allow the query to execute. ### Claim 4 (depends on 3) The computer apparatus of claim 3 wherein the query file includes information selected from the following: network used, elapsed time, node list, and priority. ### Claim 5 (depends on 1) The computer apparatus of claim 1 further comprising a service node connected to the plurality of nodes that controls the plurality of nodes and wherein the network monitor resides in and executes from a memory of the service node. ### Claim 6 (depends on 1) The computer apparatus of claim 1 further comprising node/network restrictions that are setup by a system administrator and used by the query governor to restrict access to a network by the query. ### Claim 7 (depends on 6) The computer apparatus of claim 6 wherein the node/network restrictions are selected from the following: node ID, network ID, byte count, priority and latency. ### Claim 8 (depends on 1) The computer apparatus of claim 1 wherein the query governor uses a traditional query governor metric in combination with the network data from the network file to govern whether the query can access the database. ### Claim 9 A computer implemented method for governing access to data on a partitioned database comprising the steps of: receiving a query to the database; monitoring at least one network connected to a plurality of nodes each having a memory and at least one processor to gather network data; storing network data in a network file; and governing the query's execution to access the database over the at least one network based on network data in the network file. ### Claim 10 (depends on 9) The computer implemented method of claim 9 wherein the step of governing the query's execution further includes selecting a network from a plurality of networks that is not restricted and is not overloaded and executing the query over the selected network. ### Claim 11 (depends on 9) The computer implemented method of claim 9 wherein the network data includes information selected from the following: byte count, latency, retransmits, packets dropped, and resets. ### Claim 12 (depends on 9) The computer implemented method of claim 9 further comprising the step of setting up node/network restrictions by a system administrator using the node/network restrictions to restrict access to a network by the query. ### Claim 13 (depends on 12) The computer implemented method of claim 12 wherein the node network restrictions include restricted applications and a priority. ### Claim 14 (depends on 9) The computer implemented method of claim 9 further comprising the step of maintaining a query file with historical information regarding query execution and wherein the query governor uses the query file to determine whether to allow the query to execute. ### Claim 15 A computer-readable program product for executing on a parallel computer system with a plurality of compute nodes comprising: a network monitor that monitors at least one network connecting the plurality of compute nodes and stores network data in a network file; a query governor that governs whether a query can access the database over the at least one network based on the data in the network file; and computer-readable medium in which computer instructions are stored, which instructions, when read by a computer, cause the computer to perform the steps of the query governor. ### Claim 16 (depends on 15) The program product of claim 15 wherein the network data in the network file includes information selected from the following: byte count, latency, retransmits, packets dropped, and resets. ### Claim 17 (depends on 15) The program product of claim 15 further comprising a query file with historical information regarding query execution and wherein the query governor uses the query file to determine whether to allow the query to execute. ### Claim 18 (depends on 17) The program product of claim 17 wherein the query file includes information selected from the following: network used, elapsed time, node list, and priority. ### Claim 19 (depends on 15) The program product of claim 15 wherein the computer system includes a service node connected to the plurality of nodes that controls the plurality of nodes and wherein the network monitor resides in and executes from a memory of the service node. ### Claim 20 (depends on 19) The program product of claim 19 further comprising node/network restrictions that are setup by a system administrator and used by the query governor to restrict access to a network by the query. ### Claim 21 (depends on 20) The program product of claim 20 wherein the node/network restrictions are selected from the following: node ID, network ID, byte count, priority and latency. ### Claim 22 (depends on 15) The program product of claim 15 wherein the query governor uses a traditional query governor metric in combination with the network data from the network file to govern whether the query can access the database.