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.

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.

scholarly journals The Development and Usage of a Relational Database Design Tool for Educational Purposes

10.28945/3199 ◽  
2008 ◽  
Author(s):  
Milos Bogdanovic ◽  
Aleksandar Stanimirovic ◽  
Nikola Davidovic ◽  
Leonid Stoimenov
Keyword(s):  
Relational Database ◽  
Design Patterns ◽  
Relational Databases ◽  
Conceptual Modeling ◽  
Database Design ◽  
Design Tool ◽  
Relational Model ◽  
Modular Architecture ◽  
Data Definition ◽  
Entity Relationship

Most universities where students study informational technologies and computer science have an introductory course dealing with the development and design of databases. These courses often include usage of database design tools. In this paper, the #EER tool is presented, the task of which is to make the process of relational databases design easier for the students and partially automatize it. The tool evolved due to the experience in using similar tools for educational purposes. It enables fast and efficient development of the relational database conceptual model and its automatized compilation into a relational model and further to data definition language (DDL) commands. #EER tool is based on the extended entity-relationship (EER) model for conceptual modeling of relational databases. Modular architecture of the tool, the development of which is based on the usage of the design patterns, along with the benefits that its usage brings, is also presented.

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.

scholarly journals brModelo: An Initiative for Aiding Database Design

2021 ◽  
Vol 12 (2) ◽  
Author(s):  
Ronaldo Dos Santos Mello ◽  
Carlos Henrique Cândido ◽  
Milton Bittencourt S. Neto
Keyword(s):  
Relational Database ◽  
Design Methodology ◽  
User Interaction ◽  
Database Design ◽  
History Of ◽  
Logical Design ◽  
Entity Relationship

The brModelo tool is a initiative of the UFSC Database Group. Its first version was developed in 2005, and its main purpose is to help teaching of relational database design. Compared to similar tools, its main differentials are the support to all steps of the classical database design methodology, user interaction during the logical design step, as well as the support to all extended Entity-Relationship concepts. With more than fifteen years of existence, the brModelo was very well-accepted by the brazilian Database community, which motivated the development and release of several versions of the tool. This article presents the history of brModelo, including its available versions and their functionalities. Additionally, we detail its functionalities and compare it with popular related tools.

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
Sign in / Sign up

Export Citation Format

Share Document