Relational database: Design methodologies

2005 ◽  
pp. 22-46
Keyword(s):  
Relational Database ◽  
Database Design ◽  
Design Methodologies

Challenges on Modeling Hybrid XML-Relational Databases

2010 ◽  
pp. 28-45 ◽  
Author(s):  
Mirella M. Moro ◽  
Lipyeow Lim ◽  
Yuan-Chi Chang
Keyword(s):  
Relational Database ◽  
Relational Databases ◽  
Database Design ◽  
Design Guidelines ◽  
Use Cases ◽  
Future Research ◽  
Schema Evolution ◽  
Design Methodologies ◽  
Integrated Environment ◽  
Context Data

It is well known that XML has been widely adopted for its flexible and self-describing nature. However, relational data will continue to co-exist with XML for several different reasons one of which is the high cost of transferring everything to XML. In this context, data designers face the problem of modeling both relational and XML data within an integrated environment. This chapter highlights important questions on hybrid XML-relational database design and discusses use cases, requirements, and deficiencies in existing design methodologies especially in the light of data and schema evolution. The authors’ analysis results in several design guidelines and a series of challenges to be addressed by future research.

Relational Database Design and the Reconstruction of the British Medical Profession: Constraints and Strategies

1994 ◽  
Vol 6 (2) ◽  
pp. 71-84 ◽  
Author(s):  
James Bradley
Keyword(s):  
Relational Database ◽  
Historical Data ◽  
Medical Profession ◽  
Database Design ◽  
Ways Of Coping ◽  
Design Methodologies ◽  
Entity Relationship

Relational database design methodologies have recently been promoted for providing historians with a useful way of organising data within databases. This paper explores some of the problems which arise from using these methodologies, but suggests that techniques like Entity-Relationship Modelling remain intuitive and natural ways of coping with the complexities of historical data.

Distributed database design methodologies

1987 ◽  
Vol 75 (5) ◽  
pp. 533-546 ◽  
Author(s):  
S. Ceri ◽  
B. Pernici ◽  
G. Wiederhold
Keyword(s):  
Database Design ◽  
Distributed Database ◽  
Design Methodologies ◽  
Distributed Database Design

Relational Database Design Using Semantic Objects

2000 ◽  
pp. 375-384
Author(s):  
Jong-Sung Lee ◽  
Bo Kai Wong
Keyword(s):  
Relational Database ◽  
Database Design

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.

Sign in / Sign up

Export Citation Format

Share Document