논문 상세보기
관계형 데이터베이스에서 응답시간에 제약이 있는 경우 최적 역정규화
An Optimal Denormalization Method in Relational Database with Response Time Constraint
2002년 한국산업경영시스템학회 추계국제학술대회 (2002.10)
pp.386-392
pp.386-392
한국산업경영시스템학회
(Society of Korea Industrial and Systems Engineering)
초록
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, we 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.
목차
1. 서론 및 기존 연구
2. 연구 내용
3. 수리 모형
4. 분지한계법 앨고리듬
5. 결론
참고문헌
2. 연구 내용
3. 수리 모형
4. 분지한계법 앨고리듬
5. 결론
참고문헌
저자
