Loading…

Oracle Database In-Memory: A dual format in-memory database

The Oracle Database In-Memory Option allows Oracle to function as the industry-first dual-format in-memory database. Row formats are ideal for OLTP workloads which typically use indexes to limit their data access to a small set of rows, while column formats are better suited for Analytic operations...

Full description

Saved in:
Bibliographic Details
Main Authors: Lahiri, Tirthankar, Chavan, Shasank, Colgan, Maria, Das, Dinesh, Ganesh, Amit, Gleeson, Mike, Hase, Sanket, Holloway, Allison, Kamp, Jesse, Teck-Hua Lee, Loaiza, Juan, Macnaughton, Neil, Marwah, Vineet, Mukherjee, Niloy, Mullick, Atrayee, Muthulingam, Sujatha, Raja, Vivekanandhan, Roth, Marty, Soylemez, Ekrem, Zait, Mohamed
Format: Conference Proceeding
Language:English
Subjects:
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
cited_by
cites
container_end_page 1258
container_issue
container_start_page 1253
container_title
container_volume
creator Lahiri, Tirthankar
Chavan, Shasank
Colgan, Maria
Das, Dinesh
Ganesh, Amit
Gleeson, Mike
Hase, Sanket
Holloway, Allison
Kamp, Jesse
Teck-Hua Lee
Loaiza, Juan
Macnaughton, Neil
Marwah, Vineet
Mukherjee, Niloy
Mullick, Atrayee
Muthulingam, Sujatha
Raja, Vivekanandhan
Roth, Marty
Soylemez, Ekrem
Zait, Mohamed
description The Oracle Database In-Memory Option allows Oracle to function as the industry-first dual-format in-memory database. Row formats are ideal for OLTP workloads which typically use indexes to limit their data access to a small set of rows, while column formats are better suited for Analytic operations which typically examine a small number of columns from a large number of rows. Since no single data format is ideal for all types of workloads, our approach was to allow data to be simultaneously maintained in both formats with strict transactional consistency between them.
doi_str_mv 10.1109/ICDE.2015.7113373
format conference_proceeding
fullrecord <record><control><sourceid>ieee_CHZPO</sourceid><recordid>TN_cdi_ieee_primary_7113373</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><ieee_id>7113373</ieee_id><sourcerecordid>7113373</sourcerecordid><originalsourceid>FETCH-LOGICAL-i175t-b22578d7c2c5ad836ce4683f91395e14d1f16ecdc6a4266acfea87f415fb6ff43</originalsourceid><addsrcrecordid>eNotj81Kw0AUhUdRMNY-gLiZF5g4d-78ZHRV0qqBSjcK7srNZAYiSStJXPTtFc3ZnMV3-OAwdgsyB5D-virXm1xJMLkDQHR4xq5BO--dtxrPWabQGSGV_bhgGUiLwmKhrthyHD_lb7wGMDJjj7uBQhf5miaqaYy8OojX2B-H0wNf8eabOp6OQ08Tbw-i_wO8mbc37DJRN8bl3Av2_rR5K1_EdvdclautaMGZSdRKGVc0LqhgqCnQhqhtgckDehNBN5DAxtAES1pZSyFFKlzSYFJtU9K4YHf_3jbGuP8a2p6G037-jT-ObkkI</addsrcrecordid><sourcetype>Publisher</sourcetype><iscdi>true</iscdi><recordtype>conference_proceeding</recordtype></control><display><type>conference_proceeding</type><title>Oracle Database In-Memory: A dual format in-memory database</title><source>IEEE Xplore All Conference Series</source><creator>Lahiri, Tirthankar ; Chavan, Shasank ; Colgan, Maria ; Das, Dinesh ; Ganesh, Amit ; Gleeson, Mike ; Hase, Sanket ; Holloway, Allison ; Kamp, Jesse ; Teck-Hua Lee ; Loaiza, Juan ; Macnaughton, Neil ; Marwah, Vineet ; Mukherjee, Niloy ; Mullick, Atrayee ; Muthulingam, Sujatha ; Raja, Vivekanandhan ; Roth, Marty ; Soylemez, Ekrem ; Zait, Mohamed</creator><creatorcontrib>Lahiri, Tirthankar ; Chavan, Shasank ; Colgan, Maria ; Das, Dinesh ; Ganesh, Amit ; Gleeson, Mike ; Hase, Sanket ; Holloway, Allison ; Kamp, Jesse ; Teck-Hua Lee ; Loaiza, Juan ; Macnaughton, Neil ; Marwah, Vineet ; Mukherjee, Niloy ; Mullick, Atrayee ; Muthulingam, Sujatha ; Raja, Vivekanandhan ; Roth, Marty ; Soylemez, Ekrem ; Zait, Mohamed</creatorcontrib><description>The Oracle Database In-Memory Option allows Oracle to function as the industry-first dual-format in-memory database. Row formats are ideal for OLTP workloads which typically use indexes to limit their data access to a small set of rows, while column formats are better suited for Analytic operations which typically examine a small number of columns from a large number of rows. Since no single data format is ideal for all types of workloads, our approach was to allow data to be simultaneously maintained in both formats with strict transactional consistency between them.</description><identifier>ISSN: 1063-6382</identifier><identifier>EISSN: 2375-026X</identifier><identifier>EISBN: 1479979643</identifier><identifier>EISBN: 9781479979646</identifier><identifier>DOI: 10.1109/ICDE.2015.7113373</identifier><language>eng</language><publisher>IEEE</publisher><subject>Acceleration ; Buffer storage ; Indexes ; Memory management ; Optimization ; Servers</subject><ispartof>2015 IEEE 31st International Conference on Data Engineering, 2015, p.1253-1258</ispartof><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://ieeexplore.ieee.org/document/7113373$$EHTML$$P50$$Gieee$$H</linktohtml><link.rule.ids>309,310,780,784,789,790,2057,27924,54554,54919,54931</link.rule.ids><linktorsrc>$$Uhttps://ieeexplore.ieee.org/document/7113373$$EView_record_in_IEEE$$FView_record_in_$$GIEEE</linktorsrc></links><search><creatorcontrib>Lahiri, Tirthankar</creatorcontrib><creatorcontrib>Chavan, Shasank</creatorcontrib><creatorcontrib>Colgan, Maria</creatorcontrib><creatorcontrib>Das, Dinesh</creatorcontrib><creatorcontrib>Ganesh, Amit</creatorcontrib><creatorcontrib>Gleeson, Mike</creatorcontrib><creatorcontrib>Hase, Sanket</creatorcontrib><creatorcontrib>Holloway, Allison</creatorcontrib><creatorcontrib>Kamp, Jesse</creatorcontrib><creatorcontrib>Teck-Hua Lee</creatorcontrib><creatorcontrib>Loaiza, Juan</creatorcontrib><creatorcontrib>Macnaughton, Neil</creatorcontrib><creatorcontrib>Marwah, Vineet</creatorcontrib><creatorcontrib>Mukherjee, Niloy</creatorcontrib><creatorcontrib>Mullick, Atrayee</creatorcontrib><creatorcontrib>Muthulingam, Sujatha</creatorcontrib><creatorcontrib>Raja, Vivekanandhan</creatorcontrib><creatorcontrib>Roth, Marty</creatorcontrib><creatorcontrib>Soylemez, Ekrem</creatorcontrib><creatorcontrib>Zait, Mohamed</creatorcontrib><title>Oracle Database In-Memory: A dual format in-memory database</title><title>2015 IEEE 31st International Conference on Data Engineering</title><addtitle>ICDE</addtitle><description>The Oracle Database In-Memory Option allows Oracle to function as the industry-first dual-format in-memory database. Row formats are ideal for OLTP workloads which typically use indexes to limit their data access to a small set of rows, while column formats are better suited for Analytic operations which typically examine a small number of columns from a large number of rows. Since no single data format is ideal for all types of workloads, our approach was to allow data to be simultaneously maintained in both formats with strict transactional consistency between them.</description><subject>Acceleration</subject><subject>Buffer storage</subject><subject>Indexes</subject><subject>Memory management</subject><subject>Optimization</subject><subject>Servers</subject><issn>1063-6382</issn><issn>2375-026X</issn><isbn>1479979643</isbn><isbn>9781479979646</isbn><fulltext>true</fulltext><rsrctype>conference_proceeding</rsrctype><creationdate>2015</creationdate><recordtype>conference_proceeding</recordtype><sourceid>6IE</sourceid><recordid>eNotj81Kw0AUhUdRMNY-gLiZF5g4d-78ZHRV0qqBSjcK7srNZAYiSStJXPTtFc3ZnMV3-OAwdgsyB5D-virXm1xJMLkDQHR4xq5BO--dtxrPWabQGSGV_bhgGUiLwmKhrthyHD_lb7wGMDJjj7uBQhf5miaqaYy8OojX2B-H0wNf8eabOp6OQ08Tbw-i_wO8mbc37DJRN8bl3Av2_rR5K1_EdvdclautaMGZSdRKGVc0LqhgqCnQhqhtgckDehNBN5DAxtAES1pZSyFFKlzSYFJtU9K4YHf_3jbGuP8a2p6G037-jT-ObkkI</recordid><startdate>201504</startdate><enddate>201504</enddate><creator>Lahiri, Tirthankar</creator><creator>Chavan, Shasank</creator><creator>Colgan, Maria</creator><creator>Das, Dinesh</creator><creator>Ganesh, Amit</creator><creator>Gleeson, Mike</creator><creator>Hase, Sanket</creator><creator>Holloway, Allison</creator><creator>Kamp, Jesse</creator><creator>Teck-Hua Lee</creator><creator>Loaiza, Juan</creator><creator>Macnaughton, Neil</creator><creator>Marwah, Vineet</creator><creator>Mukherjee, Niloy</creator><creator>Mullick, Atrayee</creator><creator>Muthulingam, Sujatha</creator><creator>Raja, Vivekanandhan</creator><creator>Roth, Marty</creator><creator>Soylemez, Ekrem</creator><creator>Zait, Mohamed</creator><general>IEEE</general><scope>6IE</scope><scope>6IH</scope><scope>CBEJK</scope><scope>RIE</scope><scope>RIO</scope></search><sort><creationdate>201504</creationdate><title>Oracle Database In-Memory: A dual format in-memory database</title><author>Lahiri, Tirthankar ; Chavan, Shasank ; Colgan, Maria ; Das, Dinesh ; Ganesh, Amit ; Gleeson, Mike ; Hase, Sanket ; Holloway, Allison ; Kamp, Jesse ; Teck-Hua Lee ; Loaiza, Juan ; Macnaughton, Neil ; Marwah, Vineet ; Mukherjee, Niloy ; Mullick, Atrayee ; Muthulingam, Sujatha ; Raja, Vivekanandhan ; Roth, Marty ; Soylemez, Ekrem ; Zait, Mohamed</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-i175t-b22578d7c2c5ad836ce4683f91395e14d1f16ecdc6a4266acfea87f415fb6ff43</frbrgroupid><rsrctype>conference_proceedings</rsrctype><prefilter>conference_proceedings</prefilter><language>eng</language><creationdate>2015</creationdate><topic>Acceleration</topic><topic>Buffer storage</topic><topic>Indexes</topic><topic>Memory management</topic><topic>Optimization</topic><topic>Servers</topic><toplevel>online_resources</toplevel><creatorcontrib>Lahiri, Tirthankar</creatorcontrib><creatorcontrib>Chavan, Shasank</creatorcontrib><creatorcontrib>Colgan, Maria</creatorcontrib><creatorcontrib>Das, Dinesh</creatorcontrib><creatorcontrib>Ganesh, Amit</creatorcontrib><creatorcontrib>Gleeson, Mike</creatorcontrib><creatorcontrib>Hase, Sanket</creatorcontrib><creatorcontrib>Holloway, Allison</creatorcontrib><creatorcontrib>Kamp, Jesse</creatorcontrib><creatorcontrib>Teck-Hua Lee</creatorcontrib><creatorcontrib>Loaiza, Juan</creatorcontrib><creatorcontrib>Macnaughton, Neil</creatorcontrib><creatorcontrib>Marwah, Vineet</creatorcontrib><creatorcontrib>Mukherjee, Niloy</creatorcontrib><creatorcontrib>Mullick, Atrayee</creatorcontrib><creatorcontrib>Muthulingam, Sujatha</creatorcontrib><creatorcontrib>Raja, Vivekanandhan</creatorcontrib><creatorcontrib>Roth, Marty</creatorcontrib><creatorcontrib>Soylemez, Ekrem</creatorcontrib><creatorcontrib>Zait, Mohamed</creatorcontrib><collection>IEEE Electronic Library (IEL) Conference Proceedings</collection><collection>IEEE Proceedings Order Plan (POP) 1998-present by volume</collection><collection>IEEE Xplore All Conference Proceedings</collection><collection>IEEE Xplore</collection><collection>IEEE Proceedings Order Plans (POP) 1998-present</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Lahiri, Tirthankar</au><au>Chavan, Shasank</au><au>Colgan, Maria</au><au>Das, Dinesh</au><au>Ganesh, Amit</au><au>Gleeson, Mike</au><au>Hase, Sanket</au><au>Holloway, Allison</au><au>Kamp, Jesse</au><au>Teck-Hua Lee</au><au>Loaiza, Juan</au><au>Macnaughton, Neil</au><au>Marwah, Vineet</au><au>Mukherjee, Niloy</au><au>Mullick, Atrayee</au><au>Muthulingam, Sujatha</au><au>Raja, Vivekanandhan</au><au>Roth, Marty</au><au>Soylemez, Ekrem</au><au>Zait, Mohamed</au><format>book</format><genre>proceeding</genre><ristype>CONF</ristype><atitle>Oracle Database In-Memory: A dual format in-memory database</atitle><btitle>2015 IEEE 31st International Conference on Data Engineering</btitle><stitle>ICDE</stitle><date>2015-04</date><risdate>2015</risdate><spage>1253</spage><epage>1258</epage><pages>1253-1258</pages><issn>1063-6382</issn><eissn>2375-026X</eissn><eisbn>1479979643</eisbn><eisbn>9781479979646</eisbn><abstract>The Oracle Database In-Memory Option allows Oracle to function as the industry-first dual-format in-memory database. Row formats are ideal for OLTP workloads which typically use indexes to limit their data access to a small set of rows, while column formats are better suited for Analytic operations which typically examine a small number of columns from a large number of rows. Since no single data format is ideal for all types of workloads, our approach was to allow data to be simultaneously maintained in both formats with strict transactional consistency between them.</abstract><pub>IEEE</pub><doi>10.1109/ICDE.2015.7113373</doi><tpages>6</tpages></addata></record>
fulltext fulltext_linktorsrc
identifier ISSN: 1063-6382
ispartof 2015 IEEE 31st International Conference on Data Engineering, 2015, p.1253-1258
issn 1063-6382
2375-026X
language eng
recordid cdi_ieee_primary_7113373
source IEEE Xplore All Conference Series
subjects Acceleration
Buffer storage
Indexes
Memory management
Optimization
Servers
title Oracle Database In-Memory: A dual format in-memory database
url http://sfxeu10.hosted.exlibrisgroup.com/loughborough?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-09T06%3A09%3A18IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-ieee_CHZPO&rft_val_fmt=info:ofi/fmt:kev:mtx:book&rft.genre=proceeding&rft.atitle=Oracle%20Database%20In-Memory:%20A%20dual%20format%20in-memory%20database&rft.btitle=2015%20IEEE%2031st%20International%20Conference%20on%20Data%20Engineering&rft.au=Lahiri,%20Tirthankar&rft.date=2015-04&rft.spage=1253&rft.epage=1258&rft.pages=1253-1258&rft.issn=1063-6382&rft.eissn=2375-026X&rft_id=info:doi/10.1109/ICDE.2015.7113373&rft.eisbn=1479979643&rft.eisbn_list=9781479979646&rft_dat=%3Cieee_CHZPO%3E7113373%3C/ieee_CHZPO%3E%3Cgrp_id%3Ecdi_FETCH-LOGICAL-i175t-b22578d7c2c5ad836ce4683f91395e14d1f16ecdc6a4266acfea87f415fb6ff43%3C/grp_id%3E%3Coa%3E%3C/oa%3E%3Curl%3E%3C/url%3E&rft_id=info:oai/&rft_id=info:pmid/&rft_ieee_id=7113373&rfr_iscdi=true