Skip to main content
Journal cover image

Top-k typicality queries and efficient query answering methods on large databases

Publication ,  Journal Article
Hua, M; Pei, J; Fu, AWC; Lin, X; Leung, HF
Published in: VLDB Journal
June 1, 2009

Finding typical instances is an effective approach to understand and analyze large data sets. In this paper, we apply the idea of typicality analysis from psychology and cognitive science to database query answering, and study the novel problem of answering top-k typicality queries. We model typicality in large data sets systematically. Three types of top-k typicality queries are formulated. To answer questions like "Who are the top-k most typical NBA players?", the measure of simple typicality is developed. To answer questions like "Who are the top-k most typical guards distinguishing guards from other players?", the notion of discriminative typicality is proposed. Moreover, to answer questions like "Who are the best k typical guards in whole representing different types of guards?", the notion of representative typicality is used. Computing the exact answer to a top-k typicality query requires quadratic time which is often too costly for online query answering on large databases. We develop a series of approximation methods for various situations: (1) the randomized tournament algorithm has linear complexity though it does not provide a theoretical guarantee on the quality of the answers; (2) the direct local typicality approximation using VP-trees provides an approximation quality guarantee; (3) a local typicality tree data structure can be exploited to index a large set of objects. Then, typicality queries can be answered efficiently with quality guarantees by a tournament method based on a Local Typicality Tree. An extensive performance study using two real data sets and a series of synthetic data sets clearly shows that top-k typicality queries are meaningful and our methods are practical. © 2009 Springer-Verlag.

Duke Scholars

Published In

VLDB Journal

DOI

EISSN

0949-877X

ISSN

1066-8888

Publication Date

June 1, 2009

Volume

18

Issue

3

Start / End Page

809 / 835

Related Subject Headings

  • Information Systems
  • 4605 Data management and data science
  • 0806 Information Systems
  • 0805 Distributed Computing
  • 0804 Data Format
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Hua, M., Pei, J., Fu, A. W. C., Lin, X., & Leung, H. F. (2009). Top-k typicality queries and efficient query answering methods on large databases. VLDB Journal, 18(3), 809–835. https://doi.org/10.1007/s00778-008-0128-8
Hua, M., J. Pei, A. W. C. Fu, X. Lin, and H. F. Leung. “Top-k typicality queries and efficient query answering methods on large databases.” VLDB Journal 18, no. 3 (June 1, 2009): 809–35. https://doi.org/10.1007/s00778-008-0128-8.
Hua M, Pei J, Fu AWC, Lin X, Leung HF. Top-k typicality queries and efficient query answering methods on large databases. VLDB Journal. 2009 Jun 1;18(3):809–35.
Hua, M., et al. “Top-k typicality queries and efficient query answering methods on large databases.” VLDB Journal, vol. 18, no. 3, June 2009, pp. 809–35. Scopus, doi:10.1007/s00778-008-0128-8.
Hua M, Pei J, Fu AWC, Lin X, Leung HF. Top-k typicality queries and efficient query answering methods on large databases. VLDB Journal. 2009 Jun 1;18(3):809–835.
Journal cover image

Published In

VLDB Journal

DOI

EISSN

0949-877X

ISSN

1066-8888

Publication Date

June 1, 2009

Volume

18

Issue

3

Start / End Page

809 / 835

Related Subject Headings

  • Information Systems
  • 4605 Data management and data science
  • 0806 Information Systems
  • 0805 Distributed Computing
  • 0804 Data Format