- 관계형 데이터베이스에서 응답시간에 제약이 있는 경우 최적 역정규화 방법
- An Optimal Denormalization Method in Relational Database with Response Time Constraint
- ㆍ 저자명
- 장영관
- ㆍ 간행물명
- 산업경영시스템학회지
- ㆍ 권/호정보
- 2003년|26권 3호|pp.1-9 (9 pages)
- ㆍ 발행정보
- 한국산업경영시스템학회
- ㆍ 파일정보
- 정기간행물| PDF텍스트
- ㆍ 주제분야
- 기타
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.