• DocumentCode
    140927
  • Title

    The Vertica Query Optimizer: The case for specialized query optimizers

  • Author

    Nga Tran ; Lamb, Andrew ; Shrinivas, L. ; Bodagala, S. ; Dave, Jaimin

  • Author_Institution
    HP Vertica, Cambirdge, MA, USA
  • fYear
    2014
  • fDate
    March 31 2014-April 4 2014
  • Firstpage
    1108
  • Lastpage
    1119
  • Abstract
    The Vertica SQL Query Optimizer was written from the ground up for the Vertica Analytic Database. Its design and the tradeoffs we encountered during its implementation argue that the full power of novel database systems can only be realized with a carefully crafted custom Query Optimizer written specifically for the system in which it operates.
  • Keywords
    SQL; query processing; novel database systems; specialized query optimizers; vertica SQL query optimizer; vertica analytic database; Data models; Dictionaries; Encoding; Engines; Indexes; Optimization;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Data Engineering (ICDE), 2014 IEEE 30th International Conference on
  • Conference_Location
    Chicago, IL
  • Type

    conf

  • DOI
    10.1109/ICDE.2014.6816727
  • Filename
    6816727
    • Link To Document
    https://search.isc.ac/dl/search/defaultta.aspx?DTC=49&DC=140927