Privacy and Security Notice
G0 Database Introduction
G0 Database Introduction
Purpose
- Store summary information averaged by run.
- Allow easy access to summary information using
well-defined interface language: structured query language or
SQL.
- Common storage format for data across multiple
installations.
Database Access
Tools:
- Command line clients: mysql and mysqldump
- GUI client:
mysqlcc
- Scripting interface: Perl
via DBI
- Programming interface: ROOT/C++
via G0SQL class
- Preferred interface.
- G0SQL class provides translator routines for generating
SQL from ROOT TTree style queries.
- G0SQL class provides routines for reencapsulating
returned data in ROOT friendly form (TArrayF and
TArrayD via G0SQLResult).
- G0SQL classes still in development. Test and submit
feature requests and bugs.
Database Server:
- Server software is MySQL ver. 3.23.49
- Hostname is hallcl7.jlab.org
- Database name is gzero-eng
- User name is g0
- Password available upon request
- Server account is very permissive. Do not use DELETE,
UPDATE, or INSERT in your queries!
Page maintained by Damon Spayde
(spayde@jlab.org).
Last updated on 8 May 2003.