An Optimized Method for Access of LOBs in Database Management Systems


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.



Edited by:

Wei Deng and Qi Luo






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


[1] Zhou AY. Data intensive computing-challenges of data management techniques. Communications of CCF, 2009, 5(7): 50−53 (inChinese with English abstract).

[2] Gunarathne T, Wu TL, Qiu J, Fox G. Cloud computing paradigms for pleasingly parallel biomedical applications. In: Hariri S, Keahey K, eds. Proc. of the HPDC. Chicago: ACM Press, 2010. 460−469. [doi: 10. 1145/1851476. 1851544].

DOI: 10.1145/1851476.1851544

[3] Das S, Sismanis Y, Beyer KS, Gemulla R, Haas PJ, McPherson J. Ricardo: Integrating R and Hadoop. In: ElmagarmidAK, Agrawal D, eds. Proc. of the SIGMOD. Indiana: ACM Press, 2010. 987−998. [doi: 10. 1145/1807167. 1807275].

DOI: 10.1145/1807167.1807275

[4] Liao HJ, Han JZ, Fang JY. Multi-Dimensional index on Hadoop distributed file system. In: Xu ZW, ed. Proc. of the Networking, Architecture, and Storage (NAS). Macau: IEEE Computer Society, 2010. 240−249. [doi: 10. 1109/NAS. 2010. 44].

DOI: 10.1109/nas.2010.44

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