Applications for expression data in relational database systems

Author

Gawlick, Dieter ; Lenkov, Dmitry ; Yalamanchi, Aravind ; Chernobrod, Lucy

Author_Institution

Oracle Corp., Redwood Shores, CA, USA

fYear

2004

fDate

30 March-2 April 2004

Firstpage

609

Lastpage

620

Abstract

The support for the expression data type in a relational database system allows storing of conditional expressions as data in database tables and evaluating them using SQL queries. In the context of this new capability, expressions can be interpreted as descriptions, queries, and filters, and this significantly broadens the use of a relational database system to support new types of applications. The paper presents an overview of the expression data type, relates expressions to descriptions, queries, and filters, considers applications pertaining to information distribution, demand analysis, and task assignment, and shows how these applications can be easily supported with improved functionality.

Keywords

SQL; information filters; meta data; query processing; relational databases; vocabulary; SQL queries; database tables; expression data type; expression matching; information demand analysis; mutual filtering; publish/subscribe system; relational database system; task assignment; vocabulary; Database systems; Information analysis; Information filtering; Information filters; Matched filters; Merchandise; Power system management; Relational databases; Subscriptions; Vocabulary;

fLanguage

English

Publisher

ieee

Conference_Titel

Data Engineering, 2004. Proceedings. 20th International Conference on

ISSN

1063-6382

Print_ISBN

0-7695-2065-0

Type

conf

DOI

10.1109/ICDE.2004.1320031

Filename

1320031