System and method for expanding PC-based software capabilities

• US 9,026,618 B2
• Filed: 11/08/2010
• Issued: 05/05/2015
• Est. Priority Date: 11/08/2010
• Status: Active Grant

• Current Assignee: Junglewave Interactive, LLC
• Original Assignee: Junglewave Interactive, LLC
• Inventors: Hung, Jason J.
• Primary Examiner(s): Taylor, Nicholas
• Assistant Examiner(s): Williams, Clayton R
• Application Number:
  US12/941,831
• Publication Number:
  US 20120117125A1
• Time in Patent Office: 1,639 Days
• Field of Search: None
• US Class Current: 709/219
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 9/40 Network security protocols

Abstract

System and method for expanding the capabilities of a PC-based software are disclosed. The system provides a technique for synchronizing a database associated with a PC-based software with a WAN server database. Additionally, a WAN server, associated with the WAN server database, is configured to provide substantially the same functionality as that of the PC-based software. This effectively facilitates web-access of the PC-based software and database by way of the WAN server and database. The WAN server may be configured to provide additional functions in order to expand the functionality of the PC-based software. The WAN server may also be configured to integrate distinct databases by either relaying information between the distinct databases or integrating the information from the distinct databases into a single database.

Claims

1. A system, comprising:

one or more processor-based devices configured to execute;

a PC-based software module adapted to implement a first change to a PC-based software database based on an input from a user, wherein the PC-based software module includes a first set of functions for modifying data in the PC-based software database; and

a middleware module, separate from the PC-based software module, adapted to;

detect a first change to a PC-based software database;

transmit a first message including information related to the first change to a WAN server by way of a wide area network (WAN);

determine whether a requested function of the input initiated by the user falls within the first set of functions or within a second set of functions, wherein the WAN server includes the second set of functions for modifying data in a WAN server database, the second set of functions being different than the first set of functions; and

transmit a command to perform the requested function to the WAN server in response to determining that the requested function falls within the second set of functions and not within the first set of functions; and

the WAN server adapted to;

receive the first message from the middleware module by way of the WAN; and

modify the WAN server database based on the first change information to synchronize the data in the WAN server database with the data in the PC-based software database, wherein the second set of functions includes a particular data analysis function associated with the synchronized data in the WAN server database and the PC-based software database, wherein the particular data analysis function is not in the first set of functions.

2. The system of claim 1, wherein the middleware module is adapted to detect the first change in the PC-based software database on a time-scheduled basis.

3. The system of claim 2, wherein the time-scheduled basis is periodic.

4. The system of claim 1, wherein the middleware module is adapted to detect the first change in the PC-based software database in response to receiving a signal indicating that the first change has taken place.

5. The system of claim 1, wherein the middleware module is adapted to transmit the first message using a messaging protocol.

6. The system of claim 5, the messaging protocol comprises an Extensible Messaging and Presence Protocol (XMPP).

7. The system of claim 5, the messaging protocol comprises an Advance Message Queuing Protocol (AMQP).

8. The system of claim 1, further comprising a local area network (LAN) coupled to the one or more processor-based devices.

9. The system of claim 8, wherein the middleware module is adapted to transmit the first message to the WAN server by way of the LAN.

10. The system of claim 1, further comprising the PC-based software database.

11. The system of claim 1, further comprising the WAN server database.

12. The system of claim 1, wherein the WAN server is further adapted to:

receive a second message including a request to perform a second change to the WAN server database;

modify the WAN server database based on the request; and

transmit a third message including information related to the second change to the middleware module by way of the WAN.

13. The system of claim 12, wherein the WAN server is further adapted to receive the second message from a web client device by way of the WAN.

14. The system of claim 12, wherein the middleware module is further adapted to:

receive the third message from the WAN server by way of the WAN; and

modify the PC-based software database based on the second change information.

15. The system of claim 1, wherein the PC-based software module is adapted to effectuate the first change to the PC-based software database based on at least one function of the first set of functions.

16. The system of claim 15, wherein the first and second sets of functions have a plurality of functions in common.

17. The system of claim 1, wherein the WAN server is adapted to:

receive a request to perform one or more functions of the second set of functions;

modify the WAN server database based on the performance of the requested one or more functions; and

transmit information related to the modification of the WAN server database to the middleware module by way of the WAN.

18. The system of claim 1, wherein the WAN server is adapted to assign a collision-prevention code to a database object to prevent inconsistent modifications to the object by multiple users.

19. The system of claim 1, wherein the middleware module is configured to:

detect a request to perform the particular analysis function to the data in the PC-based software database initiated by the user;

transmit information concerning the request to the WAN server; and

wherein the WAN server is configured to perform the requested analysis of the data in response to receiving the information from the middleware module.

20. A system, comprising:

a WAN server adapted to;

receive a first message including a request to perform a first change to a WAN server database;

modify the WAN server database based on the request in accordance with one or more functions of a first set of functions;

transmit a second message including information related to the modification to a middleware module by way of a WAN; and

one or more processor-based devices adapted to execute;

a PC-based software program adapted to implement a second change to a PC-based software database in accordance with one or more functions in a second set of functions based on an input from a user, the second set of functions being different than the first set of functions, and wherein the first set of functions includes a particular data analysis function associated with synchronized data in the WAN server database and the PC-based software database, wherein the particular data analysis function is not in the second set of functions; and

the middleware module, separate from the PC-based software program, adapted to;

receive the second message from the WAN server by way of the WAN;

modify the PC-based database based on the modification to synchronize the data in the PC-based software database with the data in the WAN server database;

determine whether a requested function initiated by a user falls within the first set of functions or within a second set of functions; and

transmit a command to perform the requested function to the WAN server in response to determining that the requested function falls within the first set of functions and not within the second set of functions.

21. The system of claim 20, wherein the first and second sets of functions have a plurality of functions in common.

22. A system, comprising:

a first network device;

a first database coupled to the first network device;

a second network device;

a second database coupled to the second network device; and

a first WAN server adapted to;

receive a first message including information related to a modification to the first database from the first network device by way of a WAN, wherein the modification of the first database was effectuated in accordance with one or more functions of a first set of functions;

send a second message including the modification to the first database to the second network device by way of the WAN;

wherein the second network device is adapted to modify the second database based on the modification to synchronize the data in the second database with the data in the first database, wherein the second network device includes a second set of functions for modifying data in the second database, the second set of functions being different than the first set of functions, and wherein the second set of functions includes a particular data analysis function associated with the synchronized data in the first and second databases, wherein the particular data analysis function is not in the first set of functions; and

wherein the first network device comprises a first set of one or more processor-based devices configured to execute;

a first PC-based software module adapted to perform the modification of the first database in accordance with one or more functions of the first set of functions based on an input from a user; and

a first middleware module, separate from the first PC-based software module, adapted to;

detect the modification to the first database by the first PC-based software module;

transmit the first message to the first WAN server by way of the WAN;

determine whether a requested function initiated by a user falls within the first set of functions or within the second set of functions; and

transmit a command to perform the requested function to the second network device by way of the first WAN server in response to determining that the requested function falls within the second set of functions and not within the first set of functions.

23. The system of claim 22, wherein the first WAN server is adapted to re-format the modification information.

24. The system of claim 22, wherein the second network device comprises a second set of one or more processor-based devices configured to operate:

a second PC-based software module adapted to perform a modification of the second database in accordance with one or more functions of the second set of functions based on an input from another user; and

a second middleware module, separate from the second PC-based software module, adapted to modify the second database based on the second message.

25. The system of claim 22, wherein the second network device comprises a second WAN server and the second database comprises a WAN server database.

26. The system of claim 22, wherein the first WAN server is adapted to assign a collision-prevention code to a database object to prevent inconsistent modifications to the object by multiple users.

27. A system, comprising:

a first network device;

a first database coupled to the first network device;

a second network device;

a second database coupled to the second network device;

a first WAN server database; and

a first WAN server adapted to;

receive a first message including information related to a first modification to the first database from the first network device by way of a WAN, wherein the first modification of the first database was effectuated in accordance with one or more functions of a first set of functions;

receive a second message including information related to a second modification to the second database from the second network device by way of the WAN, wherein the second modification of the second database was effectuated in accordance with one or more functions of a second set of functions, the second set of functions being different than the first set of functions, and wherein the second set of functions includes a particular data analysis function associated with synchronized data in the first and second databases, wherein the particular data analysis function is not in the first set of functions; and

modify the first WAN server database based on the first modification information and the second modification information;

wherein the first network device comprises a first set of one or more processor-based devices configured to execute;

a first PC-based software module adapted to perform the first modification of the first database based on an input from a user; and

a first middleware module, separate from the first PC-based software module, adapted to;

detect the first modification to the first database by the first PC-based software module;

transmit the first message to the first WAN server by way of the WAN;

determine whether a requested function initiated by a user falls within the first set of functions or within the second set of functions; and

transmit a command to perform the requested function to the second network device by way of the first WAN server in response to determining that the requested function falls within the second set of functions and not within the first set of functions.

28. The system of claim 27, wherein the first WAN server is adapted to re-format at least one of the first or second modification information.

29. The system of claim 27, wherein the second network device comprises:

a second set of one or more processor-based devices configured to operate;

a second PC-based software module adapted to perform the modification of the second database based on an input from another user; and

a second middleware module, separate from the second PC-based software module, adapted to;

detect the modification to the second database by the second PC-based software module; and

transmit the second message to the first WAN server by way of the WAN.

30. The system of claim 27, wherein the second network device comprises a second WAN server and the second database comprises a second WAN server database.

31. A system comprising:

one or more processor-based devices configured to execute;

a PC-based software module adapted to implement a first change to a PC-based software database based on an input from a user, wherein the PC-based software module includes a first set of functions for modifying data in the PC-based software database; and

a middleware module, separate from the PC-based software module, adapted to;

detect the first change to the PC-based software database;

transmit a first message including information related to the first change to a WAN server by way of a wide area network (WAN);

determine whether a requested function of the input initiated by the user falls within the first set of functions or within a second set of functions, wherein the WAN server includes the second set of functions for modifying data in the WAN server database, the second set of functions being different than the first set of functions; and

transmit a command to perform the requested function to the WAN server in response to determining that the requested function falls within the second set of functions and not within the first set of function; and

the WAN server adapted to;

receive the first message from the middleware module by way of the WAN; and

modify a WAN server database based on the first change to synchronize the data in the WAN server database with the data in the PC-based software database.

32. The system of claim 31, wherein the middleware module is configured to modify that PC-based software database in response to a synchronization command received from the WAN server due to the execution of the requested function.

33. A system comprising:

one or more processor-based devices configured to execute;

a PC-based software module adapted to implement a first change to a PC-based software database based on an input from a user, wherein the PC-based software module includes a first set of functions for modifying data in the PC-based software database; and

a middleware module, separate from the PC-based software module, adapted to;

detect the first change to the PC-based software database;

transmit a first message including information related to the first change to a WAN server by way of a wide area network (WAN);

determine whether a requested function of the input initiated by the user falls within the first set of functions or within a second set of functions, wherein the WAN server includes the second set of functions for modifying data in the WAN server database, the second set of functions being different than the first set of functions; and

transmit a command to perform the requested function to the WAN server in response to determining that the requested function falls within the second set of functions and not within the first set of functions; and

the WAN server adapted to;

receive the first message from the middleware module by way of the WAN; and

modify a WAN server database based on the first change to synchronize the data in the WAN server database with the data in the PC-based software database, wherein the second set of functions includes a security access function to the synchronized data in the WAN server database and the PC-based software database, wherein the security access function is not in the first set of functions.

34. The system of claim 33, wherein the middleware module is configured to:

detect a request to access the PC-based software database initiated by the user;

transmit, in accordance with the security access function, the access request and credential information associated with the user to the WAN server; and

receive instructions as to whether to allow access to the PC-based software database by the user from the WAN server in accordance with the security access function.

35. A system comprising:

one or more processor-based devices configured to execute;

a PC-based software module adapted to implement a first change to a PC-based software database based on an input from a user, wherein the PC-based software module includes a first set of functions for modifying data in the PC-based software database; and

a middleware module, separate from the PC-based software module, adapted to;

detect the first change to the PC-based software database; and

transmit a first message including information related to the first change to a WAN server by way of a wide area network (WAN);

determine whether a requested function of the input initiated by the user falls within the first set of functions or within a second set of functions, wherein the WAN server includes the second set of functions for modifying data in the WAN server database, the second set of functions being different than the first set of functions; and

transmit a command to perform the requested function to the WAN server in response to determining that the requested function falls within the second set of functions and not within the first set of functions; and

the WAN server adapted to;

receive the first message from the middleware module by way of the WAN; and

modify a WAN server database based on the first change to synchronize the data in the WAN server database with the data in the PC-based software database, wherein the second set of functions includes an event log function for the synchronized data in the WAN server database and the PC-based software database, wherein the event log function is not in the first set of functions.

36. The system of claim 35, wherein the middleware module is configured to:

detect an action with respect to a data object in the PC-based software database initiated by the user;

transmit, in accordance with the event log function, information concerning the action to the WAN server; and

wherein the WAN server is configured to create or update an event log associated with the data object in response to receiving the information concerning the action from the middleware module.

37. A system comprising:

one or more processor-based devices configured to execute;

a PC-based software module adapted to implement a first change to a PC-based software database based on an input from a user, wherein the PC-based software module includes a first set of functions for modifying data in the PC-based software database; and

a middleware module, separate from the PC-based software module, adapted to;

detect the first change to the PC-based software database;

transmit a first message including information related to the first change to a WAN server by way of a wide area network (WAN);

determine whether a requested function of the input initiated by the user falls within the first set of functions or within a second set of functions, wherein the WAN server includes the second set of functions for modifying data in the WAN server database, the second set of functions being different than the first set of functions; and

transmit a command to perform the requested function to the WAN server in response to determining that the requested function falls within the second set of functions and not within the first set of functions; and

the WAN server adapted to;

receive the first message from the middleware module by way of the WAN; and

modify a WAN server database based on the first change to synchronize the data in the WAN server database with the data in the PC-based software database, wherein the second set of functions includes a revisions log function for the synchronized data in the WAN server database and the PC-based software database, wherein the revisions log function is not in the first set of functions.

38. The system of claim 37, wherein the middleware module is configured to:

detect a revision of data in the PC-based software database initiated by the user;

transmit, in accordance with the revisions log function, information concerning the revision of the data to the WAN server; and

wherein the WAN server is configured to update a revisions log associated with the data in response to receiving the information concerning the revision of the data from the middleware module.

39. A system comprising:

one or more processor-based devices configured to execute;

a PC-based software module adapted to implement a first change to a PC-based software database based on an input from a user, wherein the PC-based software module includes a first set of functions for modifying data in the PC-based software database; and

a middleware module, separate from the PC-based software module, adapted to;

detect the first change to the PC-based software database;

transmit a first message including information related to the first change to a WAN server by way of a wide area network (WAN);

determine whether a requested function of the input initiated by the user falls within the first set of functions or within a second set of functions, wherein the WAN server includes the second set of functions for modifying data in the WAN server database, the second set of functions being different than the first set of functions; and

transmit a command to perform the requested function to the WAN server in response to determining that the requested function falls within the second set of functions and not within the first set of functions; and

the WAN server adapted to;

receive the first message from the middleware module by way of the WAN; and

modify a WAN server database based on the first change to synchronize the data in the WAN server database with the data in the PC-based software database, wherein the second set of functions includes an action approval function for the synchronized data in the WAN server database and the PC-based software database, wherein the action approval function is not in the first set of functions.

40. The system of claim 39, wherein the middleware module is configured to:

detect a request to perform an action with respect to a data object in the PC-based software database initiated by the user;

transmit, in accordance with the action approval function, information concerning the request to the WAN server; and

wherein the WAN server is configured to;

determine, in response to receiving the action request, whether to send an approval request to a second user based on an approval criteria associated with the data object;

transmit the approval request to the second user in response to the approval criteria indicating approval for the action by the second user; and

transmit information concerning an approval or disapproval for the requested action based on a response received from the second user or lack of the response within a defined time period from the transmitting of the approval request.

41. A system comprising:

one or more processor-based devices configured to execute;

a PC-based software module adapted to implement a first change to a PC-based software database based on an input from a user, wherein the PC-based software module includes a first set of functions for modifying data in the PC-based software database;

a middleware module, separate from the PC-based software module, adapted to;

detect the first change to the PC-based software database; and

transmit a first message including information related to the first change to a WAN server by way of a wide area network (WAN);

determine whether a requested function of the input initiated by the user falls within the first set of functions or within a second set of functions, wherein the WAN server includes the second set of functions for modifying data in the WAN server database, the second set of functions being different than the first set of functions; and

transmit a command to perform the requested function to the WAN server in response to determining that the requested function falls within the second set of functions and not within the first set of functions; and

the WAN server adapted to;

receive the first message from the middleware module by way of the WAN; and

modify a WAN server database based on the first change to synchronize the data in the WAN server database with the data in the PC-based software database, wherein the second set of functions includes an alert function associated with the synchronized data in the WAN server database and the PC-based software database, wherein the alert function is not in the first set of functions.

42. The system of claim 41, wherein the middleware module is configured to:

detect a change to the data in the PC-based software database initiated by the user;

transmit information concerning the change to the WAN server; and

wherein the WAN server is configured to determine whether to transmit a message, in accordance with the alert function, based on a message criteria and the change to the data.