skip to main content
10.1145/2484028.2484078acmconferencesArticle/Chapter ViewAbstractPublication PagesirConference Proceedingsconference-collections
research-article

Efficient query construction for large scale data

Published: 28 July 2013 Publication History

Abstract

In recent years, a number of open databases have emerged on the Web, providing Web users with platforms to collaboratively create structured information. As these databases are intended to accommodate heterogeneous information and knowledge, they usually comprise a very large schema and billions of instances. Browsing and searching data on such a scale is not an easy task for a Web user. In this context, interactive query construction offers an intuitive interface for novice users to retrieve information from databases neither requiring any knowledge of structured query languages, nor any prior knowledge of the database schema. However, the existing mechanisms do not scale well on large scale datasets. This paper presents a set of techniques to boost the scalability of interactive query construction, from the perspective of both, user interaction cost and performance. We connect an abstract ontology layer to the database schema to shorten the process of user-computer interaction. We also introduce a search mechanism to enable efficient exploration of query interpretation spaces over large scale data. Extensive experiments show that our approach scales well on Freebase - an open database containing more than 7,000 relational tables in more than 100 domains.

References

[1]
P. Adolphs, M. Theobald, U. Schäfer, H. Uszkoreit, and G. Weikum. Yago-qa: Answering questions by structured knowledge queries. In ICSC, 2011.
[2]
S. Agrawal. Dbxplorer: A system for keyword-based search over relational databases. In ICDE, 2002.
[3]
L. Androutsopoulos. Natural language interfaces to databases - an introduction. Journal of Natural Language Engineering, 1:29--81, 1995.
[4]
S. Basu Roy, H. Wang, G. Das, U. Nambiar, and M. Mohania. Minimum-effort driven dynamic faceted search in structured databases. In Proceeding of the CIKM '08.
[5]
A. Blum. Microsoft english query 7.5: Automatic extraction of semantics from relational databases and olap cubes. In VLDB '99.
[6]
E. Demidova, I. Oelze, and W. Nejdl. Yago meets freebase: Combining a large-scale database with an ontology. Technical report, L3S Research Center, Leibniz Universität Hannover, available at: http://iqp.l3s.uni-hannover.de/yagof-TR.pdf, May 2013.
[7]
E. Demidova, X. Zhou, and W. Nejdl. A probabilistic scheme for keyword-based incremental query construction. IEEE Trans. Knowl. Data Eng., 24(3):426--439, 2012.
[8]
E. Demidova, X. Zhou, G. Zenz, and W. Nejdl. Suits: Faceted user interface for constructing structured queries from keywords. In DASFAA 2009, Berlin, Heidelberg, 2009. Springer-Verlag.
[9]
e. Fellbaum. WordNet: An Electronic Lexical Database . MIT Press, Cambridge, 1998.
[10]
Google. Freebase data dumps. http://download.freebase.com/datadumps/, 2011.
[11]
V. Hristidis, L. Gravano, and Y. Papakonstantinou. Efficient ir-style keyword search over relational databases. In VLDB '2003, pages 850--861. VLDB Endowment, 2003.
[12]
V. Hristidis and Y. Papakonstantinou. Discover: keyword search in relational databases. In VLDB, 2002.
[13]
H. V. Jagadish, A. Chapman, A. Elkiss, M. Jayapandian, Y. Li, A. Nandi, and C. Yu. Making database systems usable. In SIGMOD, 2007.
[14]
M. Jayapandian and H. V. Jagadish. Expressive query specification through form customization. In EDBT, 2008.
[15]
A. Kotov and C. Zhai. Towards natural question guided search. In WWW '10.
[16]
F. Liu, C. Yu, W. Meng, and A. Chowdhury. Effective keyword search in relational databases. In SIGMOD, 2006.
[17]
Y. Luo, X. Lin, W. Wang, and X. Zhou. Spark: top-k keyword query in relational databases. In SIGMOD '07.
[18]
C. D. Manning, P. Raghavan, and H. Schütze. Introduction to Information Retrieval. Cambridge University Press, New York, NY, USA, 2008.
[19]
A. Nandi and H. V. Jagadish. Assisted querying using instant-response interfaces. In SIGMOD, 2007.
[20]
J. Nielsen. Usability engineering. Morgan Kaufmann Publishers, San Francisco, Calif., 1993.
[21]
F. M. Suchanek, G. Kasneci, and G. Weikum. Yago: A Core of Semantic Knowledge. In WWW 2007. ACM Press, 2007.
[22]
E. Tata and G. M. Lohman. Sqak: doing more with keywords. In SIGMOD, 2008.
[23]
T. Tran, P. Cimiano, S. Rudolph, and R. Studer. Ontology-based interpretation of keywords for semantic search. In ISWC, 2007.
[24]
P. Wu, Y. Sismanis, and B. Reinwald. Towards keyword-driven analytical processing. In SIGMOD '07.
[25]
M. M. Zloof. Query by example. In AFIPS '75: May 19--22, 1975, national computer conference and exposition. ACM, 1975.

Cited By

View all
  • (2019)EventKG – the hub of event knowledge on the web – and biographical timeline generationSemantic Web10.3233/SW-19035510:6(1039-1070)Online publication date: 1-Jan-2019
  • (2018)EventKG: A Multilingual Event-Centric Temporal Knowledge GraphThe Semantic Web10.1007/978-3-319-93417-4_18(272-287)Online publication date: 3-Jun-2018
  • (2018)KEYSTONE WG2: Activities and Results Overview on Keyword SearchSemantic Keyword-Based Search on Structured Data Sources10.1007/978-3-319-74497-1_21(215-223)Online publication date: 8-Feb-2018
  • Show More Cited By

Index Terms

  1. Efficient query construction for large scale data

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    SIGIR '13: Proceedings of the 36th international ACM SIGIR conference on Research and development in information retrieval
    July 2013
    1188 pages
    ISBN:9781450320344
    DOI:10.1145/2484028
    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 the author(s) 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: 28 July 2013

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. freebase
    2. ontology
    3. query construction

    Qualifiers

    • Research-article

    Conference

    SIGIR '13
    Sponsor:

    Acceptance Rates

    SIGIR '13 Paper Acceptance Rate 73 of 366 submissions, 20%;
    Overall Acceptance Rate 792 of 3,983 submissions, 20%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)7
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 16 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2019)EventKG – the hub of event knowledge on the web – and biographical timeline generationSemantic Web10.3233/SW-19035510:6(1039-1070)Online publication date: 1-Jan-2019
    • (2018)EventKG: A Multilingual Event-Centric Temporal Knowledge GraphThe Semantic Web10.1007/978-3-319-93417-4_18(272-287)Online publication date: 3-Jun-2018
    • (2018)KEYSTONE WG2: Activities and Results Overview on Keyword SearchSemantic Keyword-Based Search on Structured Data Sources10.1007/978-3-319-74497-1_21(215-223)Online publication date: 8-Feb-2018
    • (2018)Towards Better Understanding Researcher Strategies in Cross-Lingual Event AnalyticsDigital Libraries for Open Knowledge10.1007/978-3-030-00066-0_12(139-151)Online publication date: 5-Sep-2018
    • (2016)A Knowledge Base Approach to Cross-Lingual Keyword Query InterpretationThe Semantic Web – ISWC 201610.1007/978-3-319-46523-4_37(615-631)Online publication date: 23-Sep-2016
    • (2015)Query construction based on concept importance for effective patent retrieval2015 12th International Conference on Fuzzy Systems and Knowledge Discovery (FSKD)10.1109/FSKD.2015.7382158(1455-1459)Online publication date: Aug-2015
    • (2014)New approach for extracting information on Freebase based on user's preferencesProceedings of the 16th International Conference on Information Integration and Web-based Applications & Services10.1145/2684200.2684344(54-58)Online publication date: 4-Dec-2014
    • (2014)Templated Search over Relational DatabasesProceedings of the 23rd ACM International Conference on Conference on Information and Knowledge Management10.1145/2661829.2661883(21-30)Online publication date: 3-Nov-2014
    • (2013)Aligning freebase with the YAGO ontologyProceedings of the 22nd ACM international conference on Information & Knowledge Management10.1145/2505515.2505546(579-588)Online publication date: 27-Oct-2013

    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