HowTo 2. Create new version for existing data table.

In this document we explain how to add another version 'TIFG-01' for node TIFG in the ATLAS Geometry DB. We assume that all the steps described in previous HowTo have already been performed and table TIFG_DATA contains two records with ID = 0,1. Say we want to modify just one field in the first record and put Nelem=15. We produce a new record with ID = 2 and call the records with ID = 2,1 the tag 'TIFG-01'.

  1. Step 1. Declare the new tag labeled 'TIFG-01' of TIFG node.
    Go to web tool, provide username/password and follow the link Create new tag. From drop-down list select TIFG and click Next. Enter new tag name TIFG-01 and click create. You will get an ID for this new tag which should be used later in SQL scripts.

  2. Step 2.Insert new record in TIFG data table.
    Modify ~tsulaia/public/start_sqlplus.sh replacing the user name atlasdd_reader by atlasdd_writer and start SQLPLUS by sourcing this script. Invoke following command.
    # insert into atlasdd.tifg_data values (2, 1, 15, 43.05);

  3. Step 3. Commit your modifications.
    # commit;

  4. Step 4. Exit sqlplus.
    # exit

  5. Step 5. Assign two TIFG records with ID=1,2 to TIFG-01 tag.
    Follow the link Collect leaf tags. Select the TIFG node from the list, then select TIFG-01 tag and click Collect. You will get the entire TIFG data table. Select records to with ID=1,2 and click Collect Selected Records.
Back