On Sat, Oct 13, 2007 at 02:36:45PM +0200, [EMAIL PROTECTED] wrote:
> [EMAIL PROTECTED] wrote:
> 
> > [EMAIL PROTECTED] 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
> [email protected]
> 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: [EMAIL PROTECTED]

-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers

Reply via email to