System and method for translating and executing update requests
First Claim
Patent Images
1. A method for executing a data operation request in a business system, comprising:
- receiving, from a frontend application, a data operation request for an operation to be performed by at least one of a plurality of backend applications, the data operation request specifying a business object, a node in the business object, and a data operation to be performed on data related to the business object node, the data operation request defined in a structured query language as a first query;
extracting identifiers corresponding to the business object, the node within the business object, and the specific data operation to be performed from the first query;
translating for any one of the plurality of backend applications the extracted information into a native command, the native command defined in a format native to the identified business object and the identified node, wherein the identified business object indicates to which one of a plurality of backend applications the native command is to be sent, wherein the translating comprises;
creating a virtual table, each row of the virtual table listing the business object, the business object node, and an assignment of a value to an attribute of the business object node; and
for each row in the virtual table, mapping the entries in the row to parameters expected by a backend application;
sending the native command to the identified backend application containing the business object;
performing the data operation on the data related to the specified business object node contained in the at least one of the plurality of backend applications;
receiving an indication from the identified backend application that processing of the command completed, wherein the indication is in a format native to the backend application;
transforming the format of the received indication into a format expected by the frontend application; and
presenting the transformed indication to the frontend application.
2 Assignments
0 Petitions
Accused Products
Abstract
Methods and systems for converting standardized, structured update requests into native business object commands are provided. The structured update requests may be defined in a business object-specific structured query language (BQL). A BQL engine may translate the structured update request into a command formatted for use by the appropriate business object or a programming interface in communication with the business object.
-
Citations
22 Claims
-
1. A method for executing a data operation request in a business system, comprising:
-
receiving, from a frontend application, a data operation request for an operation to be performed by at least one of a plurality of backend applications, the data operation request specifying a business object, a node in the business object, and a data operation to be performed on data related to the business object node, the data operation request defined in a structured query language as a first query; extracting identifiers corresponding to the business object, the node within the business object, and the specific data operation to be performed from the first query; translating for any one of the plurality of backend applications the extracted information into a native command, the native command defined in a format native to the identified business object and the identified node, wherein the identified business object indicates to which one of a plurality of backend applications the native command is to be sent, wherein the translating comprises; creating a virtual table, each row of the virtual table listing the business object, the business object node, and an assignment of a value to an attribute of the business object node; and for each row in the virtual table, mapping the entries in the row to parameters expected by a backend application; sending the native command to the identified backend application containing the business object; performing the data operation on the data related to the specified business object node contained in the at least one of the plurality of backend applications; receiving an indication from the identified backend application that processing of the command completed, wherein the indication is in a format native to the backend application; transforming the format of the received indication into a format expected by the frontend application; and presenting the transformed indication to the frontend application. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 21)
-
-
9. A computer system, comprising:
-
an input device to receive a structured language query related to a data operation request; a processor configured to; extract identifiers corresponding to a business object, a business object node, and a data operation to be performed on data related to the business object node referenced by the structured language query;
using the extracted identifiers to indicate a backend application that contains the business object and business object node from a plurality of backend applications;translate for the indicated backend application the extracted identifiers related to the business object, the business object node, and the data operation into a native command, the native command specifying the business object, the business object node, and the data operation to be performed in a language native to the backend application, wherein the translating comprises create a virtual table, each row of the virtual table listing the business object, the business object node, and an assignment of a value to an attribute of the business object node; and for each row in the virtual table, map the entries in the row to parameters expected by a backend application; and an output to send the native command to the backend application. - View Dependent Claims (10, 11, 12)
-
-
13. A computer-readable storage medium storing instructions which, when executed by a processor, cause the processor to perform a method comprising:
-
receiving a data operation request for an operation to be performed by at least one of a plurality of backend applications, the data operation request specifying a business object, a node in the business object, and a data operation to be performed on data related to the business object node, the data operation request defined in a structured query language as a first query; extracting identifiers corresponding to the business object, the node within the business object, and the specific data operation to be performed from the first query; translating for any one of the plurality of backend applications the extracted information into a native command, the native command defined in a format native to the identified business object and the identified node, wherein the identified business object indicates to which one of a plurality of backend applications the native command is to be sent, wherein the translating comprises; creating a virtual table, each row of the virtual table listing the business object, the business object node, and an assignment of a value to an attribute of the business object node; and for each row in the virtual table, mapping the entries in the row to parameters expected by a backend application; sending the native command to the identified backend application contained in the business object; performing the data operation on the data related to the specified business object node in the at least one of the plurality of backend applications; receiving an indication from the identified backend application that processing of the command completed, wherein the indication is in a format native to the backend application; transforming the format of the received indication into a format expected by the frontend application; and presenting the transformed indication to the frontend application. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 22)
-
Specification