Database structure for a class of multi-period mathematical programming models

We describe how a generic multi-period optimization-based decision support system can be used for strategic and operational planning in a company whose processes can be described in terms of five fundamental elements: Materials, Facilities, Activities, Times and Storage-Areas. We discuss the issues of interface design, data reporting and updating, and optimal production and profit planning. We also compare the performances of two different types of database structures with respect to optimization.

[1]  Frederic H. Murphy,et al.  Representation Schemes for Linear Programming Models , 1992 .

[2]  Gopal P. Sinha,et al.  A linear programming model for distribution of electrical energy in a steel plant , 1994 .

[3]  Arthur M. Geoffrion,et al.  A Management Support System For Distribution Planning , 1982 .

[4]  Daniel R. Dolk.  Data as models: an approach to implementing model management , 1986 .

[5]  Gopal P. Sinha,et al.  Strategic and Operational Management with Optimization at Tata Steel , 1995 .

[6]  Alok Aggarwal,et al.  Cooperative Multiobjective Decision Support for the Paper Industry , 1999, Interfaces.

[7]  Roy E. Marsten,et al.  The Design of the XMP Linear Programming Library , 1981, TOMS.

[8]  Goutam Dutta,et al.  An optimization-based decision support system for strategic planning in a process industry: The case of a pharmaceutical company in India , 2007 .

[9]  Tan Miller,et al.  Implementing a Distribution-Network Decision-Support System at Pfizer/Warner-Lambert , 2002, Interfaces.

[10]  Daniel R. Dolk,et al.  Data as models: An approach to implementing model management , 1986, Decis. Support Syst..

[11]  Stéphane Bressan,et al.  Introduction to Database Systems , 2005 .

[12]  Robert Fourer,et al.  Modeling languages versus matrix generators for linear programming , 1983, TOMS.

[13]  Robert Fourer,et al.  Database structures for mathematical programming models , 1997, Decis. Support Syst..

[14]  Goutam Dutta,et al.  A Survey of Mathematical Programming Applications in Integrated Steel Plants , 2001, Manuf. Serv. Oper. Manag..

[15]  Kin Keung Lai,et al.  A stochastic programming approach for multi-site aggregate production planning , 2006, J. Oper. Res. Soc..

[16]  Arthur M. Geoffrion.  Computer-Based Modeling Environments , 1989 .

[17]  Goutam Dutta,et al.  An Optimization Based Decision Support System for Strategic and Operational Planning with In-process Industries: Case of Pharmaceuticals Industry in India , 2006 .

[18]  Daniel R. Dolk,et al.  A generalized model management system for mathematical programming , 1986, TOMS.

[19]  G Mitra,et al.  Modelling and solving environments for mathematical programming (MP): a status review and new directions , 2002, J. Oper. Res. Soc..

[20]  Goutam Dutta,et al.  An Optimization-Based Decision Support System for Strategic and Operational Planning in Process Industries , 2004 .