Figure 4-2 Relationship between system tables and data tables This application group creates an application group data table every 10 million rows (based  on the seg_rows value in the ARSAG table, which is not shown in Figure 4-2). During the data  loading process, Content Manager OnDemand uses the agid and the agid_name to add a  row into the segment table (ARSSEG) for every 10 million rows that are created in the  application group data table. When the first data load occurs into the HAA application group,  the index values for the stored documents are inserted into table HAA1. A row exists for each  document that is loaded. When table HAA1 reaches its max_rows value (in this case 10  million rows), table HAA1 is closed and table HAA2 is opened. The important pointer in the ARSSEG table is the name of the application group data table,  table_name , where the index values (in this case, the four defined index values) are stored.  The table_name consists of the agid_name from the ARSAG table, plus a counter.  Figure 4-2 shows the two rows that are created in the ARSSEG table: one row with the  table_name HAA1 and another row with the table_name HAA2. Both HAA1 and HAA2 are the  actual names of the application group data tables that are created.  The application group data table contains the  doc_name , which is the actual container  (storage object) for the individual document. The offset and the document length are also kept  in this table. Figure 4-2 shows that the first row has an offset of 0, and the second row has an  offset of the document length of the first row. Figure 4-2 shows the relationship between the tables. The architecture of relating one application group to one or more application group data  tables allows Content Manager OnDemand an unlimited growth of index space. The  maximum table size is a limitation of the database subsystem and must be configured for  optimal performance.  Chapter 4. Database structure  83 ARSAG (application group table) name (checks) agid..... (5018) agid_name (HAA) ... AR SSEG (segm ent table) agid table_name … 5018 H AA1 5018 H AA2 HAA1 (application group data table) customer_name account_nbr check_nbr balance doc_name doc_offset doc_length John Smith 123456789 76543 120.78 2FAAA 0 21945 John Doe 234567890 98765 987.98 2FAAA 21945 28063 Jane Doe 345678901 87654 380.98 2FAAA 50008 28595 ......... 10 Million rows customer_name account_nbr check_nbr balance doc_name doc_offset doc_length Jane Brown 456784949 87643 245.78 4FAAA 0 21945 John Brown 574630988 34512 876.65 4FAAA 21945 28063 Jane Smith 875632091 85094 1380.98 4FAAA 50008 28595 ......... 326,098 rows HAA2 (application group data table)