FLAMES® includes a robust, flexible, and customizable data recording capability to capture scenario execution results and write them to user-specified output files. These output files can be written in a compact, efficient FLAMES-specific format that can be read and processed by FLARE™. The output files can also be written in the industry-standard .dbf file format that can be processed by FLARE and almost any third-party spreadsheet, database, or data analysis package.
This topic provides an overview of FLARE and of some of the third-party tools that can be used to analyze FLAMES output data.
The FLAMES Analysis and Reduction Environment (FLARE) allows you to read scenario execution output data files generated by the FLAMES data recording capability and perform complex queries on the data.
FLARE can read output files in the compact, efficient FLAMES-specific format as well as data files in the industry standard .dbf file format. All data read from output files is stored in memory in relational database tables.
FLARE can be operated in two modes. In interactive mode, FLARE prompts you for individual commands that you can either enter with a keyboard or paste from text copied from a third-party text editor. In batch mode, which is the most common mode, FLARE reads and immediately processes a set of commands stored in a text file called a FLARE command file.
FLARE supports many utility commands such as:
LOAD – Loads (reads) the data from the specified file and stores the data in the table identified in the file
LIST – Lists the names of the relational database tables currently resident in memory
DESCRIBE – Describes each of the columns of the specified table
OPEN – Opens an output file to which query output reports will be written
START – Reads and processes the commands in the specified FLARE command file
FLARE also supports a subset of the statements of the industry standard Structured Query Language (SQL). The most important of these is the SELECT statement. Using the SELECT statement, table joins, the WHERE, GROUP BY, and ORDER BY clauses, and several different operators and functions, you can perform complex queries on the data in the database tables to support your data analysis.
Output from a FLARE query is a tabular text report. FLARE utility commands can specify the format of the reports. Reports can be displayed on your computer screen or, more typically, written to output files.
The most common way to use FLARE is to create a command file that contains all the commands to load the necessary data files, perform queries on the data, and save the query output reports in output files. The command file can then be specified as an input parameter when FLARE is executed. In this way, a single command to execute FLARE can generate all of your desired data reports.
Runtime licenses to FLARE are available for purchase separate from other FLAMES products.
Third-Party Analysis Tools
When FLAMES scenario execution output files are written in the industry standard .dbf file format, FLARE and almost any third-party spreadsheet, database, or data analysis package can be used to view and perform analysis on the data. Some of the third-party tools that can be used include:
JMP® from SAS® – All of the statistical analysis and data visualization capabilities available in JMP can be used with FLAMES output files, which JMP can read directly. JMP can also be used to design experiments and generate experiment files that can be used directly by FIRE™.
Database Programs – Almost all third-party database programs can read and process FLAMES output files.
Spreadsheet Programs – Almost all third-party spreadsheet programs can read and process FLAMES output files.