Granulation of Large Temporal Databases: An Allan Variance Approach

Lorina Sinanaj, Hossein Haeri, Satya Prasad Maddipatla, Liming Gao, Rinith Pakala, Niket Kathiriya, Craig Beal, Sean Brennan, Cindy Chen, Kshitij Jerath

Research output: Contribution to journalArticlepeer-review

1 Scopus citations


As the use of Big Data begins to dominate various scientific and engineering applications, the ability to conduct complex data analyses with speed and efficiency has become increasingly important. The availability of large amounts of data results in ever-growing storage requirements and magnifies issues related to query response times. In this work, we propose a novel methodology for granulation and data reduction of large temporal databases that can address both issues simultaneously. While prior data reduction techniques rely on heuristics or may be computationally intensive, our work borrows the concept of Allan Variance (AVAR) from the fields of signal processing and sensor characterization to efficiently and systematically reduce the size of temporal databases. Specifically, we use Allan variance to systematically determine the temporal window length over which data remains relevant. Large temporal databases are then granulated using the AVAR-determined window length. Averaging over the resulting granules produces aggregate information for each granule, resulting in significant data reduction. The query performance and data quality are evaluated using existing standard datasets, as well as for two large datasets that include temporal information for vehicular and weather data. Our results demonstrate that the AVAR-based data reduction approach is efficient and maintains data quality, while leading to an order of magnitude improvement in query execution times compared to three existing clustering-based data reduction methods.

Original languageEnglish (US)
Article number7
JournalSN Computer Science
Issue number1
StatePublished - Jan 2023

All Science Journal Classification (ASJC) codes

  • Artificial Intelligence
  • General Computer Science
  • Computer Networks and Communications
  • Computer Science Applications
  • Computational Theory and Mathematics
  • Computer Graphics and Computer-Aided Design


Dive into the research topics of 'Granulation of Large Temporal Databases: An Allan Variance Approach'. Together they form a unique fingerprint.

Cite this