{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,31]],"date-time":"2026-03-31T09:35:08Z","timestamp":1774949708212,"version":"3.50.1"},"reference-count":16,"publisher":"Association for Computing Machinery (ACM)","issue":"13","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2016,9]]},"abstract":"<jats:p>\n            Oracle Database In-Memory (DBIM) accelerates analytic workload performance by orders of magnitude through an in-memory columnar format utilizing techniques such as SIMD vector processing, in-memory storage indexes, and optimized predicate evaluation and aggregation. With Oracle Database 12.2, Database In-Memory is further enhanced to accelerate analytic processing through a novel lightweight mechanism known as\n            <jats:italic>Dynamic In-Memory Expressions<\/jats:italic>\n            (DIMEs). The DIME mechanism automatically detects frequently occurring expressions in a query workload, and then creates highly optimized, transactionally consistent, in-memory columnar representations of these expression results. At runtime, queries can directly access these DIMEs, thus avoiding costly expression evaluations. Furthermore, all the optimizations introduced in DBIM can apply directly to DIMEs. Since DIMEs are purely in-memory structures, no changes are required to the underlying tables. We show that DIMEs can reduce query elapsed times by several orders of magnitude without the need for costly pre-computed structures such as computed columns or materialized views or cubes.\n          <\/jats:p>","DOI":"10.14778\/3007263.3007280","type":"journal-article","created":{"date-parts":[[2016,11,1]],"date-time":"2016-11-01T13:47:47Z","timestamp":1478008067000},"page":"1437-1448","source":"Crossref","is-referenced-by-count":5,"title":["Accelerating analytics with dynamic in-memory expressions"],"prefix":"10.14778","volume":"9","author":[{"given":"Aurosish","family":"Mishra","sequence":"first","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shasank","family":"Chavan","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Allison","family":"Holloway","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Tirthankar","family":"Lahiri","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhen Hua","family":"Liu","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sunil","family":"Chakkappen","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dennis","family":"Lui","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Vinita","family":"Subramanian","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ramesh","family":"Kumar","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Maria","family":"Colgan","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jesse","family":"Kamp","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Niloy","family":"Mukherjee","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Vineet","family":"Marwah","sequence":"additional","affiliation":[{"name":"Oracle America"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2016,9]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142527"},{"key":"e_1_2_1_2_1","volume-title":"C-Store: A Column-oriented DBMS. Proceedings of the 31st VLDB Conference (2005)","unstructured":"Stonebraker, M., Abadi, D., et. al. C-Store: A Column-oriented DBMS. Proceedings of the 31st VLDB Conference (2005) Stonebraker, M., Abadi, D., et. al. C-Store: A Column-oriented DBMS. Proceedings of the 31st VLDB Conference (2005)"},{"key":"e_1_2_1_3_1","volume-title":"Proceedings of the ICDE (2015)","author":"T.","unstructured":"Lahiri, T. et. al. Oracle Database In-Memory: A Dual Format In-Memory Database . Proceedings of the ICDE (2015) Lahiri, T. et. al. Oracle Database In-Memory: A Dual Format In-Memory Database. Proceedings of the ICDE (2015)"},{"key":"e_1_2_1_4_1","volume-title":"an Oracle White Paper","author":"In-Memory Oracle Database","year":"2015","unstructured":"Oracle Database In-Memory , an Oracle White Paper , 2015 Oracle Database In-Memory, an Oracle White Paper, 2015"},{"key":"e_1_2_1_5_1","volume-title":"TPCTC","author":"Boncz P.","year":"2013","unstructured":"P. Boncz , T. Neumann , and O. Erling . TPC-H analyzed: Hidden messages and lessons learned from an influential benchmark . In TPCTC , 2013 P. Boncz, T. Neumann, and O. Erling. TPC-H analyzed: Hidden messages and lessons learned from an influential benchmark. In TPCTC, 2013"},{"key":"e_1_2_1_6_1","first-page":"590","volume-title":"Proceedings of VLDB '97","author":"Bridge W.","year":"1997","unstructured":"W. Bridge , A. Joshi , M. Keihl , T. Lahiri , J. Loaiza , and N. MacNaughton , The Oracle Universal Server Buffer Manager . Proceedings of VLDB '97 , pp. 590 -- 594 , 1997 . W. Bridge, A. Joshi, M. Keihl, T. Lahiri, J. Loaiza, and N. MacNaughton, The Oracle Universal Server Buffer Manager. Proceedings of VLDB '97, pp. 590--594, 1997."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.14778\/2824032.2824074"},{"key":"e_1_2_1_8_1","volume-title":"an Oracle White Paper","author":"Oracle Query Optimization","year":"2005","unstructured":"Query Optimization in Oracle Database 10g Release 2 , an Oracle White Paper , 2005 Query Optimization in Oracle Database 10g Release 2, an Oracle White Paper, 2005"},{"key":"e_1_2_1_9_1","volume-title":"an Oracle White Paper","author":"Oracle Oracle Total","year":"2009","unstructured":"Oracle Total Recall with Oracle Database 11g Release 2 , an Oracle White Paper , 2009 Oracle Total Recall with Oracle Database 11g Release 2, an Oracle White Paper, 2009"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.367892"},{"key":"e_1_2_1_11_1","first-page":"1","volume-title":"Proceedings of WebDB","author":"Chasseur C.","year":"2013","unstructured":"C. Chasseur , Y. Li , and J. M. Patel . Enabling JSON Document Stores in Relational Systems . Proceedings of WebDB , pages 1 -- 6 , 2013 . C. Chasseur, Y. Li, and J. M. Patel. Enabling JSON Document Stores in Relational Systems. Proceedings of WebDB, pages 1--6, 2013."},{"key":"e_1_2_1_12_1","volume-title":"Achieving Extreme Performance with Oracle Exadata","author":"Greenwald R.","year":"2011","unstructured":"R. Greenwald , M. Bhuller , R. Stackowiak , and M. Alam , Achieving Extreme Performance with Oracle Exadata , McGraw-Hill , 2011 R. Greenwald, M. Bhuller, R. Stackowiak, and M. Alam, Achieving Extreme Performance with Oracle Exadata, McGraw-Hill, 2011"},{"key":"e_1_2_1_13_1","unstructured":"TPC Benchmark H (Decision Support) Standard Specification Revision 2.17.1  TPC Benchmark H (Decision Support) Standard Specification Revision 2.17.1"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.5555\/1287369.1287454"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2595628"},{"key":"e_1_2_1_16_1","volume-title":"an Oracle White Paper","author":"Oracle Automatic Data","year":"2015","unstructured":"Automatic Data Optimization with Oracle Database 12c , an Oracle White Paper , 2015 Automatic Data Optimization with Oracle Database 12c, an Oracle White Paper, 2015"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3007263.3007280","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:38:25Z","timestamp":1672220305000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3007263.3007280"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2016,9]]},"references-count":16,"journal-issue":{"issue":"13","published-print":{"date-parts":[[2016,9]]}},"alternative-id":["10.14778\/3007263.3007280"],"URL":"https:\/\/doi.org\/10.14778\/3007263.3007280","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2016,9]]}}}