Method and apparatus for querying relational databases

G - Physics – 06 – F

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

G06F 17/30 (2006.01)

Patent

CA 2480687

The invention provides a method of evaluating a query involving a relational database comprising a relational database management system (RDBMS), said query relating to at least one table of said relational database, said method comprising determining a table as a gateway table for evaluating said query, retrieving one or more unique identifiers of said gateway table related to one or more entries in a table to be queried, retrieving information from tables to be queried related to said retrieved unique identifiers of said gateway table, and providing a result set comprising the retrieved primary keys of the gateway table in relation to said retrieved information. The invention further provides a related data processing system and program.

La présente invention concerne un procédé qui permet d'évaluer une interrogation impliquant une base de données relationnelle comprenant un système de gestion de base de données relationnelle (RDBMS), ladite interrogation étant liée à au moins une table de ladite base de données relationnelle, lequel procédé consiste à déterminer une table comme table passerelle afin d'évaluer l'interrogation, à extraire de ladite table passerelle au moins un identificateur unique lié à au moins une entrée d'une table à interroger, à extraire des tables à interroger des informations liées auxdits identificateurs uniques de la table passerelle précitée, et à fournir un ensemble de résultats comprenant les clés primaires extraites de la table passerelle liées aux informations extraites.L'invention se rapporte également à un système et à un programme de traitement des données connexes.

LandOfFree

Say what you really think

Search LandOfFree.com for Canadian inventors and patents. Rate them and share your experience with other people.

Rating

Method and apparatus for querying relational databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for querying relational databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for querying relational databases will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFCA-PAI-O-1758578

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.