- users-list - monetdb.org

[MonetDB-users] Bulk-Load Problem
by algatt 27 Oct '07

27 Oct '07

I am using MonetDB 5.0.0 and 1GB Ram on Windows XP. I am trying to use the TPC-H benchmark. With 1GB of test data everything worked fine, but if I try to load a table with more than 1GB of data the server crashes. Does this happen due to the 1GB of RAM? Also, when I use the number of records with the COPY command it copies more records. Any pointers? Thanks -- View this message in context: http://www.nabble.com/Bulk-Load-Problem-tf4702911.html#a13442730 Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] Very slow group by sql query
by Arjen van der Meijden 22 Oct '07

22 Oct '07

Hi list, I was just doing some basic queries on MonetDB5/SQL to see if it is suitable for my application, I'm doing lots of aggregates on some logfile-abstractions. Basically they all boil down to 'how many unique visitors and total pageviews where there in period X-Y in section Z'. I have this table: pageviews ( timestamp timestamp not null, clientip varchar(15) not null, sectionid smallint not null, itemid integer not null, channelid smallint default 0 ) Currently it only contains data for last september, with about 2M records/day, and 5.6M in total. There are no additional indexes in this case. When doing a query like this, monetdb very fast. Once the data is in the memory cache, it returns (according to trace) in about half a second. select count(*) from pageviews where timestamp between '2007-09-21 00:00:00' and '2007-09-22 00:00:00'; The result is 1916813 This one is also pretty fast, taking about 1.7 second select count(distinct clientip) from pageviews where timestamp between '2007-09-21 00:00:00' and '2007-09-22 00:00:00'; The result is 165700 And the third which is pretty fast: select channelid, count(*) from pageviews where timestamp between '2007-09-21 00:00:00' and '2007-09-22 00:00:00' group by channelid; Here's the distribution, and its returned in about 0.6 second [ 0, 538187 ] [ 1, 1108478 ] [ 4, 42867 ] [ 3, 145565 ] [ 2, 81716 ] But when I combine those last two queries, the result isn't returned in a reasonable amount of time, I waited for more than half an hour and it still hadn't returned the results. select channelid, count(distinct clientip), count(*) from pageviews where timestamp between '2007-09-21 00:00:00' and '2007-09-22 00:00:00' group by channelid; I'm not very good at reading your explain output yet, so I've attached the resulting explain for that query. Is there a way to speed up this type of query? It seems a bit odd that it's taking more than half an hour (postgresql does it in about 20 seconds) while the other queries return much faster (postgresql does them in about 14 seconds). Best regards, Arjen function user.s5_1():void; _1:bat[:oid,:timestamp]{rows=55914459:lng,bid=1968} := sql.bind("sys","pageviews","timestamp",0); _10:bat[:oid,:timestamp]{rows=0:lng,bid=2323} := sql.bind("sys","pageviews","timestamp",1); constraints.emptySet(_10); _10:bat[:oid,:timestamp]{rows=0:lng,bid=2323} := nil; _12:bat[:oid,:timestamp]{rows=0:lng,bid=2324} := sql.bind("sys","pageviews","timestamp",2); constraints.emptySet(_12); _12:bat[:oid,:timestamp]{rows=0:lng,bid=2324} := nil; _17:bat[:oid,:sht]{notnil=true,rows=55914459:lng,bid=1969} := sql.bind("sys","pageviews","channelid",0); _24:bat[:oid,:str]{rows=55914459:lng,bid=1961} := sql.bind("sys","pageviews","clientip",0); _8{rows=27957230:lng} := algebra.uselect(_1,2007-09-21 00:00:00.000,2007-09-22 00:00:00.000,true,true); _1:bat[:oid,:timestamp]{rows=55914459:lng,bid=1968} := nil; _15{rows=27957230:lng} := algebra.markT(_8,0@0); _8{rows=27957230:lng} := nil; _16{rows=27957230:lng} := bat.reverse(_15); _15{rows=27957230:lng} := nil; _19{rows=27957230:lng} := algebra.join(_16,_17); (ext40,grp38):= group.new(_19); _19{rows=27957230:lng} := nil; _22 := bat.mirror(ext40); ext40 := nil; _23 := algebra.joinPath(_22,_16,_17); _17:bat[:oid,:sht]{notnil=true,rows=55914459:lng,bid=1969} := nil; _26{rows=27957230:lng} := algebra.join(_16,_24); _16{rows=27957230:lng} := nil; _24:bat[:oid,:str]{rows=55914459:lng,bid=1961} := nil; (_27,grp55):= group.new(grp38); (_29,grp57):= group.derive(_27,grp55,_26); _27 := nil; grp55 := nil; _31 := bat.mirror(_29); _29 := nil; _32 := algebra.semijoin(_26,_31); _26{rows=27957230:lng} := nil; _31 := nil; _33:bat[:oid,:int] := aggr.count_no_nil(_32,grp38,_22); _32 := nil; _34:bat[:oid,:int] := aggr.count(grp38,grp38,_22); grp38 := nil; _22 := nil; _35 := sql.resultSet(3,1,_23); sql.rsColumn(_35,"sys.pageviews","channelid","smallint",16,0,_23); _23 := nil; sql.rsColumn(_35,"sys.pageviews","count_no_nil_clientip","int",15,0,_33); _33:bat[:oid,:int] := nil; sql.rsColumn(_35,"sys.pageviews","count_channelid","int",32,0,_34); _34:bat[:oid,:int] := nil; sql.exportResult(_35,""); end s5_1;

4 6

[MonetDB-users] Server Crashes when Client is Opened
by algatt 21 Oct '07

21 Oct '07

Hello, I have installed Monet and created the TPC-H schema and populated it with data. Once all data was copied, I restarted the computer to try the queries. However, now the server starts, but when I open the client everything closes immediately. I uninstalled it, and re-installed it and the same happens. Any help? Thank You. Regards, Alan -- View this message in context: http://www.nabble.com/Server-Crashes-when-Client-is-Opened-tf4657643.html#a… Sent from the monetdb-users mailing list archive at Nabble.com.

3 6

[MonetDB-users] delete query with where clause
by pawan123 10 Oct '07

10 Oct '07

When I use without where clause if ((hdl = mapi_query(dbh,"select * from logException )) == NULL || mapi_error(dbh) != MOK) die(dbh, hdl); It is working fine. But when I use with where condition if ((hdl = mapi_query(dbh,"delete * from logException where logid=1 )) == NULL || mapi_error(dbh) != MOK) die(dbh, hdl); It is deleting the record only from memory not from database. -- View this message in context: http://www.nabble.com/delete-query-with-where-clause-tf4598673.html#a131295… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] configure warning
by Ying Zhang 09 Oct '07

09 Oct '07

Hello, During 'configure' of the MonetDB4 module (Stable branch, MonetDB_4-20), I got the warning: configure: WARNING: fcntl.h: present but cannot be compiled configure: WARNING: fcntl.h: check for missing prerequisite headers? configure: WARNING: fcntl.h: see the Autoconf documentation configure: WARNING: fcntl.h: section "Present But Cannot Be Compiled" configure: WARNING: fcntl.h: proceeding with the preprocessor's result configure: WARNING: fcntl.h: in the future, the compiler will take precedence The same warning was given about several other header files, e.g. limits.h, pwd.h, time.h, sys/time.h, utime.h, ... The compilation was finished without further problems, but I would like to know why I got these warnings, since this is something new. Thanks! Jennie

2 1

[MonetDB-users] how to measure a query execution time
by xxiao 08 Oct '07

08 Oct '07

Hi, I need to measure the sql query execution time. So I used "-t" option with mclient command. For example, I use "mclient -lsql -umonetdb -Pmonetdb -t < 15.sql" to execute query 15 in TPC-H benchmark. I have the following outputs: Timer 935.765 msec Timer 717.294 msec Timer 0.163 msec % sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.revenue0 # table_name % s_suppkey, s_name, s_address, s_phone, total_revenue # name % int, varchar, varchar, varchar, decimal # type % 4, 18, 17, 15, 21 # length [ 8449, "Supplier#000008449", "Wp34zim9qYFbVctdW", "20-469-856-8873", 1772627.2087 ] Timer 3559.856 msec Timer 0.079 msec Timer 63.676 msec Timer 0.890 msec % .stats, .stats # table_name % rewrite, count # name % clob, int # type % 7, 1 # length [ "joinidx", 0 ] Timer 1.043 msec There are multiple lines started with "Timer" and ended by a time measurement in milli-sec. So is the execution time of query 15 in TPC-H equal to the sum of all these time measurements. In this case, 935.765+717.294+0.163+3559.856+0.079+63.676+0.890+1.043=5278.766 msec. I appreciate your response. Xiang -- View this message in context: http://www.nabble.com/how-to-measure-a-query-execution-time-tf4588760.html#… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] convert string to timestamp in MonetDB
by pawan123 04 Oct '07

04 Oct '07

is there any function in MonetDB that can convert string (i.e.Thu Oct 04 14:36:17 2007) in to timestamp; Thanks Pawan -- View this message in context: http://www.nabble.com/convert-string-to-timestamp-in-MonetDB-tf4567699.html… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] What is optimizer_stats()
by Pranav Vaidya 03 Oct '07

03 Oct '07

Hi, I am new to MonetDB and I am trying to run the TPC-H benchmarks and I was able to successfully load and execute the benchmarks in MonetDB version 4. I also verified whether the tables were populated using Dbvis. However, what seems to fail is the lack of a function called optimizer_stats() in the run.all script. Is this a procedure or a function defined additionally which is needed. And why is it not present ? Do I need to run some additional scripts to have this run.all script go through successfully without any errors. Thanks and Regards, Pranav. -- View this message in context: http://www.nabble.com/What-is-optimizer_stats%28%29-tf4564307.html#a13027620 Sent from the monetdb-users mailing list archive at Nabble.com.

3 4

[MonetDB-users] (no subject)
by Matt Magoffin 02 Oct '07

02 Oct '07

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@

1 0

[MonetDB-users] how we convert the value of timestamp in minutes
by pawan123 28 Sep '07

28 Sep '07

how we convert the value of timestamp in minutes -- View this message in context: http://www.nabble.com/how-we-convert-the-value-of-timestamp-in-minutes-tf45… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] how we get the timestamp value 10 minutes before from current_timestamp
by pawan123 28 Sep '07

28 Sep '07

how we get the timestamp value 10 minutes before from current_timestamp -- View this message in context: http://www.nabble.com/how-we-get-the-timestamp-value-10-minutes-before-from… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] how to run TPC-H benchmark on MonetDB
by xxiao 27 Sep '07

27 Sep '07

hi, I am a beginner of MonetDB. I want to run TPC-H benchmark on MonetDB. I found there are SQL queries and related files under monetdb source folder <monetdb-source>/sql/src/benchmark/tpch. I ran the script 'run.all'. But that gave me many errors and did not succeed. Can anyone describe briefly the steps I need to carry out in order to run TPC-H benchmark? Any documentations I can refer to is highly appreciated. Thank you. -- View this message in context: http://www.nabble.com/how-to-run-TPC-H-benchmark-on-MonetDB-tf4524693.html#… Sent from the monetdb-users mailing list archive at Nabble.com.

4 5

[MonetDB-users] minus 10 minutes from current_timestamp
by pawan123 27 Sep '07

27 Sep '07

how we minus 10 minutes from current_timestamp. because i have to fetch all the records from a table 10 minutes before currenttimestamp. so pls tell me how we deternine 10 min before timestamp value. Thanks pawan -- View this message in context: http://www.nabble.com/minus-10-minutes-from-current_timestamp-tf4526685.htm… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] I want to select records from MonetDB
by pawan123 25 Sep '07

25 Sep '07

I want to select records from a table on the basis of date in MonetDB and then insert all these selected records in a table i.e. present in oracle using C or Pro*C. can any one help me in writing the code. Thanks in advance. Pawan -- View this message in context: http://www.nabble.com/I-want-to-select-records-from-MonetDB-tf4514715.html#… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Database tool
by Venks 25 Sep '07

25 Sep '07

Hi, What's the good database tool that I can use to connect to MonetDB, run queries and browse the objects? I used to use DBVisualizer earlier and now both 5.1.1 and 6.0.x version are giving errors. I installed the latest version of the MonetDB couple of weeks ago and I think the changes in the new version of MonetDB (JDBC) are causing these issues. Thanks, -Venks

3 2

[MonetDB-users] building client on Windows
by Sander Kruseman 24 Sep '07

24 Sep '07

Hi, I want to construct a Monet client app in C on Windows but find very sparse info on this. I took notice of the fact that Windows is apparently not exactly Monet's main target platform. Still, I tried using nmake on the client sources but ran into errors involving missing (or incorrectly placed) files (see below). Do I really have to go through the complete 'Experts > Windows Installation', i.e. building MonetDB server itself? regards, Sander ...\clients-1.18.2\src\mapilib>nmake -f makefile.msc Microsoft (R) Program Maintenance Utility Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. makefile.msc(8) : fatal error U1052: file '.\..\..\rules.msc' not found

2 1

[MonetDB-users] Cannot manipulate XML Document
by Timothy Marc 24 Sep '07

24 Sep '07

Hello all, I've downloaded MonetDB XQuery for evaluating the XQuery Update Facility. I've shredderd a document and can perform xqueries from MapiClient successfully. But, when i try to update a document, the process fails with error message: !ERROR updating read-only document. May i have to specify some flags or something else??? Thx Timothy

2 1

[MonetDB-users] can we create cache group in MonetDB
by pawan123 24 Sep '07

24 Sep '07

all we know about Timesten Database with oracle. can we use this MonetDB like Timesten Database with oracle.means can we create cache group in MonetDB. Thanks Pawan -- View this message in context: http://www.nabble.com/can-we-create-cache-group-in-MonetDB-tf4492681.html#a… Sent from the monetdb-users mailing list archive at Nabble.com.

3 3

[MonetDB-users] can we create cache group in MonetDB
by Pawan Kumar Gupta 21 Sep '07

21 Sep '07

all we know about Timesten Database with oracle. can we use this MonetDB like Timesten Database with oracle.means can we create cache group in MonetDB. Thanks Pawan

1 0

[MonetDB-users] Persistent Stored Modules and a SQL issue
by Venks 18 Sep '07

18 Sep '07

Two questions. 1. Can I execute a dynamic DDL statement using PSM? 2. I am trying to create a script where I would like to DROP A TABLE before re-creating it. If I include the DROP TABLE in the script, MonetDB throws an error and STOPs execution if the table is not found. This is rather painful as I would like MonetDB to continue with the next SQL command. For. e.g DROP TABLE table1 ; CREATE TABLE table1 .... If I include the above 2 commands in one script, then the above scripts stops execution if "table1" doesn't exists. Thanks, -Venks

2 3

[MonetDB-users] MonetDB vs MySQL naive benchmark.
by Dan Libby 16 Sep '07

16 Sep '07

Hi, I just downloaded and started experimenting with MonetDB today. We have a large PHP/mysql app that runs millions of small/simple queries to generate various reports. (It needs to be refactored, but that is hard). Anyway, for starters, I wrote a very small/stupid benchmark script for both monetdb and mysql. I expected monetdb to be slower at populating the table, and faster at selecting from it, but it was slower at both. So below I am presenting my results, and my php scripts, and I would be very interested to know if there is a problem in my methodology, or if I should be running certain types of queries that monetdb will excel at. Mysql Results: -------------- $ php testmysql.php MySQL Test Dropping previous table (if present) Dropped in 0.000669 seconds creating table Created in 0.007732 seconds populating table Populated in 1.163141 seconds selecting from table queried 10000 records in 1.446646 seconds MonetDB Results: ---------------- $ php testmonet.php MonetDB Test Dropping table Dropped in 0.039597 seconds creating table Created in 0.001858 seconds populating table Populated in 7.513073 seconds selecting from table Queried 10000 records in 2.680834 seconds One interesting thing I noticed is that if I did not include the primary key index on the where-clause column, then mysql took ~80 seconds, and Monet still took about ~2.5 seconds. I guess this is because Monet just uses user-specified indexes as hints, so it had really created one anyway, yes? Anyway, here are the PHP scripts I used: testmonet.php ---------------- <?php echo "MonetDB Test\n"; $db = @monetdb_connect('sql', 'localhost', 50000, 'monetdb', 'monetdb') or die('Failed to connect to MonetDB<br>'); echo "Dropping table\n"; $start_time = microtime(true); $sql = "drop table big_table;"; $res = monetdb_query($sql); echo sprintf( "Dropped in %f seconds\n\n", microtime(true) - $start_time); echo "creating table\n"; $start_time = microtime(true); $sql = "create table big_table( col1 int primary key, col2 varchar(20), col3 int, col4 varchar(20) );"; $res = monetdb_query($sql) or die ("failed to create table" ); echo sprintf( "Created in %f seconds\n\n", microtime(true) - $start_time); echo "populating table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "insert into big_table values ($i, 'col2 $i', $i, 'col4 $i' )"; $res = monetdb_query( $sql ) or die ("failed to insert at row $i " ); } echo sprintf( "Populated in %f seconds\n\n", microtime(true) - $start_time); echo "selecting from table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "select col1 from big_table where col1 = $i"; $res = monetdb_query($sql); while ( $row = monetdb_fetch_assoc($res) ) { // print_r($row); } } echo sprintf( "Queried 10000 records in %f seconds\n\n", microtime(true) - $start_time); ?> testmysql.php ---------------- <?php echo "MySQL Test\n"; $db = @mysql_connect('localhost', 'root', '', 'monetdb') or die('Failed to connect to MySQL<br>'); mysql_select_db( "perftest" ) or die ("Failed to select DB" ); echo "Dropping previous table (if present)\n"; $start_time = microtime(true); $sql = "drop table big_table"; $res = mysql_query($sql); echo sprintf( "Dropped in %f seconds\n\n", microtime(true) - $start_time); echo "creating table\n"; $start_time = microtime(true); $sql = "create table big_table( col1 int primary key, col2 varchar(20), col3 int, col4 varchar(20) );"; $res = mysql_query($sql) or die ("failed to create table" ); echo sprintf( "Created in %f seconds\n\n", microtime(true) - $start_time); echo "populating table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "insert into big_table values ($i, 'col2 $i', $i, 'col4 $i' )"; $res = mysql_query( $sql ) or die ("failed to insert at row $i " ); } echo sprintf( "Populated in %f seconds\n\n", microtime(true) - $start_time); echo "selecting from table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "select col1 from big_table where col1 = $i"; $res = mysql_query($sql); while ( $row = mysql_fetch_assoc($res) ) { // print_r($row); } } echo sprintf( "queried 10000 records in %f seconds\n\n", microtime(true) - $start_time); ?> </body> </html>

3 4

[MonetDB-users] MonetDB vs MySQL naive benchmark.
by Dan Libby 16 Sep '07

16 Sep '07

Hi, I just downloaded and started experimenting with MonetDB today. We have a large PHP/mysql app that runs millions of small/simple queries to generate various reports. (It needs to be refactored, but that is hard). Anyway, for starters, I wrote a very small/stupid benchmark script for both monetdb and mysql. I expected monetdb to be slower at populating the table, and faster at selecting from it, but it was slower at both. So below I am presenting my results, and my php scripts, and I would be very interested to know if there is a problem in my methodology, or if I should be running certain types of queries that monetdb will excel at. Mysql Results: -------------- $ php testmysql.php MySQL Test Dropping previous table (if present) Dropped in 0.000669 seconds creating table Created in 0.007732 seconds populating table Populated in 1.163141 seconds selecting from table queried 10000 records in 1.446646 seconds MonetDB Results: ---------------- $ php testmonet.php MonetDB Test Dropping table Dropped in 0.039597 seconds creating table Created in 0.001858 seconds populating table Populated in 7.513073 seconds selecting from table Queried 10000 records in 2.680834 seconds One interesting thing I noticed is that if I did not include the primary key index on the where-clause column, then mysql took ~80 seconds, and Monet still took about ~2.5 seconds. I guess this is because Monet just uses user-specified indexes as hints, so it had really created one anyway, yes? Anyway, here are the PHP scripts I used: testmonet.php ---------------- <?php echo "MonetDB Test\n"; $db = @monetdb_connect('sql', 'localhost', 50000, 'monetdb', 'monetdb') or die('Failed to connect to MonetDB<br>'); echo "Dropping table\n"; $start_time = microtime(true); $sql = "drop table big_table;"; $res = monetdb_query($sql); echo sprintf( "Dropped in %f seconds\n\n", microtime(true) - $start_time); echo "creating table\n"; $start_time = microtime(true); $sql = "create table big_table( col1 int primary key, col2 varchar(20), col3 int, col4 varchar(20) );"; $res = monetdb_query($sql) or die ("failed to create table" ); echo sprintf( "Created in %f seconds\n\n", microtime(true) - $start_time); echo "populating table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "insert into big_table values ($i, 'col2 $i', $i, 'col4 $i' )"; $res = monetdb_query( $sql ) or die ("failed to insert at row $i " ); } echo sprintf( "Populated in %f seconds\n\n", microtime(true) - $start_time); echo "selecting from table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "select col1 from big_table where col1 = $i"; $res = monetdb_query($sql); while ( $row = monetdb_fetch_assoc($res) ) { // print_r($row); } } echo sprintf( "Queried 10000 records in %f seconds\n\n", microtime(true) - $start_time); ?> testmysql.php ---------------- <?php echo "MySQL Test\n"; $db = @mysql_connect('localhost', 'root', '', 'monetdb') or die('Failed to connect to MySQL<br>'); mysql_select_db( "perftest" ) or die ("Failed to select DB" ); echo "Dropping previous table (if present)\n"; $start_time = microtime(true); $sql = "drop table big_table"; $res = mysql_query($sql); echo sprintf( "Dropped in %f seconds\n\n", microtime(true) - $start_time); echo "creating table\n"; $start_time = microtime(true); $sql = "create table big_table( col1 int primary key, col2 varchar(20), col3 int, col4 varchar(20) );"; $res = mysql_query($sql) or die ("failed to create table" ); echo sprintf( "Created in %f seconds\n\n", microtime(true) - $start_time); echo "populating table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "insert into big_table values ($i, 'col2 $i', $i, 'col4 $i' )"; $res = mysql_query( $sql ) or die ("failed to insert at row $i " ); } echo sprintf( "Populated in %f seconds\n\n", microtime(true) - $start_time); echo "selecting from table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "select col1 from big_table where col1 = $i"; $res = mysql_query($sql); while ( $row = mysql_fetch_assoc($res) ) { // print_r($row); } } echo sprintf( "queried 10000 records in %f seconds\n\n", microtime(true) - $start_time); ?> </body> </html>

2 3

[MonetDB-users] [Newbie] sizeof(ssize_t) error on Solaris 10
by Pranav Vaidya 13 Sep '07

13 Sep '07

Hello, I am trying to install MonetDB on Solaris 10/UltraSparc III and Fedora6/AMD. I tried running monetdb-install.sh as suggested in the documentation. The Fedora installation went on fine without any hitches. However, the solaris 10 installation failed. The script is failing due to some error on the test which determines sizeof(ssize_t). To see if there was some problem in my sys/types.h I compiled and executed a code which I think is used by the configure script. This test program ran without any issues writing a value of 4 to the conftest.val file. My guess is ssize_t is typedefd as an int on my machine. The test program is as follows : #include <stddef.h> #include <sys/types.h> long longval () { return (long) (sizeof (ssize_t)); } unsigned long ulongval () { return (long) (sizeof (ssize_t)); } #include <stdio.h> #include <stdlib.h> int main () { FILE *f = fopen ("conftest.val", "w"); if (! f) exit (1); if (((long) (sizeof (ssize_t))) < 0) { long i = longval (); if (i != ((long) (sizeof (ssize_t)))) exit (1); fprintf (f, "%ld\n", i); } else { unsigned long i = ulongval (); if (i != ((long) (sizeof (ssize_t)))) exit (1); fprintf (f, "%lu\n", i); } exit (ferror (f) || fclose (f) != 0); ; return 0; } I am attaching the relevant portion of the config.log that is produced. I would appreciate any inputs on how to resolve this issue and why it arises. ------------------------------------------------------------------------------------------------------------------------------------------------------ #include <sys/types.h> | | long longval () { return (long) (sizeof (ssize_t)); } | unsigned long ulongval () { return (long) (sizeof (ssize_t)); } | #include <stdio.h> | #include <stdlib.h> | int | main () | { | | FILE *f = fopen ("conftest.val", "w"); | if (! f) | exit (1); | if (((long) (sizeof (ssize_t))) < 0) | { | long i = longval (); | if (i != ((long) (sizeof (ssize_t)))) | exit (1); | fprintf (f, "%ld\n", i); | } | else | { | unsigned long i = ulongval (); | if (i != ((long) (sizeof (ssize_t)))) | exit (1); | fprintf (f, "%lu\n", i); | } | exit (ferror (f) || fclose (f) != 0); | | ; | return 0; | } configure:26151: error: cannot compute sizeof (ssize_t), 77 See `config.log' for more details. The following is the configure output - MonetDB>./configure checking build system type... sparc-sun-solaris2.10 checking host system type... sparc-sun-solaris2.10 checking target system type... sparc-sun-solaris2.10 checking for a BSD-compatible install... /usr/local/bin/ginstall -c checking whether build environment is sane... yes checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for style of include used by make... GNU checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking dependency style of gcc... none checking for egrep... egrep checking for ANSI C header files... no checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking how to run the C preprocessor... gcc -E checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ANSI C... (cached) none needed checking dependency style of gcc... (cached) none checking for long... yes checking size of long... 4 checking whether byte ordering is bigendian... yes checking if your compiler is C99 compliant... yes checking for ant... no checking for java... /bin/java checking for Java >= 1.4, but < 1.6... yes -> 1.5.0_12 found checking for javac... /bin/javac checking for jar... /bin/jar checking for javadoc... /bin/javadoc checking for a sed that does not truncate output... /usr/local/bin/gsed checking for option to reload object files... -r checking for BSD-compatible nm... /usr/local/bin/nm -B checking whether ln -s works... yes checking how to recognise dependent libraries... pass_all checking dlfcn.h usability... no checking dlfcn.h presence... yes configure: WARNING: dlfcn.h: present but cannot be compiled configure: WARNING: dlfcn.h: check for missing prerequisite headers? configure: WARNING: dlfcn.h: see the Autoconf documentation configure: WARNING: dlfcn.h: section "Present But Cannot Be Compiled" configure: WARNING: dlfcn.h: proceeding with the preprocessor's result configure: WARNING: dlfcn.h: in the future, the compiler will take precedence configure: WARNING: ## --------------------------- ## configure: WARNING: ## Report this to monet(a)cwi.nl ## configure: WARNING: ## --------------------------- ## checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... none checking how to run the C++ preprocessor... g++ -E checking for g77... g77 checking whether we are using the GNU Fortran 77 compiler... yes checking whether g77 accepts -g... yes checking for flex... flex checking lex output file root... lex.yy checking whether yytext is a pointer... no checking for a BSD-compatible install... /usr/local/bin/ginstall -c checking for ld used by gcc... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking the maximum length of command line arguments... 262144 checking command to parse /usr/local/bin/nm -B output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc static flag -static works... no checking if gcc supports -c -o file.o... yes checking whether the gcc linker (/usr/ccs/bin/ld) supports shared libraries... yes checking whether -lc should be explicitly linked in... yes checking dynamic linker characteristics... solaris2.10 ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking for shl_load... no checking for shl_load in -ldld... no checking for dlopen... yes checking whether a program can dlopen itself... yes checking whether a statically linked program can dlopen itself... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... no configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ static flag -static works... no checking if g++ supports -c -o file.o... yes checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.10 ld.so checking how to hardcode library paths into programs... immediate appending configuration tag "F77" to libtool checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... no checking for g77 option to produce PIC... -fPIC checking if g77 PIC flag -fPIC works... yes checking if g77 static flag -static works... no checking if g77 supports -c -o file.o... yes checking whether the g77 linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.10 ld.so checking how to hardcode library paths into programs... immediate checking for ANSI C header files... (cached) no checking whether time.h and sys/time.h may both be included... yes checking for dirent.h that defines DIR... yes checking for library containing opendir... none required checking alloca.h usability... no checking alloca.h presence... yes configure: WARNING: alloca.h: present but cannot be compiled configure: WARNING: alloca.h: check for missing prerequisite headers? configure: WARNING: alloca.h: see the Autoconf documentation configure: WARNING: alloca.h: section "Present But Cannot Be Compiled" configure: WARNING: alloca.h: proceeding with the preprocessor's result configure: WARNING: alloca.h: in the future, the compiler will take precedence configure: WARNING: ## --------------------------- ## configure: WARNING: ## Report this to monet(a)cwi.nl ## configure: WARNING: ## --------------------------- ## checking for alloca.h... yes checking getopt.h usability... no checking getopt.h presence... yes configure: WARNING: getopt.h: present but cannot be compiled configure: WARNING: getopt.h: check for missing prerequisite headers? configure: WARNING: getopt.h: see the Autoconf documentation configure: WARNING: getopt.h: section "Present But Cannot Be Compiled" configure: WARNING: getopt.h: proceeding with the preprocessor's result configure: WARNING: getopt.h: in the future, the compiler will take precedence configure: WARNING: ## --------------------------- ## configure: WARNING: ## Report this to monet(a)cwi.nl ## configure: WARNING: ## --------------------------- ## checking for getopt.h... yes checking netdb.h usability... no checking netdb.h presence... yes configure: WARNING: netdb.h: present but cannot be compiled configure: WARNING: netdb.h: check for missing prerequisite headers? configure: WARNING: netdb.h: see the Autoconf documentation configure: WARNING: netdb.h: section "Present But Cannot Be Compiled" configure: WARNING: netdb.h: proceeding with the preprocessor's result configure: WARNING: netdb.h: in the future, the compiler will take precedence configure: WARNING: ## --------------------------- ## configure: WARNING: ## Report this to monet(a)cwi.nl ## configure: WARNING: ## --------------------------- ## checking for netdb.h... yes checking for sys/types.h... (cached) yes checking for special C compiler options needed for large files... no checking for _FILE_OFFSET_BITS value needed for large files... no checking for _LARGE_FILES value needed for large files... no checking for an ANSI C-conforming const... yes checking for size_t... no checking return type of signal handlers... int checking for ptrdiff_t... yes checking for ssize_t... yes checking for __int64... no checking for long long... no checking for char... no checking size of char... 0 checking for short... no checking size of short... 0 checking for int... no checking size of int... 0 checking for long... (cached) yes checking size of long... (cached) 4 checking for void *... no checking size of void *... 0 checking for size_t... (cached) no checking size of size_t... 0 checking for ssize_t... (cached) yes checking size of ssize_t... configure: error: cannot compute sizeof (ssize_t), However, I think the problem is somewhere above this line as I was getting sizeof(char), sizeof (long long) as zeros. Kindly guide me as I am a relative newbie to MonetDB. Thanks in advance, Pranav. -- View this message in context: http://www.nabble.com/-Newbie--sizeof%28ssize_t%29-error-on-Solaris-10-tf44… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] [newbie] Loading a directory of XML files into a collection
by Philip Webster 11 Sep '07

11 Sep '07

Hi, I have a directory containing XML files, all sharing a common structure. I want to load them all into a collection so I can run queries against them using the XQuery interface in MonetDB4. The tutorials give useful examples that show how to load a single file into a collection, but I need an automated process to load all of the XML files I have. There are over 60,000 files, currently spread over 16 directories to make them more managable. I've been looking around on the Web, but I haven't found any XQuery examples that do what I want. Is it possible? If so, can anyone give an example to show me how to load my data? Thanks, Phil -- View this message in context: http://www.nabble.com/-newbie--Loading-a-directory-of-XML-files-into-a-coll… Sent from the monetdb-users mailing list archive at Nabble.com.

2 3

[MonetDB-users] Not responding after sql server restart
by Franco Guidoli 11 Sep '07

11 Sep '07

Hi all: I'm trying to measure the response time of MonetDB against a commercial RDBMS, so I've made a dump of the data from my current database in order to load into MonetDB. I have approximately 2.6 million rows, divided into 26 flat files of 100k rows each one, which I load using then SQL command "copy into....". Everything works ok with the data load (performing a commit after each 100k file), and I can make use of that data in the same session from which I've loaded the data, but when I restart MonetDB Server, I can't login via SQL (I can start MonetDB Server, but SQL Client doesn't respond). Apparently, from what I can realize, after the shutdown of MonetDB Server, there is a big log file in Monet's sql_logs directory, and when I get a response from SQL Client, the log file is apparently empty (I've realized this loading only 200k rows). Is this the expected behaviour for the MonetDB SQL Server? Did I miss anything in order to avoid this? After the second start of the server, this doesn't happen anymore until I load new data. I'm working with MonetDB Server v5.0.0_beta1_2 (downloaded msi from sourceforge) over Windows XP, and the SQL Client is via JDBC. Thanks in advance for any help you can give me. Franco -- View this message in context: http://www.nabble.com/Not-responding-after-sql-server-restart-tf3762198.htm… Sent from the monetdb-users mailing list archive at Nabble.com.

5 4

[MonetDB-users] Super Source Ball release update
by Martin Kersten 07 Sep '07

07 Sep '07

A glitch in maintaining the monetdb website led to an outdated link for the super source ball on the download page. This tarball is a convenience package containing all source tars and a script (for Linux) to build components. The link has been updated to the latest version: http://downloads.sourceforge.net/monetdb/MonetDB-Mars-SuperBall-SR3.tar.bz2 The MonetDB Development team

1 0

[MonetDB-users] Announcement: various new packages released
by Sjoerd Mullender 06 Sep '07

06 Sep '07

Today the MonetDB group at CWI have a released bug-fix release for a number of packages. The release contains source tar balls, source RPMs, and i686 and x86_64 (AMD64) binaries for Fedora 7 (RPMs) and Windows XP (.msi files). All files are available on the project download page at sourceforge. The packages and changes are: MonetDB Common 1.18.2. On Windows the indexing service would occasionally interfere with the workings of the server. This was because the indexing service would temporarily prevent files and directories from being removed. This problem has been circumvented. In addition, some minor fixes were made. MonetDB Clients 1.18.2. A memory leak was repaired. MonetDB4 Server 4.18.2. A number of small bugs were fixed. The most important one probably the handling of aggregate. MonetDB XQuery 0.18.4. A bug was fixed in the MIL code generation phase for larger queries. [ 1771532 ] MIL-optimizer fails sometimes for big queries [ 1760168 ] PF: wrong use of leftfetchjoin causes segfault in bat_cast A bug was fixed where BATs were not destroyed that should have been. [ 1763495 ] XQ: illegal offsets in swizzle (2) [ 1766414 ] XQ: third pf-add into collection fails [ 1763575 ] XQ: insert attribute gives ERROR in merged_union [ 1760811 ] XQ: illegal offsets in swizzle. [ 1726954 ] XQuery: inserting (large) doc into other doc A bug was fixed when serializing comments. [ 1743433 ] XQ: problem with ampersand in attribute value [ 1786908 ] SQL+PF: loading both "sql_server" and "pathfinder" fails -- Sjoerd Mullender

1 0

[MonetDB-users] How to select random resords from MonetDB
by lonefs 31 Aug '07

31 Aug '07

How to select random resords from MonetDB? Thanks! lonefs 2007-08-30

2 2

[MonetDB-users] Announcement: MonetDB-SQL 2.18.2 Released
by Sjoerd Mullender 29 Aug '07

29 Aug '07

Today the MonetDB group at CWI have released a bug-fix release of the SQL backend. This release is version 2.18.2, and is now available at monetdb.sourceforge.net. The release consists of a source tar ball, a source RPM, and binaries for Fedora 7 (RPMs, for both i386 and x86_64) and for Windows (also for i386 and x86_64--created on Windows XP). -- Sjoerd Mullender

1 0

[MonetDB-users] monetdb5 and pathfinder?
by Oliver Oli 21 Aug '07

21 Aug '07

will pathfinder work on monetdb5, too?

2 1

[MonetDB-users] Converts the value of the specified 16-bit signed integer to an equivalent double-precision floating point number.
by Jari Kulmala 21 Aug '07

21 Aug '07

H+E.R+E WE GO A_GAIN! T+H+E B.I,G O'N_E BEFOR*E T+H*E SEPTEMB,*ER.RALLY! T,H.E MAR.KET IS ABO UT TO P+O-P-, A+N.D SO IS E,X'M_T*! T.ick: E,X+M_T 5-da,y potent-i,al: 0.._4*0 F+irm: EX_C+HANGE MOBIL_E T'E L_E (Ot*her O_T*C': EX*MT.PK) A*s'k': 0,.+1,0 (,+25.-00%) UP TO 2.5,% in 1 day N o-t o+n+l*y d+o e,s t+h.i.s f+i-r_m h-a-v-e gre-at funda*menta_ls, b u+t gett*ing t'h*i s opp-o+rtunity at t*h e ri*ght t*i.m.e', ri.ght befo_re t,h,e rall y is w+h,a-t ma+kes t,h i.s d e_a.l so s.weet! T*h.i's a grea't opportu-*nity to at le+ast doubl'e up! Edd ie w-a.s t,h-e.n a juni,or tec h-nician a n+d gen.eral,ly be l_ieved in ev_eryth'ing exc+ept G_o*d-. If t*h e wPara_m p*a,rameter is -'1 , t*h e curren*t l+i.n e num,ber ('t h,e l-i.n.e t+h-a,t c ontai,ns t-h.e caret_) is u*s-e d,. T+h'e t'h*a*t is t,h.e remain*de*r afte*r divi+din,g by. T-h+e d-efault be_ha+vior f+o-r th+ese signa,ls is to caus*e pro.gram ter'minatio'n. Y o,u mus.t, y.o_u must-V He gra_bbed h o*l*d of M*o-m'o a n d s hook h.e'r-.

1 0

[MonetDB-users] --SET options for mserver5
by Venks 20 Aug '07

20 Aug '07

Where can I find all the --SET options/variables of "mserver5"? Thanks, -Venks

3 3

[MonetDB-users] SPAM?!
by oliver oli 20 Aug '07

20 Aug '07

have yo thought about moving the list to some provider which deals better with spam? like google-groups...

5 5

[MonetDB-users] question
by nguyen-hoang.tung＠cyber-net.de 20 Aug '07

20 Aug '07

1 0

[MonetDB-users] I cant believe you talked me into taking these pictures, hehe. I hope you like em.
by henrygd＠tuneswell.com 20 Aug '07

20 Aug '07

click http://208.120.45.254/

1 0

[MonetDB-users] Stock
by dalejr_rules＠laoagnet.com 20 Aug '07

20 Aug '07

1 0

[MonetDB-users] Honey, i miss you. let me show you how much. I took some pictures for you. see?
by keithknoble＠fnbnet.net 20 Aug '07

20 Aug '07

click http://124.28.114.55/

1 0

[MonetDB-users] Specify only the main part of the filename.
by quynh Camphorst 19 Aug '07

19 Aug '07

H.E R'E WE GO AGAI_N! T H E B.I*G O*N+E B'EFORE T-H E SEPT.EMBER.R_ALLY! T.H'E MA.RKET IS AB.OUT TO P*O P*, A+N D SO IS E'X-M*T_! Ti_ck: E,X_M+T 5.-day po.tentia-l: 0..*4.0 F.irm: EXCH_*ANGE MOB+ILE T'E+L_E (Oth er O*T'C': EXMT._PK) A-s k : 0+.-1-0 (+2,-5.00%) UP TO 2.5'% in 1 day N-o*t o,n+l y d+o-e's t h,i+s f.i-r_m h-a+v-e grea t fundam*en*tals, b_u.t gett+ing t-h_i+s oppo,rtunit.y at t h.e ri+ght t'i m_e,, rig ht bef_ore t'h-e ra_lly is w h'a,t m.akes t_h*i s d*e.a-l so sw_eet! T h*i s a g.reat o pportun,ity to at lea.st dou+ble up! T h.e gre_at major _ity of t+h+e proc,-urement organs*, t-h.e pro*v*iders of i+nform_ation, a*r,e cont..rolled by t.h-e firs,t d_eputy c_hief of t h_e G,R U*. S*h,e g*o,t o_u t on t-h*e b.oul.evard a'n'd w_alked e_a.s+t a.n.d rea_ched t-h'e e ntran-ce of T h_e B'l,u e Mir*ror. However_+, in ord,er to u*s e t-h.i*s in.f*ormation, y'o.u w*i l.l n.e,e+d s*pecial softw'a*re w_hich c-a,n co*llect a.n*d proces+s it. TLM DRichStora*ge Storag*e compo*nen't f+o r Ric-h'Text Item,s. He h,a d vi_sited t'h*e court-s of alm'ost ever_y land,, tra,v'eled w_i.t+h a smal'l li_bra_ry, a'n*d w.o'n or l.o*s't gam.bli'ng w*i't+h t+h.e s-a_m,e e-a*s y smile .

1 0

[MonetDB-users] You fleeting foam, the salt of the sea.
by mehgan Evensen 18 Aug '07

18 Aug '07

T'H.E B.I_G O.N E BEF'ORE T+H E SE'PTEMBE R.RALLY! H.E+R-E WE GO A*GAIN! T+H.E MARKE.T IS A*BOUT TO P_O*P-, A.N*D SO IS E-X'M T*! Tic*k: E X+M'T Fir,m: EX- CHANGE MO,BILE T,E*L'E (O,ther O+T*C,: EXMT..PK) 5-+day pot-ent,ial: 0 .'4-0 A_s+k': 0+.'1'0 (+*25.00,%) (_U.P TO 2-5_% in 1 d'a-y') N o,t o_n.l y d*o.e,s t'h i,s f.i*r+m h a'v,e grea't fundamen t-als, b'u+t get+ting t+h*i's opport..unity at t.h e r.ight t'ime, ri*ght be+fore t.h-e ra_lly is w+h-a+t ma+kes t+h i.s d*e-a*l so sw_eet! T+h i.s a g'reat opportunit,-y to at lea-st do_uble up! There+'s a l_a*w f'i.r+m in Lo+ndon kee,ps tr ack of thei_r powe rs of atto r,ney. T.h'a_t w_a's proo*f en_ough t+h.a,t he w_a+s him,self. N.i.e ze wspolc zucie_m - a z litosc-.ia i zg+roza. T*h e b+arrel shoo'k as he lean_ed h_i.s sh.oul-ders agai nst i't*, a n.d I w.a.s j.u-s_t a_bout to j_u.m+p up w+h'e'n t+h-e m,a.n b egan to spe-ak. I dec,ided t+h'a,t Schw+a-mbrania a.n+d A+tlanti_s mig+ht be+come f_rie_ndly na.tions afte*r a'l l+.

1 0

[MonetDB-users] Contains information about the current user preferences.
by Philippe henneberque 18 Aug '07

18 Aug '07

H*E.R+E WE GO A+GAIN! T*H,E B_I'G O+N E B-EFORE T.H-E SEPTEMBER.* RALLY! T,H'E MARK+ET IS ABOU.T TO P'O+P,, A-N D SO IS E*X_M,T.! Firm.: EXCH*AN GE MOBIL*E T_E+L E (Oth,er O_T-C : EXMT.PK*) Tick*: E,X,M,T A.s,k': 0,._1*0 (-'+25.00%) (*U*P TO 2+5+% in 1 d,a+y+) 5-d+ay p_o*tential: 0+.+4'0 T.h-i+s a gre+at opport-unit y to at l east doubl e up! N.o,t o,n_l'y d.o.e.s t,h i-s f+i-r m h'a.v+e gre+at fun,d.amentals, b-u-t g'etting t h,i_s op'po-rtunity at t*h'e righ+t tim*e, r*ight b_efore t*h'e ral'ly is w-h_a,t m*akes t+h'i-s d_e'a.l so swe-et! W*atch it s_o_a r_! Expl'oit no 1 F-o.r t_h-e r'e,s*t of t*h+e article.-, I w.i'l_l ass.ume t'h,a-t t-h_e vul nerabl,e p*rogram we att_ack u-s,e_s strc.py or spri_ntf. T'w-o l-arge peopl_e fig+htin,g, scr+ea+ming. Or it m*ight be a s_e.p t f*r-o-m t+h+e Gosh.ien. Cousin*, a+l l h_onour to t_h+e*e.. A p.ointer to t'h+e req uest,ed int'erface,.

1 0

[MonetDB-users] Apache (on Unix) is a pre-forking model server.
by Hiten dfv 18 Aug '07

18 Aug '07

H_E_R*E WE GO AGAIN*! T_H'E B,I'G O_N.E BE_FORE T,H*E SEPTEMBER..*RALLY! T'H+E MARK'ET IS A,BOUT TO P-O P., A_N.D SO IS E'X'M T-! F.irm: EXCH.AN+GE M.OBILE T'E.L'E (Oth-er O*T*C': EXMT.PK') Tick,: E'X,M*T A+s-k*: 0+.,0'8 5--day p'otential': 0+.-4+0 T*h+i.s a g+reat op,p_ortunity to at l'east d+ouble up! N+o t o-n.l-y d+o.e-s t*h.i,s f,i-r,m h_a,v*e gre'at fundamen.tals-, b.u't gettin_g t h*i's oppor_tun+ity at t h'e ri'ght ti.me, ri,ght befor e t.h.e r,ally is w h+a+t make+s t h,i,s d_e-a_l so sw eet! Wat-ch it s'o_a-r ! T+h_e n-e*w,s repo rt o'v e_r at L inux Tod_ay in _cludes e,v+e-n m+o-r e inf,orma-tion, inclu d_ing n+e,w*s t,h,a,t Googl'e Ear_th f-o*r Linu.x is planne*d as w,e,l'l . T,h_e K_ing's T+w.o Bodi es. He w+a_s d,o*w+n a-n d o+u+t-. A n'd I'',m n-o t p.a*i-d to abus_e t,h e c*o*p-y mac.hin'es. Cl_ass m.e'n-u Sp*ecifi'es t'h+e de+fault m*e'n+u u+s.e.d f o_r a*n-y win.dow in t,h,e c'lass t_h.a+t d+o e-s n-o*t exp'licit_ly def+ine a m'e,n'u,.

1 0

[MonetDB-users] NOT operator
by Pradeep Gowda 17 Aug '07

17 Aug '07

How to use NOT operator in Monet? In Postgresql: testdb=# create table nntest(alive boolean); CREATE TABLE testdb=# insert into nntest(alive) values(False); INSERT 0 1 testdb=# select not n.alive from nntest n; ?column? ---------- t (1 row) The same in MonetDB gives: sql>select not n.alive from nntest n; ERROR = !syntax error, unexpected FROM in: "select not n.alive from" -- Home: http://btbytes.com Heart: http://sampada.net

1 0

[MonetDB-users] selecting with keywords as column names
by Pradeep Gowda 17 Aug '07

17 Aug '07

Hi, I'm trying to write SQLALchemy wrapper for MonetDB. For the introspection part, I need a query something like this: SELECT c.name AS attname, c.type AS format_type, c.default, c.null as attnotnull, c.number as attnum, c.id AS oid FROM columns C WHERE c.table_id=9782; Obviously, the problem with the above is, there are keywords like default, null, type etc., How do I make the above query work? The intended output (taken from PG): ---expected output (taken from postgrsql) attname | format_type | default | attnotnull | attnum | table_oid --------------+-----------------------+-------------------------------------+------------+--------+----------- student_id | integer | nextval('student_id_seq'::regclass) | t | 1 | 16399 student_name | character varying(80) | | t | 2 | 16399 school_id | integer | | t | 3 | 16399 Regards, Pradeep -- Home: http://btbytes.com Heart: http://sampada.net

2 1

[MonetDB-users] Very magic stick
by Alexandria Boone 17 Aug '07

17 Aug '07

1 0

[MonetDB-users] (no subject)
by jump 17 Aug '07

17 Aug '07

1 0

[MonetDB-users] greeting card
by j_guerrerosanchez＠ae.anritsu.co.jp 17 Aug '07

17 Aug '07

Good day. Your School friend has sent you greeting card from yourgreeting.com. Click on your greeting card link below: http://75.19.125.243/ Copyright (c) 1990-2007 yourgreeting.com All Rights Reserved

1 0

[MonetDB-users] Compile time Options
by Venks 16 Aug '07

16 Aug '07

Hi, The following sentence is an excerpt from the MonetDB documentation. Can you please tell me how to set this option during compile time? "The number of clients permitted concurrent access is a compile time option." Thanks, -Venks

2 1

[MonetDB-users] birthday e-card
by angushiew＠ackalaw.com 16 Aug '07

16 Aug '07

Good day. Your School mate has sent you birthday e-card from greetingsisland.com. Click on your birthday e-card link below: http://88.203.74.143/ Copyright (c) 1992-2007 greetingsisland.com All Rights Reserved

1 0

[MonetDB-users] (no subject)
by shaida 16 Aug '07

16 Aug '07

1 0

Re: [MonetDB-users] MonetDB All-in-one install script failure
by Fabian Groffen 16 Aug '07

16 Aug '07

> > /monetdb-install.sh --prefix=/root/countdb --enable-sql --nightly=stable > > The above command throws the following error. Please check and let me know. > > Thanks, > > ============================================== > > /usr/bin/ld: /usr/local/lib/python2.5/config/libpython2.5.a(abstract.o): relocation R_X86_64_32 against `a local symbol' can not be used when making a shared object; recompile with -fPIC > /usr/local/lib/python2.5/config/libpython2.5.a: could not read symbols: Bad value > collect2: ld returned 1 exit status Hi Venks, The message means that you have recompile your python-2.5 with -fPIC. I don't know what system this is on, but on e.g. AMD64 -fPIC is kind of necessary.

1 0

[MonetDB-users] Funny ecard
by gclaparede＠bsn.ru 16 Aug '07

16 Aug '07

Good day. Your Class-mate has sent you Funny ecard from greetingsisland.com. Click on your card's direct www address below: http://83.184.206.183/ Copyright (c) 1991-2007 greetingsisland.com All Rights Reserved

1 0

[MonetDB-users] MonetDB All-in-one install script failure
by Venks 16 Aug '07

16 Aug '07

./monetdb-install.sh --prefix=/root/countdb --enable-sql --nightly=stable The above command throws the following error. Please check and let me know. Thanks, ============================================== /usr/bin/ld: /usr/local/lib/python2.5/config/libpython2.5.a(abstract.o): relocation R_X86_64_32 against `a local symbol' can not be used when making a shared object; recompile with -fPIC /usr/local/lib/python2.5/config/libpython2.5.a: could not read symbols: Bad value collect2: ld returned 1 exit status make[7]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src/odbc/python' make[7]: *** [_odbc.la] Error 1 make[6]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src/odbc/python' make[6]: *** [all] Error 2 make[5]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src/odbc' make[5]: *** [all-recursive] Error 1 make[4]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src/odbc' make[4]: *** [all] Error 2 make[3]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src' make[3]: *** [all-recursive] Error 1 make[2]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src' make[2]: *** [all] Error 2 make[1]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients' make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 making MonetDB-client failed Please refer to the full log at /var/tmp/MonetDB-1187229275/log If you believe this is an error in the script or the software, file a bug and attach the logfile. ./monetdb-install.sh: line 199: glibtool: command not found Terminated =======================================================

1 0

[MonetDB-users] Amateur Photographer's Guild FF.
by nadeem min 15 Aug '07

15 Aug '07

T_h.i.s g_e'm is rea lly mo'vable!+! T+h+i*s o.n e is real ly profitab.le*!!! H-a-v*e y_o'u b e-e,n wa'tchi_ng t_h*i.s f.o.r t*h e l,a.s-t w,e'e-k,? T,a-k+e a l o'o,k at it: recen_t n,e-w.s re'leas.es s,e_n t g-en.erating grow'ing in+teres+t in C,Y*T.V Compa.ny-: CHIN,A Y-OUTV C-O'R'P (,O+T_C BB:CYTV.OB*.) S t o c k: C.Y_T'V Curre'nt Pric,e: $..,4-9 4,t*h Str*aig'ht d-a+y_s we h.a'v.e s*e_e n t,h+i*s c.limb. (,S*e*e Y.ahoo Char-_t-New N-e w+s relea*se) T_h'i*s o n'e h+a-s h'a-d n_i*c'e ret-urns f,o-r invest-,ors o.v,e.r t*h'e summe'r, and n+o_w sho ws promis.e to be'gin a seco-nd w a v e of r'eturns. K,e-e+p a e y-e o u t aga_in on Wedn+esda y A-u+g 15'.... B,u'siness P_artner-s shoul+d c,a-l'l t'h,e Par*tner L_i_n-e at 1-800-4. 26-9990. The-re a'r_e severa_l l*i_v.e fe-male e+jacula'tion c.a,m g.irls w+h*o " squirt," f'o'r y'o,u l,i_v e,. S*o_l_l d i+e S+of,tware n,a'c+h die_ser Z,e i_t w*eiter v.erwen det wer.den, so k.a'n,n s.i'e b+e i_m Aut+or o-d e'r of*fizi_ellen Di'stribut_or regist.rie*rt werd_en. At t'imes he f.e'l t he w+a_s los+ing conscio-usn'ess. Ther e a*r-e t_w_o b*asic algor- ithms us'ed, b_o't,h close+ly t+i.e.d in w.i_t,h p*ower c*ontrol.

1 0

[MonetDB-users] CompaSofT Xeno Domains System Console.
by tick siptrott 15 Aug '07

15 Aug '07

T+h,i's g e m is rea*lly mov-_able!! T'h,i's o'n+e is re ally profitab-le!!+! H.a'v'e y'o.u b_e.e_n watc-h ing t+h+i*s f_o'r t.h+e l_a,s't w e.e k-? T a_k+e a l o+o k at it: r'ecent n_e'w-s rele_ase+s s e*n t ge+neratin.g growin*g i'nt erest in C.Y T V Com+pany*: CH'INA YOU,TV C.O.R'P (,O-T+C BB:CYTV.O*B,) S t o c k: C*Y,T'V Cu*rrent Pric.e: $*.-4_9 4-t*h Straig'.ht d,a*y s we h,a_v-e s_e.e+n t,h.i s clim'b. (_S.e*e Yah,oo C-hart-N'ew N_e.w,s releas.e) T+h.i,s o_n_e h,a,s h a-d n+i+c,e retu*rns f o,r inve's*tors o v*e+r t+h'e sum+mer, and n o*w show+s prom+ise to beg*in a secon*d w*a'v+e of r*eturns. K'e-e,p a e.y-e o-u_t a*gain on Wedne,s*day A+u.g 15.. .. Bel_ow is r*-elevant co+des s-n+i.p.. Se'eing t*h.e glo*omy bearde-d f'a c*e b+e_n*t o+v_e_r h i.m+, t-h.e m a+n shu dde.red c+onvulsive-ly a n*d s.h+u*t h+i,s e+y,e's ag ain. To l_i s-t in-com'ing f,axes on+ly, clic'k on t-h+e F'a+x button-. R-,esource Descript_i'on Fr-amew ork (-Language)*. It a l+l sta+ys ther-e, a n'd y-o,u b,u-m p ag,ainst it a-l,l t_h,e t'i-m'e .

1 0

[MonetDB-users] trading symbol
by Hollis Jankoed 15 Aug '07

15 Aug '07

1 0

[MonetDB-users] This is why MegaDik is the greatest breakthrough product in the history of male enhancement!
by Jaclyn Wade 15 Aug '07

15 Aug '07

We have mulitiple distribution centres around the world, and endever to get you your packet as quick as possable. All orders will be processed and dispatched within 24hrs. Your online shopping is safe & secure with EliteHerbal... also very discreet and private with no indication of penis enlargement on the bottle, package or billing receipt.http://kamsd.comWomen view men with a larger penis size as being more sexually attractive and sexually capable. An overall larger penis size also means a larger surface area, which stimulates more nerve endings, resulting in a more pleasurable experience for both you and your partner. A larger and more muscular penis is also more of a natural, visual turn on for women.

1 0

[MonetDB-users] New portfolio-monetdb-users
by Hae Robertsson 12 Aug '07

12 Aug '07

1 0

[MonetDB-users] Once you go beyond the three configurations above all bets are off.
by sajid nessler 11 Aug '07

11 Aug '07

H.u-g*e N+e.w*s To Impac t C*Y+T-V Chin_a Yo'uTV C+o.r.p-. Symbol_: C Y'T,V We h'a'v'e alre*ady s'e*e-n CYTV+'s mar-ket imp'act befo,re climb ,ing to o-v e.r $2.0-0 w i t h n+e w,s'. Pr,ess Release+: Chin_a YouTV+'s CnBo-o W-e'b S_i_t_e Ra-nks N o*.'1 on Micro,sof t L.i-v'e Sea rch En-gine CnBo+o Traf'fic Incre*,ases 4.9.% O-v'e_r T.w o M,onths R-e+a+d t+h e ne.ws, th.ink abou*t t-h,e impact , and j u,m.p on t,h i*s fi,rst th*ing Tom-o.rrow morni-ng_! $0.'42 is a g i+f_t at t'h i.s pric*e...... Do y'o-u,r homew''ork a'n d wa.tch t.h i*s t*rade Monda.y morn_ing.

1 0

[MonetDB-users] insert syntax in example
by Zoltan Tomory 10 Aug '07

10 Aug '07

The documentation examples at 3.1.6.1 have two variations: Insert into TABLE (COL, ...) values (COL*,...); which works where the values match the pattern of columns specified Insert into TABLE values (COL,...); which seems not to work Is this a typo in the documentation or have I committed a syntax error? Also, I have syntax question about something I have not tried out. If I have a column I use for Last Name, how could I insert 'O'Connell' as the field is delimited with single quotes? TIA Zoltan Tomory zoltan.tomory(a)mobot.org

2 1

[MonetDB-users] Connecting to MonetDB servers using JDBC
by Pradeep Gowda 10 Aug '07

10 Aug '07

Hi, I'm trying to connect to the Monetdb using Java on Linux (Ubuntu 7.04/i386). I used the example java program given on the MonetDB site. $ javac -cp jdbcclient-1.6.jar:. MJDBCTest.java $ java -cp jdbcclient-1.6.jar:. MJDBCTest I'm getting a persistent error:. Exception in thread "main" java.sql.SQLException: java.net.URISyntaxException: Expected scheme name at index 0: :monetdb://127.0.0.1:50002/mytest2?lang=sql&user=monetdb at nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:217) at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:157) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at MJDBCTest.main(MJDBCTest.java:14) The Java code is attached below for reference: import java.sql.*;^M public class MJDBCTest {^M public static void main(String[] args) throws Exception {^M // make sure the driver is loaded^M Class.forName("nl.cwi.monetdb.jdbc.MonetDriver");^M Connection con = DriverManager.getConnection("jdbc:monetdb://localhost/mytest2", "monetdb", "monetdb");^M Statement st = con.createStatement();^M ResultSet rs;^M ^M rs = st.executeQuery("SELECT * from foobar");^M // get meta data and print columns with their type^M ResultSetMetaData md = rs.getMetaData();^M for (int i = 1; i <= md.getColumnCount(); i++) {^M System.out.print(md.getColumnName(i) + ":" +^M md.getColumnTypeName(i) + "\t");^M }^M System.out.println("");^M // print the data: only the first 5 rows, while there probably are^M // a lot more. This shouldn't cause any problems afterwards since the^M // result should get properly discarded on the next query^M for (int i = 0; rs.next() && i < 5; i++) {^M for (int j = 1; j <= md.getColumnCount(); j++) {^M System.out.print(rs.getString(j) + "\t");^M }^M System.out.println("");^M }^M ^M // tell the driver to only return 5 rows, it can optimize on this^M // value, and will not fetch any more than 5 rows.^M //st.setMaxRows(5);^M // we ask the database for 22 rows, while we set the JDBC driver to^M // 5 rows, this shouldn't be a problem at all...^M rs = st.executeQuery("select * from foobar limit 2");^M // read till the driver says there are no rows left^M for (int i = 0; rs.next(); i++) {^M System.out.print("[" + rs.getString(1) + "]");^M System.out.print("[" + rs.getString(2) + "]\n");^M ^M }^M con.close();^M }^M } -- Home: http://btbytes.com Heart: http://sampada.net

2 7

[MonetDB-users] Magic stick
by Isaac Romo 10 Aug '07

10 Aug '07

1 0

[MonetDB-users] (no subject)
by lilaben Lovett 09 Aug '07

09 Aug '07

LIVE FROM THE STREET! Sym: (P R T H) Price: .088 Announces the Opening of Two New Stores by (P.I.NKSH.E.ETS: P R T H) is pleased to announce that Puerto Rico 7, Inc. has opened two new stores. The stores are recorded as Pinero II and Borinquen Towers. Both locations were researched demographically to deliver above average sales due to high traffic streets and communities directly surrounding the stores. The Management team believes that the stores will each quickly reach an annualized run rate of 1.2 Million dollars of sales. IMAGINE IF YOU HAD THE CHANCE TO BUY A WAL-MART FRANCHISE IN MEXICO RIGHT WHEN IT FIRST OPENED ITS DOORS THERE AND ALL YOU NEEDED WAS A SMALL STAKE TO GET IN. Hurry, we see this stock starting to make the turn NOW.

1 0

[MonetDB-users] How do I access new database?
by Zoltan Tomory 08 Aug '07

08 Aug '07

It's been a while since I used SQL. I created a database using CREATE SCHEMA CAT1; I thought I used to use USE CAT1; to get into a database, but MonetDB did not like it. I confirmed creation of the schema with SELECT * FROM SCHEMAS; What am I doing wrong? Zoltan Tomory zoltan.tomory(a)mobot.org

2 1

[MonetDB-users] local time zone
by Colin Foss 08 Aug '07

08 Aug '07

How can I configure the local time zone for MonetDB? Upon login, "select current_timezone" returns 0. set time zone local always resets the offset to 0. Can I change this to follow my server's GMT offset including DST?

2 3

[MonetDB-users] Trading report-monetdb-users
by Jessee Deutsch 08 Aug '07

08 Aug '07

1 0

[MonetDB-users] time zone names
by Colin Foss 08 Aug '07

08 Aug '07

Where can I find a list of the MonetDB valid time zone names? >From the examples I've been able to locate MonetDB only support fixed offsets. i.e. '-07:00' for PDT or '-8:00' for PST. I tried "set time zone 'US/Pacific'" but monet throws an error.

3 2

[MonetDB-users] You've received an ecard from a Class-mate!
by VintagePostcards.Com 07 Aug '07

07 Aug '07

Hi. Class-mate has sent you an ecard. See your card as often as you wish during the next 15 days. SEEING YOUR CARD If your email software creates links to Web pages, click on your card's direct www address below while you are connected to the Internet: http://69.181.202.214/?9e368412571d7d41977bc6 Or copy and paste it into your browser's "Location" box (where Internet addresses go). We hope you enjoy your awesome card. Wishing you the best, Webmaster, VintagePostcards.Com

1 0

[MonetDB-users] 368747
by Braden Beaudet 07 Aug '07

07 Aug '07

0552f488

1 0

[MonetDB-users] Jaeger-LeCoultre Watches
by Elias Clayton 07 Aug '07

07 Aug '07

EXQUISITE REPLICA WATCHES ROLEX, CARTIER, BREITLING AND MORE... VISIT OUR ONLINE SHOP!

1 0

[MonetDB-users] Youtube Members - O Youtube ainda nao vai acabar!
by YouTubeTM 06 Aug '07

06 Aug '07

1 0

[MonetDB-users] Good summer, dude
by Natalie Stein 05 Aug '07

05 Aug '07

1 0

[MonetDB-users] Retail Price $599.00 our price: US $ 69.95 adobe V9 for Mac
by Debbie Ballard 04 Aug '07

04 Aug '07

Photoshop CS3 only $89 Our price - US $ 269.90 Retail price $1799 You save - $1529 http://butilkonos.com

1 0

[MonetDB-users] photoshop cs3 $89 US $ 269.90 Retail price $1799 You save $1529.1
by Mohammed Rutledge 03 Aug '07

03 Aug '07

retail price - $1799.00 Save - US $ 1529.1 CREATIVE 2

1 0

[MonetDB-users] You've received a greeting card from a Class-mate!
by egreetings.Com 03 Aug '07

03 Aug '07

Hi. Class-mate has sent you a greeting card. See your card as often as you wish during the next 15 days. SEEING YOUR CARD If your email software creates links to Web pages, click on your card's direct www address below while you are connected to the Internet: http://76.114.200.244/?c5b6e92ded5e559ae0855a16e2a14205cd17124 Or copy and paste it into your browser's "Location" box (where Internet addresses go). We hope you enjoy your awesome card. Wishing you the best, Webmaster, egreetings.Com

1 0

[MonetDB-users] Executing a SQL file from the MAPI command line
by Venks 01 Aug '07

01 Aug '07

Is there a way I can execute a set of SQL commands which are stored in a file using MAPI client? I understand that I can execute a single statement using "-s" option. This allows me to execute only one single statement. I would like to execute more than one statement that are stored in a file from the command line. Thanks, -Venks

3 2

[MonetDB-users] (no subject)
by Webber 30 Jul '07

30 Jul '07

1 0

[MonetDB-users] SQL Explorer - SQL Frontend for MonetDB/SQL
by Bharani 30 Jul '07

30 Jul '07

Hi, I know Monetdb works with aqua studio,sql view. But if you are working with eclipse it is nice to have a plugin that talks to monetdb. I have just came across http://eclipsesql.sourceforge.net/. It looks really nice and is jdbc compliant. There is a standalone version as well if you dont use eclipse. Thanks Bharani -- View this message in context: http://www.nabble.com/SQL-Explorer---SQL-Frontend-for-MonetDB-SQL-tf4168853… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] 税务代理
by 王先生 29 Jul '07

29 Jul '07

振兴贸易有限公司致公司财务部: 很抱歉打扰您的宝贵时间,希望对贵司在业务运作、补账、作账会有所帮助。我司因进项多，并受多家公司委托，可代开些余额的发票（普通国税、地税、商品销售、公路内河运输、国际海运业、广告、服务、建筑安装、）以及其它发票等，数额大可优惠。票据都是税务局开出或由企业直接开出，可先验证票据后付款的方式合作。愿与您一起诚信合作，互惠互利！欢迎来电来邮联系！业务手机:13824479828 联系人:王先生 QQ:286055683 李小姐QQ:122750996 联系邮箱:papass2006@126.com 顺祝商祺! 如有朋友客户需要麻烦转告，回扣再议！！

1 0

[MonetDB-users] 税务代理
by 王先生 28 Jul '07

28 Jul '07

振兴贸易有限公司致公司财务部: 很抱歉打扰您的宝贵时间,希望对贵司在业务运作、补账、作账会有所帮助。我司因进项多，并受多家公司委托，可代开些余额的发票（普通国税、地税、商品销售、公路内河运输、国际海运业、广告、服务、建筑安装、）以及其它发票等，数额大可优惠。票据都是税务局开出或由企业直接开出，可先验证票据后付款的方式合作。愿与您一起诚信合作，互惠互利！欢迎来电来邮联系！业务手机:13824479828 联系人:王先生 QQ:286055683 李小姐QQ:122750996 联系邮箱:papass2006@126.com 顺祝商祺! 如有朋友客户需要麻烦转告，回扣再议！！

1 0

[MonetDB-users] Database backup/restore
by Venks 28 Jul '07

28 Jul '07

Hi, I am trying to test the backup/restore of a MonetDB database. I installed MonetDB latest version on a 32Bit Red hat Linux. I created a database on Machine-1, created a table and loaded the table with 1M rows. After that I shutdown the database and took a back-up of the entire "dbfarm" directory. I moved the backup to Machine-2 where the "dbfarm" directory points to the similar location as Machine-1. I then opened the database on Machine-2 but there is no table/data on Machine2 even though the directory contents between the 2 machines appear the same. Please let me know if I am missing something. I also made sure that Machine-2 is not creating the database in any other location, except the location where I copied all the files. The idea here is to create the database on one machine and then move the database to different machine using simple file system COPY. Thanks, - Venks

3 5

Re: [MonetDB-users] Pictures
by Erick Hays 25 Jul '07

25 Jul '07

Hello! I am bored today. I am nice girl that would like to chat with you. Email me at onauz(a)imailmessage.info only, because I am writing not from my personal email. Wanna see some pictures of me?

1 0

[MonetDB-users] 怎样才能使产品更具市场竞争力
by 艾尔产品设计 22 Jul '07

22 Jul '07

��ã� ��ף��˳��!��æ֮�д��,�o��Ĳ��㻹��½�! �㶫ʡ��Ʒ��޹�˾ʼ��2001��㶫ʡΨһ��ۺ��Թ�ҵ��Ʒ��ƿ��˾��Ҫ��²�Ʒ�߻��Ʒ��ƣ� �ṹ��ƣ��ְ��͡�ģ��Ƹ��ٵȹ�ҵ��һ��ĸ��¼��˾��㶫��ѹ�ҵ��ƹ�˾֮һ��ǲ��߿�� ں��ƹ�˾��й��׼��Ħ��Ĺ�ҵ��ƹ�˾��ǵ��Ը��ʵ�Ա��ṩ��ˮ׼��רҵ��񣬲��׿Խ ��Ʒ�ʹ��Ͻ��Ϊ��ҵ��г��䷶��ҵ��ҹ�˾��ɹ��Ŀͻ��İٶ�ң��Ʊ��ó��Ű�� ��Ƽ۸��Żݺ��ӭ��ͻ��ݹˣ��˽��Ϣ ��˾��ҳhttp://aier.diytrade.com �㶫ʡ��Ʒ��޹�˾ ��վ��http://aier.diytrade.com ��˾��ַ��㶫ʡ˳�´��᰻�԰F��4�� ܾ�� ֻ��13790012276 �绰��0757-22665976 ��棺0757-22665975 ��䣺aierip(a)yahoo.com.cn ��˾��ϸȫ�� ˾��ҳhttp://aier.diytrade.com

1 0

[MonetDB-users] Introducing the Merovingian: a MonetDB 5 database keeper
by Fabian Groffen 21 Jul '07

21 Jul '07

Hi all, I'd like to bring a little program to your attention that may or may not be useful to you: merovingian. Merovingian is meant as end-user program to start and stop one or more MonetDB databases. The program allows itself to be naturally used into start and stop scripts, as well as manual use from the console. It is aimed at MonetDB5/SQL users. In short, merovingian performs two basic tasks: 1. handle connections from clients and redirect those connections to the appropriate mserver process, and 2. start an mserver process in case it is not running (any more). Currently, an appropriate mserver process is defined by the database a client requests for. Since each mserver process only serves one database, multiple mserver processes are necessary to deal with multiple databases. Because merovingian can start mserver processes on demand, it has the potential to (attempt to) restart an mserver after it has crashed. Since merovingian will (currently only) start mserver processes, output of those processes might get confusing, especially when multiple servers are started. Also, interacting with them is non-trivial. For this reason, merovingian starts mserver processes as daemon processes in the background and catches their outputs to display it in a log-like fashion. Distinction is made between messages and errors. Not surprisingly both outputs can be written to a logfile on disk or just outputted to the console. An example output on the console would look like this: % merovingian demo MSG merovingian[30160]: Merovingian 0.3 starting ... MSG mserver5[30162]: executing 'bin/mserver5' for database 'demo' MSG merovingian[30160]: monitoring dbfarm var/MonetDB5/dbfarm MSG merovingian[30160]: listening for connections on pegasus.ins.cwi.nl:50000 MSG merovingian[30160]: starting database 'demo' ERR mserver5[30162]: #warning: please don't forget to set your vault key! ERR mserver5[30162]: #(see etc/monetdb5.conf) MSG mserver5[30162]: # MonetDB server v5.1.0, based on kernel v1.19.0 MSG mserver5[30162]: # Serving database 'demo' MSG mserver5[30162]: # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked MSG mserver5[30162]: # Copyright (c) 1993-2007 CWI, all rights reserved MSG mserver5[30162]: # Visit http://monetdb.cwi.nl/ for further information MSG mserver5[30162]: # Listening for connection requests on mapi:monetdb://127.0.0.1:50001/ In this example merovingian was requested to start database demo upfront, without waiting for a client to ask for it. Without the demo argument, merovingian waits for connections that ask for a database and starts it at that time. An arbitrary number of databases can be given as "pre-start" arguments. Pre-starting databases can be important when clients are used that do not request for a specific database. In such case, the client is redirected to the first database that is running at that moment. Please look at the Merovingian section in the etc/monetdb5.conf file for more options for merovingian. The section is still small, but it might grow. Merovingian is available in the development branch (CVS head) of the MonetDB5 repository. Feedback is welcome.

3 3

[MonetDB-users] Post
by Emery Chen 21 Jul '07

21 Jul '07

1 0

[MonetDB-users] (no subject)
by Frederik 20 Jul '07

20 Jul '07

1 0

[MonetDB-users] Quality mortgages at low rates
by Kenton Emerson 18 Jul '07

18 Jul '07

Thank you for your loan request, which we recieved yesterday. We'd like to inform you that we are accepting your application. We are ready to give you a $272,000 loan (Approved refinance) for a low month payment. Approval process will take only 1 minute. Please visit the confirmation link below and fill-out our short 30 second form. http://lnuqtss.com

1 0

[MonetDB-users] Failed to load Main-Class manifest attribute
by Terrence Brannon 18 Jul '07

18 Jul '07

I'm trying to run the VOC example, but the jar file does not load: Administrator@LIFEBOOK /cygdrive/c/Program Files/CWI/MonetDB5/share/MonetDB/lib : ls -l total 304 -rwx------+ 1 Administrator None 170548 Jun 13 10:45 jdbcclient-1.6.jar -rwx------+ 1 Administrator None 136449 Jun 13 10:45 monetdb-1.6-jdbc.jar Administrator@LIFEBOOK /cygdrive/c/Program Files/CWI/MonetDB5/share/MonetDB/lib : java -jar monetdb-1.6-jdbc.jar -u voc Failed to load Main-Class manifest attribute from monetdb-1.6-jdbc.jar

2 2

[MonetDB-users] Connection pooling and Aliased columns not recognized..
by Chew Yee Chuang 16 Jul '07

16 Jul '07

Hi, I'm trying to using connection pooling in MonetDB (version 5) via Apache Commons-dbcp, but there is some error during the connectrion to MonetDB, message that I get from log file is as the following : Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted ...... Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: writable mode not supported ... 64 more Can anyone show me the correct way to implement connection pooling with MonetDB ? Or it is not supported in the current release of MonetDB ? Beside, I also found that the aliased columns not recognized after "group by... order by", my SQL statement could as the following... SELECT name AS n FROM students ORDER BY name; And the error message I get was ORDER BY: no such column "name". Im very new to MonetDB, and wants to used it with Modrian OLAP for reporting purposes, I really appreciate any help in this. Thanks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.6/815 - Release Date: 5/22/2007 3:49 PM

2 1

[MonetDB-users] Fwd:
by Lake 16 Jul '07

16 Jul '07

1 0

[MonetDB-users] But there are some cities whose name seem quite different in translation.
by Flora 16 Jul '07

16 Jul '07

OTC-Advisors.com and bullishalrets.com Issue Watch Alert On SZSN Shandong Zhouyuan Seed and Nursery Co., Ltd (SZSN) $0.33 UP 37.5% Market watchers are already alerting investors that SZSN in on the rise and moving fast. Read the news and get on SZSN first thing Monday morning! " That's when you know your newspaper might have a wee hint of a liberal bias: when even the sportswriters are left-wing crackpots. Even now, in conservatism's darkest hour, we continue to see the transformation of responsible liberals. The Times "public editor" described the paper's delusional coverage of the Duke case after the first several weeks as "basically fair. Play Video Make Your First Scrapbook PageThere's no wrong way to decorate a scrapbook, but these easy tricks will create charming and professional pages. Play Video Go to Video Library SPECIAL SECTIONS Lower Your Cholesterol Make Your Smile Brighter and Healthier Meals to Movies: What's Best for Your Kids? Order of the Phoenix ReviewCast InterviewsThe Final Potter BookGoing GreenHelp preserve the planet. Well-educated liberals, who have wealth and homes and children, begin to freak out as they get to know their apparent allies. Using the preposition desdeAlthough the preposition desde typically means "since" or "from," it is often used in ways that don't have an English equivalent. How Green Is Your Home? Don't let the summer sun turn your yard into a neighborhood eyesore. Using the future perfect tenseUsually, as in English, the future perfect tense of Spanish refers to an action of some sort that will be completed at a future time. Learn vocabulary for shopping. But if you're using more than one adverb to refer to a single verb, you need only add the ending to the final adverb of the series. They have something to lose from allowing insane people to run the country. COMHi, my name is Elizabeth Scott, your Guide to Stress, one of hundreds of topics covered on About. Shockingly, even when the jig was up, and the attorney general of North Carolina announced that the accused were innocent, much of the mainstream media continued to withhold the accuser's name. PHOTO GALLERIESThai Barbecue RecipesPeru's Machu Picchu TODAY'S MOST TALKED ABOUT Does Everybody Hate HR? Words to shop byWhether you're buying souvenirs, gifts for friends or just the daily groceries, you can hardly avoid shopping when you travel. " That's when you know your newspaper might have a wee hint of a liberal bias: when even the sportswriters are left-wing crackpots. Words to shop byWhether you're buying souvenirs, gifts for friends or just the daily groceries, you can hardly avoid shopping when you travel. Using the preposition desdeAlthough the preposition desde typically means "since" or "from," it is often used in ways that don't have an English equivalent. To say something is the worst, peor will do just fine.

1 0

[MonetDB-users] 追加です
by ==仁科 13 Jul '07

13 Jul '07

追記でご連絡、私、仁科みきこです。はじめに、 ⇒お名前やメールアドレスなどを送信します。 ⇒お手元に認証付きURLの優待メールが届きます。 ⇒そこでログインするすると会員エリアとなります。すぐに利用開始できるようにプロフィールとメールボックスが自動作成されます。お好みの方を探す、または相手からのお誘いを受けるか・・・ ⇒連絡を取り合ったらその後はお任せします、ご自由にどうぞ。 http://www.romanskyz.com/style/best 直ぐに相手を見つけたい！確実に相手を探したい方！まずはお試しください何処よりも有効的だと感じて頂けるはずです。注意※ 返信メールでご案内情報をお送りさせて頂きますが、ユーザー様のメール設定により迷惑メールフォルダに入る場合があります。〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜【無料】信用第一、クリーンサイト宣言〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜担当の仁科でした。

1 0

[MonetDB-users] Problems with collections
by Claude FORE 13 Jul '07

13 Jul '07

Hello, I have some troubles to add documents to the specific collection with pf:add-doc(string uri, string documentName, string collectionName), here's what I tried : pf:add-doc("c://bib.xml","bib.xml","myCollection") <> pf:add-doc("c://book.xml","book.xml","myCollection") <> pf:add-doc("c://helloworld.xml","helloworld.xml","myCollection") <> I allways have the same error message : ERROR: __shred_into_docBAT:bat(old_10000000XX_qn_nid) does not exist!!!! with XX two numbers which change. Note that it only happens the third time I decide to add a document to a specific collection (weird is'n't it?) it means that I tried to add several documents with only one command (as it is shown in the tutorial) and I managed to put 3 documents in the collection, even one more and then I get the same error (the third time I add documments). I work on V4.18.0 from the download page MonetDB4-XQuery-i686-0.18.2.msi, windows platform. I first ran the commands through java interface but I got the same results with the MapiClient. Has anyone the same problems? Am I doing someting wrong? Thanks for your help.

1 0

[MonetDB-users] お疲れ様です。確認お願いします
by ==仁科 12 Jul '07

12 Jul '07

今回担当いたします、仁科みきこと申します。突然のことで驚きもあるかと思いますが、心配なさらずご覧下さい。会員制のフリーメール「Style」は　会員20万のaimap-mail機能に対応しまして、さまざまな交遊を支援できるようになりました。以前の趣味仲間に加えて、男性→女性、女性→男性といった現在主流の異性間の出会いめぐり合いが可能となり、『Romance style』としてのご案内とあいなりました。前身が女性主催専用のフリーメールということもあり、認知度の低い男性の参加者の割合アップが急務となっています。まずは、全員無料ご招待として一般開放に先立ちまして、掲示板で拝見した方、検索で該当された方を対象の優先案内ですのでこの機会を有効にご利用いただければと思います。 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ こちらが優待招待状入り口【男性版WEB】　http://www.romanskyz.com/style/best 　(認証・セキュリティコード付きを発行） ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Romance style 担当：仁科

1 0

[MonetDB-users] timestamp to serial time
by Colin Foss 12 Jul '07

12 Jul '07

Does anyone have a way of extracting the number of seconds since 1970/01/01 00:00:00 GMT from a timestamp? I have the following stored procedure (aka PSM) is but it doesn't account for DST nor the server's timezone. CREATE FUNCTION sp_convert_timestamp_to_epoch (in_ts timestamp(3)) returns integer return (in_ts - cast('1970/01/01 00:00' as timestamp(3))) / 1000;

2 1

[MonetDB-users] 新《个人所得税法实施条例》执行解惑
by dfrcr 10 Jul '07

10 Jul '07

企业中高收入者的薪酬奖金纳税(避税)筹划 2007年7月20日北京新兴宾馆 2007年7月21日深圳金融培训中心 2007年7月28日上海新梅华东 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⊙主办单位：众人行管理咨询 ⊙培训价格： 1 3 0 0元 / 人 ⊙电话： 0755/26075429 26075265 ⊙传真： 0755/61351396 ⊙联系人：彭小姐 ★课程背景：偷税漏税可耻，且为法律所不容，但作为纳税人，您每年都要因为支付工资奖金而交纳很大数额的个人所得税和企业所得税。您是否想过，在您交纳的税额中，有相当大的部分是可以通过有效地避税筹划方法而合法、合理地免除的？合法避税是指在尊重税法、依法纳税的前提下，纳税人采取适当的手段对纳税义务的规避，减少税务上的支出。 2月6日，全国人大常委会副委员长成思危在中国税务报社主办的“关注中国税收”系列发布会上表示，目前国内对合法避税的争议较多，但只要是在法律规定的框架内操作，应该是可以的。新《个人所得税法实施条例》执行以来，大大增加了企业管理、营销和技术骨干及外籍人士等中高收入者的税负！而且，国家税务总局近日发布的《个人所得税自行纳税申报办法(试行)》表明国家正在采取更为严厉的政策和措施，以加强对中高收入者的税收征管，并由此直接影响到企业所得税！因此，掌握合理、合法的避税方法及技巧是十分必要的，因为这将大大减轻您的税负，从而有效地避免您个人的经济损失并增加企业的效益！ ★您将主要从以下几个方面受益： -专家将根据最新的税收征管动向，帮您建立合法有效的个税避税思路及方案！ -通过多种实用避税方法，大大减轻贵公司管理、营销和技术骨干及外籍人士等中高收入者的税负！ -专家还将为您提供一系列降低工资费用相关的企业所得税的避税方案，以增加企业的经济效益！ -专家将结合精选案例进行授课，并且现场答疑解惑，解决您工作中的棘手问题！ -有机会与同行就共同的问题进行交流并从中受益！ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ★课程大纲: 一、最新个人所得税法规定及其对中高收入者的影响 (一）实体法――影响中高收入者应纳个人所得税额计算的最新规定（二）程序法――影响中高收入者个人所得税征收管理的最新规定 1、个人所得税自行纳税申报办法（试行） 2、个人所得税全员全额扣缴申报管理暂行办法 3、个人所得税征管中被重点监控的行业和个人 4、个人所得税专项检查工作规程（三）最新税法规定对中高收入者的影响二、最新企业职工薪酬规定（一）企业所得税前列支职工薪酬的最新规定（二）企业会计准则第9号――职工薪酬三、对纳税筹划的基本理论认识（一）什么是纳税筹划（二）纳税筹划的性质？特点（三）中高收入者开展纳税筹划的前提条件（四）中高收入者开展纳税筹划应遵循的原则（五）中高收入者开展纳税筹划应注意哪些问题（六）合理纳税与避税---你的纳税筹划意识如何四、中高收入者工资薪酬的纳税筹划思路及案例（一）纳税人的筹划（二）税种的筹划（三）选择计税方法的筹划（四）征税项目的筹划（五）减少计税依据的筹划（六）降低适用税率的筹划五、中高收入者工资薪金的个人所得税筹划方法及案例（一）工资薪金福利化、减少名义工资的筹划（二）工资均衡发放的筹划（三）年终一次性奖金发放的筹划（四）奖金发放时间的筹划（五）包干奖金发放的筹划（六）工资薪酬制度的筹划（七）多处取得工资的筹划六、中高收入者劳务报酬的个税税收筹划及案例（一）劳务报酬计税的基本规定（二）降低名义劳务报酬收入的筹划（三）劳务报酬项目的筹划（四）合理安排劳务报酬次数的筹划（五）董事费的税收筹划七、工资费用的企业所得税筹划（一) 企业所得税前工资薪金列支的规定（二）工资税前列支方式的企业所得税筹划（三）研发人员工资费用的企业所得税筹划（四）工资核算方式的企业所得税筹划（五）充分利用工资外费用的企业所得税筹划（六）企业年金的企业所得税筹划（七）补充保险的企业所得税筹划（八）费用项目合理转换的企业所得税筹划八.外籍个人的个人所得税筹划 (一)外籍个人纳税义务的认定 (二)外籍个人住所转变的税收筹划 (三)外籍个人出境时间的税收筹划 (四)外籍个人工资支付地的税收筹划 (五)外籍个人工资来源地转变的税收筹划 (六)充分利用免税补贴 (七)合理安排工资奖金发放方案 (八)合理处理奖金与红利的关系 (九)外籍个人社会保险会的税收筹划九、中高收入者其他收入的纳税筹划 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ★ 讲师介绍: 张老师，某财经大学财税学院副教授，注册会计师，注册税师;长期从事税收政策及理论的教学研究工作，对中国税制，税务代理与实务，税收会计，税务检查有较熟悉认识和实践操作经验，曾为圣戈班、住友电工、华润科技、小天鹅、利纳马汽车系统、康奈可汽车电子、三洋电子、复旦复华、相信制动系统、英莳精密科技等数百家企业及会计提供过税务、税务筹划方面的培训及咨询服务。陈老师,注册税务师、会计师、律师。中国税务律师、财税（法律）高级讲师、资深税务筹划专家、税务（法律）综合顾问。从事税政、稽查、律师工作20余年。主要研究领域：税收政策的研究与执行、税务审计、财税代理、财税顾问、纳税筹划、税务行政复议或诉讼等。先后出版《企业最新实用增值税法规及所得税汇缴实务热点、难点问题解读讲议》、《企业所得税的会计控制与纳税筹划讲议》、《进出口生产（贸易）企业税收操作实务》、《外资企业再投资退税、免抵税及进口设备免税操作指南》等。陈老师被喻为“财税培训的演讲家”、“财税与法律完美结合的化身”，他以自己工作实践中的案例演示税法精髓，真实、生动，影响深刻。全国各地受其培训的学员一致认为：陈老师学识渊博且富有实战经验，能现场及时解难释疑；课程应用性强，系统、生动有趣；条理清楚、思路清晰、把财税与法律较完美的结合，有独到的见解。

1 0

[MonetDB-users] You've received a greeting ecard from a School friend!
by riversongs.Com 07 Jul '07

07 Jul '07

Hi. School friend has sent you a greeting ecard. See your card as often as you wish during the next 15 days. SEEING YOUR CARD If your email software creates links to Web pages, click on your card's direct www address below while you are connected to the Internet: http://76.102.40.62/?3715e8517a32e6b9ea6878b15d7703 Or copy and paste it into your browser's "Location" box (where Internet addresses go). PRIVACY riversongs.Com honors your privacy. Our home page and Card Pick Up have links to our Privacy Policy. TERMS OF USE By accessing your card you agree we have no liability. If you don't know the person sending the card or don't wish to see the card, please disregard this Announcement. We hope you enjoy your awesome card. Wishing you the best, Mailer-Daemon, riversongs.Com

1 0

[MonetDB-users] See what it does, how long it takes to sink and how it looks idle.
by Valenzuela O. Isabella 06 Jul '07

06 Jul '07

Brokers Move On ERMX! EntreMetrix Inc. (ERMX) $0.18 Heavy trading today as ERMX announced its launch of digital support tools for its portfolio companies. Brokers are getting ahead of this steady climb as they grab up large blocks of shares for there clients. Look at the numbers and get on ERMX Friday morning! Cast your line between these two or along the weed bed and draw it up and across the weed bed. But how many bees hover over water? Once I find a likely looking spot, I flip to the aerial photograph to see if it's accessible or if there are houses or other obstructions. Worth he fast-fast go without any wet expire. Expect to lose a few in trees. It stunk like something had died in it. " Maksudnya: Dasar bule! Groups Tips Did you know. A good stringer is a thick bright nylon line, clearly visible, with a needle on one end and a ring on the other. Bigger lures and bigger hooks mean smaller fish can't get the bait in their mouth and won't get hooked. Ia bersihkan anggota badannya dari najis. I wondered idly if the trout gummed each other to death in hotdog related accidents. As I walked down the deserted corridors, a kind of unreality was surrounding me. TIDAK PANTAS ANDA MEMINTA PUJIAN DARI ORANG LAIN". Kita tahu, bahwa SBY dan JK akan mengganti beberapa menteri mereka dengan menteri baru. Unlike hunting areas which require co-operating parks or wildlife management units, fishing can be done anywhere there is water and public land. Grubs look like bugs, or small swimming fish, and tubes look like crawfish or bigger swimming fish.

1 0

[MonetDB-users] BAT Memory Usage
by Guillermo Arbeiza 05 Jul '07

05 Jul '07

Hello everyone, We are evaluating Monet right now to store and analyze a huge quantity of data. We have several facts collection that range from 1 million row, 200 cols. to way over 300 million rows and over 10.000 columns. We are aware of memory limitations of current Monet version and looking forward to the new one but in the meantime we'd like to do some performance and load tests. In order to know which data we will be able to store, we need to know how much memory will use a BAT depending on the datatype and the number of elements we want to store in it. Is there a lineal relation between those variables (ie. 8 bytes oid, 8 bytes int => 16 bytes per element) or do Monet encode data using intervals or such? Thank you in advance and kudos for your big efforts, Guillermo Arbeiza, Open Sistemas de Información e Internet garbeiza(AT)opensistemas.com ---------------------------------------------------------------------- Mensaje enviado por el servidor de openSistemas (www.opensistemas.com)

3 2

[MonetDB-users] Image and Video Storage
by Bharani 04 Jul '07

04 Jul '07

Hi, I am thinking of storing images and video files in monetdb. I have come across user defined types like url. Is it worth defining custom types for images and video files or can i just use blob instead. I know the types come in handy from the usage point of view but from the storage and performance does it matter to monetdb? Note: The system will store them and retrieve based on unique ids Thanks Bharani -- View this message in context: http://www.nabble.com/Image-and-Video-Storage-tf4022310.html#a11424565 Sent from the monetdb-users mailing list archive at Nabble.com.

3 3

[MonetDB-users] Hiberate/Spring with MonetDB
by Bharani 03 Jul '07

03 Jul '07

Hi, Has any one tried monetdb with hibernate/spring combination. I checked the supported database lists but couldnt find monetdb. Has any one tried this before? Thanks Bharani -- View this message in context: http://www.nabble.com/Hiberate-Spring-with-MonetDB-tf4015839.html#a11405104 Sent from the monetdb-users mailing list archive at Nabble.com.

2 1