System and method for the optimization of database access in data base networks

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.

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.

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.

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.

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.