users-list May 2008

users-list@monetdb.org

25 participants
28 discussions

by Matt Magoffin

Hello, I am interested in evaluating MonetDB/XQuery. I have some XML collections for a project I work on that are of 1-2 million individual XML documents for which I use XQuery to access for OLAP style reporting operations. This is a Java-based project, and while working on this project I developed a thin XQuery-centric API so that I could evaluate/use many different XQuery implementations, which my company released as an open source project called Xaj (http://sourceforge.net/projects/xaj). Currently I am using a Berkeley DB XML implementation, but am interested in exploring other options. I'd like to implement a MonetDB version of this API now, but I am having some difficulty finding out how to effectively access MonetDB through Java. So far I was able to use the MonetDB JDBC driver to construct XQuery statements and get XML results, and also I was able to construct MonetDB pf:add-doc() statements to add documents, but I am wondering if this is the best approach (and if so, how to add documents to a remote MonetDB server using the pf:add-doc() mechanism). The API I am trying to implement you can view here, to give you an idea what I'm trying to do: http://xaj.svn.sourceforge.net/viewvc/xaj/xaj/src/net/sf/xaj/XmlDb.java?rev… It was somewhat modeled after the defunct XML:DB API, but focused just on add/store/XQuery operations. Any help/advise would be greatly appreciated! -- m@

13 years, 11 months

[MonetDB-users] Is it possible getting types IN params or result set?

by Marc Weber

Hi, I'd like to work on embedding query statements into the haskell language by using template haskell to automatically derive insert and select functions having proper types automatically. sqli for Java already does it. resulting in something as: (rows :: [ (Int, String) ]) = $( select "SELECT intV, stringV FROM table") $( ) means a function is automatically created returning a list of tules of type (Int, String). Because haskell is strongly typed the function select creating the the type safe function must get to know which type the query will return. When using INSERT statements it would be nice to also now which type of parameters have to be passed. Does MonetDB provide kind of query function WhichInOutTypesDoesQueryHave("SELECT ..") or WhichInOutTypesDoesQueryHave("INSERT INTO FOO (abc,def) VALUES (?,?)") This way syntax and semantics could be checked at compile time. Sincerly Marc Weber

14 years, 2 months

[MonetDB-users] /bin/bash: ../Mx/Mx: No such file or directory

by Ying Zhang

Dear all, I'm trying to compile monet on my laptop But I already get a problem when I 'make' in buildtools: ../Mx/Mx -x C /home/jennie/monet/current/buildtools/mel/any_arg.mx /bin/bash: ../Mx/Mx: No such file or directory The directory Mx indeed contains too few files, but 'make' in Mx seems doing nothing: $ cd ../Mx $ ls config.log config.status Makefile mx_config.h stamp-h1 $ make make all-am make[1]: Entering directory `/home/jennie/scratch/monet-build/current/buildtools/build-debug/Mx' make[1]: Nothing to be done for `all-am'. make[1]: Leaving directory `/home/jennie/scratch/monet-build/current/buildtools/build-debug/Mx' $ ls config.log config.status Makefile mx_config.h stamp-h1 Sys. info: $ uname -a Linux 2.6.22-14-generic #1 SMP Tue Feb 12 07:42:25 UTC 2008 i686 GNU/Linux I did: bootstrap && configure && make && make install with the configure options: --prefix=$INSTALL_DIR --enable-strict --enable-assert --enable-debug --disable-optimize Does anyone have an idea why Mx is not generated by 'make'? Thanks! Jennie

14 years, 2 months

Re: [MonetDB-users] (no subject)

by Martin Kersten

Yeo Yvonne wrote: > Dear Sir, > > I would like to find out more about MONETDB and the diffenerces > betwwen ORacle and MONETBD? Dear Yeo This is a question of comparing apples and oranges ;) There is no document available to compare the systems. Please have a look at the introductionary sections of the MonetDB manual. The rest is a study by itself. regards, Martin > > Thanks. > > With Regards, > Yvonne Yeo. >

14 years, 2 months

[MonetDB-users] fedora core 9 repo or rpms?

by mobiledreamers＠gmail.com

Please share fc9 repos or how do we install monetdb in fc9 sudo yum -c /tmp/MonetDB-Stable-Fedora.repo resolvedep http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./0_lates…: [Errno 14] HTTP Error 404: Not Found Trying other mirror. Error: Cannot retrieve repository metadata (repomd.xml) for repository: MonetDB-Stable. Please verify its path and try again *Forcing to use the 8 repo in 9 gives these errors* sudo yum -c /tmp/MonetDB-Release-Fedora.repo install MonetDB5-server MonetDB MonetDB-SQL-server5 Setting up Install Process Parsing package install arguments Resolving Dependencies --> Running transaction check ---> Package MonetDB.i386 0:1.22.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB --> Processing Dependency: libcrypto.so.6 for package: MonetDB ---> Package MonetDB5-server.i386 0:5.4.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB5-server --> Processing Dependency: MonetDB-client >= 1.22 for package: MonetDB5-server --> Processing Dependency: libcrypto.so.6 for package: MonetDB5-server --> Processing Dependency: libMapi.so.0 for package: MonetDB5-server ---> Package MonetDB-SQL-server5.i386 0:2.22.0-1.fc8.oid32 set to be updated --> Running transaction check ---> Package MonetDB-client.i386 0:1.22.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB-client --> Processing Dependency: libcrypto.so.6 for package: MonetDB-client ---> Package MonetDB.i386 0:1.22.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB --> Processing Dependency: libcrypto.so.6 for package: MonetDB ---> Package MonetDB5-server.i386 0:5.4.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB5-server --> Processing Dependency: libcrypto.so.6 for package: MonetDB5-server --> Finished Dependency Resolution MonetDB-client-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-client-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libcrypto.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libssl.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libssl.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libcrypto.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libcrypto.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libssl.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release)

14 years, 2 months

[MonetDB-users] MonetDB users

by Seth Grimes

Hello all, I've just joined the list to learn more about use of MonetDB. The DBMS looks quite interesting. Who's using it outside the research community at CWI? For what type and size of applications? Thanks, Seth -- Seth Grimes Alta Plana Corp, analytical computing & data management Intelligent Enterprise magazine (CMP), Contributing Editor grimes(a)altaplana.com http://altaplana.com 301-270-0795

14 years, 2 months

[MonetDB-users] deep-equals function

by luc touraille

Hi everyone, I was wondering if the deep-equals function, described in the http://www.w3.org/TR/xpath-functions/#func-deep-equal W3C XQuery functions spec , was planned to be supported soon in MonetDB/XQuery. I saw on the CVS repository that the latest files of pathfinder included its signature, but I can't find its implementation. Can anyone enlighten me ? Thanks, Luc -- View this message in context: http://www.nabble.com/deep-equals-function-tp17364244p17364244.html Sent from the monetdb-users mailing list archive at Nabble.com.

14 years, 2 months

[MonetDB-users] Data Compression Algorithms

by Veneta Dobreva

Hello, I have the following question about MonetDB: does MonetDB implement some data compression algorithms? I would like to use an RLE (run-length encoding) algorithm for compression of my data. Is this already implemented in MonetDB? Thank you in advace for your help! Regards, Veneta Dobreva -- Dipl.-Inf. Veneta Dobreva Lehrstuhl Informatik III Tel.: ++49 (0)89 289-17288 Fakultät für Informatik Fax: ++49 (0)89 289-17263 TU München, Raum 02.11.041 MI veneta.dobreva(a)in.tum.de http://www-db.in.tum.de/~dobreva/

14 years, 2 months

[MonetDB-users] MonetDB V 4.22 installation on Mac OS X 10.5.2 and Mac OS X 10.4.0.

by Irini Fundulaki

Hi, I have the following problems with MonetDB XQuery Release Feb 2008, V. 4.22 on Mac OS X 10.5.2 and Mac OS X 10.4.0. 1) Mac OS X 10.5.2: a) I was not able to install MonetDB from sources. I downloaded MonetDB-Feb2008-SuperBall.bz2 and followed the instructions in http://monetdb.cwi.nl/projects/monetdb//MonetDB/Documentation/Linux-Install…. I successfully installed MonetDB, clients and MonetDB4-server, but when installing MonetDB4-XQuery I had the following error: Undefined symbols: "_embedded_mil", referenced from: _main in prog.o ld: symbol(s) not found collect2: ld returned 1 exit status make[5]: *** [Mbeddedxq] Error 1 make[4]: *** [all] Error 2 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 b) by calling monetdb-install.sh. MonetDB was installed with no problems. Nevertheless, mclient with a simple query (e.g., <example>hello</example) stalled. Mserver stalled when executing xmldb_print(); 2) Mac OS X 10.4.0 a) I was able to install MonetDB XQuery Release Feb 2008, V. 4.22 using monetdb-install.sh. Mserver did not stall with xmldb_print(). mclient for the same query exhibited different behaviors: that is, sometimes it stalled, and others not (again, the same simple query as before). I had downloaded MonetDB on September 2007, and installed it on Mac OS X 10.4.0. I had no problem with that version. Thanks for looking into it, Irini

14 years, 2 months

[MonetDB-users] MonetDB as server side environment

by bryan rasmussen

Hi, I'm thinking about moving some applications I have running in eXist to MonetDB, just to gauge performance and possibilities. These applications take parameters from the querystring, is there an example of accessing the querystring in a MonetDB Xquery XQL file when it runs? Best Regards, Bryan Rasmussen

14 years, 2 months

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

users-list May 2008