CST363: Learning Journal Week 7





Prompt for this week's journal entry.

Compare MongoDB with MySQL.


  • What are some similarities?

MySQL and MongoDB are similar in the sense that they are both database management systems. They both have their own query languages that allow you to manage and manipulate any stored data.

  • What are some differences?

One of the biggest differences between MySQL and MongoDB is how they store data. MySQL stores data in tables whereas MongoDB basically uses JSON documents for storing data without a strict schema. In that way MySQL is much more structured and rigid. MongoDB is also capable of vertical and horizontal scaling while MySQL can’t be scaled across multiple systems.

  • When would you choose one over the other?

I would choose MySQL for smaller scale projects that require advanced queries to retrieve data in unique ways. MongoDB seems like a much better choice for large scale projects that may need to be scaled up to handle larger datasets and more bandwidth. I’m much less familiar with MongoDB compared to MySQL though, so I might change my opinion in the future and choose to exclusively use one of the two or a different option entirely.

Comments

Post a Comment

Popular posts from this blog

CST438: Journal Entry Week 1

Q. What did you expect a course in Software Engineering would cover? A. I believed we'd be building desktop applications with graphical user interfaces. Q. After completing week 1, how has your opinion changed? A. It turns out we're working on web services instead. I think that my personal preference toward desktop apps over web-based ones, especially regarding sensitive information and potential security concerns, is why I had the wrong initial impression.
Read more

CST370: Journal Entry Week 3

Week 3 is ending already! We learned about brute-force string matching as well as depth and breadth-first search algorithms. I was already familiar with the divide and conquer algorithm design, but it was still good to read more about it. The homework this week was torture. The first program about Depth-First Search took me forever to do and I found the instructions to be confusing. The hint really saved me on that one. The second program was easier in the way that we just needed to use brute force over more complicated algorithms. Anyways that’s all for now. The midterm is coming up soon and I hope I’m prepared for it.
Read more

CST311: Journal Entry Week 7

We covered chapter 6 of the textbook which was about link layers, but that was overshadowed by the much bigger thing this week, the final exam. One difference I noticed between the midterm and the final was that the midterm had much more overlap with the pre-midterm questions than the final had with the pre-final. That didn’t turn out to be much of an issue since I still scored pretty well in the end. This class is basically over now. I’m not bothering with any more extra credit work since it won’t make a meaningful difference to my grade since I already have an A. There’s just the programming assignment 4, and chapter 8.9 quiz, and the week 8 journal, which I probably won’t have much to say in since I’ll have to turn that in within 4 days from the date this one is published. That’s all for now.
Read more