XORT/tool data

From GMOD
Jump to: navigation, search

{{ {{{template}}} | name = XORT | full_name = | status = mature | dev = maintenance | support = active | type = Database tools, Middleware | os = linux, unix | logo = | home = http://gmod.org/wiki/XORT | about = 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.

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."

| screenshot = | public_server = | dl = | dl_url = http://sourceforge.net/projects/gmod/files/OldFiles/ | dl_src = | dl_src_url = | dl_dev = | dl_dev_url = | getting_started_preamble = | req =

| install = | config = | doc =

| papers = | presentations =

| tutorials = | wild_urls = | mail = There is no mailing list for XORT; please direct queries to the GMOD helpdesk or to the XORT developer Pinglei Zhou. | logo_info = | dev_ppl = FlyBase at Harvard | dev_status = | contact_email = zhou@morgan.harvard.edu | formats = | see_also =

Note that GMODTools offers an alternative approach to bulk uploads and downloads from a Chado database.

DBStag

The DBStag XML<->SQL API implements the XORT spec for bulkloading of data; it does not support the dump spec

Chado-XML

Chado XML is a direct mapping of the Chado relational schema into XML.

Tools that read and write Chado-XML

go2chadoxml

Distributed as part of go-perl. Takes any obo file and exports as Chado-XML. Can be loaded using XML::Xort or DBStag

Status: Stable

The OBO repository is pre-converted to Chado-XML on a nightly basis.

BioPerl

writes chadoXML

Status: ?

Bio-Chaos

The bio-chaos library reads and writes chaos-xml, which can be converted to and from chado

Status: no longer supported

Macros

The basic chadoXMLl expansion can be extremely verbose - this is because chadoXML uses the unique keys from the chado db, yet it does not use 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.

| demo_server = | survey_link = |release date=2006 }}