OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [xml-dev] storing XML files

Hi nice people,

Many thanx to all who took their time to answer my questions and think
together with me on reaching the right approach and tools for my project.

Some of you asked me for additional or more detailed information to be able
to extend the discussion.

the data I am dealing with is:

5, 6 different xml data feeds
possible several new data feeds in the near future
they are usually very small files
their DTD's are well defined and don't change over time, only I don't know
in advance the DTD's of the future data feeds.
nesting depth is very small

Ronald: What do you mean by "semi-structured"_ness of the data?

<!--     EXAMPLE -->

<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE nitf SYSTEM "nitf-adjusted-13c.dtd">
<meta name="onlinefolder" content="Entertainment"></meta>
<date.issue norm="20010302 150629+0100"></date.issue>
        	<keyword key="Maxima"></keyword>
        	<keyword key="Princess"></keyword>
<hedline><hl1>Maxima speaks perfect dutch</hl1></hedline>
<p>Princess Maxima presented the Princess Collection 2000 in an estate with
a very royal ambiance. The dazzling collection is also presented in the new
catalogue full of show, glitter and glamour.</p>

<!--     /EXAMPLE -->

All I want to do with them for now, is to save them in a RDBMS. The rest of
the applications (ASPs or servlets) will access that data through ODBC or
They will be interested in such queries:
Find and display all datafeeds containing "this" and "that" keywords ...
	<keyword key="Maxima"></keyword>
	<keyword key="Princess"></keyword>

Find me all the datafeeds issued on that date
<date.issue norm="20010302 150629+0100"></date.issue>

If the applications access the datafeeds through ODBC or JDBC and they don't
ask for XML format, ( no need for XML retrieval ) I see no reason for
introducing a XML native database at this point, but please correct me I am
wrong ...

I just need a good way to transform a XML data feeds into relational
database model. That is why, I asked for something like DTD2SQL or XML2SQL
tool. So, I imagined applying XSLT transformations to every different
datafeed to transform it into some DTD for SQL and then just run that SQL.

My idea was to generate some intermediate XML that describes a RDBMS
Something maybe like this, but more sophisticated, I guess ... and simple
enough :)

<!--    example of standard DTD for SQL output -->

<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE sql SYSTEM "sql.dtd">
<record table="anp" type="master">
   <column name="issued" type="date">1.2.2221</column>
   <column name="description"  type="text">
          Princess presented the Princess Collection 2000 in an estate with
a very royal ambiance. The dazzling collection is also presented in the new
catalogue full of show, glitter and glamour. 
   <record table="keyword" type="detail">
       	<column name="keyword"  type="text">Maxima</column>
   <record table="keyword" type="detail">
       	<column name="keyword"  type="text">Princess</column>
   <record table="category" type="lookup">
       	<column name="category"  type="text">Entertainment</column>
<!--    example of standard DTD for SQL output -->

So, I am searching for a standart DTD to describe records ot be inserted,
relationships between them and in general, to create SQL fairly strait
forward from it.

Thanx again for your time and friendly support.
Nice day!

Albena Georgieva
Internet Software Developer
Sint Antoniesbreestraat 16
1011 HB Amsterdam
t. +31 (0) 20 530 9100