• X-Ray: Monitoring and Analysis...

Treffer: X-Ray: Monitoring and Analysis of Distributed Database Queries

Title:
X-Ray: Monitoring and Analysis of Distributed Database Queries
Authors:
Guimarães, Pedro, Pereira, José
Contributors:
Institute for Systems and Computer Engineering, Technology and Science Braga (INESC TEC), Alysson Bessani, Sara Bouchenak, TC 6, WG 6.1
Source:
Lecture Notes in Computer Science ; 15th IFIP International Conference on Distributed Applications and Interoperable Systems (DAIS) ; https://inria.hal.science/hal-01775031 ; 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⟩
Publisher Information:
CCSD
Springer International Publishing
Publication Year:
2015
Subject Terms:
Distributed databases, Monitoring, Java instrumentation, [INFO]Computer Science [cs], [INFO.INFO-NI]Computer Science [cs]/Networking and Internet Architecture [cs.NI]
Subject Geographic:
Grenoble, France
Document Type:
Konferenz conference object
Language:
English
DOI:
10.1007/978-3-319-19129-4_7
Availability:
https://inria.hal.science/hal-01775031
https://inria.hal.science/hal-01775031v1/document
https://inria.hal.science/hal-01775031v1/file/978-3-319-19129-4_7_Chapter.pdf
https://doi.org/10.1007/978-3-319-19129-4_7
Rights:
http://creativecommons.org/licenses/by/ ; info:eu-repo/semantics/OpenAccess
Accession Number:
edsbas.29EE4575
Database:
BASE

Weitere Informationen

International audience ; 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.