Evaluations of architectural designs and implementation for database-driven web sites

Wen Syan Li, Wang Pin Hsiung, Oliver Po, K. Selçuk Candan, Divyakant Agrawal

Research output: Contribution to journalArticle

8 Citations (Scopus)

Abstract

Response time is a key differentiation point among electronic commerce (e-commerce) applications. For many e-commerce applications, Web pages are created dynamically based on the current business state, stored in database systems. The architecture of database-driven e-commerce Web sites are more complex than that of typical Web sites. It requires integration of Web servers, application servers, and back-end database systems as well as synchronization of multiple databases if caches are used for acceleration of content delivery. In this paper, we analyze the factors that impact the performance and scalability of a database-driven Web site. We experimentally test (1) the performance metrics of database update, query, and synchronization; (2) trigger overhead; and (3) application server (AS) and database connection overhead and constraints. We describe several architectural design approaches for database-driven Web sites and present experimental results on their performance under various conditions, including varying request rates, update-to-request ratio, cache hit ratio, number of regional AS/data cache suites deployed, and database size. We also discuss how to handle Web page requests that involve SSL, cookies, and fragment pages (i.e. by frame or JSP).

Original languageEnglish
Pages (from-to)151-177
Number of pages27
JournalData and Knowledge Engineering
Volume43
Issue number2
DOIs
Publication statusPublished - 1 Nov 2002
Externally publishedYes

Fingerprint

Architectural design
Websites
Electronic commerce
Servers
Synchronization
Evaluation
Web sites
Data base
World Wide Web
Scalability

Keywords

  • Application server
  • Cookie
  • Database cache
  • Dynamic content caching
  • Electronic commerce
  • Fragment page
  • i-cache
  • SSL
  • Web acceleration

ASJC Scopus subject areas

  • Artificial Intelligence

Cite this

Evaluations of architectural designs and implementation for database-driven web sites. / Li, Wen Syan; Hsiung, Wang Pin; Po, Oliver; Candan, K. Selçuk; Agrawal, Divyakant.

In: Data and Knowledge Engineering, Vol. 43, No. 2, 01.11.2002, p. 151-177.

Research output: Contribution to journalArticle

Li, Wen Syan ; Hsiung, Wang Pin ; Po, Oliver ; Candan, K. Selçuk ; Agrawal, Divyakant. / Evaluations of architectural designs and implementation for database-driven web sites. In: Data and Knowledge Engineering. 2002 ; Vol. 43, No. 2. pp. 151-177.
@article{ae6205d39af54d35be31b716fc917dbd,
title = "Evaluations of architectural designs and implementation for database-driven web sites",
abstract = "Response time is a key differentiation point among electronic commerce (e-commerce) applications. For many e-commerce applications, Web pages are created dynamically based on the current business state, stored in database systems. The architecture of database-driven e-commerce Web sites are more complex than that of typical Web sites. It requires integration of Web servers, application servers, and back-end database systems as well as synchronization of multiple databases if caches are used for acceleration of content delivery. In this paper, we analyze the factors that impact the performance and scalability of a database-driven Web site. We experimentally test (1) the performance metrics of database update, query, and synchronization; (2) trigger overhead; and (3) application server (AS) and database connection overhead and constraints. We describe several architectural design approaches for database-driven Web sites and present experimental results on their performance under various conditions, including varying request rates, update-to-request ratio, cache hit ratio, number of regional AS/data cache suites deployed, and database size. We also discuss how to handle Web page requests that involve SSL, cookies, and fragment pages (i.e. by frame or JSP).",
keywords = "Application server, Cookie, Database cache, Dynamic content caching, Electronic commerce, Fragment page, i-cache, SSL, Web acceleration",
author = "Li, {Wen Syan} and Hsiung, {Wang Pin} and Oliver Po and Candan, {K. Sel{\cc}uk} and Divyakant Agrawal",
year = "2002",
month = "11",
day = "1",
doi = "10.1016/S0169-023X(02)00054-X",
language = "English",
volume = "43",
pages = "151--177",
journal = "Data and Knowledge Engineering",
issn = "0169-023X",
publisher = "Elsevier",
number = "2",

}

TY - JOUR

T1 - Evaluations of architectural designs and implementation for database-driven web sites

AU - Li, Wen Syan

AU - Hsiung, Wang Pin

AU - Po, Oliver

AU - Candan, K. Selçuk

AU - Agrawal, Divyakant

PY - 2002/11/1

Y1 - 2002/11/1

N2 - Response time is a key differentiation point among electronic commerce (e-commerce) applications. For many e-commerce applications, Web pages are created dynamically based on the current business state, stored in database systems. The architecture of database-driven e-commerce Web sites are more complex than that of typical Web sites. It requires integration of Web servers, application servers, and back-end database systems as well as synchronization of multiple databases if caches are used for acceleration of content delivery. In this paper, we analyze the factors that impact the performance and scalability of a database-driven Web site. We experimentally test (1) the performance metrics of database update, query, and synchronization; (2) trigger overhead; and (3) application server (AS) and database connection overhead and constraints. We describe several architectural design approaches for database-driven Web sites and present experimental results on their performance under various conditions, including varying request rates, update-to-request ratio, cache hit ratio, number of regional AS/data cache suites deployed, and database size. We also discuss how to handle Web page requests that involve SSL, cookies, and fragment pages (i.e. by frame or JSP).

AB - Response time is a key differentiation point among electronic commerce (e-commerce) applications. For many e-commerce applications, Web pages are created dynamically based on the current business state, stored in database systems. The architecture of database-driven e-commerce Web sites are more complex than that of typical Web sites. It requires integration of Web servers, application servers, and back-end database systems as well as synchronization of multiple databases if caches are used for acceleration of content delivery. In this paper, we analyze the factors that impact the performance and scalability of a database-driven Web site. We experimentally test (1) the performance metrics of database update, query, and synchronization; (2) trigger overhead; and (3) application server (AS) and database connection overhead and constraints. We describe several architectural design approaches for database-driven Web sites and present experimental results on their performance under various conditions, including varying request rates, update-to-request ratio, cache hit ratio, number of regional AS/data cache suites deployed, and database size. We also discuss how to handle Web page requests that involve SSL, cookies, and fragment pages (i.e. by frame or JSP).

KW - Application server

KW - Cookie

KW - Database cache

KW - Dynamic content caching

KW - Electronic commerce

KW - Fragment page

KW - i-cache

KW - SSL

KW - Web acceleration

UR - http://www.scopus.com/inward/record.url?scp=0036834729&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0036834729&partnerID=8YFLogxK

U2 - 10.1016/S0169-023X(02)00054-X

DO - 10.1016/S0169-023X(02)00054-X

M3 - Article

VL - 43

SP - 151

EP - 177

JO - Data and Knowledge Engineering

JF - Data and Knowledge Engineering

SN - 0169-023X

IS - 2

ER -