October 2009 - users-list

[MonetDB-users] Question on Usage
by Roman Sokolyuk 20 Oct '09

20 Oct '09

Hi, I am evaluating MonetDB for OLAP purposes and had some questions about usage: Please, be patient with me as I am rather new to this area... 1. If I were to build a data warehouse in MonetDB, would I have to store data in a different manner than in any other RDBMS? From what I understand, in data warehousing data should be denormalized, but besides that, do I need to familiarize myself with any new paradigms specific to MonetDB? For example, If my firsm sells 4types of vehicles - RV's, small cars, and motorcycles - and I want to create reporting which can be limited to only one of them or all of them put together, would I have to create 3 tables - one for each type of vehicle, but which have the same columns? Say RVs: make_year, size, brand car: make_year, size, brand motorcylce: make_year, size, brand? 2. Let's say I wanted to also keep aggregate information on the purchase of those vehicles, would I keep the aggregate data in a separate table, or use MonetDB to compute it? I guess what I am struggling to understand is: is usage of monet db for a Java developer radically different from other RDBMS's like MySQL or Oracle, or is it the same, and the OLAP strength is only the result of MonetDB's internals? Thanks,

1 0

[MonetDB-users] create temp table privileges
by magicrobotmonkey 20 Oct '09

20 Oct '09

I am trying to set up monet as a backend to our system for reporting. I've got merovigian running, with a database created, and I've added a schema and user to that db via mclient: CREATE USER "test" WITH PASSWORD 'password' NAME 'Test User' SCHEMA "sys"; CREATE SCHEMA "test" AUTHORIZATION "test"; ALTER USER "test" SET SCHEMA "test"; Now, I can do all kinds of things in the test schema with this user. What I can't do is create temporary tables: Error in query: CREATE TABLE: insufficient privileges for user 'test' in schema 'tmp'. I cannot for the life of me figure out how to give this user create table privileges in tmp. -- View this message in context: http://www.nabble.com/create-temp-table-privileges-tp25981635p25981635.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] default database
by Roman Sokolyuk 20 Oct '09

20 Oct '09

Hi, I installed Monet, but I did not create a database, and now I want to connect SQuirrell, but I need to know the name of the database to put in the URL. I imported the voc data, so there must be a database set up already. Is there a way I can find out the name of the database I am logged into?

2 2

[MonetDB-users] Hibernate?
by Roman Sokolyuk 20 Oct '09

20 Oct '09

Does Monet integrate with Hibernate?

1 0

[MonetDB-users] Cannot import the VOC data
by Roman Sokolyuk 20 Oct '09

20 Oct '09

Hi, I extracted the sql voc data file, but when I run \< voc_dump.sql on the command line I get the error: *voc_dump.sql: cannot open* I extracted it directly into the MonetDB installation directory, alongside mclient.bat.

3 4

[MonetDB-users] Cannot start mclient on Windows
by Roman Sokolyuk 20 Oct '09

20 Oct '09

Hi, I am running Vista 64. I installed the 64 msi of monetdb. When I start the client from the Start menu it works fine, but when I try to run mclient --help for example in a simple command prompt window I get a Windows error message: "This application has failed to start because libMapi.dll was not found. Re-installing the application may fix the problem". Could you please suggest something? Thanks.

2 2

[MonetDB-users] How to display the 'cool' mclient error messages?
by Stefan de Konink 19 Oct '09

19 Oct '09

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi, After trying to figure out for over an hour what could have possibly gone wrong with my database. And just before I started to complain out potential corruption I really wonder: If a mapilib user wants to get this message: SELECT: access denied for dbslayer to table 'sys.ietsanders' Could anyone provide a code snippet that returns that? printf("SELECT: access denied for dbslayer to table 'sys.ietsanders'\n"); is too easy... Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.13 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREKAAYFAkrcpQoACgkQYH1+F2Rqwn2x9wCfVXutknJ59KByQ+CzobrhrucK BCkAnRM6MiUcd/TwK47InveuD2rx8v7c =gUIR -----END PGP SIGNATURE-----

1 0

Re: [MonetDB-users] loading RDF data in MonetDB
by Medha Atre 17 Oct '09

17 Oct '09

Hi, Thanks for the reply. At this point, all I am looking for is to load RDF NTriples data -- treated as a 3 column table -- into MonetDB using "vertical partitioning" to index the data nicely (as I read about MonetDB being used for the same in different research papers recently.. e.g. http://portal.acm.org/citation.cfm?id=1453856.1453927 RDF-3X etc). I am not really looking for a great support for different RDF formats (as the data has already been cleaned into NTriples format using rdflib), I want to check the correctness of the results generated using my own querying tool. So can you please suggest me a method of treating the given RDF NTriples file as a simple "space separated" 3-column data file from which I can load the data into MonetDB creating the required indexes or "vertical partitions"? Querying with SQL front end is fine with me! Looking forward to your help. Medha > ------------------------------ > > Message: 5 > Date: Tue, 6 Oct 2009 10:19:57 +0200 > From: Lefteris <lsidir(a)gmail.com> > Subject: Re: [MonetDB-users] loading RDF data in MonetDB > To: Communication channel for MonetDB users > <monetdb-users(a)lists.sourceforge.net> > Message-ID: > <852badbc0910060119x4f125a06qd5fc7ed0c56035c(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, > > there is a highly experimental module for MonetDB to load RDF data. > This is not activated in the stable release, and in order to use it > you will need to do some compilation on your own and possible report > back any problems you have. If you are willing to jump deeper in the > MonetDB experience I can guide you on how to do this. The module will > read any RDF format supported by the rdflib library and create a > triple store with appropriate indices. However, the only way to query > the triple store at this point is through the SQL front-end. > > regrads, > > lefteris > > On Tue, Oct 6, 2009 at 8:59 AM, Medha Atre <medha.atre(a)gmail.com> wrote: >> Hi, >> >> I intend to use MonetDB for some of my experimental work using RDF >> data. I was wondering if there is an easy way to load RDF data (in >> NTriples format) in MonetDB making use of the column-wise vertical >> partitioning of the RDF data, based on properties/predicates in the >> RDF data. >> >> Some pointers or help regarding this is much appreciated. >> >> I am sorry if this is not the correct forum to post this message. >> >> Thanks. >> Medha

8 24

[MonetDB-users] prepared exec did not translate date string
by Allen Zhang 16 Oct '09

16 Oct '09

Hi, there, We are testing the Aug SP1 (v5.14.2) release, it seems the exec did not translate the date string, please run attached sql against Aug SP1, it give out the following error, the same script works file on mserver v5.10.4 (May SP1). Sounds like a bug to me. 15:19:53 [CREATE - 0 row(s), 0.000 secs] Command processed. No rows were affected 15:19:53 [SELECT - 3 row(s), 0.000 secs] Result set fetched 15:19:54 [PREPARE - 1 row(s), 0.000 secs] Result set fetched 15:19:54 [EXEC - 0 row(s), 0.000 secs] SQLException:sql.prepare:wrong argument for prepared statement (expected date instead of char) 15:19:54 [EXEC - 0 row(s), 0.000 secs] current transaction is aborted (please ROLLBACK) 15:19:54 [EXEC - 0 row(s), 0.000 secs] current transaction is aborted (please ROLLBACK) 15:19:54 [EXEC - 0 row(s), 0.000 secs] current transaction is aborted (please ROLLBACK) 15:19:54 [COMMIT - 0 row(s), 0.000 secs] COMMIT: failed ERROR: COMMIT: transaction is aborted, will ROLLBACK instead 15:19:54 [SELECT - 3 row(s), 0.015 secs] Result set fetched 15:19:54 [DROP - 0 row(s), 0.000 secs] Command processed. No rows were affected ... 10 statement(s) executed, 7 row(s) affected, exec/fetch time: 0.015/0.000 sec [3 successful, 2 warnings, 5 errors] Thanks for the attention. Allen

2 1

[MonetDB-users] BATpropcheck exception
by Alex Bo. 15 Oct '09

15 Oct '09

Hi, I haven't been able to reproduce this, but when running an INSERT query I got: !MALEXCEPTION: !ERROR: BATpropcheck: ... tuples seqbase of dense oid bat is wrong! 0 != 12306 I am running Aug09 SP1 compiled from CVS on Windows. What could have caused this error? Thanks. -- View this message in context: http://www.nabble.com/BATpropcheck-exception-tp25909476p25909476.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0