Search Postgresql Archives

Dependency graph of all tuples relied upon in a query answer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 the facts that pertain to a
given company.  I understand this as meaning I need to sign off on each
row that was used in answering the query "select * from company left
join ..."

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 format.  How do you "tag" the origin of each
and every row in every table that resulted from that source document?
It is possible to do so by associating an extra column with each
inserted or modified value (yuck).

It seems to me that the elegant way to do this would be to get the
entire graph of dependencies for not only all tables that reference the
entity, but only those rows within those tables that refer specifically
to my entity.

The query engine should have a pretty good idea about which tables and
which rows would actually be used in forming the responses to a given
query.  How can I get this information?  Or am I off the deep end (-ency
graph) with this one?

Best,

Randall

-- 
Randall Lucas       Tercent, Inc.       DF93EAD1


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux