- users-list - monetdb.org

[MonetDB-users] Using MonetDB for financial time series analysis
by Joel Reymont 28 Jul '05

28 Jul '05

Howdy! I'm looking to use the framework for high-performance storing and querying of financial time series, i.e. ticks arriving from the exchange. I need to be able to store 500-1000 (or more) ticks per second and would like to be able to quickly find similar time series given a date range. I'm looking to create a cheaper alternative to www.kx.com with their KDB and K language. For each tick I need to store the datetime, symbol, trade type (bid/ask/trade), price and volume. How would I do a … [View More]

2 1

[MonetDB-users] Triggers in MonetDB
by Arthur van Bunningen 17 Jul '05

17 Jul '05

Dear all, First my compliments with this piece of useful and implemented research. Second I was wondering if there is a possibility to have so-called "triggers" in MonetDB such as in for example PostgreSQL [1] or if there are other ways to use MonetDB as an "active database". If anyone has experiences in this field or can point me to the right place to look for this experience I would be very thankful. Kind regards, Arthur van Bunningen [1] http://www.postgresql.org/docs/8.0/static/… [View More]

3 4

[MonetDB-users] jdbc related tests fail with a : connection refused
by Arnold Reuser 16 Jul '05

16 Jul '05

Hi all, Currently I've installed MonetDB & SQL on SUSE9.2 Pro from source as it was in CVS on 15 July. The problem I have is that all my jdbc related tests fail with a : Database connect failed: Unable to connect (localhost:48016): Connection refused , MServer with sql option and MapiClient runs just fine. Another example : % java -jar share/MonetDB/lib/MonetDB_JDBC.jar -umonetdb password: <monetdb> Currenlty also fails with the given username, password. Is the documentation or … [View More]

2 2

[MonetDB-users] bogus SQL in example + bad Mapi error reporting
by Martijn Faassen 03 Jul '05

03 Jul '05

Hi there, I just spent several hours scratching my head over why a piece of code didn't work. I was experimenting with Mapi and tried the example listed on the top of this page: http://monetdb.cwi.nl/TechDocs/APIs/Mapi/C/index.html This contains the following line: if ((hdl = mapi_query(dbh, "create table emp(name varchar, age int)")) == NULL) die(dbh); Unfortunately, it needs to be 'varchar(20)', not just plain 'varchar'. Just 'varchar' apparently does *not* result in an … [View More]

3 8

[MonetDB-users] mapi and xquery
by Martijn Faassen 03 Jul '05

03 Jul '05

Hi there, I'm trying to figure out how to use mapi to do an xquery. I have been able to shred documents (using MIL), but mapi with xquery is giving me trouble. Looking at the implementation of MapiClient, I see the following piece of code which appears relevant: /* xquery options are passed via the command string (becomes first line of query) */ char *c = command ? command : XQuerydefaultMode; char *t = strstr(c, "… [View More]

2 3

[MonetDB-users] xquery collection support?
by Martijn Faassen 02 Jul '05

02 Jul '05

Hi there, Another question: does the xquery implementation have collection support? It appears not, as fn:collection doesn't appear to be supported yet, but I'm a newbie to xquery so I may be missing something. I'm interested in XML content management applications, which tend to keep lots (and lots) of smaller XML documents. It'd be interesting to be able to query all of them (or sets of them) using XQuery in one go -- looping through all the stored documents and doing an XQuery on these … [View More]

2 1

[MonetDB-users] monetdb failing tests on FreeBSD
by Joseph McDonald 09 Jun '05

09 Jun '05

Hi, I just installed MonetDB-4.8.0_rc0 on FreeBSD 5.4-STABLE running on an opteron. To get it to compile I added this to monetdb_config.h: #define __BSD_VISIBLE 1 and I changed /* #define _POSIX_C_SOURCE 200112L */ /* XXX JOE */ #define _POSIX_C_SOURCE 200112 because a freebsd system header already had _POSIX_C_SOURCE defined without the L. when running "gmake check" I get: !ERROR: Testing FAILED SIGNIFICANTLY ! 2 out of 69 tests could not be executed 2 out of 69 tests … [View More]

4 7

[MonetDB-users] running 'make check'
by Martijn Faassen 07 Jun '05

07 Jun '05

Hey, Thanks to Niels Nes, my compilation problems were solved. Just for others who may be reading: it was a bogus mel.yy.cc that I generated on an early compile run without bison and flex installed, and this didn't get removed by 'make clean' (something that will be fixed). Anyway, now I ran 'make check', but not very successfully: !ERROR: Testing FAILED SIGNIFICANTLY ! 3 out of 222 tests could not be executed 219 out of 222 tests produced SIGNIFICANTLY different output … [View More]

4 9

[MonetDB-users] MonetDB 4.8.0 compile problem
by Martijn Faassen 03 Jun '05

03 Jun '05

Hi there, I'm trying to get MonetDB compiled on my debian (unstable) box, but I keep running into the same snag. It's probably something stupid, but I cannot seem to solve it. The full error log is in the end, but much of it seems to point to a missing yacc/bison during linking: mel.o(.text+0x6f4): In function `main': /home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.mx:400: undefined reference to `yyin' mel.tab.o(.text+0x126): In function `yyparse': /home/faassen/working/monet/… [View More]MonetDB-4.8.0/src/mel/mel.yy:53: undefined reference to `yylineno' I have bison and flex installed, and configure picks it up, but this doesn't seem to help any... Does anyone have any clue on what I am doing wrong here, and how to fix it? Regards, Martijn /bin/sh ../../libtool --tag=CXX --mode=link g++ -g -O2 -ansi -Wall -W -o mel FileInfo.o atomops.o mil.o prelude.o bat_arg.o epilogue.o var_arg.o proto.o builtin.o glue.o mel.o mel.tab.o mel.yy.o symbol.o command.o html.o module.o symtable.o any_arg.o debug.o iterator.o object.o type_arg.o atom.o depend.o operator.o use.o atom_arg.o dependency.o link.o ops.o g++ -g -O2 -ansi -Wall -W -o mel FileInfo.o atomops.o mil.o prelude.o bat_arg.o epilogue.o var_arg.o proto.o builtin.o glue.o mel.o mel.tab.o mel.yy.o symbol.o command.o html.o module.o symtable.o any_arg.o debug.o iterator.o object.o type_arg.o atom.o depend.o operator.o use.o atom_arg.o dependency.o link.o ops.o mel.yy.o(.text+0x0): In function `main': /home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy.cc:2: multiple definition of `main' mel.o(.text+0x670):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.mx:388: first defined here /usr/bin/ld: Warning: size of symbol `main' changed from 1247 in mel.o to 15 in mel.yy.o mel.o(.text+0x6f4): In function `main': /home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.mx:400: undefined reference to `yyin' mel.tab.o(.text+0x126): In function `yyparse': /home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:53: undefined reference to `yylineno' mel.tab.o(.text+0x138):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:54: undefined reference to `yyin' mel.tab.o(.text+0x1e0):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:61: undefined reference to `yylineno' mel.tab.o(.text+0x265):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:64: undefined reference to `close_and_change(void*, _IO_FILE*)' mel.tab.o(.text+0x621):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:124: undefined reference to `get_cur_buffer()' mel.tab.o(.text+0x637):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:125: undefined reference to `yylineno' mel.tab.o(.text+0x691):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:129: undefined reference to `new_buffer(_IO_FILE*)' mel.tab.o(.text+0x99f):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:181: undefined reference to `get_signature(char*)' mel.tab.o(.text+0x9c0):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:182: undefined reference to `script' mel.tab.o(.text+0x15dc): In function `yyparse': /home/faassen/working/monet/MonetDB-4.8.0/src/mel/y.tab.c:1168: undefined reference to `yylex()' mel.tab.o(.text+0x176b): In function `mel_yyerror(char const*)': /home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:464: undefined reference to `yylineno' mel.tab.o(.text+0x178c): In function `mel_yyerror(char const*)': /usr/include/c++/3.3/ostream:193: undefined reference to `yylineno' mel.tab.o(.text+0x17da): In function `mel_yyerror(char const*)': /home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:468: undefined reference to `yytext' mel.tab.o(.text+0x17f3):/home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:472: undefined reference to `yytext' mel.tab.o(.text+0x1876): In function `mel_yyerror(char const*)': /usr/include/c++/3.3/ostream:193: undefined reference to `yytext' mel.tab.o(.text+0x195b): In function `semerror()': /home/faassen/working/monet/MonetDB-4.8.0/src/mel/mel.yy:494: undefined reference to `yylineno' mel.tab.o(.text+0x197c): In function `semerror()': /usr/include/c++/3.3/ostream:193: undefined reference to `yylineno' collect2: ld returned 1 exit status make[4]: *** [mel] Error 1 make[4]: Leaving directory `/home/faassen/working/monet/MonetDB-4.8.0/src/mel' make[3]: *** [all] Error 2 make[3]: Leaving directory `/home/faassen/working/monet/MonetDB-4.8.0/src/mel' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/home/faassen/working/monet/MonetDB-4.8.0/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/faassen/working/monet/MonetDB-4.8.0' make: *** [all] Error 2 [View Less]

2 3

[MonetDB-users] Converting a unix timestamp (bigint) to timestamp/date?
by Arjen van der Meijden 24 May '05

24 May '05

Hi List, I'm trying to have an easy way to convert some fields that where initialy (in MySQL) stored as unsigned integers. I converted them using a dump/restore to MonetDB's bigint. Currently this works: CAST("1970-01-01 01:00:00" as timestamp) + (CAST(RecordTimestamp AS STRING) || 'LL') Appearantly bigint (long) is incompatible with sec_interval (long)? But afaik this should be possible in SQL as well: CAST("1970-01-01 01:00:00" as timestamp) + INTERVAL RecordTimestamp SECONDS … [View More]

3 2