Browse Prior Art Database

Methodology and Process for Prioritizing DML in a Database Environment

IP.com Disclosure Number: IPCOM000228070D
Publication Date: 2013-Jun-04
Document File: 1 page(s) / 19K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a new level of database authorization: prioritize. This allows the completion of a prioritized request in a database environment, overriding any existing locks on a database object.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 66% of the total text.

Page 01 of 1

Methodology and Process for Prioritizing DML in a Database Environment

In database technologies, the concept of locking a database object is a common practice that prevents other actions on the object from starting. However, at times, the user wants a command to execute, regardless of the fact that a lock exists; this would usually occur when the user or Database Administrator (DBA) wants to complete a command. With existing methods, the user must wait for the unit of work to complete and release the lock or have a DBA manually force the lock release. While that action takes place, the prioritized request would have failed. This can repeat multiple times.

A method is needed to allow the completion of the prioritized request in a database environment.

The invention is a method to allow the prioritized request to complete by supplementing the existing privilege tables (that all database management systems have) and allow the command to complete. Common authorizations against database objects include insert, update, delete, and select. The invention adds a new level of authorization: prioritize (existing authorizations).

When the invention is implemented (i.e., the prioritize level of authorization) a command run from a user with the new level of authorization does not fail due to existing locks, but forces any units of work that were locking objects to fail. The invention overrides the lock, and the prioritized work continues.

The steps for implementing the priori...