Hi,
in the MAL level the fastest and best access to a BAT is still subselect if
you are looking for a value and fetch if you are interested in the value to
a specific position (aka oid).
Lefteris
On Wed, Dec 16, 2015 at 4:45 PM, Giacomo Bergami
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