HOME   UP  

picture


Changes from CERA-2.4 to CERA-2.5

The following changes/supplements of CERA-2.4 have been accepted for Version CERA-2.5 (CR=Claus Rachimow, HT=Hannes Thiemann, FT=Frank Toussaint); respectively: CERA Module DATA_ORGANIZATION 1.2 ==> DATA_ORGANIZATION 1.3. Find the SQL for the migration here.
No. Date From Concerning Subject
104.01.00FTBlock METADATA ENTRYNew Block "Languages", as language is required in many European metadata standards.
519.02.01FTMod. DATA_ORG: Most entities and LOVextend to 3 description fields: _acronym*31, _name*250, _descr*2000
619.02.01FTCore: Block structureNew Block "ENTRY_CONNECT" of tables Entry_connect, Connect_type (formally Block METADATA ENTRY)
719.02.01FTCore: Block structureNew Block "KEY_CONNECT" of tables Key_connect, General_key (formally Block METADATA ENTRY)
819.02.01FTCore: Block structureNew Block "CAMPAIGN" of tables Campaign, Project (formally Block METADATA ENTRY)
919.02.01FTCore: Block structureTables Quality, Progress to Block METADATA ENTRY (formally Block STATUS)
1019.02.01FTCore: Block structureNew Block "PROCESS_STEP" of table PROCESS_STEP (formally Block STATUS [to be dropped])
1119.02.01FTCore: Block structureNew Block "LOCATION_CONNECT" of tables Location_connect, Location (formally Block COVERAGE)
1427.02.01CRtable PROCESS_STEPAs a module, not a block
1610.03.01HT/FTCore: Tab.PARAMETERAdd Column Data_org_seq*int (to order the topics)
1714.03.01HTMod. DATA_ORG: MomentRename column utc_difference to utc_diff_hours
1814.03.01HT/FTNEW Mod. PATCHED_DIMENSIONSubModule of DATA_ORGANIZATION to allow for patchwise equidistant gridded dimensions
2 Relation Tables: SCALE_/TIME_PATCHES with columns: scale_/time_id, patch_id, specifier*int
1915.03.01FTMod. DATA_ORG.Time_connectAdd column sequence_no*int
2015.03.01FTCore: Entry.entry_acronymMake column UNIQUE
2122.03.01FTCore: Entry.entry_acronymMake all *_acronym columns UNIQUE, except for Topic, where topic_name is UNIQUE

Pages are optimized for NETSCAPE. For comments and suggestions contact CERA Admin.

Last change: Mon Mar 26 10:22:37 NFT 2001