[seek-dev] SQL db candidates for data query

[Serguei Krivov]

Hi All,
I did not attend the last meeting and I do not know much about the
requirements for ql. Yet , before opting for sql db it is good to know
if sql support (not XQuery and friends) is really the main  requirement.
In fact, should we abandon the world of well established sql rdbms (e.g
postgresql, oracle) and switch to new java  databases, then we shall
have a wide vistas of options that include native xml databases and a
lot of other things. Ferdinando has  installed one here at
http://ecoinformatics.uvm.edu:8080/exist/index.xml
There are a lot of others as well, see:
http://www.garshol.priv.no/download/xmltools/cat_ix.html#SC_XMLDBMS

In fact I wonder if there is a DB specifically designed for DL( or may
be we can write one ;-)  ) But surely, if the target  query language is
not  sql, then why do not to consider non sql dbs?
Ciao,
serguei


 
 

-----Original Message-----
From: seek-dev-admin at ecoinformatics.org
[mailto:seek-dev-admin at ecoinformatics.org] On Behalf Of Jing Tao
Sent: Wednesday, June 16, 2004 6:46 PM
To: seek-dev at ecoinformatics.org
Subject: [seek-dev] SQL db candidates for data query

Hi, everyone:

I am eveluating the sql db candidates for data query. It turns out that 
the following ones are pretty good: hsqldb and Mckoi.

Here is the features both of them share:
1)Open source
2)Write in pure java and everything is in jar files.
3)Have server/client and stand-alone mode.
4)Have JDBC implementation.
5)Support Linux, Windows.

Moreover, hsqldb has a good feature that support CSV (Comma Separated 
Value) or other delimited text file as the source of their data. So user

don't need use sql command to insert data into db and only tell the text

file location and the sperator. It even can ommit the first line when it

is a column name. It pretty matches eml semantic.
Except pipe(|), comma(,) and period(.), HSQLDB also recognises the 
following special indicators for separators:
\semi - semicolon
\quote - quote
\space - space character
\apos - apostrophe
\n - newline - Used as an end anchor (like $ in regular expressions)
\r - carriage return
\t - tab
\\ - backslash
\u#### - a Unicode character specified in hexadecimal

This feature is every good for us to load data into db. So I prefer to 
use hsqldb. 

Any comments, suggestions are apprecaited.

Jing 

-- 
Jing Tao
National Center for Ecological
Analysis and Synthesis (NCEAS)
735 State St. Suite 204
Santa Barbara, CA 93101

_______________________________________________
seek-dev mailing list
seek-dev at ecoinformatics.org
http://www.ecoinformatics.org/mailman/listinfo/seek-dev