Dynamic selection of source table for db rollup aggregation and query rewrite based on model driven definitions and cardinality estimates
US-2015379080-A1 · Dec 31, 2015 · US
US9489428B2 · US · B2
| Field | Value |
|---|---|
| Publication number | US-9489428-B2 |
| Application number | US-201314139180-A |
| Country | US |
| Kind code | B2 |
| Filing date | Dec 23, 2013 |
| Priority date | Sep 5, 2011 |
| Publication date | Nov 8, 2016 |
| Grant date | Nov 8, 2016 |
A practical reading order for non-experts. Skip the full description unless you need deep technical detail.
What the patent document calls the invention.
A short plain-language summary of the technical disclosure.
Who owns or filed the patent and who is credited as inventor.
Filing, priority, publication, and grant dates set the timeline.
The legal scope of protection — read this for what is actually claimed.
Technology tags used to group this patent with similar filings.
Prior art links and similar publications in this corpus.
Official abstract text for this publication.
Disclosed is a search ranking method for community users. The method includes: calculating a pre-ranking factor and an offline ranking factor according to historical behavior data of users; performing weighted ranking on inverted indices of the users by taking the pre-ranking factor as a weight, to obtain orderly inverted user index data; and with respect to a logged-in search user, in search results obtained according to the index data, performing weighted calculation on the search results according to the offline ranking factor, to obtain final ranking results. Also disclosed is a search ranking system for community users. The method and system can enable a user to obtain more optimized search ranking results.
Opening claim text (preview).
What is claimed is: 1. A search ranking method for community users, comprising: calculating, by a search ranking system, a pre-ranking factor and an offline ranking factor according to historical behavior data of users searched from a search for community users according to a keyword inputted by a searching user; performing, by the search ranking system, a first weighted ranking on inverted indices of searched users by taking the pre-ranking factor as a weight, to obtain orderly inverted indices data, wherein the inverted indices of searched users are obtained by from said search for community users; in a case that the searching user is a logged-in search user, performing, by the search ranking system, a second weighted ranking on search results of the first weighted ranking according to the offline ranking factor, to obtain final ranking results for community users; and presenting the final ranking results for community users to the searching user, wherein the pre-ranking factor includes user activeness information calculated according to data on a user level of a user in the community, and data on the user's recent log-ins and usages of the community, and the offline ranking factor includes at least one of user preference information or user category information obtained by analyzing data on articles posted or read by a user in a community, persons with whom the searching user has communicated or become friends, and persons followed by the searching user; user potential friendship chain information obtained by analyzing data on friends of the searching user in the community and persons followed by the searching user in the community; and user intimacy degree information calculated according to data on interactivities between the searching user and friends. 2. The search ranking method for community users according to claim 1 , further comprising: in the case that the searching user is a non-login search user, obtaining, by the search ranking system, location information of the non-login search user to calculate an online ranking factor; and performing, by the search ranking system, a third weighted ranking on search results of the second weighted ranking according to the online ranking factor, such that items in the same location as the non-login searching user or near the location of the non-login searching user are ranked higher, to obtain final ranking results. 3. The search ranking method for community users according to claim 1 , further comprising: obtaining, by the search ranking system, location information of the logged-in search user to calculate an online ranking factor; and performing, by the search ranking system, a third weighted ranking on search results of the second weighted ranking according to the online ranking factor, such that items in the same location as the logged-in searching user or near the location of the logged-in searching user are ranked higher, to obtain final ranking results. 4. The search ranking method for community users according to claim 1 , further comprising: calculating, by the search ranking system, an online ranking factor according to attribute information of the logged-in searching user; and performing, by the search ranking system, weighted ranking on search results of the second weighted ranking according to the online ranking factor, such that community users having same or similar attributes as the logged-in searching user are ranked higher, to obtain final ranking results. 5. A search ranking system for community users, comprising: processing circuitry configured to: calculate a pre-ranking factor and an offline ranking factor according to historical behavior data of users searched from a search for community users according to a keyword inputted by a searching user; perform a first weighted ranking on inverted indices of searched users by taking the pre-ranking factor as a weight, to obtain orderly inverted indices data, wherein the inverted indices of searched users are obtained by from said search for community users; in a case that the searching user is a logged-in searching user of the community user, perform a second weighted ranking on search results of the first weighted ranking according to the offline ranking factor, to obtain final ranking results for community users: and present the final ranking results for community users to the searching user, wherein the pre-ranking factor includes user activeness information calculated according to data on a user level of a user in the community, and data on the user's recent log-ins and usages of the community, and the offline ranking factor includes at least one of user preference information or user category information obtained by analyzing data on articles posted or read by a user in a community, persons with whom the searching user has communicated or become friends, and persons followed by the searching user; user potential friendship chain information obtained by analyzing data on friends of the searching user in the community and persons followed by the searching user in the community; and user intimacy degree information calculated according to data on interactivities between the searching user and friends. 6. The search ranking system for community users according to claim 5 , wherein the processing circuitry is further configured to: in a case that the searching user is a non-login searching user, obtain location information of the non-login searching user to calculate an online ranking factor; and perform a third ranking on search results of the second weighted ranking according to the online ranking factor, such that items in the same location as the non-login searching user or near the location of the searching user are ranked higher, to obtain final ranking results. 7. The search ranking system for community users according to claim 5 , wherein the processing circuitry is further configured to: obtain location information of the logged-in searching user to calculate an online ranking factor; and perform a third weighted ranking on search results of the second weighted ranking according to the online ranking factor, such that items in the same location as the logged-in searching user or near the location of the logged-in searching user are ranked higher, to obtain final ranking results. 8. The search ranking system for community users according to claim 5 , wherein the processing circuitry is further configured to: calculate an online ranking factor according to attribute information of the logged-in searching user; and perform a third weighted ranking on search results of the second weighted ranking according to the online ranking factor, such that community users having same or similar attributes as the logged-in searching user are ranked higher, to obtain final ranking results.
Business processes related to social networking or social networking services · CPC title
Physics · mapped topic
Physics · mapped topic
Physics · mapped topic
Querying (for retrieval from the web G06F16/953) · CPC title
Related publications grouped by family.
Answers are generated from the same data shown on this page.