Volume 4 Number 12 (Dec. 2009)
Home > Archive > 2009 > Volume 4 Number 12 (Dec. 2009) >
JCP 2009 Vol.4(12): 1263-1274 ISSN: 1796-203X
doi: 10.4304/jcp.4.12.1263-1274

High Performance SQL Queries on Compressed Relational Database

Mohammad Masumuzzaman Bhuiyan1, Abu Sayed Md. Latiful Hoque2
1Department of Computer Science and Mathematics Bangladesh Agricultural University, Mymensingh, Bangladesh
2Department of Computer Science and Engineering Bangladesh University of Engineering and Technology, Dhaka, Bangladesh


Abstract—Loss-less data compression is potentially attractive in database application for storage cost reduction and performance improvement. The existing compression architectures work well for small to large database and provide good performance. But these systems can execute a limited number of queries executed on single table. We have developed a disk-based compression architecture, called DHIBASE, to support large database and at the same time, perform high performance SQL queries on single or multiple tables in compressed form. We have compared our system with widely used Microsoft SQL Server. Our system performs significantly better than SQL Server in terms of storage requirement and query response time. DHIBASE requires 10 to 15 times less space and for some operation it is 18 to 22 times faster. As the system is column oriented, schema evolution is easy.

Index Terms—Compressed database, high performance query.

[PDF]

Cite: Mohammad Masumuzzaman Bhuiyan, Abu Sayed Md. Latiful Hoque, "High Performance SQL Queries on Compressed Relational Database," Journal of Computers vol. 4, no. 12, pp. 1263-1274, 2009.

General Information

ISSN: 1796-203X
Abbreviated Title: J.Comput.
Frequency: Monthly
Editor-in-Chief: Prof. Liansheng Tan
Executive Editor: Ms. Nina Lee
Abstracting/ Indexing: DBLP, EBSCO,  ProQuest, INSPEC, ULRICH's Periodicals Directory, WorldCat, CNKI,etc
E-mail: jcp@iap.org
  • Aug 16, 2019 News!

    Vol 14, No 8 has been published with online version   [Click]

  • Jul 19, 2019 News!

    Vol 14, No 7 has been published with online version   [Click]

  • Jun 21, 2019 News!

    Vol 14, No 6 has been published with online version   [Click]

  • Apr 28, 2019 News!

    Vol 14, No 5 has been published with online version 7 papers are published in this issue after peer review   [Click]

  • Mar 20, 2019 News!

    Vol 14, No 3 has been published with online version   [Click]

  • Read more>>