Meeting on 18 Feb 2008

Present: Philippe, Marianne, Zoltan, Elisa


  • Removal of bad jobs from the BK database: Marianne is taking care of this, tomorrow (19th) the files should not be visible in the views.
  • Marianne will provide documentation and tools to remove data from the database (there is a specific procedure to do that, and it has to be followed carefully!).
  • Update of the views: the views should be updated more frequently (ex. with a period of 6 hours). The will be modified accordingly.

Maintenance of the existing system

  • Zoltan addressed the problem relative to the UI web page crashing for some event types.The int type was not enough to store the file size. He changed it from int to long and solved the issue.
  • Problem of duplicated events in the views: in order to investigate on this problem, we need to have the development instance of the BK fully operative. See the Development instance item below.

New DB schema

  • Elisa showed the last version of the proposal for the new DB schema. The jobs and jobParams tables have been merged in just one table (jobs). The same for the files and fileParams table. The type of the attributes has been set to the actual type (int or float, not always varchar as before). The size attribute will be declared as long (int is not enough).

Next to do: a proposal for the views (for simulated and real data respectively). It has been proposed to include the production attribute in the views also for simulated data. For the next meeting Elisa will show a proposal.

  • About the use of AMGA: investigate if it is possible to perform all the operations necessary for the creation of the views via AMGA. Try to clarify the reason why AMGA is used only for some operations on the database, but not for others.

Development instance

Miguel Anjo has been asked to replicate the whole database schema (all the objects, including tables, procedures, triggers) in the development database. He should also copy the data, because otherwise it is impossible to make operations such recreating the views.

Waiting for a feedback from Miguel.

-- ElisaLanciotti - 19 Feb 2008

Edit | Attach | Watch | Print version | History: r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r1 - 2008-02-19 - ElisaLanciotti
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LHCb 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