NDLI: Update semantics of relational views

Content Provider	ACM Digital Library
Author	Bancilhon, F. Spyratos, N.
Copyright Year	1981
Abstract	A database view is a portion of the data structured in a way suitable to a specific application. Updates on views must be translated into updates on the underlying database. This paper studies the translation process in the relational model.The procedure is as follows: first, a “complete” set of updates is defined such thattogether with every update the set contains a “return” update, that is, one that brings the view back to the original state;given two updates in the set, their composition is also in the set.To translate a complete set, we define a mapping called a “translator,” that associates with each view update a unique database update called a “translation.” The constraint on a translation is to take the database to a state mapping onto the updated view. The constraint on the translator is to be a morphism.We propose a method for defining translators. Together with the user-defined view, we define a “complementary” view such that the database could be computed from the view and its complement. We show that a view can have many different complements and that the choice of a complement determines an update policy. Thus, we fix a view complement and we define the translation of a given view update in such a way that the complement remains invariant (“translation under constant complement”). The main result of the paper states that, given a complete set $\textit{U}$ of view updates, $\textit{U}$ has a translator if and only if $\textit{U}$ is translatable under constant complement.
Starting Page	557
Ending Page	575
Page Count	19
File Format	PDF
ISSN	03625915
e-ISSN	15574644
DOI	10.1145/319628.319634
Volume Number	6
Issue Number	4
Journal	ACM Transactions on Database Systems (TODS)
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	1981-12-01
Publisher Place	New York
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Conceptual model Data model Data semantics Database view Relation Relational model database Update translation View updating
Content Type	Text
Resource Type	Article
Subject	Information Systems

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

Extending the database relational model to capture more meaning

Updating Relational Databases through Object-Based Views (1991)

Updating Typical XML Views

Update semantics of relational views (1981)

Updating Relational Databases through Object-Based Views (1991)

On the correct translation of update operations on relational views

Updating XML Views Published Over Relational Databases: Towards the Existence of a Correct Update Mapping (2005)

Toward the Next Generation of Data Modeling Tools

Updating XML Views Published Over Relational Databases: Towards the Existence of a Correct Update Mapping (2004)

Update semantics of relational views

Similar Documents

Extending the database relational model to capture more meaning

Updating Relational Databases through Object-Based Views (1991)

Updating Typical XML Views

Update semantics of relational views (1981)

Updating Relational Databases through Object-Based Views (1991)

On the correct translation of update operations on relational views

Updating XML Views Published Over Relational Databases: Towards the Existence of a Correct Update Mapping (2005)

Toward the Next Generation of Data Modeling Tools

Updating XML Views Published Over Relational Databases: Towards the Existence of a Correct Update Mapping (2004)

Update semantics of relational views