Hi Martin, Thanks for the advice. Ignoring all the rest of the intermediate/index/delta data structures and focussing only on the core data structures that hold Table's real/core data that is accessed over time to fetch and store data in memory. This part of the code would be in gdk or sql directory? Or in both directories please? Thanks. Kind Regards, Ahmad -----Original Message----- From: users-list-bounces+ahmad.hassan=sap.com@monetdb.org [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] On Behalf Of Martin Kersten Sent: 21 January 2013 14:06 To: users-list@monetdb.org Subject: Re: BAT Data structures of a Schema Hi Ahmad, Your question requires an answer way beyond the typical message in this forum. (A couple of months studying the code base ;)) Data structures are everywhere. They may play a short term role, e.g. during query parsing, an intermediate role, e.g. a temporary hash index, or a persistent role. All of them may be crucial in achieving the required performance. The code is in this respect your main (only) resource and you need ample of time to pin the area you really want to monitor. A tool to analyse access/instruction behavior is "valgrind --tool=callgrind mserver5...." success, Martin On 1/21/13 2:55 PM, Hassan, Ahmad wrote:
Hi Stefan,
Firstly, thanks for the email. I wish to identify the variable names of the BAT structures that constitute all the tables of the database schema and the place in the code where these BAT variables are declared/initialized using helper/wrapper functions for a database schema.
The reason I need this is, I want to add compiler level instrumentation to analyse the memory access pattern of the BAT data structures of a database schema. The only way I can identify various individual data structures at the compiler level is through the name of the variables in the source code. If you can point to me this information, it will be very helpful for the understanding and analyses. So I would particularly need the variable names in C code that represents the each individual table and then the variable name of each BAT structure with in each table.
The variable names will be correlated/mapped to the virtual addresses at the compiler level.
Thanks.
Kind Regards, Ahmad
-----Original Message----- From: users-list-bounces+ahmad.hassan=sap.com@monetdb.org [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] On Behalf Of Stefan de Konink Sent: 21 January 2013 13:24 To: users-list@monetdb.org Subject: Re: BAT Data structures of a Schema
On 01/21/13 14:15, Hassan, Ahmad wrote:
Please can you point me to the C code file(s) that hold the BAT objects for each column of the above tables please?
Do you mean the "wrapper code" that implements SQL storage (MonetDB/sql/storage/bat) or the underlying that does the raw processing?
Stefan _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list