An Optimized Method for Access of LOBs in Database Management Systems

Abstract:

Article Preview

This paper researches methods used by relational database management systems to manage LOBs. It attempts to use LOB slave table methods to optimize and advance the storage structures of large objects as well as optimize the redo and undo log mechanisms to increase LOB access efficiency. For changes in slave table data, it effectively prevents the redo log from being written into the LOB database, while diminishing the amount of changes being recording within the undo journal. This improves the writing speed of the log, thus improving the access efficiency and speed of the slave table record. At the same time, this optimized log mechanism also ensures the correct recovery of data after a system crash. Tests have shown that the optimized LOB access efficiency is slightly better than Oracle’s.

Info:

Periodical:

Edited by:

Wei Deng and Qi Luo

Pages:

58-63

DOI:

10.4028/www.scientific.net/AEF.6-7.58

Citation:

J. J. Liang and W. Zhan, "An Optimized Method for Access of LOBs in Database Management Systems", Advanced Engineering Forum, Vols. 6-7, pp. 58-63, 2012

Online since:

September 2012

Export:

In order to see related information, you need to Login.

In order to see related information, you need to Login.