Method and system for wireless database management

• US 8,065,284 B2
• Filed: 02/11/2009
• Issued: 11/22/2011
• Est. Priority Date: 11/09/2000
• Status: Expired due to Term

• Current Assignee: Byteweavr, LLC (Ascend Innovation Management, LLC)
• Original Assignee: Stavros Investments LLC (Intellectual Ventures LLC)
• Inventors: Kaplan, Ari David
• Primary Examiner(s): THAI, HANH B
• Application Number:
  US12/369,461
• Publication Number:
  US 20090150410A1
• Time in Patent Office: 1,014 Days
• Field of Search: 707705-706, 709223-224, 709/217, 709226-227, 709/235
• US Class Current: 707/705
• CPC Class Codes: G06F 16/9577 Optimising the visualization of content, e.g. distillation of HTML documents
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: H04L 63/0428 wherein the data content is protected, e.g. by encrypting or encapsulating the payload
• CPC Class Codes: H04L 63/166 at the transport layer
• CPC Class Codes: H04L 67/04 specially adapted for terminals or networks with limited capabilities; specially adapted for terminal portability
• CPC Class Codes: H04L 67/14 Session management for real-time applications in data packet communications networks H04L65/1066
• CPC Class Codes: H04L 67/2895 Intermediate processing functionally located close to the data provider application, e.g. reverse proxies
• CPC Class Codes: H04L 67/55 Push-based network services
• CPC Class Codes: H04L 67/5682 Policies or rules for updating, deleting or replacing the stored data
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04W 24/00 Supervisory, monitoring or testing arrangements
• CPC Class Codes: H04W 76/11 Allocation or use of connection identifiers
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

An efficient method and system for wireless database management that allows database administrators to monitor and manage a plurality of databases from a remote location is disclosed. Included in this description are steps for reducing the amount of data transmitted and received by narrow bandwidth wireless communications, storing the results of requests made by the same user repeatedly for quicker access time, and enabling a single user to access multiple databases within the wireless database management system simultaneously.

Claims

1. A system comprising:

an application server; and

a memory associated with said application server, wherein;

said application server is configured to be coupled to a first database management server which hosts, is coupled to, connects to, or is configured to support a database management system (DBMS); and

said application server is configured to receive a request from a wireless device to the first database management server, wherein;

the request from the wireless device comprises at least one of a request to the first database management server for monitoring a database of the DBMS or a request to the first database management server for managing the database of the DBMS;

the application server is configured that when the request from the wireless device is made to the DBMS from the wireless device, the application server assigns a communication session identifier that uniquely identifies and distinguishes a respective communication session between the wireless device and the first database management server from any other communication session between the same wireless device and at least one of the first database management server or a second database management server;

the application server is configured to determine whether a result for the request from the wireless device has been stored; and

the application server is configured such that upon a determination that the result for the request from the wireless device has not been stored, the application server;

requests the result from the first database management server;

associates the communication session identifier with the result of the request; and

stores in the memory associated with the application server the communication session identifier with the associated result of the request;

wherein;

the application server is configured for wireless monitoring and management of the DBMS; and

the application server is configured to store the result of the request from the wireless device for access when an interrupted or terminated database session is reestablished, wherein said access to said stored result is faster than an access time associated with retrieving the result from the DBMS.

2. The system of claim 1, wherein the application server is further configured to request from the first database management server an updated result of the request from the wireless device.

3. The system of claim 2, wherein the application server is further configured to adjust how often the stored result of the request from the wireless device is updated.

4. The system of claim 1, further comprising:

the first database management server; and

the second database management server, said second database management server coupled to the application server, wherein;

the application server is further configured to distinguish a communication session between the wireless device and the first database management server from another communication session between the wireless device and the second database management server.

5. The system of claim 1, wherein:

the application server is configured to receive from the wireless device a request to reconnect the wireless device to the first database management server;

the application server is configured to reestablish a connection between the wireless device and the first database management server upon receiving the request to reconnect; and

the application server is further configured to reestablish a previous communication session between the wireless device and the first database management server based on a communication session identifier that uniquely identifies the previous communication session.

6. The system of claim 5, wherein the application server is further configured to retrieve a stored session information of the previous communication session, wherein the stored session information comprises at least one of the request from the wireless device and the stored result of the request from the wireless device.

7. A system comprising:

a database management server which hosts, is coupled to, connects to, or is configured to support a database management system (DBMS); and

an application server coupled to said database management server, said application server configured to;

identify a plurality of distinct communication sessions between a wireless device and the database management server;

assign respective session identification information to each respective distinct communication session between the wireless device and the database management server;

receive in at least one of said communication sessions a request to the DBMS from the wireless device, wherein the request to the DBMS comprises at least one of a request for monitoring a database of the DBMS or a request for managing the database of the DBMS;

append the respective session identification information to the request to the DBMS; and

store the request to the DBMS with the appended session identification information;

wherein;

the system is configured for wireless monitoring and management of the DBMS; and

the system is configured to store the request to the DBMS for access when an interrupted or terminated database session is reestablished, wherein said access is faster than an access time associated with retransmitting the request to the DBMS.

8. The system of claim 7, wherein said application server is further configured to associate the session identification information with a stored result of the request to the DBMS.

9. A system comprising:

a database management server which hosts, is coupled to, connects to, or is configured to support a database management system (DBMS);

an application server coupled to said database management server and configured to receive from a wireless device an instruction request instructing the application server to perform certain tasks to interact with the DBMS, wherein the instruction request comprises at least one of a request for monitoring a database of the DBMS or a request for managing the database of the DBMS, wherein;

the system is configured for wireless monitoring and management of the DBMS; and

in response to the interaction with the application server, the DBMS monitors or manages the database;

assign a code to the instruction request, said code representing the instruction request; and

store said code in the application server;

wherein a data size of the code is less than a data size of the instruction request, to enable the wireless device to instruct the application server to perform said certain tasks by sending the code as a request to the application server instead of sending the instruction request to the application server.

10. The system of claim 9, wherein said application server is further configured to:

assign session identification information to each connection established between the wireless device and the database management server;

associate the session identification information with a stored result of a first request made to the DBMS from the wireless device, said result being stored in the application server; and

associate the session identification information with the code assigned to the stored result.

11. A system comprising:

first processing means configured to monitor and manage a database of a DBMS; and

second processing means coupled to said first processing means, said second processing means configured to receive a request to the DBMS from a wireless device;

wherein;

the request to the DBMS comprises at least one of a request to the DBMS for monitoring the database of the DBMS or a request for managing the database of the DBMS;

the second processing means is configured that when the request to the DBMS is made from the wireless device, the second processing means assigns a communication session identifier that uniquely identifies and distinguishes a respective communication session between the wireless device and the first processing means from any other communication session between the wireless device and at least one of the first processing means or a third processing means configured to monitor and manage a database of the DBMS;

the second processing means is configured to determine whether a result for the request to the DBMS has been stored; and

the second processing means is configured that upon a determination that the result for the request to the DBMS has not been stored, the second processing means;

requests the result from the first processing means,

associates the result with the communication session identifier; and

stores the result and associated communication session identifier in the second processing means;

wherein;

the system is configured for wireless monitoring and management of the DBMS; and

the system is configured to store the result for the request to the DBMS for access when an interrupted or terminated database session is reestablished, wherein said access to said stored result is faster than an access time associated with requesting said result from said first processing means.

12. The system of claim 11, wherein said second processing means is further configured to:

assign a code to the request to the DBMS;

store said code in a memory associated with the second processing means;

wherein a data size of the code is less than a data size of the request to the DBMS to enable the wireless device to instruct the first processing means to perform a task associated with said request to the DBMS by sending the code as the request to the second processing means instead of sending the request to the DBMS to the second processing means.

13. A tangible computer-readable medium having stored thereon, computer-executable instructions that, if executed by a computing device, cause the computing device to perform a method comprising:

receiving at an application server coupled to a first database management server a request from a wireless device, wherein the request from the wireless device comprises at least one of a request to the first database management server for monitoring a database of a database management system (DBMS) or a request to the database management server for managing the database of the DBMS;

sending from the application server to the first database management server the request from the wireless device;

causing the application server to assign to the received request from the wireless device a communication session identifier that uniquely identifies and distinguishes a respective communication session between the wireless device and the first database management server from any other communication session between the same wireless device and at least one of the first database management server or a second database management server;

determining at the application server whether a result for the request from the wireless device has been stored;

in response to a determination that the result has not been stored, requesting by the application server the result from the first database management server;

associating at the application server the result with the communication session identifier; and

storing at the application server the result and the associated communication session identifier.

14. The tangible computer-readable medium of claim 13, wherein the method further comprises:

requesting an updated result of the request from the wireless device from the first database management server by the application server.

15. The tangible computer-readable medium of claim 14, wherein the method further comprises:

causing the application server to adjust how often the stored result of the request from the wireless device is updated.

16. The tangible computer-readable medium of claim 13, wherein the method further comprises:

distinguishing at the application server a first communication session between the wireless device and the first database management server from a second communication session between the wireless devices and the second database management server.

17. The tangible computer-readable medium of claim 13, wherein the method further comprises:

receiving at the application server from the wireless device a request to reconnect the wireless device to the first database management server;

reestablishing via the application server a connection between the wireless device and the first database management server; and

reestablishing via the application server a previous communication session between the wireless device and the first database management server based on a communication session identifier that uniquely identifies the previous communication session.

18. A tangible computer-readable medium having stored thereon, computer-executable instructions that, if executed by a computing device, cause the computing device to perform a method comprising:

identifying at an application server coupled to a database management server a plurality of distinct communication sessions between a wireless device and the database management server;

assigning via the application server unique session identification information to each respective distinct communication session between the wireless device and the database management server;

receiving from the wireless device in at least one of said communication sessions a request to a database management system (DBMS) of the database management server, wherein the request to the DBMS comprises at least one of a request for monitoring a database of the DBMS or a request for managing the database of the DBMS;

appending via the application server the respective session identification information to the request to the DBMS; and

storing in a memory associated with the application server the request to the DBMS with the appended session identification information.

19. The tangible computer-readable medium of claim 18, wherein the method further comprises:

associating at the application server the session identification information with a stored result of the request to the DBMS, said stored result with the associated session identification information being stored in the memory associated with the application server.

20. A tangible computer-readable medium having stored thereon, computer-executable instructions that, if executed by a computing device, cause the computing device to perform a method comprising:

receiving at an application server from a wireless device an instructing request instructing the application server to perform certain tasks to interact with a database management system (DBMS) of a database management server coupled to the application server, wherein;

the instructing request comprises at least one of a request for monitoring a database of the DBMS or a request for managing the database of the DBMS, wherein in response to the interaction with the application server the DBMS monitors or manages the database;

assigning at the application server a code to the instructing request, said code representing the instructing request; and

storing said code in the application server;

wherein a data size of the code is less than a data size of the instructing request, to enable the wireless device to instruct the application server to perform said certain tasks by sending the code as a request to the application server instead of sending the instructing request to the application server.

21. The tangible computer-readable medium of claim 20, wherein the method further comprises:

assigning at the application server session identification information to each connection established between the wireless device and the database management server;

associating at the application server the session identification information with a stored result of a stored instructing request made to the DBMS from the wireless device, said result being stored in a memory associated with the application server; and

associating at the application server the session identification information with the code assigned to the stored instructing request.

22. A system comprising:

an application server; and

a memory associated with said application server,

wherein said application server is configured to;

couple to a database management server which hosts, is coupled to, connects to, or is configured to support a database management system (DBMS);

receive from a wireless device an instruction request instructing the application server to perform certain tasks to interact with the DBMS, wherein the instruction request comprises at least one of a request for monitoring a database of the DBMS or a request for managing the database of the DBMS, wherein;

the application server is configured for wireless monitoring and management of the DBMS; and

in response to the interaction with the application server the DBMS monitors or manages the database;

assign a code to the instruction request, said code representing the instruction request; and

store said code in the memory associated with the application server;

wherein a data size of the code is less than a data size of the instruction request, to enable the wireless device to instruct the application server to perform said certain tasks by sending the code as a request to the application server instead of sending the instruction request to the application server.

23. A system comprising:

first processing means; and

data storage means associated with said first processing means, wherein;

said first processing means is configured to be coupled to a second processing means which hosts, is coupled to, connects to, or is configured to support a database management system (DBMS); and

said first processing means is configured to receive a request from a wireless device to the second processing means, wherein;

the request from the wireless device comprises at least one of a request to the second processing means for monitoring a database of the DBMS or a request to the second processing means for managing the database of the DBMS;

the first processing means is configured that when the request from the wireless device is received, the first processing means assigns a communication session identifier that uniquely identifies and distinguishes a respective communication session between the wireless device and the second processing means from any other communication session between the same wireless device and at least one of the second processing means or a third processing means;

the first processing means is configured to determine whether a result for the request from the wireless device has been stored in the data storage means associated with the first processing means; and

the first processing means is configured such that upon a determination that the result for the request from the wireless device has not been stored, the first processing means;

requests the result from the second processing means;

associates the communication session identifier with at least one of the request from the wireless device and the result of the request; and

stores in the data storage means associated with the first processing means the communication session identifier with the associated at least one of the request from the wireless device and the result of the request;

wherein;

the first processing means is configured for wireless monitoring and management of the DBMS; and

the first processing means is configured to store at least one of the request from the wireless device and the result of the request from the wireless device for access when an interrupted or terminated database session is reestablished, wherein said access to said stored at least one of the request from the wireless device and the result of the request from the wireless device is faster than an access time associated with requesting the result from the second processing means.

24. A system comprising:

a first processing means; and

a memory associated with said first processing means;

wherein said first processing means is configured to;

couple to a second processing means which hosts, is coupled to, connects to, or is configured to support a database management system (DBMS);

receive from a wireless device an instruction request instructing the first processing means to perform certain tasks to interact with the DBMS, wherein the instruction request comprises at least one of a request for monitoring a database of the DBMS or a request for managing the database of the DBMS, wherein the first processing means is configured for wireless monitoring and management of the DBMS;

assign a code to the instruction request, said code representing the instruction request; and

store said code in the memory associated with the first processing means;

wherein a data size of the code is less than a data size of the instruction request, to enable the wireless device to instruct the first processing means to perform said certain tasks by sending the code as a request to the first processing means instead of sending the instruction request to the first processing means.

25. A system comprising:

a first processing means; and

a memory associated with said first processing means;

wherein said first processing means is configured to;

receive a first request to a DBMS, wherein the first request to the DBMS comprises at least one of a second request for monitoring a database of the DBMS or a third request for managing the database of the DBMS, wherein the first request is made to the DBMS from a wireless device and is assigned a communication session identification that identifies and distinguishes a respective communication session between the wireless device and a computer system which hosts the DBMS or connects to the DBMS from any other communication session between the same wireless device and the computer system;

check whether a result for the first request has been stored; and

if the result for the first request has not been stored, produce the result and store the result on a server.

26. A method for wireless monitoring and management of a database management system (DBMS) comprising:

establishing a communication session between a wireless device and a computer system which hosts, is coupled to, connects to, or is configured to support the DBMS;

receiving a first request to the DBMS, wherein;

the first request to the DBMS comprises at least one of a second request for monitoring a database of the DBMS or a third request for managing the database of the DBMS; and

the first request is made to the DBMS from the wireless device and is assigned a communication session identification that identifies a respective communication session between the wireless device and the computer system from any other communication session between the same wireless device and the computer system;

checking whether a result for the first request has been stored; and

if the result for the first request has not been stored, producing the result and storing the result on a server;

wherein;

the result of the first request to the DBMS is stored for access when an interrupted or terminated database session is reestablished; and

said access to said stored result is faster than an access time associated with obtaining said result of said first request from said DBMS.