Balancing Performance and Data Freshness in Web Database Servers

Summary: Online View Selection for web databases balances performance and data freshness via view materialization, decoupling serving from updates. Defines data freshness metrics, presents an adaptive online algorithm for the online view selection problem, and shows experimental validation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9182
Venue: VLDB
Year: 2003
Pagerank: 5.7707686e-05
Overall Rank: 6,795 | 53.39%
DOI: 10.1016/B978-012722442-8/50042-2

Incoming Non-self Citations Over Time

Authors

1. Alexandros Labrinidis (University of Pittsburgh)
2. Nick Roussopoulos (University of Maryland)

BibTeX Citation

@article{labrinidis_vldb03,
        title = {{Balancing Performance and Data Freshness in Web Database Servers}},
        author = {Labrinidis, Alexandros and Roussopoulos, Nick},
        journal = {PVLDB},
        series = {{VLDB} '03},
        doi = {10.1016/B978-012722442-8/50042-2},
        url = {https://doi.org/10.1016/B978-012722442-8/50042-2},
        year = {2003}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,770	Relaxed Currency and Consistency: How to Say "Good Enough" in SQL	2004	SIGMOD	8.1458395e-05
12,710	TRAC: Toward Recency and Consistency Reporting in a Database with Distributed Data Sources	2006	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
785	Middle-Tier Database Caching for e-Business	2002	SIGMOD	0.00014068999
929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD	0.00013152103
943	DynaMat: A Dynamic View Management System for Data Warehouses	1999	SIGMOD	0.00013068595
2,113	Caching Strategies for Data-Intensive Web Sites	2000	VLDB	9.149719e-05
2,231	Transparent Mid-Tier Database Caching in SQL Server	2003	SIGMOD	8.8980681e-05
2,274	A Comparative Study of Alternative Middle Tier Caching Solutions to Support Dynamic Web Content Acceleration	2001	VLDB	8.8228773e-05
2,456	WATCHMAN: A Data Warehouse Intelligent Cache Manager	1996	VLDB	8.5526697e-05
2,557	WebView Materialization	2000	SIGMOD	8.4161033e-05
4,586	DBCache: Middle-tier Database Caching for Highly Scalable e-Business Architectures	2003	SIGMOD	6.6173402e-05
6,270	Proxy-Based Acceleration of Dynamically Generated Content on the World Wide Web: An Approach and Implementation	2002	SIGMOD	5.9330107e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,787	Adapting Materialized Views after Redefinitions	1995	SIGMOD
2	39	Efficiently Updating Materialized Views	1986	SIGMOD
3	2,598	Enabling Dynamic Content Caching for Database-Driven Web Sites	2001	SIGMOD
4	1,743	Algorithms for Materialized View Design in Data Warehousing Environment	1997	VLDB
5	1,091	Incremental Maintenance of Externally Materialized Views	1996	VLDB
6	6,401	Analytical Modeling of Materialized View Maintenance	1988	PODS
7	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
8	5,117	View Invalidation for Dynamic Content Caching in Multitiered Architectures	2002	VLDB
9	2,557	WebView Materialization	2000	SIGMOD
10	4,453	Update Propagation Strategies for Improving the Quality of Data on the Web	2001	VLDB