Experimental Physics and
Industrial Control System

Noboru Yamamoto <[email protected]> · Thu, 12 Feb 2004 11:06:53 +0900

Vladimir Sirotenko wrote:
> We here at D0(Fermilab) are using set of tools (written in Python) to store
> PV variables directly in Oracle database. We use CA from EPICS to access
> IOC's and DCOracle2 to access database. We use it as slow archiver with
> archive rates from 5 secs and up. If you are interested, I can give you more
> details.
> 
> Vladimir
>
We , KEKB, use the similar approach to store the data from EPICS
database into
RDB(PosgtreSQL).
A tiny program written in Python monitors events in EPICS database and
stores
event data, i.e. a value, a time stamp, and other related data, into RDB,
We use a standard Python module to handle RDB from this program.
Rich set of modules is one of benefit using Python.

Regards

Noboru Yamamoto
EPICS group/KEKB control group
KEK, JAPAN

> ----- Original Message ----- 
> From: "黄松" <[email protected]>
> To: <[email protected]>
> Sent: Wednesday, February 11, 2004 3:55 AM
> Subject: Oracle archiver
> 
> 
> Hi, everyone,
> 
>    Now I manage to store datum retrieved from hardware on ioc (e.g. pv
> values) into ORACLE database system. I think there are two solutions, one is
> directly use the interface provided by EPICS to access pv channel, the other
> is use ORACLE facilities to load the archived files archived by Channel
> Archiver. I wonder if there are some sites who have realize this or are
> contributing on this. Can you give me some instructions on this?
> 
> Best wishes and regards,
> Huang song, IHEP
> 
> 　　　　　　　　[email protected]
> 　　　　　　　　　　2004-02-11
> 
> 
> 
> 
>

Experimental Physics and Industrial Control System

Experimental Physics and
Industrial Control System