High Performance SQL Queries on Compressed Relational Database
|
| Title | High Performance SQL Queries on Compressed Relational Database |
| Authors | |
| 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. |
| Publisher | ACADEMY PUBLISHER |
| Date | 2009-12-01 |
| Source | Journal of Computers Vol 4, No 12 (2009): Special Issue: Selected Best Papers of 2008 International Workshop on Modellin |
| Rights | Copyright © ACADEMY PUBLISHER - All Rights Reserved.To request permission, please check out URL: http://www.academypublisher.com/copyrightpermission.html. |