Access operation request management

• US 10,650,013 B2
• Filed: 12/12/2016
• Issued: 05/12/2020
• Est. Priority Date: 12/12/2016
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ks, Venkatesh Babu, Papaiah, Chetan Babu
• Primary Examiner(s): Ly, Cheyne D
• Application Number:
  US15/375,428
• Publication Number:
  US 20180165469A1
• Time in Patent Office: 1,247 Days
• Field of Search: 707783
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries

Abstract

Disclosed aspects relate to access operation management to a database management system (DBMS) on a shared pool of configurable computing resources having a set of members. A map of the set of table names to the set of members may be established. A query may be received which indicates the access operation request to the DBMS. The query may be parsed to identify a mentioned table name. In the query related to the access operation request to the DBMS, the mentioned table name may be identified. A specific member of the set of members may be selected by comparing the mentioned table name with the map. The specific member of the set of members may be configured to process the access operation request to the DBMS. The routing may be performed in order to process the access operation request to the DBMS.

Claims

1. A computer-implemented method for managing an access operation request to a database management system (DBMS) on a shared pool of configurable computing resources having a set of members, the method comprising:

establishing, with respect to the DBMS on the shared pool of configurable computing resources, a map of a set of table names to the set of members, wherein a respective table name of the set of table names maps to an indicated member of the set of members;

receiving a query which indicates the access operation request to the DBMS;

parsing the query to identify a table name based on analyzing a syntax of the query;

identifying the table name from within the query, based on a set of table identification criteria;

selecting, based on comparing the table name with the map, a specific member of the set of members to process the access operation request to the DBMS;

routing, to process the access operation request to the DBMS, the access operation request to the specific member of the set of members;

storing, in a server configuration file by a server of the shared pool of configurable computing resources, the map of the set of table names to the set of members; and

updating, by the server, the server configuration file in response to activation of the DBMS.

2. The method of claim 1, further comprising:

carrying-out, to process the access operation request to the DBMS, a table-specific operational lock on the specific member of the set of members.

3. The method of claim 1, further comprising:

carrying-out, to process the access operation request to the DBMS, a table-specific operational lock on the specific member of the set of members without carrying-out a global operational lock on all members of the set of members to process the access operation request to the DBMS.

4. The method of claim 1, further comprising:

refreshing, to process the access operation request to the DBMS, a specific memory page for the specific member of the set of members without refreshing memory pages for all members of the set of members to process the access operation request to the DBMS.

5. The method of claim 1, further comprising:

maintaining, to process the access operation request to the DBMS, a non-shared state for the set of members.

6. The method of claim 1, further comprising:

managing, without regard to a query-type of the query, the access operation request to the DBMS on the shared pool of configurable computing resources having the set of members.

7. The method of claim 1, further comprising:

balancing, based on both the table name and the map of the set of table names to the set of members, an operational load for the set of members.

8. The method of claim 1, further comprising:

storing the server configuration file in a set of caches of the set of members, wherein a respective member of the set of members includes a respective cache of the set of caches.

9. The method of claim 1, further comprising:

storing, in a client configuration file by a client of the shared pool of configurable computing resources, the map of the set of table names to the set of members.

10. The method of claim 9, further comprising:

storing the client configuration file in a cache of a machine having the client.

11. The method of claim 9, further comprising:

prioritizing a first set of map entries of the client configuration file with respect to a second set of map entries of a server configuration file, wherein the first set of map entries indicates a client routing preference, and wherein the second set of map entries indicates a server routing preference.

12. The method of claim 1, further comprising:

structuring the map to route a first set of operations of a first application program to a first member of the set of members; and

structuring the map to route a second set of operations of a second application program to a second member of the set of members.

13. The method of claim 1, further comprising:

structuring the map to route a set of read-type operations to a first member of the set of members; and

structuring the map to route a set of write-type operations to a second member of the set of members.

14. The method of claim 1, further comprising:

selecting, in response to a member error event, a next available member.

15. The method of claim 1, wherein the establishing, the receiving, the parsing, the identifying, the selecting, and the routing each occur to manage the access operation request.

16. The method of claim 1, wherein the establishing, the receiving, the parsing, the identifying, the selecting, and the routing each occur in an automated fashion without user intervention.

17. A system for managing an access operation request to a database management system (DBMS) on a shared pool of configurable computing resources having a set of members, the system comprising:

a memory having a set of computer readable computer instructions, and a processor for executing the set of computer readable instructions, the set of computer readable instructions including;

establishing, with respect to the DBMS on the shared pool of configurable computing resources, a map of a set of table names to the set of members, wherein a respective table name of the set of table names maps to an indicated member of the set of members;

receiving a query which indicates the access operation request to the DBMS;

parsing the query to identify a table name based on analyzing a syntax of the query;

identifying the table name from within the query, based on a set of table identification criteria;

selecting, based on comparing the table name with the map, a specific member of the set of members to process the access operation request to the DBMS; and

routing, to process the access operation request to the DBMS, the access operation request to the specific member of the set of members;

storing, in a server configuration file by a server of the shared pool of configurable computing resources, the map of the set of table names to the set of members; and

updating, by the server, the server configuration file in response to activation of the DBMS.

18. A computer program product for access operation request management in a database management system (DBMS) on a shared pool of configurable computing resources having a set of members, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:

establishing, with respect to the DBMS on the shared pool of configurable computing resources, a map of a set of table names to the set of members, wherein a respective table name of the set of table names maps to an indicated member of the set of members;

receiving a query which indicates the access operation request to the DBMS;

parsing the query to identify a table name based on analyzing a syntax of the query;

identifying the table name from within the query, based on a set of table identification criteria;

selecting, based on comparing the table name with the map, a specific member of the set of members to process the access operation request to the DBMS; and

routing, to process the access operation request to the DBMS, the access operation request to the specific member of the set of members;

storing, in a server configuration file by a server of the shared pool of configurable computing resources, the map of the set of table names to the set of members; and

updating, by the server, the server configuration file in response to activation of the DBMS.