Abstract
Most e-commerce Web sites dynamically generate their contents through a three-tier server architecture composed of a Web server, an application server, and a database server. In such an architecture, the database server easily becomes a bottleneck to the overall performance. In this paper, we propose WDBAccel, a high-performance database server accelerator that significantly improves the throughput of the database processing, and thus that of the overall Web site. WDBAccel eliminates costly, complex query processing needed to obtain query results by reusing previous query results for subsequent queries. This differentiates WDBAccel from other database cache systems, which replicate a database into multiple conventional DBMS’s and distribute queries among them. We evaluate the performance of WDBAccel by using the queries of the TPC-W benchmark. The measurement results show that WDBAccel outperforms DBMS-based cache systems by up to an order of magnitude.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Amiri, K.S., Park, S., Tewari, R., Padmanabhan, S.: DBProxy: A self-managing edge-of-network data cache. In: 19th IEEE International Conference on Data Engineering (2003)
Anton, J., Jacobs, L., Liu, X., Parker, J., Zeng, Z., Zhong, T.: Web caching for database applications with oracle web cache. In: Proceedings of ACM SIGMOD Conference (2002)
Candan, K.S., Li, W.-S., Luo, Q., Hsiung, W.-P., Agrawal, D.: Enabling dynamic content caching for database-driven web sites. In: Proceedings of ACM SIGMOD Conference, Santa Barbara, USA (2001)
Challenger, J., Iyengar, A., Witting, K., Ferstat, C., Reed, P.: A publishing system for efficiently creating dynamic web content. In: Proceedings of IEEE INFOCOM (2000)
Choi, S., Huh, S., Kim, S.M., Song, J., Lee, Y.-J.: An efficient update management mechanism for query result caching at databasedriven web sites (under submission)
Oracle Corporation. Oracle9ias cache, http://www.oracle.com/ip/deploy/ias/index.html?cache.html
Datta, A., Dutta, K., Thomas, H., VanderMeer, D.: Proxy-based acceleration of dynamically generated content on the world wide web: An approach and implementation. In: Proceedings of ACM SIGMOD Conference (2002)
Holmedahl, V., Smith, B., Yang, T.: Cooperative caching of dynamic content on a distributed web server. In: Proceedings of the 7th IEEE International Symposium on High Performance Distributed Computing (1998)
Luo, Q., Krishnamurthy, S., Mohan, C., Pirahesh, H., Woo, H., Lindsay, B.G., Naughton, J.F.: Middle-tier database caching for ebusiness. In: Proceedings of ACM SIGMOD Conference (2002)
Luo, Q., Naughton, J.F.: Form-based proxy caching for database-backed web sites. In: Proceedings of the 27th VLDB Conference, Roma, Italy (2001)
TimesTen Performance Software. Timesten library, http://www.timesten.com/library/index.html
Transaction Processing Performance Council (TPC). TPC benchmarkTMW (web commerce) specification version 1.4. February 7 (2001)
Yagoub, K., Florescu, D., Issarny, V., Valduriez, P.: Caching strategies for data-intensive web sites. In: Proceedings of the 26th VLDB Conference (2000)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Choi, S., Lee, J., Kim, S.M., Song, J., Lee, YJ. (2004). Accelerating Database Processing at e-Commerce Sites. In: Bauknecht, K., Bichler, M., Pröll, B. (eds) E-Commerce and Web Technologies. EC-Web 2004. Lecture Notes in Computer Science, vol 3182. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30077-9_5
Download citation
DOI: https://doi.org/10.1007/978-3-540-30077-9_5
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22917-9
Online ISBN: 978-3-540-30077-9
eBook Packages: Springer Book Archive