Return to search

Exploratory Ad-Hoc Analytics for Big Data

In a traditional relational database management system, queries can only be defined over attributes defined in the schema, but are guaranteed to give single, definitive answer structured exactly as specified in the query. In contrast, an information retrieval system allows the user to pose queries without knowledge of a schema, but the result will be a top-k list of possible answers, with no guarantees about the structure or content of the retrieved documents. In this chapter, we present Drill Beyond, a novel IR/RDBMS hybrid system, in which the user seamlessly queries a relational database together with a large corpus of tables extracted from a web crawl. The system allows full SQL queries over a relational database, but additionally enables the user to use arbitrary additional attributes in the query that need not to be defined in the schema. The system then processes this semi-specified query by computing a top-k list of possible query evaluations, each based on different candidate web data sources, thus mixing properties of two worlds RDBMS and IR systems.

Identiferoai:union.ndltd.org:DRESDEN/oai:qucosa:de:qucosa:86494
Date19 July 2023
CreatorsEberius, Julian, Thiele, Maik, Lehner, Wolfgang
PublisherSpringer
Source SetsHochschulschriftenserver (HSSS) der SLUB Dresden
LanguageEnglish
Detected LanguageEnglish
Typeinfo:eu-repo/semantics/acceptedVersion, doc-type:bookPart, info:eu-repo/semantics/bookPart, doc-type:Text
Rightsinfo:eu-repo/semantics/openAccess
Relation978-3-319-49340-4, 10.1007/978-3-319-49340-4_11

Page generated in 0.002 seconds