Method and system for wireless database management

• US 7,496,554 B2
• Filed: 11/08/2001
• Issued: 02/24/2009
• 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 D.
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): Thai; Hanh B
• Application Number:
  US10/007,912
• Publication Number:
  US 20020083044A1
• Time in Patent Office: 2,665 Days
• Field of Search: 707/1, 707/3, 707 9- 10, 707/109, 705/14, 709/217, 709226-227, 709/235
• US Class Current: 1/1
• 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 method for wireless monitoring and management of a database management system (DBMS) wherein a result of a first request to the DBMS is stored for faster access when an interrupted or terminated database session is reestablished, comprising:

receiving the 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

wherein the first request is made to the DBMS from the 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;

checking whether the 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.

2. The method of claim 1 further comprising:

updating the stored result of a stored first request.

3. The method of claim 2 further comprising:

adjusting how often the stored result of the stored first request is updated.

4. The method of claim 3, further comprising:

adjusting how often the stored result of the stored first request is updated based on a type of the stored first request.

5. The method of claim 1, wherein:

each communication session identification further distinguishes a respective communication session between the wireless device and the computer system from another communication session between another wireless device and another computer system.

6. The method of claim 5, wherein:

each communication session identification further distinguishes a respective communication session between the wireless device and the computer system from any other communication session between any other of a plurality of wireless devices and any other computer system.

7. The method of claim 1, further comprising:

receiving from the wireless device a request to reconnect the wireless device to the computer system which hosts the DBMS or connects to the DBMS;

reconnecting the wireless device to the computer system; and

reestablishing a previous communication session between the wireless device and the computer system based on the communication session identification that identifies and distinguishes the previous communication session.

8. The method of claim 7, further comprising retrieving a session information of the respective previous communication session, wherein the session information comprises at least one of the first request to the DBMS and the stored result of the first request to the DBMS.

9. The method of claim 7, wherein reestablishing the previous communication session between the wireless device and the computer system comprises at least one of reestablishing an interrupted communication session and reestablishing a terminated communication session.

10. A method for wireless monitoring and management of a database management system (DBMS), wherein results of requests to the DBMS are stored for faster access when an interrupted or terminated database session is reestablished, comprising:

identifying a plurality of distinct communication sessions between the wireless device and a computer system which hosts the DBMS or connects to the DBMS;

assigning respective session identification information to each respective communication session between the wireless device and the computer system which hosts the DBMS or connects to the DBMS;

receiving at the computer system which hosts the DBMS or connects to the DBMS in at least one of said communication sessions a first request to the DBMS from the wireless device, wherein the first request 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;

appending the respective session identification information to the first request; and

storing on a server the first request with the appended session identification information.

11. The method of claim 10 further comprising:

associating the session identification information with a stored result of the first request made to the DBMS, said stored result with the appended session identification information being stored on the server.

12. The method of claim 11 further comprising:

updating the stored result of the stored first request.

13. The method of claim 12 further comprising:

adjusting how often the stored result of the stored first request is updated.

14. The method of claim 13, further comprising:

adjusting how often the stored result of the stored first request is updated based on a type of the stored first request.

15. The method of claim 10, wherein:

the identifying step further identifies a plurality of distinct communication sessions between a plurality of wireless device and a plurality of computer systems; and

the assigning step assigns respective session identification information to each respective communication session between each of the wireless devices and the computer systems.

16. The method of claim 10, further comprising:

detecting a loss of connection between the wireless device and the computer system which hosts the DBMS or connects to the DBMS;

reconnecting the wireless device to the computer system; and

reestablishing a previous communications session of the plurality of distinct communications sessions between the wireless device and the computer system based on the session identification information assigned to the previous communication session.

17. The method of claim 16, further comprising retrieving a session information of the reestablished previous communications session, wherein the retrieved session information comprises at least one of:

the first request to the DBMS with appended session identification information and a stored result of the first request to the DBMS with an appended session identification information.

18. The method of claim 16, wherein reestablishing the previous communication session between the wireless device and the computer system comprises at least one of reestablishing an interrupted communication session and reestablishing a terminated communication session.

19. A method for wireless monitoring and management of a database management system (DBMS) wherein results are stored for faster access when an interrupted or terminated database session is reestablished, comprising:

assigning a code to a first request made to a computer system from a wireless device, said computer system hosting the DBMS or connecting to the DBMS, and said code being stored on a server and representing at least one command comprising the first request for instructing the server to perform certain tasks to interact with the DBMS, wherein the first request 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 in response to the interaction with the server the DBMS monitors or manages the database; and

wherein the data size of the code is less than the data size of the at least one command comprising the first request, to enable the wireless device to instruct the server to perform said certain tasks by sending the code as the request to the server instead of sending the at least one command comprising the first request to the server.

20. The method of claim 19 further comprising:

assigning session identification information to each connection established between the wireless device and the computer system which hosts the DBMS or connects to the DBMS;

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

associating the session identification information with the code assigned to the stored first request.

21. The method of claim 20 further comprising:

updating the stored result of the stored first request.

22. The method of claim 21 further comprising:

adjusting how often the stored result of the stored first request is updated.

23. A method for wireless monitoring and management of one or more database management systems (DBMSs) wherein a result is stored for faster access when an interrupted or terminated database session is reestablished, comprising:

storing addresses of a plurality of computer system servers on a separate server;

storing addresses of a plurality of DBMSs on the separate server, wherein the computer system servers host the DBMSs or the computer system servers are connected to the DBMSs;

allowing a single wireless device to interact with the plurality of computer system servers and the plurality of DBMSs by communicating to the separate server a first request for interaction with the plurality of computer system servers and the plurality of DBMSs corresponding to the stored addresses identified in the request, and wherein in response to the interaction with the separate server the DBMSs will monitor or manage one or more databases; and

assigning a code to a first request made to a database management system (DBMS) from the single wireless device, said code being stored on a server and representing at least one command comprising the first request for instructing the server to perform certain tasks to interact with the DBMS, wherein;

the data size of the code is less than the data size of the at least one command comprising the first request, to enable the single wireless device to instruct the server to perform said certain tasks by sending the code as the first request to the server instead of sending the at least one command comprising the first request to the server; and

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

24. The method of claim 23 further comprising:

associating the respective addresses of each of the computer system servers and each of the DBMSs with respective user defined representation that are stored on the separate server.

25. The method of claim 24 further comprising:

allowing the user defined representations associated with each of the computer server systems and each of the DBMSs to be set by the user.