Developing integrated decision support systems from mathematical models
Downs, Michael S.
MetadataShow full item record
A methodology for the creation of decision support systems (DSS) from mathematical programming models is examined. This approach is demonstrated using a model for flight scheduling, integrating a formal data model, represented in a database management system (Paradox), and a mathematical programming model, represented in an executable mathematical modeling language (GAMS). The integration is completed by creating a database capable of supporting the GAMS model creating a series of queries to extract the data required by the GAMS model, and finally by modifying the GAMS model to import the external data sets and write the results to a file that can be interpreted by the database. This process is first completed manually to support a specific GAMS model. In the second portion of this thesis, the process is generalized to provide a framework that can be used to design a front-end database for any GAMS model. Benefits of this integrated approach over using a stand alone mathematical model include: The assurance of model integrity, explicit data modeling, improved representation and manipulation of model inputs and outputs, greater integrity of input data, and easier interpretation and multiple views of model outputs.
RightsThis publication is a work of the U.S. Government as defined in Title 17, United States Code, Section 101. Copyright protection is not available for this work in the United States.
Showing items related by title, author, creator and subject.
Hoppenstand, Gregory S. (Monterey, California. Naval Postgraduate School, 1988-03);When classified data of different classifications are stored in a database, it is necessary for a contemporary database system to pass through other classified data to find the properly classified data. Although the user ...
Modeling data encapsulation and a communication network for the National Training Center, Fort Irwin, CA. Benson, Kirk C. (Monterey, California. Naval Postgraduate School, 1997-03);The National Training Center (NTC) located at Fort Irwin, California provides the U.S. Army sole replication of a desert combat environment. The NTC provides U.S. Army brigade size heavy forces both realistic training ...
Barnes, Gerald Byron (Monterey, California. Naval Postgraduate School, 1994-09);Object-oriented data modeling is starting to replace the relational model for many recently emerging database applications. The complex nature of these databases precludes mapping of their data directly into a tabular ...