• DocumentCode
    84737
  • Title

    CrowdOp: Query Optimization for Declarative Crowdsourcing Systems

  • Author

    Ju Fan ; Meihui Zhang ; Kok, Stanley ; Meiyu Lu ; Beng Chin Ooi

  • Author_Institution
    Sch. of Comput., Nat. Univ. of Singapore, Singapore, Singapore
  • Volume
    27
  • Issue
    8
  • fYear
    2015
  • fDate
    Aug. 1 2015
  • Firstpage
    2078
  • Lastpage
    2092
  • Abstract
    We study the query optimization problem in declarative crowdsourcing systems. Declarative crowdsourcing is designed to hide the complexities and relieve the user of the burden of dealing with the crowd. The user is only required to submit an SQL-like query and the system takes the responsibility of compiling the query, generating the execution plan and evaluating in the crowdsourcing marketplace. A given query can have many alternative execution plans and the difference in crowdsourcing cost between the best and the worst plans may be several orders of magnitude. Therefore, as in relational database systems, query optimization is important to crowdsourcing systems that provide declarative query interfaces. In this paper, we propose CROWDOP, a cost-based query optimization approach for declarative crowdsourcing systems. CROWDOP considers both cost and latency in query optimization objectives and generates query plans that provide a good balance between the cost and latency. We develop efficient algorithms in the CROWDOP for optimizing three types of queries: selection queries, join queries, and complex selection-join queries. We validate our approach via extensive experiments by simulation as well as with the real crowd on Amazon Mechanical Turk.
  • Keywords
    SQL; program compilers; query processing; relational databases; Amazon Mechanical Turk; CrowdOp; SQL-like query; complex selection-join query; cost-based query optimization approach; crowdsourcing cost; declarative crowdsourcing systems; declarative query interfaces; join query; query compiling; relational database systems; selection query; Accuracy; Automobiles; Crowdsourcing; Data models; Optimization; Query processing; Crowdsourcing; Query Optimization; query optimization;
  • fLanguage
    English
  • Journal_Title
    Knowledge and Data Engineering, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1041-4347
  • Type

    jour

  • DOI
    10.1109/TKDE.2015.2407353
  • Filename
    7052378