poster

I/O characteristics of MongoDB and trim-based optimization in flash SSDs

Authors:

EDB '16: Proceedings of the Sixth International Conference on Emerging Databases: Technologies, Applications, and Theory

Pages 139 - 144

https://doi.org/10.1145/3007818.3007844

Published: 17 October 2016 Publication History

Get Access

Abstract

NoSQL solutions become emerging for large scaled, high performance, schema-flexible applications. WiredTiger is cost effective, non-locking, no-overwrite storage used as default storage engine in MongoDB. Understanding I/O characteristics of storage engine is important not only for choosing suitable solution with an application but also opening opportunities for researchers optimizing current working system, especially building more flash-awareness NoSQL DBMS. This paper explores background of MongoDB internals then analyze I/O characteristics of WiredTiger storage engine in detail. We also exploit space management mechanism in WiredTiger by using TRIM command.

References

[1]

Sadalage, Pramod J., and Martin Fowler. NoSQL distilled: a brief guide to the emerging world of polyglot persistence. Pearson Education, 2012.

Digital Library

Google Scholar

[2]

Stonebraker, M. (2010). SQL databases v. NoSQL databases. Communications of the ACM, 53(4), 10--11.

Digital Library

Google Scholar

[3]

DeCandia, G., Hastorun, D., Jampani, M., Kakulapati, G., Lakshman, A., Pilchin, A., ... & Vogels, W. (2007). Dynamo: amazon's highly available key-value store. ACM SIGOPS Operating Systems Review, 41(6), 205--220.

Digital Library

Google Scholar

[4]

Chang, F., Dean, J., Ghemawat, S., Hsieh, W. C., Wallach, D. A., Burrows, M., ... & Gruber, R. E. (2008). Bigtable: A distributed storage system for structured data. ACM Transactions on Computer Systems (TOCS), 26(2), 4.

Digital Library

Google Scholar

[5]

Lee, S. W., Moon, B., Park, C., Kim, J. M., & Kim, S. W. (2008, June). A case for flash memory SSD in enterprise database applications. In Proceedings of the 2008 ACM SIGMOD international conference on Management of data (pp. 1075--1086). ACM.

Digital Library

Google Scholar

[6]

Schindler, J. (2012). I/O characteristics of NoSQL databases. Proceedings of the VLDB Endowment, 5(12), 2020--2021.

Digital Library

Google Scholar

[7]

Kim, S. H., Kim, J. S., & Maeng, S. (2012). Using solid-state drives (SSDs) for virtual block devices. Proceedings of the runtime environments, systems, layering and virtualized environments (RESoLVE'12).

Google Scholar

[8]

Oh, G., Seo, C., Mayuram, R., Kee, Y. S., & Lee, S. W. (2016, June). SHARE Interface in Flash Storage for Relational and NoSQL Databases. In Proceedings of the 2016 International Conference on Management of Data (pp. 343--354). ACM.

Digital Library

Google Scholar

[9]

WiredTiger, http://source.wiredtiger.com/2.7.0/index.html.

Google Scholar

[10]

The MongoDB 3.2 Manual https://docs.mongodb.com/manual/

Google Scholar

[11]

Cooper, B. F., Silberstein, A., Tam, E., Ramakrishnan, R., & Sears, R. (2010, June). Benchmarking cloud serving systems with YCSB. In Proceedings of the 1st ACM symposium on Cloud computing (pp. 143--154). ACM.

Digital Library

Google Scholar

Cited By

View all

Hwang JKim SPark DSong YHan JChoi SCho SWon YBagchi SZhang Y(2024)ZMSProceedings of the 2024 USENIX Conference on Usenix Annual Technical Conference10.5555/3691992.3692003(173-189)Online publication date: 10-Jul-2024
https://dl.acm.org/doi/10.5555/3691992.3692003
Bergman SCassel NBjørling MSilberstein M(2023)ZNSwap: un-Block your SwapACM Transactions on Storage10.1145/358243419:2(1-25)Online publication date: 1-Feb-2023
https://dl.acm.org/doi/10.1145/3582434
Nguyen TLee S(2019)PB-NVMJournal of Systems Architecture: the EUROMICRO Journal10.1016/j.sysarc.2019.03.00797:C(20-33)Online publication date: 1-Aug-2019
https://dl.acm.org/doi/10.1016/j.sysarc.2019.03.007
Show More Cited By

Index Terms

I/O characteristics of MongoDB and trim-based optimization in flash SSDs
1. Information systems
  1. Data management systems
    1. Database management system engines
      1. Database transaction processing
      2. Parallel and distributed DBMSs

Recommendations

Comparing NoSQL MongoDB to an SQL DB
ACMSE '13: Proceedings of the 51st annual ACM Southeast Conference

NoSQL database solutions are becoming more and more prevalent in a world currently dominated by SQL relational databases. NoSQL databases were designed to provide database solutions for large volumes of data that is not structured. However, the ...
Modeling MongoDB with Relational Model
EIDWT '13: Proceedings of the 2013 Fourth International Conference on Emerging Intelligent Data and Web Technologies

Relational databases have been prevailing for the last two decades, with features of clear semantics and ease of use with SQL supported by the underlying theory, relational algebra. Relational databases provide good support for structural data ...
Enhancement of Database Access Performance by Improving Data Consistency in a Non-relational Database System (NoSQL)
Computational Science and Its Applications – ICCSA 2024 Workshops
Abstract
This study aims to improve data consistency in NoSQL databases, which traditionally follow BASE properties instead of the strong consistency guaranteed by ACID principles in RDBMS. We have developed a four-stage server-side model specifically for ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

EDB '16: Proceedings of the Sixth International Conference on Emerging Databases: Technologies, Applications, and Theory

October 2016

183 pages

ISBN:9781450347549

DOI:10.1145/3007818

General Chairs:
Jinho Kim,
Young-Kuk Kim,
James Geller,
Program Chairs:
Wonik Choi,
Carson K. Leung,
Young-Ho Park

Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 17 October 2016

Check for updates

Author Tags

Qualifiers

Poster

Conference

EDB

Sponsor:

KoDB
Nara System
2e consulting

EDB: 2016 International Conference on Emerging Databases

October 17 - 19, 2016

Jeju, Republic of Korea

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

4
Total Citations
View Citations
261
Total Downloads

Downloads (Last 12 months)14
Downloads (Last 6 weeks)2

Reflects downloads up to 12 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Hwang JKim SPark DSong YHan JChoi SCho SWon YBagchi SZhang Y(2024)ZMSProceedings of the 2024 USENIX Conference on Usenix Annual Technical Conference10.5555/3691992.3692003(173-189)Online publication date: 10-Jul-2024
https://dl.acm.org/doi/10.5555/3691992.3692003
Bergman SCassel NBjørling MSilberstein M(2023)ZNSwap: un-Block your SwapACM Transactions on Storage10.1145/358243419:2(1-25)Online publication date: 1-Feb-2023
https://dl.acm.org/doi/10.1145/3582434
Nguyen TLee S(2019)PB-NVMJournal of Systems Architecture: the EUROMICRO Journal10.1016/j.sysarc.2019.03.00797:C(20-33)Online publication date: 1-Aug-2019
https://dl.acm.org/doi/10.1016/j.sysarc.2019.03.007
Nguyen TLee S(2017)Optimizing MongoDB Using Multi-streamed SSDProceedings of the 7th International Conference on Emerging Databases10.1007/978-981-10-6520-0_1(1-13)Online publication date: 14-Oct-2017
https://doi.org/10.1007/978-981-10-6520-0_1

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Comparing NoSQL MongoDB to an SQL DB

Modeling MongoDB with Relational Model

Enhancement of Database Access Performance by Improving Data Consistency in a Non-relational Database System (NoSQL)