Toaster at 17:38, 16 September 2008

2008-09-16T17:38:43Z

New page

From conversation w/ SDSC, this may only be relevant to versions prior to 3.x
<pre>
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.
</pre>

-- Main.MikeSmorul - 02 May 2005

SRB:Schema Extending - Revision history

Toaster at 17:38, 16 September 2008