April 2012 - developers-list

[Monetdb-developers] Announcement: New Apr2012 Feature release of MonetDB suite
by Sjoerd Mullender 27 Apr '12

27 Apr '12

The MonetDB team at CWI/MonetDB BV is pleased to announce the Apr2012 feature 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 feature release Build Environment * Fixed some of the package names for Debian/Ubuntu. Packages for libraries should contain the major number of the library version number. This was not always the case. * On Debian and Ubuntu, install Python modules in dist-packages instead of site-packages. This fixed bug 2997. SQL * Fixed a crash that happened at the end of a database upgrade to the Dec2011 database scheme. The crash happened during cleanup after the database was upgraded, so it was merely inconvenient. * Stripped off implementation-specific parts from error messages before they get presented to the user. Java Module * Password reading by JdbcClient no longer results in strange artifacts * JdbcClient now returns exit code 1 in case of failures * Implemented missing Number types support in PreparedStatement.setObject() * Fixed bug in DatabaseMetaData.getSchemas() method that caused an SQL error when called with catalog and schema argument. * Resolved a bug where JDBC and Control connections could terminate abruptly with 'Connection closed' messages Client Package * ODBC: Implemented the SQL_ATTR_CONNECTION_TIMEOUT attribute. * mclient now has a -a (--autocommit) option to turn off autocommit mode. MonetDB5 Server * The type "chr" has been removed. chr has long been superseded by bte for 1 byte arithmetic plus it is pretty useless to hold single characters since we use Unicode and thus only a tiny subset of the supported character set would fit. * Fixed potential crash by dealing better with non-standard types. * A couple of memory leaks have been plugged. Merovingian * The logfile and pidfile monetdbd properties are now displayed with dbfarm path when relative * Fixed a bug in the multiplex-funnel where certain clients would abort on responses for update queries. * Fixed problem where version and mserver properties for monetdbd were not always successfully retrieved. Bug #2982. * Fixed problem where shutdown of monetdbd would lead to shutting down database 'control' which does not exist. Bug #2983. * Fixed issue causing (harmless) 'error reading from control channel' messages. Bug #2984. * Resolved problem where remote start/stop/etc. commands with monetdb would report error 'OK'. Bug #2984. MonetDB Common * The type "chr" has been removed. chr has long been superseded by bte for 1 byte arithmetic plus it is pretty useless to hold single characters since we use Unicode and thus only a tiny subset of the supported character set would fit. Bug Fixes

1 0

Re: [Monetdb-developers] MonetDB: holindex - Initial step for holistic indexing.
by Stefan Manegold 24 Apr '12

24 Apr '12

Eleni, you might also want to checkin your new files that are required to compile your code ;-) Thanks, Stefan On Tue, Apr 24, 2012 at 10:06:06AM +0200, Eleni Petraki wrote: > Changeset: 71b71ebda4e6 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=71b71ebda4e6 > Modified Files: > monetdb5/extras/crackers/60_crackers.mal > monetdb5/extras/crackers/Makefile.ag > monetdb5/extras/crackers/crackers.mx > monetdb5/optimizer/opt_pipes.c > monetdb5/optimizer/opt_support.c > monetdb5/optimizer/opt_support.h > Branch: holindex > Log Message: > > Initial step for holistic indexing. > I implemented an operator that initializes with zero the weights in a list. > > > diffs (175 lines): > > diff --git a/monetdb5/extras/crackers/60_crackers.mal b/monetdb5/extras/crackers/60_crackers.mal > --- a/monetdb5/extras/crackers/60_crackers.mal > +++ b/monetdb5/extras/crackers/60_crackers.mal > @@ -19,5 +19,6 @@ > library crackers; > include opt_selcrack; > include opt_selcrackst; > +include opt_selcrackhol; > include crackers; > > diff --git a/monetdb5/extras/crackers/Makefile.ag b/monetdb5/extras/crackers/Makefile.ag > --- a/monetdb5/extras/crackers/Makefile.ag > +++ b/monetdb5/extras/crackers/Makefile.ag > @@ -35,9 +35,13 @@ lib_crackers = { > crackers_index.mx \ > crackers_core_unordered.mx \ > crackers_select_ops.mx \ > + crackers_holistic.c \ > + crackers_holistic.h \ > crackers_selectst_ops.mx \ > + crackers_selecthol_ops.mx \ > opt_selcrack.mx \ > - opt_selcrackst.mx > + opt_selcrackst.mx \ > + opt_selcrackhol.mx > LIBS = ../../tools/libmonetdb5 \ > ../../../gdk/libbat \ > ../../../common/stream/libstream \ > @@ -49,7 +53,8 @@ headers_mal = { > DIR = libdir/monetdb5 > SOURCES = crackers.mx \ > opt_selcrack.mx \ > - opt_selcrackst.mx > + opt_selcrackst.mx \ > + opt_selcrackhol.mx > } > > headers_crackersautoload = { > diff --git a/monetdb5/extras/crackers/crackers.mx b/monetdb5/extras/crackers/crackers.mx > --- a/monetdb5/extras/crackers/crackers.mx > +++ b/monetdb5/extras/crackers/crackers.mx > @@ -239,6 +239,55 @@ address CRKthetaselectst_@2 > comment "Retrieve the subset using a cracker > index producing preferably a BATview."; > > + > +command selecthol(b:bat[:oid,:@2],l:@2,h:@2):bat[:oid,:@2] > +address CRKselecthol_@2 > +comment "Retrieve the subset using a cracker > + index producing preferably a BATview."; > + > +command selecthol(b:bat[:oid,:@2],l:@2):bat[:oid,:@2] > +address CRKselectholValue_@2 > +comment "Retrieve the subset using a cracker > + index producing preferably a BATview."; > + > +command selecthol(b:bat[:oid,:@2],l:@2,h:@2,li:bit,hi:bit):bat[:oid,:@2] > +address CRKselectholBounds_@2 > +comment "Retrieve the subset using a cracker > + index producing preferably a BATview."; > + > +command uselecthol(b:bat[:any_1,:@2],l:@2,h:@2):bat[:any_1,:void] > +address CRKuselecthol_@2 > +comment "Retrieve the subset using a cracker > + index producing preferably a BATview."; > + > +command uselecthol(b:bat[:any_1,:@2],l:@2):bat[:any_1,:void] > +address CRKuselectholValue_@2 > +comment "Retrieve the subset using a cracker > + index producing preferably a BATview."; > + > +command uselecthol(b:bat[:any_1,:@2],l:@2,h:@2,li:bit,hi:bit):bat[:any_1,:void] > +address CRKuselectholBounds_@2 > +comment "Retrieve the subset using a cracker > + index producing preferably a BATview."; > + > +command thetauselecthol(b:bat[:any_1,:@2],v:@2,op:str):bat[:any_1,:void] > +address CRKthetauselecthol_@2 > +comment "Retrieve the subset using a cracker > + index producing preferably a BATview."; > + > +command thetaselecthol(b:bat[:any_1,:@2],v:@2,op:str):bat[:any_1,:@2] > +address CRKthetaselecthol_@2 > +comment "Retrieve the subset using a cracker > + index producing preferably a BATview."; > + > +command initFrequencyStruct(b:bat[:any_1,:@2]):void > +address CRKinitFrequencyStruct_@2 > +comment "Initialize the struct(lifo) with zero values."; > + > +command selectNode(l:int,h:int):void > +address CRKselectNode > +comment "Select node/BAT to crack (randomly)."; > + > @ > @= Index > command printCrackerIndexBATpart(b:bat[:any_1,:@2]):void > @@ -296,12 +345,15 @@ comment "Break a BAT into three pieces w > #include "crackers_index.h" > #include "crackers_select_ops.h" > #include "crackers_selectst_ops.h" > +#include "crackers_selecthol_ops.h" > +#include "crackers_holistic.h" > #include "crackers_core_unordered.h" > #include "crackers_AVL_tree.h" > > #ifdef LIBCRACKERS > extern int maxCrackMap; > extern CrackerIndexNode *CrackerIndex; > +extern FrequencyNode *FrequencyStruct; > extern int IndexEntries; > extern int IndexSize; > extern int IndexStop; > @@ -323,6 +375,7 @@ extern struct storageManagement *Storage > int maxCrackMap = 0; > > CrackerIndexNode *CrackerIndex; > +FrequencyNode *FrequencyStruct; > > struct storageManagement *StorageInfo = NULL; > > diff --git a/monetdb5/optimizer/opt_pipes.c b/monetdb5/optimizer/opt_pipes.c > --- a/monetdb5/optimizer/opt_pipes.c > +++ b/monetdb5/optimizer/opt_pipes.c > @@ -296,6 +296,28 @@ struct PIPELINES { > "optimizer.multiplex();" > "optimizer.garbageCollector();", > "experimental", "OPTselcrackst", 0}, > +/*The HOLISTIC indexing pipeline*/ > + {"crackerhol_pipe", > + "optimizer.inline();" > + "optimizer.remap();" > + "optimizer.evaluate();" > + "optimizer.costModel();" > + "optimizer.coercions();" > + "optimizer.emptySet();" > + "optimizer.aliases();" > + "optimizer.selcrackhol();" > + "optimizer.deadcode();" > + "optimizer.commonTerms();" > + "optimizer.groups();" > + "optimizer.joinPath();" > + "optimizer.reorder();" > + "optimizer.deadcode();" > + "optimizer.reduce();" > + "optimizer.dataflow();" > + "optimizer.history();" > + "optimizer.multiplex();" > + "optimizer.garbageCollector();", > + "experimental", "OPTselcrackhol", 0}, > > > {"sidcrack_pipe", > diff --git a/monetdb5/optimizer/opt_support.c b/monetdb5/optimizer/opt_support.c > --- a/monetdb5/optimizer/opt_support.c > +++ b/monetdb5/optimizer/opt_support.c > @@ -603,6 +603,7 @@ struct OPTcatalog { > {"replication", 0, 0, 0, DEBUG_OPT_REPLICATION}, > {"selcrack", 0, 0, 0, DEBUG_OPT_SELCRACK}, > {"selcrackst", 0, 0, 0, DEBUG_OPT_SELCRACKST}, > +{"selcrackhol", 0, 0, 0, DEBUG_OPT_SELCRACKHOL}, > {"sidcrack", 0, 0, 0, DEBUG_OPT_SIDCRACK}, > {"singleton", 0, 0, 0, DEBUG_OPT_SINGLETON}, > {"strengthreduction", 0, 0, 0, DEBUG_OPT_STRENGTHREDUCTION}, > diff --git a/monetdb5/optimizer/opt_support.h b/monetdb5/optimizer/opt_support.h > --- a/monetdb5/optimizer/opt_support.h > +++ b/monetdb5/optimizer/opt_support.h > @@ -93,6 +93,7 @@ > #define DEBUG_OPT_HEURISTIC 49 > #define DEBUG_OPT_CENTIPEDE 50 > #define DEBUG_OPT_SELCRACKST 51 > +#define DEBUG_OPT_SELCRACKHOL 52 > > #define DEBUG_OPT(X) ((lng) 1 << (X)) > opt_export lng optDebug; > _______________________________________________ > 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] help ! Why can't i analyze schema ?
by hunglmk 20 Apr '12

20 Apr '12

* * * * * * * * * * * * * * * * * * * * Sio Lâm Minh Khánh Hùng * * * * * * * * * * * * * * * * * * * * * ----- Original Message ----- From: hunglmk To: monetdb-developers(a)lists.sourceforge.net Sent: Wednesday, April 04, 2012 8:07 chieu Subject: Why can't i analyze schema ? Good morning . I'm using monetdb with proximity and when i was trying to [analyze schema] the database but nothing happened thought i did exactly like the tutorial . here what i got from the command promt ================================================================== 0 [main] WARN kdl.prox3.util.Util - * log config file not found (using defaults ): D:\prx\proximity\prox.lcf' Exception in thread "AWT-EventQueue-0" java.lang.IllegalAccessError: class javax .swing.$Proxy1 cannot access its superinterface javax.swing.TransferHandler$HasG etTransferHandler at java.lang.reflect.Proxy.defineClass0(Native Method) at java.lang.reflect.Proxy.getProxyClass(Unknown Source) at java.lang.reflect.Proxy.newProxyInstance(Unknown Source) at spin.Spin.getProxy(Spin.java:190) at spin.Spin.over(Spin.java:223) at spin.off.ListenerSpinOver.spinOver(ListenerSpinOver.java:104) at spin.off.ListenerSpinOver.intercept(ListenerSpinOver.java:64) at spin.Spin$AbstractInvocationHandler.invoke(Spin.java:411) at $Proxy0.addPropertyChangeListener(Unknown Source) at kdl.prox3.gui2.SchemaAnalysisJFrame.analyze(SchemaAnalysisJFrame.java :98) at kdl.prox3.gui2.SchemaAnalysisJFrame.access$000(SchemaAnalysisJFrame.java:57) at kdl.prox3.gui2.SchemaAnalysisJFrame$1.actionPerformed(SchemaAnalysisJFrame.java:121) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$000(Unknown Source) at java.awt.EventQueue$1.run(Unknown Source) at java.awt.EventQueue$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$2.run(Unknown Source) at java.awt.EventQueue$2.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) ================================================================== I'm using window XP SP2 and JDK 1.6 , JRE 1.6 , monetdb 4.6.2 for windows . Do i need to install any software or library . Any advices will be great help . Thanks for your time Have a nice day * * * * * * * * * * * * * * * * * * * * Sio Lâm Minh Khánh Hùng * * * * * * * * * * * * * * * * * * * * *

1 0

[Monetdb-developers] Why can't i analyze schema ?
by hunglmk 04 Apr '12

04 Apr '12

Good morning . I'm using monetdb with proximity and when i was trying to [analyze schema] the database but nothing happened thought i did exactly like the tutorial . here what i got from the command promt ================================================================== 0 [main] WARN kdl.prox3.util.Util - * log config file not found (using defaults ): D:\prx\proximity\prox.lcf' Exception in thread "AWT-EventQueue-0" java.lang.IllegalAccessError: class javax .swing.$Proxy1 cannot access its superinterface javax.swing.TransferHandler$HasG etTransferHandler at java.lang.reflect.Proxy.defineClass0(Native Method) at java.lang.reflect.Proxy.getProxyClass(Unknown Source) at java.lang.reflect.Proxy.newProxyInstance(Unknown Source) at spin.Spin.getProxy(Spin.java:190) at spin.Spin.over(Spin.java:223) at spin.off.ListenerSpinOver.spinOver(ListenerSpinOver.java:104) at spin.off.ListenerSpinOver.intercept(ListenerSpinOver.java:64) at spin.Spin$AbstractInvocationHandler.invoke(Spin.java:411) at $Proxy0.addPropertyChangeListener(Unknown Source) at kdl.prox3.gui2.SchemaAnalysisJFrame.analyze(SchemaAnalysisJFrame.java :98) at kdl.prox3.gui2.SchemaAnalysisJFrame.access$000(SchemaAnalysisJFrame.java:57) at kdl.prox3.gui2.SchemaAnalysisJFrame$1.actionPerformed(SchemaAnalysisJFrame.java:121) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$000(Unknown Source) at java.awt.EventQueue$1.run(Unknown Source) at java.awt.EventQueue$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$2.run(Unknown Source) at java.awt.EventQueue$2.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) ================================================================== I'm using window XP SP2 and JDK 1.6 , JRE 1.6 , monetdb 4.6.2 for windows . Do i need to install any software or library . Any advices will be great help . Thanks for your time Have a nice day * * * * * * * * * * * * * * * * * * * * Sio Lâm Minh Khánh Hùng * * * * * * * * * * * * * * * * * * * * *

2 1

[Monetdb-developers] (no subject)
by sylver_b 02 Apr '12

02 Apr '12

<a href="http://babyproduct.co.in/wp-content/plugins/extended-comment-options/02efpk…"> http://babyproduct.co.in/wp-content/plugins/extended-comment-options/02efpk…</a>

1 0

[Monetdb-developers] (no subject)
by sylver_b 02 Apr '12

02 Apr '12

<a href="http://netbooksindia.com/wp-content/plugins/extended-comment-options/02efpk…"> http://netbooksindia.com/wp-content/plugins/extended-comment-options/02efpk…</a>

1 0