Further Analysis of the Entity-Relationship Approach to Database Design

1981 ◽  
Vol SE-7 (1) ◽  
pp. 85-99 ◽  
Author(s):  
P.A. Ng
Keyword(s):  
Database Design ◽  
Entity Relationship

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 Survey Teknik-Teknik Database Design Menggunakan Metode Systematic Literature Review

2021 ◽  
Vol 3 (2) ◽  
pp. 162-175
Author(s):  
Mohamad Ichsan Wibawa ◽  
Farhan Rafif Azzufar ◽  
Ilmi Rasyidah Firdaus ◽  
Muhammad Ainul Yaqin
Keyword(s):  
Literature Review ◽  
Systematic Literature Review ◽  
Database Design ◽  
Entity Relationship

Teknik database desain adalah segala metode yang berhubungan dengan kegiatan perancangan dalam membuat sebuah database. Dalam mendesain database, terdapat beberapa teknik yang dapat digunakan. Namun dalam penggunaanya, kerap dijumpai kurangnya kecocokan teknik dengan jenis database yang akan digunakan. Maka dari itu, tujuan dibuatnya paper ini untuk menyajikan pasangan teknik dan jenis database yang baik untuk dikombinasikan. Manfaat dari pembuatan paper ini yaitu untuk membantu para developer dalam menentukan teknik dan jenis database yang sesuai, yang nantinya akan diterapkan pada aplikasi yang dibangun. Metode yang digunakan dalam mencapai tujuan tersebut adalah meninjau Systematic Literature Review (SLR) terhadap paper-paper penelitian yang membahas tentang teknik mendesain database dari tahun 1988-2018. Hasil yang diperoleh yaitu teknik-teknik dalam mendesain database antara lain teknik normalisasi, teknik entity-relationship, dan teknik date wilson. Berdasarkan survey yang telah kami lakukan, kami mendapatkan kesimpulan pasangan teknik desain dengan jenis databasenya yang paling cocok digunakan dalam membangun aplikasi yang akan dibuat oleh developer untuk contoh kasus pembuatan database sistem informasi perpustakaan.

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.

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.

An automated entity–relationship clustering algorithm for conceptual database design

2007 ◽  
Vol 32 (5) ◽  
pp. 773-792 ◽  
Author(s):  
Madjid Tavana ◽  
Prafulla Joglekar ◽  
Michael A. Redmond
Keyword(s):  
Clustering Algorithm ◽  
Database Design ◽  
Entity Relationship
Sign in / Sign up

Export Citation Format

Share Document