From Wikibooks, the open-content textbooks collection

Contents 1 XQuery Examples Collection 1.1 Current Status 1.2 New and Revised Articles 1.3 About this Project 1.4 Introduction 2 Example Scripts 2.1 Beginning Examples 2.2 Intermediate Examples 2.3 Search 2.4 Browsing 2.5 Reporting 2.5.1 Creating Custom Views 2.5.2 Paginated Reports 2.6 Transforming XML Documents 2.7 Notification 2.8 URL Rewriting 2.9 XQuery Updates 2.10 Graphs 2.11 XML Differencing 2.12 Synchronization and Replication 2.13 XQuery and other languages 2.14 Wikipedia interaction 2.15 Wikibook applications 2.16 Page Scraping 2.17 Mapping 2.18 Timelines 2.19 The Semantic Web 2.20 Interaction 2.21 Session Management 2.22 Triggers 2.23 Development Tools 2.24 Validation 2.25 Visualization 2.26 Puzzles, Maths and Games 2.27 Case Studies 2.28 eXist db specific Functions 2.28.1 Modules and Functions 3 Appendixes 3.1 Systems that Support XQuery 3.2 Live Applications 3.3 Crib Sheets 3.4 Debugging XQuery 4 Other sources 4.1 Function Libraries 4.2 Discussion Groups 5 Indexes

[edit] XQuery Examples Collection

Welcome to the XQuery Examples Collection Wikibook! XQuery is a World Wide Web Consortium recommendation for selecting data from documents and databases.

[edit] Current Status

A new release of eXist (1.4) is currently installed and under test. Please note any problems with these examples in the discussion

Recent Changes

[edit] New and Revised Articles

• World Temperature records
• Digest Authentication
• Pachube feed
• Lucene_Search
• Lorum Ipsum text
• Navigating Collections
• Synchronizing Remote Collections

[edit] About this Project

This is a collaborative project and we encourage everyone who is using XQuery to contribute their XQuery examples. All example programs must conform to the creative-commons-2.5 share-alike with attribution license agreement [1].

Execution of examples use an eXist demo server.

1. Instructors: please sign our Guest Registry if you are using this book for learning or teaching XQuery
2. Contributors: please see our Naming Conventions to ensure your examples are consistent with the textbook
3. Learners: If you are looking for a specific example program, please feel free to use the Examples Wanted section if you are looking for specific example programs

[edit] Introduction

1. Background - A brief history and motivation for the XQuery standard.
2. Benefits - Why use XQuery?
3. Installing and Testing - How to install an XQuery server on your .
4. Naming Conventions - Naming standards used throughout this book.

[edit] Example Scripts

[edit] Beginning Examples

Examples that do not assume knowledge of functions and modules.

1. HelloWorld - A simple test to see if XQuery is installed correctly.
2. FLWOR Expression - A basic example of how XQuery FLWOR statements work.
3. Sequences - Working with sequences is central to XQuery.
4. Regular Expressions - Regular expressions make it easy to parse text.
5. Searching multiple collections - How to search multiple collections in a database.
6. Getting URL Parameters - How to get parameters from the URL.
7. Getting POST Data - How to get XML data posted to an XQuery.
8. Checking for Required Parameters - How to check for a required parameter using if/then/else.
9. Displaying Lists - How to take a list of values in an XML structure and return a comma separated list.
10. Extracting data from XHTML files - How to use the doc() function to get data from XHTML pages.
11. Displaying data in HTML Tables - How to display XML data in an HTML table.
12. Limiting Result Sets - How to limit the number or records returned in an XQuery.
13. Filtering Words - How to test to see if a word is on a list.
14. Saving and Updating Data - How to have a single XQuery that saves new records or updates existing records.
15. Quantified Expressions - Testing all the items in a sequence.

[edit] Intermediate Examples

Assumes knowledge of functions and modules.

1. Using XQuery Functions - How to read XQuery function documents and user XQuery functions
2. Creating XQuery Functions - How to create your own local XQuery functions
3. Returning the Longest String - A function to find the longest string from a list of strings
4. Net Working Days - How to calculate the number of working days between two dates
5. Tag Cloud - Counting and viewing the number of keywords
6. String Analysis - Regular expression string analysis
7. Manipulating URIs - How to get and manage URIs
8. Parsing Query Strings - Parsing query strings using alternate delimiters.
9. Splitting Files - Splitting a large XML files into many smaller files.
10. Filling Portlets - How to fill regions of a web page with XQuery
11. Filtering Nodes - How to use the identity transform to filter out nodes
12. Higher Order Functions - Passing functions as arguments to functions
13. Timing Fibonacci algorithms - A couple of Fibonacci algorithms and timing display
14. Using Intermediate Documents - Analysis of a MusicXML file

[edit] Search

1. Introduction to XML Search - An overview of XML search terminology
2. Basic Search - A simple search page
3. Searching,Paging and Sorting - Searching and Viewing search results
4. Keyword Search - full text search with Google-style results
5. Employee Search - an Ajax example
6. Incremental Search of the Chemical Elements - with Ajax
7. Lucene Search - using eXist's Lucene-based fulltext search
8. Incremental Searching

[edit] Browsing

1. Navigating Collections - an example of an AJAX browser

[edit] Reporting

[edit] Creating Custom Views

These examples use reflection on the structure of an XML document using name() to implement generic functions for XML transformations.

1. HTML Table View - A generic HTML table representation
2. Tree View - A generic HTML tree representation
3. Grouping Items - how to group items in a report

[edit] Paginated Reports

Unlike HTML pages, paginated reports use the concept of text flows between pages. These examples show you how to convert raw XML into high-quality PDF files suitable for printing. The examples use a markup standard called XSLFO for "Formatted Objects"

1. Generating PDF from XSL-FO files - Converting XML-FO to PDF files
2. XSL-FO Tables - Generating XSL-FO tables from XML files

[edit] Transforming XML Documents

1. Typeswitch Tranformations Using the typeswitch function to transform an XML document {stage short|25%|Febuary 7th, 2010}}

[edit] Notification

When an event gets trigged there are several ways to notify users. Sending an e-mail message or creating an entry in an atom feed are to examples of notification services.

1. Sending E-mail - How to send an e-mail message from within an XQuery

[edit] URL Rewriting

1. URL Rewriting Basics How to make your URLs look nice

[edit] XQuery Updates

1. Updates and Namespaces - How updates can change serialization

[edit] Graphs

1. Topological Sort

[edit] XML Differencing

1. Compare two XML files - using the eXist compare() function to test to see if two XML files are exactly the same
2. XML Differences - displaying the difference between two XML files
3. Compare with XQuery - Using XQuery to Compare Lists

[edit] Synchronization and Replication

1. Time Comparison with XQuery - Using XQuery to Compare Dated Items
2. Synchronizing Remote Collections - Using lastModified time stamps to see what items have changed

[edit] XQuery and other languages

1. XQuery from SQL - Using XQuery to access a classic Relational database - Employee/Department/Salary
2. XML to SQL
3. XQuery and XSLT
4. XQuery and Python
5. Excel and XML
6. XQuery and XML Schema - Generating an XML instance document
7. XHTML + Voice

[edit] Wikipedia interaction

1. Wikipedia Page scraping
2. Wikipedia Lookup
3. Wikipedia Events RSS
4. Wiki weapons page

[edit] Wikibook applications

1. Wikibook index page
2. Wikibook list of code links

[edit] Page Scraping

Page scraping is the process of extracting well-formed XML data from any HTML web page. When creating mashup applications this is also known as the harvesting process.

1. Overview of Page Scraping Techniques
2. Page scraping and Yahoo Weather
3. UK shipping forecast
4. BBC Weather Forecast
5. Page scraping and Mashup
6. Simple RSS reader
7. Multiple page scraping and Voting behaviour
8. Link gathering
9. REST interface definition
10. Caching and indexes

[edit] Mapping

1. Google Geocoding
2. /String Analysis#Location_Mapping/ Mapping Car Registrations
3. Flickr GoogleEarth
4. Nationalgrid and Google Maps
5. SMS tracker

[edit] Timelines

1. Creating a Timeline - Creating a simple timeline view of events
2. Timelines of Resource - Using creation and modification dates to create timelines

[edit] The Semantic Web

1. DBpedia with SPARQL - Football teams
2. DBpedia with SPARQL and Simile Timeline - Album Chronology Creating a timeline of album releases using data from Wikipedia
3. DBpedia with SPARQL - Stadium locations
4. The Emp-Dept case study
   1. XML to RDF
   2. SPARQL Tutorial
   3. SPARQL interface
5. Graphing Triples
6. SPARQLing Country Calling Codes
7. Southampton Pubs
8. Alphabet Poster
9. Simile Exhibit Browser visualizations using the Simile JavaScript libraries
10. Latent Semantic Indexing Finding the semantic distance between documents

[edit] Interaction

1. Adder - Creating a web service that adds two numbers.
2. Simple XForms Examples
3. XMP data
4. Slideshow
5. Pachube feed

[edit] Session Management

1. Basic Session Management - the basics of session management including getting a setting session variables

[edit] Triggers

1. Using Triggers to Log Events - how to set up a trigger to log store, update and remove events on a collection

[edit] Development Tools

1. Sitemap for Content Management System XQuery functions can easily perform many common web site content management functions
2. Formatting Numbers - using picture formats to format numbers
3. Uptime monitor
4. XQuery IDE
5. Image Library - using an XQuery to preview your images
6. XSD to XML Sample - XQuery function to generate a sample XML instance from an XML Schema file (.xsd)
7. Lorum Ipsum text

[edit] Validation

1. Validating a document - Validate a document with an XML Schema
2. Validation using a Catalog - Using a Catalog file to validate documents
3. Validating a hierarchy -

[edit] Visualization

1. Graph Visualization
2. Dataflow diagrams
3. Sequence Diagrams
4. Example Sequencer - Step-by-step tutorial
5. Google Charts
6. GoogleChart example - A demonstration of how to create a chart using the Google Charts API
7. Histogram of File Sizes - An XQuery report that generates a histogram of file sizes

[edit] Puzzles, Maths and Games

1. Fizzbuzz
2. Project Euler
3. Sudoku

[edit] Case Studies

1. World Temperature records - conversion of text data formats to XML, indexing and data presentation

[edit] eXist db specific Functions

[edit] Modules and Functions

1. List Modules
2. Modules and Functions
3. Dynamic Module Loading

[edit] Appendixes

[edit] Systems that Support XQuery

Using native and hybrid XML databases that implement XQuery

1. BaseX - Native open source XML Database with visual frontend
2. DataDirect XQuery - Java XQuery engine supporting relational, EDI, flat files and XML input/output
3. eXist - Open source native XML database
4. DB2 pureXML - DB2 9.1 includes the pureXML feature
5. MarkLogic Server - MarkLogic Server commercial XML Content Server
6. Microsoft SQL Server 2005 -
7. NetKernel - NetKernel
8. Oracle Berkeley DB XML - Open source embedded storage management
9. Oracle XML DB - Oracle Server 11g includes the XML DB (XDB) feature
10. Sedna - Open source native XML Database
11. Stylus Studio - XQuery mapping/editing/debugging, ships with Saxon (and SA) and DataDirect XQuery
12. xDB (X-Hive/DB) - EMC Documentum xDB commercial native XML database
13. XQilla - Open source XQuery library and command line utility
14. Zorba - Open source XQuery engine C++ implementation with C, Java, Php, Python, Ruby library bindings and command line utility

[edit] Live Applications

1. UWE StudentsOnline

[edit] Crib Sheets

• eXist Crib sheet
• XPath examples

[edit] Debugging XQuery

1. Gotchas - some pitfalls
2. Ahhas - some ahha moments

[edit] Other sources

[edit] Function Libraries

1. FunctX XQuery Function Library by Priscilla Walmsley

[edit] Discussion Groups

1. XQuery General

[edit] Indexes

• Page index - generated
• Index of XQuery features - edited
• Index of Application Areas - edited
• Index of eXist modules and features - edited

Key to symbols:

Wikibook Development Stages
Sparse text	Developing text	Maturing text	Developed text	Comprehensive text:

indicates an XQuery/Best practice