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
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.