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.

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.

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.

A tribute to Gwen Leighty

2006 ◽  
Vol 19 (2) ◽  
pp. 84-86
Author(s):  
Jennifer Paustenbaugh
Keyword(s):  
Web Sites ◽  
Academic Libraries ◽  
Design Methodology ◽  
Fund Raising ◽  
Personal Knowledge ◽  
Valuable Contribution ◽  
Content Type ◽  
History Of ◽  
Development Network ◽  
Fund Raiser

PurposeThe purpose of the paper is to provide a tribute to the life and work of library fund‐raiser Gwen Leighty.Design/methodology/approachThe paper uses personal knowledge and references to Academic Libraries Advancement and Development Network (ALADN) and LIBDEV web sites.FindingsThe paper finds that fundraising is connecting with people and the journey that each development officer must make while raising funds for their library.Originality/valueThe paper presents a brief history of ALADN and the valuable contribution one person made to the cause of library fund‐raising.

The sediment of the Hostivar Reservoir (Prague, Czech Republic) as a memory of 45 years of pollution

2017 ◽  
Vol 28 (2) ◽  
pp. 204-213
Author(s):  
Lucie Soucková ◽  
Dana Kominkova
Keyword(s):  
Czech Republic ◽  
Design Methodology ◽  
Polyaromatic Hydrocarbons ◽  
Reservoir Sediment ◽  
Terrestrial Environment ◽  
Content Type ◽  
Sediment Extraction ◽  
History Of ◽  
Us Epa ◽  
Practical Implications

Purpose The purpose of this paper is to evaluate the historical pollution of the Hostivar Reservoir (largest reservoir in Prague) sediment by metals, polyaromatic hydrocarbons (PAH) and polychlorinated biphenyls (PCB) and identify the trends in pollution of aquatic environment. Design/methodology/approach Core samples, 140 cm long, recording the 45-year history of the reservoir, were separated to 5 cm width subsamples (approximately 1.5 years of sedimentation) and analyzed for metals (Cd, Pb, Cu, Zn, Cr, Ni, Al), PAH and PCB. Following methods were used: US EPA 3051 for metals, US EPA 505 and US EPA 8082 A for PCB, and ISO 18287:2006 for PAH. Findings Most of the contaminants had the highest concentration at the beginning of the existence of the reservoir, suggesting that the contamination results from construction activities. Significant decrease of Pb occurred in the second half of the 1990s. It was caused by termination of the addition of lead as a detonation suppressant to the gasoline. Most concentrations of PAHs, PCBs and metals, except copper do not present eco-toxicological risk. Practical implications The results show the volume of priority pollutants removed from the reservoir by sediment extraction, and point risk to the terrestrial environment due to application of the sediment in the construction of a noise protecting wall. Originality/value The paper presents unique data about historical contamination of the largest reservoir in Prague, the capital of Czech Republic. It shows how the watershed and the construction phase of the dam cause a pollution of the reservoir sediment and possible environmental risk for aquatic biota.

Haunted by the past: transformations and daily challenges of China's prosthetics

2020 ◽  
Vol 10 (1) ◽  
pp. 115-124
Author(s):  
Chunchun Wang
Keyword(s):  
Design Methodology ◽  
Cross Cultural ◽  
Future Research ◽  
Institutional Pressures ◽  
Rehabilitation Center ◽  
Content Type ◽  
The Past ◽  
Daily Experiences ◽  
History Of ◽  
Depth Interviews

PurposeThe purpose of this paper is to examine the transformations of prosthetic practices in China, as well as the daily experiences and dilemmas arising from the everchanging practices since 1949. On the basis of materials, this paper explores an everyday perspective to review the history of technology.Design/methodology/approachEthnography was collected with the application of participant observations, informal interviews and in-depth interviews during a 13-months study at a rehabilitation center in Chengdu, China. The literature on prosthetic manufacturing was also reviewed for this paper.FindingsChina's prosthetic technology seems to evolve from traditional to modern. However, this progressive narrative – innovation-based timeline (Edgerton, 2006, xi) – has been challenged by daily practices. Due to institutional pressures, prosthetists are in a dilemma of selectively using their knowledge to create one kind of device for all prosthesis users with a certain kind of disability, thereby regulating the physical and social experiences of prosthesis users. Besides, prosthesis users are accustomed to prostheses made with old techniques, and must correct themselves from old experiences to the daily practices recognized by the selected techniques.Originality/valueThis paper provides a cross-cultural case to reexamine Edgerton's criticism of the progressive and orderly innovation-centric technological narrative. More importantly, it reviews the history and practices of China's prosthetics from daily experiences rather than Edgerton's concentration on technology; therefore, it provides an everyday perspective for future research on technological transformations.

Sign in / Sign up

Export Citation Format

Share Document