skip to main content
10.1145/1142473.1142516acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
Article

Ranking objects based on relationships

Published: 27 June 2006 Publication History

Abstract

In many document collections, documents are related to objects such as document authors, products described in the document, or persons referred to in the document. In many applications, the goal is to find these objects that best match a set of keywords. However, the keywords may not necessarily occur in the target objects; they occur only in the documents. For example, in a product review database, a user might search for names of products (say, laptops) using keywords like "lightweight" and "business use" that occur only in the reviews but not in the names of laptops. In order to answer these queries, we need to exploit relationships between documents containing the keywords and the target objects related to those documents. Current keyword query paradigms do not exploit these relationships effectively and hence are inefficient for these queries.In this paper, we consider a class of queries called the "object finder" queries. Our main intuition is to exploit the relationships between searchable documents and related objects and further "aggregate" the document scores from these relationships in order to find the best ranking target objects. Building upon existing keyword search engines such as full text search, we design efficient algorithms that exploit the requirement of only the best k target objects to terminate early. The main challenge here is to push early termination through blocking operators such as group by and aggregation. Our experiments with real datasets and workloads demonstrate the effectiveness of our techniques. Although we present our techniques in the context of keyword search, our techniques apply to other types of ranked searches (e.g., multimedia search) as well.

References

[1]
S. Agrawal, S. Chaudhuri and G. Das. DBExplorer: A System for Keyword Search over Relational Databases. In Proc. of ICDE, 2002.
[2]
S. Agrawal, S. Chaudhuri, G. Das and A. Gionis. Automated Ranking of Database Query Results. In Proc. of CIDR, 2003.
[3]
R. Baeza_yates and B. Ribiero-Neto, Modern Information Retrieval, ACM Press, 1999.
[4]
A. Balmin, V. Hristidis and Y. Papakonstantinou, ObjectRank: Authority-Based Keyword Queries in Databases, In Proc. of VLDB, 2004.
[5]
G. Bhalotia, A. Hulgeri, C. Nakhe, S. Chakrabarti and S. Sudarshan, Keyword Searching and Browsing in Databases using BANKS, In Proc. of ICDE, 2002.
[6]
S. Chaudhuri and L. Gravano, Evaluating Top-k Selection Queries, In Proc. of VLDB, 1999.
[7]
S. Chaudhuri, R. Ramakrishnan and G. Weikum, Integrating DB and IR Technologies: What is the Sound of One Hand Clapping?, In Proc. of CIDR, 2005.
[8]
J. Conrad and M. H. Utt, A System for Discovering Relationships by Feature Extraction from Text Databases, In Proc. of SIGIR, 1994.
[9]
S. Dessloch and N. Mattos, Integrating SQL Databases With Content-Specific Search Engines. In Proc. of VLDB, 1997.
[10]
R. Fagin, Combining fuzzy information from multiple systems. In Journal of Computer and System Sciences, 1999.
[11]
R. Fagin, A. Lotem and M. Naor, Optimal Aggregation Algorithms for Middleware, In Journal of Computer and System Sciences, 2003.
[12]
U. Guntzer, W. Balke and W. Kieβling, Optimizing Multi-Feature Queries for Image Databases. In Proc. of VLDB, 2000.
[13]
V. Hristidis and Y. Papakonstantinou, DISCOVER: Keyword Search in Relational Databases, In Proc. of VLDB Conference, 2002
[14]
I. Ilyas, W. Aref and A. Elmagarmid, Supporting Top-k Join Queries in Relational Databases. In Proc. of VLDB, 2003.
[15]
D. Mattox, Expert Finder. MITRE Publications, 'The Edge', http://www.mitre.org/news/the_edge/june_98/third.html, Jun 1998
[16]
S. Nepal and M. V. Ramakrishna, Query Processing Issues in Image (Multimedia) Databases, In Proc. of ICDE, 1999.
[17]
Z.Nie, Y. Zhang, J. Wen and W. Ma, "Object-Level Ranking: Bringing Order to Web Objects", In Proc. of WWW, 2005.
[18]
E. Voorhees, Introduction to Information Extraction and Message Understanding Conferences, http://www.itl.nist.gov/iaui/894.02/related_projects/muc/

Cited By

View all
  • (2016)Memory-based Recommendations of Entities for Web Search UsersProceedings of the 25th ACM International on Conference on Information and Knowledge Management10.1145/2983323.2983823(35-44)Online publication date: 24-Oct-2016
  • (2016)Beyond entities: promoting explorative search with bundlesInformation Retrieval10.1007/s10791-016-9283-519:5(447-486)Online publication date: 1-Oct-2016
  • (2015)Mining Subjective Properties on the WebProceedings of the 2015 ACM SIGMOD International Conference on Management of Data10.1145/2723372.2750548(1745-1760)Online publication date: 27-May-2015
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SIGMOD '06: Proceedings of the 2006 ACM SIGMOD international conference on Management of data
June 2006
830 pages
ISBN:1595934340
DOI:10.1145/1142473
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 27 June 2006

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. aggregation
  2. early termination
  3. keyword search
  4. named entities
  5. ranking
  6. relationships
  7. top-k queries

Qualifiers

  • Article

Conference

SIGMOD/PODS06
Sponsor:

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)11
  • Downloads (Last 6 weeks)0
Reflects downloads up to 02 Mar 2025

Other Metrics

Citations

Cited By

View all
  • (2016)Memory-based Recommendations of Entities for Web Search UsersProceedings of the 25th ACM International on Conference on Information and Knowledge Management10.1145/2983323.2983823(35-44)Online publication date: 24-Oct-2016
  • (2016)Beyond entities: promoting explorative search with bundlesInformation Retrieval10.1007/s10791-016-9283-519:5(447-486)Online publication date: 1-Oct-2016
  • (2015)Mining Subjective Properties on the WebProceedings of the 2015 ACM SIGMOD International Conference on Management of Data10.1145/2723372.2750548(1745-1760)Online publication date: 27-May-2015
  • (2015)Strength of Relationship Between Multi-labeled Data and LabelsInformation and Communication Technology10.1007/978-3-319-24315-3_10(99-108)Online publication date: 19-Nov-2015
  • (2013)Penguins in sweaters, or serendipitous entity search on user-generated contentProceedings of the 22nd ACM international conference on Information & Knowledge Management10.1145/2505515.2505680(109-118)Online publication date: 27-Oct-2013
  • (2013)A Learning Approach to SQL Query Results Ranking Using Skyline and Users' Current Navigational BehaviorIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2012.12825:12(2683-2693)Online publication date: 1-Dec-2013
  • (2013)Automatic extraction of top-k lists from the webProceedings of the 2013 IEEE International Conference on Data Engineering (ICDE 2013)10.1109/ICDE.2013.6544897(1057-1068)Online publication date: 8-Apr-2013
  • (2013)Finding Similar Objects in Relational Databases -- An Association-Based Fuzzy ApproachProceedings of the 10th International Conference on Flexible Query Answering Systems - Volume 813210.1007/978-3-642-40769-7_37(425-436)Online publication date: 18-Sep-2013
  • (2012)BOSS: context-enhanced search for biomedical objectsBMC Medical Informatics and Decision Making10.1186/1472-6947-12-S1-S712:S1Online publication date: 30-Apr-2012
  • (2012)Towards expressive exploratory search over entity-relationship dataProceedings of the 21st International Conference on World Wide Web10.1145/2187980.2187990(83-92)Online publication date: 16-Apr-2012
  • Show More Cited By

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media