Use of email to update records stored in a database server

• US 10,536,404 B2
• Filed: 09/13/2013
• Issued: 01/14/2020
• Est. Priority Date: 09/13/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Kumar, Saurabh
• Primary Examiner(s): Obisesan, Augustine K.
• Application Number:
  US14/025,853
• Publication Number:
  US 20150081730A1
• Time in Patent Office: 2,314 Days
• CPC Class Codes: G06F 16/235 Update request formulation
• CPC Class Codes: H04L 51/04 Real-time or near real-time messaging, e.g. instant messaging [IM]
• CPC Class Codes: H04L 51/08 Annexed information, e.g. attachments
• CPC Class Codes: H04L 51/216 Handling conversation history, e.g. grouping of messages in sessions or threads
• CPC Class Codes: H04L 51/42 Mailbox-related aspects, e.g. synchronisation of mailboxes

Abstract

According to an aspect multiple records are stored in a database server. A set of records are retrieved by querying the database server. A first file is formed to contain the retrieved set of records. The first file is sent by email to a user, and a second file, with at least one of the set of records modified, is received from the user by email. The received modifications contained in the second file are propagated to the database server, upon receipt of the second file. Users may accordingly be able to effect modifications to multiple records in a single email exchange. According to another aspect, the updates are effected by using a SOA server storing a process definition to interface (send and receive emails) with the user and propagate the changes. The SOA server may contain a workflow block to interact with users based on email exchange.

Claims

1. A method of managing records, said method comprising:

storing a plurality of records in a database server, wherein said plurality of records includes a first record containing a first column set to a first data value;

issuing a first structured query directed to said database server to retrieve a set of records of interest, wherein said query specifies a condition and wherein each of said set of records satisfies said condition, wherein said set of records includes said first record with said first data value;

forming a first file by incorporating into said first file, said set of records retrieved from said database server, wherein each of said set of records, including said first record with said first data value, is incorporated into said first file after being retrieved from said database server;

sending said first file, containing said set of records, by email to a user;

receiving a second file, with at least one of said set of records modified, by email from said user, wherein said second file indicates a second data value for said first column of said first record,

wherein said second file contains a respective additional field for each of said set of records, wherein the additional field indicates whether the corresponding record has been modified or not, wherein the additional field for said first record indicates that said first record has been modified;

parsing said second file to determine the specific records of said set of records which are indicated by the respective additional fields as having been modified; and

propagating the modifications contained in said second file to said database server, upon receipt of said second file, wherein said propagating comprises issuing a second structured query directed to said database server to update said at least one of said set of records,

wherein said second structured query is designed to update only said specific records in said database server,

wherein said first data value for said first column is replaced by said second data value in said database server due to execution of said second structured query in said database server.

2. The method of claim 1, wherein said first file is sent as a corresponding attachment to said email sent to said user, and said second file with modifications is received as a corresponding attachment to said email received from said user.

3. The method of claim 1, wherein each of said first structured query and said second structured query is according to SQL (structured query language),

said database server containing a plurality of tables, each table containing a plurality of rows,

each of said plurality of records being stored as a respective row of a corresponding table,

said first structured query according to said SQL specifying said condition such that the rows of data in said plurality of tables satisfying said condition constitute said set of records of interest retrieved from said database server,

said second structured query according to said SQL causing update of a row storing said at least one of said set of records.

4. The method of claim 3, further comprising:

maintaining, a process definition containing a set of tasks, wherein said set of tasks include interfacing with said user, and said propagating; and

receiving a request to execute said process definition, said request specifying said first file and said user as parameters such that said first file is sent to said user by email.

5. The method of claim 4, wherein a process manager executes said process definition in response to receiving of said request,

said process manager being contained in a SOA (Service Oriented Architecture) server and said process definition being specified according to Business Process Execution Language (BPEL),

said process manager invoking a human workflow block to perform said sending and said receiving.

6. The method of claim 5, wherein said plurality of records correspond to issues raised by members of a team, and wherein said condition comprises specifying a manager who is to process the issues as a next step, said user comprising said manager such that said first file contains only issues that are to be processed by said manager,

wherein said issuing, said forming and said sending of said first file are performed periodically,

said set of records being provided as respective rows in said first file and each row containing a set of columns, wherein said modifications comprise changes made by said manager to data in said set of records in said first file, and

wherein modifications performed to said first file are propagated to said database server by execution of said process definition.

7. The method of claim 1, wherein said plurality of records includes a second record with a third data value for said first column in said database server,

wherein said second record with said third data value is retrieved as a part of said set of records and incorporated into said first file sent to said user,

wherein said second file indicates said third data value for said first column of said second record,

wherein said second structured query is designed to update said first record but not said second record in said database server in view of change of data value of said first record but not said second record.

8. A computing system comprising:

a database server;

an application server to populate said database server with a plurality of records, wherein said plurality of records includes a first record containing a first column set to a first data value,

wherein said application server is operable to issue a first structured query directed to said database server to retrieve a set of records as being of interest, wherein said query specifies a condition and wherein each of said set of records satisfies said condition, wherein said set of records includes said first record with said first data value,

said application server further operable to form a first file by incorporating said set of records into said first file, wherein each of said set of records, including said first record with said first data value, is incorporated into said first file after being retrieved from said database server; and

an update server operable to;

send said first file containing said set of records by email to a user, said set of records being contained in said plurality of records;

receive a second file, with at least one of said set of records modified, by email from said user, wherein said second file indicates a second data value for said first column of said first record,

wherein said second file contains a respective additional field for each of said set of records, wherein the additional field indicates whether the corresponding record has been modified or not, wherein the additional field for said first record indicates that said first record has been modified;

parsing said second file to determine the specific records of said set of records which are indicated by the respective additional fields as having been modified; and

propagate the modifications contained in said second file to said database server, upon receipt of said second file, wherein to said propagate, said update server issues a second structured query directed to said database server to update said at least one of said set of records,

wherein said second structured query is designed to update only said specific records in said database server,

wherein said first data value for said first column is replaced by said second data value in said database server due execution of said second structured query in said database server.

9. The computing system of claim 8, further comprising a repository server,

said application server being operable to store said first file in said repository server and to generate a request to said update server to cause said update server to perform said send of said first file,

wherein each of said first structured query and said second structured query is according to SQL (structured query language),

said database server containing a plurality of tables, each table containing a plurality of rows, each of said plurality of records being stored as a respective row of a corresponding table,

said first structured query according to said SQL specifying said condition such that the rows of data in said plurality of tables satisfying said condition constitute said set of records of interest retrieved from said database server, said set of records being provided as respective rows in said first file and each row containing a set of columns,

said second structured query according to said SQL causing update of a row storing said at least one of said set of records.

10. The computing system of claim 9, wherein said update server is a Service Oriented Architecture (SOA) server storing a process definition specified in Business Process Execution Language (BPEL), said process definition specifying interfacing with said user and said propagate as respective tasks,

said update server being operable to receive a request to execute said process definition, and to execute said process definition in response to receipt of said request.

11. The computing system of claim 10, wherein said update server is operable to store said second file also in said repository server, wherein said update server retrieves said second file from said repository server in performing said propagate.

12. The computing system of claim 11, wherein said application server is designed to facilitate members of a team to raise respective issues, each issue requiring review by a corresponding manager as a next step,

said application server retrieving issues to be reviewed by a specific manager as said first set of issues, wherein said user is said specific manager.

13. The computing system of claim 12, wherein said application server generates said request after storing said first file in said repository,

said application server specifying an identity of said user and an identity of said first file in said repository as parameters to said request, causing said update server to send said first file to said user.

14. A non-transitory machine readable medium storing one or more sequences of instructions for causing a server system to manage records, wherein execution of said one or more sequences of instructions by one or more processors contained in said server system causes said server system to perform the actions of:

issuing a first structured query directed to a database server to retrieve a set of records of interest, wherein said query specifies a condition and wherein each of said set of records satisfies said condition, wherein said set of records includes a first record containing a first column set to a first data value in said database server;

forming a first file by incorporating into said first file, said set of records retrieved from said database server, wherein each of said set of records, including said first record with said first data value, is incorporated into said first file after being retrieved from said database server;

sending said first file, containing said set of records, by email to a user;

receiving a second file, with at least one of said set of records modified, by email from said user, wherein said second file indicates a second data value for said first column of said first record,

wherein said second file contains a respective additional field for each of said set of records, wherein the additional field indicates whether the corresponding record has been modified or not, wherein the additional field for said first record indicates that said first record has been modified;

parsing said second file to determine the specific records of said set of records which are indicated by the respective additional fields as having been modified; and

propagating the modifications contained in said second file to said database server, upon receipt of said second file, wherein said propagating comprises one or more instructions for issuing a second structured query directed to said database server to update said at least one of said set of records,

wherein said second structured query is designed to update only said specific records in said database server,

wherein said first data value for said first column is replaced by said second data value in said database server due to execution of said second structured query in said database server.

15. The non-transitory machine readable medium of claim 14, wherein said first file is sent as a corresponding attachment to said email sent to said user, and said second file with modifications is received as a corresponding attachment to said email received from said user.

16. The non-transitory machine readable medium of claim 14, wherein each of said first structured query and said second structured query is according to SQL (structured query language),

said database server containing a plurality of tables, each table containing a plurality of rows,

each of said plurality of records being stored as a respective row of a corresponding table,

said first structured query according to said SQL specifying said condition such that the rows of data satisfying said condition constitute said set of records of interest retrieved from said database server,

said second structured query according to said SQL causing update of a row storing said at least one of said set of records.

17. The non-transitory machine readable medium of claim 16, the actions further comprising:

maintaining, a process definition containing a set of tasks, wherein said set of tasks include interfacing with said user, and said propagating; and

receiving a request to execute said process definition, said request specifying said first file and said user as parameters such that said first file is sent to said user by email.

18. The non-transitory machine readable medium of claim 17, wherein a process manager executes said process definition in response to receiving of said request,

said process manager being contained in a SOA (Service Oriented Architecture) server and said process definition being specified according to Business Process Execution Language (BPEL),

said process manager invoking a human workflow block to perform said sending and said receiving.

19. The non-transitory machine readable medium of claim 18, wherein said plurality of records correspond to issues raised by members of a team, and wherein said condition comprises specifying a manager who is to process the issues as a next step, said user comprising said manager such that said first file contains only issues that are to be processed by said manager,

wherein said issuing, said forming and sending of said first file are performed periodically,

said set of records being provided as respective rows in said first file and each row containing a set of columns, wherein said modifications comprise changes made by said manager to data in said set of records in said second file, and

wherein modifications performed to said first file are propagated to said database server by execution of said process definition.