Week 23

-

Compare MongoDB with MySQL.

What are some similarities?

They are both open source, run on multiple OS, support indexing, and support many programming languages.

What are some differences?

MySQL uses tables with rows and columns, and MongoDB uses JSON-like documents. MySQL uses enforced schema, while MongoDB is schemaless. MySQL supports joins and prefers vertical scaling. While MongoDB doesn't and prefers horizontal scaling.

When would you choose one over the other? 

Choose MySQL when you need structured data with well-defined relationships, rely heavily on joins, foreign keys, and/or complex SQL queries. MongoDB is better when data is unstructured, nested, or constantly evolving. If you're dealing with large-scale data and need horizontal scalability. 

Comments

Post a Comment

Popular posts from this blog

Week 1

-
 I'm excited to begin my first official week at CSUMB CS online! I started off the first week by going over the lecture. I learned about how we will be utilizing APA format, different sources and what is expected of us, paraphrasing, and plagiarism. I will do my best throughout the year and I believe I'm off to a great start. This Thursday I will thoroughly review the writing lab and begin. Let's have a great first week.
Read more

Week 4

-
Set Your Educational Goals      I have several educational goals. The first one is a strong understanding of core computer science concepts such as data structures and algorithms, operating systems, databases, and computer networks. A deep understanding of advanced math such as calculus, discrete math, and linear algebra will also help. With a clear emphasis on getting better at programming, that will be beneficial. I also want to have an internship and more personal projects. I then want to specialize in an area of computer science, maybe artificial intelligence as that's what I wrote for my paper but it's still up in the air. I want to be good at communicating, teamwork, and problem-solving. Set Your Career Goals      Short term wise I want to land a role in my specific interest. Whether it be software development, data science/AI, cybersecurity, or other fields. Then build technical depth and gain industry experience. I can then network with others to fu...
Read more

Week 2

-
Image
Part 1:      The first thing I'm good at is schedules, I agree there is a ton of value to schedules and they save an immense amount of time. Figuring out what days and hours I have available to do what work also relieves stress on my mind because I know I will figure out those problems when my availability is open to do so. One thing I'm not good at is not storing my notes in a good place. I'm scatterbrained in that sense so according to this effective study skills document I should try and consolidate my notes for better retention of information. The second thing I'm good at is answering easy questions first, as soon as I'm stumped I skip past it to let my subconscious handle it and get on an easier problem. Another thing I'm bad at is reading multiple-choice questions, I have a bad habit of rushing so I need to take some time to read the questions multiple times to make sure I understand what is being asked. I do have a good study space, that is quiet and comf...
Read more