Chapter 4. Database structure 83
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. 
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_n br   check_nb r     balan ce   do c_nam e doc_offset    doc_len gth
John Smith             12 3456789        76543          120 .78    2FAAA                   0        21945
John Doe                23456789 0        9876 5          98 7.98   2 FAAA           21945         2806 3
Jane Doe                34567890 1        8765 4          38 0.98   2 FAAA           50008         2859 5
.. ....... 10 Millio n ro w s
customer_name    account_n br   check_nb r     balan ce   do c_nam e doc_offset    doc_len gth
Jane Bro wn           45 6784949        87643          245 .78     4FAAA                   0       21945
John Bro wn           57 4630988        34512          876 .65     4FAAA            21945      28063
Jane Smith             87 5632091        85094        1380 .98     4FAAA            50008      28595
.. ....... 326 ,098  rows
HAA2 (application group data table)