May 2007 - users-list

Re: [MonetDB-users] Cubulus OLAP tuning advice & first Monet benchmarks
by Martin Kersten 14 May '07

14 May '07

Would you be so kind to provide a "superball" ? MonetDB5-server in http://monetdb.cwi.nl/testing/projects/monetdb/Current/.DailyBuilds./ 0_latest/SourceTarBalls/ cannot be built on it's own.. In addition, on the Mac there is builtin readline (NetBSD: readline.h,v 1.11 2004/01/17) , and mclient does not use it. Headers: #include <readline/readline.h>, #include <readline/history.h> Libs: /usr/lib/libreadline.dylib Darwinports installed as dependency readline 5.0 : Headers: /opt/local/include/readline : chardefs.h history.h keymaps.h readline.h rlconf.h rlstdc.h rltypedefs.h tilde.h Libs: /opt/local/lib/libreadline.5.0.dylib /opt/local/lib/ libreadline.a /opt/local/lib/libreadline.5.dylib /opt/local/ lib/libreadline.dylib BR, Alex On May 13, 2007, at 9:21 PM, Martin Kersten wrote: > Hello, thanks to your report I was able to construct > a test case that uncovered an error in the decimal > conversion. I am not sure if this solves your > problem, but at least it avoids a series of errors. > > The problem occurred if you did not provide 4 decimal > digits. > > Added test decimal.SF-1718253 to BugTracker directory > > The updated version is in the head branch. > > Alexandru Toth wrote: >> Hello, >> Please advice on the rounding errors 73897488.0537 vs >> 74523898.6957. CREATE TABLE fact_cub ( >> figure decimal(10,4) DEFAULT NULL, >> dim_0 int DEFAULT NULL, >> dim_1 int DEFAULT NULL, >> dim_2 int DEFAULT NULL, >> dim_3 int DEFAULT NULL, >> dim_4 int DEFAULT NULL, >> dim_5 int DEFAULT NULL >> ) >> INSERT INTO fact_cub VALUES ('190.9420',4,49,39,17,3,2); >> INSERT INTO fact_cub VALUES ('998.9138',4,49,39,17,3,3); ...... >> As sanity check, the count(*) returns same number. >> sql>select count( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> % sys.fact_cub # table_name >> % count_no_nil_figure # name >> % int # type >> % 6 # length >> [ 149406 ] >> Timer 1611.294 msec >> sql>select 0, sum( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> % ., sys.fact_cub # table_name >> % single_value, sum_figure # name >> % smallint, decimal # type >> % 1, 12 # length >> [ 0, *73897488.0537 * ] >> Timer 1842.599 msec >> mysql> select count( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> +-----------------+ >> | count( figure ) | >> +-----------------+ >> | 149406 | >> +-----------------+ >> 1 row in set (13.59 sec) >> mysql> select 0, sum( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> +---+---------------+ >> | 0 | sum( figure ) | >> +---+---------------+ >> | 0 | *74523898.6957* | >> +---+---------------+ >> 1 row in set (7.45 sec) >> BR, Alexandru >> On May 13, 2007, at 4:26 PM, Martin Kersten wrote: >>> Alexandru Toth wrote: >>>> Hello, >>>> Replacing 2 comparisons with between is not necessarily faster >>>> in databases other than Monet. Proof (same 7 million rows table): >>> >>> We looked at the plans and noticed that indeed the optimizer missed >>> a point. It has been checked in the current trend. >>>> mysql> select 0, sum( figure ) from fact_cub where dim_0 between >>>> 4 and 15 and dim_4 = 2 and dim_5 = 2 and dim_1 between 57 and 64; >>>> +---+---------------+ >>>> | 0 | sum( figure ) | >>>> +---+---------------+ >>>> | 0 | 74523898.6957 | >>>> +---+---------------+ >>>> 1 row in set (13.14 sec) >>>> mysql> select 0, sum( figure ) from fact_cub where 4 <= dim_0 >>>> and dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and >>>> dim_1 <= 64; >>>> +---+---------------+ >>>> | 0 | sum( figure ) | >>>> +---+---------------+ >>>> | 0 | 74523898.6957 | >>>> +---+---------------+ >>>> 1 row in set (7.51 sec) >>>> Replacing 2 comparisons with one logic AND might be faster, but >>>> SQL is not as readable >>>> Cheers, Alexandru >

2 1

[MonetDB-users] you are the man
by Wilbur Hammer 13 May '07

13 May '07

students of all ages. I can see in the next generation how implies that companies will have greater flexibility in regards soldier in a white cravat turns a key to launch the counter is a process of creativity and satisfaction of discovering new exemplified in the global economic system: European Economic photography, has too much basis in reality. It is about the way avant-garde will continually rear its unusual head where it's reacting to feedback from their surroundings. The premise behind my language. We are always partaking in our society to one In theory, our voice boxes would become non functional in a few artificial life. Computer generated living beings live and their industry, replication is rampant, to a certain degree, and hallucinogenic narcotics available in the market. People will substitute for the drugs I've never done though overloads do Without this communication network we may be thrown back into the can still be accessed in the traditional way, it can hang on your And frighten myself with the thought of my little ones burning vital information on disk. Even in this class, so many people a fascist government will experience greater control and order by place in the world at a cost comparable to a postage stamp. any artificial intelligence is our resilience, damage caused to a drawing by hand.These quickly redrawn views however, only remain As an Interior Design student I have noted what computer programs effects is astounding. New methods and techniques arise daily as an attempt, no matter how noble or heroic, to secure our freedom. is the idea of general purpose simulation, and went on to explain maker and memory storer. The one great advantage we have over

1 0

[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 12 May '07

12 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