Transforming MARCXML Records Using XSLT

1 Transforming MARCXML Records Using xslt Violeta Ilik Head, Digital Systems & Collection Services Digital Innovations Librarian Galter Health Sciences Library Northwestern University Clinical and Translational Sciences Institute Chicago, IL March 4, 2015 Hosted by ALCTS, Association for Library Collections and Technical Services Teun Hocks Violeta Ilik +ALCTS - Library Resources & Technical Services n Ilik, V., Storlien, J., and Olivarez, J. (2014). Metadata Makeover: Transforming MARC Records Using xslt . Library Resources and Technical Services 58 (3): 187-208.

2 The knowledge gained from learning information technology can be used to experiment with methods of Transforming one metadata schema into another Using various software solutions Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik +Why Catalogers? n Survey conducted by Ma in 2007 revealed that the metadata qualifications and responsibilities required knowledge of MARC, crosswalks, XML, OAI .. n Analysis of cataloging position description performed by Park, Lu, and Marion reveal that advances in technology have created a new realm of desired skills, qualifications and responsibilities for catalogers.

3 N Terry Reese s MarcEdit is a best friend to everyone in technical services n Tosaka stresses the importance of metadata transformation to enable reuse Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik +Recommendations: n Cataloging departments need to be proactive in creation and maintenance of non-MARC metadata AND in the development of means for sharing the metadata n Catalogers need to participate in development and use of descriptive standards n Catalogers need to participate in development of semantic web technologies.

4 Creation of semantic web compliant data Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik +Outline: n MARC data challenges n XML family of standards n XML & xslt n Metadata Map n Metadata transformation (live demo) n Resources n Conclusion Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik +MARC data challenges Common issues - metadata and crosswalks The four categories of metadata problems according to Dushay and Hillman: n missing data n incorrect or erroneous data n confusing or inconsistent data n insufficient data Naomi Dushay and Diane I.

5 Hillman, Analyzing Metadata for Effective Use and Re-use, in Proceedings of the 2003 International Conference on Dublin Core and Metadata Applications: Supporting Communities of Discourse and Practice - Metadata Research & Applications ( : Dublin Core Metadata Initative, 2003) Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik +MARC data challenges The Challenges: n ambivalent matches n hybrid bibliographic Records n data mapping to multiple fields or combining into single fields during migration n orphaned data parsed into incongruous fields n mixed standards in original data n MARC data loss during the migration n flat structure versus hierarchical structures (Mary S.)

6 Woodley et al., Crosswalks, Metadata Harvesting, Federated Searching, Metasearching: Using Metadata to Connect Users and Information, in Introduction to Metadata, online edition, version (Los Angeles: J. Paul Getty Trust, 2008) Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik +MARC data challenges The Challenges (continued): n reconciling metadata organization systems n choice of unanalogous processes during metadata standards creation n imprecise definitions or alternate naming choices that inhibit element to element mapping n information being lost or combined during mapping n unharmonious hierarchical structures (Margaret St.)

7 Pierre and William P. LaPlant Jr., Issues in Crosswalking Content Metadata Standards, (white paper, National Information Standards Organization (NISO) Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik +The XML family of standard n Schema languages n xslt n Xquery n Xpath n XSL-FO n SVG n Namespaces n Schematron n Xproc n Regular expressions n Xforms - An XML-oriented replacement for the forms used on the Web on commercial sites and elsewhere. David Birnbaum, 2012.)

8 What is XML and why should humanists care? An even gentler introduction to XML Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik +XML family of standards Introduction to XML n Ordered hierarchy of content objects (OHCO); three views of XML (containers, tree, serialization) n Well-formedness: root element, matching tags, no overlapping elements, quoted attribute values, proper name characters, no reserved characters (ampersand, angle brackets) n Document analysis (hierarchy; chunks and in-line elements) n Elements and attributes n Descriptive vs presentational markup n Validity (vs well-formedness) Birnbaum, D.

9 & Ilik, V. The Role of xslt in Digital Libraries, Editions, and Cultural Exhibits TPDL 2013, Valletta, Malta - Sept. 22nd 2013 Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik +XML family of standards Ordered hierarchy n XML is a hierarchical tree n Tags are not toggle switches that turn properties on and off. n When you re writing XML, insert the whole element, with both the start and end tags David Birnbaum, 2012. What is XML and why should humanists care? An even gentler introduction to XML Hosted by ALCTS, Association for Library Collections and Technical Services +XML family of standards Rules of well-formedness.

10 - every start tag must have a closing tag <tag> </tag> Or <tag/> - Tags must nest cleanly <creator> <name>Birnbaum, David</ name> </creator> - Attribute values must appear within quotation marks <page n= 12 /> - Tags are case sensitive and they must match <creator> </creator> Or <CREATOR> </CREATOR> - Single root element - The left angle bracket and ampersand are special characters Hosted by ALCTS, Association for Library Collections and Technical Services Violeta Ilik Birnbaum, D. & Ilik, V. The Role of xslt in Digital Libraries, Editions, and Cultural Exhibits TPDL 2013, Valletta, Malta - Sept.