Patent application number | Description | Published |
20080288501 | Integrating Database Functionality with Workload Schedulers - A relational database trigger that accesses a distributed database table is initially created. This relational database trigger is defined prior to executing a first set of instructions, which are designed to be executed by a local first computer. The first set of instructions is executed until the relational database trigger is encountered, which causes a distributed database table to be accessed. Using information from the distributed database table, a dummy file is transmitted to a remote second computer. In response to the remote second computer receiving the dummy file, a scheduler searches the specific file location on the remote second computer for the dummy file. If the scheduler detects the dummy file at the specific file location, the remote second computer initiates execution of the second set of instructions. | 11-20-2008 |
20080319998 | SYSTEM AND METHOD FOR DYNAMIC AUTHORIZATION TO DATABASE OBJECTS - The present invention provides a system and method allows a user to add a parameter at the end of the GRANT statement that would not require multiple changes by the DBA. The parameter may indicate that the user only needs to have access for 2 days, or to have access when a flag is set in the database. This reduces the frequency that a DBA needs to be engaged and decreases the cycle time that is necessary to turn the request around. An additional benefit is that the authority is removed when it should be. This then also improves the business controls around the data. | 12-25-2008 |
20090049022 | Swapping Multiple Object Aliases in a Database System - A novel Structure Query Language (SQL) command globally swaps multiple alias names for multiple objects in a database management system. | 02-19-2009 |
20130110881 | SINGLE COMMAND DATA WAREHOUSE TABLE UPDATE | 05-02-2013 |
20130246340 | SINGLE COMMAND DATA WAREHOUSE TABLE UPDATE - Information warehouse table data is updated through a full outer join between warehouse tables and source tables in response to a single query language command statement of a relational database computer language. The single command statement comprises table mapping instructions for updating the warehouse tables that define matching conditions, delete instructions, archive instructions, and update instructions. The full outer join inserts rows in the warehouse tables for source table data rows that do not have corresponding matching rows in the warehouse table. Data rows in the warehouse tables without corresponding matching source table rows are deleted if a value of a parameter in the warehouse table system is set to delete; updated if the parameter is update; and updated with archive values and a new table row inserted with existing values if the parameter is archive. | 09-19-2013 |
20150227561 | MANAGING DATABASE CLUSTERING INDICES - A computer manages entries into a clustered index. The computer handles one or more commands, wherein each command loads a dataset into a database. The computer queries a database system catalog of the database for a target index, wherein the database system catalog contains a list of indices of the dataset in the form of metadata. The computer disables a parallel loading process for the dataset. The computer loads the dataset into the target index, wherein the dataset is sorted according to the target index. | 08-13-2015 |
20150242476 | UPDATING DATABASE STATISTICS WITH DYNAMIC PROFILES - Embodiments of the present invention disclose a method, computer program product, and system for updating database statistics using profiles. A computer determines whether an application credential has authority to update a database statistic of a target database, based, at least in part, on a profile. Responsive to determining that the application credential has authority to update the database statistic, the computer loads the transformed data into the target database. The computer determines whether an update to the statistic is to be performed. Responsive to a determination that the update to the statistic is to be performed, the computer generates a profile name. The computer determines whether the generated profile name exists within a system catalog of the target database. Responsive to a determination that the generated profile name exists, the computer transmits a command to update the database statistic of the target database using the generated profile name. | 08-27-2015 |
20150295878 | NOTIFICATION OF ELECTRONIC CONVERSATION - A computer system identifies an electronic conversation between a plurality of participants. The computer system identifies the plurality of participants. The computer system determines whether the plurality of participants match a specific list of participants that have been predetermined to be of interest to a user. In response to determining that the plurality of participants engaged in the electronic conversation matches the predetermined list of participants of interest to the user, the computer system notifies the user of the electronic conversation. | 10-15-2015 |