NoSQL database

-

 


Data is everywhere, it is expanding with each passing day. Relational Database systems are kind of fixed and static. When we have something in abundance and without any standard formation, then the tables of relational database systems cry out. 

So what to do with so many data integrations from several structured as well as unstructured sources. Well, the answer is to go for NoSQL (Not Only SQL). SQL is a structured query language that is used to query Relational Databases. However, NoSQL database does not contain data in the form of relations. Most of the NoSQL databases follow the JSON type structure to store data. 

 

Formal Definition:

 

   Guru99 provides a pretty nice definition for NoSQL databases:

"NoSQL Database is a non-relational Data Management System, that does not require a fixed schema. It avoids joins and is easy to scale. The major purpose of using a NoSQL database is for distributed data stores with humongous data storage needs. NoSQL is used for Big data and real-time web apps. For example, companies like Twitter, Facebook, and Google collect terabytes of user data every single day."

Types of NoSQL databases:

 

There are several types of NoSQL databases, such as: 

  • Key-Value 
    • DyanamoDB by Amazon, Redis, and Velocity are examples of Key-value databases.
    • Use cases: Gaming, ad tech, IoT, and web crawling.
  • Document
    • NoSQL databases like MongoDB, Elasticsearch, IBM Domino, and Couchbase fall into Document databases.
    • Use case: Content management systems, user profiles, and catalogs.
  • Graph
    • Typical examples for graph database includes Amazon Neptune, Giraph, and Neo4j.
    • Use cases: Recommendation systems, fraud detection, and social networking.
  • In-memory
  • Search 
    • Amazon ElasticSeach Service falls into the search database.
    • Use cases: Full-text search.


When to use NoSQL databases:

 

As mentioned above, when you have a huge amount of data from different standard/non-standard data and you need to perform real-time operations over that data to generate real-time results then you would be using NoSQL databases.

 

Companies using a NoSQL database: 

 

  • ContentStudio.io
  • Teradata
  • Facebook
  • IBM
  • Amazon
  • Snapchat 

And the list goes on... 

 

Conclusion

To recapitulate and to create synergy between this very article and my previous data engineering-related blog posts, here is a summary:

  • Till now we have gone through Data Engineering
  • Data Modeling
  • Relational Database systems
  • and now this NoSQL database

Hope you are enjoying these blog posts, if you have any query feel free to reach out via comment section.

In the next blog post, we will talk about the applications of Data Engineering and it's use cases.

Happy Learning :)

---

References: aws 

                   Wikipedia

                   Guru99 

---

 

Comments

  1. StaffMergeApril 16, 2021 at 11:36 PM

    Thanks for this post. StaffMerge provides an amazing Tips for Video Interviewing to make you employable faster.

    ReplyDelete

Post a Comment

Popular posts from this blog

Data Engineering Tools

-
Image
   Data is a new oil. To channelize this data we need proper pipelines. These pipelines are mostly called ETL or data pipelines.  There are various tools out there to work out these Extract, Transform, and Load (ETL) operations.  Some of the scripting tools are:  - Python - SQL and NoSQL Apache provides a wide range of products that can be used as Data Engineering tools.  Some of the amazing apache DE services comprised of; - Hadoop - Spark - Kafka - Cassandra - Hive In addition, some cool DE tools are: - Tableau - Talend - MapReduce These DE tools provide a way to manage the data pipelines in a more effective, efficient, and better way.  Almost every Data-Oriented company in the corporate sector is highly dependent upon these technologies. They are leveraging many of the above-mentioned mechanisms for promising Data Services and Architecture. That's it for today. Hope you have enjoyed this article. If you want to know more about data or software related concepts, let me know in th
Read more

1-Machine Learning : Start...

-
Image
John went to the cafeteria 10 times at 1:00 P.M. on 10 Fridays, each time the cafeteria was closed at that particular time. John decided not to go to cafe at 1:00 P.M. on Friday because the cafe will be closed.  But wait! How did John know that the cafe will  also be closed on next Friday at 1:00 P.M.??? Yes, you are absolutely right.  "John Learned from his Experience that the Task of going to the cafeteria at 1:00 P.M. on Fridays resulted in waste of time, since the cafe was closed on each Friday, so it will Perform the same on the next Friday." In the above scenario, John learned something so we can call it " John Learning ". Similarly, if we replace John with some sort of Machine, that can learn from the Experience or from the History about how the tasks were performed in the past given certain situation. Such that the Machine will perform the same if the same task happen again in near future. Then this will be called as Machine Learning. To mak
Read more

A Survey of the Final Year University Students

-
Image
I don't know what should be the title of this blog post, but let's call it " A survey of the final year university students ". Pretty long title, huh? Okay, let me tell you about this survey... The story behind this thing: Well, one day I thought about writing a post on Facebook to ask people about their sentiments and reviews regarding the final year of university life, then another thought knocked my head to write a full blog post on this topic. Then I disseminated a google form for this purpose. The google form was saying: "Hello, final semester people! I thought to collect reviews of 2020 graduates specifically of NUST and other IT universities. I am planning to add these to my blog post. Please take a few seconds to fill this form, thank you." So that was a brief story behind this whole thing, Now let's have a look at the most awaited questions and the corresponding responses...  Question#1:  Do you feel like a better hu
Read more

Habits to adopt in the freshman year

-
Image
We are what we repeatedly do. Excellence, then, is not an act but a habit. ~Aristotle Have you ever noticed? When you were a kid, your parents used to correct you all the time, whenever you did some mistake. Why did they do so? Because at that time you were growing at the conscience and the sub-conscience level. Your mind was setting some patterns at that time. And today, you are mostly acting out of those patterns. Your parents want great patterns for you, that's why they used to scold you at an early age. The patterns set at that time is what you repeatedly do and that is what we call, "the habit".  Similarly, when you are a fresher you could adopt certain habits that could make or break you in the long run. Every one of us wants to have constructive habits. so here are some habits that you could adopt as a fresher in order to function well in coming years... Habits to Have 1. Googling Search on google for difficult and different concepts. Make it your h
Read more

UI / UX Designs

-
Image
Is there any website or an application that you enjoyed to use ? If I ask you why you like this particular application then most of you would say that it is fluent, it's easy to use or the theme is so soothing.  So what is behind all these user friendly themes and designs ? The answer is, UI and UX designs. UI stands for User Interface while UX is used for User Experience. In today's world it is important to provide user friendly interface. Your application must be liked by everyone to the extent that they don't want to close that tab.  Now lets dig deep into UI and UX designs.... UI vs UX designs.. The first thing is that UI designs focus on the interface or the front end, the application is providing to the user. It has to deal with beauty. How beautiful, attractive and good-looking is your application; determines its User Interface. While UX design deals with the experience of the user. Whether the user feels comfortable while using your application
Read more

PHP chess board : how to make ?

-
Image
As we have learned much of the basics of  HTML and CSS . Let us now learn how can we make our web applications more user friendly, flexible and versatile, using php . Today we will see how to make a chess board using php in collaboration with HTML and CSS .  So, Let's start: BASIC php SYNTAX: Starting Closing Tags: <?php ?> Php code must be written in these tags. Variables:              Start with "$" sign e.g. $num=3;               ; is really important to put after every statement. Functions:              Functions start with the keyword "function". E.g. function power(){} Print:             echo "printing by using echo";             echo ("printing by using echo");             print "printing by using print";             print ("echo "printing by using print"); CODE: <!DOCTYPE html> <html> <
Read more

Applications of Data Engineering

-
Image
In a previous blog post about data engineering, we went through several many concepts related to data engineering such as data modeling, and then we went through different types of databases, for example, relational databases and we also got a glimpse of relational as well as NoSQL databases. And in today's blog post we will be writing about data engineer applications. Which are basically the use cases of data engineering 1st let's see what data engineering applications mean; so basically when we have data and we have engineered it then there are several things that we can do with that data and these things that we can do with processed data are the use cases of the data engineering. For example: If we have filled our containers with the data then it's not of any good use if it is not clean and well-formed. If your data is well-formed and if there are no logical mistakes, missing values, and garbage then we can easily perform the use cases and applications of data enginee
Read more

Web Applications

-
Image
When did you open your Facebook last time? Have you connected with other people on Linked In? If not then, you might have sent an email... What am I talking about? Image Source That's right! I am talking about Web applications . Web applications are the applications that run over the web or an Internet. There are some differences between website and web applications. Difference between Websites and Web applications.. The main differences between websites and web applications are as under: Websites: Provide information as a static file. Not very much interactive. Don't allow the user to do transactions. For example: news feeds, blogs, images etc. Web applications: Provide dynamic data. Interactive rather than just informative. Allow the user to do transactions. For example: bidding sites, on-line shopping sites, mailing sites, facebook, Twitter and Wikipedia etc. How do they work? On an abstract and simple level, The client(web browser
Read more

An Interview with Pakistani Data Scientist : Dr. Zeeshan Ul Hassan Usmani

-
Image
Dr. Zeeshan-ul-Hassan Usmani, the name known for Data Science, Predictify me, Eisenhower fellowship  and most importantly motivation for many of the students. He is the Author of book like  (C++) ++سی/سی ,  Bit Coin Block Chain aur Crypto Currency بٹ کوائن، بلاک چین اور کرپٹو کرنسی  and many other, you can visit them here . Today "Mainly: The Software Engineering Blog" asked him some of the questions, as an interview and we are very glad that he gave his precious time to answer them. It was kinda "Remote Interview"... not the traditional one.. The Interview Question:  How can you describe " Dr. Zeeshan ul Hassan Usmani " ? ANSWER: I am a shameless idealist. We are all idealists at some stage of our lives but then it fades away and we live as a mediocre. I don’t want it to fade away. I remind myself almost every day that I need to make my today better than my yesterday, and the challenge is keep getting harder J . We only need to co
Read more

Hollow Diamond

-
Image
Drawing different shapes with the help of coding is quite  enjoyable and interesting. Mostly the first semester students of software engineering encounter with this. so, let us learn, how to draw a hollow diamond using python? First of all declare variables: Diamond consists of two cones , upper cone with pointed top and lower cone with pointed bottom . so let us write the code for the upper cone, but the cone must be hollow: The resultant of this code is as under: Now, write the code for lower hollow cone: The output for this code is: Now, run both the codes simultaneously, and the output is: the reason for this output: This is one of the possibilities of writing code, to get this output. There might be other ways of doing the same task. Keep finding and trying different ways of coding. And do remember: Programming language doesn't matter but logic matters . So, work mainly on logic building .
Read more