RE: R, SQL, i2b2, and governance RE: Example (Re: Empirical Data Dictionary)

2014-10-07 Thread Dan Connolly
pc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Alex Bokov [bo...@uthscsa.edu] Sent: Tuesday, October 07, 2014 9:41 AM To: gpc-dev@listserv.kumc.edu Subject: Re: R, SQL, i2b2, and governance RE: Example (Re: Empirical Data Dictionary) Yes, I'm fully in agreement there-- no d

Re: R, SQL, i2b2, and governance RE: Example (Re: Empirical Data Dictionary)

2014-10-07 Thread Alex Bokov
Yes, I'm fully in agreement there-- no direct, unlimited queries by investigators. Or under normal circumstances, us, for that matter. The only variable parts are the patient/visit sets. I see the goal of the initial cohort work is learning how to generalize these queries so they can be automa

R, SQL, i2b2, and governance RE: Example (Re: Empirical Data Dictionary)

2014-10-06 Thread Dan Connolly
(Please excuse the awkward top-posting format; I'm stuck with Microsoft Outlook.) Perhaps we're converging... the new Data Builder code delivers an sqlite3 file, so you can continue to use SQL to analyze it; and if you like