(eg which PMT is plugged into what channel of a TDC) Monitoring

townripeΔιαχείριση Δεδομένων

31 Ιαν 2013 (πριν από 4 χρόνια και 4 μήνες)

182 εμφανίσεις

1

Paul Kyberd
-

CM17
-

February 2007

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.

2

Paul Kyberd
-

CM17
-

February 2007

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?


Anyone who is using a database during the construction should
contact myself or Malcolm Ellis to make sure your requirements are
fulfilled?


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


Against malicious attack


System failures


backups, journaling.


Are transactions supported?


Capacity planning tools


Backup tools

3

Paul Kyberd
-

CM17
-

February 2007

Options


Oracle


Complete solution



IBM


DB2



Access


Windows specific so no good
for Linux



mySQL


Free


Easy to install and
configure

Expensive

Not the easiest to run



Expensive



Detectors already using it
for the construction
database



(Transaction support new)

Security needs careful
thought

4

Paul Kyberd
-

CM17
-

February 2007

Options

postgreSQL


Free



root


Free



SQLserver


Cheapest tps


Windows specific



Other

Not much knowledge of it in
the collaboration



Ditto



Not cheap




Anybody using a solution
not mentioned above

5

Paul Kyberd
-

CM17
-

February 2007

Comparisons

Transac
tions

Backup

Locking

Concurrent

Tuning

Size

Network

Cost

Oracle

Row Level


SQL*Net


$14,000
-
$40000

/ processor

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

6

Paul Kyberd
-

CM17
-

February 2007

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

7

Paul Kyberd
-

CM17
-

February 2007

Comparisons