The Daytona® data management system is used by AT&T to solve a wide spectrum of data management problems. For example, Daytona is managing over 312 terabytes of data in a 7x24 production data warehouse whose largest table contains over 743 billion records as of Sept 2005. Indeed, for this database, Daytona is managing over 1.924 trillion records; it could easily manage more but we ran out of data. Update: as of June 2007, Daytona is managing over 2.8 trillion records in this same data warehouse, with over 938 billion records in the largest table.

Daytona's architecture is based on translating its high-level query language Cymbal® (which includes SQL as a subset) completely into C and then compiling that C into object code. The system resulting from this architecture is fast, powerful, easy to use and administer as well as reliable and open to UNIX tools. In particular, two forms of data compression plus robust horizontal partitioning and effective SPMD parallelization enable Daytona to handle terabytes with ease. Fast, large-scale in-memory operations are supported by in-memory tables with skip-list indices accompanied by scalar and tuple-valued multi-dimensional (hashed) associative arrays.

Daytona offers all the essentials of data management including a high-level query language, data dictionary, B-tree indexing, locking, transactions, logging, and recovery. Regarding its openness to other software, Daytona supports SQL, Perl DBI, and JDBC.

Daytona is also general-purpose: as such, it supports the storage and querying of any kind of tabular data. Such data includes not only a variety of telephone company data but also the results of scientific experiments, inventory data, and accounts receivable data.

  1. Daytona In Use
  2. Compared To Awk & Perl For Flat File Processing
  3. Instructional Queries
  4. Recently Added Features

In hopes of clearing up a common misunderstanding, it is useful to realize what Daytona is and what it is not. Daytona is a data management system, not a database. A data management system is a tool kit that application writers use in order to create databases that are used to store information specific to their application. (In a relational system, a database is a collection of related tables.) By analogy, a data management system is like a carpenters' toolkit that different carpenters could use at different times to build fancy filing cabinets -- or wooden barns. Clearly, the carpenters' toolkit is not the same as either a cabinet or a barn and furthermore, the maker of the toolkit is not necessarily one of the carpenters using the toolkit. Thus, the term "Daytona database" does not properly refer to Daytona itself but rather to some otherwise unspecified application database that was constructed using Daytona.

For further information on Daytona, please send email to:

AT&T is the sole source for the Daytona product, service and support and is the only company authorized to use the Daytona trademark for a database product.