CST 363 Week 7

Compare MongoDB with MySQL. 

What are some similarities? 

Both MongoDB and MySQL are both databases that stores a collection of data that can be created, read, updated, and deleted. MongoDB can also represent the type of information, like integer, string, double, date, boolean, etc. Just like MySQL, it has indexing abilities and offers security with role-based access, authentication, and authorization.


What are some differences? 

The difference between MongoDB and MySQL is that MongoDB is a document-based style of collection whereas MySQL is a relational database. This means that it stores data objects as documents inside a collection as a binary JSON. As a result, the language style differs as well. MongoDB was also developed with the intention of scalability at the forefront of their mind.


When would you choose one over the other?  

If queries have more simple data types that can be adhered to, MySQL might be a good candidate, as MongoDB supports more complex data types, to include embedded objects and arrays.  Therefore, MySQL is a better pick for structured data that requires constraints and relationships. MongoDB is a good choice if the database would undergo rapid development and require more flexibility, like Internet of Things.


Comments

Post a Comment

Popular posts from this blog

04 February 2025

Interview with Bill McDermott The expert I decided to interview within the industry is Bill McDermott, the Technical Director of Test Operations at General Atomics. Bill is responsible for the research and development of the technology used and also manages special projects. He used to be the supervisor for my current mentor in the company, Roy Lara. It is through Roy that I became acquainted with Bill (I have a different supervisor). Now Bill is managing the Collaborative Combat Aircrafts (CCA) project for a contract we recently secured with the Air Force. I chose Bill as the expert I wanted to research because he is not only very knowledgeable, but the impression he leaves on me is different compared to other higher-ups in the company. Unlike other supervisors, Bill is rarely found in his office, but rather working hands-on tasks on the floor, whether it be routing fiber or connecting the different systems that compose a Ground Control Station (GCS). Bill is also personally writing...
Read more

Week 7

  Homework One assignment was the Markov Prompt. It read a text file and generated a collection of words and those that followed it to generate a new text. Sometimes the new sentences made sense and sometimes, they were just strange. It is funny to think about how I thought it was such a difficult assignment, but looking back, it was the only one I managed to get all the tests to pass on. I think I had the best approach with it so far, reading the prompt for understanding, then going through it once more to set up skeleton methods, prior to writing the code. How I would approach it differently is to sit down and think about my approach a little more. The prompt seemed so thorough and like it covered everything, that I just went for it. However, when it was time, I got stuck on areas like addWord and getSentence for DAYS because algorithms matter. I would also better organize myself with each method by creating a chart, because as I worked on some of them, I realized it made calls t...
Read more

January 21, 2025

Image
Review and Reflect: Based on the Effective Study Skills paper, three areas that I am strong in are: scheduling my study times, surveying what I am going to be studying, and reciting. I start out every week reviewing all the assignments so I can decide what will require more of my time. I set aside 1.5 hours after work to go to the gym and shower then understand I will get straight to studying afterwards. I tend to talk to myself a lot for anything, even reading a word I never seen before. I will say it out loud to make sure I understand it. Three areas that I think I can improve on is: reading, reviewing, and true-false questions. I find myself constantly getting in a cycle of reading and not really comprehending what I just read, so I have to reread the material. As I am usually in a rush, I don't review enough if I feel like I got it. My test scores sometimes beg to differ. But this also correlates with the fact that I tend to overthink small details in true-false questions, ofte...
Read more