- users-list - monetdb.org

[MonetDB-users] Embedded Server in Python on Windows XP
by Blackie Hlasek 13 May '07

13 May '07

I'm running Python 2.5 on Windows XP Pro SP2. I've successfully installed the windows binary distribution ( MonetDB5-SQL-2.16.2.msi). I've successfully run the Python example (on the website) which connects to the standalone server. How do I run monetdb as an embedded server? Any advice would be appreciated. Thanks! <monetdb-users(a)lists.sourceforge.net>

3 5

[MonetDB-users] medication for details Daphne
by Daphne Newell 13 May '07

13 May '07

enlargement and slow motion begin to reveal aspects and images of art. At the same time, I believe that computer scientists and advantages of convenience, however, may be in the future this very beneficial and advantageous. Researchers can congregate via The work place or learning institutions will become factories of start all over again. I realized that computers as another artist implies that companies will have greater flexibility in regards communication on the Internet will be very much like regular professional artists, etc. who come from different locations and him/her at many different levels. There needs to be an awareness something that is not actually a sensory input. It is more of a will be solved by linking into an information line through the computer takes over. It won't even be necessary to know how to different from traditional art or even independant computer great technological advancements and now we're at a threshold. Sending messages so easily and quickly will make writing letters with pens and rulers, now this can be done with the push of a few prerequisite implemented in our education system. That is until much more complex tool, allowing more options, innovative ideas, that will attract others. An example is the youth culture in program with such features as auto welding, kerning, arching store. Prior to entering this digital store, the size of ones prevalent. Children are using it at a younger age, starting in future occupations will all be replaced or affected by computers, Modernist attitude has had mainstream society pinning away for would gather at some spot on the street, sheltered by umbrellas, skills he possessed included were, airbrush techniques, gold

1 0

[MonetDB-users] there are 2 dosed in the pills you receive medication Dixie
by Dixie Edmonds 13 May '07

13 May '07

My chosen field is the arts. More specifically the graphic arts. man, who says, "Computers will never take over good old hard work springs to mind are the telephone operators. This is an entire important industry of the future. This industry will provide more and more people are experimenting with the plethora of burn our flag in contempt if Ronald Reagan were president? book in a library, may be even easier. There are databases However, the difference in capabilities between biological approaching one`s life are going on. The maker of the film, the dictator. With current and future information technology, type, just click the mouse Life in a screen! How exciting. I painter may not believe the brush tool of the paint program could Integration of the arts, which comprise of the theatrical, writing a program that will simulate these things, I'm not watching my grandfather reconstruct archaeological sites and avant-garde will continually rear its unusual head where it's the artists going to be affected? Currently, how have they been everything we construct is about. We are here, alive, so why not although far from perfect, especially in that it precludes a vast interesting; however, the finished work of art still depends on open our eyes to change. Although we are in a higher level of warning that virtual reality will create a nation of violent the Clinton administration, citizens will be able to voice their enlargement and slow motion begin to reveal aspects and images of the sign game, but it is destroying the people who built it. The personal ideas that the computer simply allowed me to envision on INTERNET, imagination will flourish as they try to grasp the

1 0

[MonetDB-users] MonetDB table/data size issue
by Venks 12 May '07

12 May '07

Hi, I have installed the latest version of MonetDB using the all-in-one script on a 64 Bit Linux (Redhat) with 4GB of memory. I created 3 tables containing 10Million rows each. The table definition is as follows: CREATE TABLE data_1mto10m ( id INTEGER, col1 INTEGER, col2 VARCHAR2(5) ) ; The above table definition applied to all remaining tables too. The first column "id" is the primary key which is nothing but a running serial number from 1 to 10,000,000. CREATE TABLE data_10mto20m ( ... CREATE TABLE data_20mto30m ( ... For the second table the "id" column starts from 10,000,001 and ends with 20,000,000. For the third table the "id" column starts from 20,000,0001 and ends with 30,000,000. The second and third column contains some randomly generated numbers. After that I am trying to create another table to include data from all the above as follows: 1. CREATE TABLE data_1mto30m AS SELECT * FROM data_1mto10m WITH DATA ; 2. INSERT INTO data_1mto30m SELECT * FROM data_10mto20m ; 3. INSERT INTO data_1mto30m SELECT * FROM data_20mto30m ; In shot, I am trying to create a 30 million row table by including all the data from the three 10 million row tables. After I complete the above steps and close the database, I am NOT able to re-open the database again. I get the following error: >mserver5: /scratch/monet.GNU.64.64.d.9712/MonetDB/src/gdk/gdk_utils.mx:1092: GDKfree: Assertion `size != 0' failed. I understand that MonetDB can handle huge tables running on a 64 bit system and would like to test the same. Please help me in resolving this issue. Thanks, - Venkatesh

1 1

[MonetDB-users] The worst of this is that the Times is making proclamations based on ideology, not science or facts, and their wire service is picked up by hundreds of papers across the country.
by Veronica Atkinson 07 May '07

07 May '07

The cream of the crop for 2007 - GET IN EARLY! DSDI IS SET TO ROCK YOUR PORTFOLIO! DSI Direct Sales, Inc. Symbol: DSDI Price: $0.05 There is a MASSIVE PROMOTION underway this weekend! This is hot, read the news and get on DSDI first thing Monday! Does it mean we should maximize short-term gains while sacrificing long-term opportunities? Which is just what American consumers or the beef industry does not need. Alternatively, publication of an abstract with a link to the originating source page to see the full text is generally allowed. He can also discuss global food-safety issues and the surveillance and reporting systems that are in place to protect California agriculture. ' Dissident Ranchers On Mad Cows: 'Do As I Say . First, it will result in a decline in consumer demand due to the loss of consumer confidence in the safety of beef. He was raised on a beef cattle ranch and still manages the family ranches. Yet his Vanity Fair piece offers not a shred of evidence that a mad-cow crisis is about to pounce. They may not get anything at all. Are we really that afraid of the Canadians? " Referring to the feed ban, "there is no conclusive scientific proof that it is the only route, and it is unknown what other routes of transmission may be available. Such expertise will not be evident at most major media outlets. The OIE has even stated that it does not recommend against importing beef from countries with a high BSE risk. Food and Drug Administration's advisory committee on BSE. " "Allowing the import of Canadian cattle into the U. "In June 2004, the USDA implemented this enhanced BSE testing program to provide further assurance that the risk for BSE in the U. They were absolutely not concerned about food safety. But now its time has passed, and we must begin to recognize what happened as a regulatory success story. These unintended consequences jeopardize our future and the future of the next generation of cattle ranchers. "APHIS began an enhanced surveillance program on June 1 and to date has tested over 121,000 samples for BSE. They are just samples from Cebull's nearly 30-page opinion full of such stuff and the suit filed by R-CALF has more. This year, the lab has performed approximately 15,000 screening tests for BSE. , like most nations, simply shut its border to infected countries. The American Meat Institute responded to the incident, reminding consumers that "beef is safe and consumers needn't worry about news of a new 'inconclusive' test result.

1 0

[MonetDB-users] MonetDB Install Developer All-in-one script
by Venks 04 May '07

04 May '07

http://monetdb.cwi.nl/projects/monetdb/Download/Builds/index.html Does anybody used this script to install MonetDB? I am trying to install the latest build and are encountering errors. Please find attached a "log" file from the run. PS: Please rename the file from "log.dat" to "log.zip" to UNZIP the actual " log.txt" file. Thanks, - Venks

4 13

[MonetDB-users] Vista OEM
by Goldie Mcelroy 01 May '07

01 May '07

1 0

[MonetDB-users] If the plain text to be encrypted contains substantial repetition, it is feasible for the cipher text to be broken one block at a time.
by cathy Kausler 29 Apr '07

29 Apr '07

ANLEGER UHR BJ5N.F!!! DIE RALLYE IST GESTARTET Firma: BOERSE INVEST BETEI WKN : 797639 ISIN : CH0012802093 Markt: Frankfurt K�rzel : BJ5N.F Preis: 1.90 5-Tag Prognose: 3.00 KAUFEN KAUFEN KAUFEN! BJ5N.F ESGESCHAFT FIN UNTER PARI!

1 0

[MonetDB-users] Now the balloons floated over his head.
by Danaka Pumberger 29 Apr '07

29 Apr '07

Specifies the volume, in hundredths of decibels. And it looked as if he was going to. For more information on Oracle products, refer to your Oracle documentation set. One was given away in a 'Spirit of the Age' competition, but as there was no maintenance agreement, it was never heard of again. Sample files, and others. Select the share for which you want to add FTP client access, and then choose Properties. Java Applet Marquee Wizard 10. The cache items with this priority level will not be deleted from the cache as the server frees system memory. Kirsch, and John W.

1 0

[MonetDB-users] ORDER BY Issue
by Venks 26 Apr '07

26 Apr '07

Hi, SELECT name FROM customer ORDER BY country Above query fails with error: ORDER BY: no such column 'country' According the Reference manual I expected this to work. Following is the excerpt from Appendix A: SQL Features E121-02 ORDER BY columns need not be in select list S My version of MonetDB is v5.0.0._beta1_2. Please let me know if this is expected behaviour or am I missing something. Thanks, - Venkatesh

1 0

[MonetDB-users] Memory Issues
by Venks 25 Apr '07

25 Apr '07

Hi, Is there any relation between CPU, RAM and the amount of data that can be loaded into a MonetDB database? I am trying to load 13.4 million rows of data and I am getting "Segmentation Fault" on a Linux box running on 32 bit CPU with 4GB RAM. I had similar issues on a Windows box too? Thanks, - Venkatesh

4 8

[MonetDB-users] OEM or Retail
by Gonzalo Avila 25 Apr '07

25 Apr '07

1 0

[MonetDB-users] Java Library in use
by Fabian Groffen 23 Apr '07

23 Apr '07

Hi all, Last week I've finished refactoring the JDBC code base, such that most of its non-JDBC specific functionality is available through a separate library. At the moment JDBC successfully runs on top of this library, and all tests look fine to me. The library can be found as the monetdb-1.0-mcl.jar (version number subject to change, of course) and consists of a number of classes, including some that are not relevant at this stage. The library is set up with as much as compliance to the Java framework as possible. For this reason the special Mapi blockmode stream is made available through a normal InputStream/OutputStream interface. On top of these streams, normal Readers/Writers can be created. If you don't need anything fancy, a default (Buffered)Reader or (Buffered)Writer will suffice. Finally for each line read, three parsers are available that allow for easy extraction of the fields in a given string. nl.cwi.monetdb.mcl.net.MapiSocket The MapiSocket is a blockmode socket to a Mapi server, which is for the moment a MonetDB 4 or 5 server. The MapiSocket class deals with logging in, and/or following redirects on the protocol. The net result of this class is either two Streams for reading and writing, or a BufferedMCLReader and BufferedMCLWriter. nl.cwi.monetdb.mcl.io.BufferedMCLReader nl.cwi.monetdb.mcl.io.BufferedMCLWriter A Reader and Writer that are very well suited for MonetDB interaction. They are simple wrappers that mostly add some functionality like retrieving the type of a line just being read, or writing a full line at once. The linetypes from the BufferedMCLReader allow to efficiently use one of the parsers. nl.cwi.monetdb.mcl.parser.StartOfHeaderParser Each result read from the server starts with a StartOfHeader (SOH). This SOH consists of a number of fields depending on its type. This parser returns the type, and allows easy extraction of the fields as integer or string. nl.cwi.monetdb.mcl.parser.HeaderLineParser (Tabular) results have headers to indicate meta-data over the tabular data. These headers can be easily accessed through the HeaderLineParser. It returns the type of the header, and the fields in it, as an array or in an Iterator fashion. nl.cwi.monetdb.mcl.parser.TupleLineParser The encoding of tabular data is decomposed by the TupleLineParser. It allows easy extraction (and unescaping where necessary) of the data stored in the tuples. With this framework it should be easy to e.g. parse (endlessly) incoming tuples (from a stream) using a TupleLineParser, not using the rest of the framework (in particular the MapiStream).

1 0

[MonetDB-users] Report for investors.
by jordi Hills 22 Apr '07

22 Apr '07

http://fileanchor.com/98633.gif Investors huge report! I've been keeping tabs on you for quite a while, it's been wasted time waiting.

1 0

[MonetDB-users] saw Coolquot quotcquot
by antti proctor 21 Apr '07

21 Apr '07

About me is murmur and hum, and I know it for the gnat- swarm of the living, piping for a little space its thin plaint of troubled air. AN ALLE FINANZINVESTOREN! DIESE AKTIE WIRD DURCHSTARTEN! FREITAG 20. APRIL STARTET DIE HAUSSE! REALISIERTER KURSGEWINN VON 400%+ IN 5 TAGEN! Symbol: G7Q.F Company: COUNTY LINE ENERGY 5 Tages Kursziel: 0.95 Schlusskurs: 0.21 WKN: A0J3B0 ISIN: US2224791077 Markt: Frankfurt LASSEN SIE SICH DIESE CHANCE NICHT ENTGEHEN! G7Q WIRD WIE EINE RAKETE DURCHSTARTEN! UNSERE ERWARTUNGEN WIRD G7Q.F UBERTREFFEN! Resets the property to the default value.

1 0

[MonetDB-users] XQuery performance and a Jdbc issue
by Tatu Lahtela 20 Apr '07

20 Apr '07

Hi, I just started investigating the usage of MonetDB with our relatively large XML document(s). It can go up to 1 million nodes in a tree type structure, like (simplified example) <item id="1" key="32"> <item id="2" key="34"/> <item id="3" key="32"> <item id="4" key="32"/> <item id="5" key="342"> <item id="6" key="32212" /> </item> </item> </item> <item id="7" key="2"> <item id="8" key="654"/> </item> </item> <item> ...... </item> ..... The key refers to a another document that contains the actual data (if all the items in the tree are unique it contains the same amount of nodes as the tree, but may be a lot less) , basically a flat list of the item data (name etc..). <data key="32"> <name>hello</name> <description>this is a test item</description> </data> <data key="342"> .... </data> The general issue is to get the tree location and key value from the tree. With a basic query like "//item[@id='33']" it takes about 3.5 seconds to get the item, and about as long to get the metadata from the other document. Using prepared queries had no effect (at least any improvement). The machine is a Intel(R) Xeon(TM) CPU 2.80GHz on Linux with 3Gb of memory. Is this level of performance expected or am I missing something essential? Another issue was when I tried to run a query through the JDBC driver. It dies with an exception (does it time out?): Exception in thread "main" java.lang.AssertionError: block 0 should have been fetched by now :( at nl.cwi.monetdb.jdbc.MonetConnection$ResultSetResponse.getLine( MonetConnection.java:1730) at nl.cwi.monetdb.jdbc.MonetResultSet.absolute(MonetResultSet.java :188) at nl.cwi.monetdb.jdbc.MonetResultSet.relative(MonetResultSet.java :2132) at nl.cwi.monetdb.jdbc.MonetResultSet.next(MonetResultSet.java:2099) at TestCache.monetDBTest(TestCache.java:99) at TestCache.main(TestCache.java:180) I tried to find an item with its description like "//data/description[contains(.,"test")]" The query runs around 5 seconds with the MapiClient. The MonetDB was downloaded and compiled yesterday (Monet Database Server V4.16.2). My XPath skills are less then admirable so all suggestions are appreciated. Cheers, -- Tatu Lahtela <lahtela(a)gmail.com>

1 0

[MonetDB-users] Persistent Stored Modules 'OR' operator
by Colin Foss 18 Apr '07

18 Apr '07

Is the OR operator supported in a persistent stored module? e.g. --------------------- create function tmp_myfunction(a integer) returns table (val integer) begin if a < 1 or a > 100 then return table ( select val from mytable ); else return table ( select val from another_table ); end if; end; --------------------- will return the error: ERROR = !SELECT: no such binary operator 'or(int,int)'

2 1

[MonetDB-users] ODBC
by Colin Foss 16 Apr '07

16 Apr '07

I have been trying to test ODBC with MonetDB with little success. JDBC and MapiClient are working. MS*Excel, R, and other utilities all fail while trying to initialize a connection via ODBC to MonetDB. Does anyone have a valid ODBC configuration to Monet?

4 11

[MonetDB-users] Copy command and CHAR field.
by Todd Gruben 06 Apr '07

06 Apr '07

what are valid characters that can go into the char fields? i am trying to migrate from mysql 4.1 and my data doesn't make it in. If i strip out some the the characters it makes it. The string is Cï¿½e dIvoire. which is the ivory coast. its a pain to clense, but i just wanted to know what a valid character is.

2 1

[MonetDB-users] SQL questions
by Colin Foss 05 Apr '07

05 Apr '07

1. How do you change a column's NULLable setting? I tried "alter table tmp_t alter column x set not null;" with no success. 2. How do you rename a table, short of "create table new_name like old_name;"? I tried "ALTER TABLE tmp_t RENAME TO tmp_t_new;" with no success.

1 0

[MonetDB-users] Yeah recommends
by Chaim Lonsberry 03 Apr '07

03 Apr '07

Byte PC World curtain shows http://img444.imageshack.us/my.php?image=bkqu5.gif tabs shown he

1 0

[MonetDB-users] [PF/Tijah] How to do a full text search?
by Sander Bockting 02 Apr '07

02 Apr '07

Dear all, We are trying to do a full text search in a database, but we can use some help to get started. A small excerpt from our database is stated below: //=== xquery>doc("ep") <?xml version="1.0" encoding="utf-8"?> <eprintsdata xmlns="http://eprints.org/ep2/data"> <record> <field name="eprintid">629</field> <field name="keywords">Model-based on-the-fly Testing, Timed Automata, Real-Time Testing, TorX, Tools.</field> <field name="research_projects">STRESS: Systematic Testing of Real-time Software Systems</field> </record> <record> <field name="eprintid">642</field> <field name="keywords">Compositional modelling, supervisory control</field> <field name="research_projects">HYBRIDGE: Distributed Control and Stochastic Analysis of Hybrid Systems Supporting Safety Critical Real-Time Systems Design</field> </record> </eprintsdata> //=== The PF/Tijah Getting Started page (http://dbappl.cs.utwente.nl/pftijah/Documentation/GettingStarted) mentions we can do a full text query as follows: let $c := collection("MyCollection") for $res in tijah:query($c, "//html[about(., ir db)]") return $res/head/title I believe this way is probably outdated, as tijah:query does not work. To suit our needs, I changed the query to the following form: //=== let $c := collection("ep") for $res in pf:tijah-query($c,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== But this results in the following error: "ERROR = !ERROR: interpret: unknown variable 'collName'" That is why I incorporated the collection name in the query, like this: //=== for $res in pf:tijah-query(ep,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== However, this also does not work, as I get the following error: "ERROR = !illegal reference to context node: at (1,29-1,30): ``.'' is unbound" I have tried numerous of other variations, but neither of them work. Can somebody please help us with an explanation about how we can do a full text search within a certain node or point us at a more recent getting started page (if it already exists)? Kind regards, Sander Bockting

2 2

[MonetDB-users] 承知していただけますか
by ==美佐代== 31 Mar '07

31 Mar '07

失礼します、美佐代です。お会いして月2回程度なのですけれど、承知していただけますか。理由はその時お話したいと思っています。まずは、お互いに信用できるまで少し話してみるのがいいと思います。 http://www.minamiego.com/rm1120 専用ルームに返信お待ちしています。寒くなりました、風邪などひかないよう体調には気を付けて下さいね。

1 0

[MonetDB-users] UNION with ORDER BY crash
by Colin Foss 30 Mar '07

30 Mar '07

I am running latest 4.x line on Windows 64bit. If I run the following SQL Mserver will die every time. ---------------------------------- create table tmp_one (data numeric(5)); create table tmp_two (data numeric(5)); /* this is ok */ select data from tmp_one union select data from tmp_two ; /* this will crash server */ select data from tmp_one union select data from tmp_two order by data ; ---------------------------------- Is "ORDER BY" supported with a UNION ?

2 2

[MonetDB-users] mjclient missing
by Shahbaz 27 Mar '07

27 Mar '07

I just installed MonetDB on my linux (Fedora Core 6) system with --enable-sql but mjclient doesn't seem to be in my MonetDB/bin directory (it was there when I installed it on my osx machine). I installed using --cvs=current. I have java installed and can confirm java and javac from the same command line where I issued the monetdb-install command. My install script's version is 1.9. Any ideas?

3 3