Ministry of Agriculture & Lands
Data Warehouse Meta-content
Data Warehouse Meta-contentTable of Contents
Link to follow-up report: Survey Results
September 1997Executive Summary
The Information Management Branch (IMB) of the Ministry of Sustainable Resource Management(MSRM) is expanding its capability to manage structured and unstructured data across a distributed information management environment. The system will handle geographic, image, sound, document, and conventional data. The heart of such an environment is the meta-content repository. Meta-content is data that describe both database organization and the data's fitness for use (see Section 2 for a more complete definition).
The first steps in the development of a meta-content repository are to establish the roles the repository is to play, to identify the meta-content that supports those roles, and to design an information architecture to enable the business functions.
This report describes the results of a meta-content study by Mercator Systems
to address issues of MSRM meta-content. It introduces a meta-content framework
that clearly defines the potential roles the repository can play (Figure 1).
Figure 1. Recommended roles for MSRM meta-content. Meta-content should be used by MSRM to administer the database, assist in editing, document and oversee system architecture, aid in decision support, and describe marketing and utilitization.
The study performed a mid-stream review of MSRM's meta-content strategy, and
identifies gaps and overlaps with provincial, national, and international
meta-content standards. The standards compared were LandData BC Repository
Model, the US Federal Geographic Data Committee's content standard, and the
International Standard Organization's TC211 draft standard for metadata. The
goals of the review were threefold:
- determine how standards compare to MSRM's meta-content holdings
- determine the difficulty of complying with each standard
- glean the best ideas from the standards for adoption by MSRM.
This meta-content report is in three logical parts. The first part is comprised of Sections 1, 2, and 3; it provides background on this study, on meta-content issues, and on MSRM's existing system strategies.
The second part is comprised of Sections 4, 5, and 6; it provides an analysis of the three meta-content standards, highlighting the best ideas from each, and explaining how they could apply to MSRM meta-content holdings. Each section on the standards includes a final summary to highlight the most important findings and recommendations.
The final part is comprised of Section 7 alone; it compiles the recommendations discussed throughout the report into a strategy for MSRM meta-content. The following table summarizes specific recommendations for improving MSRM meta-content.
Recommendation |
Reference
model(s) |
| Describe
spatial extent by coordinate boundary. |
FGDC,
LDBC, TC211 |
| Improve
the description of coordinate systems, particularly datum and projection. |
TC211 |
| Add
horizontal and vertical accuracy, and define business rules for the use of
these data. |
FGDC,
TC211 |
| Improve
the identification information, particularly regarding the data originator and
point of contact. |
TC211 |
| Improve
quality descriptors, including accuracy, resolution, completeness, logical
consistency, lineage, currency, and accountability. |
FGDC,
TC211 |
| Provide
the capability to link Information Sources to scanned documents, GIF files, and
structured documents. |
LDBC |
| Improve
lineage information, including source reference, process steps, and processing
software. |
TC211,
LDBC |
| Define
the originating government Ministry, Department, Program, or Project. |
LDBC |
| Adopt
more normalized meta-types (e.g., citation, time period, and contact
information). |
FGDC,
TC211 |
| Consider
adopting an information type hierarchy. |
TC211 |
| Provide
for version control and change notification. |
LDBC |
| Provide
schema identification and browsing through Designer/2000 and off-the-shelf
reporting tools. |
D/2000 |
| Consider
including roles as part of Person/Org. |
Mercator |
| Support
the tracking of usage statistics, feedback on data quality, and meta-content
provision to users. |
LDBC |
Table of Contents
- 1. Introduction
- 2. Meta-content and information resources
- 3. MSRM and IMB situation assessment
- 4. The FGDC meta-content standard
- 5. The LandData BC repository model
- 6. The TC211 meta-content standard
- 7. Recommendations
- 8. References
