TWiki> LHCb Web>LHCbComputing>BKDev>CheckList (revision 3)EditAttachPDF

What to check before putting the system in production:

(after the meeting with Zoltan, Miguel and Elisa, on Fri Oct 17 2008)

  • 1 Pass_index ( I have to copy some simulation condition). Zoltan. Done

  • 2 Fill the processing_pass table (new productions). Joel is filling this table. It is not problem if it is not done before the migration, because he can fill it in the production system. ( the only problem is that the users can't see the new productions). Ongoing

  • 3 Check the new schema (keys, indexes, ...). In the processing_pass tables we should put indexes on the foreign keys (passid). Zoltan. Done

  • 4 Materialized view creation ( automatic or agent?). Zoltan thinks we do not need a view. After the migration, he will test how it works without using a view. The agent is done.

  • 5 Remove the not used attributes (for ex, In jobs table DaqPeriodId,Generator). I can't remove because the active production BKK registration will fail. Ongoing

  • 6 We have to reimplement a materialized view. Zoltan. Done

  • 7 We have to change the BKK API, because I removed the DaqPeriod. Zoltan. Done

  • 8 Set the Simcondid as primary key in the simulationConditions table (Elisa). Done

  • 9 Find out which is the increase rate of jobs and file. Can we foresee how many new files and jobs will be inserted into the database per year? (Philippe)

  • 10 Remove the trigger which automatically deletes the files when a job is deleted (this can be substituted by a foreign key with the property of delete in cascade. Ongoing We decide I will remove this trigger in the production system

  • 11 Establish if the data, once inserted into the bk database, are read-only or can be removed. This is very important for Miguel, because it determines the type of backup he has to set for the DB. If they are read-only, he can make a much simpler and less expansive backup.

  • 12 Provide the list of objects which have to be migrated to the production system:

Tables

JOBS
FILES
INPUTFILES
CONFIGURATIONS
FILETYPES
EVENTTYPES
DATA_TAKING_CONDITIONS
SIMULATIONCONDITIONS
PROCESSING_PASS
PASS_INDEX
PASS_GROUP

Packages

BKK_ORACLE
BKK_MONITORING

Sequences

pass_index_seq
groupid_seq
PRODUCTION_SEQ
jobId_seq
fileId_seq
configurationId_seq
simulationCondID_seq

Triggers

jobs_before_delete

-- ElisaLanciotti - 17 Oct 2008

Edit | Attach | Watch | Print version | History: r7 | r5 < r4 < r3 < r2 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r3 - 2008-11-03 - ZoltanMathe
 
    • 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-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback