Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: A method of aggregating changes in an order status database system teaching the method steps of identifying the order and the order status, where the order status includes an insert timestamp and an update timestamp; identifying individual line items (products) that together form the order, each line item identifying the quantity requested, quantity shipped, and status shipped, with individual insert timestamps and update timestamps; and updating the order and line item insert and update timestamps whenever a line item is updated.

Abstract: System, method and program 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.

Abstract: A method and system 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.

Abstract: 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.

Abstract: 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.