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)