June 2012 - developers-list

Re: [Monetdb-developers] MonetDB: holindex - Change L1 cache size into the number of inte...
by Stefan Manegold 25 Jun '12

25 Jun '12

On Mon, Jun 25, 2012 at 02:53:54PM +0200, Eleni Petraki wrote: > Changeset: f52327015707 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f52327015707 > Modified Files: > monetdb5/extras/crackers/crackers_selecthol_ops.mx > Branch: holindex > Log Message: > > Change L1 cache size into the number of integers that fit into L1. > > > diffs (12 lines): > > diff --git a/monetdb5/extras/crackers/crackers_selecthol_ops.mx b/monetdb5/extras/crackers/crackers_selecthol_ops.mx > --- a/monetdb5/extras/crackers/crackers_selecthol_ops.mx > +++ b/monetdb5/extras/crackers/crackers_selecthol_ops.mx > @@ -306,7 +306,7 @@ createView: > bit copy=TRUE; > > int countBatElements; > - int L1=8192; /*KiloBytes*/ > + int L1=2048000; /*Number of integers that can fit into L1 cache (size: 8192KB)*/ Wow --- which CPU has 8 MB L1(!) cache? > /*k and randomoid are used for DD1R*/ > @1 k,temp_h; > _______________________________________________ > Checkin-list mailing list > Checkin-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/checkin-list > > -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

1 0

[Monetdb-developers] ODBC driver
by Max Kad 25 Jun '12

25 Jun '12

Hi Guys, I've installed MonetDB yesterday on Ubuntu 11.10 and it seems working fine. I've 2 questions though: 1) I'm trying to install MonetDB ODBC driver for UnixODBC following the instructions at (http://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/ODBC ) but for some reason I can't find the Monet ODBC libMonetODBC.so or libMonetODBCs.so driver. ( I found the following files: libmonetdb5.so.11, libmonetdb5.so.11.0.2 but I'm not sure what they are for. ) 2) Are there similar Date functions available on MonetDB as the following MySQL functions: UNIX_TIMESTAMP(), DATE() ) or an epoch function. I couldn't find it on the following link. ( http://www.monetdb.org/Documentation/SQLreference/Temporal ) Thanks in advance, Max

2 1

[Monetdb-developers] ODBC driver
by Max Kad 23 Jun '12

23 Jun '12

Hi Guys, I've installed MonetDB yesterday on Ubuntu 11.10 and it seems working fine. I've 2 questions though: 1) I'm trying to install MonetDB ODBC driver for UnixODBC following the instructions at ( http://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/ODBC ) but for some reason I can't find the Monet ODBC libMonetODBC.so or libMonetODBCs.so driver. ( I found the following files: libmonetdb5.so.11, libmonetdb5.so.11.0.2 but I'm not sure what they are for. ) 2) Are there similar Date functions available on MonetDB as the following MySQL functions: UNIX_TIMESTAMP(), DATE() ) or an epoch function. I couldn't find it on the following link. ( http://www.monetdb.org/Documentation/SQLreference/Temporal ) Thanks in advance, Max

1 0

[Monetdb-developers] Announcement: New Apr2012-SP2 Bugfix release of MonetDB suite
by Sjoerd Mullender 19 Jun '12

19 Jun '12

The MonetDB team at CWI/MonetDB BV is pleased to announce the Apr2012-SP2 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Apr 2012-SP2 bugfix release Client Package * Resolved a cosmetical error where tab-characters would cause misalignments in tabular result views. For the time being, tabs are now represented as a single space in tabular view. MonetDB Common * Limit number of detected CPU cores to 16 on 32-bits systems to avoid running quickly out of addressable resources followed by a kill from the OS. Bug Fixes * 2594: NULL cannot automatically be casted to every other type * 3085: assertion fails upon execution of a valid SQL query * 3086: Modulo function does not work in select from table * 3087: query causes "Not yet implemented" message * 3089: mserver5 crashed if join condition has two column and incorrect order * 3090: crashed if using single identifier for where condition * 3096: Type of median error

1 0

Re: [Monetdb-developers] MonetDB: default - attempt to more thoroughly remove opt_accessmode
by Sjoerd Mullender 14 Jun '12

14 Jun '12

On 2012-06-14 10:16, Fabian Groffen wrote: > Changeset: af264c7d6966 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=af264c7d6966 > Modified Files: > NT/installer32/MonetDB5-SQL-Installer.vdproj > NT/installer64/MonetDB5-SQL-Installer.vdproj > clients/Tests/exports.stable.out > monetdb5/modules/mal/mal_init.mal > monetdb5/optimizer/opt_support.c > sql/backends/monet5/Tests/optimizers.sql > sql/backends/monet5/Tests/optimizers.stable.err > Branch: default > Log Message: > > attempt to more thoroughly remove opt_accessmode > > > diffs (163 lines): > > diff --git a/NT/installer32/MonetDB5-SQL-Installer.vdproj b/NT/installer32/MonetDB5-SQL-Installer.vdproj > --- a/NT/installer32/MonetDB5-SQL-Installer.vdproj > +++ b/NT/installer32/MonetDB5-SQL-Installer.vdproj > @@ -2477,26 +2477,6 @@ > "IsDependency" = "11:FALSE" > "IsolateTo" = "8:" > } > - "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_4704D4539B804719AEB979F67EE20CDE" > - { > - "SourcePath" = "8:lib\\monetdb5\\opt_accessmode.mal" > - "TargetName" = "8:opt_accessmode.mal" > - "Tag" = "8:" > - "Folder" = "8:_B593DAA0787744D6A44D17884E0C3951" > - "Condition" = "8:" > - "Transitive" = "11:FALSE" > - "Vital" = "11:TRUE" > - "ReadOnly" = "11:FALSE" > - "Hidden" = "11:FALSE" > - "System" = "11:FALSE" > - "Permanent" = "11:FALSE" > - "SharedLegacy" = "11:FALSE" > - "PackageAs" = "3:1" > - "Register" = "3:1" > - "Exclude" = "11:FALSE" > - "IsDependency" = "11:FALSE" > - "IsolateTo" = "8:" > - } > "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_47A76DE07EE648EF9F19C2D1AC42B9EE" > { > "SourcePath" = "8:lib\\monetdb5\\autoload\\80_udf.mal" > diff --git a/NT/installer64/MonetDB5-SQL-Installer.vdproj b/NT/installer64/MonetDB5-SQL-Installer.vdproj > --- a/NT/installer64/MonetDB5-SQL-Installer.vdproj > +++ b/NT/installer64/MonetDB5-SQL-Installer.vdproj > @@ -2937,26 +2937,6 @@ > "IsDependency" = "11:FALSE" > "IsolateTo" = "8:" > } > - "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_7209273FAD0B4F4ABFF16B6C23681DA5" > - { > - "SourcePath" = "8:lib\\monetdb5\\opt_accessmode.mal" > - "TargetName" = "8:opt_accessmode.mal" > - "Tag" = "8:" > - "Folder" = "8:_B593DAA0787744D6A44D17884E0C3951" > - "Condition" = "8:" > - "Transitive" = "11:FALSE" > - "Vital" = "11:TRUE" > - "ReadOnly" = "11:FALSE" > - "Hidden" = "11:FALSE" > - "System" = "11:FALSE" > - "Permanent" = "11:FALSE" > - "SharedLegacy" = "11:FALSE" > - "PackageAs" = "3:1" > - "Register" = "3:1" > - "Exclude" = "11:FALSE" > - "IsDependency" = "11:FALSE" > - "IsolateTo" = "8:" > - } > "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_727ED1BD7FF74A91A491B34CC26E6848" > { > "SourcePath" = "8:lib\\monetdb5\\udf.mal" If you do this, also remove the "Entry" with MsmKey equal to the value behind the UUID (so 4704D4539B804719AEB979F67EE20CDE and 7209273FAD0B4F4ABFF16B6C23681DA5 in this case respectively). -- Sjoerd Mullender

1 0