Article

Free access

Updaies of relational views

Authors:

Stavros S. Cosmadakis,

Christos H. PapadimitriouAuthors Info & Claims

PODS '83: Proceedings of the 2nd ACM SIGACT-SIGMOD symposium on Principles of database systems

Pages 317 - 331

https://doi.org/10.1145/588058.588096

Published: 21 March 1983 Publication History

Abstract

We study the problem of translating updates of database views. View updates are disambiguated by requning that a specified view complement (i.e. a second view which contnms all the information omitted from the given view) remains constant during the translation. We study some of the computational problems related to the application of this general methodology in the context of relational databases. We restrict our attention to projective views of databases which consist of a single relation and satisfy functional dependencies. We first characterize complementary views and show that finding a minimum complement of a given view is NP-complete. We then study in detail the problem of translating the insertion of a tuple into a view and extend our results to the cases of deletion and replacement of a tuple. Finally we define and study a new kind of dependencies the explicit functional dependencies, which intuitively state that some part of the database information can be computed from the rest.

References

[1]

{Ar} Armstrong W W Dependency structures of database relationships Proc II IP 74 North Holland, Amsterdam, 1974 pp 580-583

[2]

{As} Astrahan M M et al System R Relational approach to database management ACM Iransactions on Database Systems I 2 (June 1976) 97-137

Digital Library

[3]

{BB} Beeri C and Bernstein, P A Computational problems related to the design of normal form relational schemas ACM Iransactions on Database Systems 4, 1 (March 1979), 30-59

Digital Library

[4]

{BBG} Beeri C, Bernstein, P A and Goodman N A sophisticate's introduction to database normalization theory In Proc 4th VLDB Conference West Berlin, September 1978

[5]

{BS} Bancilhon, F and Spyratos, N Update semantics of relational views ACM Transactions on Database Systems 6 4 (December 1981), 557-575

Digital Library

[6]

{BV} Beeri, C, and Vardi, M Y On the complexity of testing implications of data dependencies Research Report Department of Computer Science, The Hebrew University of Jerusalem, Jerusalem, Israel, December 1980

[7]

{Ca} Carlson, C R and Arora, A K The updatability of relational views based on functional dependencies Third International Computer Software and Applications Conference, IEEE Computer Society, Chicago, IL, November 1979

[8]

{Ch} Chamberlin, D D, et al Views authorization and locking in a relational data base system In Proc 1975 Nat Computer Conf, AFIPS Press Arlington, Va

[9]

{Co1} Codd, E F A relational model for large shared data banks Communications of the ACM 13, 6 (June 1970) 377-387

Digital Library

[10]

{Co2} Codd F F Relational completeness of database sublanguages In Data Base Systems R Rustin, Ed, Prentice Hall, Englewood Cliffs, N J, 1972, pp 65 98

[11]

{Co3} Codd, E F Further normalization of the database relational model In Database Systems, R Rustin, Ed Prentice Hall, Englewood Cliffs, N J, 1972, pp 33 64

[12]

{Co4} Codd, F F Extending the database relational model to capture more meaning ACM Transactions on Database Systems 4, 4 (December 1979) 397-434

Digital Library

[13]

{Ck} Cook, S A The complexity of theorem proving procedures proceedings of the 3rd Annual ACM Symposium on the Theory of Computing Shaker Heights, Ohio May 1971, pp 151-158

Digital Library

[14]

{CO} CODASYL Data Base Task Group April 71 Report, ACM, New York

[15]

{D} Date, C J An Introduction to Database Systems Addison Wesley Reading, Mass, 1977

Digital Library

[16]

{DB} Dayal U, and Bernstein P A On the updatability of relational views In Proc 4th VLDB Conference, West Berlin, September 1978

[17]

{F} Fagin, R Multivalued dependencies and a new normal form for relational databases ACM Transactions on Database Systems 2, 3 (September 1977), 262-278

Digital Library

[18]

{FSD} Furtado, A L, Sevcik, K C, and Dos Santos, C S Permitting Updates through views of data bases Information Systems 4, 4 (1979), 269-283

[19]

{GJ} Garey, M R and Johnson D S Computers and Intractability A Guide to the Theory of NP completeness (Freeman, San Francisco, CA, 1979)

Digital Library

[20]

{I} IMS/VS publications, IBM, White Plains, New York

[21]

{K} Karp R M Reducibility among combinatorial problems In Complexity of Computer Computations, R E Miller and J W Thatcher, Eds Plenum Press, New York, 1972, pp 85-104

[22]

{MMS} Maier, D, Mendelzon, A O, and Sagiv, Y Testing implications of data dependencies ACM Transactions on Database Systems 4, 4 (December 1979), 455-469

Digital Library

[23]

{MSY} Maier, D, Sagiv, Y, and Yannakakis, M On the complexity of testing implications of functional and join dependencies JACM 28, 4 (October 1981), 680-695

Digital Library

[24]

{R1} Rissanen, J Independent components of relations ACM Transactions on Database Systems 2, 4 (December 1977), 317 325

Digital Library

[25]

{R2} Rissanen, J Theory of relations for databases --- a tutorial survey Proc 7th Symp on Mathematical Foundations of Computer Science, Lecture Notes in Computer Science 64, Springer Verlag, Berlin, Heidelberg, 1978, pp 536-551

[26]

{RS} Rowe, L, Stonebraker, M Manuscript, U C Berkeley, 1979

[27]

{Sp} Spyratos, N Translation structures of relational views In Proc 6th VLDB Conference, Montreal, 1980

[28]

{St} Stockmeyer, L J The polvnomial time hierarchy Theoretical Computer Science 3, 1 (1976), 1-22

[29]

{SDSF} Sagiv, Y, Delobel, C, Stott Parker Jr, D, and Fagin, R An equivalence between relational database dependencies and a fragment of propositional logic Journal of the ACM 28, 3 (July 1981), 435-453

Digital Library

[30]

{SWKH} Stonebraker, M, Wong E, Kreps, P, and Held, G The design and implementation of INGRES ACM Transactions on Database Systems 1, 3 (September 1976), 189-222

Digital Library

[31]

{T} Todd, S J P The Peterlee relational test vehicle --- a system overview IBM Systems Journal 15, 4, 285-308

Digital Library

[32]

{U1} Ullman, J D Principles of Database Systems Computer Science Press, Rockville, Maryland, 1980

[33]

{U2} Ullman, J D The U R strikes back Proc of the ACM Symp on Principles of Database Systems Los Angeles, California, 1982

Digital Library

[34]

{V1} Vardi, M Y On decomposition of relational databases Proceedings of the 23rd Symposium on Foundations of Computer Science Chicago Illinois, 1982

[35]

{V2} Vardi M Y Infclring multivalued dependencies from functional and join dependencies Research Report, Dep of Applied Mathematics, Weizmann Institute of Science, Rehovot, Israel March 1980

[36]

{W} Wrathall C Complete sets and the polynomial-time hierarchy Theoretical Computer Science 3, 1, (1976), 23-33

[37]

{Za1} Zaniolo, C Analysis and design of relational schemata for database systems Tech Rep UCLA-ENG 7669, Dep of Computer Science, University of California, Los Angeles, California, July 1976

[38]

{Za2} Zaniolo C Database relations with null values Proc of the ACM Symp on Principles of Database Systems, Los Angeles, California, 1982

Digital Library

[39]

{Z1} Zloof M M Query-by Example a data base language IBM Systems Journal 16, 4, 324-343

Digital Library

Cited By

Cai ZMiao DLi Y(2019)Deletion Propagation for Multiple Key Preserving Conjunctive Queries: Approximations and Complexity2019 IEEE 35th International Conference on Data Engineering (ICDE)10.1109/ICDE.2019.00052(506-517)Online publication date: Apr-2019
https://doi.org/10.1109/ICDE.2019.00052
Masunaga YNagata YIshii T(2018)Extending the View Updatability of Relational Databases from Set Semantics to Bag Semantics and Its Implementation on PostgreSQLProceedings of the 12th International Conference on Ubiquitous Information Management and Communication10.1145/3164541.3164584(1-8)Online publication date: 5-Jan-2018
https://dl.acm.org/doi/10.1145/3164541.3164584
Masunaga Y(2017)An intention-based approach to the updatability of views in relational databasesProceedings of the 11th International Conference on Ubiquitous Information Management and Communication10.1145/3022227.3022239(1-8)Online publication date: 5-Jan-2017
https://dl.acm.org/doi/10.1145/3022227.3022239
Show More Cited By

Recommendations

Query processing over object views of relational data

This paper presents an approach to object view management for relational databases. Such a view mechanism makes it possible for users to transparently work with data in a relational database as if it was stored in an object-oriented (OO) database. A ...
Queries and views of programs using a relational database system
Relational Operations and Uncertainty Measure in Rough Relational Database

The traditional relational database model RDM is not effective for dealing with imprecise and uncertain data as it deals with precise and unambiguous data. Hence, Beaubouef et al. proposed the rough relational database model RRDM for the management of ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

PODS '83: Proceedings of the 2nd ACM SIGACT-SIGMOD symposium on Principles of database systems

March 1983

420 pages

ISBN:0897910974

DOI:10.1145/588058

Conference Chair:
Ronald Fagin
IBM Research Laboratory, San Jose, California
,
Program Chair:
Philip A. Bernstein
Harvard University, Cambridge, Massachusetts

Copyright © 1983 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 21 March 1983

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Conference

PODS '83

Sponsor:

PODS '83: Principles of database systems

March 21 - 23, 1983

Georgia, Atlanta

Acceptance Rates

Overall Acceptance Rate 642 of 2,707 submissions, 24%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

17
Total Citations
View Citations
223
Total Downloads

Downloads (Last 12 months)25
Downloads (Last 6 weeks)10

Reflects downloads up to 30 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

Cai ZMiao DLi Y(2019)Deletion Propagation for Multiple Key Preserving Conjunctive Queries: Approximations and Complexity2019 IEEE 35th International Conference on Data Engineering (ICDE)10.1109/ICDE.2019.00052(506-517)Online publication date: Apr-2019
https://doi.org/10.1109/ICDE.2019.00052
Masunaga YNagata YIshii T(2018)Extending the View Updatability of Relational Databases from Set Semantics to Bag Semantics and Its Implementation on PostgreSQLProceedings of the 12th International Conference on Ubiquitous Information Management and Communication10.1145/3164541.3164584(1-8)Online publication date: 5-Jan-2018
https://dl.acm.org/doi/10.1145/3164541.3164584
Masunaga Y(2017)An intention-based approach to the updatability of views in relational databasesProceedings of the 11th International Conference on Ubiquitous Information Management and Communication10.1145/3022227.3022239(1-8)Online publication date: 5-Jan-2017
https://dl.acm.org/doi/10.1145/3022227.3022239
Cong GFan WGeerts FLi JLuo J(2012)On the Complexity of View Update Analysis and Its Application to Annotation PropagationIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2011.2724:3(506-519)Online publication date: 1-Mar-2012
https://dl.acm.org/doi/10.1109/TKDE.2011.27
Cong GLi Y(2010)Updating XML views and querying XML views with update syntaxInternational Journal of Computational Science and Engineering10.1504/IJCSE.2010.0368225:2(118-126)Online publication date: 1-Nov-2010
https://dl.acm.org/doi/10.1504/IJCSE.2010.036822
Cong G(2007)Query and update through XML viewsProceedings of the 5th international conference on Databases in networked information systems10.5555/1779354.1779363(81-95)Online publication date: 17-Oct-2007
https://dl.acm.org/doi/10.5555/1779354.1779363
Cong G(2007)Query and Update Through XML ViewsDatabases in Networked Information Systems10.1007/978-3-540-75512-8_7(81-95)Online publication date: 2007
https://doi.org/10.1007/978-3-540-75512-8_7
Cong GFan WGeerts FYu PTsotras VFox ELiu B(2006)Annotation propagation revisited for key preserving viewsProceedings of the 15th ACM international conference on Information and knowledge management10.1145/1183614.1183705(632-641)Online publication date: 6-Nov-2006
https://dl.acm.org/doi/10.1145/1183614.1183705
Biskup JConvent B(2005)Towards a schema design methodology for deductive databasesMFDBS 8910.1007/3-540-51251-9_4(37-52)Online publication date: 1-Jun-2005
https://doi.org/10.1007/3-540-51251-9_4
Buneman PKhanna STan WPopa LAbiteboul SKolaitis P(2002)On propagation of deletions and annotations through viewsProceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems10.1145/543613.543633(150-158)Online publication date: 3-Jun-2002
https://dl.acm.org/doi/10.1145/543613.543633
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Table of Contents