{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,1,9]],"date-time":"2024-01-09T23:27:21Z","timestamp":1704842841773},"reference-count":63,"publisher":"Springer Science and Business Media LLC","issue":"5","license":[{"start":{"date-parts":[[2015,11,17]],"date-time":"2015-11-17T00:00:00Z","timestamp":1447718400000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["The VLDB Journal"],"published-print":{"date-parts":[[2016,10]]},"DOI":"10.1007\/s00778-015-0410-5","type":"journal-article","created":{"date-parts":[[2015,11,17]],"date-time":"2015-11-17T05:50:53Z","timestamp":1447739453000},"page":"651-672","update-policy":"http:\/\/dx.doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":13,"title":["Exploiting SSDs in operational multiversion databases"],"prefix":"10.1007","volume":"25","author":[{"given":"Mohammad","family":"Sadoghi","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kenneth A.","family":"Ross","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mustafa","family":"Canim","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bishwaranjan","family":"Bhattacharjee","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2015,11,17]]},"reference":[{"key":"410_CR1","unstructured":"BioPostgres: Data management for computational biology. http:\/\/www.biopostgres.org\/"},{"key":"410_CR2","unstructured":"IBM DB2 Database for Linux, UNIX, and Windows. www.ibm.com\/software\/data\/db2\/linux-unix-windows\/"},{"key":"410_CR3","unstructured":"IBM DB2 with BLU Acceleration. www.ibm.com\/software\/data\/db2\/linux-unix-windows\/db2-blu-acceleration\/"},{"key":"410_CR4","unstructured":"OpenFTS: Open source full text search engine. http:\/\/openfts.sourceforge.net\/"},{"key":"410_CR5","unstructured":"PostGIS: Geographic information systems. http:\/\/postgis.refractions.net\/"},{"key":"410_CR6","unstructured":"PostgreSQL: Open source object-relational database system. http:\/\/www.postgresql.org\/"},{"key":"410_CR7","unstructured":"YAGO2: High-quality knowledge base. http:\/\/www.mpi-inf.mpg.de\/yago-naga\/yago\/"},{"issue":"1","key":"410_CR8","first-page":"361","volume":"2","author":"D Agrawal","year":"2009","unstructured":"Agrawal, D., Ganesan, D., Sitaraman, R.K., Diao, Y., Singh, S.: Lazy-adaptive tree: an optimized index structure for flash devices. PVLDB 2(1), 361\u2013372 (2009)","journal-title":"PVLDB"},{"issue":"2","key":"410_CR9","doi-asserted-by":"crossref","first-page":"85","DOI":"10.1016\/0020-0190(94)00176-Y","volume":"53","author":"C-H Ang","year":"1995","unstructured":"Ang, C.-H., Tan, K.-P.: The interval B-tree. Inf. Process. Lett. 53(2), 85\u201389 (1995)","journal-title":"Inf. Process. Lett."},{"key":"410_CR10","unstructured":"Arpaci-Dusseau, R., Arpaci-Dusseau, A.: Operating Systems: Three Easy Pieces. Arpaci-Dusseau Books, 0.5 edition (2012)"},{"key":"410_CR11","doi-asserted-by":"crossref","unstructured":"Athanassoulis, M., Chen, S., Ailamaki, A., Gibbons, P.B., Stoica, R.: MaSM: efficient online updates in data warehouses. In: SIGMOD Conference, pp. 865\u2013876 (2011)","DOI":"10.1145\/1989323.1989414"},{"issue":"4","key":"410_CR12","doi-asserted-by":"crossref","first-page":"264","DOI":"10.1007\/s007780050028","volume":"5","author":"B Becker","year":"1996","unstructured":"Becker, B., Gschwind, S., Ohler, T., Seeger, B., Widmayer, P.: An asymptotically optimal multiversion B-Tree. VLDB J. 5(4), 264\u2013275 (1996)","journal-title":"VLDB J."},{"issue":"2","key":"410_CR13","doi-asserted-by":"crossref","first-page":"1462","DOI":"10.14778\/1687553.1687573","volume":"2","author":"B Bhattacharjee","year":"2009","unstructured":"Bhattacharjee, B., Lim, L., Malkemus, T., Mihaila, G., Ross, K., Lau, S., McArthur, C., Toth, Z., Sherkat, R.: Efficient index compression in DB2 LUW. Proc. VLDB Endow. 2(2), 1462\u20131473 (2009)","journal-title":"Proc. VLDB Endow."},{"key":"410_CR14","unstructured":"Bhattacharjee, B., Malkemus, T., Lau, S., Mckeough, S., Kirton, J.-A., Boeschoten, R.V., Kennedy, J.: Efficient bulk deletes for multi dimensionally clustered tables in DB2. In: VLDB, pp. 1197\u20131206 (2007)"},{"key":"410_CR15","doi-asserted-by":"crossref","unstructured":"Bhattacharjee, B., Ross, K.A., Lang, C.A., Mihaila, G.A., Banikazemi, M.: Enhancing recovery using an SSD buffer pool extension. In: DaMoN, pp. 10\u201316 (2011)","DOI":"10.1145\/1995441.1995443"},{"key":"410_CR16","doi-asserted-by":"crossref","first-page":"541","DOI":"10.1007\/BFb0054512","volume":"1460","author":"T Bozkaya","year":"1998","unstructured":"Bozkaya, T., \u00d6zsoyo\u011flu, M.: Indexing valid time intervals. Lect. Notes Comput. Sci. 1460, 541\u2013550 (1998)","journal-title":"Lect. Notes Comput. Sci."},{"issue":"2","key":"410_CR17","first-page":"1318","volume":"2","author":"M Canim","year":"2009","unstructured":"Canim, M., Bhattacharjee, B., Mihaila, G.A., Lang, C.A., Ross, K.A.: An object placement advisor for DB2 using solid state storage. PVLDB 2(2), 1318\u20131329 (2009)","journal-title":"PVLDB"},{"issue":"2","key":"410_CR18","first-page":"1435","volume":"3","author":"M Canim","year":"2010","unstructured":"Canim, M., Mihaila, G.A., Bhattacharjee, B., Ross, K.A., Lang, C.A.: SSD bufferpool extensions for database systems. PVLDB 3(2), 1435\u20131446 (2010)","journal-title":"PVLDB"},{"issue":"1","key":"410_CR19","doi-asserted-by":"crossref","first-page":"7","DOI":"10.1109\/69.908978","volume":"13","author":"S Chaudhuri","year":"2001","unstructured":"Chaudhuri, S., Narasayya, V.: Automating statistics management for query optimizers. IEEE Trans. Knowl. Data Eng 13(1), 7\u201320 (2001)","journal-title":"IEEE Trans. Knowl. Data Eng"},{"key":"410_CR20","unstructured":"Chaudhuri, S., Narasayya, V.R.: An efficient cost-driven index selection tool for microsoft SQL server. In: Proceedings of the 23rd International Conference on Very Large Data Bases, VLDB \u201997, pp. 146\u2013155. Morgan Kaufmann Publishers Inc., San Francisco (1997)"},{"key":"410_CR21","unstructured":"Chen, F., Luo, T., Zhang, X.: CAFTL: a content-aware flash translation layer enhancing the lifespan of flash memory based solid state drives. In: FAST, pp. 77\u201390 (2011)"},{"key":"410_CR22","unstructured":"Chen, S.: Time travel query or bi-temporal. In: DB2 for z\/OS Technical Forum (2010)"},{"key":"410_CR23","doi-asserted-by":"crossref","unstructured":"Do, J., Zhang, D., Patel, J.M., DeWitt, D.J., Naughton, J.F., Halverson, A.: Turbocharging DBMS buffer pool using SSDs. In: Proceedings of the 2011 ACM SIGMOD International Conference on Management of data, SIGMOD \u201911, pp. 1113\u20131124. ACM, New York (2011)","DOI":"10.1145\/1989323.1989442"},{"key":"410_CR24","doi-asserted-by":"crossref","unstructured":"Dou, A.J., Lin, S., Kalogeraki, V.: Real-time querying of historical data in flash-equipped sensor devices. In: IEEE Real-Time Systems Symposium, pp. 335\u2013344 (2008)","DOI":"10.1109\/RTSS.2008.30"},{"key":"410_CR25","unstructured":"Drossel, G.: Methodologies for calculating SSD usable life. In: Storage Developer Conference (2009)"},{"key":"410_CR26","unstructured":"Elmasri, R., Wuu, G.T.J., Kouramajian, V.: The time index and the monotonic B+-tree. In: Temporal Databases, pp. 433\u2013456 (1993)"},{"key":"410_CR27","unstructured":"Fusion-io breaks one billion IOPS barrier. http:\/\/www.fusionio.com\/press-releases\/fusion-io-breaks-one-billion-iops-barrier\/"},{"key":"410_CR28","volume-title":"Database Systems: The Complete Book","author":"H Garcia-Molina","year":"2008","unstructured":"Garcia-Molina, H., Ullman, J.D., Widom, J.: Database Systems: The Complete Book, 2nd edn. Prentice Hall Press, Upper Saddle River, NJ (2008)","edition":"2"},{"key":"410_CR29","unstructured":"The GiST indexing project. http:\/\/gist.cs.berkeley.edu\/"},{"issue":"3","key":"410_CR30","doi-asserted-by":"crossref","first-page":"496","DOI":"10.1109\/69.224200","volume":"5","author":"H Gunadhi","year":"1993","unstructured":"Gunadhi, H., Segev, A.: Efficient indexing methods for temporal relations. IEEE Trans. Knowl. Data Eng. 5(3), 496 (1993)","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"410_CR31","unstructured":"Hellerstein, J.M., Naughton, J.F., Pfeffer, A.: Generalized search trees for database systems. In: Proceedings of the 21th International Conference on Very Large Data Bases, VLDB \u201995, pp. 562\u2013573. Morgan Kaufmann Publishers Inc., San Francisco (1995)"},{"key":"410_CR32","unstructured":"Hinshaw, F.D., Harris, C.S., Sarin, S.K.: Controlling visibility in multi-version database systems. US 7305386 Patent, Netezza Corporation (2007)"},{"key":"410_CR33","unstructured":"Hitz, D., Lau, J., Malcolm, M.: File system design for an NFS file server appliance. In: Proceedings of the USENIX Winter 1994 Technical Conference, WTEC\u201994, pp. 19\u201319. USENIX Association, Berkeley (1994)"},{"key":"410_CR34","unstructured":"DB2 10 for z\/OS. ftp:\/\/public.dhe.ibm.com\/software\/systemz\/whitepapers\/DB210_for_zOS_Upgrade_ebook"},{"key":"410_CR35","volume-title":"Building the Operational Data Store","author":"WH Inmon","year":"1999","unstructured":"Inmon, W.H.: Building the Operational Data Store, 2nd edn. Wiley, New York (1999)","edition":"2"},{"key":"410_CR36","doi-asserted-by":"crossref","unstructured":"Jouini, K., Jomier, G.: Indexing multiversion databases. In: Proceedings of the Sixteenth ACM Conference on Information and Knowledge Management, CIKM \u201907, pp. 915\u2013918. ACM, New York (2007)","DOI":"10.1145\/1321440.1321574"},{"issue":"11","key":"410_CR37","first-page":"1615","volume":"5","author":"W-H Kang","year":"2012","unstructured":"Kang, W.-H., Lee, S.-W., Moon, B.: Flash-based extended cache for higher throughput and faster recovery. PVLDB 5(11), 1615\u20131626 (2012)","journal-title":"PVLDB"},{"issue":"4","key":"410_CR38","doi-asserted-by":"crossref","first-page":"298","DOI":"10.14778\/2095686.2095689","volume":"5","author":"P-A Larson","year":"2011","unstructured":"Larson, P.-A., Blanas, S., Diaconu, C., Freedman, C., Patel, J.M., Zwilling, M.: High-performance concurrency control mechanisms for main-memory databases. Proc. VLDB Endow. 5(4), 298\u2013309 (2011)","journal-title":"Proc. VLDB Endow."},{"key":"410_CR39","doi-asserted-by":"crossref","unstructured":"Levandoski, J.J., Lomet, D.B., Sengupta, S.: The Bw-Tree: a B-tree for new hardware platforms. In: Proceedings of the 2013 IEEE 29th International Conference on Data Engineering, ICDE \u201913. IEEE Computer Society, Washington (2013)","DOI":"10.1109\/ICDE.2013.6544834"},{"issue":"7","key":"410_CR40","doi-asserted-by":"crossref","first-page":"47","DOI":"10.1145\/1364782.1364796","volume":"51","author":"A Leventhal","year":"2008","unstructured":"Leventhal, A.: Flash storage memory. Commun. ACM 51(7), 47\u201351 (2008)","journal-title":"Commun. ACM"},{"key":"410_CR41","doi-asserted-by":"crossref","unstructured":"Li, Y., He, B., Luo, Q., Yi, K.: Tree indexing on flash disks. In: Proceedings of the 2009 IEEE International Conference on Data Engineering, ICDE \u201909, pp. 1303\u20131306. IEEE Computer Society, Washington (2009)","DOI":"10.1109\/ICDE.2009.226"},{"key":"410_CR42","doi-asserted-by":"crossref","unstructured":"Lomet, D., Barga, R., Mokbel, M.F., Shegalov, G., Wang, R., Zhu, Y.: Immortal DB: transaction time support for SQL server. In: Proceedings of the 2005 ACM SIGMOD international conference on Management of data, SIGMOD \u201905, pp. 939\u2013941. ACM, New York (2005)","DOI":"10.1145\/1066157.1066295"},{"issue":"1","key":"410_CR43","doi-asserted-by":"crossref","first-page":"870","DOI":"10.14778\/1453856.1453951","volume":"1","author":"D Lomet","year":"2008","unstructured":"Lomet, D., Hong, M., Nehme, R., Zhang, R.: Transaction time indexing with version compression. Proc. VLDB Endow. 1(1), 870\u2013881 (2008)","journal-title":"Proc. VLDB Endow."},{"key":"410_CR44","doi-asserted-by":"crossref","unstructured":"Menon, P., Rabl, T., Sadoghi, M., Jacobsen, H.: CaSSanDra: an SSD boosted key-value store. In: IEEE 30th International Conference on Data Engineering, Chicago, ICDE 2014, IL, USA, March 31\u2013April 4, 2014, pp. 1162\u20131167 (2014)","DOI":"10.1109\/ICDE.2014.6816732"},{"key":"410_CR45","unstructured":"Murphy, G., Compher, D.: DB2 storage observations (2011)"},{"issue":"3","key":"410_CR46","doi-asserted-by":"crossref","first-page":"345","DOI":"10.1016\/0306-4379(91)90006-U","volume":"16","author":"E Omiecinski","year":"1991","unstructured":"Omiecinski, E., Liu, W., Akyildiz, I.F.: Analysis of a deferred and incremental update strategy for secondary indexes. Inf. Syst. 16(3), 345\u2013356 (1991)","journal-title":"Inf. Syst."},{"issue":"4","key":"410_CR47","doi-asserted-by":"crossref","first-page":"351","DOI":"10.1007\/s002360050048","volume":"33","author":"PE O\u2019Neil","year":"1996","unstructured":"O\u2019Neil, P.E., Cheng, E., Gawlick, D., O\u2019Neil, E.J.: The log-structured merge-tree (LSM-Tree). Acta Inf. 33(4), 351\u2013385 (1996)","journal-title":"Acta Inf."},{"key":"410_CR48","unstructured":"Oracle database 11g workspace manager overview. http:\/\/www.oracle.com\/technetwork\/database\/twp-appdev-workspace-manager-11g-128289"},{"key":"410_CR49","unstructured":"Oracle total recall\/flashback data archive. http:\/\/www.oracle.com\/technetwork\/issue-archive\/2008\/08-jul\/flashback-data-archive-whitepaper-129145"},{"issue":"12","key":"410_CR50","doi-asserted-by":"crossref","first-page":"1724","DOI":"10.14778\/2367502.2367512","volume":"5","author":"T Rabl","year":"2012","unstructured":"Rabl, T., G\u00f3mez-Villamor, S., Sadoghi, M., Munt\u00e9s-Mulero, V., Jacobsen, H.-A., Mankovskii, S.: Solving big data challenges for enterprise application performance management. Proc. VLDB Endow. 5(12), 1724\u20131735 (2012)","journal-title":"Proc. VLDB Endow."},{"key":"410_CR51","doi-asserted-by":"crossref","unstructured":"Rosenblum, M., Ousterhout, J.K.: The design and implementation of a log-structured file system. ACM Trans. Comput. Syst. 10(1), 26\u201352 (1992)","DOI":"10.1145\/146941.146943"},{"issue":"13","key":"410_CR52","doi-asserted-by":"crossref","first-page":"1331","DOI":"10.14778\/2733004.2733006","volume":"7","author":"M Sadoghi","year":"2014","unstructured":"Sadoghi, M., Canim, M., Bhattacharjee, B., Nagel, F., Ross, K.A.: Reducing database locking contention through multi-version concurrency. Proc. VLDB Endow. 7(13), 1331\u20131342 (2014)","journal-title":"Proc. VLDB Endow."},{"issue":"11","key":"410_CR53","doi-asserted-by":"crossref","first-page":"997","DOI":"10.14778\/2536222.2536226","volume":"6","author":"M Sadoghi","year":"2013","unstructured":"Sadoghi, M., Ross, K.A., Canim, M., Bhattacharjee, B.: Making updates disk-I\/O friendly using SSDs. Proc. VLDB Endow. 6(11), 997\u20131008 (2013)","journal-title":"Proc. VLDB Endow."},{"key":"410_CR54","doi-asserted-by":"publisher","unstructured":"Salzberg and Tsotras: Comparison of access methods for time-evolving data. CSURV. Comput. Surv. 31(2), 158\u2013221 (1999). doi: 10.1145\/319806.319816","DOI":"10.1145\/319806.319816"},{"key":"410_CR55","unstructured":"Samy, V., Lu, W., Rada, A., Punit, S., Srinivasan, S.: Best practices physical database design for online transaction processing (OLTP) environments (2011)"},{"key":"410_CR56","unstructured":"Saracco, C.M., Nicola, M., Gandhi, L.: A matter of time: temporal data management in DB2 for z\/OS (2010)"},{"key":"410_CR57","doi-asserted-by":"crossref","unstructured":"Sears, R., Ramakrishnan, R.: bLSM: a general purpose log structured merge tree. In: SIGMOD Conference, pp. 217\u2013228 (2012)","DOI":"10.1145\/2213836.2213862"},{"key":"410_CR58","doi-asserted-by":"crossref","unstructured":"Shen, H., Chin, B., Lu, O.H.: The TP-Index: a dynamic and efficient indexing mechanism for temporal databases. In: Proceedings of the Tenth International Conference on Data Engineering, pp. 274\u2013281. IEEE (1994)","DOI":"10.1109\/ICDE.1994.283041"},{"key":"410_CR59","volume-title":"A case study of temporal data","author":"RT Snodgrass","year":"2010","unstructured":"Snodgrass, R.T.: A case study of temporal data. Teradata Corporation, Dayton (2010)"},{"key":"410_CR60","unstructured":"TPC-H, decision support benchmark. http:\/\/www.tpc.org\/tpch\/"},{"issue":"10","key":"410_CR61","first-page":"1004","volume":"5","author":"HT Vo","year":"2012","unstructured":"Vo, H.T., Wang, S., Agrawal, D., Chen, G., Ooi, B.C.: LogBase: a scalable log-structured database system in the cloud. PVLDB 5(10), 1004\u20131015 (2012)","journal-title":"PVLDB"},{"key":"410_CR62","doi-asserted-by":"crossref","unstructured":"Volos, H., Tack, A.J., Swift, M.M.: Mnemosyne: lightweight persistent memory. In: Proceedings of the Sixteenth International Conference on Architectural Support for Programming Languages and Operating Systems, ASPLOS XVI, pp. 91\u2013104. ACM, New York (2011)","DOI":"10.1145\/1950365.1950379"},{"key":"410_CR63","doi-asserted-by":"publisher","unstructured":"Wu, C.-H., Kuo, T.-W., Chang, L.-P.: An efficient B-tree layer implementation for flash-memory storage systems. ACM Trans. Embedded Comput. Syst. 6(3) (2007). doi: 10.1145\/1275986.1275991","DOI":"10.1145\/1275986.1275991"}],"container-title":["The VLDB Journal"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s00778-015-0410-5.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s00778-015-0410-5\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s00778-015-0410-5","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,5,29]],"date-time":"2019-05-29T15:05:12Z","timestamp":1559142312000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s00778-015-0410-5"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2015,11,17]]},"references-count":63,"journal-issue":{"issue":"5","published-print":{"date-parts":[[2016,10]]}},"alternative-id":["410"],"URL":"https:\/\/doi.org\/10.1007\/s00778-015-0410-5","relation":{},"ISSN":["1066-8888","0949-877X"],"issn-type":[{"value":"1066-8888","type":"print"},{"value":"0949-877X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2015,11,17]]}}}