mercredi 18 février 2015

Generate tables out of an xml File (UML representation)

I have the following xml file, from which I want to create a database





<knowledge_base>
</entity>
<entity wiki_title="China_National_School_of_Administration" type="ORG" id="E8" name="China National School of Administration">
<facts>
<fact name="name">China National School of Administration</fact>
<fact name="established"><link>1994</link></fact>
<fact name="city"><link>Beijing</link></fact>
<fact name="country"><link>China</link></fact>
<fact name="native_name">国家行政学院</fact>
<fact name="type"><link>Public</link></fact>
<fact name="president"><link>Ma Kai</link></fact>
<fact name="campus"><link>Urban</link></fact>
</facts>
<wiki_text><![CDATA[China National School of Administration
China National School of Administration (CNSA, 国家行政学院), ]]></wiki_text>
</entity>
<entity wiki_title="East_Java" type="GPE" id="E18" name="East Java">
<facts>
<fact name="name">East Java (Jawa Timur)</fact>
<fact name="country">Indonesia</fact>
<fact name="motto">Jer Basuki Mawa Béya</fact>
<fact name="capital"><link>Surabaya</link></fact>
<fact name="population">34766000</fact>
<fact name="population_as_of">2000</fact>
<fact name="area_in_km2">47922</fact>
<fact name="Time"><link>WIB</link> (<link>UTC+7</link>)</fact>
<fact name="ethnicity"><link>Javanese</link> (79%), <link>Madurese</link> (18%), <link>Osing</link> (1%), <link>Chinese</link> (1%)</fact>
<fact name="religion"><link>Islam</link> (96.3%), <link>Christianity</link> (2.6%), <link>Hinduism</link> (0.6%), <link>Buddhism</link> (0.4%), <link>Kejawen</link> also practised</fact>
<fact name="language"><link>Javanese</link>, <link>Madurese</link>, <link>Indonesian</link></fact>
<fact name="governor"><link>Imam Utomo</link></fact>
<fact name="site">[ http://www.jatim.go.id/ ]</fact>
<fact name="map"></fact>
</facts>
<wiki_text><![CDATA[East Java]]</wiki_text>
<entity wiki_title="Abdurrahman_Wahid" type="PER" id="E11" name="Abdurrahman Wahid">
<facts>
<fact name="name">Abdurrahman Wahid</fact>
<fact name="order">4th <link>President of Indonesia</link></fact>
<fact name="term_start">October 20, 1999</fact>
<fact name="term_end">July 23, 2001</fact>
<fact name="predecessor"><link>Jusuf Habibie</link></fact>
<fact name="successor"><link>Megawati Sukarnoputri</link></fact>
<fact name="birth_date">September 7, 1940 (1940 -09-07) (age 68)</fact>
<fact name="birth_place"><link>Jombang</link>, <link entity_id="E18">East Java</link></fact>
<fact name="dead">alive</fact>
<fact name="spouse">Shinta Nuriyah</fact>
<fact name="party"><link>National Awakening Party</link></fact>
<fact name="vicepresident"><link>Megawati Sukarnoputri</link></fact>
<fact name="religion"><link>Islam</link></fact>
</facts>
<wiki_text><![CDATA[Abdurrahman Wahid]]</wiki_text>
</knowledge_base>




I represented the following xml tree as follow:



  • The knowledge database has 1 to many entities

  • Every entity has 1 to many facts and 1 knowledge database

  • Every fact has 1 entity and 1 to many links

  • Every link has 1 fact and may or may not point to another entity





  • Facts has as foreign key the entity_ID

  • links: are the foreign keys in link represented correctly?

  • Does this representation sound logical?


enter image description here


Aucun commentaire:

Enregistrer un commentaire