|
Abstract : |
The Daytona ? data management system is used by AT&T to solve a wide spectrum of data management problems. For example, Daytona is managing a 4 terabyte data warehouse whose largest table contains over 10 billion rows. 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, reliable and open to UNIX ? tools. In particular, two forms of data compression plus robust horizontal partitioning enable Daytona to handle terabytes with ease. 1. Daytona The Daytona ? data management system is used by AT&T to solve a wide spectrum of data management problems. On the tiny end, Daytona provided the data manager for the DACS VI switch which only had 64MB of memory at the time. Since DACS VI used a real-time UNIX operating system, virtual memory could not be paged to swap disk. Consequently, the entire application, including the 15 % that was allocated to the database, had to fit into the rather small amount of physical memory at all times. As another example, all of AT&T?s (phone) call detail data (which represents most of the company?s, |
