Data processing: database and file management or data structures – Database and file access – Database access control methods
Reexamination Certificate
2011-06-28
2011-06-28
Cottingham, John R. (Department: 2167)
Data processing: database and file management or data structures
Database and file access
Database access control methods
Reexamination Certificate
active
07970787
ABSTRACT:
A method and system for improving access concurrency to information stored in at least one table in a relational database system is disclosed. The method comprises providing a data cache, which stores a portion of the at least one table. The data cache includes a plurality of cache entries, wherein each cache entry comprises a first data item, a second data item, and a cache entry state. The method further comprises retrieving from the at least one table and storing in a cache entry's first data item a representation of committed information for a user, and retrieving from the at least one table and storing in the cache entry's second data item a representation of changes applied to the committed information, but not yet committed in the database system.
REFERENCES:
patent: 5230070 (1993-07-01), Liu
patent: 5608909 (1997-03-01), Atkinson et al.
patent: 5864854 (1999-01-01), Boyle
patent: 5897634 (1999-04-01), Attaluri et al.
patent: 5930794 (1999-07-01), Linenbach et al.
patent: 6016495 (2000-01-01), McKechan et al.
patent: 6138209 (2000-10-01), Krolak et al.
patent: 6243719 (2001-06-01), Ikuta et al.
patent: 6263369 (2001-07-01), Sitaraman et al.
patent: 6321235 (2001-11-01), Bird
patent: 2001/0051956 (2001-12-01), Bird
patent: 2002/0026448 (2002-02-01), Bird et al.
patent: 2002/0091899 (2002-07-01), Weedon
patent: 9744747 (1997-11-01), None
Boykin, R. J. “Support of Column Privileges in SQL”. Sep. 1992., pp. 80-81. IBM Technical Disclosure Bulletin. vol. 35 No. 4A.
Provided are www.google.com web definitions of the word Cache. Accessed Dec. 7, 2006.
“Using ‘defunct’ Cache Entries to Avoid Artificial Deadlocks when Caching Catalog Tables,” IBM Research Disclosure. Jun. 2001. pp. 1089-1090.
Myer, Andy et al., “A Secure, Publisher-Centric Web Caching Infrastructure,” Dept of Electr. & Comp. Eng., Carnegie Mellon University, Pittsburg, PA, pp. 1-26, Apr. 26, 2001.
Bird Paul M.
Stuy Michael A. F.
Cottingham John R.
International Business Machines - Corporation
Pham Michael
Sawyer Law Group P.C.
LandOfFree
Access concurrency for cached authorization information in... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Access concurrency for cached authorization information in..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Access concurrency for cached authorization information in... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2738789