以文本方式查看主题

-  中文XML论坛 - 专业的XML技术讨论区  (http://bbs.xml.org.cn/index.asp)
--  『 XML基础 』  (http://bbs.xml.org.cn/list.asp?boardid=1)
----  请高手帮忙写一个架构  (http://bbs.xml.org.cn/dispbbs.asp?boardid=1&rootid=&id=61191)


--  作者:x032403
--  发布时间:4/11/2008 2:15:00 PM

--  请高手帮忙写一个架构
我想把一个xml里的数据转入123.dbf表中,想提取其中部分字段到表里面


xml文件
由于很长,所以只列出了一个<PubmedArticle>元素。
<?xml version="1.0"?>
<!DOCTYPE PubmedArticleSet PUBLIC "-//NLM//DTD PubMedArticle, 1st January 2007//EN" "http://www.ncbi.nlm.nih.gov/entrez/query/DTD/pubmed_080101.dtd">
<PubmedArticleSet>
<PubmedArticle>
    <MedlineCitation Owner="NLM" Status="MEDLINE">
        <PMID>18158825</PMID>
        <DateCreated>
            <Year>2007</Year>
            <Month>12</Month>
            <Day>26</Day>
        </DateCreated>
        <DateCompleted>
            <Year>2008</Year>
            <Month>03</Month>
            <Day>13</Day>
        </DateCompleted>
        <Article PubModel="Print">
            <Journal>
                <ISSN IssnType="Print">1096-620X</ISSN>
                <JournalIssue CitedMedium="Print">
                    <Volume>10</Volume>
                    <Issue>4</Issue>
                    <PubDate>
                        <Year>2007</Year>
                        <Month>Dec</Month>
                    </PubDate>
                </JournalIssue>
                <Title>Journal of medicinal food</Title>
            </Journal>
            <ArticleTitle>Soy isoflavones as safe functional ingredients.</ArticleTitle>
            <Pagination>
                <MedlinePgn>571-80</MedlinePgn>
            </Pagination>
            <Abstract>
                <AbstractText>In recent years, isoflavones have increased in popularity as an alternative to estrogen therapy, particularly after the Women's Health Initiative demonstrated an increased risk of breast cancer, stroke, and heart attacks in response to estrogen and progesterone intervention. Isoflavones are heterocyclic phenols with structural similarity to estradiol-17beta and selective estrogen receptor modulators. Actions at the cellular level depend on the target tissue, receptor status of the tissue, and the level of endogenous estrogen. Clinical studies of soy-based diets evaluating the relation between soy consumption and serum lipid concentrations revealed that soy consumption significantly decreased total cholesterol, low-density lipoprotein cholesterol, and triglyceride levels. Epidemiological studies suggest a protective effect of soy protein on breast tissue as evidenced by the lower rates of breast cancer in East Asian countries where soy is a predominant part of the diet. Soy products also alleviate menopausal symptoms by reducing hot flashes. However, whether these biological effects of soy products originated from isoflavones is not clear. Furthermore, data available from human studies on the effect of isoflavones on osteoporosis are limited, and additional studies are needed to support a role in osteoporosis prevention. To date, no adverse effects of short- or long-term use of soy proteins are known in humans, and the only adverse effects known are those reported in animals. In conclusion, isoflavones are biologically active compounds, and current data are insufficient to draw definitive conclusions regarding the use of isoflavones as an alternative to estrogen for hormone replacement in postmenopausal women. Large, long-term intervention studies examining adverse effects and disease outcomes are needed before definitive conclusion can be drawn.</AbstractText>
            </Abstract>
            <Affiliation>Department of Food Science and Human Nutrition, Michigan State University, MI 48824, USA. song@msu.edu</Affiliation>
            <AuthorList CompleteYN="Y">
                <Author ValidYN="Y">
                    <LastName>Song</LastName>
                    <ForeName>Won O</ForeName>
                    <Initials>WO</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Chun</LastName>
                    <ForeName>Ock Kyoung</ForeName>
                    <Initials>OK</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Hwang</LastName>
                    <ForeName>Inkyeong</ForeName>
                    <Initials>I</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Shin</LastName>
                    <ForeName>Han Seung</ForeName>
                    <Initials>HS</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Kim</LastName>
                    <ForeName>Bong-Gwan</ForeName>
                    <Initials>BG</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Kim</LastName>
                    <ForeName>Kun Soo</ForeName>
                    <Initials>KS</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Lee</LastName>
                    <ForeName>Sang-Yun</ForeName>
                    <Initials>SY</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Shin</LastName>
                    <ForeName>Dayeon</ForeName>
                    <Initials>D</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Lee</LastName>
                    <ForeName>Sung G</ForeName>
                    <Initials>SG</Initials>
                </Author>
            </AuthorList>
            <Language>eng</Language>
            <PublicationTypeList>
                <PublicationType>Journal Article</PublicationType>
                <PublicationType>Review</PublicationType>
            </PublicationTypeList>
        </Article>
        <MedlineJournalInfo>
            <Country>United States</Country>
            <MedlineTA>J Med Food</MedlineTA>
            <NlmUniqueID>9812512</NlmUniqueID>
        </MedlineJournalInfo>
        <ChemicalList>
            <Chemical>
                <RegistryNumber>0</RegistryNumber>
                <NameOfSubstance>Flavonoids</NameOfSubstance>
            </Chemical>
            <Chemical>
                <RegistryNumber>0</RegistryNumber>
                <NameOfSubstance>Isoflavones</NameOfSubstance>
            </Chemical>
            <Chemical>
                <RegistryNumber>0</RegistryNumber>
                <NameOfSubstance>Phytoestrogens</NameOfSubstance>
            </Chemical>
        </ChemicalList>
        <CitationSubset>IM</CitationSubset>
        <MeshHeadingList>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Cardiovascular Diseases</DescriptorName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="Y">Diet</DescriptorName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Female</DescriptorName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Flavonoids</DescriptorName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Health Promotion</DescriptorName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Humans</DescriptorName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Infant Formula</DescriptorName>
                <QualifierName MajorTopicYN="N">chemistry</QualifierName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Isoflavones</DescriptorName>
                <QualifierName MajorTopicYN="Y">administration &amp; dosage</QualifierName>
                <QualifierName MajorTopicYN="Y">adverse effects</QualifierName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Menopause</DescriptorName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Neoplasms</DescriptorName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Phytoestrogens</DescriptorName>
                <QualifierName MajorTopicYN="N">adverse effects</QualifierName>
            </MeshHeading>
            <MeshHeading>
                <DescriptorName MajorTopicYN="N">Soybeans</DescriptorName>
                <QualifierName MajorTopicYN="Y">chemistry</QualifierName>
            </MeshHeading>
        </MeshHeadingList>
        <NumberOfReferences>123</NumberOfReferences>
    </MedlineCitation>
    <PubmedData>
        <History>
            <PubMedPubDate PubStatus="pubmed">
                <Year>2007</Year>
                <Month>12</Month>
                <Day>27</Day>
                <Hour>9</Hour>
                <Minute>0</Minute>
            </PubMedPubDate>
            <PubMedPubDate PubStatus="medline">
                <Year>2008</Year>
                <Month>3</Month>
                <Day>14</Day>
                <Hour>9</Hour>
                <Minute>0</Minute>
            </PubMedPubDate>
        </History>
        <PublicationStatus>ppublish</PublicationStatus>
        <ArticleIdList>
            <ArticleId IdType="doi">10.1089/jmf.2006.0620</ArticleId>
            <ArticleId IdType="pubmed">18158825</ArticleId>
        </ArticleIdList>
    </PubmedData>
</PubmedArticle>
</PubmedArticleSet>

想提取其中的PMID和MeshHeading,两项到表中,如果能提取其他到表中更好,主键是MeshHeading,其他可以重复的,就是几个MeshHeading的PMID可以相同。


W 3 C h i n a ( since 2003 ) 旗 下 站 点
苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》
89.844ms