From mboxrd@z Thu Jan  1 00:00:00 1970
From: Andy Choens <andy.choens@gmail.com>
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>
	<F8C7EAD6-3983-4C5E-9853-5027800E14D6@tsdye.com>
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0234491840=="
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
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 <andy.choens@gmail.com>) 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 <andy.choens@gmail.com>) 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 <emacs-orgmode@gnu.org>; Wed, 05 Jan 2011 09:24:31 -0800 (PST)
In-Reply-To: <F8C7EAD6-3983-4C5E-9853-5027800E14D6@tsdye.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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" <tsd@tsdye.com>
Cc: Org-mode ml <emacs-orgmode@gnu.org>


--===============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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.30.3">
</HEAD>
<BODY>
<BR>
On Wed, 2011-01-05 at 06:24 -1000, Thomas S. Dye wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
    <TT><FONT COLOR="#3c3c3c">Most of my projects store data in a MySQL database.&nbsp; My projects&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">define queries that relate tables to one another, but the results are&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">typically something that Org-mode understands---a flat table or a&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">single value.&nbsp; The reproducible research functions that I write break&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">the analysis workflow down into separate tasks so that the results of&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">a SQL query are written to the Org-mode buffer.&nbsp; Subsequent steps in&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">the workflow refer to the named results block.&nbsp; This way, the Org-mode&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">project contains the actual data used in the analysis without the need&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">to reproduce a relational structure.&nbsp; The functions that access the&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">SQL database go in the local library of babel because I don't want to&nbsp; </FONT></TT><BR>
    <TT><FONT COLOR="#3c3c3c">give users of a RR document direct access to my database.</FONT></TT><BR>
    <BR>
</BLOCKQUOTE>
<BR>
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.
</BODY>
</HTML>

--=-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==--