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!