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:
Information about the JDBC connection for XML data storage
Data source URLs
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 ...