Database Scheme Optimization For Online Applications

• Autorzy: Marszałkowski J. , Marszałkowski Jędrzej , Musial J.
• Języki publikacji: EN

Abstrakty

EN

With a rapid growth of Internet usage, e-commerce projects, such as content management systems, on-line shops, social networking pages, and online web- based gaming, meet new performance challenges. In this note we enclose information on database systems using MySQL working in the background of web-based applications. Effect of table name length in simple queries is measured in experimental environment. Conclusions over execution time and amounts of data sent are made. Moreover, comparison performance tests for long and short table names are made on a model and two real web-based applications. Finally, simple yet effective database scheme optimization is proposed.

Słowa kluczowe

EN

database; database scheme optimization; MySQL; e-commerce; web-based applications

• Wydawca: Wydawnictwo Politechniki Poznańskiej
• Czasopismo: Foundations of Computing and Decision Sciences
• Rocznik: 2011
• Tom: Vol. 36, No. 2
• Strony: 121--129
• Opis fizyczny: Bibliogr. 15 poz.

Twórcy

autor

Marszałkowski J.

autor

Marszałkowski Jędrzej

autor

Musial J.

• Poznan University of Technology, ul. Piotrowo 2, 60-965 Poznan, Poland,

Bibliografia

• [1] Alexa Rank, www.alexa.com, (last seen: October 2010).
• [2] J. Blażewicz, M.Y. Kovalyov, J. Musiał, A.P. Urbański and A. Wojciechowski. Internet Shopping Optimization Problem. International Journal of Applied Mathematics and Computer Science, 20, 2, 2010, 385-390.
• [3] Chu W., Choi B., Song MR, The Role of On-line Retailer Brand and Infomediary Reputation in Increasing Consumer Purchase Intention, International Journal of Electronic Commerce, 9, 3, 2005, 115-127.
• [4] Główny Urząd Statystyczny (Central Statistical Office of Poland), http://www.stat.gov.pl/gus, (last seen: October 2010).
• [5] Holsapple C. et. al., Decision Support Applications in Electronic Commerce in: Shaw M. et al. (eds.), Handbook on Electronic Commerce, Springer-Verlag, Berlin Heidelberg, 2000.
• [6] Internet Usage Statistics, Internet World Stats, http://www.internetworldstats.com/stats.htm, (last seen: October 2010).
• [7] George Lawton, LAMP Lights Enterprise Development Efforts, Computer, 9, 38, 2005, 18-20.
• [8] MySQL AB, MySQL: The World's Most Popular Open Source Database http://www.mysql.org (last seen: November 2010).
• [9] Netcraft Ltd., Most Reliable Hosting Company Sites in May 2009, http://news.netcraft.com/archives/2009/06/02/ (last seen: November 2010).
• [10] Ng B.D., Wiemer-Hastings P., Addiction to the Internet and Online Gaming, Cyber Psychology & Behavior, 8, 2, 2005, 110-113.
• [11] Pew Internet &; American Life Project. On-line Shopping, http://www.pewinternet.org/Reports/2OO8/Online-Shopping.aspx, (last seen: October 2010).
• [12] Shreves, R., Open Source CMS market Share., Water & Stone, 2008.
• [13] The Future Foundation. E-commerce across Europe - Progress and prospects, 2008.
• [14] Zawodny, J., Balling, D., High Performance MySQL, O'Reilly Media, 2004.
• [15] Wojciechowski A., Musial J., Towards Optimal Multi-item Shopping Basket Management: Heuristic Approach, in: R. Meersman et al. (eds.), OTM 2010 Workshops, LNCS, 6428, Springer, Heidelberg, 2010, 349-357.