Schema for Table storing AIM objects is as follows :
<p>
<table>
	<thead>
		<th>Column Name</th><th>Description</th><th>Data Type</th>
	</thead>
	<tbody>
		<tr><td>UNIQUE_ID</td><td>extracted from <em>ImageAnnotation/@uniqueIdentifier</em> (Primary Key) </td><td>varchar(64)</td></tr>
		<tr><td>REVIEWER</td><td>extracted from <em>ImageAnnotation/user/User/@loginName</em> </td><td>varchar(64)</td></tr>
		<tr><td>DATE_CREATED</td><td> extracted from <em>ImageAnnotation/@dateTime</em> </td><td>timestamp</td></tr>
		<tr><td>PATIENT_ID</td><td> extracted from <em>ImageAnnotation/person/Person/@id</em> </td><td>varchar(64)</td></tr>
		<tr><td>XMLCOLUMN</td><td>Entire AIM object in XML format </td><td>xml</td></tr>
		<tr><td>DATA_SOURCE</td><td> Contains source of AIM object. For example : bindaas, etc. </td><td>varchar(120)</td></tr>
		<tr><td>IMAGE_UID</td><td> extracted from <em>ImageAnnotation/imageReferenceCollection/ImageReference/imageStudy/ImageStudy/imageSeries/ImageSeries/imageCollection/Image/@sopInstanceUID</em> </td><td>varchar(64)</td></tr>
		<tr><td>STUDY_UID</td><td> extracted from <em>ImageAnnotation/imageReferenceCollection/ImageReference/imageStudy/ImageStudy/@instanceUID</em> </td><td>varchar(64)</td></tr>
		<tr><td>SERIES_UID</td><td> extracted from <em>ImageAnnotation/imageReferenceCollection/ImageReference/imageStudy/ImageStudy/imageSeries/ImageSeries/@instanceUID</em> </td><td>varchar(64)</td></tr>
	</tbody>
</table>
<p>
You can author following types of queries supported by IBM DB2 database :
<ul>
	<li>SQL</li>
	<li>XQuery/Xpath</li>
</ul>

You can choose to render the results in following formats:
<ul>
	<li>HTML</li>
	<li>XML</li>
	<li>CSV</li>
</ul>

<p>Care should be taken when authoring XPath/XQueries that the output format is compatible with the results. If the XQuery/Xpath returns a XML structure then choose <kbd>XML</kbd> format.
Do the same for <kbd>CSV</kbd> and <kbd>HTML</kbd>.