System for controlling concurrent access to data in a...

Details System for controlling concurrent access to data in a... System for controlling concurrent access to data in a...

2011-02-15

2011-02-15

Lin, Shew-Fen (Department: 2166)

Data processing: database and file management or data structures

Data integrity

Concurrent read/write management using locks

C711S141000, C711S152000

Reexamination Certificate

active

07890482

ABSTRACT:
A system for controlling concurrency of access to data in a database system is provided. The system includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the database system containing the data. The method further includes identifying a partition in the database system that contains the row or the page in the database system containing the data; associating the lock request with a partition lock on the partition that contains the row or the page in the database system containing the data; and accessing the data using the partition lock.

REFERENCES:
patent: 4399504 (1983-08-01), Obermarck et al.
patent: 4716528 (1987-12-01), Crus et al.
patent: 4727485 (1988-02-01), Keshlear et al.
patent: 4933848 (1990-06-01), Haderle et al.
patent: 4965719 (1990-10-01), Shoens et al.
patent: 5226143 (1993-07-01), Baird et al.
patent: 5247672 (1993-09-01), Mohan
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5301290 (1994-04-01), Tetzlaff et al.
patent: 5448727 (1995-09-01), Annevelink
patent: 5454108 (1995-09-01), Devarakonda et al.
patent: 5455942 (1995-10-01), Mohan et al.
patent: 5551027 (1996-08-01), Choy et al.
patent: 5596754 (1997-01-01), Lomet
patent: 5625811 (1997-04-01), Bhide et al.
patent: 5625815 (1997-04-01), Maier et al.
patent: 5675797 (1997-10-01), Chung et al.
patent: 5692174 (1997-11-01), Bireley et al.
patent: 5692182 (1997-11-01), Desai et al.
patent: 5717919 (1998-02-01), Kodavalla et al.
patent: 5758345 (1998-05-01), Wang
patent: 6754656 (2004-06-01), Cornwell et al.
patent: 9103024 (1991-03-01), None
Locking in DB2 for MVS/ESA Environment, Aug. 1996, International Technical Support Organization, San Jose Center.
IBM Technical Disclosure Bulletin, “Method for Performance Enhancement in the Parallel Execution of Status Database Transactions,” Aug. 1994, vol. 37, No. 8, pp. 609-614.
Dias et al., Integrated Concurrency-Coherency Controls for Multisystem Data Sharing, IEEE, Trans on Software Engineering, vol. 15, No. 4, New York, NY, 1989, pp. 437-447.
Mohan et al., Efficient Looking and Caching of Data in the Multisystem Shared Disks Transaction Environment, 3rd Invention Conference on Extended Database Technology, Vienna, Mar. 1992, 16 pages.
An Introduction to Database Systems, Chapter 14, Concurrency, C.J. Date, 6th Edition, Addison-Wesley Systems Programming Series, 1995, pp. 391-415.

Affiliated with

Also associated with

Rating

System for controlling concurrent access to data in a... 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 controlling concurrent access to data in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System for controlling concurrent access to data in a... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2620150