Using XSLT's SQL Extension with Encyclopedia Virginia

Abstract

This paper explores how to integrate data across a hybrid relational database and XML-based management system. It examines specifically how XSLT's SQL extension can be used to communicate information between SQL tables and TEI-conformant XML documents to make data-centric content more manageable and flexible and thereby leverage the strengths of both systems. In what follows, one will learn about some of the methods, benefits, and shortcomings of XSLT's SQL extension in the context of Encyclopedia Virginia, an open access publication of the Virginia Foundation for the Humanities that utilizes a suite of digital humanities and digital library XML vocabularies such as TEI and METS.