Storage of File Data in Database with Blob Field and Its Efficiency Analysis

SONG Guo-bing,CHEN Qi
DOI: https://doi.org/10.16208/j.issn1000-7024.2010.21.023
2010-01-01
Abstract:To improve the efficiency of storing file data directly into databases in information system,support of file data storage with ADO.NET technique is studied.Two methods to store file data into blob field of databases with SqlCommand object in ADO.NET technique is presented,one of which is storage procedure,and the other is to directly execute SQL statement.Principle and procedure of SQL method is studied,and a kind of storage algorithm based on binary stream reader and buffer is proposed.Two quantitative models are established to evaluate the efficiency of each step of storage algorithm.Experiments in local area network demonstrate the effectiveness of this algorithm.Comparison results of two methods,show that storage procedure method is more efficient.
What problem does this paper attempt to address?