QuiLogic

Technologies Inc.

In Memory SQL / XML Database Technology for

Universal Data Management

>> SQL/XML-IMDB <<

 

Home | Download | Order | Support | AboutUs

Features

SQL Language

 

SQL/XML-IMDB supports a significant subset of the SQL92 definition of the SQL database language, including support of the following:

 

  • SELECT, UPDATE, INSERT, DELETE
  • CREATE TABLE...[PRIMARY KEY...]
  • DROP [TABLE]
  • SELECT qualifiers: DISTINCT, TOP n
  • SELECT clauses FROM, WHERE, GROUP BY, HAVING, ORDER BY
  • WHERE expressions: AND, OR, NOT, LIKE, BETWEEN, + - * /, IS [NOT]
  • NULL, <, >, =, < >, <=, >=, Constants, Parameters, Column Names
  • SELECT list expressions: MAX, MIN, AVG, SUM, COUNT, +, -, *, /,
  • Constants, Parameters, Column Names
  • Value list qualifiers: ANY, ALL, SOME, IN
  • UPDATE expressions: +, -, *, /, Constants, Parameters, Column Names
  • INSERT values expressions: Constants, Parameters
  • INSERT ... SELECT
  • Sub-queries within SELECT statements

 

 

Supported Data Types

 

Numeric

4 bytes 2,147,483,648 to 2,147,483,647

INT, INTEGER, SHORT, LONG, SMALLINT

Decimal

8 bytes (See DOUBLE)

REAL, FLOAT, DOUBLE, SINGLE, CURRENCY

 

Bool

1 bit

BOOL, BOOLEAN, YESNO

 

Counter

4 bytes Auto-Increment value 1 to 2,147,483,647

COUNTER

 

Character

1 byte per character (2 bytes for UNICODE)

Zero to a maximum of 256 MB/row

CHAR(n), VARCHAR(n), CHARACTER(n), TEXT

 

Date/Time

8 bytes 0 to year 20.000,

Time 00:00:00.000.000.0 to 24:59:59.999.999.999

100 nano-seconds resolution

DATE, TIME, DATETIME

 

Binary

Zero to a maximum of 256 MB/row

BLOB, LONGBINARY

 

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

XML

XML Update

SQL <-> XML

Persistence

SOAP

NET

C/C++

VB(A)

Delphi

ODBC/OLE-DB

 

 

 

 

 

 

 

QuiLogic Inc. 2000 - 2009