BLOB Data Research Articles

Research of LOB Data Compression and Read-Write Efficiency in Oracle Database

Aiming at the problems of huge storage space, low exchange speed and low read-write speed of the current specific oracle database, the read-write speed and exchange speed tests are performed on the compressed and uncompressed Clob and Blob data by three compression algorithms, including Bzip2, Gzip and GzipIO respectively. The read speed test is performed by the direct read, substr read, and substr+threadPool read techniques. The results show that: (1) Blob is superior to Clob in terms of storage, exchange, or read-write speed; (2) For the specific database, Blob+Gzip is the optimal storage structure of the minute and second data. The read-write speed is greatly improved, and the overall capacity of the database is reduced to 7% (or less). The exchange rate of the second data is at least 7.89 times of the present rate, and the station data can be exchanged to the disciplinary center within 2–3 hours (currently 1.5 days); (3) The simplest and most widely used direct read method by software developers has poor database read efficiency, while the substr+threadPool technique shows higher database read efficiency no matter for Clob or Blob, for compressed or uncompressed, which brings a leap-forward improvement in the read speed of LOB data. The results of this paper are of high reference significance to the LOB data storage design and software development.

Design and Implementation of BLOB Data Processing Mechanism based on Struts2 and Hibernate

Design and Implementation of BLOB Data Processing Mechanism based on Struts2 and Hibernate

An Efficient Distributed Model for XMLised Blob Data Generation

In today’s Internet computing, eXtensible Markup Language (XML) is preferred tool for exchange of data’s by all the organizations irrespective of its size. As there are lots of data exchange is involved within the organization as well as outside the organization, there is high requirement for reliable, consistent, and platform-independent mode of data sharing especially with respect to multimedia files like audio and video files. The major problem with most of the relational database is its incompatible formats between computer systems. XML will be hardware and software independent thereby having full integration with any environments. Thus, this paper aims to convert or transform the multimedia files stored in the relational database into an xml document for data sharing in a distributed Environment. As XML is text based, data sharing becomes very easy and faster when compared to the multimedia files, thereby increasing the internet computing performance. By providing proper authentication details, the blob data stored in relational database can be fetched in a XML format that can be used independently for multiple purpose.