The Globals database stores data optimally in a global, as described in the What is a Global? document. Relational databases, however, tend to store data in a less-than-optimal format, due to the many restrictions placed upon it by the relational model (adherence to first normal form (1NF) for example).

The following example shows an Invoice table, and a Transaction table (with a Foreign Key pointer back to the Invoice table):
Invoice Table

ID# Date ….
1 01/01/2011
2 02/01/2011
3 02/15/2011
4 03/01/2011
5 03/02/2011

Transaction Table

ID# Invoice# Date ….
1 1 01/01/2011
2 2 02/21/2011
3 3 02/25/2011
4 4 03/20/2011
5 5 03/21/2011

Global Storage for both the Invoice & Transaction Tables:

invoice[1]== “01/01/2011”
invoice[2]== “02/01/2011”
invoice[3]== “02/15/2011”
invoice[4]== “03/01/2011”
invoice[5]== “03/02/2011″
transaction[1,”invoice”,1]==” 01/01/2011″
transaction[2,”invoice”,2]==” 02/21/2011″
transaction[3,”invoice”,3]==” 02/25/2011″
transaction[3,”invoice”,4]==” 03/20/2011″
transaction[4,”invoice”,5]==” 03/21/2011″