{"id":15133,"date":"2016-05-14T11:00:00","date_gmt":"2016-05-14T11:00:00","guid":{"rendered":"https:\/\/www.whizlabs.com\/?p=15133"},"modified":"2020-09-01T07:01:34","modified_gmt":"2020-09-01T07:01:34","slug":"open-source-databases","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/open-source-databases\/","title":{"rendered":"Open source databases"},"content":{"rendered":"

\u201cData\u201d is growing exponentially today due to the Internet age and \u201cstudying Data\u201d, \u201canalyzing Data\u201d have become a necessity for most professions. Data is stored in \u201cdatabases\u201d and storing this data in databases too has evolved over time. Oracle and Microsoft SQL Server were examples of popular databases that were used to store data. Things slowly changed with the explosion of data and open source databases were born. We will look at a few open source databases in this post.<\/span><\/p>\n

MongoDB:<\/span><\/h2>\n

MongoDB is an open source database developed by MongoDB Inc. and written in C++. Data was traditionally only stored in tables as rows and columns. For any database developer in the 1990s, it was difficult to think of data in any other way.<\/span><\/p>\n

\u00a0But all this changed in the mid 2000s, when MongoDB entered the \u201cNoSQL\u201d way of handling data. Dynamic schemas are used in MongoDB and the structure of the database, such as the type of field does not have to be defined first. This is one of the highlights of the MongoDB database \u2013 the ability to add and delete fields dynamically, whereby we can change the structure of database. <\/span><\/p>\n

\u00a0In MongoDB, a table is a \u201ccollection\u201d, a row is a \u201cdocument\u201d and a column is a \u201cfield\u201d. MongoDB has its own query language known as the MongoDB query language. Its chief advantages are high scalability and high availability.<\/span><\/p>\n

MetLife, Expedia.com, Facebook, Cisco are examples of few organizations who have embraced MongoDB. (Flexible enough to fit any industry)<\/span><\/p>\n

MySQL:<\/span><\/h2>\n

MySQL is a traditional open source RDBMS created and released in 1995. It was eventually acquired, by Oracle in 2010.\u00a0 It features the traditional terminology and concepts related to RDBMS \u2013 namely, tables, primary keys, foreign keys, relationships and more. <\/span><\/p>\n

It is written in \u2018C\u2019 and \u2018C++\u2019 and uses the SQL or \u2018Structured query language\u2019 for querying, inserting and updating records. It supports up to 50 million records in a table. While MySQL does not have the dynamic schema or the rich data model of NoSQL databases like MongoDB, it is still used by legacy systems and cannot be entirely replaced by NoSQL databases.<\/span><\/p>\n

Some of the organizations that are using MySQL are Alcatel-Lucent, Pinterest, Sears, Walmart and more.<\/span><\/p>\n

The need of an organization sometimes might be to use both NoSQL and SQL databases to satisfy all the business requirements accordingly.<\/span><\/p>\n

\"db_rankings\"<\/a><\/p>\n

PostgreSQL:<\/span><\/h2>\n

PostgreSQL or just Postgres was initially released in 1996 and is an open source object relational database management system. It is written in the \u2018C\u2019 programming language and is one of the most popular open source databases for startups. (Oracle’s biggest database foe: Could it be Postgres?)<\/span><\/p>\n

It runs on all major operating systems and some limits are stated as follows:<\/span><\/p>\n

Maximum database size in Postgres: Unlimited<\/span><\/p>\n

Maximum Table size in Postgres: 32TB<\/span><\/p>\n

Maximum row size in Postgres: 1.6TB<\/span><\/p>\n

Maximum rows\/table in Postgres: unlimited<\/span><\/p>\n

Postgres also supports MVCC or \u2018Multiversion Concurrency Control\u2019.\u00a0 MVCC involves transaction isolation for each database session. This largely avoids \u201cread locks\u201d and encourages better performance in multi-user environments.<\/p>\n

Apple, <\/span>University of Alabama, Birmingham, University of California, Berkeley are some organizations and universities that have built products, solutions using Postgres open source database.<\/p>\n

Cassandra:<\/h2>\n

Apache Cassandra initially developed by Facebook in 2008 is an open source distributed database management system to handle today\u2019s requirement of humungous amounts of data that is constantly streaming from different sources. It is a column oriented database.<\/span><\/p>\n

\u00a0<\/span>Some of the important features of Cassandra include constant up-time ensuring 24\/7 access to information and fault tolerance along with scalability. This is done by maintaining a \u201cring\u201d design than the classic master-slave design. All nodes in a cluster have the same role and nodes can be added with no major issues. Data is replicated across multiple data centers which provide low latency.<\/p>\n

\"mysql\"<\/a><\/p>\n

 <\/p>\n

Facebook\u2019s Instagram, Cisco\u2019s Webex, Netflix are examples of organizations that use Cassandra.<\/span><\/p>\n

\u00a0<\/span>We saw some interesting and popular open source databases in this post. We will explore some more technical topics in the next post.<\/p>\n

* Images from Google\u00a0<\/span><\/p>\n

Bibliography\n<\/span>Flexible enough to fit any industry<\/i>. (n.d.). Retrieved from mongodb.com: https:\/\/www.mongodb.com\/who-uses-mongodb\nOracle's biggest database foe: Could it be Postgres?<\/span><\/i> (n.d.). Retrieved from techrepublic.com: http:\/\/www.techrepublic.com\/article\/oracles-biggest-database-foe-could-it-be-postgres\/\n\n<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u201cData\u201d is growing exponentially today due to the Internet age and \u201cstudying Data\u201d, \u201canalyzing Data\u201d have become a necessity for most professions. Data is stored in \u201cdatabases\u201d and storing this data in databases too has evolved over time. Oracle and Microsoft SQL Server were examples of popular databases that were used to store data. Things slowly changed with the explosion of data and open source databases were born. We will look at a few open source databases in this post. MongoDB: MongoDB is an open source database developed by MongoDB Inc. and written in C++. Data was traditionally only stored […]<\/p>\n","protected":false},"author":220,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[13],"tags":[1095,1115,1160],"class_list":["post-15133","post","type-post","status-publish","format-standard","hentry","category-java","tag-mongodb","tag-mysql","tag-opensource-database"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"profile_24":false,"profile_48":false,"profile_96":false,"profile_150":false,"profile_300":false,"tptn_thumbnail":false,"web-stories-poster-portrait":false,"web-stories-publisher-logo":false,"web-stories-thumbnail":false},"uagb_author_info":{"display_name":"Aditi Malhotra","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/aditi\/"},"uagb_comment_info":0,"uagb_excerpt":"\u201cData\u201d is growing exponentially today due to the Internet age and \u201cstudying Data\u201d, \u201canalyzing Data\u201d have become a necessity for most professions. Data is stored in \u201cdatabases\u201d and storing this data in databases too has evolved over time. Oracle and Microsoft SQL Server were examples of popular databases that were used to store data. Things…","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/15133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/220"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=15133"}],"version-history":[{"count":1,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/15133\/revisions"}],"predecessor-version":[{"id":75983,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/15133\/revisions\/75983"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=15133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=15133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=15133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}