Re: [Help-glpk] Mathprog > SQLite/MySQL > GNUPlot - (Graphing LP and MIP results)

[Noli Sicad]

The idea that I am presenting here is using a databases as input and
output /results of LP and MIP model.

I am also trying to avoid proprietory software as well

> Last time this came up you rejected Excel due to having too much data for a
> spreadsheet.

I can not remember saying this statement above "rejected Excel". I
love Excel for data inputting. I even have example for the
transportation model in Excel using SQL statement.
http://www.mail-archive.com/address@hidden/msg03741.html


I am not really after of nice graphics but functional graphics similar
to gnuplot in GAMS.

http://www.gamsworld.org/mpsge/debreu/gnuplot/gnuplot.htm

> agree with you that this is not a sensible use of spreadsheets, but Excel
> can use data in a database as a datasource.

UPDATE SQL statement is not supported in EXCEL ODBC driver. You have
to delete the rows first. The results will be inserted - INSERT works.
 If you make a reference to the cells in these rows, you will have
errors in the pre-prepare graph template.

I am not developing a software program at this moment so I don't
really need Crystral Report or BIRT. I used Crystal Report before as
part of day time job.

I use GUSEK as IDE for mathprog, gnuplot, R package and Matplotlib
scripts. I like to visualise my LP and MIP results quickly by just
going to gnuplot tab and then run and see the graphs.

Noli


On 6/12/10, Nigel Galloway <address@hidden> wrote:
>
> Last time this came up you rejected Excel due to having too much data for a
> spreadsheet. I have since created an Excel spreadsheet with two 1.5 million
> datasets and plotted them in various combinations and graph types. Changing
> the graph took about 7.5 secs. It is essential to use keybord commands to
> navigate the changes as any mouse drag and drop did take far too long. I
> agree with you that this is not a sensible use of spreadsheets, but Excel
> can use data in a database as a datasource. You won't get better graphs.
>
> Another tool I use is qtiplot. Among the graph types that can be selected
> here are vector graphs (those graphs of little arrows which look like
> compasses in a magnetic field). You can choose other types, but the graphs
> are not as good as those produced by Excel.
>
> If this is a business problem requiring a business solution then that
> solution is probably Crystal Reports. Crystal Report is a Reporting
> Application that can generate reports from various Data Sources like
> Databases , XML files etc.
>
> Sadly the output from glpk is not XML, but I have a program written in Ruby
> that converts csv to XML. Or it did, perhaps it will need changing for the
> modified glpk csv format.
>
> See for my dreams come true:
> http://www.threedgraphics.com/tdg/enterprise/sap/crce/?gclid=CO3zso-kmKICFRM_lAodyGQpXg
>
> and note:
> Change chart properties dynamically at runtime
>
>> ----- Original Message -----
>> From: Noli Sicad <address@hidden>
>> To: "address@hidden" <address@hidden>
>> Subject: [Help-glpk] Mathprog > SQLite/MySQL > GNUPlot - (Graphing LP
>> and  MIP results)
>> Date: Fri, 11 Jun 2010 12:59:31 +1000
>>
>>
>> Hi,
>>
>> I have trying to find easy way to render business graphs from my
>> MathProg MIP and LP results. R package works quite well but you have
>> to prepare the in advance what sort of graphs to you like to have.
>>
>> What really we need is dynamic graphing compatibilities similar  to
>> ILOG ODM studio.
>>
>> I think lately gnuplot supports SQL statement, if I am not mistaken.
>>
>> Anyway, here what I found below
>>
>> Generating Graphs with gnuplot, Part 3 Sqlite3
>> http://www.linux.com/news/software/developer/26873:generating-graphs-with-gnuplot-part-3%3E
>>
>> GNUplot from sqlite3 using plot special-filename
>> http://schwehr.org/blog/archives/2009-05.html
>>
>> Using GNUPlot to chart MySQL data
>> http://www.krazyworks.com/using-gnuplot-to-chart-mysql-data/
>>
>> Or anybody doing this already?
>>
>> Noli
>>
>> _______________________________________________
>> Help-glpk mailing list
>> address@hidden
>> http://lists.gnu.org/mailman/listinfo/help-glpk
>
>>
>
>
> --
> _______________________________________________
> Surf the Web in a faster, safer and easier way:
> Download Opera 9 at http://www.opera.com
>
>