Title :
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
fDate :
30 March-2 April 2004
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;
Conference_Titel :
Data Engineering, 2004. Proceedings. 20th International Conference on
Print_ISBN :
0-7695-2065-0
DOI :
10.1109/ICDE.2004.1320031