Matches in SemOpenAlex for { <https://semopenalex.org/work/W1904036550> ?p ?o ?g. }
Showing items 1 to 99 of
99
with 100 items per page.
- W1904036550 endingPage "1781" @default.
- W1904036550 startingPage "1770" @default.
- W1904036550 abstract "Traditional on-disk row major tables have been the dominant storage mechanism in relational databases for decades. Over the last decade, however, with explosive growth in data volume and demand for faster analytics, has come the recognition that a different data representation is needed. There is widespread agreement that in-memory column-oriented databases are best suited to meet the realities of this new world. Oracle 12c Database In-memory, the industry's first dual-format database, allows existing row major on-disk tables to have complementary in-memory columnar representations. The new storage format brings new data processing techniques and query execution algorithms and thus new challenges for the query optimizer. Execution plans that are optimal for one format may be sub-optimal for the other. In this paper, we describe the changes made in the query optimizer to generate execution plans optimized for the specific format -- row major or columnar -- that will be scanned during query execution. With enhancements in several areas -- statistics, cost model, query transformation, access path and join optimization, parallelism, and cluster-awareness -- the query optimizer plays a significant role in unlocking the full promise and performance of Oracle Database In-Memory." @default.
- W1904036550 created "2016-06-24" @default.
- W1904036550 creator A5003966028 @default.
- W1904036550 creator A5005835027 @default.
- W1904036550 creator A5019479352 @default.
- W1904036550 creator A5020186386 @default.
- W1904036550 creator A5048369180 @default.
- W1904036550 creator A5049684258 @default.
- W1904036550 creator A5055961430 @default.
- W1904036550 creator A5086174001 @default.
- W1904036550 creator A5089890915 @default.
- W1904036550 date "2015-08-01" @default.
- W1904036550 modified "2023-10-16" @default.
- W1904036550 title "Query optimization in Oracle 12c database in-memory" @default.
- W1904036550 cites W1509841269 @default.
- W1904036550 cites W1967601791 @default.
- W1904036550 cites W2014977566 @default.
- W1904036550 cites W2039910065 @default.
- W1904036550 cites W2063281504 @default.
- W1904036550 cites W2079499902 @default.
- W1904036550 cites W2123845384 @default.
- W1904036550 cites W2155070484 @default.
- W1904036550 cites W2170016254 @default.
- W1904036550 doi "https://doi.org/10.14778/2824032.2824074" @default.
- W1904036550 hasPublicationYear "2015" @default.
- W1904036550 type Work @default.
- W1904036550 sameAs 1904036550 @default.
- W1904036550 citedByCount "22" @default.
- W1904036550 countsByYear W19040365502016 @default.
- W1904036550 countsByYear W19040365502017 @default.
- W1904036550 countsByYear W19040365502018 @default.
- W1904036550 countsByYear W19040365502019 @default.
- W1904036550 countsByYear W19040365502020 @default.
- W1904036550 countsByYear W19040365502021 @default.
- W1904036550 countsByYear W19040365502022 @default.
- W1904036550 countsByYear W19040365502023 @default.
- W1904036550 crossrefType "journal-article" @default.
- W1904036550 hasAuthorship W1904036550A5003966028 @default.
- W1904036550 hasAuthorship W1904036550A5005835027 @default.
- W1904036550 hasAuthorship W1904036550A5019479352 @default.
- W1904036550 hasAuthorship W1904036550A5020186386 @default.
- W1904036550 hasAuthorship W1904036550A5048369180 @default.
- W1904036550 hasAuthorship W1904036550A5049684258 @default.
- W1904036550 hasAuthorship W1904036550A5055961430 @default.
- W1904036550 hasAuthorship W1904036550A5086174001 @default.
- W1904036550 hasAuthorship W1904036550A5089890915 @default.
- W1904036550 hasConcept C123593499 @default.
- W1904036550 hasConcept C148840519 @default.
- W1904036550 hasConcept C157692150 @default.
- W1904036550 hasConcept C164120249 @default.
- W1904036550 hasConcept C173608175 @default.
- W1904036550 hasConcept C192939062 @default.
- W1904036550 hasConcept C194222762 @default.
- W1904036550 hasConcept C199360897 @default.
- W1904036550 hasConcept C23123220 @default.
- W1904036550 hasConcept C24028149 @default.
- W1904036550 hasConcept C41008148 @default.
- W1904036550 hasConcept C54239708 @default.
- W1904036550 hasConcept C55166926 @default.
- W1904036550 hasConcept C5655090 @default.
- W1904036550 hasConcept C77088390 @default.
- W1904036550 hasConcept C97854310 @default.
- W1904036550 hasConceptScore W1904036550C123593499 @default.
- W1904036550 hasConceptScore W1904036550C148840519 @default.
- W1904036550 hasConceptScore W1904036550C157692150 @default.
- W1904036550 hasConceptScore W1904036550C164120249 @default.
- W1904036550 hasConceptScore W1904036550C173608175 @default.
- W1904036550 hasConceptScore W1904036550C192939062 @default.
- W1904036550 hasConceptScore W1904036550C194222762 @default.
- W1904036550 hasConceptScore W1904036550C199360897 @default.
- W1904036550 hasConceptScore W1904036550C23123220 @default.
- W1904036550 hasConceptScore W1904036550C24028149 @default.
- W1904036550 hasConceptScore W1904036550C41008148 @default.
- W1904036550 hasConceptScore W1904036550C54239708 @default.
- W1904036550 hasConceptScore W1904036550C55166926 @default.
- W1904036550 hasConceptScore W1904036550C5655090 @default.
- W1904036550 hasConceptScore W1904036550C77088390 @default.
- W1904036550 hasConceptScore W1904036550C97854310 @default.
- W1904036550 hasIssue "12" @default.
- W1904036550 hasLocation W19040365501 @default.
- W1904036550 hasOpenAccess W1904036550 @default.
- W1904036550 hasPrimaryLocation W19040365501 @default.
- W1904036550 hasRelatedWork W2100356604 @default.
- W1904036550 hasRelatedWork W2363222923 @default.
- W1904036550 hasRelatedWork W2372388316 @default.
- W1904036550 hasRelatedWork W2372649518 @default.
- W1904036550 hasRelatedWork W2545191987 @default.
- W1904036550 hasRelatedWork W2604963418 @default.
- W1904036550 hasRelatedWork W4381740310 @default.
- W1904036550 hasRelatedWork W57921718 @default.
- W1904036550 hasRelatedWork W2371929047 @default.
- W1904036550 hasRelatedWork W3103741606 @default.
- W1904036550 hasVolume "8" @default.
- W1904036550 isParatext "false" @default.
- W1904036550 isRetracted "false" @default.
- W1904036550 magId "1904036550" @default.
- W1904036550 workType "article" @default.