Introduction to Databases - SQL, NoSQL, Graph Databases, Blockchain

Welcome to the discussion about this lecture. Here you can ask questions or post feedback about this specific lecture.

2 Likes

Well explained Ivan.

2 Likes

I’m still a little unclear with Graph databases. I sort of get what it does, but I guess I might like to see the ‘how’ it gets it. Perhaps it would have been helpful to see real-time querying of a SQL database, a NoSQL database and a Graph database. I’m looking forward to your discussion on how private blockchains brings them all together.

I agree it would be useful to see this in practice. Although I have no idea how easily “accessible” it’d be for Ivan to get access to different databases. I’m sure there’d also be some funky security/privacy issues there.

This video shows some examples of Graph databases and takes more of a deep-dive on it:

For SQL and NoSQL database examples:

Hope these help :slight_smile:

5 Likes

Good explanation about SQL, NoSQL ans Graph databases!

1 Like

Ivan is an amazing teacher, it is incredibly how such a young adult can explain complex things in a way that everyone can understand. Thanks so much for this excellent course packed with knowledge.

1 Like

I have a general question about which database to choose for a project.
Imagine, I have several sensor with data (timestamp and a value). That means I would choose NoSQL because I only have key-value pairs. But what if these data of the sensors have a clearly relationship to each other? For example I have a sensor which measure the pressure, the force, the displacements, the the vibrations and so on and so forth. And we know that the data of the sensors have a relationship together (pressure increase, force increase, vibration increase etc.). Which one should I use now? SQL? NoSQL? Or Graph?

1 Like

Good question, I see you posted this a couple of days ago.

I’m intrigued. Could you please post what you found out? I would be interested to know… :thinking:Ivo

1 Like

I would like to give you an answer, but I cannot. I thought the community here is more active…

I don’t understand. what does that have to do with the community being active? Did you even try to do a google search? and you found nothing at all? If even google don’t know, how would we know? I don’t get it.:thinking: maybe it’s because of the language.

Did you really mean that you wanted us to do the google searching for you, read the answers, then come back to this post, and explain to you what we found? is this a joke?

ok.

Please, Do us all a favor and at least try to find the answer yourself. Don’t always rely on others to hand you the answers on a sliver plate. You are taking the business masterclass, and I’m shocked that you waited 2 days for something that took under 10 seconds to find the answer to. To me, this is pure laziness. just being honest!

Here are your answers.
https://duckduckgo.com/?q=Which+one+should+I+use+now%3F+SQL%3F+NoSQL%3F+Or+Graph%3F&t=brave&ia=web

You can read it yourself, and see if you are able to make a decision on what fits your own project.

Ivo

Hello Ivo,

I have to say your answer is very unfriendly and not professional. Of course I googled it but I did not found a clear answer. OK, I google maybe 5 minutes, but not more, don´t wanted to waste a lot of time, because it was just a theoretical question. I thought it would be nice to post such question so that other people who has the same question can read also the answer. I wanted an answer from someone who has real experience with such an issue (implemented such a thing in real and not in writing just the theory in google). That being said I don’t wan´t someone to google something for me, I am able to do so. Of course, I can make a decision what the best is, but I as I said before I wanted to have an answer from someone who has implemented such issue in real practical applications. Next time I will add something to my post that it would be nice to have an answer from someone who has practical expertise on it.
And Ivo, call someone you don´t know in person over the internet lazy is shocking to me. Especially when you are working for a company and represent it on the internet. Why should I use the academy when it is not welcome to ask questions or get such answers?

However, thank your for your time and answer.

2 Likes
  1. Row = a single record or dataset in a table
  2. Column = a field or attribute in a record
  3. Table = a set of records that have similar attributes
1 Like

Very clearly explained. SQL NoSQL, GRAPH Publick Blockchain Private Blockchains All very interesting and looking forward to further videos. D

1 Like

Thank you for your inputs. I appreciate them and take them to heart.

Ivo

Hi, I am struggling to define the purpose of a graph database in my notes from the video explanation, would you say that with the restaurant analogyexplanation I could simple say that graph databases are used for more complex relations (which is said in the video) such as relations that involve ‘a greater number of variables’? or if not variables perhaps conditions. I feel as though that was what was being got at in the video?

That was good. I wasn’t previously aware of Graph DBs

Another example of a situation a graph database fits best is a chamber of commerce organization. They are storing all information from company’s and their shareholders. You can be shareholder in many company’s to get a clear overview of all company’s a shareholder can be involved fits best to a graph database.

I always used sql for everything but after this video I realized that
database graph also does the same as the other databases so it’s the best for everything,and faster than sql.
right?