XORT is a utility written in Perl that can be used to read to and write from a relational schema using XML as an interchange format. In GMOD XORT is frequently used to transfer data to and from Chado.
We have developed XORT, an XML-database mapping system for data exchange. XORT’s three major elements are an XML-database schema mapping specification, an XORT language for both data retrieval and data construction, and a collection of tools that are based on the specification to facilitate the mapping and data exchange. The mapping specification specifies the schema requirement, mapping, operation, and object reference mechanism; the XORT language is used to construct the dump specification; the tool collections comprise the data validation, data input, data output and data debug system. Because it originates from the Chado database, we denote the corresponding XML - Chado XML.
Our project has been using XORT for Drosophila melanogaster genome annotation in the context of a genome database, specifically with Chado and Apollo. Our results validate the architecture of XORT, and show that XORT provides excellent performance both in flexibility and extensibility. Despite its start as a system to manage an organism genome database, with its generic design, it can readily be extended to other database systems, as long the schema design satisfies minimal basic requirements.
Note that GMODTools offers an alternative approach to bulk uploads and downloads from a Chado database.
Chado-XML is a direct mapping of the Chado relational schema into XML.
The basic chado-xml expansion can be extremely verbose - this is because chado-xml uses the unique keys from the chado db, yet it does not database internal foreign keys. XORT can be configured with macros that can be used to capture repeated nodes in the XML and give them XML IDs that are valid within a particular document.