IP Library Granted Patent US 7,539,665
Granted Patent B2
US 7,539,665 · App. 10/279,369 · Granted May 26, 2009

System and method for merging remote and local data in a single user interface

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,539,665
App. No.
10/279,369
Granted
May 26, 2009
Kind
B2
Abstract

The system comprises a local database; a user interface; a remote access engine, communicatively coupled to a network, the user interface, and the local database; and a rendering engine, communicatively coupled to the remote access engine. The user interface receives a data search request. The remote access engine searches for and retrieves, from a remote database communicatively coupled to the network and the local database, data corresponding to the received search request. The rendering engine displays the received data from the remote database and the local database.

Claims (93)

1. A method, comprising:

receiving, from a handheld device, a data search request specifying at least one database to search for data;

searching in a local database, upon indication that the local database is included in the at least one database specified in the received data search request, for each data entry in the local database fulfilling requirements of the received data search request;

querying via a wireless connection a remote database manager to search in a remote database, upon indication that the remote database is included in the at least one database specified in the received data search request, for each data entry in the remote database fulfilling the requirements of the received data search request;

determining if receiving data from the local and remote databases corresponding to the received data search request exceeds a threshold of an amount of data that is displayed simultaneously on a display of the handheld device;

refining the received data search request if the determining indicates that the received data corresponding to the received data search request exceeds the threshold;

retrieving, from the local database, data entries found in the searching fulfilling the requirements of the refined data search request;

receiving, from the remote database via the wireless connection, data entries found in the querying fulfilling the requirements of the refined data search request;

merging the retrieved and received data entries; and

presenting the merged data entries in a single user interface on the display.

2. The method of claim 1 , further comprising:

excluding voluminous data exceeding a threshold, the voluminous data stored in the remote database, from the received data corresponding to the received data search request.

3. The method of claim 1 , further comprising:

excluding confidential data, stored in the remote database, from the received data corresponding to the received data search request.

4. The method of claim 1 , further comprising:

excluding obsolete data that is stored in the remote database longer than a threshold time period from the received data corresponding to the received data search request.

5. The method of claim 1 , further comprising:

excluding personal data associated with a user, the personal data stored in the local database, from the received data corresponding to the received data search request.

6. The method of claim 1 , wherein the local and remote databases store sales force automation data.

7. The method of claim 1 , wherein the local and remote databases store customer relations management data.

8. The method of claim 1 , wherein the local and remote databases store corporate directory data.

9. The method of claim 1 , wherein the local and remote databases store calendar data.

10. The method of claim 1 , wherein the local and remote databases store tasks data.

11. The method of claim 1 , wherein the local and remote databases store files.

12. The method of claim 1 , further comprising: saving, to the local database, the data received from the remote database.

13. The method of claim 1 , further comprising:

accessing the remote database using a one port of a plurality of ports on a firewall; and

presenting in the single user interface that the retrieved data is stored in the local database, and the received data is stored in the remote database.

14. The method of claim 1 , wherein searching the local database and querying the remote database manager are performed in response to a sole data search request.

15. A computer readable medium, including computer executable instructions that cause a computer to implement a method comprising:

receiving, from a handheld device, a data search request specifying at least one database to search for data;

searching in a local database, upon indication that the local database is included in the at least one database specified in the received data search request, for each data entry in the local database fulfilling requirements of the received data search request;

querying via a wireless connection a remote database manager to search in a remote database, upon indication that the remote database is included in the at least one database specified in the received data search request, for each data entry in the remote database fulfilling the requirements of the received data search request;

determining if receiving data from the local and remote databases corresponding to the received data search request exceeds a threshold of an amount of data that is displayed simultaneously on a display of the handheld device;

refining the received data search request if the determining indicates that the received data corresponding to the received data search request exceeds the threshold;

retrieving, from the local database, data entries found in the searching fulfilling the requirements of the refined data search request;

receiving, from the remote database via the wireless connection, data entries found in the querying fulfilling the requirements of the refined data search request;

merging the retrieved and received data entries; and

presenting the merged data entries in a single user interface on the display.

16. The method of claim 15 , further comprising:

excluding voluminous data exceeding a threshold, the voluminous data stored in the remote database, from the received data corresponding to the received data search request.

17. The method of claim 15 , further comprising:

excluding confidential data, stored in the remote database, from the received data corresponding to the received data search request.

18. The method of claim 15 , further comprising:

excluding obsolete data that is stored in the remote database longer than a threshold time period from the received data corresponding to the received data search request.

19. The method of claim 15 , further comprising:

excluding personal data associated with a user, the personal data stored in the local database, from the received data corresponding to the received data search request.

20. The computer readable medium of claim 15 , wherein the local and remote databases store sales force automation data.

21. The computer readable medium of claim 15 , wherein the local and remote databases store customer relations management data.

22. The computer readable medium of claim 15 , wherein the local and remote databases store corporate directory data.

23. The computer readable medium of claim 15 , wherein the local and remote databases store calendar data.

24. The computer readable medium of claim 15 , wherein the local and remote databases store tasks data.

25. The computer readable medium of claim 15 , wherein the local and remote databases store files.

26. The computer readable medium of claim 15 , wherein the method further comprises:

saving, to the local database, data received from the remote database.

27. The computer readable medium of claim 15 , wherein the method further comprises:

accessing the remote database using port one of a plurality of ports on a firewall, and

presenting in the single user interface that the retrieved data is stored in the local database, and the received data is stored in the remote database.

28. The computer readable medium of claim 15 , wherein searching the local database and querying the remote database manager are performed in response to a sole data search request.

29. A system, comprising:

at least one server computer coupled to a network:

means for receiving, from a handheld device, a data search request specifying at least one database to search for data;

means for searching in a local database, upon indication that the local database is included in the at least one database specified in the received data search request, for each data entry in the local database fulfilling requirements of the received data search request;

means for querying via a wireless connection a remote database manager to search in a remote database, upon indication that the remote database is included in the at least one database specified in the received data search request, for each data entry in the remote database fulfilling the requirements of the received data search request;

means for determining if receiving data from the local and remote databases corresponding to the received data search request exceeds a threshold of an amount of data that is displayed simultaneously on a display of the handheld device;

means for refining the received data search request if the determining indicates that the received data corresponding to the received data search request exceeds the threshold;

means for retrieving, from the local database, data entries found by the means for searching fulfilling the requirements of the refined data search request;

means for receiving, from the remote database via the wireless connection, data entries found by the means for querying fulfilling the requirements of the refined data search request;

means for merging the retrieved and received data entries; and

means for presenting the merged data entries in a single user interface on the display.

30. The system of claim 29 , wherein the means for querying the remote database manager queries the remote database manager in response to a sole data search request.

31. An apparatus, comprising:

a processor;

a local database;

a user interface, communicatively coupled to the local database, receives a data search request, from a handheld device, specifying at least one database to search for data and to search for and retrieve, from the local database, upon indication that the local database is included in the at least one database specified in the received data search request, each data entry in the local database fulfilling requirements of the received data search request;

a remote access engine, communicatively coupled to a network and the user interface, queries and receives via a wireless connection, from a remote database communicatively coupled to the network, upon indication that the remote database is included in the at least one database specified in the received data search request, each data entry in the remote database fulfilling requirements of the received data search request; and

the user interface further

determines if receiving data from the local and remote databases corresponding to the received data search request exceeds a threshold of an amount of data that is displayed simultaneously on a display of the handheld device;

refines the received data search request if the user interface determines that the received data corresponding to the received data search request exceeds the threshold:

retrieves, from the local database, data entries found in the searching fulfilling the requirements of the refined data search request;

receives, from the remote database via the wireless connection, data entries found in the querying fulfilling the requirements of the refined data search reguest;

a rendering engine, communicatively coupled to the remote access engine and the user interface, merges the received data from the remote database and the retrieved data from the local database and presents the merged data in a single user interface on the display.

32. The apparatus of claim 31 , wherein the rendering engine further excludes personal data stored in the local database.

33. The apparatus of claim 31 , wherein the local database stores sales force automation data.

34. The apparatus of claim 31 , wherein the local database stores customer relations management data.

35. The apparatus of claim 31 , wherein the local database stores corporate directory data.

36. The apparatus of claim 31 , wherein the local database stores calendar data.

37. The apparatus of claim 31 , wherein the local database stores tasks data.

38. The apparatus of claim 31 , wherein the local database stores files.

39. The apparatus of claim 31 , wherein the user interface further saves, to the local database, data received from the remote database.

40. The system of claim 29 , further comprising: a firewall to protect the remote database, wherein the means for presenting the retrieved and received data in the single user interface also presents in the single user interface that the retrieved data is stored in the local database, and the received data is stored in the remote database.

41. The apparatus of claim 31 , further comprising: a firewall to protect the remote database, and wherein the rendering engine is further configured to present in the single user interface that the retrieved data is stored in the local database, and the received data is stored in the remote database.

42. The apparatus of claim 31 , wherein the remote access engine queries the remote database in response to a sole data search request.

Assignments (7)
NUNC PRO TUNC ASSIGNMENT Recorded Jun 19, 2023
From: BLACKBERRY LIMITED
To: MALIKIE INNOVATIONS LIMITED
Reel/Frame 064271/0199 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 16, 2023
From: BLACKBERRY LIMITED
To: MALIKIE INNOVATIONS LIMITED
Reel/Frame 064104/0103 →
CHANGE OF NAME Recorded Oct 28, 2014
From: RESEARCH IN MOTION LIMITED
To: BLACKBERRY LIMITED
Reel/Frame 034068/0923 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 24, 2013
From: BEECHWOOD LIMITED PARTNERSHIP
To: RESEARCH IN MOTION LIMITED
Reel/Frame 030483/0660 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 25, 2009
From: VISTO CORPORATION
To: BEECHWOOD LIMITED PARTNERSHIP
Reel/Frame 023303/0764 →
CHANGE OF ADDRESS Recorded Sep 16, 2009
From: VISTO CORPORATION
To: VISTO CORPORATION
Reel/Frame 023234/0410 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 29, 2003
From: MENDEZ, DANIEL J.
To: VISTO CORPORATION
Reel/Frame 013710/0498 →