[Monetdb-developers] MAL access to tables created with SQL

Niels Nes Niels.Nes at cwi.nl
Sat Oct 13 14:48:04 CEST 2007


On Sat, Oct 13, 2007 at 02:36:45PM +0200, darabi at web.de wrote:
> Martin.Kersten at cwi.nl wrote:
> 
> > darabi at web.de wrote:
> > > Hello,
> > >
> > > how is it possible to access in a MAL client session (mclient -l mal)
> > > the BATs of tables which were created previously in sql?
> > >   
> > You can't, because the mapping of SQL to BATs is maintained in the SQL 
> > private catalog.
> > Also, each column in SQL has multiple bats.
> 
> Is it not recommended or not at all possible?
not recommended.
> 
> Because what I am up to could be implemented on top of sql
> (at least to rapidly get off the ground in the beginning).
> 
> I would like to have something like this for an OODB schema:
> 
> - one bat for each class
> - one bat for each attribute (maybe also a persistent reversed bat
> sorted on the value to be able to speed up equality and range queries)
> - one bat for each relation between classes
> - one bat for each collection which contains attributes (and not references)
> 
> And if I interpret the contents of sql_catalog correctly,
> much of it is already present there.
Indeed, but when sql is running its in control of the sql_catalog bat (through
the gdk_logger code). This means it assumes its the only one accessint it.

Niels
> 
> If it is technically impossible, then I would have to
> duplicate some of that.
> 
> 
> Kambiz
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

-- 

Niels Nes, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
room C0.02,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl




More information about the developers-list mailing list