- 관계형 데이터베이스에서 비정규화를 고려한 최적 데이터베이스 설계
- ㆍ 저자명
- 장영관,강맹규
- ㆍ 간행물명
- 데이타베이스저널
- ㆍ 권/호정보
- 1996년|3권 1호|pp.3-24 (22 pages)
- ㆍ 발행정보
- 한국데이타베이스학회
- ㆍ 파일정보
- 정기간행물| PDF텍스트
- ㆍ 주제분야
- 기타
Databases are critical to business information systems, and RDBMS is most widely used for the database system. Normalization has been designed to control various anomalies(insert, update, and delete anomalies). However, normalized database design does not account for the tradeoffs necessary for the performance. In this research, we develop a model for database design by denormalization of duplicating attributes in order to reduce frequent join processes. In this mood, we consider insert, update, delete, and query costs. The anomaly and data inconsistency are removed by additional disk I/O which is necessary for each update and insert transaction. We propose a branch and bound method for this model, and show considerable cost reduction.