Method, system, and program for executing a query having a union all operator and data modifying operations
First Claim
1. A method of directing a data processing system to execute a query against a data object, the query having a union all operator and having a set of data modifying operators, the set of data modifying operators being associated with the union all operator, the union all operator referencing the data object, the method comprising:
- determining whether a data modification operation is being requested by the query;
if no data modification operation is being requested, terminating operations of said method;
if the data modification operation is being requested, determining whether the data modification operation operates upon a data object involving one of an Updateable union all operator, Deleteable union all operator and Insertable union all operator;
if it is determined that said data modification operation does not operate upon the data object involving said one of the Updateable union all operator, Deleteable union all operator, and Insertable union all operator, terminating operations of said method;
if it is determined that the data modification operation operates upon the data object involving said one of the Updateable union all operator, Deleteable union all operator, and Insertable union all operator;
preventing the union all operator from being applied to the data object; and
applying the set of data modifying operators against the data object,wherein the applying comprises;
analyzing every selected update operator and every selected delete operator to determine if the source for the selected update operator and the selected delete operator comes from the data objects referenced by the UNION ALL operator,wherein the analyzing comprises;
comparing an identifier added to each source row to ensure that each data object referenced by the union all operator only contains a single identifier; and
comparing a condition in a selected data modifying operator with the identifier for all rows from particular data modifying operators referenced by the union all operator to ensure that only a single data object is the source for the selected data modifying operator.
1 Assignment
0 Petitions
Accused Products
Abstract
Disclosed is a data processing system, a data processing system implemented method and an article of manufacture for executing a query having a union all operator. The data processing system implemented method directs the data processing system to execute a query against a data object. The query has a union all operator and has a set of data modifying operators. The set of data modifying operators is associated with the union all operator. The union all operator references the data object. The data processing system implemented method includes preventing the union all operator from being applied to the data object, and applying the set of data modifying operators against the data object.
-
Citations
14 Claims
-
1. A method of directing a data processing system to execute a query against a data object, the query having a union all operator and having a set of data modifying operators, the set of data modifying operators being associated with the union all operator, the union all operator referencing the data object, the method comprising:
-
determining whether a data modification operation is being requested by the query; if no data modification operation is being requested, terminating operations of said method; if the data modification operation is being requested, determining whether the data modification operation operates upon a data object involving one of an Updateable union all operator, Deleteable union all operator and Insertable union all operator; if it is determined that said data modification operation does not operate upon the data object involving said one of the Updateable union all operator, Deleteable union all operator, and Insertable union all operator, terminating operations of said method; if it is determined that the data modification operation operates upon the data object involving said one of the Updateable union all operator, Deleteable union all operator, and Insertable union all operator; preventing the union all operator from being applied to the data object; and applying the set of data modifying operators against the data object, wherein the applying comprises; analyzing every selected update operator and every selected delete operator to determine if the source for the selected update operator and the selected delete operator comes from the data objects referenced by the UNION ALL operator, wherein the analyzing comprises; comparing an identifier added to each source row to ensure that each data object referenced by the union all operator only contains a single identifier; and comparing a condition in a selected data modifying operator with the identifier for all rows from particular data modifying operators referenced by the union all operator to ensure that only a single data object is the source for the selected data modifying operator. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. An article of manufacture for directing a data processing system to execute a query against a data object, the query having a union all operator and having a set of data modifying operators, the set of data modifying operators being associated with the union all operator, the union all operator referencing the data object, the article of manufacture comprising:
-
a usable memory medium embodying one or more instructions executable by the data processing system, the one or more instructions comprising; data processing system executable instructions for preventing the union all operator from being applied to the data object; and data processing system executable instructions for applying the set of data modifying operators against the data object, wherein a determination is made whether a data modification operation is being requested by the query; wherein if no data modification operation is being requested, terminating operations related to executing said query against said data object, wherein if the data modification operation is being requested, a determination is made whether the data modification operation operates upon a data object involving one of an Updateable union all operator, Deleteable union all operator and Insertable union all operator, wherein if it is determined that said data modification operation does not operate upon the data object involving said one of the Updateable union all operator, Deleteable union all operator, and Insertable union all operator, operations related to executing said query against said data object are terminated, wherein if it is determined that the data modification operation operates upon the data object involving said one of the Updateable union all operator, Deleteable union all operator, and Insertable union all operator; the union all operator is prevented from being applied to the data object; and the set of data modifying operators are applied against the data object, wherein the applying comprises; analyzing every selected update operator and every selected delete operator to determine if the source for the selected update operator and the selected delete operator comes from the data objects referenced by the UNION ALL operator, wherein the analyzing comprises; comparing an identifier added to each source row to ensure that each data object referenced by the union all operator only contains a single identifier; and comparing a condition in a selected data modifying operator with the identifier for all rows from particular data modifying operators referenced by the union all operator to ensure that only a single data object is the source for the selected data modifying operator. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
Specification