Abstract: Techniques for extending database date statistics are provided. A data dictionary houses existing date statistics for information housed in a column of a database table. The existing statistics housed in the data dictionary are used to project estimated statistics for the column for a target date that is not yet represented in the data dictionary and the data dictionary is updated with the estimated statistics.

Abstract: A method, data structure, and database system for synchronizing access to a global resource by a plurality of processes executing on a computer system are disclosed. A global lock is defined for the global resource and a local instantiation of the global lock is defined for each of the plurality of processes that will access the global resource.

Abstract: A system includes at least two database systems that both store a common portion of a relational database and that are configured to share in execution of a database workload against that relational database. The system also includes a system-management component configured to receive indication that a first one of the database systems is ceasing operation and, in response, take a second one of the database systems to an operational state in which at least a portion of the database workload that is scheduled to be carried out by the first database system is transferred to the second database system.

Abstract: A method, computer system, and database system for automating a business rule in a database are disclosed. One or more database triggers associated with a business rule state machine are enabled and the business rule state machine is initialized.

Abstract: A system calculates the optimal allocation of two or more resources provided by a resource provider to a task within a computer system from a plurality of possible allocations. In doing so, the system calculates the total volume of an N-dimensional cube, where N is the number of resources provided by the resource provider, representing the respective amounts of resources available to be allocated. The system also calculates the average volume of the N-1 dimensional shapes forming the sides of the N-dimensional cube. The system then calculates, at least partly from the ratio of the total volume to the average volume, the balance resulting from the allocation of resources represented by the N-dimensional cube. The system then calculates the imbalance resulting from the allocation of resources at least partly from the balance and determines the smallest imbalance as the optimal allocation of resources.

Abstract: A method, computer program, and database system are disclosed for storing element-based descriptions of documents in a database. The database system includes one or more nodes. Each of the one or more nodes provides access to one or more of a plurality of CPUs. Each of the one or more CPUs provides access to one or more of a plurality of virtual processes. Each virtual process is configured to manage data stored in one of a plurality of data-storage facilities. The data stored in the plurality of data-storage facilities includes data representing a database table. A row of the table corresponds to an element of the element-based document description and includes: data describing the element, an order identifier corresponding to the element, and a range identifier corresponding to the element.

Abstract: An end transaction procedure is optimized for certain database operations. Where a transaction preceding the end transaction procedure includes a step that employs all the access modules in the transaction, a flush of the transaction log is performed during execution of the last step of the transaction. The need to flush the transaction log during the subsequent end transaction procedure is obviated. The end transaction procedure further may check to determine whether the transaction log was previously flushed, rather than always flushing the transaction log. Also, where the access modules involved in a transaction are part of the same cluster, certain broadcast operations of the end transaction procedure may be avoided.

Abstract: An improved system and method for storing, reusing and recompiling execution plans for SQL database queries. The system. The system validates the performance of a newly compiled plan prior to replacing a currently stored execution plan and compares the resource cost of the recompiled plan with the cost of the currently stored plan. In the event that the resource cost of the recompiled plan is not greater than the stored plan resource cost, the system replaces the currently stored execution plan with the recompiled plan.

Abstract: A system and method for migrating data, in parallel, from a source database system into a target database system includes storing data in groups (e.g., clusters) in the source database system. The groups of data are transferred, in parallel, to respective temporary staging tables in the target database system. The data in the temporary staging tables are then inserted, in parallel, into a target table in the target database system to complete the migration.

Abstract: A method for forecasting daily sales patterns for retail products. The method uses historical daily demand data for a product to calculate a daily weight value for the product for each day of the week, each daily weight value representing the ratio of the historical daily demand for a corresponding day of the week to a total of the historical daily demands for the entire week. A daily demand forecast for each day of a forthcoming week is determined by applying the daily weight values to a predetermined weekly demand forecast for the forthcoming week. Store closure coefficients are applied to the daily demand forecasts for days immediately preceding and following store closures or holidays to adjust the daily forecasts to accommodate changes in customer buying patterns resulting from the store closures.

Abstract: A financial processing system that accesses account, event and organization attributes from a relational database management database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the event attributes comprise data about account-related transactions, and (3) the organization attributes comprise data about the organization's financial status. Profitability calculations are performed in the computer using the account, event and organization attributes accessed from the relational database management system, as well as one or more profit factors and one or more rules. The profitability calculations comprise the following: Profit (ai) = Net Interest Revenue (NIR) (ai) + Other Revenue (OR) (ai) ? Direct Expense (DE) (ai) ? Indirect Expense (IE) (ai) ? Risk Provision (RP) (ai) for an account ai.

Abstract: An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.

Abstract: A method, computer program, and database system for controlling operations that may be performed on a user-defined type (UDT) are disclosed. The UDT is derived from an underlying type that has a set of underlying operations. The method includes creating the UDT and activating zero or more underlying operations for the UDT.

Abstract: Techniques are presented for two-phase commit of electronic mail (email) processing. An email service interacts with a sender's service to prepare and commit emails. An email is not sent to a recipient until a commit is received from the sender's service. The sender's service records responses from the email service for tracking whether the emails are successfully sent or failed to be sent to their intended recipients.

Abstract: A Value Analyzer system is a data-driven computer-facilitated financial model that provides accurate and consistent profitability calculations using account and event data stored in a relational database managed by a relational database management system (RDBMS), wherein the account data comprises attributes of the accounts being measured and the event data comprises attributes of account-related transactions. A selector function uses selection criteria to select accounts and events from the relational database in order to generate a number of inputs for profitability calculations.

Abstract: A printed circuit board includes multiple layers on which electrically conductive traces reside, where at least two of the electrically conductive traces each has a first portion formed on one layer of the printed circuit board and a second portion formed on another layer of the printed circuit board. The printed circuit board also includes a thru-hole via that includes at least two electrically conductive portions electrically isolated from each other, such that each of the electrically conductive portions connects electrically to both the first and second portions of a corresponding one of the electrically conductive traces.

Abstract: A method, computer program, and computer network are disclosed for transforming multiple alternative equality conditions between a database column and a set of values. The method includes identifying one or more groups of consecutive values in the set. The equality conditions corresponding to values found in one or more of the identified groups are removed. One or more inequality conditions corresponding to the one or more of the identified groups are added.

Abstract: A method for determining daily weight values and store closure coefficients for use in forecasting daily sales patterns for retail products. The method uses historical daily demand data for a product to calculate a daily weight value for the product for each day of the week, each daily weight value representing the ratio of the historical daily demand for a corresponding day of the week to a total of the historical daily demands for the entire week. A daily demand forecast for each day of a forthcoming week is determined by applying the daily weight values to a predetermined weekly demand forecast for the forthcoming week. Historical demand data for weeks including holidays or store closures is used to calculate store closure coefficients, representing the ratio of the historical daily demand for days immediately preceding and following a store closure, to the historical demand for a corresponding day during a regular, non-holiday, week.

Abstract: A Customer Relationship Management (CRM) system accesses customer transaction data from a database managed by a Relational Database Management System (RDBMS), and then performs a pattern detection function using the customer transaction data, wherein the pattern detection function finds patterns in customer purchasing behavior, as evidenced by the customer transaction data, related to a sequence of when purchases occur. Specifically, the pattern detection function finds the patterns in the customer purchasing behavior by comparing a focal product set to an analysis product set over a specified time interval.

Abstract: A computer program and system for redistributing data in a relational data base management system includes storing one or more rows of a database table in an allocated buffer associated with a program. The program is associated with a transmitting processing module and is capable of managing a redistribution of one or more rows associated with one or more database tables. The method includes comparing the allocated buffer to a portion of the buffer to be occupied by the one or more rows. If the allocated buffer is larger than the portion of the buffer to be occupied by the one or more rows, then the method includes communicating a message to one or more destination processing modules, the message comprising at least some of the one or more rows stored in the allocated buffer. Otherwise, the method includes executing a many-rows method to redistribute the one or more rows.