Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Knut Staring
On Thu, May 27, 2010 at 6:39 PM, Bob Jolliffe wrote: > On 27 May 2010 17:27, Knut Staring wrote: >> DHIS already has the concept of datamart and report tables, which do >> provide some separation of the transactional from the analytical, >> though we also have plans for improving this. >> >> R-no

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Bob Jolliffe
On 27 May 2010 17:27, Knut Staring wrote: > DHIS already has the concept of datamart and report tables, which do > provide some separation of the transactional from the analytical, > though we also have plans for improving this. > > R-node with Jquery /GeoExt looks interesting: > http://www.r-stat

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Knut Staring
DHIS already has the concept of datamart and report tables, which do provide some separation of the transactional from the analytical, though we also have plans for improving this. R-node with Jquery /GeoExt looks interesting: http://www.r-statistics.com/2010/04/r-node-a-web-front-end-to-r-with-pr

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Jason Pickering
Hi Roger, Valid concerns, but I would assume that the typical use case for R would be that the user would typically only be looking at 1) a view that has been prepared for them or 2) be provided with read only access to selected tables. I would not expect that locks would be a problem in this case

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Friedman, Roger (CDC/OID/NCHHSTP) (CTR)
My concern would be DB performance, there's no telling what kind of locks R or any other product using odbc/jdbc is going to use. I'm already worried about simultaneous transactional and reporting use. Have there been any large-volume performance tests? Has any thought been given to splitting

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Jason Pickering
Yeah, this I guess comes back time and time again, with my some what uncomfortable relationship with Hibernate and Java. Clearly, we need to think about how to make certain procedures crossplatform compatible (cross platform in the sense of working between Postgres/MySQL and other DBs) with the nee

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Bob Jolliffe
On 27 May 2010 11:15, Jason Pickering wrote: > Hi Bob, > > Yes, I suspect that most R users would probably want to do things > their own way. It has a rather steep learning curve. :) > > As for canned R scripts, the best way would probably with with PL/R, a > procedural Postgresql language which u

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Knut Staring
OpenXdata is looking at R integration over Hibernate, aiming to have a web based analytical tool similar to RCmdr/SPSS: "RCmdr is an R package that provides a user interface which is quite similar to SPSS, perhaps the most popular package used for statistical analysis by study designers and public

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Knut Staring
On Thu, May 27, 2010 at 11:45 AM, Bob Jolliffe wrote: > We've talked before about integrating scripting engine (such as R) > into dhis : http://www.rforge.net/rscript/ > > But my guess is that most R users are going to be of a level of > sophistication that they would be most comfortable doing the

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Jason Pickering
Hi Bob, Yes, I suspect that most R users would probably want to do things their own way. It has a rather steep learning curve. :) As for canned R scripts, the best way would probably with with PL/R, a procedural Postgresql language which utilizes R. http://www.joeconway.com/plr/doc/index.html I

Re: [Dhis2-users] [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Bob Jolliffe
We've talked before about integrating scripting engine (such as R) into dhis : http://www.rforge.net/rscript/ But my guess is that most R users are going to be of a level of sophistication that they would be most comfortable doing the kind of thing you describe - conecting directly to db with r cl

[Dhis2-users] DHIS2 with R

2010-05-27 Thread Jason Pickering
Hi everyone. I have had a recent question from a user about how DHIS2 can be used with R. I am including a trivial example here about how to use R as as a client to access data and produce a graph in DHIS2. Just get a copy of R and install the DBI and RPostregSQL packages with >install.packages(