한국정밀공학회:학술대회논문집 (Proceedings of the Korean Society of Precision Engineering Conference)
- 한국정밀공학회 2005년도 춘계학술대회 논문집
- /
- Pages.187-190
- /
- 2005
- /
- 2005-8446(pISSN)
ERP 환경에서 MRP 부품전개의 성능향상을 위한 연구
Performance improvement study for MRP part explosion in ERP environment
초록
There have been many studies to improve the performance of a database system focused on modifying data structure, data partitioning, and materializing strategy. The main contribution of this study is to propose a new alternative towards improving database performance by designing single table schema or processing queries virtually in main memory space. Material Requirement Planning(MRP) part explosion process has shown almost 2 times shorter under DB schema we suggested, and even more than 10 times shorter when separating and filtering policy of DB archiving process are assumed. Several experimental results are shown to illustrate the excellence of our solution.
키워드