QuiLogic Technologies Inc.		In Memory SQL / XML Database Technology for Universal Data Management >> SQL/XML-IMDB <<
Home |  Download |  Order |  Support |  AboutUs
Features	In an attempt to ease the management and access of relational data in xml based environments, QuilLogic has developed an extension to the XQuery draft specification which allows the use of SQL statements within any part of the XQuery statements where an expression is allowed too. Ø Transfer data between SQL and XML tables/files with ease. Ø Use correlated values between XQuery and the SQL sub-queries. FOR/LET … IN ( SQL SELECT query ) … … WHERE $X/… = ( SQL SELECT query ) … WHERE $X/… IN ( SQL SELECT query ) … WHERE $X/… = All/Any/Some ( SQL SELECT query ) … WHERE EXISTS ( SQL SELECT query ) … RETURN { (SQL INSERT/UPDATE/DELETE statement ) }, … When using a SQL statement within the RETURN part of XQuery it is possible to manipulate the content of relational tables by using SQL Insert/Update/Delete statements. Applying a SQL SELECT statement has no effect (although it is possible). Columns in the WHERE clause section of the SQL query might be compared against any bound variable from the earlier part of the XQuery query, making it effectively possible to use correlated values between XQuery and the SQL sub-queries. Example: … (SELECT price FROM TR WHERE TR.price = $Y/[path]/number() AND … ) …		NEW XML IFilter Crawl, index and search arbitrary structured xml files based on content. Extends functionality of: SharePoint Portal Server SharePoint Team Service MS Indexing Service MS Site Server Other Indexing Products Read more…
Architecture
Application
Usage
SQL Database
XML Database
XML Update
SQL <-> XML
Persistence
SOAP
NET
C/C++
VB(A)
Delphi
ODBC/OLE-DB
© QuiLogic Inc. 2000 - 2009