Title :
Analysis of Oracle locks blocking and the solving method in the design of information system
Author :
Li, Ran ; Guo, Xianjiu
Author_Institution :
Inf. Eng. Coll., Dalian Ocean Univ., Dalian, China
Abstract :
The way Oracle locked data in DML and the reasons for DML lock blocking were introduced in this study. To confirm the successful parallel visits to the same data for users, various lock technologies were adopted to realize the data integrality. The solving methods of Oracle locks blocking in some practical applications were presented.
Keywords :
database languages; information systems; object-oriented databases; relational databases; Oracle locks blocking; data integrality; data manipulation language lock blocking; information system design; Computers; Concurrency control; Concurrent computing; Databases; Information systems; Maintenance engineering; Process control; Oracle; concurrency control; information system; locks blocking;
Conference_Titel :
Computer Science and Service System (CSSS), 2011 International Conference on
Conference_Location :
Nanjing
Print_ISBN :
978-1-4244-9762-1
DOI :
10.1109/CSSS.2011.5974448