RDB -- A UNIX Command-Line Database
By Mark Pruett, April 10, 2003
Sometimes, even a small database is too big. Databases such as mySQL and PostgreSQL, while lightweight and easy to install by commercial standards, may still be more than you need for some straightforward data analysis problems. Some of these databases may also require root access to install, which may not be practical in some environments.
Figure 4 Result of a master-detail table join
# Some random people
# Age table
Age<t>LastName<t>FirstName<t>Phone<t>Comment
3N<t>15S<t>10<t>12><t>15
25<t>Smith<t>John<t>555-2416<t>Twenty-Five
27<t>Adams<t>Frank<t>555-1378<t>Twenty-Seven
34<t>Smith<t>Jane<t>555-3499<t>