CST 363: Week 7

Compare MongoDB with MySQL. 

What are some similarities? 

Both MongoDB and MySQL support indexes and have built in query languages. They are also both compatible with a variety of programming languages like python and java

What are some differences? 

MongoDB is schema less, where MySQL is not. MongoDB stores data in documents and uses its own query language called MQL, where MySQL stores data in tables and uses SQL as the query language of choice.

When would you choose one over the other? 

I will choose MySQL when I need to use complex joins and need the compliances that come with ACID. 
MongoDB would be my choice when I need to use flexible, unstructured data.

Comments

Post a Comment

Popular posts from this blog

Week 2 Learning Journal Post

Image
  Part 1: Learning Strategies When it comes to learning strategies, three areas I feel I am good at are creating an adequate study space, establishing study habits, and taking notes. Before I study, I make sure to clean my desk area and have drinks and snacks nearby for easy to reach replenishment. Then when I study, I make sure to add my notes in OneNote along with my assignment and quiz due dates so I can make sure to highlight and organize details based on when something will be needed for either. As for study habits, I make sure to set a timer so I don't sit down for more than 2 hours at a time so I can make sure to move around or give my brain a rest. Additionally, three areas I believe I am weakest in are writing papers, answering easy questions first, and not reading aloud. These all have a tendency to make me take longer doing assignments than I should have to. When I am writing a paper, like our industry analysis paper, I get so stuck on the words I am choosing and whether...
Read more

Week 1: Learning about CSUMB and the CS Major.

    This week, w e learned more about California State University Monterey Bay (CSUMB) and its school for computing and design (SCD). Prior to this course, I only had consideration for the computer science (CS) degree program, and it did not occur to me what else the school had to offer. It was interesting to learn about the campus' origin as an army base turned university and inspiring to hear how the university aims to mold their students into what sounds like successful and contributing individuals.      In addition to learning more about CSUMB and the SCD, we also began to work on our first essay outline and conducted a review of APA style formatting for referencing sources. I took a small number of English courses at my community college, so taking the time to review APA is essential for me to succeed in this course. For my essay, I decided to do an analysis of the cybersecurity industry, which is where I hope to work in after graduating.    ...
Read more

Week 3 Learning Journal Post

Part 1: Time Management and Study Strategy There was a short period of time when I first started college that I would go to the library to study, but that caused me social anxiety and I began focusing more on those around me than my work, so I just study at home. To improve my notetaking, I am going to try using the split page method and using colors. Additionally, I stated last week that I spent more time that I had allotted for my essay draft, so something new I plan to try is not to be a perfectionist and prioritize better.  Part 2: Learnings from This Week In addition to the other parts of this post, we gathered together with our teams to look into the various courses that are offered within the computer science (CS) curriculum and how they may serve an importance to us as CS majors. Additionally, we reviewed our Individual Learning Plans which indicate what courses we are expected to take and when we will take them. We also took some time to learn about how well we can read ot...
Read more