An overview of the deco system: data model and query language; query processing and optimization

  • Authors:
  • Hyunjung Park;Richard Pang;Aditya Parameswaran;Hector Garcia-Molina;Neoklis Polyzotis;Jennifer Widom

  • Affiliations:
  • Stanford University;Google, Inc.;Stanford University;Stanford University;UC Santa Cruz;Stanford University

  • Venue:
  • ACM SIGMOD Record
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

Deco is a comprehensive system for answering declarative queries posed over stored relational data together with data obtained on-demand from the crowd. In this overview paper, we describe Deco's data model, query language, and system prototype, summarizing material from earlier papers. Deco's data model was designed to be general, flexible, and principled. Deco's query language extends SQL with simple constructs necessary for crowdsourcing, and has a precise semantics for arbitrary queries. Deco's query execution engine and cost-based query optimizer incorporate many novel techniques to address the limitations of traditional query processing techniques in the crowdsourcing setting. Query processing is guided by the objective of minimizing monetary cost and reducing latency.