Physical database design for efficient time-series similarity search

Sang Wook Kim, Jinho Kim, Sanghyun Park

Research output: Contribution to journalArticle

Abstract

Similarity search in time-series databases finds such data sequences whose changing patterns are similar to that of a query sequence. For efficient processing, it normally employs a multi-dimensional index. In order to alleviate the well-known dimensionality curse, the previous methods for similarity search apply the Discrete Fourier Transform (DFT) to data sequences, and take only the first two or three DFT coefficients as organizing attributes. Other than this ad-hoc approach, there have been no research efforts on devising a systematic guideline for choosing the best organizing attributes. This paper first points out the problems occurring in the previous methods, and proposes a novel solution to construct optimal multi-dimensional indexes. The proposed method analyzes the characteristics of a target time-series database, and identifies the organizing attributes having the best discrimination power. It also determines the optimal number of organizing attributes for efficient similarity search by using a cost model. Through a series of experiments, we show that the proposed method outperforms the previous ones significantly.

Original languageEnglish
Pages (from-to)1251-1254
Number of pages4
JournalIEICE Transactions on Communications
VolumeE91-B
Issue number4
DOIs
Publication statusPublished - 2008 Jan 1

All Science Journal Classification (ASJC) codes

  • Software
  • Computer Networks and Communications
  • Electrical and Electronic Engineering

Fingerprint Dive into the research topics of 'Physical database design for efficient time-series similarity search'. Together they form a unique fingerprint.

  • Cite this