Derby/S: A DBMS for sample-based query answering

Research output: Contribution to book/Conference proceedings/Anthology/ReportConference contributionContributedpeer-review

Contributors

Abstract

Although approximate query processing is a prominent way to cope with the requirements of data analysis applications, current database systems do not provide integrated and comprehensive support for these techniques. To improve this situation, we propose an SQL extension - -called SQL/S - -for approximate query answering using random samples, and present a prototypical implementation within the engine of the open-source database system Derby - -called Derby/S. Our approach significantly reduces the required expert knowledge by enabling the definition of samples in a declarative way; the choice of the specific sampling scheme and its parametrization is left to the system. SQL/S introduces new DDL commands to easily define and administrate random samples subject to a given set of optimization criteria. Derby/S automatically takes care of sample maintenance if the underlying dataset changes. Finally, samples are transparently used during query processing, and error bounds are provided. Our extensions do not affect traditional queries and provide the means to integrate sampling as a first-class citizen into a DBMS.

Details

Original languageEnglish
Title of host publicationSIGMOD 2006 - Proceedings of the ACM SIGMOD International Conference on Management of Data
Pages757-759
Number of pages3
Publication statusPublished - 2006
Peer-reviewedYes

Conference

Title2006 ACM SIGMOD International Conference on Management of Data
Duration27 - 29 June 2006
CityChicago, IL
CountryUnited States of America

External IDs

ORCID /0000-0001-8107-2775/work/200630406

Keywords

Research priority areas of TU Dresden

DFG Classification of Subject Areas according to Review Boards

Subject groups, research areas, subject areas according to Destatis

ASJC Scopus subject areas

Keywords

  • Approximate query answering, Sampling