Dear Sucharita Ghosh,
About your question for interaction between Oracle and Splus.
It depends what you wish for "in an interactive fashion".
Here is one solution to your question, assuming:
interactive => HTML-based
Splus => R
I found that the Perl language had all of the pieces (libraries) for
me to put such an interactive system together.
For the Web interface to Oracle, I chose the DBI::Oracle library
(DBI = database interface), which can be retrieved from:
http://www.symbolstone.org/technology/perl/DBI/
The most recent Oracle module is version 1.03, released 12-Jul-199.
You need to have Perl 5, and there exists an active DBI email list
(~20-30 messages/day):
http://www.isc.org/view.cgi?/services/mailing-lists/dbi-lists.phtml
where users can ask questions. The Perl DBI modules are actively used
and actively supported software and is really robust.
Once you've queried the Oracle database with your Perl/DBI program,
you need to save the data to input into R. I just save the output
via my Perl script to a temporary data file.
For reading and processing the Oracle-output-file into R, I modified
the Perl "Rweb" code. Rweb is a beautiful and simple Perl (free,
online) library by Jeff Banfield that reads in simple data files via
the Web and processes those files using R, and then outputs the
results to your Web browser. The graphics displayed in the Web page
are produced in a postscript form in R, and converted to display to
the Web browser with the utilities: ghostscript and netpbm.
You can retrieve Rweb here:
http://www.math.montana.edu/Rweb/
In order for Rweb to work, you also need:
R: http://lib.stat.cmu.edu/R/CRAN/
netpbm: http://www.dsms.com/pub/mirror/netpbm/netpbm-1mar1994.tar.gz
ghostscript: http://www.cs.wisc.edu/~ghost/aladdin/get510.html
Perl: http://www.perl.com/pub/language/info/software.html
Since the Rweb code is an open source that already has a half-dozen
statitistical modules, one can add to the capabilities by writing more
R code. Banfield's Perl code is well-documented and straightforward to
modify. (You may want to talk to him to tell him what you are doing
and to give him credit.)
I've glossed over the details, but I hope that I've shown you that
such an interactive system can be built.
Amara
------------------------------------------------
>Is it possible to retrieve data from
>Oracle and use it in Splus in an interactive
>fashion?
>
>I would appreciate any information on this.
>Sincerely
>
>Sucharita Ghosh
>rita.ghosh@wsl.ch
--
***************************************************************
Amara Graps | Max-Planck-Institut fuer Kernphysik
Interplanetary Dust Group | Saupfercheckweg 1
+49-6221-516-543 | 69117 Heidelberg, GERMANY
Amara.Graps@mpi-hd.mpg.de * http://galileo.mpi-hd.mpg.de/~graps
***************************************************************
"Never fight an inanimate object." - P. J. O'Rourke
-----------------------------------------------------------------------
This message was distributed by s-news@wubios.wustl.edu. To unsubscribe
send e-mail to s-news-request@wubios.wustl.edu with the BODY of the
message: unsubscribe s-news
|