View update in entity-relationship approach

Data and Knowledge Engineering

Volumn 19, Issue 1, 1996, Pages 135-169

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

^a NATIONAL UNIVERSITY OF SINGAPORE   (Singapore)

Author keywords

Entity relationship based database management systems; View updatability; View update translation

Indexed keywords

ALGORITHMS; COMPUTATION THEORY; COMPUTER SOFTWARE; DATA STRUCTURES; INFORMATION RETRIEVAL; SECURITY OF DATA; USER INTERFACES;

ENTITY RELATIONSHIP BASED DATABASE MANAGEMENT SYSTEMS; ENTITY RELATIONSHIP DIAGRAMS; INSERTABILITY; VIEW UPDATABILITY; VIEW UPDATABILITY ALGORITHMS; VIEW UPDATE TRANSLATION; VIEW UPDATE TRANSLATION ALGORITHMS;

RELATIONAL DATABASE SYSTEMS;

EID: 0030165575     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/0169-023x(95)00042-q     Document Type: Article

References (30)

1. T.W. Ling, A three level schema architecture ER based database management systems, in: S.T. March, ed., Entity-Relationship Approach (North Holland, Amsterdam, 1987) 205-220.
2. T.W. Ling, A normal form for Entity-Relationship diagrams, Proc. 4th Int. Conf. on Entity-Relationship Approach (1985).
3. T.W. Ling and M.L. Lee, A prolog implementation of an ER based DBMS, Proc. 10th Int. Conf. on ER Approach (1991) 587-605.
4. E.F. Codd, Recent Investigations in a Relational Database System, Information Processing 74 (North-Holland, Amsterdam, 1974) 1017-1021.
5. F. Bancilhon and N. Spyratos, Update semantics and relational views, ACM Trans. Database Systems 6(4) (1981).
6. T. Barsalou et al., Updating relational databases through object-based views, Proc. 1991 ACM SIGMOD Int. Conf. on Management of Data (May 1991).
7. C.R. Carlson and A.K. Arora, The updatability of relational views based on functional dependencies, 3rd Int. Computer Software and Applications Conf., IEEE Computer Society (1979).
8. M.C. Chan, Translation templates for updates issued on relation views, Tech. Report 35, Dept. of Comp. Science, Monash University, Melbourne, Australia, April 1983.
9. M.C. Chan and K.J. McDonell, An update schema for relational views, Proc. 10th Aust. Computer Conf. (September 1983) 150-163.
10. B. Czejdo, D.W. Embley and M. Rusinkiewicz, View updates for an extended Entity-Relationship Model, J. Information Sciences 62 (1992) 41-62.
11. U. Dayal and P.A. Bernstein, On the correct translation of update operations on relational views, ACM Trans. Database Systems 7(3) (1982).
12. A.L. Furtado, C.K. Sevcik and C.S. Santos, Permitting updates through views of databases, Information Systems 4(4) (Pergamon Press, UK, 1979),
13. J. Guttag, Abstract data types and the development of data structures, Commun. ACM 20(6) (1977) 396-404.
14. A.M. Keller, Algorithms for translating view updates to database updates for views involving selections, projections and joins, 4th PODS, ACM (March 1985).
15. A.M. Keller, Choosing a view update translator by Dialog at view definition time, Proc. 12th Int. Conf. on Very Large Databases (1986).
16. R. Langerak, View updates in relational databases with an independent scheme, ACM Trans. Database Systems 15(1) (March 1990) 40-66.
17. 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.
18. L. Rowe and K.A. Schoens, Data abstractions, views and updates in RIGEL, in: Proc. ACM-SIGMOD Int. Conf. on Management of Data (1979) 71-81.
19. K.C. Sevcik and A.L. Furtado, Complete and compatible sets of update operations, in: Int. Conf. on Management of Data, ICMOD (1978).
20. M. Stonebraker, Implementation of integrity constraints and views by query modification, Proc. ACM-SIGMOD Int. Conf. on Management of Data, San Jose (1975) 65-78.
21. P.P. Chen, The Entity-Relationship model: Toward a unified view of data, ACM Trans. Database Systems 1(1) (1976) 166-192.
22. 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.
23. T.W. Ling and M.L. Lee, A graphical Entity-Relationship based database management system workbench, Proc. 4th Int. Workshop on Computer-Aided Software Engineering (1990) 480-495.
24. J. Grant and T.W. Ling, Database representation and manipulation using Entity-Relationship database logic, Proc. of Methodologies for Intelligent Systems IV (Elsevier Science Pub. Co, 1989) 102-109.
25. D. Maier, Theory of Relational Databases (Computer Science Press, Rockville, MD, 1983).
26. D. Kapp and J.F. Leben, IMS Programming Techniques: A Guide to Using DL/I (Van Nostrand Reinhold, New York, 1978).
27. C.J. Date, A Guide to INGRES (Addison-Wesley, 1987).
28. C.J. Date, An Introduction to Database Systems, 4th edition (Addison-Wesley, 1986).
29. M. Papazoglou and W. Valder, Relational Database Management: A Systems Programming Approach (Prentice-Hall, 1989).
30. Digital Equipment Corporation, VAX Rdb/VMS Reference Manual, 1989.