How should I store this information?
<p>I have a <code>PrivilegeGroup</code> table, a <code>Privileges</code> table and a <code>link</code> table because the <code>PrivilegeGroup</code> table and the <code>Privileges</code> table is a many to many relationship. I am thinking about load all contents of <code>PrivilegeGroup</code> table and <code>Privilege</code> table into memory from database at beginning when application started.</p>

<p>I want to save them in a form easily to look up. Usually we will look up the <code>PrivilegeCode</code> via <code>GroupId</code>. </p>

<p>Which structure is good for this purpose? array of list? dictionary?</p>
