System for optimally processing a transaction and a query to the

Details System for optimally processing a transaction and a query to the System for optimally processing a transaction and a query to the

1995-03-17

1998-05-26

Black, Thomas G.

395603, 395604, 395616, 395439, 395440, 395456, G06F 1700, G06F 1500

Patent

active

057581495

ABSTRACT:
A system for concurrent processing of queries and transactions against a shared database. The system includes multiple processors wherein a processor is available for processing queries and another processor is available for concurrently processing transactions. A query buffer is established for performing the query search while the data accessed by transactions is available in a database cache. Control logic in a database management system distinguishes between transactions and queries and initiates file-read control for reading the file containing the database. File-read control contains logic for logical sequential reading and logical non-sequential reading of the file. Control structures provide a means for control over the load that the query is allowed to place on the system.

REFERENCES:
patent: 4648036 (1987-03-01), Gallant
patent: 4870568 (1989-09-01), Kahle et al.
patent: 4876643 (1989-10-01), McNeill et al.
patent: 4925311 (1990-05-01), Neches et al.
patent: 4993030 (1991-02-01), Krakauer et al.
patent: 5148432 (1992-09-01), Gordon et al.
patent: 5179702 (1993-01-01), Spix et al.
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5287473 (1994-02-01), Mohan et al.
patent: 5287496 (1994-02-01), Chen et al.
patent: 5317727 (1994-05-01), Tsuchida et al.
patent: 5317731 (1994-05-01), Dias et al.
patent: 5325525 (1994-06-01), Shan et al.
patent: 5333305 (1994-07-01), Neufeld
patent: 5345585 (1994-09-01), Iyer et al.
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5410693 (1995-04-01), Yu et al.
patent: 5423037 (1995-06-01), Hvasshod
patent: 5448727 (1995-09-01), Annevelink
patent: 5457793 (1995-10-01), Elko et al.
patent: 5495606 (1996-02-01), Borden et al.
"Parallel Query and Transaction Processing", Mike Ferguson Information Database, 1993, pp. 18-27.
Chan, A. et al. "The Implementation of an Integrated Concurrency Control and Recovery Scheme," Jun. 1992, Orlando.
The Tandem Performance Group, "A Benchmark of Non-Stop SQL on the Debit Credit Transactions," 1988, Chicago.
Stearns, R.E., et al. "Distributed Database Concurrency Controls Using Before-Values," Apr. 1981, Ann Arbor.
Bayer, R., et al. "Parallelism and Recovery in Database Systems," Jun. 1980, vol. 5, No. 2, pp. 139-156.

Affiliated with

Also associated with

Rating

System for optimally processing a transaction and a query to the does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System for optimally processing a transaction and a query to the, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System for optimally processing a transaction and a query to the will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1976548