Difference: NewSchema (1 vs. 4)

Revision 42008-07-02 - ElisaLanciotti

Line: 1 to 1
 
META TOPICPARENT name="BKDev"

New BK database schema

Line: 11 to 11
  A preliminary draft of the documentation about this new schema is available in this page (see below the newschema.pdf document). This is not yet an official documentation!
Deleted:
<
<

A new criterion to make queries on files: the Processing Pass

This is the set of application version and condition DB tags which have been used to produce a file and its ancestors.

The processing pass is common for all the files of the same production and of the same file type (ex. SIM, DIGI, DST).

By consequence, a processing pass corresponds to a set of productions. A complementary table has been introduced in the new schema, with the information relative to each production, file type and corresponding processing pass.

Special cases:

The production 1959: here there is an additional step of digitization, but it is a fake step.. (decide how to compute the proc.pass)

Productions 2000, 2001: these productions are a special case because in the same production different versions of the application have been used. We have not decided yet how to compute their proc. pass.

  -- ElisaLanciotti - 17 Apr 2008

Revision 32008-06-23 - ElisaLanciotti

Line: 1 to 1
 
META TOPICPARENT name="BKDev"

New BK database schema

Line: 22 to 22
 

Special cases:

Changed:
<
<
The production 1959: here there is an additional step of digitization, but it is a fake step.. (removed from the proc. pass)
>
>
The production 1959: here there is an additional step of digitization, but it is a fake step.. (decide how to compute the proc.pass)
 

Productions 2000, 2001:

Revision 22008-05-19 - ElisaLanciotti

Line: 1 to 1
 
META TOPICPARENT name="BKDev"

New BK database schema

Line: 11 to 11
  A preliminary draft of the documentation about this new schema is available in this page (see below the newschema.pdf document). This is not yet an official documentation!
Added:
>
>

A new criterion to make queries on files: the Processing Pass

This is the set of application version and condition DB tags which have been used to produce a file and its ancestors.

The processing pass is common for all the files of the same production and of the same file type (ex. SIM, DIGI, DST).

By consequence, a processing pass corresponds to a set of productions. A complementary table has been introduced in the new schema, with the information relative to each production, file type and corresponding processing pass.

Special cases:

The production 1959: here there is an additional step of digitization, but it is a fake step.. (removed from the proc. pass)

Productions 2000, 2001: these productions are a special case because in the same production different versions of the application have been used. We have not decided yet how to compute their proc. pass.

  -- ElisaLanciotti - 17 Apr 2008

Revision 12008-04-17 - ElisaLanciotti

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="BKDev"

New BK database schema

The same tables will be used to store metadata relative to real data and simulated data. The main differences with respect to the old schema are the following:

  • Many obsolete or duplicated attributes have been dropped
  • Some new attributes have been added, relevant for real data
  • The 2 tables relative to files (files and fileParams tables) and the 2 tables relative to jobs ( jobs and jobParams tables) have been merged.
  • Two new tables have been added: DataTakingPeriod and ProcessingPass

A preliminary draft of the documentation about this new schema is available in this page (see below the newschema.pdf document). This is not yet an official documentation!

-- ElisaLanciotti - 17 Apr 2008

META FILEATTACHMENT attachment="newschema.pdf" attr="" comment="Draft (still preliminary) of the new database schema" date="1208441407" name="newschema.pdf" path="newschema.pdf" size="104858" stream="newschema.pdf" user="Main.ElisaLanciotti" version="1"
 
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