The LoPiX-Mondial Case Study: Data Integration in XML

The LoPiX - Mondial case study illustrates data integration in XML using the LoPiX system. LoPiX is an implementation of the XML XML querying and data manipulation language XPathLog.

The case study is based on XML representations of the sources which have been used for generating the Mondial database:

• CIA World Factbook,
• Global Statistics which has been collected by Johan van der Heijden.
• additional textual sources for coordinates,
• the International Atlas by Kümmerly & Frey, Rand McNally, and Westermann,
• and some geographical data of the Karlsruhe TERRA database.

The original HTML sources have been mapped to XML using wrappers with the FLORID system (see here).

• The individual sources in XML format
  • CIA Factbook: Country Data cia.xml cia.dtd
  • CIA Factbook: Organizations orgs.xml orgs.dtd
  • Global Statistics: Countries, Cities and Provinces gs.xml gs.dtd
  • Cities: Geographic Coordinates qiblih.xml qiblih.dtd
  • the Original TERRA database terra.xml terra.dtd
  • Country codes and names codes.xml codes.dtd
  (note that most browsers to not *show* XML and DTD files correctly. Download the file(s) and load them into an editor)

The integration of the above sources has been done in XPathLog:

• The integration is described in the in the report
  Information Integration in XML: The Mondial Case Study.
  Wolfgang May; Preliminary Report, Institut für Informatik, Universität Freiburg, March 2001.
• Integration Program
  • Integration program "mondial-integra.lpx"
  (note that some browsers to not *show* the program correctly. Download the file and load it into an editor)
• Integrated XML Database
  • mondial.dtd
  • mondial.xml
  (note that most browsers to not *show* XML and DTD files correctly. Download the file(s) and load them into an editor)