{"id":325,"date":"2016-12-14T10:21:59","date_gmt":"2016-12-14T10:21:59","guid":{"rendered":"http:\/\/mansainfotech.com\/blog\/?p=325"},"modified":"2016-12-14T10:21:59","modified_gmt":"2016-12-14T10:21:59","slug":"choosing-or-not-choosing-mysql-vs-mongodb","status":"publish","type":"post","link":"https:\/\/mansainfotech.com\/blog\/choosing-or-not-choosing-mysql-vs-mongodb\/","title":{"rendered":"CHOOSING OR NOT CHOOSING \u2013 MYSQL? VS MONGODB?"},"content":{"rendered":"

In terms of IT, today, we all are living in the golden age of data management era. So, choosing the best database solution for yourself is a must.<\/span><\/span><\/p>\n

Here I provide my rundown on MySQL vs MongoDB \u2013 concepts, terminologies, feature comparison, and conclusion. Let’s get cracking then!<\/span><\/span><\/span><\/p>\n

OVERVIEW<\/b><\/span><\/span><\/pre>\n
Since the release of MySQL in 1995, it has remained most popular and inexpensive option. But with the burst in volume and variety of data in recent years, Databases such as MongoDB have come into view for addressing the requirements of new applications. Now, here comes the comparison between Relational Database (such as Mysql) and Non-relational Database (such as MongoDB).<\/span><\/span><\/span><\/p>\n
WHAT IS MYSQL?<\/b><\/span><\/span><\/p>\n
Developed, distributed, and supported by Oracle Corporation<\/span>, MySQL is one of the most popular and open-source RDBMS(relational database management system).<\/span><\/span><\/p>\n
It stores data in the form of tables(containing rows\/tuples), uses structured query language for accessing the database, as well as create an association between separate tables through the use of joins. These relational systems have taken the leadership for years while becoming an obvious choice for the IT professionals. <\/span><\/span><\/p>\n
WHAT IS MONGODB OR NOSQL DATABASE? <\/b><\/span><\/span><\/p>\n
Developed by MongoDB Inc., MongoDB is an open-source NoSQL Database. It come into existence when the capacity to handle large relational data stores became the challenge, thereby limiting system scalability.<\/span><\/span><\/p>\n
It stores data in JSON-like documents uses dynamic schemas and provides a cheaper way to build complex distributed systems. <\/span><\/span><\/p>\n
COMMON CONCEPTS AND TERMINOLOGIES<\/b><\/span><\/span><\/p>\n
The below table outlines the close analogue of Mysql as well as MongoDB:<\/span><\/span><\/p>\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
 
\n
MySQL<\/span><\/span><\/span><\/p>\n<\/td>\n
\n
MongoDB<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
Table<\/span><\/span><\/p>\n<\/td>\n
\n
Collection<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
Row <\/span><\/span><\/p>\n<\/td>\n
\n
Document<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
Column<\/span><\/span><\/p>\n<\/td>\n
\n
Field<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
Joins<\/span><\/span><\/p>\n<\/td>\n
\n
Embedded documents<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
COMPARING FEATURES OF MYSQL & MONGODB<\/b><\/span><\/span><\/p>\n
Both databases offer a rich set of features and functionalities.Let’s discuss them below:<\/span><\/span><\/p>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
 
<\/td>\n\n
MYSQL<\/span><\/span><\/span><\/p>\n<\/td>\n
\n
MONGODB<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
Easy for programmers<\/span><\/span><\/p>\n<\/td>\n
\n
No<\/span><\/span><\/p>\n<\/td>\n
\n
Yes<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
Are transactions complex?<\/span><\/span><\/p>\n<\/td>\n
\n
Yes<\/span><\/span><\/p>\n<\/td>\n
\n
No<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
Contains rich data model<\/span><\/span><\/p>\n<\/td>\n
\n
No<\/span><\/span><\/p>\n<\/td>\n
\n
Yes<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
Dynamic schema<\/span><\/span><\/p>\n<\/td>\n
\n
No<\/span><\/span><\/p>\n<\/td>\n
\n
Yes<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
Query used<\/span><\/span><\/p>\n<\/td>\n
\n
SQL<\/span><\/span><\/p>\n<\/td>\n
\n
JSON<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
And much more on the list…..<\/i><\/span><\/span><\/p>\n
QUERY LANGUAGE \u2013 MYSQL VS MONGODB<\/b><\/span><\/span><\/p>\n
Both of them have a rich query language. Let check out:<\/span><\/span><\/p>\n\n\n\n<\/colgroup>\n\n\n\n\n\n
 
\n
MYSQL<\/span><\/span><\/span><\/p>\n<\/td>\n
\n
MONGODB<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
INSERT INTO users (user_id, age, status)<\/span><\/span><\/p>\n
VALUES (‘bcd001’, 45, ‘A’)<\/span><\/span><\/p>\n<\/td>\n
\n
db.users.insert({<\/span><\/span><\/p>\n
user_id: ‘bcd001’,<\/span><\/span><\/p>\n
age: 45,<\/span><\/span><\/p>\n
status: ‘A’<\/span><\/span><\/p>\n
})<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
SELECT * FROM users<\/span><\/span><\/p>\n<\/td>\n
\n
db.users.find()<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n
\n
UPDATE users SET status = ‘C’<\/span><\/span><\/p>\n
WHERE age > 25<\/span><\/span><\/p>\n<\/td>\n
\n
db.users.update(<\/span><\/span><\/p>\n
{ age: { $gt: 25 } },<\/span><\/span><\/p>\n
{ $set: { status: ‘C’ } },<\/span><\/span><\/p>\n
{ multi: true }<\/span><\/span><\/p>\n
)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/pre>\n
So, Here I’ve discussed the few points of Mysql and Mongodb. Both are easy, convenient and functionality rich. Yet, MongoDB has achieved a greater edge over the other in terms of Fast & diverse data types, removes ORM(object-relational mapping) layer, it is schemaless and much scalable.<\/span><\/span><\/span><\/p>\n
So, choose the one that meets your requirement and keeps coding. See you again with my next blog. Cheerio:) <\/span><\/b><\/span><\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
In terms of IT, today, we all are living in the golden age of data management era. So, choosing the best database solution for yourself is a must. Here I provide my rundown on MySQL vs MongoDB \u2013 concepts, terminologies, feature comparison, and conclusion. Let’s get cracking then! OVERVIEW Since … Continue reading CHOOSING OR NOT CHOOSING \u2013 MYSQL? VS MONGODB?<\/span><\/a><\/p>\n","protected":false},"author":4,"featured_media":334,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67],"tags":[68,62,69,70,71],"class_list":["post-325","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-backend-development","tag-database","tag-florida","tag-mongodb","tag-mysql","tag-orm"],"_links":{"self":[{"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/posts\/325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/comments?post=325"}],"version-history":[{"count":0,"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/posts\/325\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/media\/334"}],"wp:attachment":[{"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/media?parent=325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/categories?post=325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mansainfotech.com\/blog\/wp-json\/wp\/v2\/tags?post=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}