Performance improvement study for MRP part explosion in ERP environment

International Journal of Advanced Manufacturing Technology

Volumn 35, Issue 3-4, 2007, Pages 309-324

  Lee, Hyoung Gon ^a   Na, Hong Bum ^a   Shin, Kitae ^b   Jeong, Han Il ^c   Park, Jinwoo ^a  

^a South Korea   (South Korea)

^b Daejin University   (South Korea)

^c Daejeon University   (South Korea)

Author keywords

Hierarchical structure; Main memory virtual DB; MRP; Part explosion

Indexed keywords

DATA STRUCTURES; DATABASE SYSTEMS; PLANNING; REAL TIME CONTROL;

DATA PARTITIONING; HIERARCHICAL STRUCTURE; MATERIAL REQUIREMENT PLANNING; PART EXPLOSION; TIME PHASED PRODUCTION;

EXPLOSIONS;

EID: 38349153591     PISSN: 02683768     EISSN: 14333015     Source Type: Journal    
DOI: 10.1007/s00170-006-0718-9     Document Type: Article

References (22)

1. Melnyk SA, Piper CH (1985) Leadtime errors in MRP: the lot-sizing effect. Int J Prod Res 23(2):253-264
2. Heemsbergen BL, Malstrom EM (1994) A simulation of single-level MRP lot-sizing heuristics: an analysis of performance by rule. Prod Plan Control 5(4):381-391
3. Minifie JR, Davis RA (1986) Survey of MRP nervousness issues. Prod Invent Manage 27(3):111-120
4. Codd E (1970) A relational model for large shared data banks. Commun ACM 13(6):377-387
5. Dogac A et al. (1994) Advances in object-oriented databases systems. Springer, Berlin Heidelberg New York
6. Stonebraker M, Moore D (1996) Object-relational DBMSs: the next great wave. Morgan Kaufman, San Francisco
7. Jagadish HV (1989) Incorporating hierarchy in a relational model of data. Proc 1989 ACM SIGMOD, pp 78-87
8. Garcia-Molina H, Salem K (1992) Main-memory database systems. IEEE Trans Knowl Data Eng 4(6):509-516
9. Golshani F, Pizzarello A (1998) The use of immense memories for database systems: a pragmatic approach. J Syst Softw 41(1):41-50
10. Rüdiger BE (2000) The SAP R/3 System - an introduction to ERP and business software technology. Addison-Wesley, London
11. Bellatreche L, Shneider M, Lorinquer H, Mohania M (2004) Bringing Together Partitioning Materialized views and indexes to optimize performance of relational data warehouses. LNCS 3181:15-25
12. Jonathan G, Per-Ake L (2001) Optimizing queries using materialized views. ACM SIGMOD 30(2):331-342
13. Gupta A, Mumick IS, Rao J et al. (2001) Adapting materialized views after redefinitions: techniques and a performance study. Inf Syst 26(5):323-362
14. Ali MA, Fernandes AAA, Paton NW (2003) MOVIE: an incremental maintenance system for materialized object views. Data Knowl Eng 47(2):131-166
15. Ceri S, Negri M, Pelagatti G (1982) Horizontal data partitioning in database design. Proc 1982 ACM SIGMOD international conference on Management of data, pp 128-136
16. Bellatreche L, Karlapalem K, Simonet A (2000) Algorithms and support for horizontal class partitioning in object-oriented databases. Distrib Parallel Databases 8:155-179
17. Andrew N, Paulo B, Alok G, James R (2004) Database design in the modern organization - identifying robust structures under changing query patterns and arrival rate conditions. Decis Support Syst 37:435-447
18. Scheer AW (1994) Business process engineering, 2nd edn. Springer, Berlin Heidelberg New York
19. Elmasri R, Navathe SB (2000) Fundamentals of database systems, 3rd edn. Addison Wesley, New York
20. Atzeni P, De Antonellis V (1993) Relational database theory. Benjamin/Cummings, Redwood
21. Sanders G (2001) Denormalization effects on performance of RDBMS. Proc 34th Hawaii International Conference on System Sciences, pp 930-938
22. Westland JC (1992) Economic incentives for database normalization. Inf Process Manag 28:644-662