In this initial section we will get an overview of some of the topics we will be covering as far as designing the database, as well as an overview of the system tables in Texis. The system tables contain the information that Texis uses while processing queries.

A database in Texis is a directory. All the system tables live in that directory, as do the user tables and indices by default. A database is created with the creatdb command, which takes the directory as an argument.

• 1.1 Designing the database
• 1.2 Standard tables
• 1.3 Disk layout of the table and indexes
• 1.4 Ordering data for performance
• 1.5 Counter data type, other types
• 1.6 Database security