Personal tools

SRB:Schema Extending

From Adapt

Revision as of 17:38, 16 September 2008 by Toaster (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


From conversation w/ SDSC, this may only be relevant to versions prior to 3.x

        I have looked at the table  definition. Which database were they
written for?  I tried creating one of the tables in Oracle and failed.
To extend MCAT with attributes you need to follow four steps:

1. create the tables in the MCAT database
2. modify the include files (mdasC_db2_externs.h ,mdasGlobals.h)
   the mdasC_db2_externs.h has the index for the attribute
        that is visible through the MCAT API
    the mdasGlobals.h maps the index to table name and attribute name
3. modify the metadata.fkrel file in the data directory
    here you give the join attributes among the tables. make sure that you
        are not introducing cycles.
4. recompile client and server and restart the SRB.

this will allow you to query the attribute through the MCAT but does not
    provide a means of inserting or updating through the MCAT. You can do
    ingestion either through Oracle directly or usingt the SRB DAI
    interface. If you are doing thr DAI interface, I would suggest
    having a separete Oracle account for it and give it only insert
    permissions to these tables and not any other MCAT tables.

if you want to modify through the MCAT it is possible but a little bit
more involved.  The insertion of rows through MCAT is more involved and I
would   suggest not to try it if possible. we can use that as a last
resort if the DAI or Oracle option is not workable.

-- Main.MikeSmorul - 02 May 2005