A theory for entity-relationship view updates

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 645 LNCS, Issue , 1992, Pages 262-279

  Ling, Tok Wang ^a   Lee, Mong Li ^a  

^a NATIONAL UNIVERSITY OF SINGAPORE   (Singapore)

Author keywords

[No Author keywords available]

Indexed keywords

ARTIFICIAL INTELLIGENCE; COMPUTER SCIENCE; COMPUTERS;

CONCEPTUAL SCHEMAS; ENTITY-RELATIONSHIP; ER DIAGRAMS; NORMAL FORM; PRACTICAL PROBLEMS; RELATIONAL DATABASE; VIEW UPDATE;

DATA MINING;

EID: 85029790680     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/3-540-56023-8_17     Document Type: Conference Paper

References (24)

1. F. Bancilhon and N. Spyratos: Update semantics and relational views, ACM Trans. Database Systems 6 (4), 1981.
2. T. Barsalou, et. al: Updating Relational Databases through Object-Based Views, Proc. of the 1991 ACM SIGMOD Int. Conf. on Management of Data, May 1991.
3. C.R. Carlson and A.K. Arora: The updatability of relational views based on functional dependencies, Third International Conputer Software and Applications Conference, IEEE Computer Society, 1979.
4. M.C. Chart: Translation templates for updates issued on relation views, Tcch. Report 35, Dept. of Comp. Science, Monash University, Melbourne, Australia, April 1983.
5. P.P. Chen: The Entity-Relationship Model: Toward a Unified View of Data, ACM Transactions on Database Systems vol l, no 1, 1976, pp 166-192.
6. E.F. Codd: Recent Investigations in a Relational Database System, Information Processing 74, North Holland, Amsterdam, 1974, pp 1017-1021.
7. U. Dayal and P.A. Bernstein: On the correct translation of update operations on relational views, ACM Trans. Database Systems 7 (3), 1982.
8. A.L. Furtado, C.K. Sevcik and C.S. Santos: Permittting updates through views of databases, Information Systems 4 (4), Pergamon Press, Great Britain, 1979.
9. J. Grant and T.W. Ling: Database Representation and Manipulation Using Entity-Relationship Database Logic, Proc. of Methodologies for Intelligient Ststem IV, Elsevier Science Pub. Co., 1989, pp 102-109.
10. J. Guttag: Abstract data types and the development of data structures, Communications of ACM 20 (6), 1977, pp 396-404.
11. A.M. Keller: Algorithms for translating view updates to database updates for views involving selections, projections and joins, 4th PODS, ACM, March 1985.
12. A.M. Keller: Choosing a view update translator by Dialog at view definition time, Proc. of the 12th International Conference on Very Large Databases, 1986.
13. R. Langerak: View Updates in Relational Databases with an Independent Scheme, ACM Transactions on Database Systems, Vol 15, No 1, March 1990, pp 40-66.
14. M.L. Lee: An Entity-Relationship Based Database Management System, a thesis submitted for the degree of Master of Science, National University of Singapore, 1992.
15. S.B. Legg and K.J. McDonell: Translating update requests on user views, technical report 77, Department of Computer Science, Monash University, Melbourne, Australia, Nov 1986.
16. T.W. Ling: A Normal Form for Entity-Relationship Diagrams, Proc. 4th International Conference on Entity-Relationship Approach, 1985.
17. T.W. Ling: A Three Level Schema Architecture ER based Database Management Systems, in: March, S.T. (ed), Entity-Relationship Approach, North Holland, Amsterdam, 1987, pp 205-220.
18. T.W. Ling and M.L. Lee: A Graphical Entity-Relationship Based Database Management System Workbench, Prec. 4th International Workshop on Computer-Aided Software Engineering, 1990, pp 480-495.
19. T.W. Ling. and M.L. Lee: A Prolog Implementation of an ER based DBMS, Prec. 10th Int. Conf. on ER Approach, 1991, pp 587-605.
20. T.W. Ling and M.L. Lee: View Update in Entity-Relationship Approach, to be submitted for publication, 1992.
21. D. Maier: Theory of Relational Databases, Computer Science Press, 1983.
22. L. Rowe and K.A. Schoens: Data abstractions, views and updates in RIGEL, in Proc. ACM-SIGMOD International Conf. on Management of Data, 1979, pp 71-81.
23. K.C. Sevcik and A.L. Furtado: Complete and compatible sets of update operations, in International Conf. on Management of Data (ICMOD), 1978.
24. M. Stonebraker: Implementation of integrity constraints and views by query modification, Proc. ACM SIGMOD Int. Conf. on Management of Data, San Jose, 1975, pp 65-78.