13-17 February 2006
Tata Institute of Fundamental Research
Europe/Zurich timezone
- chep06@tifr.res.in
Support
ROOT I/O for SQL databases
Presented by Dr. Sergey LINEV
on
13 Feb 2006
from
17:40
to
18:00
Type: oral presentation
Session:
Software Components and Libraries
Track: Software Components and Libraries
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.
Event calendar file