X-Ray: Monitoring and Analysis of Distributed Database Queries

Conference paper

DOI: 10.1007/978-3-319-19129-4_7

Part of the Lecture Notes in Computer Science book series (LNCS, volume 9038)
Cite this paper as:
Guimarães P., Pereira J. (2015) X-Ray: Monitoring and Analysis of Distributed Database Queries. In: Bessani A., Bouchenak S. (eds) Distributed Applications and Interoperable Systems. DAIS 2015. Lecture Notes in Computer Science, vol 9038. Springer, Cham

Abstract

The integration of multiple database technologies, including both SQL and NoSQL, allows using the best tool for each aspect of a complex problem and is increasingly sought in practice. Unfortunately, this makes it difficult for database developers and administrators to obtain a clear view of the resulting composite data processing paths, as they combine operations chosen by different query optimisers, implemented by different software packages, and partitioned across distributed systems. This work addresses this challenge with the X-Ray framework, that allows monitoring code to be added to a Java-based distributed system by manipulating its bytecode at runtime. The resulting information is collected in a NoSQL database and then processed to visualise data processing paths as required for optimising integrated database systems. This proposal is demonstrated with a distributed query over a federation of Apache Derby database servers and its performance evaluated with the standard TPC-C benchmark workload.

Keywords

Distributed databases Monitoring Java instrumentation 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© IFIP International Federation for Information Processing 2015

Authors and Affiliations

  1. 1.INESC TEC and U. MinhoGuimaraesPortugal

Personalised recommendations