From mboxrd@z Thu Jan 1 00:00:00 1970 From: Andy Choens Subject: Re: Reproducible Research Template Date: Wed, 05 Jan 2011 12:24:28 -0500 Message-ID: <1294248268.4016.10.camel@Yates> References: <1294170927.2599.110.camel@Yates> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0234491840==" Return-path: Received: from [140.186.70.92] (port=57392 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1PaX69-0000wc-6A for emacs-orgmode@gnu.org; Wed, 05 Jan 2011 12:24:34 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1PaX68-0004tg-2e for emacs-orgmode@gnu.org; Wed, 05 Jan 2011 12:24:33 -0500 Received: from mail-qy0-f169.google.com ([209.85.216.169]:62252) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1PaX67-0004tZ-Ut for emacs-orgmode@gnu.org; Wed, 05 Jan 2011 12:24:32 -0500 Received: by qyk7 with SMTP id 7so16760578qyk.0 for ; Wed, 05 Jan 2011 09:24:31 -0800 (PST) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: "Thomas S. Dye" Cc: Org-mode ml --===============0234491840== Content-Type: multipart/alternative; boundary="=-2Onnij1mEp3NxMTYEoB3" --=-2Onnij1mEp3NxMTYEoB3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit On Wed, 2011-01-05 at 06:24 -1000, Thomas S. Dye wrote: > Most of my projects store data in a MySQL database. My projects > define queries that relate tables to one another, but the results > are > typically something that Org-mode understands---a flat table or a > single value. The reproducible research functions that I write > break > the analysis workflow down into separate tasks so that the results > of > a SQL query are written to the Org-mode buffer. Subsequent steps in > the workflow refer to the named results block. This way, the > Org-mode > project contains the actual data used in the analysis without the > need > to reproduce a relational structure. The functions that access the > SQL database go in the local library of babel because I don't want > to > give users of a RR document direct access to my database. > That is very interesting. I like the idea of separating the database queries from the flat table results. This is similar to my situation. The actual storage of the data is relational, but the queries needed to assess the data result in either flat tables or single values. Very good idea. --=-2Onnij1mEp3NxMTYEoB3 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 7bit
On Wed, 2011-01-05 at 06:24 -1000, Thomas S. Dye wrote:
Most of my projects store data in a MySQL database.  My projects 
define queries that relate tables to one another, but the results are 
typically something that Org-mode understands---a flat table or a 
single value.  The reproducible research functions that I write break 
the analysis workflow down into separate tasks so that the results of 
a SQL query are written to the Org-mode buffer.  Subsequent steps in 
the workflow refer to the named results block.  This way, the Org-mode 
project contains the actual data used in the analysis without the need 
to reproduce a relational structure.  The functions that access the 
SQL database go in the local library of babel because I don't want to 
give users of a RR document direct access to my database.


That is very interesting. I like the idea of separating the database queries from the flat table results. This is similar to my situation. The actual storage of the data is relational, but the queries needed to assess the data result in either flat tables or single values. Very good idea. --=-2Onnij1mEp3NxMTYEoB3-- --===============0234491840== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode --===============0234491840==--