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

• US 8,260,796 B2
• Filed: 02/05/2009
• Issued: 09/04/2012
• Est. Priority Date: 10/23/2001
• Status: Expired due to Term

• Current Assignee: Malikie Innovations Limited (Key Patent Innovations Limited)
• Original Assignee: Beechwood Limited Partnership
• Inventors: Mendez, Daniel J.
• Primary Examiner(s): Pham, Hung Q
• Application Number:
  US12/366,445
• Publication Number:
  US 20090144632A1
• Time in Patent Office: 1,307 Days
• Field of Search: 707/758, 707/767, 707/765, 707/766
• US Class Current: 707/758
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99936 Pattern matching access

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

1. A method, comprising:

receiving 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 data search request, for each data entry in the local database corresponding to the 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 data search request, for each data entry in the remote database corresponding to the data search request;

determining if the data entries from the local database and the data entries from the remote database corresponding to the data search request exceed a threshold of an amount of data that can be displayed simultaneously on a display of a handheld device;

refining the data search request if the data entries from the local database and the data entries from the remote database corresponding to the data search request exceed the threshold;

repeating said searching, querying, determining, and refining until said data entries do not exceed the threshold;

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

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

merging the retrieved and received data entries.

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 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 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 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 retrieved data corresponding to the received data 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, wherein the local database is data stored on a smartphone.

14. The method of claim 1, wherein the remote database is data stored on a remote personal computer.

15. The method of claim 1, further comprising accessing the remote database using a one port of a plurality of ports on a firewall.

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

17. The method of claim 1, further comprising presenting in a single user interface that the retrieved data is stored in the local database, and the received data is stored in the remote database.

18. A non-transitory computer readable medium, including computer executable instructions that cause a computer to implement a method comprising:

receiving 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 data search request, for each data entry in the local database corresponding to the 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 data search request, for each data entry in the remote database corresponding to the data search request;

determining if the data entries from the local database and the data entries from the remote database corresponding to the data search request exceed a threshold of an amount of data that can be displayed simultaneously on a display of a handheld device;

refining the data search request if the data entries from the local database and the data entries from the remote database corresponding to the data search request exceed the threshold;

repeating said searching, querying, determining, and refining until said data entries do not exceed the threshold;

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

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

merging the retrieved and received data entries.

19. The computer readable medium of claim 18, 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 request.

20. The computer readable medium of claim 18, further comprising:

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

21. The computer readable medium of claim 18, 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 request.

22. The computer readable medium of claim 18, further comprising:

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

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

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

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

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

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

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

29. The computer readable medium of claim 18, wherein the method further comprises:

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

30. The computer readable medium of claim 18, wherein the local database is data stored on a smartphone.

31. The computer readable medium of claim 18, wherein the remote database is data stored on a remote personal computer.

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

33. The computer readable medium of claim 18, wherein the method further comprises:

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

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

34. A method, comprising:

receiving a data search request to search for data;

searching in a local database for data entries corresponding to the data search request;

requesting a search of a remote database for data entries corresponding to the data search request;

after said searching and requesting,

determining if the data entries from the local database and the data entries from the remote database corresponding to the data search request exceed a limit; and

refining the data search request if said data entries from the local database and the data entries from the remote database exceed the limit;

repeating said searching, requesting, determining, and refining until said data entries do not exceed the limit;

retrieving from the local database retrieved data satisfying the requirements of the data search request as refined;

receiving from the remote database received data satisfying the requirements of the data search request as refined; and

merging the data retrieved from the local database and the data received from the remote database.

35. The method of claim 34, wherein requesting the search of the remote database occurs via a wireless connection.

36. The method of claim 34, wherein receiving data from the remote database occurs via a wireless connection.

37. The method of claim 34, wherein the limit corresponds to an amount of data that can be displayed in a user interface display.

38. The method of claim 34, wherein the limit corresponds to a pre-specified number of matches with the data search request.

39. The method of claim 34, wherein the limit is pre-specified.

40. The method of claim 34, further comprising presenting in a 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 method of claim 34, wherein the data search request is refined.

42. The method of claim 34, wherein refining comprises refining the data search request using a specified search term.

43. The method of claim 34, wherein the data search request is received at a wireless communication device.

44. The method of claim 43, wherein the wireless communication device comprises a wireless voice and data communication device.

45. A wireless communication device comprising a processor configured to:

receive a data search request to search for data;

search in a local database for data entries corresponding to the data search request;

request a search of a remote database for data entries corresponding to the data search request;

after said search and request,

determine if the data entries from the local database and the data entries from the remote database corresponding to the data search request exceed a limit; and

refine the data search request if said data entries from the local database and the data entries from the remote database corresponding to the data search request exceed the limit;

repeat said searching, requesting, determining, and refining until said data entries do not exceed the limit;

retrieve from the local database retrieved data satisfying the requirements of the data search request as refined;

receive from the remote database received data satisfying the requirements of the data search request as refined; and

merge the data retrieved from the local database and the data received from the remote database.

46. The wireless communication device of claim 45, wherein the processor is further configured to request the search of the remote database using a wireless connection.

47. The wireless communication device of claim 45, wherein the processor is further configured to receive data from the remote database using a wireless connection.

48. The wireless communication device of claim 45, wherein the limit corresponds to an amount of data that can be displayed in a user interface display.

49. The wireless communication device of claim 45, wherein the limit corresponds to a pre-specified number of matches with the data search request.

50. The wireless communication device of claim 45, wherein the limit is pre-specified.

51. The wireless communication device of claim 45, wherein the processor is further configured to present in a single user interface that the retrieved data is stored in the local database, and the received data is stored in the remote database.

52. The wireless communication device of claim 45, wherein the data search request is refined.

53. The wireless communication device of claim 45, wherein the processor is further configured to refine the data search request using a specified search term.

54. The wireless communication device of claim 45, wherein said wireless communication device is adapted for voice and data communication.

55. A method, comprising:

searching in a local database for data entries corresponding to a data search request, the data search request being associated with a limit;

requesting a search of a remote database for data entries corresponding to the data search request;

after said searching and requesting, refining the data search request upon determination that a total number of data entries in the local database and remote database corresponding to the data search request exceeds the limit;

repeating said searching, requesting and refining until said total number does not exceed the limit;

retrieving from the local database retrieved data fulfilling the requirements of the data search request as refined;

receiving from the remote database received data fulfilling the requirements of the data search request as refined; and

merging the data retrieved from the local database and the data received from the remote database.

56. The method of claim 55, wherein requesting the search of the remote database occurs via a wireless connection.

57. The method of claim 55, wherein receiving data from the remote database occurs via a wireless connection.

58. The method of claim 55, wherein the limit corresponds to an amount of data that can be displayed in a user interface display.

59. The method of claim 55, wherein the limit corresponds to a pre-specified number of matches with the data search request.

60. The method of claim 55, wherein the limit associated with the data search request is pre-specified.

61. The method of claim 55, further comprising presenting in a single user interface that the retrieved data is stored in the local database, and the received data is stored in the remote database.

62. The method of claim 55, wherein the data search request is received at a wireless communication device comprising the local database.

63. The method of claim 62, wherein the wireless communication device comprises a voice and data communication device.

64. The method of claim 55, further comprising refining a received data search request to provide the data search request associated with the limit.

65. The method of claim 64, wherein the received data search request is refined using a specified search term.

66. A wireless communication device comprising a processor configured to:

search in a local database for data entries corresponding to a data search request, the data search request being associated with a limit;

request a search of a remote database for data entries corresponding to the data search request;

after said search and request, refine the data search request upon determination that a total number of data entries in the local database and remote database corresponding to the data search request exceeds the limit;

repeating said searching, requesting and refining until said total number does not exceed the limit;

retrieve from the local database, retrieved data fulfilling the requirements of the data search request as refined;

receive from the remote database, following the refining of the data search request, received data fulfilling the requirements of the data search request as refined; and

merge the data retrieved from the local database and the data received from the remote database.

67. The wireless communication device of claim 66, wherein the processor is further configured to request the search of the remote database using a wireless connection.

68. The wireless communication device of claim 66, wherein the processor is further configured to receive data from the remote database using a wireless connection.

69. The wireless communication device of claim 66, wherein the limit corresponds to an amount of data that can be displayed in a user interface display.

70. The wireless communication device of claim 66, wherein the limit corresponds to a pre-specified number of matches with the data search request.

71. The wireless communication device of claim 66, wherein the limit associated with the data search request is pre-specified.

72. The wireless communication device of claim 66, wherein the processor is further configured to present in a single user interface that the retrieved data is stored in the local database, and the received data is stored in the remote database.

73. The wireless communication device of claim 66, wherein the wireless communication device is a voice and data communication device.

74. The wireless communication device of claim 66, wherein the processor is further configured to refine a received data search request to provide the data search request associated with the limit.

75. The wireless communication device of claim 74, wherein the received data search request is refined using a specified search term.