International Business Machines Corporation

Kyndryl, Inc.

Charles Matula

Andrea C Martinez

David Henry Starke

Roy Froehlich

Thomas A Jobson, Jr

Edith A Kanyock

Arnold M Rosenberg

Gregory R Wiley

Gregory Richard Edward Wiley

Howard S Bloom

Karen Cheng

Gregory R E Wiley

Marshall Todd Jarman

Dallas L Johnson

A method, computer program product, and system includes a processor(s) executing a new instruction in place of a left outer join instruction to generate a data set, where the left outer join instruction includes at least two tables and an indication of a column in each the tables to join on. Executing the new instruction includes the processor(s) creating a temporary table including all columns of the at least two tables, where values in fields of the temporary table are null values, executing an inner join instruction, the inner join instruction includes the indication of the column in each of the at least two tables to join on, to create a preliminary results set, and generating the data set, wherein the generating includes the processor(s) overlaying the preliminary results set on the temporary table to update a portion of the null values with values from the preliminary results set.

Increasing database performance through query aggregation

Methods, systems and apparatus for implementing behavior of a user defined type (UDT) in a database by providing a data table with multiple rows and generating a UDT table having only a single row. An instance of a UDT is created and stored in the single row of the UDT table. A query having a Cartesian product is implemented to join the UDT table and data table for invoking behavior of the UDT and generating a resultant data table without increasing cardinality thereof. The single instance of the UDT may be shared amongst several users of the database as a result of all required persisted objects of the UDT residing within only a single row of the UDT table.

Sharing a single instance of a user defined type

A computer implemented system and method enables an application that only has the ability to request Structured Query Language (SQL) database read to effect a write to a SQL database is disclosed.

Write instruction datasource for database write procedure

A method and system for rewriting Structured Query Language (SQL) statements. A SQL statement having search criteria including conditions pertaining to fields in database tables is received. A table from the SQL statement listing all combinations of the search criteria is created, every combination reflecting a subset of information used to determine combined results. A set of patterns among the possible combinations of the SQL statement based on the fields referenced in the combinations is identified. The table based on the set of patterns is sorted. Based on the sorting, the table is divided into temporary tables which are joined with the SQL statement. New temporary tables are generated. Each new temporary table includes results of a search conducted using a separate portion of the SQL statement as joined with the set of temporary tables. All results from the new temporary tables are combined into a single result table.

Method, system and program product for rewriting structured query language (SQL) statements

A computer implemented system and method for enabling a database write operation for an application that only has a database read operation is disclosed. At least one data source is stored in a database, the data source having at least one pre-coded stored write operation. A database read operation that calls the data source is received. The read operation is performed on the database, the read operation causing the database to execute the pre-coded stored write operation on the database.

Under the present invention, a SQL statement having search criteria is received. Upon receipt, a table that lists all possible combinations of the search criteria is created. From the table, a set of patterns among the possible combinations is identified. Based on these patterns, the table is then sorted. Once sorted, the table is divided into a set of temporary tables based on the set of patterns/sorting operation. The set of temporary tables are then individually joined with the SQL statement and separate searches are conducted. A new set of temporary tables is then generated and populated with results of the separate searches. These result tables are then unioned/combined into a single result table.

System, method and program product for generating a trigger program that updates an entry in a dependent column in a table in response to a request to update a corresponding entry in a parent column in the table. A trigger program template is provided. The trigger program template includes program steps which indicate a type of update to an entry in an unspecified parent column which triggers an update to a corresponding entry in an unspecified dependent column. The trigger program template also indicates a type of the unspecified dependent column to update upon the update to the entry in the unspecified parent column. The table is automatically scanned to identify one or more dependent columns of the type. In response to identification of the one or more dependent columns of the type, a name of a parent column, corresponding to the one or more dependent columns, is inserted in the trigger program template steps to identify the corresponding parent column as the unspecified parent column and identify the one or more dependent columns as the unspecified dependent columns. Names of the one or more dependent columns comprise the name of the specified parent column and respective suffixes indicating the types of the dependent columns.

System, method and program product for generating triggers for a relational database

Under the present invention, when a SQL statement having a full select portion that references a view containing a join operation (e.g., a LOJ operation) is received, the reference to the view will be moved out of the full select portion. Once moved, the view and its join operation will be resolved separately from the SQL statement. The results of this resolution will be placed in a temporary table. A reference to the temporary table is then inserted in the full select portion, and the SQL statement is thereafter performed.

Method, system and program product for rewriting view statements in structured query language (SQL) statements

A system and program product for detecting granular data store changes in a computing environment. Data values stored in a first relational database are changed. Each data value is stored in a row and a column of the first relational database. Rows (i.e., changed rows) including the changed data values are identified. Changed rows are propagated to a second relational database. Columns including the changed data values are identified in the second relational database. The types of changes associated with the changed data values are identified. Filters optionally filter out one or more of the changed data values from further processing. At least one data value of the changed data values, along with their types of changes, are transformed into a language neutral format included in packaged data to be sent in response to a client requesting the at least one data value.

Detecting granular data store changes

A method for detecting granular data store changes in a computing environment. Data values stored in a first relational database are changed. Each data value is stored in a row and a column of the first relational database. Rows (i.e., changed rows) including the changed data values are identified. Changed rows are propagated to a second relational database. Columns including the changed data values are identified in the second relational database. The types of changes associated with the changed data values are identified. Filters optionally filter out one or more of the changed data values from further processing. At least one data value of the changed data values, along with their types of changes, are transformed into a language neutral format included in packaged data to be sent in response to a client requesting the at least one data value.

Growing community of inventors

Poughkeepsie, NY, United States of America

Charles Matula