Adding Email Type into a Commercial

Object-Oriented Relational Database -- TOR

Hongfei Guo         guo@cs.wisc.edu

Wanli Yang           ywl@cs.wisc.edu

Abstract: One of the key object-relational features added to relational database is an extensible type system (ADTs). In this project, we examined in depth how a real ORDBMS supports this feature by adding a useful new data type - Email ADT into a commercial Object-Oriented Relational Database - NCR's Teradata ORDBMS (TOR). This work involves two parts. Part 1, implementing Email ADT, which consists of a source file, a header file and a XML description file, supporting users to randomly retrieve different parts from Email data. Part 2, integrating Email ADT into TOR, which includes registering Email type, registering user visible functions to operate Email type data, adding rules in parser, and updating build script. Finally, we gave out our test cases for Email ADT in addition to the original test case suites for existing data types in TOR and corresponding results.

[Full Paper] [Slides]