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

Goutam Dutta*, Robert Fourer

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

11 Scopus citations


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.

Original languageEnglish (US)
Pages (from-to)870-883
Number of pages14
JournalDecision Support Systems
Issue number4
StatePublished - Nov 2008


  • Decision support system
  • Optimization
  • Process industries
  • Strategic and operational planning

ASJC Scopus subject areas

  • Management Information Systems
  • Information Systems
  • Developmental and Educational Psychology
  • Arts and Humanities (miscellaneous)
  • Information Systems and Management


Dive into the research topics of 'Database structure for a class of multi-period mathematical programming models'. Together they form a unique fingerprint.

Cite this