Abstract: A query to perform an ordered analytic function contains a clause specifying creation of dynamic partitions, where the clause contains a partitioning condition to specify the dynamic partitions. During processing of the query, dynamic partitions are identified based on evaluating the partitioning condition. To identify the dynamic partitions, a first table is created that contains a first column to track rows of an input table for indicating whether the partitioning condition evaluates to true. The first column of the first table is used to identify the dynamic partitions.

Abstract: The number of writes to a device (“D1-n”) consisting of n sub-devices (“Da”) is counted: [ W 1 , 1 … W 1 , m - 1 W 1 , m W 2 , 1 … W 2 , m - 1 W 2 , m … … … … W n , 1 … W n , m - 1 W n , m ] ? ? where: Wa,b is the number of writes to sub-device Da in time period “b”; n>1; m>1. A write rate is determined for each sub-device Da at the end of time period p (“WRa,p”) using the following equation: WR a , p = ? b = 1 p ? ? W a , b ? b = 1 p ? ? t b ? where: tb is the amount of time in time period “b”; p<m. The write rate to sub-device Da is controlled in time periods after time period p so that device D1-n will have a guaranteed lifetime (“LD1-n”).

Abstract: A computer-implemented apparatus, method, and article of manufacture manage a plurality of database systems and perform data maintenance tasks in a data warehouse system. A domain includes a plurality of database systems. A virtual regulator manages the domain, detects a request to invoke a data maintenance task on a first system in the domain, routes the data maintenance task, for execution, to a second system in the domain, and applies results from the data maintenance task (executed by the second system) to the first system.

Abstract: A Value Analyzer system is a data-driven computer-facilitated financial model that provides accurate and consistent profitability calculations using account, product and event attributes stored in a relational database managed by a relational database management system (RDBMS). Profitability calculations are performed in the computer by applying one or more rules to the account, product and event attributes accessed from the database, wherein the profitability calculations include setup, generation and execution of structured query language (SQL) statements by the RDBMS. The present invention also monitors the profitability calculations by monitoring the setup, generation and execution of the SQL statements by the RDBMS, in order to provide bypass, logging, user restartability, or status (BLURS) functions for the profitability calculations.

Abstract: A temporal table is present in an active data warehouse (“ADW”) on a massively parallel processing system (“MPP system”). The MPP system includes a plurality of units of parallelism. Each of the plurality of units of parallelism maintains its own moving system time separate from that of the other units of parallelism. A load-job for the ADW is accepted. The load-job includes a requested modification to an identified row. The identified row is stored in the temporal table on a first of the MPP system's units of parallelism. The requested modification is implemented on the identified row. The identified row is timestamped with the moving system time maintained by the first of the MPP system's units of parallelism at the time of the implementation of the modification.

Abstract: A database system includes an optimizer to generate resource estimates regarding execution of a request in the database system, and a regulator to monitor execution of a request and to adjust a priority level of the request based on the monitored execution and based on the resource estimates provided by the optimizer.

Abstract: Techniques for establishing and enforcing row level database security are presented. Qualifiers are used to uniquely identify particular rows of a database table. The qualifiers are selectively combined to generate a hash value. The hash value is associated with a user. The user is permitted to accesses selective rows of the database table in response to the rows represented in the hash value, which is associated with the user.

Abstract: A database system includes a rescheduler that performs rescheduling of transactions in a scheduling queue based on one or more criteria. One criterion is whether a first transaction in the queue can be performed as a synchronized scan of a table with a second transaction that is currently executing. This enables the first and second transactions to share a segment of a buffer storage pool.