Browse Prior Art Database

Utility to load xml elements

IP.com Disclosure Number: IPCOM000197257D
Publication Date: 2010-Jun-30
Document File: 2 page(s) / 78K

Publishing Venue

The IP.com Prior Art Database

Abstract

A program is disclosed that load parts of the XML documents to the specified table in the xml repository with the options provided.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 55% of the total text.

Page 1 of 2

Utility to load xml elements

Utility to load xml elementsUtility to load xml elements

Implementation

Add XMLTABLE option for load command.

    XMLTABLE option will look for txt file which contains information about table column and element names.

Add file as parameter to XMLTABLE option by which it will include the column names and path of element that needs to be added.

Add level option that will break the document wrt levels and insert to different tables. (Level option can break XML documents wrt levels or hierarchy and insert into tables;

Number of tables will be the number of breaks and tables' names will be like table1,

table2 etc.).

Retain temporary table created for inserting XML documents to table.

Proposed load command options

LOAD [

-xmltable] {filename} [

Basic fetch required data and insert into a single table

load xdsdirectory xdsfilename xmldocument -xmltable t1.txt insert into t1 Basic fetch required data and insert into multiple tables

load xdsdirectory xdsfilename xmldocument -xmltable t1.txt,t2.txt insert into t1 ,t2 Advanced break document wrt levels of xmldocument and insert into tables created by the system with names starting with TABLE

load xdsdirectory xdsfilename xmldocument -xmltable -level 3 insert into TABLE Basic fetch required data and insert into multiple tables and retain the specified temporary table that is created

load xdsdirectory xdsfilename xmldocument -xmltable t1.txt,t2.txt insert into t1 ,t2

retain t1

Basic fetch required data and insert into multiple tables and retain all temporary tables that are created

load xdsdirectory xdsfilename xmldocument -xmltable t1....