Re: Creating Graphs from Oracle Database.

I'm investigating an XML-based solution, though it's still very early days. In a nutshell my data comes out of the DB as an XML file, and I've got a few XSLs to transform it into something readable. For graphics I'm turning it into SVG. It works for bar charts and graphs, but not yet for pies as SVG curves are a b****** to program. The beauty of this approach is that the serious coding is done once, in the DB, and all the graphics are done on the client.

If anyone's trying something similar, I'd love to share experiences.

"Brian Peasland" <peasland_at_usgs.gov> wrote in message news:3AD5A446.C948CA00_at_usgs.gov...
> Aside from all of the other fine answers given, I thought that I would
> add the following, FREE solution! That's right it's free! Just step
> right up and take it!!!!
>
> I just implemented this very solution using Perl, CGI, DBI, and Perl's
> Chart module. You can then run this on any web server which will handle
> CGI. They all do, but you might need to make some configuration changes.
> If you want a great free web server, get Apache!
>
> In a nutshell, Perl is the scripting language that performs all of the
> logic. After you've installed Perl, install the CGI module. This module
> lets you write programs that displays web pages. Then install the DBI
> module. This is the database interface module which lets your Perl
> program talk to a database. Before the DBI module can connect, you will
> need to load your vendor specific database driver (DBD) module as well.
> Then load the Chart module. This lets you take data points and produce
> some pretty good charts. You can have your Perl program automatically
> render the chart to the browser.
>
> While this method may not have all the bells and whistles of expensive
> products like Oracle Developer, it is a tried and true method that works
> great!!!!!
>
> HTH,
> Brian
>
>
> > Anurag Minocha wrote:
> >
> > Hi,
> >
> > Right now we use Excel to connect to Oracle and then create the graphs
> > which we store as Images and then finally saved to be displayed on our
> > web site.
> >
> > This whole process is manual and consumes a lot of time and has to be
> > done daily.
> > Is there any tool which automates this and the graph automatically
> > gets updated on the web site.
> >
> > Our database is Oracle 8.0.5 and we are using OAS 4.0.8.
> >
> > Please suggest.
> >
> > Thanks
> > Anurag
> >
> > -- Posted from jshemail.herold.com [63.105.8.12] via Mailgate.ORG
> > Server - http://www.Mailgate.ORG
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Thu Apr 12 2001 - 08:43:40 CDT