16.4. Managing the Metadata

The specification of the data warehouse is stored in an XML document. This document contains the metadata of the warehouse, including:

  1. Information about the JDBC connection for XML data storage

  2. Data source URLs

  3. View specifications

We chose an XML format for metadata storage because of portability and easy parsing. We present now the DTD validating the warehouse metadata.

16.4.1. Data Warehouse

The root element of the data warehouse specification is declared as follows:

<!-- datawarehouse element -->
<!ELEMENT datawarehouse (connection, source*, view*) >
  • “connection” element contains data about the JDBC connection. This data is used to connect the data warehouse manager with the DBMS (MySQL) used to store data of the ...

Get XML Data Management: Native XML and XML-Enabled Database Systems now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.