Access operation request management
First Claim
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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
18 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
-
-
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.
-
Specification