DBDOC: querying and browsing databases and interrelated documents

  • Authors:
  • Carlos Garcia-Alvarado;Carlos Ordonez;Zhibo Chen

  • Affiliations:
  • University of Houston, Houston, TX;University of Houston, Houston, TX;University of Houston, Houston, TX

  • Venue:
  • Proceedings of the First International Workshop on Keyword Search on Structured Data
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

Large collections of documents are commonly created around a database, where a typical database schema may contain hundreds of tables and thousands of columns. We developed a system based on SQL code generation and User-Defined Functions that analyzes document-to-metadata links by extracting a basic set of relationships at different levels of granularities: coarse, medium and fine. Such relationships are then stored and queried in the DBMS, allowing the user to explore, query, and rank how columns and tables are related to users and applications. At the same time, our system provides typical information retrieval capabilities for querying medium-sized document collections of interrelated documents in the DBMS, with an acceptable performance.