skip to main content
10.1145/956699.956727acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
Article

Answering imprecise database queries: a novel approach

Published:07 November 2003Publication History

ABSTRACT

A growing number of databases especially those published on the Web are becoming available to external users. Users of these databases are provided simple form-based query interfaces that hide the underlying schematic details. Constrained by the expressiveness of the query interface users often have difficulty in articulating a precise query over the database. Supporting imprecise queries over such systems would allow users to quickly find relevant answers without iteratively refining their queries. For databases to support imprecise queries they must provide answers that closely match the query constraints. In this paper we focus on answering imprecise user queries without changing the existing database system. We propose to support imprecise queries over a database by identifying a set of related precise queries that provide answers that are relevant to the user given query. We present a domain independent approach based on information retrieval techniques to estimate the distance between queries. To demonstrate the utility and usefulness of our approach we perform usability tests and provide results.

References

  1. W. Cohen. Integration of heterogeneous databases without common domains using queries based on textual similarity. Proc. of SIGMOD, pages 201--212, June 1998. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. R. Goldman, N .Shivakumar, S. Venkatasubramanian, and H. Garcia-Molina. Proximity search in databases. VLDB, 1998. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. T. Haveliwala, A. Gionis, D. Klein, and P Indyk. Evaluating strategies for similarity search on the web. Proceedings of WWW, Hawai, USA, May 2002. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. J. M. Morrissey. Imprecise information and uncertainty in information systems. ACM Transactions on Information Systems, 8:159--180, April 1990. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. A. Motro. Vague: A user interface to relational databases that permits vague queries. ACM Transactions on Office Information Systems, 6(3):187--214, 1998. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. Z. Nie, S. Kambhampati, and T. Hernandez. BibFinder/StatMiner: Effectively Mining and Using Coverage and Overlap Statistics in Data Integration. VLDB, 2003. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. Micheal Ortega-Binderberger. Integrating Similarity Based Retrieval and Query Refinement in Databases. PhD thesis, UIUC, 2002. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. NKICDE:04 Z. Nie and S. Kambhampati. A Frequency Based Approach for Mining Coverage Statistics in Data Integration. to appear in ICDE 2004. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. R. Baeza-Yates and B. Ribiero-Neto. Modern Information Retrieval. Addison Wesley Longman Publishing, May 1999. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Answering imprecise database queries: a novel approach

          Recommendations

          Comments

          Login options

          Check if you have access through your login credentials or your institution to get full access on this article.

          Sign in
          • Published in

            cover image ACM Conferences
            WIDM '03: Proceedings of the 5th ACM international workshop on Web information and data management
            November 2003
            164 pages
            ISBN:1581137257
            DOI:10.1145/956699

            Copyright © 2003 ACM

            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]

            Publisher

            Association for Computing Machinery

            New York, NY, United States

            Publication History

            • Published: 7 November 2003

            Permissions

            Request permissions about this article.

            Request Permissions

            Check for updates

            Qualifiers

            • Article

            Upcoming Conference

          PDF Format

          View or Download as a PDF file.

          PDF

          eReader

          View online with eReader.

          eReader