13–17 Feb 2006
Tata Institute of Fundamental Research
Europe/Zurich timezone

ROOT I/O for SQL databases

13 Feb 2006, 17:40
20m
AG 69 (Tata Institute of Fundamental Research)

AG 69

Tata Institute of Fundamental Research

Homi Bhabha Road Mumbai 400005 India
oral presentation Software Components and Libraries Software Components and Libraries

Speaker

Dr Sergey Linev (GSI DARMSTADT)

Description

ROOT already has powerful and flexible I/O, which potentially can be used for storage of objects data in SQL databases. Usage of ROOT I/O together with SQL database will provide advanced functionality like: guarantee of data integrity, logging of data changes, possibility to rollback changes and lot of other features, provided by modern databases. At the same time data representation in SQL tables is main issue. To be able navigate and access data from non-ROOT environment objects data should be presented rather in native data types (integer, float, text) and not as set of BLOBs (binary block of data). A new TSQLFile class will be presented. It implements standard ROOT TFile interface for storage of object in human readable format in SQL database. Different possibilities for table design will be discussed.

Author

Dr Sergey Linev (GSI DARMSTADT)

Presentation materials