10–14 Oct 2016
San Francisco Marriott Marquis
America/Los_Angeles timezone

A study of data representations in Hadoop to optimize data storage and search performance of the ATLAS EventIndex

11 Oct 2016, 15:30
1h 15m
San Francisco Marriott Marquis

San Francisco Marriott Marquis

Poster Track 4: Data Handling Posters A / Break

Speaker

Luca Canali (CERN)

Description

This paper reports on the activities aimed at improving the architecture and performance of the ATLAS EventIndex implementation in Hadoop. The EventIndex contains tens of billions event records, each of which consisting of ~100 bytes, all having the same probability to be searched or counted. Data formats represent one important area for optimizing the performance and storage footprint of applications based on Hadoop. This work reports on the production usage and on tests using several data formats including Map Files, Apache Parquet, Avro, and various compression algorithms.
The query engine plays also a critical role in the architecture. This paper reports on the use of HBase for the EventIndex, focussing on the optimizations performed in production and on the scalability tests. Additional engines that have been tested include Cloudera Impala, in particular for its SQL interface, and the optimizations for data warehouse workloads and reports.

Primary Keyword (Mandatory) Storage systems
Secondary Keyword (Optional) Databases

Authors

Dario Barberis (Università e INFN Genova (IT)) Julius Hrivnac (Universite de Paris-Sud 11 (FR)) Luca Canali (CERN) Rainer Toebbicke (CERN) Zbigniew Baranowski (CERN)

Presentation materials