WebView Materialization Alexandros Labrinidis and Nick Roussopoulos   View Paper (PDF)   Return to Research Sessions Abstract A WebView is a web page automatically created from base data typically stored in a DBMS. Given the multi-tiered architecture behind database-backed web servers, we have the option of materializing a WebView inside the DBMS, at the web server, or not at all, always computing it on the fly (virtual). Since WebViews must be up to date, materialized WebViews are immediately refreshed with every update on the base data. In this paper we compare the three materialization policies (materialized inside the DBMS, materialized at the web server and virtual) analytically, through a detailed cost model, and quantitatively, through extensive experiments on an implemented system. Our results indicate that materializing at the web serveris a more scalable solution and can facilitate an order of magnitude more users than the virtual and materialized inside the DBMS policies, even under high update workloads. References Note: References link to DBLP on the Web. [AB99] Tarek F. Abdelzaher , Nina T. Bhatti : Web Content Adaptation to Improve Server Overload Behavior. WWW8 / Computer Networks 31(11-16) : 1563-1577(1999) [AMM98] Paolo Atzeni , Giansalvatore Mecca , Paolo Merialdo : Design and Maintenance of Data-Intensive Web Sites. EDBT 1998 : 436-450 [AMR+98] Serge Abiteboul , Jason McHugh , Michael Rys , Vasilis Vassalos , Janet L. Wiener : Incremental Maintenance for Materialized Views over Semistructured Data. VLDB 1998 : 38-49 [AW97] Martin F. Arlitt , Carey L. Williamson : Internet Web servers: workload characterization and performance implications. IEEE/ACM Transactions on Networking 5(5) : 631-645(1997) [BBC+98] Philip A. Bernstein , Michael L. Brodie , Stefano Ceri , David J. DeWitt , Michael J. Franklin , Hector Garcia-Molina , Jim Gray , Gerald Held , Joseph M. Hellerstein , H. V. Jagadish , Michael Lesk , David Maier , Jeffrey F. Naughton , Hamid Pirahesh , Michael Stonebraker , Jeffrey D. Ullman : The Asilomar Report on Database Research. SIGMOD Record 27(4) : 74-80(1998) [BCF+99] ... [BD+98] Randall G. Bello , Karl Dias , Alan Downing , James Feenan Jr. , William D. Norcott , Harry Sun , Andrew Witkowski , Mohamed Ziauddin : Materialized Views in Oracle. VLDB 1998 : 659-664 [CFP99] Stefano Ceri , Piero Fraternali , Stefano Paraboschi : Data-Driven, One-To-One Web Site Generation for Data-Intensive Applications. VLDB 1999 : 615-626 [CID99] ... [CZB98] ... [FFK+98] Mary F. Fernandez , Daniela Florescu , Jaewoo Kang , Alon Y. Levy , Dan Suciu : Catching the Boat with Strudel: Experiences with a Web-Site Management System. SIGMOD Conference 1998 : 414-425 [FLM98] Daniela Florescu , Alon Y. Levy , Alberto O. Mendelzon : Database Techniques for the World-Wide Web: A Survey. SIGMOD Record 27(3) : 59-74(1998) [FLSY99] Daniela Florescu , Alon Y. Levy , Dan Suciu , Khaled Yagoub : Optimization of Run-time Management of Data Intensive Web-sites. VLDB 1999 : 627-638 [GM95] Ashish Gupta , Inderpal Singh Mumick : Maintenance of Materialized Views: Problems, Techniques, and Applications. Data Engineering Bulletin 18(2) : 3-18(1995) [GM99] ... [Gre99] ... [Gup97] Himanshu Gupta : Selection of Views to Materialize in a Data Warehouse. ICDT 1997 : 98-112 [IC97] ... [KR99] Yannis Kotidis , Nick Roussopoulos : DynaMat: A Dynamic View Management System for Data Warehouses. SIGMOD Conference 1999 : 371-382 [LISD99] ... [LR99] Alexandros Labrinidis , Nick Roussopoulos : On the Materialization of WebViews. WebDB (Informal Proceedings) 1999 : 79-84 [LR00a] Alexandros Labrinidis , Nick Roussopoulos : Generating Dynamic Content at Database-Backed Web Servers: cgi-bin vs. mod_perl. SIGMOD Record 29(1) : 26-31(2000) [LR00b] ... [Mal98] Susan Malaika : Resistance is Futile: The Web Will Assimilate Your Database. Data Engineering Bulletin 21(2) : 4-13(1998) [MMM98] Giansalvatore Mecca , Alberto O. Mendelzon , Paolo Merialdo : Efficient Queries over Web Views. EDBT 1998 : 72-86 [Rou98] Nick Roussopoulos : Materialized Views and Data Warehouses. SIGMOD Record 27(1) : 21-26(1998) [Sin98] Giuseppe Sindoni : Management of Hypertextual Views. WebDB 1998 : 98-117 BIBTEX @inproceedings{DBLP:conf/sigmod/LabrinidisR00,   author    = {Alexandros Labrinidis and                 Nick Roussopoulos},    editor    = {Weidong Chen and                 Jeffrey F. Naughton and                 Philip A. Bernstein},    title     = {WebView Materialization},    booktitle = {Proceedings of the 2000 ACM SIGMOD International Conference on                 Management of Data, May 16-18, 2000, Dallas, Texas, USA},    journal   = {SIGMOD Record},    publisher = {ACM},    volume    = {29},    number    = {2},    year      = {2000},    isbn      = {1-58113-218-2},    pages     = {367-378},    crossref  = {DBLP:conf/sigmod/2000},    bibsource = {DBLP, http://dblp.uni-trier.de} } }, DiSC'01 Copyright ©2002 ACM Inc.