Database Systems - Week 6

Comparing MongoDB with MySQL, the first thing that strikes me is that MongoDB is not a relational database.  There are no keys that are strictly tied to other keys.  MongoDB stores data in documents using JSON.  MySQL uses rows and columns.

MongoDB is easier to scale and can handle larger amounts of data more easily.  Using Mongo, you can store data with more flexibility allowing for more complex data storage.  Using MySQL, you would have to have tables and relations set up before data can be stored.

MongoDB uses MQL, a query language based on JavaScript, while MySQL uses SQL which was developed to communicate with relational databases.

I would choose Mongo if I needed to store large amounts of unstructured data.  Also if I needed flexibilty in changing data and high performance searching through mass amounts of data.

I would choose MySQL if I needed a relational database with a well defined schema.  Also if I needed to keep data consistency and needed to insert, update and retrive data frequently.

Comments

Post a Comment

Popular posts from this blog

Learning Journal Final Entry...

     Well, this is the toughest journal entry I've had to write so far as I am excited to be moving forward but sad to finish this journey I have been on for so many years. I am 39 years old and have wanted to be a Software Developer since I was a kid. I had big plans while attending Jr College but life had a different plan in mind where I started a family at the age of 19 and I decided to put my goals of software development on hold. 17 years later, I was married to my wife raising 3 children, and working at the High School I graduated from while also coaching Football and Wrestling. I loved what I was doing but I felt like I missed out on my goals.      Covid hit and everything shut down. No more coaching and most of my job duties were diminished. It was at that time that I decided I would go back and finish my degree and make my career in Software Development a priority. Now here I am 4 years later and I'm finally finishing what I started out to do. I fi...
Read more

Software Engineering - Week 8

This is the final week of my Software Engineering class and I thoroughly enjoyed working on the projects I was presented with.  The five most important things I learned in the class are Selenium automated testing, Spring Boot Framework, Authentication, Stories and Epics, and React. I chose these because they have the most real-world applications and interest me. I have seen these things listed in job descriptions and knew they were used in many applications. Using Selenium to automate testing is a nice skill to have as it allows you to automate web browser interactions, making it easier to test web applications and have repeatable tests when updates are released. Spring Boot framework allows you to build web applications more quickly and with less code and is fairly simple to implement. Learning Authentication using JWT (JSON Web Tokens) is a very good skill because so many web applications use authentication. Learning about the Agile methodology and how it works with epics and sto...
Read more

Computer Networks - Week 8

This is the final week of my computer networking class, and it's been a journey of learning and discovery. This week, we focused on some security implementation, learning about firewalls and intrusion detection systems. I learned about the fundamentals of firewalls, which act as a protective barrier between internal networks and the outside world. Firewalls help with filtering network traffic and preventing unauthorized access. We also learned about intrusion detection systems (IDS), which are designed to detect and respond to potential threats or attacks within a network.  At the link layer, we focused on wireless security, recognizing the importance of protecting wireless networks from unauthorized access. I learned about encryption methods, authentication mechanisms, and best practices for securing wireless networks. Lastly, we have been working on finishing our team project and it has been a great learning experience.  This class has been an enlightening experience learnin...
Read more