Relational Database Design: A Review

Kumar, Kunal; Azad, Sachindra Kumar

doi:10.5120/ijca2017915626

Cited by 2 publications

(2 citation statements)

References 15 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The existence of non-constant data will undoubtedly affect the conceptual design of the designed database. Thus the task of normalization becomes very important in the database design process [29]. The relational database created contains five tables related to each other and has their respective functions.…”

Section: Relational Database Modelmentioning

confidence: 99%

Data storage model in low-cost mobile applications

Sukarsa

Antara

Buana

et al. 2022

IJEECS

View full text Add to dashboard Cite

<span lang="EN-US">Mobile applications that have data transactions between users require a database relational database management system (RDBMS) and RESTful API operating on the hosting service so that all users can access the data. Renting a hosting service is not cheap and creating a RESTful API takes plenty of time. As an alternative to hosting, a free version of the Cloud Firestore service gives full access rights to the database and has an application programming interface (API) to manage data or access data. However, the free version of Cloud Firestore has limitations in terms of storage capacity, read, write, and delete processes. Therefore, redesigning process of the database was carried out into a low-cost version of the database model consisting of SQLite database and a low-cost version of the NoSQL database to overcome this problem. The goal is to reduce storage space usage and read, write, and delete processing on Cloud Firestore. The low-cost version of the database was tested with 6,030 data. The results obtained were savings of 47.27% storage usage, 83.08% write usage, 91.26% read process usage, and 83.19% delete process usage compared to the test results of the relational database model.</span>

show abstract

Section: Relational Database Modelmentioning

confidence: 99%

Data storage model in low-cost mobile applications

Sukarsa

Antara

Buana

et al. 2022

IJEECS

View full text Add to dashboard Cite

show abstract

“…The Entity-Relationship (ER) model [1,2] is widely used to create conceptual schemas (conceptual models) to represent application domains in the field of Information Systems development. However, when an ER model is transformed to a Relational Database Schema (RDS) of the relational model, some critical information modeled on the ER model may not be represented meaningfully on the RDS [3][4][5]. This situation causes a loss of information during the transformation process [5,6].…”

Section: Introductionmentioning

confidence: 99%

ER Model Partitioning: Towards Trustworthy Automated Systems Development

Pieris¹,

Wijegunesekera²,

Dias³

2020

IJACSA

View full text Add to dashboard Cite

In database development, a conceptual model is created, in the form of an Entityrelationship(ER) model, and transformed to a relational database schema (RDS) to create the database. However, some important information represented on the ER model may not be transformed and represented on the RDS. This situation causes a loss of information during the transformation process. With a view to preserving information, in our previous study, we standardized the transformation process as a one-to-one and onto mapping from the ER model to the RDS. For this purpose, we modified the ER model and the transformation algorithm resolving some deficiencies existed in them. Since the mapping was established using a few real-world cases as a basis and for verification purposes, a formal-proof is necessary to validate the work. Thus, the ongoing research aiming to create a proof will show how a given ER model can be partitioned into a unique set of segments and use it to represent the ER model itself. How the findings can be used to complete the proof in the future will also be explained. Significance of the research on automating database development, teaching conceptual modeling, and using formal methods will also be discussed.

show abstract

Relational Database Design: A Review

Cited by 2 publications

References 15 publications

Data storage model in low-cost mobile applications

Data storage model in low-cost mobile applications

ER Model Partitioning: Towards Trustworthy Automated Systems Development

Contact Info

Product

Resources

About