Method and apparatus for ranked join indices
View Patent ↗A method and apparatus for ranked join indices includes a solution providing performance guarantees for top-k join queries over two relations, when preprocessing to construct a ranked join index for a specific join condition is permitted. The concepts of ranking join indices presented herein are also applicable in the case of a single relation. In this case, the concepts herein provide a solution to the top-k selection problem with monotone linear functions, having guaranteed worst case search performance for the case of two ranked attributes and arbitrary preference vectors.
1. A method of creating a ranked join index for ordered data entries, comprising:
determining, via a processor, a dominating set of said ordered data entries;
mapping said dominating set of said ordered data entries according to rank attributes;
determining a separating vector for each set of adjacent mapped data entries; and
ordering said data entries according to a separating point associated with each of said separating vectors.
2. The method of claim 1 , wherein said determining the dominating set of said ordered data entries, comprises:
maintaining a priority queue of a predetermined size of said ordered data entries according to said rank attributes, wherein data entries having highest combined rank attribute values are maintained in said priority queue;
wherein, if said priority queue has reached a maximum capacity, only data entries having combined rank attribute values greater than an attribute value of data with a minimum rank value present in the priority queue are added to the priority queue.
3. The method of claim 2 , wherein said predetermined size corresponds to a minimum number of data entries necessary to generate, a ranked join index providing answers with a desired guaranteed performance on any top-k join query.
4. The method of claim 1 , wherein said ordering said data entries, comprises:
sweeping a vector across a plane of said mapped data entries, wherein each time said vector crosses a separating vector, a current composition of highest ranked data entries changes by swapping at least one of the data entries in the adjacent data entries set if it causes a change in the index; and
wherein each time a data entry is swapped, the highest ranked data entries are materialized and a new index entry is initiated.
5. The method of claim 1 , wherein said ordering is query independent such that substantially any user preference query is resolved using said index.
6. The method of claim 1 , wherein said each set of adjacent mapped data entries comprises more than two mapped data points if data entries are collinear.
7. The method of claim 1 , wherein performance guarantees are provided for an amount of time said index requires for resolving user queries.
8. The method of claim 1 , further comprising merging ordered data entries.
9. The method of claim 8 , wherein said merging results in a storage space requirement for said index that is characterized according to an equation:
O(nK 2 (K+m)/m)
wherein n represents a total number of data entries to be indexed, K represents an upper bound on a number of high ranking data entries that is requested by a user, and m represents a total number of data entries to be merged.
10. The method of claim 8 , wherein said merging results in a query time for said index that is characterized according to an equation:
O(log(nK 2 /m)+(K+m)log(K+m))
wherein n represents a total number of data entries to be indexed, K represents an upper bound on a number of high ranking data entries that is requested by a user, and m represents a total number of data entries to be merged.
11. The method of claim 8 , wherein said merging said ordered data entries provides a space and time tradeoff.
12. The method of claim 11 , wherein said space and time tradeoff comprises reducing a query time of said index by increasing a storage space of said index.
13. The method of claim 11 , wherein said space and time tradeoff comprises reducing a storage space required by said index by increasing a query time of said index.
14. A method of providing solutions to top-k join queries of ranked data entries for user specified preferences, comprising:
determining, via a processor, a dominating set of said ranked data entries;
mapping said dominating set of said ranked data entries according to rank attributes;
creating a ranked join index for said ranked data entries by determining a separating vector for each set of adjacent mapped data entries;
ordering said data entries according to a separating point associated with each of said separating vectors; and
providing a solution for a user preference query using said ranked join index.
15. A computer-readable medium storing a set of instructions, which when executed by a processor, perform a method of creating a ranked join index for ordered data entries, comprising:
determining a dominating set of said ordered data entries;
mapping said dominating set of said ordered data entries according to rank attributes;
determining a separating vector for each set of adjacent mapped data entries; and
ordering said data entries according to a separating point associated with each of said separating vectors.
16. A computer-readable medium storing a set of instructions, which when executed by a processor, perform a method of providing solutions to top-k join queries of ranked data entries for user specified preferences, comprising:
determining a dominating set of said ranked data entries;
mapping said dominating set of said ranked data entries according to rank attributes;
creating a ranked join index for said ranked data entries by determining a separating vector for each set of adjacent mapped data entries;
ordering said data entries according to a separating point associated with each of said separating vectors; and
providing a solution for a user preference query using said ranked join index.
17. An apparatus, comprising a memory storing information and program instructions and a processor executing said instructions, said apparatus adapted to perform a method of creating a ranked join index for ordered data entries comprising:
determining a dominating set of said ordered data entries;
mapping said dominating set of said ordered data entries according to rank attributes;
determining a separating vector for each set of adjacent mapped data entries; and
ordering said data entries according to a separating point associated with each of said separating vectors.
18. The apparatus of claim 17 , wherein said determining the dominating set of said ordered data entries, comprises:
maintaining a priority queue of a predetermined size of said ordered data entries according to said rank attributes, wherein data entries having highest combined rank attribute values are maintained in said priority queue;
wherein, if said priority queue has reached a maximum capacity, only data entries having combined rank attribute values greater than an attribute value of data entries with a minimum rank value present in the priority queue are added to the priority queue.
19. The apparatus of claim 18 , wherein the predetermined size of said priority queue corresponds to a minimum number of data entries necessary to generate, a ranked join index providing answers with a desired guaranteed performance on any top-k join query.