<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <!--Converted with LaTeX2HTML 98.1p1 release (March 2nd, 1998) originally by Nikos Drakos (nikos@cbl.leeds.ac.uk), CBLU, University of Leeds * revised and updated by: Marcus Hennecke, Ross Moore, Herb Swan * with significant contributions from: Jens Lippmann, Marek Rouchal, Martin Wilck and others --> <HTML> <HEAD> <TITLE>Structure of Tables</TITLE> <META NAME="description" CONTENT="Structure of Tables"> <META NAME="keywords" CONTENT="vol1"> <META NAME="resource-type" CONTENT="document"> <META NAME="distribution" CONTENT="global"> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <LINK REL="STYLESHEET" HREF="vol1.css"> <LINK REL="next" HREF="node58.html"> <LINK REL="previous" HREF="node56.html"> <LINK REL="up" HREF="node55.html"> <LINK REL="next" HREF="node58.html"> </HEAD> <BODY > <!--Navigation Panel--> <A NAME="tex2html1200" HREF="node58.html"> <IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="icons.gif/next_motif.gif"></A> <A NAME="tex2html1196" HREF="node55.html"> <IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="icons.gif/up_motif.gif"></A> <A NAME="tex2html1190" HREF="node56.html"> <IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="icons.gif/previous_motif.gif"></A> <A NAME="tex2html1198" HREF="node1.html"> <IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="icons.gif/contents_motif.gif"></A> <A NAME="tex2html1199" HREF="node216.html"> <IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="icons.gif/index_motif.gif"></A> <BR> <B> Next:</B> <A NAME="tex2html1201" HREF="node58.html">Input/Output of Tables</A> <B> Up:</B> <A NAME="tex2html1197" HREF="node55.html">Table File System</A> <B> Previous:</B> <A NAME="tex2html1191" HREF="node56.html">Tables in Image Processing</A> <BR> <BR> <!--End of Navigation Panel--> <H1><A NAME="SECTION00820000000000000000"> </A> <A NAME="structure-of-tables"> </A> <BR> Structure of Tables </H1> <P> Table data are arranged in columns and rows, and stored in MIDAS files with the extension <TT>.tbl</TT>. The entry at a given row and column may be either a single value or an array. The items in one row may describe different properties of the same object or feature. All elements in a given column must be of the <I>same</I> type and thus be associated with the <I>same</I> property. For instance, a table with stellar data could contain the following items in each row: identification, right ascension, declination, magnitude, and spectral type. The first column would then contain all the stellar identifications, the second the right ascensions, etc. <P> The supported column data types are numerical data (8/16/32-bit integers or 32/64-bit reals) and character strings. <P> Each column is tagged with a user-defined label, a display format and optional physical units and can be referred to either by its absolute number or its label. <P> An item in a table is accessed by giving its column and row in addition to the table name. The row number can either be given as an absolute value (i.e. the sequence number) or indicated by the value in a previously defined reference column. <P> In addition to the normal columns all tables contain a <TT>SELECT</TT> and a <TT>SEQUENCE</TT> column: <UL> <LI>The <TT>SELECT</TT> column enables the user to define and work with a subset of his table by flagging the rows that satisfy a selection criteria. The subtable will be used by commands that do not modify the table information whereas the selection flag will be reset by commands that modify table information and this before taking any action. The values of this column can be accessed in the <TT>COMPUTE</TT> command by using the name SELECT (short form SEL). <LI>The <TT>SEQUENCE</TT> column contains the sequence number of each row. The values of this column can be accessed in the <TT>COMPUTE</TT> command by using the name SEQUENCE (short form SEQ). </UL> <P> If an element is not defined it will be a <TT>NULL</TT> entry and will be listed as a "*" for all data types except for character strings. In that case it will be listed as an empty field. <P> The tables may be physically stored on disk in two formats: by records corresponding to the natural way of storing sequentially the rows and transposed , where all the values of a given column are stored together( default mode). A table can be always expanded in the sense that its number of columns and rows is automatically increased when the allocated space is exceeded. <P> <HR> <!--Navigation Panel--> <A NAME="tex2html1200" HREF="node58.html"> <IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="icons.gif/next_motif.gif"></A> <A NAME="tex2html1196" HREF="node55.html"> <IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="icons.gif/up_motif.gif"></A> <A NAME="tex2html1190" HREF="node56.html"> <IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="icons.gif/previous_motif.gif"></A> <A NAME="tex2html1198" HREF="node1.html"> <IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="icons.gif/contents_motif.gif"></A> <A NAME="tex2html1199" HREF="node216.html"> <IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="icons.gif/index_motif.gif"></A> <BR> <B> Next:</B> <A NAME="tex2html1201" HREF="node58.html">Input/Output of Tables</A> <B> Up:</B> <A NAME="tex2html1197" HREF="node55.html">Table File System</A> <B> Previous:</B> <A NAME="tex2html1191" HREF="node56.html">Tables in Image Processing</A> <!--End of Navigation Panel--> <ADDRESS> <I>Petra Nass</I> <BR><I>1999-06-09</I> </ADDRESS> </BODY> </HTML>