Querying web metadata: Native score management and text support in databases

Gültekin Özsoyoǧlu*, Ismail Sengör Altingövde, Abdullah Al-Hamdani, Selma Ayşe Özel, Özgür Ulusoy, Zehra Meral Özsoyoǧlu

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

10 Citations (Scopus)


In this article, we discuss the issues involved in adding a native score management system to object-relational databases, to be used in querying Web metadata (that describes the semantic content of Web resources). The Web metadata model is based on topics (representing entities), relationships among topics (called metalinks), and importance scores (sideway values) of topics and metalinks. We extend database relations with scoring functions and importance scores. We add to SQL score-management clauses with well-defined semantics, and propose the sidewayvalue algebra (SVA), to evaluate the extended SQL queries. SQL extensions and the SVA algebra are illustrated through two Web resources, namely, the DBLP Bibliography and the SIGMOD Anthology. SQL extensions include clauses for propagating input tuple importance scores to output tuples during query processing, clauses that specify query stopping conditions, threshold predicates (a type of approximate similarity predicates for text comparisons), and user-defined-function-based predicates. The propagated importance scores are then used to rank and return a small number of output tuples. The query stopping conditions are propagated to SVA operators during query processing. We show that our SQL extensions are well-defined, meaning that, given a database and a query Q, under any query processing scheme, the output tuples of Q and their importance scores stay the same. To process the SQL extensions, we discuss two sideway value algebra operators, namely, sideway value algebra join and topic closure, give their implementation algorithms, and report their experimental evaluations.

Original languageEnglish
Pages (from-to)581-634
Number of pages54
JournalACM Transactions on Database Systems
Issue number4
Publication statusPublished - Dec 2004
Externally publishedYes


  • Score management for Web applications

ASJC Scopus subject areas

  • Information Systems


Dive into the research topics of 'Querying web metadata: Native score management and text support in databases'. Together they form a unique fingerprint.

Cite this