I'm working with XML extnder..and am storing data throught XColumn.
It seems it is impossible to store a documnet which has a DTD like
<!ELEMENT ARTICLE (CHAPTER+)>
<!ATTLIST ARTICLE ARTICLE-ID KEY #REQUIRED>
<!ELEMENT CHAPTER (SECTION+)>
<!ATTLIST CHAPTER CHAPTER-ID KEY #REQUIRED>
<!ELEMET SECTION (TEXT+)>
<!ATTLIST SECTION SECTION-ID KEY #REQUIRED>
<!ELEMENT TEXT (#PCDATA)>
I need to store all the elements and attributes in side-tables(I can very
well do it with XCollection, but I need to do with XColumn :) becuase of
Now multi_occurence attribute in DAD file will have value "YES" for
CHAPTER-ID as well as for SEcTION-ID. so I cannot store both of these
together in the same tables. Thus it is a lossy decomposition, as I cannot
know after decomposition which section belong to which chapters. becuase I
need to have a table in which there are columns for both chapter-id and
section-id telling which sections occur in which chapter. I don't think it
is possible because multi-occurence attribute for both of these is "YES".
Is there a way out, so that it is a lossless decomposition.
Thanks in advance...
p.s: I think I'm somewhat misinterpreting multi-occurence attribute. Can
anyone clarify how it is used.
Computer Science and Engineering
University of Waterloo
Studying in: Indian Institute of Technology, India