Relational Database Design

1999 ◽  
pp. 237-285
Author(s):  
Mark Levene ◽  
George Loizou
Keyword(s):  
Relational Database ◽  
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.

From Conceptual Database Schemas to Logical Database Tuning

2011 ◽  
pp. 52-74
Author(s):  
Jean-Marc Petit ◽  
Mohand-Saïd Hacid
Keyword(s):  
Relational Database ◽  
Database Design ◽  
Relational Model ◽  
A Posteriori ◽  
Entity Relationship ◽  
Database Tuning

This chapter revisits conceptual database design and focuses on the so-called “logical database tuning”. We first recall fundamental differences between constructor-oriented models (like extended Entity-Relationship models) and attribute-oriented models (like the relational model). Then, we introduce an integrated algorithm for translating ER-like conceptual database schemas to relational database schemas. To consider the tuning of such logical databases, we highlight two extreme cases: null-free databases and efficient — though non redundant — databases. Finally, we point out how SQL workloads could be used a posteriori as a help for the designers and/or the database administrators to reach a compromise between these extreme cases. While a lot of papers and books have been devoted for many years to database design, we hope that this chapter will clarify the understanding of database designers when implementing their databases and database administrators when maintaining their databases.

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.

Sign in / Sign up

Export Citation Format

Share Document