A Methodology for View Inegration in Logical Database Design.

Shamkant B. Navathe, Suresh G. Gadgil: A Methodology for View Inegration in Logical Database Design. VLDB 1982: 142-164
  author    = {Shamkant B. Navathe and
               Suresh G. Gadgil},
  title     = {A Methodology for View Inegration in Logical Database Design},
  booktitle = {Eigth International Conference on Very Large Data Bases, September
               8-10, 1982, Mexico City, Mexico, Proceedings},
  publisher = {Morgan Kaufmann},
  year      = {1982},
  isbn      = {0-934613-14-1},
  pages     = {142-164},
  ee        = {db/conf/vldb/NavatheG82.html},
  crossref  = {DBLP:conf/vldb/82},
  bibsource = {DBLP,}


This paper is based on a conceptual frame- work for the design of databases consisting of view modeling, view integration, schema analysis and mapping and physical design and optimiza- tion. View modeling involves the modeling of the user views using a conceptual/semantic data model; the view integration phase merqes user views into a global model which is then mapped to an existing database environment and subse- quently optimized. Here we use the data model proposed by Navathe and Schkolnick to model user views and develop a methodo1og.y for view inte- gration. View integration issues are examined in detail; operations for merging views are defined and an approach to automating the view integration process is described. The proposed approach is being partially implemented at the University of Florida.

Copyright © 1982 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.

Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 4, VLDB '75-'88" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

Eigth International Conference on Very Large Data Bases, September 8-10, 1982, Mexico City, Mexico, Proceedings. Morgan Kaufmann 1982, ISBN 0-934613-14-1
Contents BibTeX


Adarsh K. Arora, C. Robert Carlson: The Information Preserving Properties of Relational Database Transformations. VLDB 1978: 352-359 BibTeX
Carlo Batini, Maurizio Lenzerini, Gaetano Santucci: A computer-aided methodology for conceptual data-base design. Inf. Syst. 7(3): 265-280(1982) BibTeX
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX
E. F. Codd: Normalized Data Structure: A Brief Tutorial. SIGFIDET Workshop 1971: 1-17 BibTeX
Ramez Elmasri, Gio Wiederhold: Data Model Integration Using the Structural Model. SIGMOD Conference 1979: 191-202 BibTeX
Beverly K. Kahn: A Method for Describing Information Required by the Database Design Process. SIGMOD Conference 1976: 53-64 BibTeX
Vincent Y. Lum, Sakti P. Ghosh, Mario Schkolnick, Robert W. Taylor, D. Jefferson, Stanley Y. W. Su, James P. Fry, Toby J. Teorey, B. Yao, D. S. Rund, B. Kahn, Shamkant B. Navathe, D. Smith, L. Aguilar, W. J. Barr, P. E. Jones: 1978 New Orleans Data Base Design Workshop Report. VLDB 1979: 328-339 BibTeX
Shamkant B. Navathe: Schema Analysis for Database Restructuring. ACM Trans. Database Syst. 5(2): 157-184(1980) BibTeX
Shamkant B. Navathe: An Intuitive Approach to Normalize Network Structured Data. VLDB 1980: 350-358 BibTeX
Shamkant B. Navathe, James P. Fry: Restructuring for Large Data Bases: Three Levels of Abstraction. ACM Trans. Database Syst. 1(2): 138-158(1976) BibTeX
Shamkant B. Navathe, Mario Schkolnick: View Representation in Logical Database Design. SIGMOD Conference 1978: 144-156 BibTeX
John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977) BibTeX
Daniel Teichroew, Ernest A. Hershey III: PSL/PSA: A Computer Aided Technique for Structured Documentation and Analysis of Information Processing Systems. IEEE Trans. Software Eng. 3(1): 41-48(1977) BibTeX

Referenced by

  1. Tiziana Catarci, Giuseppe Santucci, John Cardiff: Graphical Interaction with Heterogeneous Databases. VLDB J. 6(2): 97-120(1997)
  2. Mong-Li Lee, Tok Wang Ling: Resolving Structural Conflicts in the Integration of Entity Relationship Schemas. OOER 1995: 424-433
  3. Ernst Ellmer, Christian Huemer, Dieter Merkl, Günther Pernul: Neural Network Technology to Support View Integration. OOER 1995: 181-190
  4. Stefano Spaccapietra, Christine Parent: View Integration: A Step Forward in Solving Structural Conflicts. IEEE Trans. Knowl. Data Eng. 6(2): 258-274(1994)
  5. M. P. Reddy, Bandreddi E. Prasad, P. G. Reddy, Amar Gupta: A Methodology for Integration of Heterogeneous Databases. IEEE Trans. Knowl. Data Eng. 6(6): 920-933(1994)
  6. Giuseppe Santucci, Carlo Batini, Giuseppe Di Battista: Multilevel Schema Integration. ER 1993: 327-338
  7. Stefano Spaccapietra, Christine Parent, Yann Dupont: Model Independent Assertions for Integration of Heterogeneous Schemas. VLDB J. 1(1): 81-126(1992)
  8. Stephen Hayne, Sudha Ram: Multi-User View Integration System (MUVIS): An Expert System for View Integration. ICDE 1990: 402-409
  9. Mokrane Bouzeghoub, Isabelle Comyn-Wattiau: View Integration by Semantic Unification and Transformation of Data Structures. ER 1990: 413-430
  10. Jürgen Diet, Frederick H. Lochovsky: Interactive Specification and Integration of User Views Using Forms. ER 1989: 171-185
  11. Veda C. Storey, Robert C. Goldstein: A Methodology for Creating User Views in Database Design. ACM Trans. Database Syst. 13(3): 305-338(1988)
  12. Amit P. Sheth, James A. Larson, Aloysius Cornelio, Shamkant B. Navathe: A Tool for Integrating Conceptual Schemas and User Views. ICDE 1988: 176-183
  13. Amit Basu: Knowledge Base Views in Multiuser Knowledge Based Systems. ICDE 1988: 346-353
  14. Shamkant B. Navathe, Mahan K. Pillalamarri: OOER: Toward Making the E-R Approach Object-Oriented. ER 1988: 185-206
  15. Ferda N. Civelek, Asuman Dogac, Stefano Spaccapietra: An Expert System Approach to View Definition and Integration. ER 1988: 229-249
  16. Toby J. Teorey, Dongqing Yang, James P. Fry: A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model. ACM Comput. Surv. 18(2): 197-222(1986)
  17. Carlo Batini, Maurizio Lenzerini, Shamkant B. Navathe: A Comparative Analysis of Methodologies for Database Schema Integration. ACM Comput. Surv. 18(4): 323-364(1986)
  18. Joachim Biskup, Bernhard Convent: A Formal View Integration Method. SIGMOD Conference 1986: 398-407
  19. Bernhard Convent: Unsolvable Problems Related To The View Integration Approach. ICDT 1986: 141-156
  20. John L. Carswell Jr., Shamkant B. Navathe: SA-ER: A Methodology that Links Structured Analysis and Entity-Relationship Modeling for Database Design. ER 1986: 381-397
  21. Christoph F. Eick, Peter C. Lockemann: Acquisition of Terminological Knowledge Using Database Design Techniques. SIGMOD Conference 1985: 84-94
  22. Shamkant B. Navathe, T. Sashidhar, Ramez Elmasri: Relationship Merging in Schema Integration. VLDB 1984: 78-90
  23. Michael V. Mannino, Wolfgang Effelsberg: Matching Techniques in Global Schema Design. ICDE 1984: 418-425
  24. Ramez Elmasri, Shamkant B. Navathe: Object Integration in Logical Database Design. ICDE 1984: 426-433
  25. Luiz Tucherman, Antonio L. Furtado, Marco A. Casanova: A Pragmatic Approach to Structured Database Design. VLDB 1983: 219-231
  26. Stanley Y. W. Su, Shamkant B. Navathe, Don S. Batory: Logical and Physical Modeling of Statistical Scientific Databases. SSDBM 1983: 251-263
  27. Marco A. Casanova, Vânia Maria Ponte Vidal: Towards a Sound View Integration Methodology. PODS 1983: 36-47
  28. Shamkant B. Navathe, A. Cheng: A Methodology for Database Schema Mapping from Extended Entity-Relationship Models into the Hierarchical Model. ER 1983: 223-248
  29. Marco A. Casanova, Jose E. Amaral de Sa: Designing Entity-Relationship Schemes for Conventional Information Systems. ER 1983: 265-277
  30. C. Robert Carlson, Adarsh K. Arora: UPM: A Formal Tool for Expressing Database Update Semantics. ER 1983: 517-525
  31. Carlo Batini, Maurizio Lenzerini: A Methodology for Data Schema Integration in the Entity-Relationship Model. ER 1983: 413-420
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sat May 16 23:45:15 2009