System and method for the optimization of database access in data base networks
First Claim
1. A system for optimization of database access from a client device in a database network comprising:
- (a) at least one client;
(b) at least one database server; and
(c) a database network router for managing data flow between said at least one client device and said at least one database server, wherein said database network router includes;
(i) a client access module for communicating configured to communicate with said at least one client device, and(ii) a database resource manager for communicating configured to communicate with said at least one database server;
whereby said database network router may be used to optimize access to said at least one database server by said at least one client.
4 Assignments
0 Petitions
Accused Products
Abstract
A database network router (DNR) in a database network includes a client access module and a database resource manager that communicate with each other using a common software interface. The client access module communicates with clients including application servers and external database servers; and the database resource manager communicates with the database servers. The DNR also includes a protocol manager for handling multiple database protocols. The database network router also includes local data cache storage to store commonly used data objects, results of parsed query statement, non-optimized query statements, and optimized alternatives and assigns a priority to each client on log-in. The DNR provides a method for connections pooling, a method for balancing the load in a database networks and a method for synchronizing the data stored in cache memory with the database network and method for synchronizing the data stored in cache memory with the database to insure data reliability. The DNR also provides a method for monitoring and optimizing data queries to improve the performance of the database network. The DNR also provides a method to migrate from an old to a new version of the database.
-
Citations
24 Claims
-
1. A system for optimization of database access from a client device in a database network comprising:
-
(a) at least one client; (b) at least one database server; and (c) a database network router for managing data flow between said at least one client device and said at least one database server, wherein said database network router includes; (i) a client access module for communicating configured to communicate with said at least one client device, and (ii) a database resource manager for communicating configured to communicate with said at least one database server; whereby said database network router may be used to optimize access to said at least one database server by said at least one client. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method for optimization of database access in a database network comprising the steps of:
-
(a) providing a database network router; and (b) using said database network router for managing data flow between at least one client and at least one database server in the database network, wherein the step of using said database network router includes comprising the steps of; (i) receiving, by a database network router, at least one client communication, (ii) sending, by said database network router, said at least one client communication to said at least one database server, and (iii) in response to said at least one client communication, said database network router receiving at least one database communication and sending said at least one database communication to said at least one client. - View Dependent Claims (8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A method of load balancing in a database network that includes a plurality of database servers, comprising the steps of:
-
(a) providing a database network router (b) detecting, by said database network router, a failed one of the database servers; and (c) using said database network router for transferring to transfer connections of said failed database server to at least one other server, wherein the step of using said database network router includes; (i) monitoring said failed database server for a recovery thereof, and (ii) transferring at least one new connection to said failed database after said recovery.
-
-
22. A system for optimization of database access from a client device in a database network comprising:
-
at least one database server; and a database network router for managing data flow between at least one client device and said at least one database server, wherein said database network router includes; (i) a client access module configured to communicate with at least one client device, (ii) a database resource manager configured to communicate with said at least one database server, and (iii) a local data storage, wherein said database resource manager stores local data and wherein said local data is chosen from the group consisting of commonly used data objects, results of parsed query statements, non-optimized query statements, alternatives for said non-optimized query statements, user defined objects, and performance statistics; whereby said database network router may be used to optimize access to said at least one database server by said at least one client.
-
-
23. A method for managing data flow between at least one client and at least one database server in the database network comprising the steps of:
-
(i) receiving, by a database network router, at least one client communication, (ii) sending, by said database network router, said at least one client communication to said at least one database server, (iii) in response to said at least one client communication, said database network router receiving at least one database communication and sending said at least one database communication to said at least one client, (iv) prior to said receiving, said database network router assigning a priority to each said at least one client communication, and (v) performing (i)-(iii) according to said priority.
-
-
24. A method for managing data flow between at least one client and at least one database server in the database network comprising the steps of:
-
(i) receiving, by a database network router, at least one client communication, (ii) sending, by said database network router, said at least one client communication to said at least one database server, (iii) in response to said at least one client communication, said database network router receiving at least one database communication and sending said at least one database communication to said at least one client, (iv) receiving, by said database network router, a log-out and disconnect request from a first client device that is initially connected to one of said at least one database server by a database connection, and (v) reporting, by said database network router, said log-out to said one database server while leaving said database connection available for a second client.
-
Specification