A DECLARATIVE APPROACH TO SHOP ORDERS OPTIMIZATION

Jarosław WIKAREK

j.wikarek@tu.kielce.pl
Technical University of Kielce, Control and Management Systems Section, 1000-PP 7, Kielce (Poland)

Paweł SITEK


Technical University of Kielce, Control and Management Systems Section, 1000-PP 7, Kielce (Poland)

Mieczysław JAGODZIŃSKI


* Silesian University of Technology, Department of Automatics, Akademicka 16, 44-101 Gliwice (Poland)

Abstract

The paper presents the problem of material requirements planning with optimization of load distribution between work centers and workers’ groups. Moreover, it discusses the computational example for shop orders optimization. The data for this example were taken from the relational database. The method of Constraint Logic Programming (CLP) for shop orders optimization has been suggested. Using Constraint Logic Programming, the constraints may be directly introduced to the problem declaration, which is equivalent to the source code of the program. The ECLiPSe-CLP software system has been presented. It allows for solving optimization problems concerning dimensions greater than in the case of the professional mathematical programming solver “LINGO”. The application of ECLiPSe-CLP in accessing data from relational databases has been presented.


Keywords:

MRP II, linear optimization, relational databases, ECLiPSe -CLP

Landvater, D. V., & Gray, C. D. (1989). MRP II Standard System. Oliver Wight Publications.
Niederliński, A. (2011). A Quick and Gentle Guide to Constraint Logic Programming via ECLiPSe. Gliwice.
Rossi, F., Van Beek, P., & Walsh, T. (2006). Handbook of Constraint Programming (Foundations of Artificial Intelligence). New York, NY, USA: Elsevier Science Inc.
Sitek, P., & Wikarek, J. (2019). Capacitated vehicle routing problem with pick-up and alternative delivery (CVRPPAD): model and implementation using hybrid approach. Annals of Operations Research, 273, 257. https://doi.org/10.1007/s10479-017-2722-x
Sitek, P., & Wikarek, J. (2018). A multi-level approach to ubiquitous modeling and solving constraints in combinatorial optimization problems in production and distribution. J. Appl. Intell, 48, 1344. https://doi.org/10.1007/s10489-017-1107-9
Sitek, P., Wikarek, J., & Zaborowski, M. (2002). Application of Constraint Logic Programming (CLP) to Shop Orders Optimization in MRP II Systems. In Conference: 4th Workshop on Constrained Programming for Decision and Control (pp. 59-66). Gliwice. www.eclipse.org (n.d.) Retrieved October 19, 2018, from The Eclipse Foundation open source community website www.eclipse.org.
www.lindo.com (n.d.) Retrieved October 19, 2018, from www.lindo.com
Download


Published
2019-12-30

Cited by

WIKAREK, J., SITEK, P., & JAGODZIŃSKI, M. (2019). A DECLARATIVE APPROACH TO SHOP ORDERS OPTIMIZATION. Applied Computer Science, 15(4), 5–15. https://doi.org/10.23743/acs-2019-25

Authors

Jarosław WIKAREK 
j.wikarek@tu.kielce.pl
Technical University of Kielce, Control and Management Systems Section, 1000-PP 7, Kielce Poland

Authors

Paweł SITEK 

Technical University of Kielce, Control and Management Systems Section, 1000-PP 7, Kielce Poland

Authors

Mieczysław JAGODZIŃSKI 

* Silesian University of Technology, Department of Automatics, Akademicka 16, 44-101 Gliwice Poland

Statistics

Abstract views: 64
PDF downloads: 9


License

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

All articles published in Applied Computer Science are open-access and distributed under the terms of the Creative Commons Attribution 4.0 International License.


Most read articles by the same author(s)

Similar Articles

1 2 3 4 > >> 

You may also start an advanced similarity search for this article.