T-Sensor user tables

In cooperation with S. Kovar a data model has been defined. The corresponding tables are located in the online Condition DB managed by A. Formica. A real time replica is provided to make this tables available to the offline world. If you want to use this tables, please contact me for access information. NEW: The design of the T-Sensor tables has been updated. The new design incorporates easy to use alarm configuration.

Further details on the T-Sensor user tables can be found in this document.

This tables are maintained by myself. If you find any error or do have any corrections please feel free to contact me.

History table of the standardized flag system

Following the definition of the standardized flags, a history table for the standardized flag system was needed. The data model of this tables has been defined in cooperation with S. Kovar and P. Fleischmann. The history tables are located in the online Condition DB managed by A. Formica. A real time replica is provided to make this tables available to the offline world. If you want to use this tables, please contact me for access information.

Further details on the history tables can be found in this document.

Bad Sensor Report on the web

There is now a bad sensor report available on the web. The page displays the last report as default and list of all reports with links at the bottom of the page. So you can easily browse through all reports. It is beeing generated automatically from the table MDT_SENSOR_STAT. The table is accessible through the account ATLAS_MDT_DCS_W of the ATONR database. If you need the PWD, please contact S. Kovar or H. Fuchs.

Structure of the table is (DESC MDT_SENSOR_STAT):

ID NOT NULL NUMBER
REPORT   VARCHAR2(4000)
CREATED_ON   DATE
CREATED_BY   VARCHAR2(40)

There is an automatic trigger, which creates and fills a sequence number and a created_on column. Furthermore, there exists a procedure which inserts a report into the table:

MDT_SENSOR_INSERT.p_ins_Mdt_Sensor_Stat(report,user); 

For example:

Exec MDT_SENSOR_INSERT.p_ins_Mdt_Sensor_Stat
('This is the first report. Test Report.','Stepan');

The size of an report is limited up to 4k.

If you have any comments, wishes or complains, please, do not hesitate to come. I hope this small apps will be helpful for many of us. Klick here to see the bad sensor report web

Topic attachments
I Attachment History Action Size Date Who Comment
PDFpdf DataModel_FlagTables.pdf r1 manage 74.0 K 2007-12-13 - 09:18 HermannFuchs Contains the data model of the MDT_SENSOR_FLAG tables, according to the standardized flags
PDFpdf DataModel_T-Sensor_Oracle_User_Tables.pdf r6 r5 r4 r3 r2 manage 33.9 K 2008-01-21 - 14:41 HermannFuchs Contains information on the implementation and content of the T-Sensor oracle user tables
Edit | Attach | Watch | Print version | History: r14 < r13 < r12 < r11 < r10 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r14 - 2008-02-29 - HermannFuchs
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Atlas All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback