Skip to main content

Streaming Approach to Schema Profiling

  • Conference paper
  • First Online:
New Trends in Database and Information Systems (ADBIS 2023)

Abstract

Schema profiling consists in producing key insights about the schema of data in a high-variety context. In this paper, we present a streaming approach to schema profiling, where heterogeneous data is continuously ingested from multiple sources, as is typical in many IoT applications (e.g., with multiple devices or applications dynamically logging messages). The produced profile is a clustering of the schemas extracted from the data and it is computed and evolved in real-time under the overlapping sliding window paradigm. The approach is based on two-phase k-means clustering, which entails pre-aggregating the data into a coreset and incrementally updating the previous clustering results without recomputing it in every iteration. Differently from previous proposals, the approach works in a domain where dimensionality is variable and unknown apriori, it automatically selects the optimal number of clusters, and detects cluster evolution by minimizing the need to recompute the profile. The experimental evaluation demonstrated the effectiveness and efficiency of the approach against the naïve baseline and the state-of-the-art algorithms on stream clustering.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Akidau, T., et al.: Streaming Systems: The What, Where, When, and How of Large-Scale Data Processing. O’Reilly Media, Inc., Sebastopol (2018)

    Google Scholar 

  2. de Andrade Silva, J., et al.: An evolutionary algorithm for clustering data streams with a variable number of clusters. Expert Syst. Appl. (2017)

    Google Scholar 

  3. Arthur, D., et al.: k-means++: the advantages of careful seeding. SIAM (2007)

    Google Scholar 

  4. Breve, B., et al.: Dependency visualization in data stream profiling. Big Data Res. (2021)

    Google Scholar 

  5. Du, M., et al.: Spell: streaming parsing of system event logs. IEEE Computer Society (2016)

    Google Scholar 

  6. Emmi, L.A., et al.: Digital representation of smart agricultural environments for robot navigation. In: CEUR Workshop Proceedings (2022)

    Google Scholar 

  7. Gallinucci, E., et al.: Schema profiling of document-oriented databases. Inf. Syst. (2018)

    Google Scholar 

  8. Grefenstette, G.: Explorations in automatic thesaurus discovery (1994)

    Google Scholar 

  9. Kullback, S., et al.: On information and sufficiency. Ann. Math. Stat. (1951)

    Google Scholar 

  10. Levandowsky, M., et al.: Distance between sets. Nature (1971)

    Google Scholar 

  11. Naldi, M.C., et al.: Comparison among methods for k estimation in k-means. IEEE Computer Society (2009)

    Google Scholar 

  12. Naumann, F.: Data profiling revisited. In: SIGMOD Rec. (2013)

    Google Scholar 

  13. Seyfi, M., et al.: H-DAC: discriminative associative classification in data streams. Soft. Comput. (2023)

    Google Scholar 

  14. Youn, J., et al.: Efficient data stream clustering with sliding windows based on locality-sensitive hashing. IEEE Access (2018)

    Google Scholar 

  15. Zhang, T., et al.: BIRCH: an efficient data clustering method for very large databases. ACM Press (1996)

    Google Scholar 

  16. Zubaroğlu, A., et al.: Data stream clustering: a review. Artif. Intell. Rev. (2021)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Enrico Gallinucci .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Forresi, C., Francia, M., Gallinucci, E., Golfarelli, M. (2023). Streaming Approach to Schema Profiling. In: Abelló, A., et al. New Trends in Database and Information Systems. ADBIS 2023. Communications in Computer and Information Science, vol 1850. Springer, Cham. https://doi.org/10.1007/978-3-031-42941-5_19

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-42941-5_19

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-42940-8

  • Online ISBN: 978-3-031-42941-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics