Optimizing schema-last tuple-store queries in graphd

  • Authors:
  • Scott M. Meyer;Jutta Degener;John Giannandrea;Barak Michener

  • Affiliations:
  • Metaweb Technologies Inc., San Francisco, CA, USA;Metaweb Technologies Inc., San Francisco, CA, USA;Metaweb Technologies Inc, San Francisco, CA, USA;Metaweb Technologies Inc, San Francisco, CA, USA

  • Venue:
  • Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

Current relational databases require that a database schema exist prior to data entry and require manual optimization for best performance. We describe the query optimization techniques used by graphd, the schema-last, automatically indexed tuple-store which supports freebase.com, a large world-writable database. Graphd is a log-structured store with a query optimizer based on a functional operator tree over the domain of sorted integer sets which accumulate naturally as tuples are appended to the store. We demonstrate that a set-based optimizer can deliver performance that is roughly comparable to traditional RDBMS query optimization techniques applied to a fixed schema.