An adaptive peer-to-peer network for distributed caching of OLAP results

Panos Kalnis*, Wee Siong Ng, Beng Chin Ooi, Dimitris Papadias, Kian Lee Tan

*Corresponding author for this work

Research output: Contribution to journalConference articlepeer-review

80 Scopus citations


Peer-to-Peer (P2P) systems are becoming increasingly popular as they enable users to exchange digital information by participating in complex networks. Such systems are inexpensive, easy to use, highly scalable and do not require central administration. Despite their advantages, however, limited work has been done on employing database systems on top of P2P networks. Here we propose the PeerOLAP architecture for supporting On-Line Analytical Processing queries. A large number of low-end clients, each containing a cache with the most useful results, are connected through an arbitrary P2P network. If a query cannot be answered locally (i.e. by using the cache contents of the computer where it is issued), it is propagated through the network until a peer that has cached the answer is found. An answer may also be constructed by partial results from many peers. Thus PeerOLAP acts as a large distributed cache, which amplifies the benefits of traditional client-side caching. The system is fully distributed and can reconfigure itself on-the-fly in order to decrease the query cost for the observed workload. This paper describes the core components of PeerOLAP and presents our results both from simulation and a prototype installation running on geographically remote peers.

Original languageEnglish (US)
Pages (from-to)25-36
Number of pages12
JournalProceedings of the ACM SIGMOD International Conference on Management of Data
StatePublished - 2002
EventACM SIGMOD 2002 Proceedings of the ACM SIGMOD International Conference on Managment of Data - Madison, WI, United States
Duration: Jun 3 2002Jun 6 2002

ASJC Scopus subject areas

  • Software
  • Information Systems


Dive into the research topics of 'An adaptive peer-to-peer network for distributed caching of OLAP results'. Together they form a unique fingerprint.

Cite this