Inserting XML data into database

• Using Oracle XML Parser:
  Currently uploading XML data into the POET database is done by runtime generation of classes using IBM XML Parser for Java [IBM, 1999]. Java objects are instantiated at runtime using the created classes and which are inserted into the POET database using POET API.

  To migrate to Oracle8i [Oracle, 1998], the generation of classes would have to be modified to support datatypes that Oracle supports. Also the parser used can be Oracle XML Parser for better compatibility. Similarly the querying module would support Oracle specific datatypes.

• Using Oracle Internet File System (iFS):
  The Oracle Internet File System (iFS) can be used in place of the Oracle XML Parser. iFS provides built-in support for defining, parsing, and rendering file types that are XML documents. Any XML document data to be inserted into the database is registered with iFS along with the description of the document structure in an XML-based syntax. Once this is done, the content of the iFS files can be searched using standard SQL queries. XML documents can be either stored into a series of related database tables and columns, or the entire XML file can be stored in a "text blob".