Data Management

Data Management

For a full description of Data Management in AIMMS see the User’s Guide.

Integrated Data Management

Case management is an important part of any decision support application that enables your end-users to run the model with varying scenarios. AIMMS provides an advanced data manager, which allows you to create data categories holding blocks of related data (for instance topology data, or supply and demand scenarios). Data sets associated with these data categories can be combined to form a single case, and thus can be shared by multiple cases. In addition, to perform an extensive what-if analysis, you can select a large number of cases to be run in batch mode overnight.

Database connectivity

MappingWizard.JPGAs data forms the life blood of any decision support application, AIMMS has extensive facilities to link your application to corporate databases and spreadsheets (Oracle, SQL, Sybase, MS Access, etc.) using ODBC data connectivity interfaces.

Special wizards (as shown on the left) help you to relate columns in a database table with the corresponding multidimensional identifiers in your AIMMS model. Once you have established such relationships, you can specify straightforward read and write statements to transfer data to and from the database.

Furthermore, AIMMS offers several powerful functions to perform database specific tasks. For example, to test the connections, to determine the underlying database table structures, or to directly execute SQL statements. AIMMS also offers support for database transactions.

Excel Add-In and spreadsheet functions

ExceAddIn.JPG

When end-users of an AIMMS application prefer using the common Microsoft Excel or Open Office Calc spreadsheet interface for data entry or as a common file format to store the results of an optimization model, AIMMS offers both an intuitive Excel Add-In and spreadsheet functions to exchange data between an Excel or Calc spreadsheet and your AIMMS model.

With the Excel Add-In, an Excel application can use an AIMMS model as an optimization component. Using the Excel Add-In configuration wizard shown on the right, you can easily specify an link between a range in the spreadsheet and an identifier in the underlying AIMMS model in a point-and-click manner. The add-in accepts Excel ranges containing data in various tabular and list formats. By simply pushing a button, or calling a Visual Basic function, the data in the spreadsheet can be exchanged with the AIMMS model.

Using the spreadsheet functions in AIMMS, an AIMMS application can use an Excel or Calc spreadsheet as a data source for retrieving input data or storing output data of the model. As the Excel Add-In, the spreadsheet functions support exchanging data with Excel and Calc in various tabular and list formats.

Support for XML files

XMLMapping.JPGAIMMS supports reading and writing XML files in almost every conceivable format.

A specialized wizard shown on the left helps you create a mapping between the XML schema associated with a specific XML file format and the multidimensional identifiers in your AIMMS model.

Once a mapping has been created, AIMMS offers a set of functions to read and write XML data according to it.