Database structures for mathematical programming models

Fourer, Robert

doi:10.1016/s0167-9236(97)00007-9

Cited by 36 publications

(15 citation statements)

References 32 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The optimization was taken to be over a 2 single planning period, however, and thus difficulties involving the indexing of data and model entities over time were not addressed. This paper extends the work of Fourer [9] to a multi-period case. We adopt the fundamental elements of Materials, Facilities, and Activities from the previous work, but add two more elements -Times and Storage-Areas.…”

Section: Introductionmentioning

confidence: 58%

“…As the project was supported by The AISI (American Iron and Steel Institute), the DSS was generic in concept, but capable of being specifically applied to any particular company's facilities by supplying appropriate data Fourer [9]. Complete data for a steelmaking operation, including values such as yields, capacities, and prices indexed over products and processes could be conveniently supplied in the form of relational database files.…”

Section: Introductionmentioning

confidence: 99%

“…The presence of subfiles implies a partially hierarchical rather than purely relational structure to the database; further details can be found in the earlier discussion of the one-period model Fourer [9].…”

mentioning

confidence: 99%

See 2 more Smart Citations

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

Dutta

Fourer

2008

Decision Support Systems

Self Cite

View full text Add to dashboard Cite

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 production and profit planning. We also compare the performances of two different types of database structures with respect to optimization.

show abstract

Section: Introductionmentioning

confidence: 58%

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

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

Dutta

Fourer

2008

Decision Support Systems

Self Cite

View full text Add to dashboard Cite

show abstract

“…A small collection of data for our example could be specified by an AMPL text file that begins as follows: Modeling language systems typically also offer facilities for exchange of data with popular databases, spreadsheets, and other repositories of data for decision support. Indeed there is a close correspondence between the way that data values are described in algebraic models and the way they are organized in relational databases (Fourer 1997). Close interaction with data management software is often important to the integration of optimization into business operations.…”

Section: Background and Motivationmentioning

confidence: 99%

A* Algorithm

2013

Encyclopedia of Operations Research and Management Science

View full text Add to dashboard Cite

A heuristic search procedure that selects a node in its search tree for expansion such that the selected node has minimum value of the sum of the cost to reach the node plus a heuristic cost value for that node, where the heuristic cost underestimates the true minimum cost of completion. See ▶ Artificial IntelligenceReferences Hart, P. E., Nilsson, N. J., & Raphael, B. (1968). A formal basis for the heuristic determination of minimum cost paths. IEEE Transactions on Systems Science and Cybernetics, 4, 100-107. Pearl, J. (1984). Heuristics. Reading, MA: Addison-Wesley. Acceptance Sampling ▶ Quality Control Acceptance-Rejection MethodIn stochastic or Monte Carlo simulation, a method for sampling from a given difficult target probability distribution by sampling from a distribution that is close to the target distribution and relatively easy to sample but possibly rejecting the generated output. Sometimes just called the rejection method. Activity LevelThe value taken by a structural variable in an intermediate or final solution to a linear programming problem. See ▶ Structural Variables Activity-Analysis ProblemA linear-programming problem of the form Maximize cx, subject to Ax b, x ! 0. The variables x j of the vector x are quantities of products to be produced. The b i coefficients of the resource vector b represent the amount of resource i that is available for production, the c j coefficients represent the value (profit) of one unit of output x j , and the coefficients a ij of the technological matrix A represent the amount of resource i required to produce one unit of product j. The a ij are termed technological or input-output coefficients. The objective function cx represents some measure of value of the total production. Adjacent (Neighboring) Extreme PointsTwo extreme points of a polyhedron that are connected by an edge of the polyhedron. Advertising IntroductionAdvertising research has focused on three substantive areas: sales response to advertising, optimal advertising policy (constant spending or pulsing), competitive reactions and over-time effects. The research has employed econometric, time-serioes, optimization and game theoretic analytical techniques to address the issues. The advent of enormous amounts of scanner panel and internet data has led to some fruitful modeling at the individual household level. Contributions in each one of the three areas are discussed. A thorough review of optimal control advertising models is given in Feichtinger, Hartl, and Sethi (1994). Mathematical programming also has been a useful technology. Since some early successful applications of this technology for media planning, the progress has been limited because of measurement problems relating to advertising response function (Little and Lodish 1969). Advances in research, however, provide reasons for optimism in identifying the response function (Little 1979; Eastlack and Rao 1986). Heuristic approaches have been developed to estimate the media characteristics of reach and frequency (Rust and Eechambadi 1989)...

show abstract

“…The software package was integrated with a management information system and uses dynamic simulation techniques to support production planning on a daily basis. Fourer (1997) implemented a generic linear programming model via a database system for production planning in the American steel industry, and Gazmuri and Arrate (1995) discuss the development of a system to build optimization models for a variety of applications. They employed a number of software tools from a prototype of a modeling system, and implement a general production-planning model in an appliance manufacturer in Chile.…”

Section: Importance Of Flexibility In Model Designmentioning

confidence: 99%

A relational database approach to a linear programming-based decision support system for production planning in secondary wood product manufacturing

Farrell¹,

Maness

2005

Decision Support Systems

View full text Add to dashboard Cite

In presenting this thesis in partial fulfilment of the requirements for an advanced degree at the University of British Columbia, I agree that the Library shall make it freely available for reference and study. I further agree that permission for extensive copying of this thesis for scholarly purposes may be granted by the head of my department or by his or her representatives. It is understood that copying or publication of this thesis for financial gain shall not be allowed without my written permission.

show abstract

Database structures for mathematical programming models

Cited by 36 publications

References 32 publications

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

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

A* Algorithm

A relational database approach to a linear programming-based decision support system for production planning in secondary wood product manufacturing

Contact Info

Product

Resources

About