FICO Xpress Optimization Examples Repository: Burglar - Data source access from Mosel models

FICO Xpress Optimization Examples Repository

FICO Optimization Community

FICO Xpress Optimization Home

Burglar - Data source access from Mosel models

Description

burglar.mos - data in the model, integer indices
burglari.mos - data in the model, string indices
burglar2.mos, burglar.dat - reading data from a text file
burglar2o.mos, burglar.mdb, burglar.sqlite - reading data with mmodbc.odbc
burglar2sql.mos, burglar.sqlite - reading data from SQLite, using SQL or ODBC
burglar2e.mos, burglar.xls - reading data with mmsheet.excel (Windows only)
burglar2dd.mos, burglardd.dat - reading data with mmetc.diskdata
burglar2ff.mos, burglarff.dat - reading data in free format
burglar2x.mos, burglar.xml - reading data in XML format
burglar2j.mos, burglar.json - reading data in JSON format

Difficulty rating: 2 (easy-medium)

Further explanation of this example: Whitepaper 'Generalized file handling in Mosel', Sections 3 Example problem and 4 Data source access from Mosel models

burgdatamos.zip

[download all files]

Source Files

By clicking on a file name, a preview is opened at the bottom of this page.

burglar.mos	[download]
burglari.mos	[download]
burglar2.mos	[download]
burglar2o.mos	[download]
burglar2sql.mos	[download]
burglar2e.mos	[download]
burglar2dd.mos	[download]
burglar2ff.mos	[download]
burglar2x.mos	[download]
burglar2j.mos	[download]

Data Files

burglar.dat	[download]
burglardd.dat	[download]
burglarff.dat	[download]
burglar.xml	[download]
burglar.json	[download]
burglar.mdb	[download]
burglar.xls	[download]
burglar.sqlite	[download]

burglar.dat

! Data file for `burglar2.mos'
          ! Item      Value  Weight
BurgData: [(camera)    [ 15   2]
           (necklace)  [100  20]
           (vase)      [ 90  20]
           (picture)   [ 60  30]
           (tv)        [ 40  40]
           (video)     [ 15  30]
           (chest)     [ 10  60]
           (brick)     [  1  10]]