 | |
#1
 
| |||
| |||
|
Query Dependency -
02-29-2008
, 01:57 AM
#2
| |||
| |||
|
|
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. |
and Inderpal Singh Mumick wrote a nice overview article in 1995:
http://citeseer.ist.psu.edu/22323.html
It's probably more than you wanted, but it should give an idea of how
much research there is on this (a lot!) and what the related problems
are, and as such a good starting point. They also wrote a book on the
subject:
http://mitpress.mit.edu/catalog/item...ype=2&tid=4157
which might be interesting to you, but I've never read that myself.
Good luck with your research,
-- Jan Hidders
#3
| |||
| |||
|
|
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. |
and Inderpal Singh Mumick wrote a nice overview article in 1995:
http://citeseer.ist.psu.edu/22323.html
It's probably more than you wanted, but it should give an idea of how
much research there is on this (a lot!) and what the related problems
are, and as such a good starting point. They also wrote a book on the
subject:
http://mitpress.mit.edu/catalog/item...ype=2&tid=4157
which might be interesting to you, but I've never read that myself.
Good luck with your research,
-- Jan Hidders
#4
| |||
| |||
|
|
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. |
and Inderpal Singh Mumick wrote a nice overview article in 1995:
http://citeseer.ist.psu.edu/22323.html
It's probably more than you wanted, but it should give an idea of how
much research there is on this (a lot!) and what the related problems
are, and as such a good starting point. They also wrote a book on the
subject:
http://mitpress.mit.edu/catalog/item...ype=2&tid=4157
which might be interesting to you, but I've never read that myself.
Good luck with your research,
-- Jan Hidders
#5
| |||
| |||
|
|
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. |
and Inderpal Singh Mumick wrote a nice overview article in 1995:
http://citeseer.ist.psu.edu/22323.html
It's probably more than you wanted, but it should give an idea of how
much research there is on this (a lot!) and what the related problems
are, and as such a good starting point. They also wrote a book on the
subject:
http://mitpress.mit.edu/catalog/item...ype=2&tid=4157
which might be interesting to you, but I've never read that myself.
Good luck with your research,
-- Jan Hidders
#6
| |||
| |||
|
|
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. |
and Inderpal Singh Mumick wrote a nice overview article in 1995:
http://citeseer.ist.psu.edu/22323.html
It's probably more than you wanted, but it should give an idea of how
much research there is on this (a lot!) and what the related problems
are, and as such a good starting point. They also wrote a book on the
subject:
http://mitpress.mit.edu/catalog/item...ype=2&tid=4157
which might be interesting to you, but I've never read that myself.
Good luck with your research,
-- Jan Hidders
#7
| |||
| |||
|
|
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. |
and Inderpal Singh Mumick wrote a nice overview article in 1995:
http://citeseer.ist.psu.edu/22323.html
It's probably more than you wanted, but it should give an idea of how
much research there is on this (a lot!) and what the related problems
are, and as such a good starting point. They also wrote a book on the
subject:
http://mitpress.mit.edu/catalog/item...ype=2&tid=4157
which might be interesting to you, but I've never read that myself.
Good luck with your research,
-- Jan Hidders
#8
| |||
| |||
|
|
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. |
and Inderpal Singh Mumick wrote a nice overview article in 1995:
http://citeseer.ist.psu.edu/22323.html
It's probably more than you wanted, but it should give an idea of how
much research there is on this (a lot!) and what the related problems
are, and as such a good starting point. They also wrote a book on the
subject:
http://mitpress.mit.edu/catalog/item...ype=2&tid=4157
which might be interesting to you, but I've never read that myself.
Good luck with your research,
-- Jan Hidders
#9
| |||
| |||
|
|
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. |
and Inderpal Singh Mumick wrote a nice overview article in 1995:
http://citeseer.ist.psu.edu/22323.html
It's probably more than you wanted, but it should give an idea of how
much research there is on this (a lot!) and what the related problems
are, and as such a good starting point. They also wrote a book on the
subject:
http://mitpress.mit.edu/catalog/item...ype=2&tid=4157
which might be interesting to you, but I've never read that myself.
Good luck with your research,
-- Jan Hidders
#10
| |||
| |||
|
|
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. |
and Inderpal Singh Mumick wrote a nice overview article in 1995:
http://citeseer.ist.psu.edu/22323.html
It's probably more than you wanted, but it should give an idea of how
much research there is on this (a lot!) and what the related problems
are, and as such a good starting point. They also wrote a book on the
subject:
http://mitpress.mit.edu/catalog/item...ype=2&tid=4157
which might be interesting to you, but I've never read that myself.
Good luck with your research,
-- Jan Hidders
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.