Data processing: database and file management or data structures – Data integrity – Concurrent read/write management using locks
Reexamination Certificate
2007-07-30
2011-10-18
Cottingham, John R. (Department: 2167)
Data processing: database and file management or data structures
Data integrity
Concurrent read/write management using locks
Reexamination Certificate
active
08041691
ABSTRACT:
Techniques for a data definition language (DDL) statement acquiring a lock on a table in wait mode in a deadlock free manner are provided. A DDL statement specifies metadata of a table that is to be modified, whereas a data manipulation language (DML) statement specifies a table to be modified. When a DDL statement is received, a proxy statement is initiated and executed instead of first acquiring an exclusive lock on metadata of a particular table. The proxy statement is similar to a DML statement in that the proxy statement acquires a lock on the particular table. After the proxy statement has been processed, an exclusive lock on the metadata is acquired.
REFERENCES:
patent: 5872981 (1999-02-01), Waddington et al.
patent: 6105026 (2000-08-01), Kruglikov et al.
patent: 6353828 (2002-03-01), Ganesh et al.
patent: 6370529 (2002-04-01), Kruglikov et al.
patent: 6772155 (2004-08-01), Stegelmann
patent: 2006/0212496 (2006-09-01), Romine et al.
patent: 2007/0094431 (2007-04-01), Fachan
Cyran et. al. “Oracle® Database Concepts, 10g Release 2 (10.2)” [Online] Oct. 2005, Oracle, [Retrevied on Sep. 23, 2009]. Retreived from Internet: <URL: http://download.oracle.com/docs/cd/B19306—01/server.102/b14220.pdf> 65 selected pages.
“Stumblings >> Locking in Oracle—DML Locks” [Online], Mar. 27, 2006, [archived by Archive.org May 7, 2006], [retreived on Sep. 23, 2009]. Retreived from the Internet: <URL:http://web.archive.org/web/20060507094455/http://rahulagarwal.wordpress.com/2006/03/27/locking-in-oracle-dml-locks/>, 4 Pages.
“Deadlocks” downloaded from the Internet Sep. 4, 2007 <http://publib.boulder.ibm.com/infocenter/cldscp10/index.jsp?topic=/com.ibm.cloudscape.doc/develop75.htm >.
“Lock Table” downloaded from the Internet Sep. 4, 2007 <http://oracle-docs.dartmouth.edu/dba-docs/10gdoc/server.101/b10759/statements—9015.htm#sthref7012>.
Kumar Ramesh
Raghavan Ananth
Shankar Shrikanth
Cottingham John R.
Hickman Palermo & Truong & Becker LLP
Ledesma Daniel D.
Nicholes Christian A.
Oracle International Corporation
LandOfFree
Acquiring locks in wait mode in a deadlock free manner does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Acquiring locks in wait mode in a deadlock free manner, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Acquiring locks in wait mode in a deadlock free manner will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4290655