Studi Literatur: Perbandingan Basis Data NewSQL
Bilah Samping Artikel
Isi Artikel Utama
Abstrak
Selama bertahun-tahun database relasional menjadi solusi untuk penyimpanan data sampai datang era Big Data. Kemudian database non-relasional (yang dikenal sebagai sistem database NoSQL) mulai dikembangkan sebagai solusi database yang mempunyai kecepatan tinggi dan scalable untuk menangani volume data yang terus meningkat. Di sisi lain, NoSQL mempunyai beberapa kekurangan, diantaranya : tidak support ACID (Atomicity, Consistency, Isolation, Durability) dan beberapa sistem database NoSQL tidak support SQL. NewSQL merupakan pengembangan dari NoSQL namun mendukung fitur ACID dan SQL.
Ada banyak sistem database NewSQL yang dikembangkan saat ini dengan arsitektur, fitur dan implementasi yang bervariasi. Dalam paper ini, kami mencoba melakukan quick review mengenai perkembangan database mulai dari database relasional yang tradisional, NoSQL hingga NewSQL. Kemudian dideskripsikan satu persatu mengenai sistem database NewSQL yang ada. Pada bagian akhir kami mencoba membandingkan beberapa database NewSQL pada lima aspek, diantaranya : Ease of Use, Features & Functionality, Advanced Features, Integration dan Performance.
Dari hasil perbandingan, pada aspek Ease of Use c-treeACE mendapat nilai tertinggi sedangkan Apache Trafodion menjadi yang terendah. Pada aspek Features & Functionality TIBCO ActiveSpaces menjadi yang tertinggi sedangkan VoltDB mendapat skor terendah. Selanjutnya, Altibase mendapat skor tertinggi pada aspek Advanced Features dan Apache Trafodion kembali menjadi yang terendah. Pada aspek Integration, skor tertinggi ada pada CockroachDB dan terendah ada pada Pivotal GemFire XD. Terakhir, pada aspek Performance, ActorDB menjadi yang tertinggi dan Apache Trafodion menjadi yang terendah lagi.
##plugins.themes.bootstrap3.displayStats.downloads##
Rincian Artikel
Artikel ini berlisensi Creative Commons Attribution 4.0 International License.
Hak cipta pada setiap artikel adalah milik penulis, dan penulis mengakui bahwa Jnanaloka sebagai pihak yang mempublikasikan pertama kali dengan lisensi Creative Commons Attribution (CC BY). Lisensi ini mengijinkan untuk, Berbagi yakni menyalin dan menyebarluaskan kembali materi ini dalam bentuk atau format apapun; dan Adaptasi yakni menggubah, mengubah, dan membuat turunan dari materi iniuntuk kepentingan apapun, termasuk kepentingan komersial dengan ketentuan Atribusi
Cara Mengutip
Referensi
U. Eze, C. Etus, and J. Uzukwu, “Database System Concepts, Implementations and Organizations-A Detailed Survey,” Int. J. Sci. Eng. Res., vol. 2, Feb. 2014.
A. Saeed, “Role of Database Management Systems (DBMS) in Supporting Information Technology in Sector of Education,” Int. J. Sci. Res., vol. 6, pp. 6–391, May 2015, doi: 10.21275/ART20173499.
H. Bediar, “Challenges and Security Vulnerabilities to Impact on Database Systems,” Al-Mustansiriyah J. Sci., vol. 29, p. 117, Nov. 2018, doi: 10.23851/mjs.v29i2.332.
T. Das and M. Mishra, “A Study on Challenges and Opportunities in Master Data Management,” Int. J. Database Manag. Syst., vol. 3, May 2011, doi: 10.5121/ijdms.2011.3209.
T. Rao, E. Haq, and D. KHAN, “Performance based Comparison between RDBMS and OODBMS,” Int. J. Comput. Appl., vol. 180, pp. 42–46, Feb. 2018, doi: 10.5120/ijca2018916410.
H. Phiri and D. Kunda, “A Comparative Study of NoSQL and Relational Database,” Zamb. ICT J., vol. 1, pp. 1–4, Dec. 2017, doi: 10.33260/zictjournal.v1i1.8.
H. S. Damesha, “Object Oriented Database Management Systems-Concepts, Advantages, Limitations and Comparative Study with Relational Database Management Systems,” Glob. J. Comput. Sci. Technol., vol. 15, 2015.
L. Matei, “Big Data Issues: Performance, Scalability, Availability,” J. Mob. Embed. Distrib. Syst., vol. 6, no. 1, Art. no. 1, Mar. 2014.
M. Aslett, “NoSQL, NewSQL and Beyond: The answer to SPRAINed relational databases,” Too much information - The 451 Take on information management, 2011. https://blogs.451research.com/information_management/2011/04/15/nosql-newsql-and-beyond/ (accessed Oct. 30, 2020).
M. Murazzo, P. Gómez, N. Rodríguez, and D. Medel, “Database NewSQL Performance Evaluation for Big Data in the Public Cloud,” in Cloud Computing and Big Data, Cham, 2019, pp. 110–121.
J. Oliveira and J. Bernardino, “NewSQL Databases - MemSQL and VoltDB Experimental Evaluation,” Jan. 2017, pp. 276–281, doi: 10.5220/0006518902760281.
M. Madison, M. Barnhill, C. Napier, and J. Godin, “NoSQL Database Technologies,” J. Int. Technol. Inf. Manag., vol. 24, no. 1, Jan. 2015, [Online]. Available: https://scholarworks.lib.csusb.edu/jitim/vol24/iss1/1.
R. Kumar and S. Charu, “NewSQL Databases: Scalable RDBMS for OLTP Needs to Handle Big Data,” Mar. 2014, doi: 10.13140/RG.2.1.2915.8561.
K. W. Ong, Y. Papakonstantinou, and R. Vernoux, “The SQL++ Semi-structured Data Model and Query Language: A Capabilities Survey of SQL-on-Hadoop, NoSQL and NewSQL Databases,” ArXiv, May 2014.
A. Watt, “Chapter 3 Characteristics and Benefits of a Database,” in Database Design - 2nd Edition, BCcampus, 2014.
A. Pavlo and M. Aslett, “What’s really new with NewSQL?,” ACM SIGMOD Rec., vol. 45, pp. 45–55, Sep. 2016, doi: 10.1145/3003665.3003674.
T. Clohessy, T. Acton, and L. Morgan, “The Impact of Cloud-Based Digital Transformation on ICT Service Providers’ Strategies,” Jun. 2017, pp. 111–125, doi: 10.18690/978-961-286-043-1.9.
P. Kaur and G. Sharma, “Scalable Database Management in Cloud Computing,” Procedia Comput. Sci., vol. 70, pp. 658–667, Dec. 2015, doi: 10.1016/j.procs.2015.10.102.
K. Grolinger, W. Higashino, A. Tiwari, and M. Capretz, “Data management in cloud environments: NoSQL and NewSQL data stores,” J. Cloud Comput. Adv. Syst. Appl., vol. 2, Dec. 2013, doi: 10.1186/2192-113X-2-22.
R. Kumar, B. Parashar, S. Gupta, Y. Sharma, and N. Gupta, “Apache Hadoop, NoSQL and NewSQL Solutions of Big Data,” Nov. 2014, doi: 10.13140/2.1.3454.9444.
A. B. M. Moniruzzaman, “NewSQL: Towards Next-Generation Scalable RDBMS for Online Transaction Processing (OLTP) for Big Data Management,” Int. J. Database Theory Appl., vol. 7, Nov. 2014, doi: 10.14257/ijdta.2014.7.6.11.
M. Mohamed, O. Altrafi, and M. Ismail, “Relational Vs. NoSQL databases: A survey,” Int. J. Comput. Inf. Technol. IJCIT, vol. 03, p. 598, May 2014.
K. Berg, Dr. T. Seymour, and R. Goel, “History Of Databases,” Int. J. Manag. Inf. Syst. IJMIS, vol. 17, p. 29, Dec. 2012, doi: 10.19030/ijmis.v17i1.7587.
A. Zahid, R. Masood, and A. Shibli, “Security of sharded NoSQL databases: A comparative analysis,” Jun. 2014, pp. 1–8, doi: 10.1109/CIACS.2014.6861323.
L. Okman, N. Gal-Oz, Y. Gonen, E. Gudes, and J. Abramov, “Security Issues in NoSQL Databases,” in 2011IEEE 10th International Conference on Trust, Security and Privacy in Computing and Communications, Nov. 2011, pp. 541–547, doi: 10.1109/TrustCom.2011.70.
W. Zugaj and A. S. Beichler, “Analysis of Standard Security Features for Selected NoSQL Systems,” Am. J. Inf. Sci. Technol., vol. 3, no. 2, Art. no. 2, Jul. 2019, doi: 10.11648/j.ajist.20190302.12.
M. Aslett, “How will the database incumbents respond to NoSQL and NewSQL?,” 451 TECHDEALMAKER, 2011.
M. Stonebraker, “New SQL: An Alternative to NoSQL and Old SQL For New OLTP Apps.” https://cacm.acm.org/blogs/blog-cacm/109710-new-sql-an-alternative-to-nosql-and-old-sql-for-new-oltp-apps/fulltext (accessed Oct. 31, 2020).
T. Hoff, “Google Spanner’s Most Surprising Revelation: NoSQL is Out and NewSQL is In - High Scalability -.” http://highscalability.com/blog/2012/9/24/google-spanners-most-surprising-revelation-nosql-is-out-and.html (accessed Oct. 31, 2020).
H. Tailor, S. Choudhary, and V. Jain, “Rise Of NewSql,” Apr. 2014, doi: 10.13140/2.1.4756.1608.
A. B. M. Moniruzzaman and S. Hossain, “NoSQL Database: New Era of Databases for Big data Analytics - Classification, Characteristics and Comparison,” Int J Database Theor Appl, vol. 6, Jun. 2013.
E. Erturk and K. Jyoti, “Perspectives on a Big Data Application: What Database Engineers and IT Students Need to Know,” Eng. Technol. Appl. Sci. Res., vol. 5, pp. 850–853, Oct. 2015, doi: 10.5281/zenodo.31794.
O. S. Tezer, “Understanding SQL and NoSQL Databases and Different Database Models,” DigitalOcean. https://www.digitalocean.com/community/tutorials/understanding-sql-and-nosql-databases-and-different-database-models (accessed Nov. 01, 2020).
A. Almassabi, O. Bawazeer, and S. Adam, “Top NewSQL Databases and Features Classification,” Int. J. Database Manag. Syst., vol. 10, no. 2, pp. 11–31.
I. Journal, “Critical Analysis of Database Management Using NewSQL,” IJCSMC, Accessed: Nov. 02, 2020. [Online]. Available: https://www.academia.edu/7110029/Critical_Analysis_of_Database_Management_Using_NewSQL_.
E. G. Caldarola and A. Rinaldi, “Big Data: A Survey The New Paradigms, Methodologies and Tools,” Jul. 2015, doi: 10.5220/0005580103620370.
ClustrixDB, “How ClustrixDB RDBMS Scales Writes & Reads-Distributed Relational Database Architecture: An Overview.” ClustrixDB WHITE PAPER, [Online]. Available: www.clustrix.com.
“ClustrixDB in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 18, 2016. https://www.predictiveanalyticstoday.com/clustrixdb/ (accessed Nov. 02, 2020).
R. Taft et al., “CockroachDB: The Resilient Geo-Distributed SQL Database,” Jun. 2020, pp. 1493–1509, doi: 10.1145/3318464.3386134.
B. Darnell, “CockroachDB-Scalable, survivable, strongly consistent, SQL.” Cockroach LABS, [Online]. Available: https://www.cc.gatech.edu.
K. Rabbani and I. P. MASLI, “COCKROACHDB-NewSQL Distributed, Cloud Native Database.” UNIVERSITE LIBRE DE BRUXELLES, 2017.
“CockroachDB in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 22, 2016. https://www.predictiveanalyticstoday.com/cockroachdb/ (accessed Nov. 02, 2020).
Intel, “How NuoDB and Intel Optane Enable Enterprises to Boost Performance, Cut Costs, and Improve Scalability of Their Transaction Processing Systems.” Intel Corporation, 2019, [Online]. Available: https://www.intel.co.uk/.
NuoDB, “NuoDB Technical Overview: The Distributed SQL Database for Modern Applications.” www.nuodb.com, [Online]. Available: http://go.nuodb.com/rs/099-DVI-451/images/Technical-Overview.pdf.
“NuoDB in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 18, 2016. https://www.predictiveanalyticstoday.com/nuodb/ (accessed Nov. 02, 2020).
B. Djamaluddin and S. Mohammed, “Survey of Big Data New SQL Database Systems for Real-Time Data Transfer in the Upstream Oil and Gas Industry,” Aug. 2018, doi: 10.2118/192412-MS.
“Pivotal GemFire XD in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 22, 2016. https://www.predictiveanalyticstoday.com/pivotal-gemfire-xd/ (accessed Nov. 02, 2020).
H.-S. Yang and S. Kim, “A Study on ALTIBASE TM LOG ANALYZER method for highly scalable, high-availability,” 2014, doi: 10.14400/JDC.2014.12.5.1.
“Altibase in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 23, 2016. https://www.predictiveanalyticstoday.com/altibase/ (accessed Nov. 02, 2020).
I. Hrubaru and M. Fotache, “On the Performance of Three In-Memory Data Systems for On Line Analytical Processing,” Inform. Econ., vol. 21, pp. 5–15, Mar. 2017, doi: 10.12948/issn14531305/21.1.2017.01.
“MemSQL in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 18, 2016. https://www.predictiveanalyticstoday.com/memsql/ (accessed Nov. 03, 2020).
M. Stonebraker and A. Weisberg, “The VoltDB Main Memory DBMS,” IEEE Data Eng Bull, 2013.
“VoltDB in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 18, 2016. https://www.predictiveanalyticstoday.com/voltdb/ (accessed Nov. 03, 2020).
FairCom, “c-treeACE Technology Overview.” FairCom, [Online]. Available: www.faircom.com.
“c-treeACE in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 23, 2016. https://www.predictiveanalyticstoday.com/c-treeace/ (accessed Nov. 03, 2020).
R. Aparicio and I. Coz, “Database on Demand: insight how to build your own DBaaS,” J. Phys. Conf. Ser., vol. 664, p. 042021, Dec. 2015, doi: 10.1088/1742-6596/664/4/042021.
“Percona TokuDB in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 22, 2016. https://www.predictiveanalyticstoday.com/percona-tokudb/ (accessed Nov. 03, 2020).
A. Akhtar, Role of Apache Software Foundation in Big Data Projects. 2020.
“Apache Trafodion in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Jul. 23, 2017. https://www.predictiveanalyticstoday.com/apache-trafodion/ (accessed Nov. 03, 2020).
“TIBCO ActiveSpaces in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Sep. 22, 2016. https://www.predictiveanalyticstoday.com/tibco-activespaces/ (accessed Nov. 03, 2020).
M. Gökalp, K. Kayabay, M. Zaki, A. Koçyiğit, P. Eren, and A. Neely, Big-Data Analytics Architecture for Businesses: a comprehensive review on new open-source big-data tools. 2017.
“ActorDB in 2020 - Reviews, Features, Pricing, Comparison,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices, Jul. 23, 2017. https://www.predictiveanalyticstoday.com/actordb/ (accessed Nov. 03, 2020).
J. Corbett et al., “Spanner: Google’s Globally Distributed Database,” ACM Trans. Comput. Syst. TOCS, vol. 31, Aug. 2013, doi: 10.1145/2491245.
“Compare,” PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices. https://www.predictiveanalyticstoday.com/compare/ (accessed Nov. 03, 2020).