April 2008 - users-list

[MonetDB-users] Sorted materialized views
by Nils Grimsmo 16 Apr '08

16 Apr '08

Hello, all! I am about to prototype something, and it would be convenient to use SQL to throw it together quickly to see if it flies. I downloaded MonetDB yesterday, so I am quite fresh :-) I have a table with a set of columns, and the like to have a few materialized views or projections (or whatever you DB people call it ;-)) sorted on different columns. The views may also have selection, I am not sure yet. And given problem (a data query), I use some statistics to decide which sorting order is most convenient, look up a (preferably continuous) vertical part of the columns, scan through it, and possibly do some filtering. The queries may also be trees, in which case I might use a different sorting order for each branch, and then do merging based on some of the columns. Assume: CREATE TABLE t (a INT, b INT); INSERT INTO t VALUES (1, 3), (4, 2); I would like to do something like: CREATE VIEW v AS SELECT b, a FROM t ORDER BY b, a; This is not allowed (works if I remove ORDER BY). I would also like to have an index over v(b,a), like: CREATE UNIQUE INDEX j USING BTREE ON v (b, a) ; But this is never allowed on a view, right? Since updates are not an issue in the prototype, I could just create a new table like this: CREATE TABLE v (b int, a int, PRIMARY KEY(b, a), INDEX i USING BTREE (b ASC, a ASC)) AS SELECT b, a FROM t ORDER BY b, a; (Using both PRIMARY KEY and INDEX is always butter on bacon?) But this is not allowed because of the table definition, all I am allowed to do is: CREATE TABLE v (b, a) AS SELECT b, a FROM t ORDER BY b, a WITH DATA; If I use PRIMARY KEY(b, a), am I then guaranteed the table to be sorted on (b, a)? Is there any other way of enforcing this in SQL? 1. Any suggestions for what I should do? Is my best option to create all "views" as tables from scratch, and fill them by hand? 2. How much slower would this be than using low-level stuff like BATs and BUNs myself? (The merges between branches in my (problem level) queries are simple, but cannot be expressed as SQL.) Klem fra Nils

3 4

Re: [MonetDB-users] Trouble connecting - Invalid credentials
by kykim_lists＠mac.com 16 Apr '08

16 Apr '08

I found this subject in the archives, and I am having the same problem I am running on Mac OS X 10.4.11 I built MonetDB from source from MonetDB-Feb2008-SuperBall I am new to MonetDB, so please forgive any ignorance.. Here's what I did: > monetdb create foo # create the db > mserver5 --dbname=foo --dbinit="include sql;" # start the db > ./mclient -lsql sql>CREATE USER "bar" WITH PASSWORD 'password' NAME 'Foobar User' SCHEMA "sys"; sql>CREATE SCHEMA "bar" AUTHORIZATION "bar"; sql>ALTER USER "bar" SET SCHEMA "bar"; > ./mclient -lsql -ubar Password:password sql>\q > ./mclient -lsql -ubar Password:password !InvalidCredentialsException:checkCredentials:Invalid credentials for user 'ifm' Two things: 1) I am able to login as user 'monetdb' without any problem 2) If i stop and start 'mserver5', I can login ONCE I know that I probably should be using 'merovingian', but I'm still playing around. Any pointers? Anything I can do to help debug? Thanks, -kevin

3 6

[MonetDB-users] fail to connect via merovingian
by McKennirey.Matthew 16 Apr '08

16 Apr '08

2 2

Re: [MonetDB-users] how to completely remove the MonetDB5installation
by ewilde 14 Apr '08

14 Apr '08

the operationg system i want to completely remove MonetDB5 from is: windows server 2003 x64 r2

2 1

[MonetDB-users] how to completely remove the MonetDB5 installation?
by ewilde 14 Apr '08

14 Apr '08

thanks for replying my previous message. as i mentioned in the previous message, the first installation worked fine (more or less), so in order to finish evaluating MonetDB5 regarding my certain needs, i just want to completely remove it and re-install it. it looks like that the installation program doesn't completely remove the MonetDB5 installation, so, what's the secrete? how do i (manually) completely remove the installation, so i be able to successfully re-install it as it happened the first time. thanks again, ewilde.

3 2

[MonetDB-users] Error building PF/Tijah index
by Desislava I. Petkova 14 Apr '08

14 Apr '08

Hello I'm trying to build a full-text PF/Tijah index. After starting the Mserver, I add 10 XML files into a new collection. I've divided the collection into files so that the files are not too large. This finishes without errors and the collection exists since pf:collections( ) <> returns <collection updatable="false" size="100 MiB" numDocs="1">dblp.xml1</collection>, <collection updatable="false" size="61 MiB" numDocs="1">dblp.xml10</collection>, <collection updatable="false" size="102 MiB" numDocs="1">dblp.xml2</collection>, <collection updatable="false" size="102 MiB" numDocs="1">dblp.xml3</collection>, <collection updatable="false" size="102 MiB" numDocs="1">dblp.xml4</collection>, <collection updatable="false" size="103 MiB" numDocs="1">dblp.xml5</collection>, <collection updatable="false" size="101 MiB" numDocs="1">dblp.xml6</collection>, <collection updatable="false" size="101 MiB" numDocs="1">dblp.xml7</collection>, <collection updatable="false" size="107 MiB" numDocs="1">dblp.xml8</collection>, <collection updatable="false" size="107 MiB" numDocs="1">dblp.xml9</collection> Then I try to build a full-text index for the collection let $opt := <TijahOptions stemmer="porter-english" /> return tijah:create-ft-index($opt) <> But the Mserver aborts after some time with the following error message: MonetDB>*** glibc detected *** free(): invalid pointer: 0x0000002be9d42010 *** I would like to know what this error message means, and how can I fix the problem. Thank you for your response, Desislava

2 1

[MonetDB-users] mserver crashes on windows server 2003 x64
by ewilde 14 Apr '08

14 Apr '08

hi, i do the following steps: 1. run the install program: MonetDB5-SQL-Installer-x86_64-20080214.msi 2. from the start menu, run the shortcut: MonetDB SQL Server 3. from the start menu, run the shortcut: MonetDB SQL Client and... the MonetDB SQL Server window disapears.... a few days ago i installed it (first time in my life) and it worked. i started doing some testing for a couple of days, and suddenly the server stopped working. finally, i gave up: i removed it (using the install program) and re-installed it again (and again (to another directory)..). more info: 1. starting the client with the -lmal option (instead of -lsql) dose NOT crashes the server. so i guess something is probably wrong with the sql layer. 2. during those couple of days that the server was working, i could not find any file related to the database in the whole file system, even though i managed to store some tables with a few millions of records. i was able to query these tables and (most of the time) getting the expected results, so i moved on ignoring this strange thing. BTW: i wonder what is the best way to migrate a database from MSSql server to MonetDB5? i tried to export a whole database (~30 millions of records) from MSSql2005 to MonetDB. first, i thought i could do it with the MSSql export wizard using the odbc driver, but this driver did not show up in the wizard as a target possibility. next, i tried to write a java program using the jdbc driver, but the performances rate weren't constant: one table with 3 columns (int,int,decimal) and about a half a million of records moved to MonetDB in ~3000 records per second. but another very similar table with 3 columns (int,int,int) and about 8 millions of records moved to MonetDB in ~30 records per second (actually, this process had been stopped as a result of an attempt to create another table, and since than, the server is dead.) thanks in advanced for any help, ewilde

2 1

[MonetDB-users] New to MonetDB
by Shankar Yoganathan 13 Apr '08

13 Apr '08

Hello I am new to monetDB. I have a few questions about using MonetDB in embedded environment. I read in the embedded server page that only client is allowed to connect to the embedded server. 1. Does this mean I can not have multiple processes accessing the same database? 2. Can multiple threads with in the same process access the same database? 3. in the in-memory embedded environment, is there a way to save the data before the system shutdown? So that when the system starts, I can automatically populate the database to the previous state? Thank you for your help in advance Shankar

3 2

[MonetDB-users] linux flavor
by mobigital1 12 Apr '08

12 Apr '08

>From my testing of the windows 64 bit port it seems that may be the linux version is a bit more stable to run? (due to specifics of memory mapped file implementations)? can anyone suggest what flavor of linux is best to use to load most data? also the one that's easy to run under vmware? -- View this message in context: http://www.nabble.com/linux-flavor-tp15860790p15860790.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] cvs version (0.23) error
by Jorge Martín Cuervo 09 Apr '08

09 Apr '08

Hi all, I use the an script to download and compile the latest version of cvs, but despite theres no error messages and seems to start very good i can't store any file. The version i see in the console is 0.23, and if i return to my 0.22 version compiled from source it works perfect. I mean storing files, listing and so on. Also, i made a simple java program that connects to database throw jdbc to create documents quickly, and works pretty good with 0.22, but no way with 0.23. In the console (http://127.0.0.1:50001/admin/) i get the same error when i push on every button: Internal Receiver Error: out-of memory any idea? thanks. -- ;-) ____________________________________ Jorge Martin Cuervo Outsourcing Emarketplace deFacto Powered by Standards email <jorge.martin(a)defactops.com> voice +34 985 129 820 voice +34 660 026 384 ____________________________________ DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info(a)defactops.com). También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación. This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

1 0