Hewlett-packard Development Company, L.p.

Hewlett Packard Enterprise Development LP

Gary Stephen Smith

Shang-Sheng Tung

Sean L Broeder

Ronald M Cassou

Charles Stuart Johnson

David Hege

John Stewart De Roo

Pankaj Mehra

David W Birdsall

Michael James Hanlon

Gary Martin Gilbert

Subbarao Kakarlamudi

Arvind Narain

Gunnar D Tapper

Sam Fineberg

Tharaknath Capirala

James Burl Tate

Milford L Hazlet

Ronald P Cohen

Leonard R Fishler

Marty Guericke

Vijay M Bellam

Sang-Sheng Tung

Examples of a no rollback threshold for an audit trail are disclosed. In one example implementation according to aspects of the present disclosure, a method may include processing, by a computing system, a database transaction, and determining, by the computing system, whether a transaction span of the transaction exceeds a no rollback threshold for an audit trail. The method may include, in response to determining that the transaction span exceeds the no rollback threshold, converting, by the computing system, the transaction into a no rollback transaction. Additionally, the method may include, in response to determining that the transaction span exceeds the no rollback threshold, abandoning, by the computing system, the transaction if an error is encountered during the processing the transaction.

No rollback threshold for audit trail

Regulating enterprise database warehouse resource usage can include identifying a number of queries in an enterprise database warehouse (EDW) and regulating EDW resource usage among the number of queries.

Regulating enterprise database warehouse resource usage of dedicated and shared process by using OS kernels, tenants, and table storage engines

A method for transaction registration is described herein. The method includes sending, for a transaction manager, a registration request for a transaction. The method also performing data accesses on a data server. The registration request is non-blocking to the data accesses. The method further includes performing a two-phase commit process for the data server if the registration request is accepted. Additionally, the method includes handling the rollback if the transaction registration is rejected.

Non-blocking registration in distributed transactions

A storage subsystem provides redundancy protection for data associated with files stored in a storage subsystem. A request is received to change the redundancy protection for data associated with at least one of the files, where the request identifies the data for which the redundancy protection is to be changed. The redundancy protection for the data identified by the request is changed, while the redundancy protection for a remainder of the data associated with the files stored in the storage subsystem is maintained unchanged.

Changing the redundancy protection for data associated with a file

In an embodiment of the invention, an apparatus and method for detecting resource consumption and preventing workload starvation, are provided. The apparatus and method perform the acts including: receiving a query; determining if the query will be classified as a resource intense query, based on a number of passes by a cache call over a data blocks set during a time window, where the cache call is associated with the query; and if the query is classified as a resource intense query, then responding to prevent workload starvation.

Apparatus and method for detecting resource consumption and preventing workload starvation

One embodiment is a method that builds a target database with transaction logs from an online source database. The transaction logs include both existing data in the source database and updates that occur to the source database while the target database is being built.

Building a synchronized target database

In at least one embodiment, transaction processing systems comprise non-disk persistent memory that is utilized to commit transactions.

Transaction processing systems and methods utilizing non-disk persistent memory

This disclosure describes a technique including operating a redundant disk drive device, wherein the redundant disk drive device includes a primary disk drive and at least one mirror disk drive. At least one of the disk drives is reconfigured within the redundant disk drive system in such a manner that during the reconfiguring, the disk drive is maintained on-line.

In-service raid mirror reconfiguring

A method of processing a transaction includes processing a transaction workload in a primary process pair on a first node in a cluster of nodes, the processing using at least one stable storage volume for storing a database and another stable storage volume for storing a log, the at least one stable storage volume and the log storage volume forming a log storage group. The method further includes performing checkpointing operations via the network from the primary process pair to a backup process pair while processing the transaction workload, the backup process pair operating on a second node in the cluster of nodes. The method further includes detecting a failure making the first node inoperable or inaccessible, and after detecting the failure, engaging the backup process pair to take over the transaction processing workload of the primary process pair, the backup process pair being configured to operate with the log storage group used by the primary process pair on the failed node.

Transaction processing apparatus and method

A method of transferring a transaction workload of a primary process pair. The primary pair has access to a stable storage volume for storing data items and a log for storing transaction processing updates to data items. A backup process pair is established for the primary pair and information is transferred thereto so that it can take over for the primary pair should that pair fail. Additionally, a lock table is maintained and update records are written to the log by the primary pair. The update records include any locks from the lock table that related to the update records. When a failure of the primary pair occurs, the storage volume is locked, and the backup pair reads the log to reconstruct a lock table. Once the locks have been reconstructed, the lock on the storage volume is released and the backup pair operates to process the workload.

Minimum latency reinstatement of database transaction locks

A method of scheduling in a mixed workload environment. A high priority workload requiring bounded response times is executed on the same system with a low priority workload that is capable of tying up the CPU and multiple volume storage resources of the system by causing multiple concurrent I/O operations, thereby increasing the response times of the high priority workload beyond acceptable bounds. The method of scheduling prevents the response times of the high priority workload from increasing beyond the acceptable bounds by deferring the dispatch of processes servicing the current low priority workload for a time that depends on the priority of the low priority work and by not performing concurrent I/O operations that are requested by the current low priority work, when there is sufficient higher priority activity on the storage resource.

Growing community of inventors

Auburn, CA, United States of America

Gary Stephen Smith