Updates through views: A new hope

Yannis Kotidis; Divesh Srivastava; Yannis Velegrakis

doi:10.1109/ICDE.2006.167

Updates through views: A new hope

Yannis Kotidis^*, Divesh Srivastava, Yannis Velegrakis

^*Corresponding author for this work

Sub Data Intensive Systems

AT&T

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › Academic › peer-review

Abstract

Database views are extensively used to represent unmaterialized tables. Applications rarely distinguish between a materialized base, table and a virtual view, thus, they may issue update requests on the views. Since views are virtual, update requests on them, need to be translated to updates on the base tables. Existing literature has shown the difficulty of translating view updates in a side-effect free manner. To address this problem, we propose a novel approach for separating the data instance into a logical and a physical level. This separation allows us to achieve side-effect free translations of any kind of update on the view. Furthermore, deletes on a view can be translated without affecting the base tables. We describe the implementation of the framework and present our experimental results

Original language	English
Title of host publication	Proceedings of the 22nd International Conference on Data Engineering, ICDE '06
Number of pages	1
Volume	2006
DOIs	https://doi.org/10.1109/ICDE.2006.167
Publication status	Published - 17 Oct 2006
Event	22nd International Conference on Data Engineering, ICDE '06 - Atlanta, GA, United States Duration: 3 Apr 2006 → 7 Apr 2006

Conference

Conference	22nd International Conference on Data Engineering, ICDE '06
Country/Territory	United States
City	Atlanta, GA
Period	3/04/06 → 7/04/06

Access to Document

10.1109/ICDE.2006.167

Cite this

@inproceedings{42c95d9c35124eb9bc9dc58855f8416a,

title = "Updates through views: A new hope",

abstract = "Database views are extensively used to represent unmaterialized tables. Applications rarely distinguish between a materialized base, table and a virtual view, thus, they may issue update requests on the views. Since views are virtual, update requests on them, need to be translated to updates on the base tables. Existing literature has shown the difficulty of translating view updates in a side-effect free manner. To address this problem, we propose a novel approach for separating the data instance into a logical and a physical level. This separation allows us to achieve side-effect free translations of any kind of update on the view. Furthermore, deletes on a view can be translated without affecting the base tables. We describe the implementation of the framework and present our experimental results",

author = "Yannis Kotidis and Divesh Srivastava and Yannis Velegrakis",

year = "2006",

month = oct,

day = "17",

doi = "10.1109/ICDE.2006.167",

language = "English",

isbn = "0769525709",

volume = "2006",

booktitle = "Proceedings of the 22nd International Conference on Data Engineering, ICDE '06",

note = "22nd International Conference on Data Engineering, ICDE '06 ; Conference date: 03-04-2006 Through 07-04-2006",

}

TY - GEN

T1 - Updates through views

T2 - 22nd International Conference on Data Engineering, ICDE '06

AU - Kotidis, Yannis

AU - Srivastava, Divesh

AU - Velegrakis, Yannis

PY - 2006/10/17

Y1 - 2006/10/17

N2 - Database views are extensively used to represent unmaterialized tables. Applications rarely distinguish between a materialized base, table and a virtual view, thus, they may issue update requests on the views. Since views are virtual, update requests on them, need to be translated to updates on the base tables. Existing literature has shown the difficulty of translating view updates in a side-effect free manner. To address this problem, we propose a novel approach for separating the data instance into a logical and a physical level. This separation allows us to achieve side-effect free translations of any kind of update on the view. Furthermore, deletes on a view can be translated without affecting the base tables. We describe the implementation of the framework and present our experimental results

AB - Database views are extensively used to represent unmaterialized tables. Applications rarely distinguish between a materialized base, table and a virtual view, thus, they may issue update requests on the views. Since views are virtual, update requests on them, need to be translated to updates on the base tables. Existing literature has shown the difficulty of translating view updates in a side-effect free manner. To address this problem, we propose a novel approach for separating the data instance into a logical and a physical level. This separation allows us to achieve side-effect free translations of any kind of update on the view. Furthermore, deletes on a view can be translated without affecting the base tables. We describe the implementation of the framework and present our experimental results

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

U2 - 10.1109/ICDE.2006.167

DO - 10.1109/ICDE.2006.167

M3 - Conference contribution

AN - SCOPUS:33749625908

SN - 0769525709

SN - 9780769525709

VL - 2006

BT - Proceedings of the 22nd International Conference on Data Engineering, ICDE '06

Y2 - 3 April 2006 through 7 April 2006

ER -

Updates through views: A new hope

Abstract

Conference

Access to Document

Other files and links

Fingerprint

Cite this