Tracker Phase 2 upgrade, IIHE(ULB/VUB) Logistics (DATABASE) Working Group


Scope:

  • collect requirements on program to handle the logistics of components for module assembly at the IIHE

  • investigate possible software solutions

  • use a barcode reader

  • deploy small-scale prototype and collect feedback

  • review, redesign, scale up


***** Meeting biweekly (Monday 11 A.M.) *****

Contacts:

Meeting Vidyo room link: https://vidyoportal.cern.ch/join/eOWcama6th

Mattermost Chat: https://mattermost.web.cern.ch/ph2-tracker-be/channels/database


Tasks

2S module Construction Database:

Assigned to Due date Description State Closed Notify  
DmytroHohov 2020-04-13 List the components to build a 2S module 2020-12-04 DmytroHohov edit
Main.All 2020-07-27 To finalize the software requirements 2020-12-04 DmytroHohov edit
DmytroHohov   Development of the prototype   edit
DmytroHohov   Installation and Test at IIHE virtual   edit

Photo Database:

Assigned to Due date Description State Closed Notify  
Main.Olivier, Main.Bugra 2020-09-09 Survey of the databases and selection 2020-10-18 DmytroHohov edit
Main.Olivier 2020-09-09 Install at IIHE hosting 2020-10-18 DmytroHohov edit
Main.Olivier, Main.Bugra 2020-09-09 Testing the functionalities 2020-10-18 DmytroHohov edit
Main.Annemie, Main.Bugra 2020-10-16 Uploading the existing photos 2020-12-04 DmytroHohov edit
DmytroHohov 2020-10-23 Allowed format extensions (Video, etc) 2020-10-23 DmytroHohov edit
DmytroHohov 2020-09-28 Testing API 2020-10-18 DmytroHohov edit
DmytroHohov 2020-11-05 Private mode and accessing 2020-12-04 DmytroHohov edit
Main.Olivier 2020-11-27 Backup option 2020-12-04 DmytroHohov edit
DmytroHohov, Main.Olivier 2020-12-03 Host for the screen recorder 2020-12-04 DmytroHohov edit

IIHE Photo Database

The Photo Database is hosted at https://photodb.iihe.ac.be to archive pictures/movies related to the CMS Tracker Phase II construction activities at IIHE(VUB/ULB) and to make them accessible to the relevant people. Pictures/movies are documented with corresponding captions and structured in subalbums. Every picture/movie can be searchable by tags, creation/uploaded date, etc.

HELP Information how to access and upload pictures to the photo database IIHEPhotoDB HELP

IIHE Local Database

HELP Information about local database IIHELocalDB HELP

Meetings minutes

Kickoff meeting 08/04/2020 Wednesday 12AM. slides: https://indico.cern.ch/event/903303/contributions/3801742/attachments/2017504/3372336/DATABASE_WG.pptx

-- Dmytro Hohov - 2020-04-08

Minutes 08/04/2020:

  • Have to define a new timeslot for the meeting
  • It was decided to have the following requirements for the software:

    • To know status of the stock
    • To monitor tracked, non-tracked and consumable components
    • Have warnings when components end up (how much time left before it is empty) in a few months
    • Interface to the CMS central database
    • Processing the plans if we want to build the number of modules
      • Are there enough components?
      • For how many modules we have remaining components?
    • What kind of budget to use to buy some components
    • Barcode reader
  • List the components to build a 2S module (Dima, for the next meeting)

  • Investigate the software and databases

-- Dmytro Hohov - 2020-04-08

Minutes 15/04/2020 (Wednesday 10 a.m.):

Steven's Table of components: https://docs.google.com/spreadsheets/d/15x1OAS1KCWn987MzxgxQZ7anQtuXzT0a88dScQkaLdg/edit#gid=0

Slides (in the Logistics for prototypes): https://indico.cern.ch/event/903304/


  • Compose the list of components
    • foresee different versions of the components:
      • default (= production)
      • proto (=prototype)
      • 1.8 mm or 4.0 mm, etc.
      • tracked in central DB or not tracked in central DB
        • do not duplicate the information that is in central DB

  • Write down requirements of software solution.
    • hierarchy of components
    • distinguish different versions of components
    • how many modules are possible to build
    • query SQL database
  • Keep on investigation of the software solutions in the Internet
    • Partkeepr
    • Square Inventory Management
    • etc
  • How we can trace consumables: need to think how to define these entries:
    • packed by how many? date of optimal use? how to enter the stock status?

-- Dmytro Hohov - 2020-04-17

Minutes 27/04/2020 (Monday 11 a.m.):

Minutes 04/05/2020 (Monday 11 a.m.):

List of consumables:

Google doc : https://docs.google.com/document/d/1Ep4ySplS5NVdjqSPuAgKpqnuYtr-wniPD_hmzK9kfbY/edit?usp=sharing

-- Dmytro Hohov - 2020-05-04

Minutes 11/05/2020 (Monday 11 a.m.):

Software specifications:

Google doc : https://docs.google.com/document/d/1dstvMaJSLlb837bzKWn0AUdGPNseeUL5mitOun0habM/edit?usp=sharing

-- Dmytro Hohov - 2020-05-11

Minutes 25/05/2020 (Monday 11 a.m.):

Detector construction app: https://twiki.cern.ch/twiki/bin/view/Sandbox/DcaForDetectors

DB: https://twiki.cern.ch/twiki/bin/viewauth/CMS/ConstructionDB

Db_Loader: https://twiki.cern.ch/twiki/bin/view/Sandbox/BatchUploadHelpers#Production_of_XML_for_uploading]]

Production of the XML file for the batch upload: https://twiki.cern.ch/twiki/bin/view/Sandbox/BatchUploadHelpers#Production_of_XML_for_uploading

DCA software: https://gitlab.cern.ch/cms-ph2-database/dca-gui

How to run: https://gitlab.cern.ch/cms-ph2-database/dca-gui/-/wikis/Run-Application-Locally

-- Dmytro Hohov - 2020-05-25

Minutes 15/06/2020 (Monday 11 a.m.):

Work on prototyping.

-- Dmytro Hohov - 2020-06-15

Minutes 31/08/2020 (Monday 11 a.m.):

Slides: https://twiki.cern.ch/twiki/pub/Main/IIHEDatabaseWG/Prototyping_of_local_DB.pptx

-- Dmytro Hohov - 2020-08-31

Minutes 14/09/2020 (Monday 11 a.m.):

  • PostgreSQL as a database (discussed with IT)
  • pyQT and/or Tkinter for GUI
  • Python

  • proto DB was created and possibility to make changes was tested (GUI)
  • Function of DB: Inventory part + Store local tests (pictures and files).
-- Dmytro Hohov - 2020-10-18

Minutes 28/09/2020 (Monday 11 a.m.):

  • Photo database piwigo
  • Check API.
  • Should be not public (authentication tool)
  • Upload pictures
  • Guide for users
-- Dmytro Hohov - 2020-10-18

-- DmytroHohov - 2020-04-03

Documents

Topic attachments
I Attachment History Action Size Date Who Comment
PDFpdf 2020-05-20_Tracker_DB_Status_report.pdf r1 manage 467.6 K 2020-05-25 - 11:14 DmytroHohov  
Unknown file formatxlsx IIHE_Phase2_OT_prototyping_components.xlsx r1 manage 11.4 K 2020-04-27 - 12:54 DmytroHohov Prototyping components
Unknown file formatpptx Prototyping_of_local_DB.pptx r1 manage 311.1 K 2020-08-31 - 17:12 DmytroHohov  
PDFpdf sensor-InvitationForTender-April2019.pdf r1 manage 962.9 K 2020-12-04 - 12:09 DmytroHohov electrical and mechanical specs
Texttxt wireless_scanner_Summary.txt r1 manage 1.2 K 2020-04-27 - 12:57 DmytroHohov survey for barcode scanners
Edit | Attach | Watch | Print version | History: r27 < r26 < r25 < r24 < r23 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r27 - 2021-04-28 - DmytroHohov
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Main All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2021 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