System and method for rewriting relational database queries

Details System and method for rewriting relational database queries System and method for rewriting relational database queries

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2326135

A system and method for answering a re-lational database query is presented. According to an embodiment of the present invention, a database query is received. It is then determined whether that query can be rewritten in such a manner as to be able to utilize a precomputed view, such that an answer to the rewritten query is equivalent to an answer to the original query. If the query can be rewritten, it is determined whether the rewritten query can more efficiently derive the answer than the original query. The query which has the most efficiently derived an-swer is the query which is utilized to derive that answer.

L'invention concerne un système et un procédé de réponse à une interrogation d'une base de données relationnelle. Selon un mode de réalisation de la présente invention, une interrogation de base de données est reçue. Il est ensuite déterminé si cette interrogation peut être réécrite d'une manière à pouvoir utiliser une vue précalculée, de sorte qu'une réponse à l'interrogation réécrite soit équivalente à une réponse à l'interrogation d'origine. Si l'interrogation peut être réécrite, il est déterminé si l'interrogation réécrite peut obtenir plus efficacement la réponse que l'interrogation d'origine. L'interrogation ayant la réponse obtenue le plus efficacement est l'interrogation utilisée pour obtenir cette réponse.

Affiliated with

Also associated with

Rating

System and method for rewriting relational database queries does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for rewriting relational database queries, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for rewriting relational database queries will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1595606