Exchanging project-related data in a client-server architecture

• US 9,632,768 B2
• Filed: 05/13/2013
• Issued: 04/25/2017
• Est. Priority Date: 11/18/2002
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Oracle America, Inc. (Oracle Corporation)
• Inventors: Li, Jimin, Wiegert, Cory D., Tse, Kwong Ming, Wei, Xuan, Fong, James Gan, Grumbach, Matthew Philip
• Primary Examiner(s): Tiv, Backhean
• Application Number:
  US13/892,580
• Publication Number:
  US 20130326468A1
• Time in Patent Office: 1,443 Days
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 8/70 Software maintenance or management
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

Techniques are described for exchanging data between software applications, such as project-related data between a project management software application (“PMSA”) and an unaffiliated organizational project tracking software application (“OPTSA”). A computing architecture with multiple interacting computer systems, such as a client-server architecture, can be used to allow users of remote computing systems to access project-related data and/or functionality from other computing systems, such as a thin client computing system with limited or no local capabilities to execute software applications and/or store associated application data accessing a remote central server computing system in order to interact with a PMSA executing on the server, to interact with an OPTSA executing on the server, and/or to invoke data exchange functionality available at the server for exchanging project-related data between the PMSA and OPTSA.

Claims

1. A method comprising:

receiving a local copy of a data file at a server computing system, wherein

the local copy of the data file is received from a client computing system,

the local copy of the data file includes data,

the local copy of the data file is in a first format,

the first format is used by a first software application, and

the local copy of the data file comprises values for multiple data fields in the local copy of the data file;

storing one or more local representations of the data in the local copy of the data file in a database at the server computing system, wherein

the data is stored in a second format, and

the second format is used by a second software application;

making a first modification to the one or more local representations of the data;

generating a new copy of the data file, wherein

the new copy of the data file reflects the first modification,

the new copy of the data file is stored in the second format; and

making a second modification to at least a portion of data in the new copy of the data file,

wherein the second modification is received from a second client computing system in the first format, and

the second modification is made by a copy of the first software application executing on the server computing system, wherein the second modification causes the local representations to be updated.

2. The method of claim 1, wherein the data is related to a project.

3. The method of claim 1, wherein

each of the one or more local representations comprises a value in a database data field that is mapped to a corresponding value in a data field of the local copy of the data file.

4. The method of claim 3, further comprising:

generating a mapping between the values in the local copy of the data field and the values in the database.

5. The method of claim 1, further comprising:

updating the local representations stored in the database, after the making the second modification to the at least a portion of the data in the new copy of the data file, wherein the updating is performed using the second software application executing on the server computing system.

6. The method of claim 5, further comprising:

updating the local copy of the data file, after the modifying the local representations, wherein

the updating the local copy of the data file is performed using the second software application executing on the server computing system.

7. The method of claim 1, wherein the first client computing system is a mobile client device.

8. The method of claim 1, further comprising:

creating the local copy of the data file at the client computing system, while the client computing system is disconnected from the server computing system, wherein

the creating is performed by the client computing system.

9. The method of claim 8, wherein

the receiving the local copy of the data file is performed after the client computing system has established a connection with the server computing system.

10. The method of claim 1, wherein the first and second software applications are not in direct communication with one another.

11. The method of claim 1, wherein

the generating the new copy of the data file is performed using a copy of the local representations of the data at the server computing system.

12. A non-transitory computer readable storage medium storing instructions, wherein

a method is implemented in response to executing the instructions, the method comprising:

receiving a local copy of a data file at a server computing system, wherein

the local copy of the data file is received from a client computing system,

the local copy of the data file includes data,

the local copy of the data file is in a first format,

the first format is used by a first software application, and

the local copy of the data file comprises values for multiple data fields in the local copy of the data file;

storing one or more local representations of the data in the local copy of the data file in a database at the server computing system, wherein

the data is stored in a second format, and

the second format is used by a second software application;

making a first modification to the one or more local representations of the data;

generating a new copy of the data file, wherein

the new copy of the data file reflects the first modification,

the new copy of the data file is stored in the second format; and

making a second modification to at least a portion of data in the new copy of the data file,

wherein the second modification is received from a second client computing system in the first format, and

the second modification is made by a copy of the first software application executing on the server computing system, wherein the second modification causes the local representations to be updated.

13. The non-transitory computer readable storage medium of claim 12, wherein

each of the one or more local representations comprises a value in a database data field that is mapped to a corresponding value in a data field of the local copy of the data file.

14. The non-transitory computer readable storage medium of claim 13, wherein the method further comprising:

generating a mapping between the values in the local copy of the data field and the values in the database.

15. The non-transitory computer readable storage medium of claim 12, wherein the method further comprising:

making a second modification to at least a portion of data in the new copy of the data file, wherein

the second modification is received from a second client computing system in the first format, and

the second modification is made by a copy of the first software application executing on the server computing system.

16. The non-transitory computer readable storage medium of claim 15, wherein the method further comprising:

updating the local representations stored in the database, after the making the second modification to the at least a portion of the data in the new copy of the data file, wherein

the updating is performed using the second software application executing on the server computing system.

17. The non-transitory computer readable storage medium of claim 16, wherein the method further comprising:

updating the local copy of the data file, after the modifying the local representations, wherein

the updating the local copy of the data file is performed using the second software application executing on the server computing system.

18. The non-transitory computer readable storage medium of claim 12, wherein the first client computing system is a mobile client device.

19. A server computing device comprising:

a memory in which a first software application and a second software application are executing to perform a method that comprises;

receiving a local copy of a data file, wherein

the local copy of the data file is received from a client computing system,

the local copy of the data file includes data,

the local copy of the data file is in a first format,

the first format is used by the first software application, and

the local copy of the data file comprises values for multiple data fields in the local copy of the data file,

storing one or more local representations of the data in the local copy of the data file in a database at the server computing system, wherein

the data is stored in a second format, and

the second format is used by the second software application,

making a first modification to the one or more local representations of the data,

generating a new copy of the data file, wherein

the new copy of the data file reflects the first modification,

the new copy of the data file is stored in the second format;

making a second modification to at least a portion of data in the new copy of the data file,

wherein the second modification is received from a second client computing system in the first format, and

the second modification is made by a copy of the first software application executing on the server computing system, wherein the second modification causes the local representations to be updated.