Skip to Main content Skip to Navigation
Conference papers

X-Ray: Monitoring and Analysis of Distributed Database Queries

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.
Complete list of metadatas

Cited literature [17 references]  Display  Hide  Download

https://hal.inria.fr/hal-01775031
Contributor : Hal Ifip <>
Submitted on : Tuesday, April 24, 2018 - 11:53:27 AM
Last modification on : Tuesday, April 24, 2018 - 12:42:52 PM
Long-term archiving on: : Wednesday, September 19, 2018 - 11:10:54 AM

File

978-3-319-19129-4_7_Chapter.pd...
Files produced by the author(s)

Licence


Distributed under a Creative Commons Attribution 4.0 International License

Identifiers

Citation

Pedro Guimarães, José Pereira. X-Ray: Monitoring and Analysis of Distributed Database Queries. 15th IFIP International Conference on Distributed Applications and Interoperable Systems (DAIS), Jun 2015, Grenoble, France. pp.80-93, ⟨10.1007/978-3-319-19129-4_7⟩. ⟨hal-01775031⟩

Share

Metrics

Record views

95

Files downloads

267