loading
Documents

Research.Publish.Connect.

Paper

Paper Unlock

Authors: David Kernert 1 ; Norman May 1 ; Michael Hladik 1 ; Klaus Werner 2 and Wolfgang Lehner 3

Affiliations: 1 SAP SE, Germany ; 2 Université de Nantes, France ; 3 Technische Universitaet Dresden, Germany

ISBN: 978-989-758-103-8

Keyword(s): In-memory Databases, Scientific Applications.

Related Ontology Subjects/Areas/Topics: Architectural Concepts ; Big Data ; Business Analytics ; Business and Social Applications ; Data Engineering ; Data Management and Quality ; Databases and Data Security ; e-Business ; Enterprise Information Systems ; Query Processing and Optimization ; Statistics Exploratory Data Analysis ; Workflow Management and Databases

Abstract: In order to confirm their theoretical assumptions, physicists employ Monte-Carlo generators to produce millions of simulated particle collision events and compare them with the results of the detector experiments. The traditional, static analysis workflow of physicists involves creating and compiling a C++ program for each study, and loading large data files for every run of their program. To make this process more interactive and agile, we created an application that loads the data into the relational in-memory column store DBMS SAP HANA, exposes raw particle data as database views and offers an interactive web interface to explore this data. We expressed common particle physics analysis algorithms using SQL queries to benefit from the inherent scalability and parallelization of the DBMS. In this paper we compare the two approaches, i.e. manual analysis with C++ programs and interactive analysis with SAP HANA. We demonstrate the tuning of the physical database schema and the SQL quer ies used for the application. Moreover, we show the web-based interface that allows for interactive analysis of the simulation data generated by the EPOS Monte-Carlo generator, which is developed in conjunction with the ALICE experiment at the Large Hadron Collider (LHC), CERN. (More)

PDF ImageFull Text

Download
Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 54.161.77.30

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Kernert D., May N., Hladik M., Werner K. and Lehner W. (2015). From Static to Agile - Interactive Particle Physics Analysis in the SAP HANA DB.In Proceedings of 4th International Conference on Data Management Technologies and Applications - Volume 1: DATA, ISBN 978-989-758-103-8, pages 16-25. DOI: 10.5220/0005503700160025

@conference{data15,
author={David Kernert and Norman May and Michael Hladik and Klaus Werner and Wolfgang Lehner},
title={From Static to Agile - Interactive Particle Physics Analysis in the SAP HANA DB},
booktitle={Proceedings of 4th International Conference on Data Management Technologies and Applications - Volume 1: DATA,},
year={2015},
pages={16-25},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005503700160025},
isbn={978-989-758-103-8},
}

TY - CONF

JO - Proceedings of 4th International Conference on Data Management Technologies and Applications - Volume 1: DATA,
TI - From Static to Agile - Interactive Particle Physics Analysis in the SAP HANA DB
SN - 978-989-758-103-8
AU - Kernert D.
AU - May N.
AU - Hladik M.
AU - Werner K.
AU - Lehner W.
PY - 2015
SP - 16
EP - 25
DO - 10.5220/0005503700160025

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.