How is a query with 'string' columns in it, gets executed?
Hello, I am looking into these column oriented databases for a while and wondered with monetdb's performance over others. I started studying about monet and found very interesting. Many concepts you use are really interesting. I want to know how monet executes a query which contain string columns in it. Does it maintain a dictionary or what kind of index it uses or is there any inverted index involved for strings etc., Any kind of material, source code portions or any other documentation regarding this, is most welcome. I would love to contribute back from my side once I get to know what is happening. Regards, Mit
On Jan 04, 2016, at 06:57, bhuvan Mitra
wrote: Hello,
I am looking into these column oriented databases for a while and wondered with monetdb's performance over others.
I started studying about monet and found very interesting. Many concepts you use are really interesting.
Thanks
I want to know how monet executes a query which contain string columns in it. Does it maintain a dictionary or what kind of index it uses or is there any inverted index involved for strings etc.,
Yes, MonetDB uses dictionary encoding for strings.
Any kind of material, source code portions or any other documentation regarding this, is most welcome. I would love to contribute back from my side once I get to know what is happening.
Concerning the usage of MonetDB, basically, all documentations we have are in monetdb.org. Concerning development, the code is (unfortunately) the best documentation. Also, you can ask questions in the mailing list. Regards, Jennie
Regards, Mit _______________________________________________ developers-list mailing list developers-list@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list
participants (2)
-
bhuvan Mitra
-
Ying Zhang