KIT | KIT-Bibliothek | Impressum | Datenschutz

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

Simonis, Michael ORCID iD icon 1; Nickel, Stefan 1
1 Fakultät für Wirtschaftswissenschaften (WIWI), Karlsruher Institut für Technologie (KIT)

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.

Zugehörige Institution(en) am KIT Fakultät für Wirtschaftswissenschaften (WIWI)
Publikationstyp Zeitschriftenaufsatz
Publikationsmonat/-jahr 11.2024
Sprache Englisch
Identifikator ISSN: 2665-9638
KITopen-ID: 1000177920
Erschienen in Software Impacts
Verlag Elsevier ScienceDirect
Band 22
Seiten Art.-Nr.: 100720
Vorab online veröffentlicht am 20.11.2024
Nachgewiesen in Scopus
OpenAlex
Dimensions

Verlagsausgabe §
DOI: 10.5445/IR/1000177920
Veröffentlicht am 14.01.2025
Seitenaufrufe: 23
seit 14.01.2025
Downloads: 14
seit 18.01.2025
Cover der Publikation
KIT – Die Forschungsuniversität in der Helmholtz-Gemeinschaft
KITopen Landing Page