Advertisement

MDBF: A Tool for Monitoring Database Files

  • Xiangyu Wei
  • Jianqiu Xu
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 11158)

Abstract

When complex queries are executed in a database system, several files will be accessed such as relational tables, indexes and profiles. Monitoring database files enables us to better understand the query progress and the storage system. In this demo, we present a tool for monitoring file operations such as when the file is accessed and how many bytes are transferred for read and write. The access information is visually displayed at running time, and also stored as historical data for further analysis and optimization. We provide a graphical interface to report and display the results. MDBF is implemented inside a system kernel with a low overhead. The demonstration is performed by using real trajectory datasets and continuous queries employing three different indexes.

Keywords

Monitor Database files Queries Analysis Visual 

Notes

Acknowledgement

The work is supported by National Key Research and Development Plan of China (2018YFB1003902) and “the Fundamental Research Funds for the Central Universities in China”, NO. NS2017073.

References

  1. 1.
  2. 2.
    Beeri, C., Eyal, A., Milo, T., Pilberg, A.: Query-based monitoring of BPEL business processes. In: ACM SIGMOD, pp. 1122–1124 (2007)Google Scholar
  3. 3.
    Chakka, V.P., Everspaugh, A., Patel, J.M.: Indexing large trajectory data sets with SETI. In: CIDR (2003)Google Scholar
  4. 4.
    Güting, R.H., Behr, T., Düntgen, C.: SECONDO: a platform for moving objects database research and for publishing and integrating research implementations. IEEE Data Eng. Bull. 33(2), 56–63 (2010)Google Scholar
  5. 5.
    Mishra, C., Koudas, N.: The design of a query monitoring system. ACM Trans. Database Syst. 34(1), 1:1–1:51 (2009)CrossRefGoogle Scholar
  6. 6.
    Pfoser, D., Jensen, C.S., Theodoridis, Y.: Novel approaches to the indexing of moving object trajectories. In: VLDB, pp. 395–406 (2000)Google Scholar

Copyright information

© Springer Nature Switzerland AG 2018

Authors and Affiliations

  1. 1.Nanjing University of Aeronautics and AstronauticsNanjingChina

Personalised recommendations