Query Dependency
From: Ly Hoang Hai <lyhoanghai_at_gmail.com>
Date: Thu, 28 Feb 2008 23:57:43 -0800 (PST)
Message-ID: <57f69484-c9fd-4761-95e4-719b04cd39c4_at_s19g2000prg.googlegroups.com>
Hi,
My current research leads me to the problem of analysis the dependency between 2 database query.
For example: There is an UPDATE query and then a SELECT query. My system have to automatically detect whether the SELECT query result is affected by the parameters of the prior UPDATE query or not. If UPDATE is carried on on table X and SELECT is on table Y and the answer is NO. Even in the case that UPDATE and SELECT is launched for the same table, they are sometime independent of each other (I"ndependent" means I can undo the UPDATE query and the result of SELECT is unchanged).
Date: Thu, 28 Feb 2008 23:57:43 -0800 (PST)
Message-ID: <57f69484-c9fd-4761-95e4-719b04cd39c4_at_s19g2000prg.googlegroups.com>
Hi,
My current research leads me to the problem of analysis the dependency between 2 database query.
For example: There is an UPDATE query and then a SELECT query. My system have to automatically detect whether the SELECT query result is affected by the parameters of the prior UPDATE query or not. If UPDATE is carried on on table X and SELECT is on table Y and the answer is NO. Even in the case that UPDATE and SELECT is launched for the same table, they are sometime independent of each other (I"ndependent" means I can undo the UPDATE query and the result of SELECT is unchanged).
In database research, is there any research area about this topic? I do not know which keywords I should use to "google".
If you know, please give me some advice.Thanks in advance Received on Fri Feb 29 2008 - 08:57:43 CET