PostgreSQL: Relational database structures application on capacitated lot-sizing for pharmaceutical tablets manufacturing processes

Abstract

Multi-level capacitated lot-sizing problems with linked lot sizes and backorders (MLCLSP-L-B) are used in pharmaceutical tablets manufacturing processes to right-size material production lots so that costs are kept at a minimum, production resource capacities are not exceeded, and customer demand is fulfilled. Uncertain demand behavior characterizes today’s global tablets market. Pharmaceutical companies request solution approaches that solve the MLCLSP-L-B with probabilistic demand. Implementing this model in industrial applications for tablets manufacturing systems requires efficient data processing due to the amount of data and the capability to store simulated demand scenarios. This paper covers the first integration of the MLCLSP-L-B with probabilistic demand and Relational Database Structures (RDS). Modeling techniques for the RDS to process massive data are outlined. A virtual environment provides the implementation software PostgreSQL and infrastructure environment. Additionally, numerical experiments with research data are used to evaluate the agility and efficiency of the developed RDS.