|
OraCIF
is a set Pl/Sql packages running on Oracle 9.2
using dynamic SQL. It requires DBMS_LOB, UTL_FILE, DBMS_JOB,
DBMS_SESSION and XML_DB Oracle Utilities.
The
routines created for the Generator are Pl/Sql
database stored procedures which handle Sql and SqlX
cursors. OraCIF has it's own set of Oracle tables
and uses CLOB and XMLtype Columns to store the information
about mmCIF and XML documents respectively.
Two
installations of OraCIF has been done, one for the
exchange with RCSB and the other to produce the complete set of
depositions from MSD databases in XML format to generate
the Atlas pages for MSDlite and MSDpro. Each
installation need one dedicate Oracle user
termed a OraCIF instance.
For
now, all XML treatment is non schema based.
|