System of database concurrency control based on transaction types and prior access to a data set

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 5551023
SERIAL NO

08286709

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A priority scheme is used to control concurrent access to a database. The priority scheme takes advantage of the usual delay in a process after a first full set of data is accessed in order to improve the overall impression of the speed of the system. Access to the database is granted on the basis of priority. In the disclosed exemplary embodiment of the invent ion, three priorities are established: a first priority for fast-response type transactions which have not yet accessed a set of data, a second priority for fast-response transactions which have accessed a set of data, and a third priority for batch transactions. When a fast-response transaction is initiated, it is given the first priority. Once a predefined number of data values have been obtained from the database, enough to produce a full screen display, the transaction receives the second priority. A transaction may be assigned the first priority periodically, when it needs to access a further set of data. A first priority transaction can block a second priority transaction and can kill a third priority transaction. A first priority transaction can only block a second priority transaction. A second priority transaction is not necessarily given priority over a third priority transaction, however.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

  • MATSUSHITA ELECTRIC CORPORATION OF AMERICA

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Alonso, Rafael Plainsboro, NJ 7 273

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation