EVALUATION OF A READ-OPTIMIZED DATABASE FOR DYNAMIC WEB APPLICATIONS

Anderson Supriano, Gustavo M. D. Vieira, Luiz E. Buzato

2008

Abstract

In this paper we investigate the use of a specialized data warehousing database management system as a data back-end for web applications and assess the performance of this solution. We have used the Monet database as a drop-in replacement for traditional databases, and performed benchmarks comparing its performance to the performance of two of the most commonly used databases for web applications: MySQL and PostgreSQL. Our main contribution is to show for the first time how a read-optimized database performs in comparison to established general purpose database management systems for the domain of web applications. Monet’s performance in relation to MySQL and PostgresSQL allows us to affirm that the widely accepted assumption that relational database management systems are fit for all applications can be reconsidered in the case of dynamic web applications.

References

  1. Amza, C., Chanda, A., Cox, A. L., Elnikety, S., Gil, R., Rajamani, K., Zwaenepoel, W., Cecchet, E., and Marguerite, J. (2002). Specification and implementation of dynamic web site benchmarks. In WWC-5: Proceedings of the IEEE International Workshop on Workload Characterization, pages 3-13.
  2. Boncz, P. A. (2002). Monet: A Next-Generation DBMS Kernel For Query-Intensive Applications. Ph.d. thesis, Universiteit van Amsterdam, Amsterdam, The Netherlands.
  3. Boncz, P. A., Zukowski, M., and Nes, N. (2005). MonetDB/X100: Hyper-pipelining query execution. In CIDR 2005: Proceedings of the Second Biennial Conference on Innovative Data Systems Research, pages 225-237.
  4. Cain, H. W., Rajwar, R., Marden, M., and Lipasti, M. H. (2001). An architectural evaluation of Java TPC-W. In HPCA 7801: Proceedings of the Seventh International Symposium on High-Performance Computer Architecture, pages 229-240, Monterrey, Mexico.
  5. García, D. F. and García, J. (2003). TPC-W e-commerce benchmark evaluation. Computer, 36(2):42-48.
  6. Harizopoulos, S., Liang, V., Abadi, D. J., and Madden, S. (2006). Performance tradeoffs in read-optimized databases. In VLDB 2006: Proceedings of the 32nd international conference on Very large data bases, pages 487-498. VLDB Endowment.
  7. Menascé, D. A. (2002). TPC-W: A benchmark for ecommerce. IEEE Internet Computing, 6(3):83-87.
  8. Stonebraker, M., Abadi, D. J., Batkin, A., Chen, X., Cherniack, M., Ferreira, M., Lau, E., Lin, A., Madden, S., O'Neil, E., O'Neil, P., Rasin, A., Tran, N., and Zdonik, S. (2005). C-Store: a column-oriented dbms. In VLDB 7805: Proceedings of the 31st international conference on Very large data bases, pages 553-564. VLDB Endowment.
  9. Stonebraker, M., Bear, C., C¸etintemel, U., Cherniack, M., Ge, T., Hachem, N., Harizopoulos, S., Lifter, J., Rogers, J., and Zdonik, S. (2007). One size fits all? Part 2: Benchmarking studies. In CIDR 2007: Proceedings of the Third Biennial Conference on Innovative Data Systems Research.
  10. Stonebraker, M. and C¸etintemel, U. (2005). “One size fits all”: An idea whose time has come and gone. In ICDE 7805: Proceedings of the 21st International Conference on Data Engineering, pages 2-11, Washington, DC, USA. IEEE Computer Society.
  11. TPC (2002). TPC Benchmark W Specification.
  12. TPC (2006). TPC Benchmark H Specification.
Download


Paper Citation


in Harvard Style

Supriano A., M. D. Vieira G. and E. Buzato L. (2008). EVALUATION OF A READ-OPTIMIZED DATABASE FOR DYNAMIC WEB APPLICATIONS . In Proceedings of the Fourth International Conference on Web Information Systems and Technologies - Volume 1: WEBIST, ISBN 978-989-8111-26-5, pages 73-80. DOI: 10.5220/0001515900730080


in Bibtex Style

@conference{webist08,
author={Anderson Supriano and Gustavo M. D. Vieira and Luiz E. Buzato},
title={EVALUATION OF A READ-OPTIMIZED DATABASE FOR DYNAMIC WEB APPLICATIONS},
booktitle={Proceedings of the Fourth International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,},
year={2008},
pages={73-80},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001515900730080},
isbn={978-989-8111-26-5},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Fourth International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,
TI - EVALUATION OF A READ-OPTIMIZED DATABASE FOR DYNAMIC WEB APPLICATIONS
SN - 978-989-8111-26-5
AU - Supriano A.
AU - M. D. Vieira G.
AU - E. Buzato L.
PY - 2008
SP - 73
EP - 80
DO - 10.5220/0001515900730080