Re: [GENERAL] Dependency graph of all tuples relied upon in a query answer

2006-09-05 Thread Merlin Moncure
On 9/1/06, Randall Lucas <[EMAIL PROTECTED]> wrote: On Fri, Sep 01, 2006 at 09:30:57AM -0400, Merlin Moncure wrote: > A key tenet of relational thinking is to reduce all information to its > functional dependencies, and to try and avoid as much as possible > keeping information state in the data

Re: [GENERAL] Dependency graph of all tuples relied upon in a query answer

2006-09-01 Thread Randall Lucas
On Fri, Sep 01, 2006 at 09:30:57AM -0400, Merlin Moncure wrote: > On 8/31/06, Randall Lucas <[EMAIL PROTECTED]> wrote: > >Now that I have this query, in order to make my case, I need to "sign > >off" on all of the individual data that went into it. I would like to > >do something like: > > > >

Re: [GENERAL] Dependency graph of all tuples relied upon in a query answer

2006-09-01 Thread Merlin Moncure
On 8/31/06, Randall Lucas <[EMAIL PROTECTED]> wrote: Now that I have this query, in order to make my case, I need to "sign off" on all of the individual data that went into it. I would like to do something like: select last_query_shown_tuples(); schema | table_name | pk_columns | pk

Re: [GENERAL] Dependency graph of all tuples relied upon in a query answer

2006-08-31 Thread Randall Lucas
On Thu, Aug 31, 2006 at 09:17:54AM -0400, Merlin Moncure wrote: > On 8/30/06, Randall Lucas <[EMAIL PROTECTED]> wrote: > > >An inverted way of thinking about the problem is the notion of getting a > >source document (say, a "company registration form") and parsing and > >storing it in a normalized

Re: [GENERAL] Dependency graph of all tuples relied upon in a query answer

2006-08-31 Thread Merlin Moncure
On 8/30/06, Randall Lucas <[EMAIL PROTECTED]> wrote: I'm storing facts about an entity (e.g., "company") in a normalized form with various repeating groups, link tables, etc. My workflow requires that after (or as part of) collecting these facts, I be able to "sign off" as having verified all of