Good Morning/Evening everyone.

My aim is to direcly access to the BAT column store representation of MonetDB through the standard libraries (MAPI/JDBC) - if possible. I know that each SQL query gets rewrited into a BAT algebra expression, but in my case I want to access to a single value per time (e.g. I want to  access to the value stored in the i-th row and in the column labelled  "j" of a given table) and maybe in this case the direct access is  quicker than performing the whole SQL query.

I've already tried to use the mclient with the MAL language and read the documentation, and I tried to use the client with something like this:

mdb.start();
bbp.open();
bbp.prelude();
a := bbp.bind("fx", "size");

where "fx" should be the name of the table and "size" one of its attributes. But unfortunately I do not know how to search for a specific row-key and to get the correspondant value, and AFAIK i have to get the id of the column "size".

Thanks in advance,
Giacomo Bergami
____________________________
Giacomo Bergami, Ph.D Student
University of Bologna
https://www.unibo.it/sitoweb/giacomo.bergami2
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list