{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,2]],"date-time":"2026-10-02T03:46:06Z","timestamp":1790912766288,"version":"4.1.0"},"reference-count":27,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2018,8]]},"abstract":"<jats:p>To address the need for extreme OLTP performance on commodity multi-core hardware supporting large amounts of memory, SAP ASE is re-architected to tightly integrate an In-Memory Row Store (IMRS) within the existing database engine. The IMRS is both a store and a caching layer to host \"hot\" rows in-memory, in a row-oriented format. The IMRS is an extension to the traditional buffer-cache which deals with data in a page-oriented storage format (referred to as the page-store). Data in individual tables marked as IMRS-enabled can be fully memory-resident or can straddle the page store and the IMRS. Cold data in the IMRS is organically identified, harvested, and \"packed\" back to the page store. SQL statements and transactions can access data transparently from both stores for the same table. All Transact-SQL capabilities and language constructs are supported with no application or stored procedure code changes required. Full durability for in-memory data is provided, including support for backup and restore of database archives and periodic transaction dumps.<\/jats:p>\n          <jats:p>The high-level system design supporting this architecture, along with experimental results and performance benefits is presented.<\/jats:p>","DOI":"10.14778\/3229863.3229875","type":"journal-article","created":{"date-parts":[[2018,9,10]],"date-time":"2018-09-10T12:12:28Z","timestamp":1536581548000},"page":"1889-1901","source":"Crossref","is-referenced-by-count":6,"title":["BTrim"],"prefix":"10.14778","volume":"11","author":[{"given":"Aditya","family":"Gurajada","sequence":"first","affiliation":[{"name":"Hyderabad, India"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Dheren","family":"Gala","sequence":"additional","affiliation":[{"name":"SAP Labs, Pune, India"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Fei","family":"Zhou","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Amit","family":"Pathak","sequence":"additional","affiliation":[{"name":"SAP Labs, Pune, India"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Zhan-Feng","family":"Ma","sequence":"additional","affiliation":[{"name":"SAP China Co. Ltd., Shanghai, China"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2018,8]]},"reference":[{"key":"e_1_2_1_1_1","first-page":"266","volume-title":"VLDB","author":"Ailamaki A.","year":"1999","unstructured":"Ailamaki A. , DeWitt J. David , Hill D.M. , Wood A. D. , DBM Ss On A Modern Processor : Where Does Time Go ? In VLDB , pages 266 -- 277 , 1999 . Ailamaki A., DeWitt J. David, Hill D.M., Wood A. D., DBMSs On A Modern Processor: Where Does Time Go? In VLDB, pages 266--277, 1999."},{"key":"e_1_2_1_2_1","volume-title":"SQL Server In-Memory OLTP Internals for SQL Server 2016","author":"Delaney K.","year":"2016","unstructured":"Delaney K. Online White Paper . SQL Server In-Memory OLTP Internals for SQL Server 2016 , June 2016 . Delaney K. Online White Paper. SQL Server In-Memory OLTP Internals for SQL Server 2016, June 2016."},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.14778\/2556549.2556575"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2463710"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732967.2732968"},{"key":"e_1_2_1_6_1","volume-title":"The SAP HANA Database - An Architecture Overview. Bulletin of the IEEE Computer Society Technical Committee on Data Engineering","author":"Farber Franz","year":"2012","unstructured":"Farber Franz , May Norma et al . The SAP HANA Database - An Architecture Overview. Bulletin of the IEEE Computer Society Technical Committee on Data Engineering , 2012 . Farber Franz, May Norma et al. The SAP HANA Database - An Architecture Overview. Bulletin of the IEEE Computer Society Technical Committee on Data Engineering, 2012."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.14778\/2735461.2735465"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.14778\/1921071.1921077"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376713"},{"key":"e_1_2_1_10_1","volume-title":"England K. Rdb: A Comprehensive Guide, 3<sup>rd<\/sup> edition","author":"Hobbs L.","year":"1999","unstructured":"Hobbs , L. , Smith I. , England K. Rdb: A Comprehensive Guide, 3<sup>rd<\/sup> edition . Digital Press , Oxford , 1999 , 167--169. Hobbs, L., Smith I., England K. Rdb: A Comprehensive Guide, 3<sup>rd<\/sup> edition. Digital Press, Oxford, 1999, 167--169."},{"key":"e_1_2_1_11_1","volume-title":"ACM","author":"Johnson R.","year":"2009","unstructured":"Johnson R. , Pandis I. , Hardavellas N. , Ailamaki A. , Falsafi B. Shore - MT : A Scalable Storage Manager for the Multicore Era . In ACM , 2009 . Johnson R., Pandis I., Hardavellas N., Ailamaki A., Falsafi B. Shore-MT: A Scalable Storage Manager for the Multicore Era. In ACM, 2009."},{"key":"e_1_2_1_12_1","article-title":"Guide to Database Performance and Tuning: Row Cache Enhancements, A feature of Oracle Rdb","author":"Lastovica N.","year":"2003","unstructured":"Lastovica , N. , Oracle Rdb Technology Group . Guide to Database Performance and Tuning: Row Cache Enhancements, A feature of Oracle Rdb . Rdb Journal , Aug 2003 . Lastovica, N., Oracle Rdb Technology Group. Guide to Database Performance and Tuning: Row Cache Enhancements, A feature of Oracle Rdb. Rdb Journal, Aug 2003.","journal-title":"Rdb Journal"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544811"},{"key":"e_1_2_1_14_1","volume-title":"Nov","author":"Microsoft SQL","year":"2017","unstructured":"Microsoft SQL Server Online Docs , Transact SQL Constructs Not Supported by In-Memory OLTP. https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/transact-sql-constructs-not-supported-by-in-memory-oltp , Nov 2017 . Microsoft SQL Server Online Docs, Transact SQL Constructs Not Supported by In-Memory OLTP. https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/transact-sql-constructs-not-supported-by-in-memory-oltp, Nov 2017."},{"key":"e_1_2_1_15_1","volume-title":"Migration Issues for Natively compiled procedures. www.microsoft.com","author":"Microsoft SQL","year":"2017","unstructured":"Microsoft SQL Server online docs , Migration Issues for Natively compiled procedures. www.microsoft.com , 2017 . Microsoft SQL Server online docs, Migration Issues for Natively compiled procedures. www.microsoft.com, 2017."},{"key":"e_1_2_1_16_1","volume-title":"Oct","author":"Oracle TimesTen White","year":"2014","unstructured":"Oracle TimesTen White paper , Using Oracle TimesTen Application-Tier Database Cache to Accelerate the Oracle Database , Oct 2014 . Oracle TimesTen White paper, Using Oracle TimesTen Application-Tier Database Cache to Accelerate the Oracle Database, Oct 2014."},{"key":"e_1_2_1_17_1","unstructured":"Oracle TimesTen online documentation various. www.oracle.com  Oracle TimesTen online documentation various. www.oracle.com"},{"key":"e_1_2_1_18_1","volume-title":"Guide to Database Performance and Tuning: Row Cache Enhancements","author":"Oracle Rdb","year":"2003","unstructured":"Oracle Rdb online documentation , Guide to Database Performance and Tuning: Row Cache Enhancements , 2003 . Oracle Rdb online documentation, Guide to Database Performance and Tuning: Row Cache Enhancements, 2003."},{"key":"e_1_2_1_19_1","volume-title":"Joint Workshop of HardBD and Active","author":"Pathak A.","year":"2018","unstructured":"Pathak A. , Gurajada A. P. , Khadilkar P. Life Cycle of Transactional Data in In-memory Databases, ICDE , Joint Workshop of HardBD and Active , April 2018 . Pathak A., Gurajada A. P., Khadilkar P. Life Cycle of Transactional Data in In-memory Databases, ICDE, Joint Workshop of HardBD and Active, April 2018."},{"key":"e_1_2_1_20_1","doi-asserted-by":"crossref","first-page":"89","DOI":"10.1007\/978-3-642-19363-7_6","volume-title":"In-Memory Data Management: An Inflection Point for the Enterprise Applications","author":"Plattner H.","year":"2011","unstructured":"Plattner H. , Zeier A.. In-Memory Data Management: An Inflection Point for the Enterprise Applications . Springer publication, 2011 , Chap. 5, pages 89 -- 95 . Plattner H., Zeier A.. In-Memory Data Management: An Inflection Point for the Enterprise Applications. Springer publication, 2011, Chap. 5, pages 89--95."},{"key":"e_1_2_1_21_1","volume-title":"What's New in SAP ASE 1602, dd","author":"Product Documentation","year":"2016","unstructured":"SAP ASE Product Documentation , What's New in SAP ASE 1602, dd . Dec. 2016 . SAP ASE Product Documentation, What's New in SAP ASE 1602, dd. Dec. 2016."},{"key":"e_1_2_1_22_1","volume-title":"What's New in SAP Adaptive Server Enterprise 16.0 SP02, MemScale Option. dd.","author":"Whitepaper","year":"2015","unstructured":"SAP ASE Whitepaper , www.sap.com , What's New in SAP Adaptive Server Enterprise 16.0 SP02, MemScale Option. dd. 2015 . SAP ASE Whitepaper, www.sap.com, What's New in SAP Adaptive Server Enterprise 16.0 SP02, MemScale Option. dd. 2015."},{"key":"e_1_2_1_23_1","volume-title":"Performance Scalability Enhancements in SAP ASE. Discussion on Scalability Enhancements in ASE 16.0, dd.","author":"Technical Whitepaper","year":"2014","unstructured":"SAP ASE Technical Whitepaper , www.sap.com , Performance Scalability Enhancements in SAP ASE. Discussion on Scalability Enhancements in ASE 16.0, dd. 2014 . SAP ASE Technical Whitepaper, www.sap.com, Performance Scalability Enhancements in SAP ASE. Discussion on Scalability Enhancements in ASE 16.0, dd. 2014."},{"key":"e_1_2_1_24_1","volume-title":"June","year":"2017","unstructured":"SAP ASE 16.0.3 online documentation , SAP ASE In-Memory Database User's Guide , June 2017 . SAP ASE 16.0.3 online documentation, SAP ASE In-Memory Database User's Guide, June 2017."},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213946"},{"key":"e_1_2_1_26_1","first-page":"1150","volume-title":"VLDB","author":"Stonebraker M.","year":"2007","unstructured":"Stonebraker M. , Madden S. , Abadi D.J The End of an Architectural Era (It's time for a complete rewrite) . In VLDB , pages 1150 -- 1160 , 2007 . Stonebraker M., Madden S., Abadi D.J et al. The End of an Architectural Era (It's time for a complete rewrite). In VLDB, pages 1150--1160, 2007."},{"key":"e_1_2_1_27_1","unstructured":"VoltDB. http:\/\/www.voltdb.com  VoltDB. http:\/\/www.voltdb.com"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3229863.3229875","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:15:05Z","timestamp":1672222505000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3229863.3229875"}},"subtitle":["hybrid in-memory database architecture for extreme transaction processing in VLDBs"],"short-title":[],"issued":{"date-parts":[[2018,8]]},"references-count":27,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2018,8]]}},"alternative-id":["10.14778\/3229863.3229875"],"URL":"https:\/\/doi.org\/10.14778\/3229863.3229875","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2018,8]]}}}