Problem
Solution
Details
Findings
Future
ARCHITECTURE & WORKFLOW
DETAILS
1. Initially
programmed in SQL, delivered MSSQL
2. Migration
to ORACLE TM
XML/XSLT Support
Support for future
enhancements
Built-in bells &
whistles
3. At the
moment, mappings are done manually from contributor exports
4. DB -->
XML achieved via XMetal database import wizard
5. Data
frequently is “massaged” in early stages; less so as contributors learn
6. After
DB-->XML and quality control, XML goes to DB administrator
7. XML is
re-validated, then a) parsed, b) ingested as document
8. Search
& Display Forms/Stylesheets modified as necessary (XSLT).