![Page 1: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/1.jpg)
ACEACEA COOL EditorA COOL Editor
ATLAS Online Database meeting3rd December 2007, CERN
Chun Lik Tan - [email protected]
![Page 2: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/2.jpg)
ACEContents
Current situationBasic requirementsFeaturesScreenshotsSoftware dependenciesOther requirementsNext stepsTrying ACE
![Page 3: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/3.jpg)
ACECurrent situationThere are tools available that provide varying access to COOL.
KTIDBExplorer (Read-only access), not COOL-specific.
Various useful scripts are available to create and populate COOL folders.
Ad-hoc modification of folder entries is tedious and error prone.
![Page 4: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/4.jpg)
ACEBasic requirementsBrowse existing COOL folders
All LCG database technologies including SQLite
Add new rows by modifying existing ones
No editing of historical data!
Commit new additions to COOL
![Page 5: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/5.jpg)
ACEFeaturesPure COOL API.Connection builder with history for quick connections.Dedicated tab for separate COOL connections with tabulated folder contents including Channel Id, Since and Until fields.Bulk field population for convenience.Display mask (e.g. hex conversion) for individual columns.Cloning of existing rows and commiting to COOL when changes to new rows have been finalised.Dockable windows for folder content tables.
![Page 6: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/6.jpg)
ACEScreenshots (Main screen)
Folder view
Folder contents
![Page 7: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/7.jpg)
ACEScreenshots (Connection Builder.)
![Page 8: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/8.jpg)
ACEScreenshots (Entry cloning)
![Page 9: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/9.jpg)
ACEScreenshots (Entry modification)
Colour change (from alternating grey/white rows) denotes that folder has been modified.
![Page 10: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/10.jpg)
ACEScreenshots (Bulk entry modification)
![Page 11: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/11.jpg)
ACEScreenshots (Entry masks)
![Page 12: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/12.jpg)
ACECurrent statusNot all buttons/menu items have been activated.Only private build using modified L1Calo software package (qtExternal) at the moment.No support for adding of new folders.No tag support.No documentation as yet.Since/Until fields now display readable date/time format.Sorting of columns enabled.
![Page 13: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/13.jpg)
ACESoftware dependencies
COOL v2.1.1 and above
TDAQ-01-08-00 and above
Temporary dependancy on L1Calo’s qtExternal package
Qt v4.3 and above
![Page 14: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/14.jpg)
ACEOther requirements?
Folder construction fromscratch with a folder builder panelXML specification
Lazy loading of large folders.
Tag support.
![Page 15: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/15.jpg)
ACENext stepsImmediate term
Build public release against L1Calo software.Enable all essential buttons and menu items.
Medium termFilter mechanisms (e.g. since/until filters).Large folder support using lazy loading mechanisms.COOL tag support?
![Page 16: ACE A COOL Editor ATLAS Online Database meeting 3 rd December 2007, CERN Chun Lik Tan - clat@hep.ph.bham.ac.ukclat@hep.ph.bham.ac.uk](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649ee55503460f94bf577c/html5/thumbnails/16.jpg)
ACETrying ACE
On LXPLUS:/afs/cern.ch/atlas/project/tdaq/level1/calo/bin/ace.sh
At Point1:/det/l1calo/bin/ace.shNote:There is a (temporary) prerequisite for TDAQ software to be available prior to running ACE with the above scripts. On LXPLUS, this is can be done by sourcing the script below:source /afs/cern.ch/atlas/project/tdaq/cmt/tdaq-01-08-03/installed/setup.sh