Posted   by 

Xml Query Tool

This online tool allows you to test your XPath expressions / queries against an XML string or file. You can easily debug your XPath expressions!

This utility also includes an XPath generator that helps you easily create XPath expressions. Double click (In 'Your XML string' editor) the element, attribute, or text you want to generate the associated xpath expression.

You can see example XPath expression to help you to find your Xpath query.

The XML to SQL Converter was created for online transform XML (Extensible Markup Language) data into SQL (Structured Query Language) queries to insert in the database. This awesome tool supports custom table name and several MySQL commands to insert. It's very simple and easy way to transform and share XML to SQL queries. Traditional xpath engines create DOM from XML and evaluate xpath on that DOM. Creating DOM for 50MB xml files requires lot of memory. You can try XMLDog. It evaluates xpath on large xml files without creating DOM, thus requires little memory. It comes with a command line tool xmldog.bat. It is implemented in java. So you can use it on windows.

You can see the user guide to help you to use this XPath tester.


User guide

In order to test your XPath expression, you must:

  • Fill 'Your XPath expression' editor
  • Fill 'Your XML string' editor
The result will be automatically generated and available in the 'Results' editor.

To fill 'Your XML string' editor, you can:

  • Copy and paste your XML string
  • Drag and drop your XML file
  • Click on 'Browse XML file' button in order to load your XML file
  • Directly type your XML string in the editor

To generate an XPath expression:
Just double click on the element, attribute, or text you want to generate the Xpath expression.

This tool does not support the XPath functions (number(), string(), string-length() ...).


About XPath

XML Path Language (XPath) is a query language for selecting nodes from a XML data. Xpath can be used to query XML databases.

It is based on a tree representation of the XML, it allows to navigate through elements in an XML document.

XPath uses path expressions to select nodes in an XML document.

XPath expressions can be used in many programming languages (JavaScript, Java, PHP, Python, C, ...).

XPath is a W3C recommendation.

XPath Examples

Select the tools element/tools
Select all tool elements which are direct children of the tools element/tools/tool
Select all tool elements without taking into account the tree//tool
Select the second tool element//tool[position() = 2]
Select the value attribute of all tool elements without taking into account the tree//tool/@value
Select the tool element which has the id attribute value of 1//tool[@id=1]

This tool uses document.evaluate function to test your XPath query.


HomeGuideTools ListingNewsBackgroundSearchAbout Us

As of January, 2012, this site is no longer being updated, due to work and health issues

SearchTools.com: Related Topics

XML Searching Resources

For background information, see the XML and Search page. This page provides annotated links to XML Search, Query Languages, Standards and Document Structure Registries information.

XML Text Search Engines

  • Amberfish - now supports both XML full text search with Boolean and phrase matching, as well as arbitrarily structured queries with hierarchical results.
  • IXIASOFT TEXTML database -XML database with real-time index synchronization, grouping of elements and attributes in indexes. Search features include Boolean, proximity and frequency operators. Results sorting, site is not clear on their relevance algorithm.
  • Infonyte Query - Implements the XQL Specification for both structured and free-text search.
  • XML Query Engine - JavaBean component for full-text indexing and searching of XML documents. Version 1.0 shipped Spring 2001, supports XQuery and XQL. See also local XML Query Engine info page
  • Tamino - indexes based on XML tags for full-text or structured searching, supports XPath query features, from Software AG.
  • Emily Solutions Framework (MLE) includes a search engine for XML, flat files and relational databases.
  • Ultraseek version 3 and later support searching XML files as full text, and setting up multiple sets of fields for field-specific searching, version 4 adds indexing of attributes.
  • SIM (The Structured Information Manager) uses XML and full-text indexing to provide a powerful combination of database searching and text retrieval.
  • GoXML Search Engine - does XML-specific search by providing a second step for the query with a popup menu of 'context': the markup tag for the text. There does not seem to be a way to perform free-text searching as well, but it does seem to index by using a robot and spidering external sites.

XML Structured Query Engines

  • X-Hive - XML database implementing XQuery standard.
  • XDisect - indexes and retrieves arbitrary XML data structures and supports flexible queries. Supports XML standards.
  • fxgrep - parses an XML document for complex queries and finds all matches. Distributed as source code.
  • GMD-IPSI XQL Engine - Java-based persistent storage of XML documents in DOM format, XQL queries into the data store. Free for noncommercial use: see Globit Infonyte for the commercial version.
  • XSet is an XML database and high performance search engine library with a very simple tag-oriented query language, expressed in XML itself.
  • UC Berkeley's Cheshire system indexes and searches structured data including XML, SGML and MARC records, as well as full-text data files.
  • Xtenint information routing and selection agents perform real-time filtering of data streams using various predefined rules.
  • Lore - a database management system for XML using semi-structured data,with a special query language called Lorel. This is a research project in the Stanford University computer science department.
  • sgrep search tool provides grep searching for structured documents, including XML. This is a command-line program that lets you limit searches to contents of specified XML tags, such as 'subject' or 'evaluation'. As of January, 2000, it has been updated to version 1.9 and now supports searching in hierarchies.

XML Query Languages

See also 'How Text Search Relates to XML Query Languages'

  • W3C XML Query
    Main page for the World Wide Web Consortium XML Query Working Group.
    • XML Query Requirements (Current Working Document) New release on February 16, 2001
      This URL points to the most current version of the XML Query Working Group requirements document for how the standard XML query language should work, with general goals, usage scenarios, terminology, data model information, functionality, and how the language should fit with the other XML standards.
    • XQuery: A Query Language for XML New release on February 15, 2001
      Implementation of a query language based on the requirements.
  • XML Query Languages: Experiences and ExemplarsSummer, 1999
    Examines four existing XML query languages in order to define the requirements for such a language. Tends to be more SQL-oriented than search-engine oriented.
  • QL '98: the Quest for an XML Query StandardLisa Rein, XML.com, March 2, 1999
    Covers the discussion at the W3C Query Language workshop in December 1998. There were more participants than expected, from XML/SGML implementors through database companies, librarians and researchers. Discussion there was about database-style querying providing selection (search), extraction, reduction, restructuring and combination of XML text.. Some participants want to make a query language like SQL or OQL, others see a relationship to research in 'semi-structured' data retrieval, while others hope to use XSL to perform these tasks. There was controversy over what the results should look like, and about if they should come in XML only or in other formats.
  • QL '98 Position PapersW3C
    66 papers from the participants in the W3C Query Language workshop in December 1998.
  • W3C XML Query Language mailing list (for the general public), with open archives. To subscribe, send a message to www-ql-request@w3c.org and put the word subscribe in the body of the message (remove your signature).

XQL

  • XQL Proposal submitted to the W3C, proposes a query language for 'addressing and filtering the elements and text of XML documents' as an extension of the XSL pattern syntax.
  • XQL FAQ - links and background information for this proposal, list of the applications that have implemented it so far.
  • XQL Tutorial - simple explanation with examples

XML-QL

Xml Query Tool

Xml query tool windows
  • XML-QL, Query Language for XML Proposal submitted to W3C. Proposes a query language approaching an XML file much like searching a database with SQL, rather than a free-text document. The focus of this proposal is EDI (Electronic Data Interchange, business-to-business purchasing) as opposed to a library or information retrieval approach. It provides examples using specific data and element patterns and constructing new results listings

XML Standards and Overviews

  • Extensible Markup Language (XML) W3C standard information

  • Robin Cover's SGML/XML Web page - a comprehensive overview with lots of pertinent information -- a great resource!

  • OASIS Web Site: Home Page Organization for the Advancement of Structured Information Standards - a vendor-neutral consortium supporting XML, SGML and HTML.

  • XML.com - includes many articles, the XML specification annotated by Tim Bray, and a way to test for well-formed files.

  • XMLInfo.com - XML news, introductory articles and reviews by the well-regarded James Tauber.

  • Frequently Asked Questions about XML - useful FAQ.

  • XML and Databases Extremely thoughtful discussion of how XML relates to databases and vice versa by Ronald Bourret.

  • XML and the Second-Generation WebScientific American, May 1999 by Jon Bosak and Tim Bray - describes features of XML and some possible future search functionality.

  • Web / XML - webreference.com - Nice site with tutorials, products links and other references.

  • John Cowan's XML Index- Includes info on RDF, XCond, IBTWSHD (a HyperText DTD), XCatalog and so on.

  • Search the XML-Dev Mailing List Archives - the mailing list is where developers work through some of the knotty issues of namespaces, fragments and other bleeding-edge technology. If you have an implementation question, it's probably been discussed with all possible implications on this list, so check the archives first!

XML Registries: Standardizing Document Structures

Groups from genealogists to real-estate brokerages want to share data without having to use complex file format converters, and they are banding together to create open XML DTDs and other structures. Today, the only standard way of structuring XML documents is with DTDs (document type descriptors). But there are several proposals for richer and more complex systems, known as schema. In any case, shared structures will improve searching as all data will be in the same format and will not require special field names.

  • XSLT: XML Transformations - A standard system for converting XML documents with one set of tags into documents with another set of tags.
  • OASIS Registry and Repository Technical Committee - a group working on standards for XML DTD and Schema registries.
  • XMLSchema.com - tools to validate XML Schema (more complex than DTDs) and convert them to another dialect such as DTD.
  • Schema Repositories: What's at Stake?XML.com, January 26, 2000 by Liora Alschuler
    Describes the existing schema registries and the issues involved in controlling schema, especially for e-commerce.

Other Listings

  • XML Query Languages, Databases and Search (Northern Light Special Edition, XML)
Page Updated 2002-12-18
HomeGuide Tools ListingNewsBackgroundSearchContact
Xml Query Tool

Xml Query Tool Online

Avi Rappoport of Search Tools Consulting can help you evaluate your search engine, whether it's on a site, portal, intranet, or Enterprise. Please contact SearchTools for more information.

Xml Query Tools

This information copyright © 2010 Avi Rappoport, Search Tools Consulting. Some Rights Reserved, under the Creative Commons Attribution-Share Alike 3.0 United States License. Please attribute copied content to the page's full URL. Permissions beyond the scope of this license are available upon request.