US 2007/0192304 A1 · Method and System for an Operation Capable of Updating and Inserting Information in a Database

Abstract

A Structured Query Language (SQL) adapter business service that converts data from a data set to a common representation format used for all data sets with which the SQL adapter business service interacts. Hence the SQL adapter business service can communicate with various internal and external systems independently of the native format in which those systems maintain and store data. The SQL adapter business service optimizes operations to update data in the data sets by combining operations when possible and by using result sets from executing previous SQL statements to construct subsequent SQL statements. SQL adapter business service takes advantage of parent/child relationships between tables to construct SQL statements in an order such that the SQL statements process only a minimum amount of data, thereby making retrieval of data as efficient as possible.

Claims30

Dependent claims

1-115. (canceled)

A method comprising:

selecting a set of instances from a set of data;
determining a number of related records in a set of related records of a table, wherein
each record of the set of related records is related to one instance of the set of instances;
comparing the number of related records and a number of instances in the set of instances prior to generating a set of select statements to select the set of related records from the table;
and
if the comparing indicates that the number of instances is greater than the number of related records,
generating the set of select statements to comprise one select statement to select the set of related records from the table, wherein
the one select statement includes a clause to select a corresponding record for each instance of a set comprising a maximum number of instances of the set of instances,
the maximum number of instances is determined by a maximum number of clauses in the one select statement, and
the one select statement is configured to
cause an update operation to be performed on a record in the table, if the record already exists in the table, and
cause an insert operation to be performed to insert the record in the table, if the record does not already exist in the table.

9 more elements

A system comprising:

selecting means for selecting a set of instances from a set of data;
determining means for determining a number of related records in a set of related records of a table, wherein
each record of the set of related records is related to one instance of the set of instances;
comparing means for comparing the number of related records and a number of instances in the set of instances prior to generating a set of select statements to select the set of related records from the table;
and
generating means for generating the set of select statements to comprise one select statement to select the set of related records from the table if the comparing indicates that the number of instances is greater than the number of related records, wherein
the one select statement includes a clause to select a corresponding record for each instance of a set comprising a maximum number of instances of the set of instances,
the maximum number of instances is determined by a maximum number of clauses in the one select statement, and
the one select statement is configured to
cause an update operation to be performed on a record in the table, if the record already exists in the table, and
cause an insert operation to be performed to insert the record in the table, if the record does not already exist in the table.

8 more elements

A computer-readable medium comprising:

selecting instructions configured to select a set of instances from a set of data;
determining instructions configured to determine a number of related records in a set of related records of a table, wherein
each record of the set of related records is related to one instance of the set of instances;
comparing instructions configured to compare the number of related records and a number of instances in the set of instances prior to generating a set of select statements to select the set of related records from the table;
and
generating instructions configured to generate the set of select statements to comprise one select statement to select the set of related records from the table if the comparing indicates that the number of instances is greater than the number of related records, wherein
the one select statement includes a clause to select a corresponding record for each instance of a set comprising a maximum number of instances of the set of instances,
the maximum number of instances is determined by a maximum number of clauses in the one select statement, and
the one select statement is configured to
cause an update operation to be performed on a record in the table, if the record already exists in the table, and
cause an insert operation to be performed to insert the record in the table, if the record does not already exist in the table.

8 more elements

A computer system comprising:

a processor to execute instructions;
and
a memory to store the instructions, wherein
the memory is coupled to the processor, and
the instructions comprise:
selecting instructions configured to select a set of instances from a set of data;
determining instructions configured to determine a number of related records in a set of related records of a table, wherein
each record of the set of related records is related to one instance of the set of instances;
comparing instructions configured to compare the number of related records and a number of instances in the set of instances prior to generating a set of select statements to select the set of related records from the table;
and
generating instructions configured to generate the set of select statements to include one select statement to select the set of related records from the table if the comparing indicates that the number of instances is greater than the number of related records, wherein
the one select statement includes a clause to select a corresponding record for each instance of a set comprising a maximum number of instances of the set of instances,
the maximum number of instances is determined by a maximum number of clauses in the one select statement, and
the one select statement is configured to
cause an update operation to be performed on a record in the tables if the record already exists in the table, and
cause an insert operation to be performed to insert the record in the table, if the record does not already exist in the table.

13 more elements

A system comprising:

a selecting module configured to select a set of instances from a set of data;
a determining module configured to determine a number of related records in a set of related records of a table, wherein
each record of the set of related records is related to one instance of the set of instances;
a comparing module configured to compare the number of related records and a number of instances in the set of instances prior to generating a set of select statements to select the set of related records from the table;
and
a generating module configured to generate the set of select statements to comprise one select statement to select the set of related records from the table if the comparing indicates that the number of instances is greater than the number of related records, wherein
the one select statement includes a clause to select a corresponding record for each instance of a set comprising a maximum number of instances of the set of instances,
the maximum number of instances is determined by a maximum number of clauses in the one select statement, and
the one select statement is configured to
cause an update operation to be performed on a record in the table, if the record already exists in the table, and
cause an insert operation to be performed to insert the record in the table, if the record does not already exist in the table.

8 more elements

Dependencies are inferred from the claim text.

Method and System for an Operation Capable of Updating and Inserting Information in a Database

Life of this patent

Method and System for an Operation Capable of Updating and Inserting Information in a Database

Life of this patent

Abstract

Claims30