NETWORK COMMUNICATION STACK FOR DATABASE CONTROL AND RESOURCE PLANNING

• US 20180053007A1
• Filed: 10/17/2016
• Published: 02/22/2018
• Est. Priority Date: 08/22/2016
• Status: Active Grant

• Current Assignee: Accenture Global Solutions Limited (Accenture PLC)
• Original Assignee: Accenture Global Solutions Limited (Accenture PLC)
• Inventors: Alexander, Simon, Kollannur Sebastian, Paul Bendix, Kurian, Joy
• Granted Patent: US 11,144,653 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 21/604 Tools and structures for managing or administering access control systems
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: G06F 2221/2125 Just-in-time application of countermeasures, e.g., on-the-fly decryption, just-in-time obfuscation or de-obfuscation
• CPC Class Codes: H04L 63/08 for authentication of entities cryptographic mechanisms or cryptographic arrangements for entity authentication H04L9/32
• CPC Class Codes: H04L 63/102 Entity profiles
• CPC Class Codes: H04L 67/141 Setup of application sessions admission control or resource allocation in data switching networks H04L47/70

Abstract

A network communication stack running on relational processing circuitry performs control and maintenance actions on records from a database server managed by repository control circuitry. The database interaction layer of the communication stack accesses the records on the database server. The database interaction layer passes the accessed records to the data processing layer for parsing and storage as tabular entries. An operator may perform manipulations on the tabular entries using a command interface generated by the command layer of the communication stack using locally-defined interface parameters that are independent of characteristics of the database server. The data processing layer recompiles manipulated entries into an altered record. The database interaction layer sends the altered record back to the database server.

Claims

1. A method comprising:

requesting establishment of a communication link between repository control circuitry and relational processing circuitry, the repository control circuitry in communication with a database server, where requesting includes;

transmitting, from a database interaction layer of a communication service stack executing on the relational processing circuitry, a security credential identifying the relational processing circuitry with a management account with access privileges for the database server; and

receiving an indication of authorization to access the database server from the repository control circuitry;

after the communication link is established, accessing, via the database interaction layer, an incoming record stored on the database server via the repository control circuitry;

passing the incoming record from the database interaction layer to a data processing layer of the communication service stack executing on the relational processing circuitry;

at the data processing layer, parsing the record into a tabular entry;

at a command layer of the communication service stack executing on the relational processing circuitry;

accessing a locally-defined interface parameter, the locally-defined interface parameter selected independently of a characteristic of the database server;

responsive to the locally-defined interface parameter, generating a user interface display on a terminal, the user interface display including a field configured in accord with the locally-defined interface parameter;

populating the field using accessed content from the tabular entry; and

receiving a request to alter the tabular entry via input to the field;

after altering the tabular entry, recompiling, at the data processing layer, the tabular entry into an outgoing record; and

sending the outgoing record to the database interaction layer for provision to the database server to replace the incoming record on the database server.

2. The method of claim 1, where requesting establishment of the communication link further comprises accessing a stored connection profile for the repository control circuitry.

3. The method of claim 2, where the stored connection profile includes the security credential.

4. The method of claim 2, where requesting establishment of the communication link further comprises selecting, responsive to the stored connection profile, a link type from among at least batch record exchange, direct record manipulation, and client access emulation.

5. The method of claim 4, where the stored connection profile includes a batch record exchange schedule to support batch record exchange.

6. The method of claim 1, further comprising accessing a cloud deployment manifest that defines operation of the communication service stack.

7. The method of claim 6, responsive to the cloud deployment manifest, deploying the communication service stack on the relational processing circuitry before requesting establishment of the communication link.

8. The method of claim 1, where parsing the record to generate the tabular entry comprises parsing the record in accord with a data model for a record type of the record.

9. A product comprising:

a machine-readable medium other than a transitory signal; and

instructions stored on the machine-readable medium, the instructions, when executed, configured to cause a processor to;

request establishment of a communication link between repository control circuitry and relational processing circuitry, the repository control circuitry in communication with a database server, by;

at a database interaction layer of a communication service stack configured to execute on the relational processing circuitry, access a stored connection profile for the repository control circuitry;

responsive to the stored connection profile, select a link type from among at least batch record exchange, direct record manipulation, and client access emulation;

transmitting, from the database interaction layer, a security credential that affords the relational processing circuitry access privileges to the database server in accord with the link type; and

receiving an indication of authorization to establish the communication link in accord with the link type;

after the communication link is established, access, via the database interaction layer an incoming record for a transaction stored on the database server via the repository control circuitry;

pass the incoming record from the database interaction layer to a data processing layer of the communication service stack configured to execute on the relational processing circuitry;

at the data processing layer parse the incoming record to generate a first tabular entry; and

at a command layer of the communication service stack configured to execute on the relational processing circuitry;

access a locally-defined interface parameter, the locally-defined interface parameter selected independently of a characteristic of the database server;

responsive to the locally-defined interface parameter, generate a user interface display on a terminal, the user interface display including a field positioned in accord with the locally-defined interface parameter;

receive a request to generate a second tabular entry via input to the field;

determine that the second tabular entry is related to the transaction;

after generating the second tabular entry, validate the second tabular entry against the first tabular entry;

compile, at the data processing layer, the first and second tabular entries into an outgoing record; and

send the outgoing record to the database interaction layer for provision to the database server to replace the incoming record for the transaction.

10. The product of claim 9, where the instructions are further configured to cause the relational processing circuitry to validate the second tabular entry against the first tabular entry responsive to an execution authorization request for the transaction.

11. The product of claim 9, where the instructions are further configured to cause the relational processing circuitry to mark the outgoing record as resolved after validating the second tabular entry against the first tabular entry.

12. The product of claim 9, where the stored connection profile includes the security credential.

13. The product of claim 12, where the stored connection profile includes a batch record exchange schedule to support batch record exchange.

14. The product of claim 9, where the instructions are further configured to cause the relational processing circuitry to parse the record to generate the first tabular entry by parsing the record in accord with a data model for a record type of the record.

15. A system comprising:

network interface circuitry configured to;

request establishment of a communication link between repository control circuitry and relational processing circuitry, the repository control circuitry in communication with a database server, by;

transmitting, from a database interaction layer of a communication service stack, a security credential identifying the relational processing circuitry with a management account with access privileges for the database server; and

receiving an indication of authorization to access the database server from the repository control circuitry; and

after the communication link is established;

receive, via the communication link, an incoming record stored on the database server via the repository control circuitry; and

transmit, from the database interaction layer, an outgoing record to the database server to replace the incoming record on the database server;

relational processing circuitry in data communication with the network interface circuitry, the relational processing circuitry configured to;

pass the incoming record from the database interaction layer to a data processing layer of the communication service stack;

at the data processing layer, parse the record into a tabular entry;

at a command layer of the communication service stack;

access a locally-defined interface parameter, the locally-defined interface parameter selected independently of characteristics of the database server;

responsive to the locally-defined interface parameter, generate a user interface display on a terminal, the user interface display including a field positioned in accord with the locally-defined interface parameter;

populate the field using accessed content from the tabular entry; and

receive a request to alter the tabular entry via input to the field; and

after altering the tabular entry, recompile, at the data processing layer, the tabular entry into the outgoing record.

16. The system of claim 15, where the network interface circuitry is configured to request establishment of the communication link by accessing a stored connection profile for the repository control circuitry.

17. The system of claim 16, where the stored connection profile includes the security credential.

18. The system of claim 16, where the network interface circuitry is configured to request establishment of the communication link by selecting, responsive to the stored connection profile, a link type from among at least batch record exchange, direct record manipulation, and client access emulation.

19. The system of claim 18, where the stored connection profile includes a batch record exchange schedule to support batch record exchange.

20. The system of claim 15, where the network interface circuitry is configured to parse the record to generate the tabular entry by parsing the record in accord with a data model for a record type of the record.