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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial