Journal Search Engine
Search Advanced Search Adode Reader(link)
Download PDF Export Citaion korean bibliography PMC previewer
ISSN : 2005-0461(Print)
ISSN : 2287-7975(Online)
Journal of Society of Korea Industrial and Systems Engineering Vol.26 No.3 pp.1-9
DOI :

관계형 데이터베이스에서 응답시간에 제약이 있는 경우 최적 역정규화 방법

장영관
삼척대학교 시스템정보공학과

An Optimal Denormalization Method in Relational Database with Response Time Constraint


[$AuthorMark7$]

Abstract

Databases are central to business information systems and RDBMS is most widely used for the database system. Normalization was designed to control various anomalies (insert, update, delete anomalies). However, normalized database design does not account for the tradeoffs necessary for performance. In this research, I model a database design method considering denormalization of duplicating attributes in order to reduce frequent join processes. This model considers response time for processing each select, insert, update, delete transaction, and for treating anomalies. A branch and bound method is proposed for this model.

Reference