Abstract
A workstation‐based system for materials planning is intended to complement a host‐based materials‐planning system, thereby leading to a multi‐level system that combines fully detailed planning procedures with “aggregate” decision support capabilities. Planning objects as well as planning procedures are formulated within the relational database frame‐work. By that means, at execution time the database management system guarantees processing efficiency as well as consistency control. After a short characterisation of the state‐of‐the‐art of database utilisation in conventional materials planning, a set of requirements which have to be met by the proposed approach is formulated. Based on this, the suitability of the relational database model as a framework for multi‐stage materials planning is discussed. In particular, the integration of abstraction hierarchies is emphasised and hierarchical planning procedures adopted from artificial intelligence are integrated into the concept. Some examples adopted from a prototype show that, at least for simple planning problems, it is possible to achieve end‐user support at any level of detail when using a relational database system for materials planning.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: International Journal of Operations & Production Management
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
