CST 363 Week 7 Reflection

-

 MySQL vs MongoDB

This week, we had the opportunity to work with MongoDB in our labs. After experiencing MongoDB and MySQL, there are a few similarities and differences that I noticed between the two. 

Similarities 

Both MySQL and MongoDB help the user create and interact with a database, especially large databases. After experiencing both, I feel that they are user-friendly and easy to use. They are both open-source software available for the public to use. They are also both adaptable to database programming. During this class, we have used both programs with Java to see how the programming language uses each one as a database with information obtained from a webpage. 

Differences 

MySQL is a relational database, while MongoDB is a non-relational database. MySQL holds data in tables with columns and rows, while MongoDB holds data in collections with documents in a JSON format. Each database uses a different programming language to complete its queries. MySQL uses SQL, and MongoDB can use a variety of different languages except SQL, hence it being called a NoSQL database. One language we used in our labs was Javascript. MongoDB also has a dynamic structure, meaning different documents can hold different information, while MySQL needs a set schema to be followed. Because of this, MongoDB stores, reads, and writes data faster than MySQL. 

When would you choose one over the other? 

MongoDB is the best choice when dealing with Big Data, such as social media, email, and the Internet of Things (IoT). Its unstructured schema allows data to be stored in various ways and accessed quickly. MySQL would be best suited for applications that involve transactions that need to be structured with specific information that is consistent among all entries (first name, last name, date, etc.). As a novice programmer, MySQL would be a good place to begin to learn the basics of databases and query processing. Once mastered, MongoDB would be the next database to learn as it has integration with different programming languages and can help with more complex data structures. 

Comments

Post a Comment

Popular posts from this blog

CST 300 - Week 8

-
 Part 1: Review of other team's final video projects Final Video Project Review # 1: Otter This World The video project from Otter This World is about Genomics. They describe how genomics is important and what advances we have made in this area. The topic is well-covered, and the presentation is clear. They cover each section described at the beginning of the video and provide various videos that go along with those sections. The quality of the research and video project is well done. They provide definitions and statistics with references. The video has a lot of visuals and could have used some slides with text at the beginning of each section. The information is being provided via audio, and there should be some text to supplement it. Also, the General Public video cuts off at the end with no conclusion. The video is engaging and interesting. They made a nice choice of visuals for each section. Team work is evident as each person had a section they covered. Overall, the video is ...
Read more

CST 300 - Week 5

-
Image
Part 1: Support and Comments on Teammates' Goals Victoria's Comment Guillermo's Comment Part 2: Possible Capstone Ideas Some ideas for capstone that I have are in the area of education with a focus on classroom management and video game design.  My first idea is to create a seating chart generator app for teachers to use in their classrooms. As a teacher, creating a seating chart can be a challenge. Whether you have a challenging class or are just looking to mix seats up, this app will help create the perfect seating chart. The app will give the teacher a variety of options to create a seating chart: individual, partner, or grouping (3 or more). The teacher can create a seating chart or groupings based on current grade in class, on an assignment, IEP requirements, or behavioral issues.  My second idea is to create a school environment application or website. With technology in the classroom becoming more and more popular, students are having to manage their own apps, homewo...
Read more

CST 300 - Week 6

-
  Part 1: Capstone Ideas Discussion In our team meeting, we discussed our possible capstone ideas and gave feedback on the ones that stood out to use.  Luis presented a 2D platform game, a music app for tuning instruments, and a database management program. His idea for the 2D platform game is to gain experience with game development. The music app would help with tuning an instrument, and his database management would help him gain experience with building a database.   Guillermo presented a pantry storage app, a music translator app, and a weather app. His idea for the pantry storage app would allow the user to create a list of items that they need to buy at a store. It would allow the user to enter items manually if no barcode exists and allow you to share the list with other people in the household. The weather app would focus on air quality.  Victoria presented an all-in-one educational app, a food information app, a fitness app, and a bookworm social media...
Read more