240 likes | 433 Views
AIRS XML Data Transfer Standards. Sharing Resource Data with Ease in a Multiple Vendor I & R Database World. Carolyn S. Keyser NY. Workshop Objectives. What are the AIRS XML Data Transfer Standards? What are the goals of these standards? How will I & R benefit from these standards?.
E N D
AIRS XML Data Transfer Standards Sharing Resource Data with Ease in a Multiple Vendor I & R Database World Carolyn S. Keyser NY
Workshop Objectives • What are the AIRS XML Data Transfer Standards? • What are the goals of these standards? • How will I & R benefit from these standards?
Problem Statement • Multiple vendor solutions with disparate data formats • Refer • IRis • Tapestry • Service Point • Resource House • Custom Solutions • Other I & R Applications • Lack of interoperability among database applications Result: Current system discourages data sharing.
ServicePoint Refer IRis The Current State of I & R Systems Disparate Applications Lacking Interoperability Discourages Data Exchange and Sharing
Does This Problem Have a Solution? YES! The AIRS XML Data Transfer Standards
What Is XML? • XML stands for EXtensible Markup Language • Extensible: No pre-defined fixed format • Able to design your own markup language tags • In contrast, HTML is an example that does have a pre-defined format • Markup Language: Method of providing structure to a document • HTML is designed to display data • XML is designed to describe and structure data; provide information about the data • Human-readable, plain text file Easy to understand • Platform independent (hardware and software independent) • Enables sharing of data among incompatible systems • Has lead to the wide-use of XML as a tool for facilitating data exchange
An Example XML Document <?xml version=“1.0” encoding=“UTF-8”?> <Agency> <Name>The Career Place</Name> <Address>31 Main St</Address> <City>Rochester</City> <State>NY</State> <Zip>14620</Zip> <Country>USA</Country> <Phone>(585) 555-5555</Phone> <Description>Provides training in job searching, résumé preparation, and interview skills.</Description> <Hours>M-F 9:00am – 5:00pm.</Hours> </Agency>
<?xml version=“1.0”?> Refer XML File IRis Export Refer ? Do these two XML files have the same data format and structure? <?xml version=“1.0”?> IRis XML File Export How Does XML Facilitate Interoperability?
What happens when a standard format for XML export files does not exist? • If each vendor application formats the data in an XML export file differently, then an application would have to include programming logic that accommodates each unique format for data exchange to be possible among the disparate vendor applications. <?xml version=“1.0”?> <?xml version=“1.0”?> Refer XML File IRis XML File No significant reduction in the complexities of data sharing. Dissimilar Data Formats
The Necessity of Standards • Question: How can we ensure that the resulting XML files from each vendor application share the same format? • Answer:Adopt a universal formatting standard for sharing data, which each vendor implements. • Regardless of the vendor application, an XML export file will have the same data format. • Vendors need only develop programming logic to handle this one standard format. • Question: What tool can we use to specify these standards? • Answer: XML Schema
XML Schema • An XML Schema defines the structure and format of an XML Document. • An XML Schema specifies: • Allowable and/or required elements and attributes. • The ordering of elements (parent-child relationships) • The number of occurrences of an element. • Element and attribute data types. • Default or fixed values for elements or attributes. • For a complete description, see the handout Resources for Additional Information. • An XML Schema is also referred to as XSD (XML Schema Definition). • Systems that have been programmed to recognize the standards specified in the XSD will be able to automatically understand and process information received in this format.
AIRS XML Data Standards Workgroup Mission Statement Summary “The Data Standards Workgroup will develop specific standards for ensuring the quality and consistency of resource databases maintained by information and referral (I&R) services, specifically to facilitate importing, exporting and merging of data….” The AIRS XML Schema specifies these standards. Vendor implementation of this schema will facilitate exchange of data and application interoperability.
AIRS XML Data Standards Workgroup History • 2002: The Michigan Association of United Ways (MAUW) received a grant to formulate standards for facilitating information exchange using XML. • 2003: AIRS Workgroup was formed to review and recommend changes to the Standards created by the MAUW. • 2004: Version 2.0 of the AIRS XSD was approved by the AIRS Board. • 2006-08: AIRS XSD Review Group contracted with data architects from the University of Nebraska Lincoln and reviewed the AIRS XSD, involving I&R vendors at every junction in order to create a more stable structure. In May 2008, the AIRS Board approved of Version 3.0 of the AIRS XSD.
Benefits of XML Standards Adoption • Provides a tool for facilitating data exchange among disparate systems. • Promotes data sharing between I & R’s, as well as information exchange with other human services agencies. • Data sharing eliminates duplication of efforts. • I & R’s can choose applications that best meet the needs of their agency and those they serve, while maintaining the ability to share data with agencies using other applications. Avoids vendor lock in.
Benefits of XML Standards (Continued) • Ability to share data while retaining investments in current infrastructure and systems. Avoid training, labor, software, and hardware costs, as well as user frustration, associated with migrating to new solutions. • Improved quality control, e.g. data quality. • Extensibility – Allows for scalability and flexibility to meet changing needs over time. Changes can be made more cost effectively. • XML Standards allow information to be easily ported to different platforms, such as PDA’s or cell phones. • Format is compatible for use with internet protocols for data exchange between systems.
What’s the Bottom Line? Our communities benefit from improved service.
The Drawback of Standards Adoption An Alternative • Initial cost of implementation for vendors. Choose one application for region-wide or state-wide use. Costs associated with buying, implementing, and learning a new technology. Removes consumer choice. Agencies cannot choose the application that best meets their needs. Eliminates benefits of competition.
Areas Where Data Sharing & Interoperability Enhance I & R • 2-1-1: Regional and state-wide data sharing. • Disasters: Ease of transferring data to another call center, when necessary. Live updates can be immediately distributed to resource databases, regardless of the vendor application. • Community collaboration: HMIS, Continuum of Care (CoC) Systems, Community Information Systems. Objective:Reduction of duplicated efforts. • Ability to aggregate information from heterogeneous sources enables more comprehensive reporting.
Yes! Is This Realistic? Some “Real Life” Examples: • SIF (Schools Interoperability Framework) • Goal: “The goal of SIF is to make it possible for school administrators, teachers and other school personnel to have secure, appropriate access to the most current and accurate data available.” –Quoted from the SIF Web Site: www.sifinfo.org. • CAP (Common Alerting Protocol) • Goal: Improving emergency management information dissemination nationwide • Description: Open, non-proprietary standard data format for exchange of alerts, hazard warnings, and reports • www.incident.com/cap/ & www.oasis-open.org/committees/emergency/ • RecML (Recreation Markup Language) • Goal: The exchange of recreational information among agencies nationwide. • Recreation.gov
And yes,…… There’s even a Meat and Poultry XML (mpXML)www.mpxml.org (Wegmans is one of the founders!)
How You Can Help • Talk to your vendors. Make sure they are aware of your needs. Remind them that our clients deserve the best services possible. Implementation by our vendors shows their continued commitment to improving I & R Services.
For Additional Information • General XML Information: • xml.com • Tutorial: http://www.w3schools.com/xml/default.asp • W3C XML Specification: http://www.w3.org/XML/ • What is XML? From TechSoup http://www.techsoup.org/howto/articlepage.cfm?ArticleID=482 • Standards Efforts in Other Industries and Fields: • xml.gov • oasis-open.org • xml.org