Deprecated: add_custom_background is deprecated since version 3.4.0! Use add_theme_support( 'custom-background', $args ) instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5084

Deprecated: add_custom_image_header is deprecated since version 3.4.0! Use add_theme_support( 'custom-header', $args ) instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5084

Notice: wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. This notice was triggered by the jquery handle. Please see Debugging in WordPress for more information. (This message was added in version 3.3.0.) in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5536

Notice: wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. This notice was triggered by the smoothscroll handle. Please see Debugging in WordPress for more information. (This message was added in version 3.3.0.) in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5536

Deprecated: The called constructor method for WP_Widget in Yoko_SocialLinks_Widget is deprecated since version 4.3.0! Use __construct() instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5177
Intro to Databases: Querying XML, XPath | Megan Taylor

Megan Taylor

front-end dev, volunteacher, news & data junkie, bibliophile, Flyers fan, sci-fi geek and kitteh servant

Intro to Databases: Querying XML, XPath

Querying XML
Not nearly as mature as querying relational databases
-newer
-no underlying algebra

Sequence of Development
1. XPath – path expressions and conditions
2. XSLT – XPath + transformations, output formatting
3. XQuery – XPath + full-featured query language

XPath
Think of XML as a tree

Bookstore
-Books
-@ISBN
-@Price
-@Title
-@Authors
-First Name
-Last Name
-Magazines

Basic Constructs
/ designates root element, also used as a separator
x designates the name of an element
* matches anything
@ attribute name
// designates any descendent of current element
[] conditions or matching nth subelement of current element

Built-in functions (lots of them)
contains(s1, s2) will return true if the first string contains the second string
name()

Navigation “axes” (13 of them)
parent::
following-sibling::
descendant::
self::

More details
XPath queries operate on and return sequence of elements
– XML doc
– XML stream
sometimes result can be expressed as XML, not always

November 16, 2011 | Comments Off on Intro to Databases: Querying XML, XPath | Categories: Posts | Permalink

Comments are closed.


Notice: Undefined index: host in /home/pqmz7qzy9yt5/public_html/wp-content/plugins/jetpack/modules/stats.php on line 209