How To Create A Crosswalk Document

A schema crosswalk is a table that shows equivalent elements (or "fields") in more than one database schema. It maps the elements in one schema to the equivalent elements in another schema. Crosswalk tables are often employed within or in parallel to enterprise systems, especially when multiple systems are interfaced or when the system includes legacy system data. In the context of Interfaces, they function as a sort of internal Extract, Transform, Load (ETL) mechanism. For example, this is a metadata crosswalk from MARC standards to Dublin Core:

Property	Value
dbo:abstract	A schema crosswalk is a table that shows equivalent elements (or "fields") in more than one database schema. It maps the elements in one schema to the equivalent elements in another schema. Crosswalk tables are often employed within or in parallel to enterprise systems, especially when multiple systems are interfaced or when the system includes legacy system data. In the context of Interfaces, they function as a sort of internal Extract, Transform, Load (ETL) mechanism. For example, this is a metadata crosswalk from MARC standards to Dublin Core: Crosswalks show people where to put the data from one scheme into a different scheme. They are often used by libraries, archives, museums, and other cultural institutions to translate data to or from MARC standards, Dublin Core, Text Encoding Initiative (TEI), and other metadata schemes. For example, say an archive has a MARC record in their catalog describing a manuscript. If the archive makes a digital copy of that manuscript and wants to display it on the web along with the information from the catalog, it will have to translate the data from the MARC catalog record into a different format such as Metadata Object Description Schema that is viewable in a webpage. Because MARC has different fields than MODS, decisions must be made about where to put the data into MODS. This type of "translating" from one format to another is often called "metadata mapping" or "field mapping," and is related to "data mapping", and "semantic mapping". Crosswalks also have several technical capabilities. They help databases using different metadata schemes to share information. They help metadata harvesters create union catalogs. They enable search engines to search multiple databases simultaneously with a single query. (en)
dbo:wikiPageExternalLink	http://jatswiki.org/wiki/JATS-to-MARC_mapping http://legacy.alexandria.ucsb.edu/public-documents/metadata/fgdc2marc.html http://metadata.teldap.tw/standard/mapping-foreign_eng.htm http://purl.oclc.org/NET/teiinlibraries http://www.dlib.org/dlib/june06/chan/06chan.html https://loc.gov/marc/dccross.html https://loc.gov/marc/marc2dc.html https://loc.gov/marc/onix2marc.html http://www.ukoln.ac.uk/metadata/interoperability http://www.ukoln.ac.uk/metadata/interoperability/ http://www.ukoln.ac.uk/metadata/interoperability/dc_unimarc.html http://www.getty.edu/research/conducting_research/standards/intrometadata/path.html https://web.archive.org/web/20080720134522/http:/libraries.mit.edu/guides/subjects/metadata/mappings.html https://web.archive.org/web/20121116094817/http:/php.indiana.edu/~fryp/marcmap.html https://www.loc.gov/ead/tglib/appendix_a.html%23a1 https://www.loc.gov/ead/tglib/appendix_a.html%23a2 https://www.loc.gov/ead/tglib/appendix_a.html%23a3 http://www.oclc.org/research/researchworks/schematrans/default.htm
dbo:wikiPageID	18048026 (xsd:integer)
dbo:wikiPageLength	8034 (xsd:nonNegativeInteger)
dbo:wikiPageRevisionID	994243622 (xsd:integer)
dbo:wikiPageWikiLink	dbr:Legacy_system dbr:Database_schema dbr:Text_Encoding_Initiative dbc:Data_management dbr:Metadata dbr:Database dbr:Dublin_Core dbc:Knowledge_representation dbc:Library_cataloging_and_classification dbc:Metadata dbc:Technical_communication dbr:Data_mapping dbr:MARC_standards dbr:Metadata_Object_Description_Schema dbr:Semantic_mapper dbr:Extract,_Transform,_Load dbr:Enterprise_systems dbr:Meta_tag
dbp:wikiPageUsesTemplate	dbt:Reflist
dct:subject	dbc:Data_management dbc:Knowledge_representation dbc:Library_cataloging_and_classification dbc:Metadata dbc:Technical_communication
gold:hypernym	dbr:Table
rdf:type	dbo:Work
rdfs:comment	A schema crosswalk is a table that shows equivalent elements (or "fields") in more than one database schema. It maps the elements in one schema to the equivalent elements in another schema. Crosswalk tables are often employed within or in parallel to enterprise systems, especially when multiple systems are interfaced or when the system includes legacy system data. In the context of Interfaces, they function as a sort of internal Extract, Transform, Load (ETL) mechanism. For example, this is a metadata crosswalk from MARC standards to Dublin Core: (en)
rdfs:label	Schema crosswalk (en)
owl:sameAs	freebase:Schema crosswalk wikidata:Schema crosswalk https://global.dbpedia.org/id/4uTbh
prov:wasDerivedFrom	wikipedia-en:Schema_crosswalk?oldid=994243622&ns=0
foaf:depiction	wiki-commons:Special:FilePath/Green_Valley_Park_in_Payson,_Arizona.jpg
foaf:isPrimaryTopicOf	wikipedia-en:Schema_crosswalk
is dbo:wikiPageDisambiguates of	dbr:Crosswalk_(disambiguation)
is dbo:wikiPageRedirects of	dbr:Crosswalk_(metadata)
is dbo:wikiPageWikiLink of	dbr:Legacy_system dbr:LIDO dbr:Crosswalk_(disambiguation) dbr:Describing_Archives:_A_Content_Standard dbr:Schema_matching dbr:Crosswalk_(metadata)
is foaf:primaryTopic of	wikipedia-en:Schema_crosswalk