[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: XML Bird eye view- Now Implemented and Verified

  • From: mike@a...
  • To: XML-dev@l...
  • Date: Thu, 04 Sep 2008 22:56:39 +0000

RE:  XML Bird eye view- Now Implemented and Verified
For those of you that looked at the below video on contrasting relational calculus concepts of DB theory with more procedural notion of trees leading to the notion of query algebra for relational DB with automatic theory for tree shaped data. My company?s just released ANSI SQL transparent XML hierarchical processor demo I mentioned in my previous email last week implements just this and verifies its possible assumptions. This live online demo be accessed with instructions below from your browser.
 

http://www.adatinc.com/nonlinearhierprocessing/sqlfxlivedemo.html



 

-----Original Message-----
From: sikandar sikandar [mailto:sikandar.786@h...]
Sent: Wednesday, September 3, 2008 03:02 AM
To: xml-dev@l...
Subject: XML Bird eye view

 A short bird's eye view at
http://expertstech.blogspot.com/2008/09/xml.html 


The above referenced ANSI SQL transparent XML hierarchical processor demo?s advanced database hierarchical processing technology operates by defining (data modeling) full multi-leg hierarchical structures in ANSI SQL-92, using a series of standard left outer joins. This enables standard ANSI SQL processors to automatically perform full multi-leg database hierarchical processing on the SQL modeled hierarchical structures when queried. Logical Relational and Physical XML data structures can be defined (modeled) and stored in SQL views. These views can be dynamically, heterogeneously, and hierarchically joined using a single left join operation and this virtual unified hierarchical (left outer join) structure will be processed hierarchically in standard SQL extended seamlessly to support the input and output of XML documuments.

The SQL database hierarchical processing demo software is automatically hierarchical structure-aware at all times. It knows the dynamic hierarchical modeling that has taken place and will output the XML result hierarchically formatted correctly. Only the data SELECTed for output is output in its proper node/XML element. The unselected nodes have been excluded, enabling natural node promotion and node collection to take place. (This has naturally occurring in the SQL rowset). 

The WHERE clause database data filtering is naturally applied hierarchically so the result is meaningfully. This happens when searching or filtering conditions are based across different path types. This requires Lowest Common Ancestor (LCA) processing that is occurring naturally in SQL. This has usually required complex tree traversing in physical hierarchical processors, but is nicely simulated naturally by SQL?s Cartesian product effect when modeling hierarchical structures. This complex level of hierarchical processing and automatic navigation can not be reasonably performed by user navigation or user specified LCA logic. With SQL?s nonprocedural and navigationless specification, non technical users can perform complex hierarchical XML processing not previously possible. Check out the demo above, it has a complete set of queries covering all of these capabilities and more. These queries can be modified or you can try your own.

This demo is for database hierarchical use with well behaved regular structures that are unambiguous. That means there can be no duplicate named node types as there can be with markup. Markup and database use requires different processing. This demo works well for SQL database uses. But let me say this also. Hierarchical XML markup also requires LCA logic, but instead of being fixed it is variable. That is LCA node usage can dynamically change to accommodate a fuzzy operation caused by the XPath ?//?search operation. If a particular LCA node occurrence is empty, the next closest LCA node with the same name will be use. This makes sense for keyword searches in markup text, but for database use using WHERE clause filtering this can not happen or the result is just plain wrong! These processing restrictions for database hierarchical processing allow hierarchical XML to be processed truly nonprocedurally with no user navigation required.

Any questions or comments, please let me know.

          /Mike

Michael M David
Advanced Data Access Technologies, Inc.
http://www.adatinc.com/

 





[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]


PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.