Transcript Cryo and AFE IIt Update

Database(s) for MICE
 It is clear that we will need some sort of data base to hold
information such as:





Geometry (survey/alignment results)
Calibration information (pedestals, gains, T0s, etc)
Cabling (e.g. which PMT is plugged into what channel of a
TDC)
Monitoring information (voltages, pressures, temperatures,
etc)
Location of datasets
 The exact list will be detector/system dependent (e.g. for
the tracker we already know that the QA/construction
process will produce a lot of information).
 At present we are NOT going to store the events as entries
in a database, but stick the longer established system of
pointing to files from a database.
Paul Kyberd - CM17 - February 2007
1
Requirements




How much data will we need to store?
What response will we need?
What is the price of the solutions?
What is already being used?




Concurrent access must be possible, but what limitations are
there on this. Numbers and locking strategy.
Network access – must be supported.
Security of the database





Anyone who is using a database during the construction should
contact myself or Malcolm Ellis to make sure your requirements are
fulfilled?
Against malicious attack
System failures – backups, journaling.
Are transactions supported?
Capacity planning tools
Backup tools
Paul Kyberd - CM17 - February 2007
2
Options
 Oracle

Complete solution
 IBM

Expensive
DB2
 Access

Expensive
Not the easiest to run
Windows specific so no good
for Linux
Detectors already using it
for the construction
database
 mySQL


Free
Easy to install and
configure
(Transaction support new)
Security needs careful
thought
Paul Kyberd - CM17 - February 2007
3
Options
Not much knowledge of it in
the collaboration
postgreSQL

Free
 root

Ditto
Free
 SQLserver


Cheapest tps
Windows specific
 Other
Not cheap
Anybody using a solution
not mentioned above
Paul Kyberd - CM17 - February 2007
4
Comparisons
Transac
tions
Backup
Locking
Concurrent
Tuning
Size
Network
Cost
SQL*Net
$14,000-$40000
/ processor
Oracle
Row Level
DB2
Object Level
$8,000-$25000
/ processor
PostgreSQL
Row Level
Free
mySQL
Row Level
Free
SQLserver
Page Level
$4,000-$24000/
processor
root
Free
access
£80/seat
Paul Kyberd - CM17 - February 2007
5
Plans
 Collect requirements from the collaboration
 Explore the options both in terms:


Existing benchmarks
Running some of our own benchmarks
 Propose a solution
 Implement a test version
Paul Kyberd - CM17 - February 2007
6
Comparisons
Paul Kyberd - CM17 - February 2007
7