QuiLogic

Technologies Inc.

In Memory SQL / XML Database Technology for

Universal Data Management

>> SQL/XML-IMDB <<

 

HomeDownloadOrderSupportAboutUs                

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