System and Method for Accessing a Database Including Data Abstraction Layer and Request Table Processing

• US 20120179711A1
• Filed: 01/06/2012
• Published: 07/12/2012
• Est. Priority Date: 01/06/2011
• Status: Abandoned Application

• Current Assignee: NorthgateArinso, Inc. (Alight, Inc.)
• Original Assignee: NorthgateArinso, Inc. (Alight, Inc.)
• Inventors: Delafortrie, Eric, Mostien, Ivan, Colman, Eefje, Quix, Luc
• Application Number:
  US13/345,658
• Publication Number:
  US 20120179711A1
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06F 16/2315 Optimistic concurrency control
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema

Abstract

A method for processing changes to a database, the method including: receiving a request to alter data stored in the database, the request including data being entered in one or more steps wherein each of the steps displays one or more data fields associated with the step; generating a plurality of records based on the received request, wherein the records reflect a particular grouping of the data fields configured to abstract a data model used by the database; temporarily storing the plurality of records in a table; determining whether the request should be processed to alter the data stored in the database; and in response to the determination, modifying the data stored in the database in accordance with the plurality of records stored in the table.

Claims

1. A method for processing changes to a database, the method comprising:

receiving a request to alter data stored in the database, the request including data being entered in one or more steps wherein each of the steps displays one or more data fields associated with the step;

generating a plurality of records based on the received request, wherein the records reflect a particular grouping of the data fields configured to abstract a data model used by the database;

temporarily storing the plurality of records in a table;

determining whether the request should be processed to alter the data stored in the database; and

in response to the determination, modifying the data stored in the database in accordance with the plurality of records stored in the table.

2. The method of claim 1, wherein the data fields are grouped into a data set, the data fields of the data set corresponding to data fields in one or more data structures in the database.

3. The method of claim 2, wherein the generating the plurality of records includes generating a field record for each of the data fields in the data set.

4. The method of claim 3, wherein the request is identified by a request ID, and each field record includes the request ID of the corresponding request.

5. The method of claim 2, wherein the generating the plurality of records includes generating a data structure record for each of the one or more data structures in the database including a data field corresponding to the data field in the data set.

6. The method of claim 5, wherein the data structure record identifies the data structure in the database affected by the received request.

7. The method of claim 1, wherein the generating the plurality of records includes generating a log record identifying a user action with respect to the received request.

8. The method of claim 1, wherein each step displays the one or more of the data fields associated with the step, on a single screen.

9. A database system comprising:

a user interface system;

a process integration layer;

a temporary database; and

a working database, the process integration layer being configured to;

receive a request to alter data stored in the working database via the user interface system, the request including data being entered in one or more steps wherein the user interface system is configured to display, in each of the steps, one or more data fields associated with the step;

generate a plurality of records based on the received data, wherein the records reflect a particular grouping of the data fields configured to abstract a data model used by the working database;

temporarily store the plurality of records in the temporary database;

determine whether the received data should be processed to alter the data stored in the working database; and

in response to the determination, modify the data stored in the working database in accordance with the plurality of records stored in the temporary database.

10. The system of claim 9, wherein the user interface system is a web-based user interface.

11. The system of claim 9, wherein the temporary database and the working database are tables within a single database system.

12. The system of claim 9, wherein the data fields are grouped into a data set, the data fields of the data set corresponding to data fields in one or more data structures in the database.

13. The system of claim 12, wherein the data fields are grouped into a data set, the data fields of the data set corresponding to data fields in one or more data structures in the database.

14. The system of claim 13, wherein the request is identified by a request ID, and each field record includes the request ID of the corresponding request.

15. The system of claim 12, wherein the process integration layer is configured to generate the plurality of records by generating a data structure record for each of the one or more data structures in the database including a data field corresponding to the data field in the data set.

16. The system of claim 15, wherein the data structure record identifies the data structure in the affected by the received data.

17. The system of claim 9, wherein the process integration layer is configured to generate a log record identifying a user action with respect to the received data.

18. The system of claim 9, wherein the user interface is configured to display the one or more of the data fields associated with the step, on a single screen.

19. A method for managing a database system, the method comprising:

receiving a user request for effectuating a change in a working database, the working database including a plurality of data structures having a plurality of data fields, wherein the plurality of data fields are grouped into a data set linked to a user input step;

identifying the user input step based on the request;

displaying each of the data fields of the data set during the user input step for prompting input of data associated with one or more of the data fields;

generating a plurality of records based on the data input during the input step;

temporarily storing the plurality of records in a table;

determining whether the change in the working database should be effectuated; and

in response to the determination, effectuating the change in the working database in accordance with the plurality of records stored in the table.

20. The method of claim 19, wherein the data fields of the data set are displayed during the user input step on a single screen.