Maintaining Mappings between Conceptual Models and Relational Schemas

2010 ◽  
Vol 21 (3) ◽  
pp. 36-68 ◽  
Author(s):  
Yuan An ◽  
Xiaohua Hu ◽  
Il-Yeol Song
Keyword(s):  
Conceptual Model ◽  
Design Process ◽  
Information Needs ◽  
Conceptual Models ◽  
Database Design ◽  
Round Trip ◽  
Relational Schemas ◽  
Engineering Approach ◽  
New Information ◽  
Relational Mapping

This paper describes a round-trip engineering approach for incrementally maintaining mappings between conceptual models and relational schemas. When either schema or conceptual model evolves to accommodate new information needs, the existing mapping must be maintained accordingly to continuously provide valid services. In this paper, the authors examine the mappings specifying “consistent” relationships between models. First, they define the consistency of a conceptual-relational mapping through “semantically compatible” instances. Next, the authors analyze the knowledge encoded in the standard database design process and develop round-trip algorithms for incrementally maintaining the consistency of conceptual-relational mappings under evolution. Finally, they conduct a set of comprehensive experiments. The results show that the proposed solution is efficient and provides significant benefits in comparison to the mapping reconstructing approach.

Maintaining Mappings between Conceptual Models and Relational Schemas

2012 ◽  
pp. 245-276
Author(s):  
Yuan An ◽  
Xiaohua Hu ◽  
Il-Yeol Song
Keyword(s):  
Conceptual Model ◽  
Design Process ◽  
Information Needs ◽  
Conceptual Models ◽  
Database Design ◽  
Round Trip ◽  
Relational Schemas ◽  
Engineering Approach ◽  
New Information ◽  
Relational Mapping

This paper describes a round-trip engineering approach for incrementally maintaining mappings between conceptual models and relational schemas. When either schema or conceptual model evolves to accommodate new information needs, the existing mapping must be maintained accordingly to continuously provide valid services. In this paper, the authors examine the mappings specifying “consistent” relationships between models. First, they define the consistency of a conceptual-relational mapping through “semantically compatible” instances. Next, the authors analyze the knowledge encoded in the standard database design process and develop round-trip algorithms for incrementally maintaining the consistency of conceptual-relational mappings under evolution. Finally, they conduct a set of comprehensive experiments. The results show that the proposed solution is efficient and provides significant benefits in comparison to the mapping reconstructing approach.

From Conceptual Models to Data Models

2011 ◽  
pp. 148-170 ◽  
Author(s):  
Antonio Badia
Keyword(s):  
Conceptual Model ◽  
Conceptual Models ◽  
Object Oriented ◽  
Data Models ◽  
Xml Database ◽  
Relational Schemas ◽  
Trade Offs ◽  
Object Relational ◽  
Entity Relationship ◽  
Entity Relationship Diagrams

This chapter describes transformations between conceptual models (mainly entity-relationship diagrams and also UML) and data models. It describes algorithms to transform a given conceptual model into a data model for a relational, object-relational, object-oriented and XML database. Some examples are used to illustrate the transformations. While some transformations are well known, some (like the transformation into XML or into object-relational schemas) have not been investigated in depth. The chapter shows that most of these transformations offer options which involve important trade-offs that database designers should be aware of.

scholarly journals Sistem Basis Data Manajemen Akademik dengan Platform Web pada Sekolah Menengah Atas Muhammadiyah 4 Bandung

2020 ◽  
Vol 2 (2) ◽  
pp. 47-54
Author(s):  
Ayu Hidayah Aslamia ◽  
Herru Darmadi
Keyword(s):  
High School ◽  
Information Needs ◽  
System Analysis ◽  
Design Method ◽  
Database Design ◽  
Database Management System ◽  
Web Based ◽  
Academic Management ◽  
Three Stages ◽  
Support Decision Making

The purpose of this research is to design a database system that is implemented in a web-based academic management that can be used to support the information system and academic management at Muhammadiyah 4 High School Bandung. The proposed Method in system design includes 2 parts, such as system analysis and product design. Analytical methods include literature studies, interviews, and questionnaire. Meanwhile, the database design method used are three stages database design according to Connoly and Begg. The results achieved are web based academic and database management system at Muhammadiyah High School 4 Bandung. The conclusion obtained from this research is the system is able to provide information needs, faster, accurate, prevent duplication problem of data , to support decision making, to improve effective communication between the user, and to get the information easier.

scholarly journals Onto2DB: towards an eclipse plugin for automated database design from an ontology

2019 ◽  
Vol 9 (4) ◽  
pp. 3298 ◽  
Author(s):  
Morad Hajji ◽  
Mohammed Qbadou ◽  
Khalifa Mansouri
Keyword(s):  
Theoretical Model ◽  
Conceptual Model ◽  
Relational Database ◽  
Information Technologies ◽  
Database Design ◽  
Relational Model ◽  
Automatic Translation ◽  
Data Definition ◽  
Ontological Model ◽  
Automated Database

Ontologies are spreading more and more in the field of information technologies as a privileged solution allowing the formalization of knowledge. The theoretical model of ontologies is most promising. They are increasingly ubiquitous given the benefits they present. Despite the proliferation of research proposing approaches dedicated to the design of a database from an ontology, the tools to design a database from an ontology are rare or inaccessible. Thus, in this contribution, we present our approach for the development of an Eclipse Plug-in, in order to automatically generate a conceptual model of a relational database from an ontology. To evaluate the usefulness of our approach, we used our resulting Eclipse Plug-in to automatically generate a conceptual model of a relational database from an ontology, customize it, and automatically generate the corresponding SQL script for Data Definition. The results of this experiment showed that our Plug-in constitutes a concretization of our approach and a means of automatic translation from the ontological model to the relational model.

Methodical Spatial Database Design with Topological Polygon Structures

2012 ◽  
Vol 3 (1) ◽  
pp. 21-30
Author(s):  
Jean Damascène Mazimpaka
Keyword(s):  
Design Process ◽  
Spatial Data ◽  
Spatial Databases ◽  
Early Stage ◽  
Spatial Database ◽  
Database Design ◽  
Integrity Constraints ◽  
Data Types ◽  
Data Infrastructure ◽  
Database Development

Spatial databases form the foundation for a Spatial Data Infrastructure (SDI). For this, a spatial database should be methodically developed to accommodate its role in SDI. It is desirable to have an approach to spatial database development that considers maintenance from the early stage of database design and in a flexible way. Moreover, there is a lack of a mechanism to capture topological relations of spatial objects during the design process. This paper presents an approach that integrates maintenance of topological integrity constraints into the whole spatial database development cycle. The approach is based on the concept of Abstract Data Types. A number of topological classes have been identified and modelling primitives developed for them. Topological integrity constraints are embedded into maintenance functions associated with the topological classes. A semi-automatic transformation process has been developed following the principles of Model Driven Architecture to simplify the design process.

From Databases to Ontologies

2009 ◽  
pp. 2360-2383
Author(s):  
Guntis Barzdins ◽  
Janis Barzdins ◽  
Karlis Cerans
Keyword(s):  
Conceptual Model ◽  
Relational Database ◽  
Relational Databases ◽  
Database Design ◽  
Database Schema ◽  
Design Problems ◽  
Uml Profile ◽  
Domain Experts ◽  
Owl Ontology ◽  
Rdf Database

This chapter introduces the UML profile for OWL as an essential instrument for bridging the gap between the legacy relational databases and OWL ontologies. We address one of the long-standing relational database design problems where initial conceptual model (a semantically clear domain conceptualization ontology) gets “lost” during conversion into the normalized database schema. The problem is that such “loss” makes database inaccessible for direct query by domain experts familiar with the conceptual model only. This problem can be avoided by exporting the database into RDF according to the original conceptual model (OWL ontology) and formulating semantically clear queries in SPARQL over the RDF database. Through a detailed example we show how UML/OWL profile is facilitating this new and promising approach.

Relationship Between New Information Technologies and Flexible Organizational Forms

2006 ◽  
pp. 68-92 ◽  
Author(s):  
Miguel Perez-Valls ◽  
José Manuel Ortega-Egea ◽  
José Antonio Plaza-Úbeda
Keyword(s):  
Conceptual Model ◽  
Theoretical Investigation ◽  
Information Technologies ◽  
Organizational Structures ◽  
Previous Literature ◽  
Organizational Forms ◽  
Environmental Dynamism ◽  
Organizational Models ◽  
New Information ◽  
It Innovations

This chapter offers a theoretical investigation of the relationships between new IT and the implementation of emerging organizational designs. It argues that IT innovations can be regarded both as cause and consequence of the emergence of more flexible and virtual organizational forms. First, the authors offer a review of relevant previous literature, dealing with new IT, flexible organizational models and the relationships between IT and modular organizational structures. Next, a conceptual model is introduced that clarifies the relationships between IT development, the implementation of flexible organizational designs and environmental dynamism. Finally, conclusions and implications for researchers and practicing managers are presented.

Interface Design

2011 ◽  
pp. 1-10
Author(s):  
Antonio Drommi
Keyword(s):  
Design Process ◽  
Human Behavior ◽  
Interface Design ◽  
Process Engineering ◽  
Screen Design ◽  
Priority List ◽  
Engineering Approach ◽  
Task Component ◽  
Traditional Process ◽  
Embedded Process

This chapter will address the issues of interface design and incorporation of human behavior factors into the design process. The traditional process engineering approach to software development embeds interface design as a task component. However, the interface design process has grown as a discipline and is beyond the single process within a larger scheme that may be lost on the priority list. The functionality and specifications for software developers tend to focus on the project and less on the product. In addition, bridging the gap of the design process to include global elements of the software is an issue for products that are internationally distributed. It is something that the computer industry must address and has been historically unsuccessful at doing. Incorporating human interactivity and screen design requires an understanding of the user and their behavior that is not part of the traditional tasks of most designers and programmers. This chapter presents the importance of human interactivity and interface design as an embedded process.

Sign in / Sign up

Export Citation Format

Share Document