Abstract: Techniques for selective compression of database information are presented. Selective first portions of a field associated with a database table are identified along with metadata associated with the database table. The first portions and the metadata are then compressed by selecting one or more compression algorithms in response to compression capabilities associated with the algorithms.

Abstract: A system, method, and computer-readable medium for automatic and dynamic control of optimizer settings in a large complex system environment are provided. The described mechanisms significantly increase the potential of achieving Service Level Goals for classes of queries where optimizer aggression is needed. Confidence threshold parameters are automatically controlled to facilitate generation of query execution plans to conform with associated Service Level Goals.

Abstract: Techniques for database rule ordering and processing are provided. Structured Query Language (SQL) statements are iterated to identify processing dependencies and a processing order is generated. The SQL statements are automatically modified to enforce the processing order and the modified SQL statements are executed against a database.

Abstract: The frequency with which data is accessed within the system may be periodically monitored and a corresponding access frequency quantifier assigned to the data is updated accordingly. The data access frequency quantifier may be associated with a storage device zone speed quality rating. The association between data access frequency quantifiers and the storage device zone speed quality ratings may be made in a hierarchical association such that quantifiable differentials may be ascertained between a particular access frequency quantifier and a storage device zone speed quality rating. In this manner, when no storage zone having a speed quality rating that is associated with data having a particular access frequency quantifier is available for storage of the data, a storage zone having a speed quality rating more proximate the speed quality rating associated with the access frequency quantifier may be identified for migration.

Abstract: An improved method for forecasting and modeling product demand for a product during promotional periods. The forecasting methodology employs information about prior promotional demand forecasts, prior product sales, and the data dispersion and the number of data samples in a product class hierarchy to dynamically determine the optimal level at which to compute promotional uplift coefficients. The methodology calculates confidence values for promotional uplift coefficients for products at each level in a merchandise product hierarchy, and uses the confidence values as a filter to determine the optimal level for promotional uplift aggregation.

Abstract: A system and method for using failure casting to manage failures in a computer system. In accordance with an embodiment, the system uses a failure casting hierarchy to cast failures of one type into failures of another type. In doing this, the system allows incidents, problems, or failures to be cast into a (typically smaller) set of failures, which the system knows how to handle. In accordance with a particular embodiment, failures can be cast into a category that is considered reboot-curable. If a failure is reboot-curable then rebooting the system will likely cure the problem. Examples include hardware failures, and reboot-specific methods that can be applied to disk failures and to failures within clusters of databases. The system can even be used to handle failures that were hitherto unforeseen—failures can be cast into known failures based on the failure symptoms, rather than any underlying cause.

Abstract: A database system includes database software to receive a query specifying a join of plural base tables, and to determine whether a foreign key and primary key relationship exists between join columns specified by the query and a materialized view definition. Based on the existence of the foreign key and the primary key relationship between join columns specified by the query and the materialized view definition, the database software determines that a result for the received query is to be computed from the materialized view.

Abstract: A system for managing a plurality of systems, includes a domain comprised of a plurality of systems, wherein the systems are managed by one or more closed-loop system management (CLSM) regulators. A virtual regulator manages operational characteristics of the domain and the plurality of systems, by communicating with the CLSM regulators to monitor the systems' states, events and conditions within the domain and to adjust the systems' operational characteristics in response to the systems' states, events and conditions.

Abstract: Techniques for constructing and using run-time JAVA Archive (JAR) files for JAVA Stored Procedures (JSPs) are provided. JSP methods referenced by an application via a plurality of different JAR files are extracted and packed into a single packed JAR file. When the application tries to execute a JSP, the attempt to process the JSP methods is redirected to a new JSP that calls the single packed JAR file.

Abstract: Techniques for collecting statistics of column data or R-Tree indexes are provided. A distributed database system includes a plurality of processing nodes controlling portions of spatial data. The nodes are instructed to create minimum bounding rectangles (MBR's) for their spatial data or R-Trees. The individual MBR's are merged and reformatted into a grid of equally sized cells. Each processing node is provided a copy of the grid to update based on statistics of each processing node's spatial data for a target table. The updated grids are then merged into a single grid and used by an optimizer to evaluate queries before the queries are executed.

Abstract: A method, system, and computer program for optimizing execution of a DML statement on a temporal database are disclosed. A first execution package is provided to an execution engine. The first execution package includes a plurality of operations to be executed if the contents of a row in a table in the temporal database indicate the row has a first temporal condition. A second execution package is provided to the execution engine. The second execution package includes a plurality of operations to be executed if the contents of the row in the table in the temporal database indicate the row has a second temporal condition. The execution engine is run to produce a result. The result is saved.

Abstract: A database system constructs representation for predicate expressions invoking user-defined routines. A first representation is constructed if an indicator has a first value, and a second representation is constructed if the indicator has a second value. Based on which representation is used, an optimizer in the database system selects use of indexing and/or statistics and/or other performance-enhancement features in generating a query plan.

Abstract: A method, computer program, and database system for performing a request on a table associated with an index are disclosed. A database contains a table, an index, and a partition elimination list and accepts a query. A table has one or more rows stored in one or more partitions. The index contains index entries, each of which references a row in a partition, where the row is in the table. The query has a first and a second condition. The partition elimination list is populated with partitions based on the first condition of the query. Only index entries that are identified by the request because of the second condition and that reference partitions that are not eliminated by the partition elimination list are read.

Abstract: Query processing statistics are logged in a multi-database system containing a plurality of system databases. A plurality of query log entries generated using information regarding the execution of a plurality of queries are temporarily stored in a database query log (DBQL). The information is received from a plurality of system databases. Each query log entry is generated using information regarding execution of one query by the plurality of system databases. Each query log entry includes a field identifying a system database that was the source of the information in that entry. An express request is created upon occurrence of a triggering event. The express request contains a subset of the query log entries temporarily stored in the DBQL cache. The created express request is transmitted to a plurality of system databases and the contents of the transmitted express request are stored in each of plurality of system databases to which it was transmitted.

Abstract: Apparatus, systems, and methods may operate to acquire an original data set comprising a series of data points having an independent portion and a dependent portion, the dependent portion representing a measure of device performance that depends on at least one device characteristic represented by the independent portion. Additional activity may include identifying outlier data points in the series by determining, in comparison with all other members of the series, whether the outlier data points conform to a known trend of the series; transforming the original data set into a transformed data set by removing the outlier data points from the series; and publishing the transformed data set. Other apparatus, systems, and methods are disclosed.

Abstract: For a given pool of database requests, a database system generates an integrated execution plan for multiple ones of the database requests in the pool. The database system determines whether to execute the integrated execution plan or individual execution plans corresponding to the respective multiple database queries. The determining is based on one or more criteria including performance goals corresponding to the respective multiple database requests.

Abstract: Methods, computer programs, and database systems for protecting one or more database objects are disclosed. The methods include designating one or more database objects for protection and characterizing one or more data storage units by a set of dimensions. The method include, for one or more database objects designated for protection: selecting one or more data storage units to store protection information for the database object based on one or more dimensions, and storing protection information in the one or more selected data storage units.

Abstract: A method, apparatus, and article of manufacture provide the ability to deploy a data management application to a target computer system. Metadata for a master data management (MDM) application is stored in a deployment database. The metadata is representative of business rules and process workflows that manage business data from multiple sources and a model definition for a model for a central business database. Configuration settings for the MDM application are stored in the deployment database. The metadata and configuration settings are retrieved from the deployment database. Installation instructions of the MDM application are confirmed based on input into a graphical user interface. The master data management application is installed on the target computer system based on the installation instructions, metadata, and configuration settings.

Abstract: A method and computer program are disclosed for increasing the efficiency of a row sequential database operation by transforming procedural logic, which applies serially to one row at a time, into set logic, which applies in parallel to many rows or all rows at once. The method includes dividing the row sequential operation into a plurality of portions. A hierarchy is determined for the portions. A set level operation is generated in accordance with the portion hierarchy.

Abstract: A method executed by a plurality of processors in a database system to implement temporal aggregate queries. The database system has a temporal table. A plurality of consecutive temporal partitions are defined and allocated to the respective processors. A query is received to aggregate at least one attribute of the temporal table. In response to the query, a plurality of timestamps are identified in the temporal table, the respective timestamps are allocated to the respective temporal partitions, the value changes in the at least one attribute at the plural timestamps are computed within each partition using the respective processors to which each partition is allocated, and the value changes within each partition are aggregated using the respective processors to which each partition is allocated to produce an aggregate value for the query.