A Database Approach to Hierarchical Materials Planning

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.