-

 

Week 7 – CST– 363 Introduction to Database Systems

Compare MongoDB with MySQL. What are some similarities? 

Now that the course has introduced MongoDB, I can see there are a few similarities between it and MySQL. They both offer a GUI interface for users to manipulate data with ease through the use of queries. For our lab 19 project, we used JDBC to program a web application using MySQL and for lab 21, we are also using Java to program the same application with MongoDB. That is because they are both compatible with many of the same languages including Java, Python, and Node.js. Lastly, both DBMS have the capability to improve query speeds by indexing frequently used data.

What are some differences? 

The main difference between MySQL and MongoDB is that MySQL is a relational database while MongoDB is document-oriented database. MySQL uses schemas with tables made up of columns and rows. These tables use keys and foreign keys to establish relationships with other tables. MongoDB stores data objects as documents inside a collection. A collection is a group of documents. It uses BSON documents which are single data objects that are composed of field/value pairs.

 When would you choose one over the other? 

MySQL is ACID-compliant which means that transactions are atomic, consistent, isolated, and durable. This makes MySQL ideal for use in fields where data is highly structured, and transactions are complex like e-commerce or financial transactions. MongoDB, on the other hand, is a NoSQL database that is unstructured and does not require a schema. This makes it ideal for use with data generated by the internet of things, Email, or social media.

Comments

Post a Comment

Popular posts from this blog

-
Week 4 – CST – 300 Module 4 OLI – Module 4 and 5 This week’s OLI required us to meet with our team and discuss what we have learned from this unit. It was interesting to compare what I have learned to what the rest of my team learned from their experience with the unit. The assignment included an activity called “2 Truths, 1 Lie” which required each team member to share three strengths related to our group project. Of the three strengths, two were supposed to be truths and one a lie without disclosing which were truths and which was the lie. The rest of the team had to guess which of the three was the lie. For the most part, we were all able to pick out the lie from the strengths. That activity showed me that we are becoming familiar with our team members’ strengths which will help in assigning tasks during challenging projects. The last part of the assignment consisted of answering questions from what each of us shared. Everyone of our members agreed that it is a good idea to allo...
Read more
-
  Week 5 – CST – 300 Module 5 OLI – Module 6 and 7 The OLI for this week was interesting. It helped us recognize conflict and showed us how to deal with them using different conflict strategies. Module 6 showed us a video where Kurt and Freda had a conversation which quickly escalated into a conflict. Freda was questioning the level of a platform that had been checked already. Kurt told Freda that he didn’t trust her leveling phone app. After arguing for some time, Kurt noticed that the platform was not level because there was a piece of wood underneath it. I first noticed the conflict when Kurt told Freda that he did not trust her leveling app around the 15 second mark of the video. Module 7 was challenging, here we had to use the best conflict strategy to deal with conflict based on how important the relationship is and how much do we care about the problem. An example was in the scenario where you asked Taylor, a friend of a friend for a ride to get wood because your car...
Read more
-
Week 8 – CST – 300 Module 8 OLI – Post-Test This week we had to take the post-test which was a culmination of what we have learned throughout the course. It started off with opinion questions where you had to choose whether you agreed or disagreed with the statement. I compared my answers to the pre-test answers and, although they are not graded, I believe my answers improved. From the OLI modules, I learned that you must consider everyone’s opinions and to use conflict resolution techniques when there is difference of opinions. When someone is expressing their opinion, you must use active listening and let them know you understood by repeating to them what they told you in your own words. For dealing with conflicts, you must use active listening and then formulate an assertion message to deal with the conflict.   Part 1: Review Other Team’s Final Video Projects Gigabit Goon Squad Public Video – 1.       Is the topic well covered? Yes, I bel...
Read more