skip to main content
10.1145/1871940.1871942acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
keynote

Query processing in Oracle DBMS

Published: 30 October 2010 Publication History

Abstract

This talk presents a broad overview of recent features in Oracle query processing including query optimization, parallel and serial executions, and analytics and OLAP. It describes Oracle's global query optimizer, which integrates logical transformation and cost-based physical optimization to allow an extensive set of possibly interdependent transformations to be performed in a cost based manner; it discusses the adaptive nature of the physical optimizer that uses feedback loop to improve upon its previous decisions. Some novel query execution techniques as well as Oracle's parallel shared-disk architecture are described. The talk outlines Oracle extension for analytics and OLAP features and their integration into the database engine. The challenges of building state-of-the-arts query optimizer and execution engine are highlighted.

Cited By

View all
  • (2011)Plan space analysisProceedings of the Fourth International Workshop on Testing Database Systems10.1145/1988842.1988844(1-6)Online publication date: 13-Jun-2011
  • (2010)DOLAP 2010 workshop summaryProceedings of the 19th ACM international conference on Information and knowledge management10.1145/1871437.1871792(1973-1974)Online publication date: 26-Oct-2010

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
DOLAP '10: Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
October 2010
112 pages
ISBN:9781450303835
DOI:10.1145/1871940

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 30 October 2010

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. query optimization
  2. query processing

Qualifiers

  • Keynote

Conference

CIKM '10

Acceptance Rates

Overall Acceptance Rate 29 of 79 submissions, 37%

Upcoming Conference

CIKM '25

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)7
  • Downloads (Last 6 weeks)1
Reflects downloads up to 10 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2011)Plan space analysisProceedings of the Fourth International Workshop on Testing Database Systems10.1145/1988842.1988844(1-6)Online publication date: 13-Jun-2011
  • (2010)DOLAP 2010 workshop summaryProceedings of the 19th ACM international conference on Information and knowledge management10.1145/1871437.1871792(1973-1974)Online publication date: 26-Oct-2010

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media