NDLI: Incremental View Maintenance By Base Relation Tagging in Distributed Databases

Content Provider	Springer Nature Link
Author	Bailey, James Dong, Guozhu Mohania, Mukesh Wang, X. Sean
Copyright Year	1998
Abstract	The incremental view maintenance problem deals with the efficient updating of materialized views in response to updates to base relations. This paper considers the problem in a distributed database environment, with communication cost minimization as the primary objective. The views considered are defined based on the relational join operation. The approach is to use “yes”/“no” tags as auxiliary data on tuples in the base relations to indicate whether the tuples participate in joins. These tags will help avoid sending irrelevant data over the network and thus reduce the communication cost. Two basic view maintenance algorithms are proposed using the tags. In addition to reducing communication costs, an important feature of these two basic algorithms is that they derive the “exact change” to views without looking at the old views. This feature allows us to maintain certain aggregates on views without actually materializing the views themselves; this feature is useful in applications such as active databases where many conditions or constraints must be tested whenever updates occur, since a condition is true exactly when some corresponding view has nonzero number of tuples. The paper then combines the use of tags with the counting algorithm to derive a tagged counting algorithm that further reduces the communication cost. The paper illustrates the algorithms by examples and studies their performance via a statistical analysis. The illustrating examples and the performance analysis show that, under uniform distribution with reasonable join participation rates, the use of tags significantly improves the efficiency of view maintenance over similar algorithms without tags. The performance analysis also identifies the situations where a particular algorithm is superior to others. The use of tags for memoing values of subexpressions in a view definition is also explored in the paper.
Starting Page	287
Ending Page	309
Page Count	23
File Format	PDF
ISSN	09268782
Journal	Distributed and Parallel Databases
Volume Number	6
Issue Number	3
e-ISSN	15737578
Language	English
Publisher	Kluwer Academic Publishers
Publisher Date	1998-01-01
Publisher Place	Boston
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Processor Architectures Computer Communication Networks Data Structures, Cryptology and Information Theory Information Storage and Retrieval
Content Type	Text
Resource Type	Article
Subject	Information Systems and Management Information Systems Software Hardware and Architecture

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

Consistency Algorithms for Multi-Source Warehouse View Maintenance

A Low-Cost Checkpointing Technique for Distributed Databases

Distributed Multi-Level Recovery in Main-Memory Databases

Adaptive Join Algorithms in Dynamic Distributed Databases

Logically Clustered Architectures for Networked Databases

Distributed Enforcement of Integrity Constraints

Distributed Processing of Similarity Queries

Shared State for Distributed Interactive Data Mining Applications

Ontological Approach for Information Discovery in Internet Databases

Incremental View Maintenance By Base Relation Tagging in Distributed Databases

Similar Documents

Consistency Algorithms for Multi-Source Warehouse View Maintenance

A Low-Cost Checkpointing Technique for Distributed Databases

Distributed Multi-Level Recovery in Main-Memory Databases

Adaptive Join Algorithms in Dynamic Distributed Databases

Logically Clustered Architectures for Networked Databases

Distributed Enforcement of Integrity Constraints

Distributed Processing of Similarity Queries

Shared State for Distributed Interactive Data Mining Applications

Ontological Approach for Information Discovery in Internet Databases

Incremental View Maintenance By Base Relation Tagging in Distributed Databases