Database Systems: Week 7

-

     There are various similarities and differences between MongoDB and MySQL. Some of their similarities are having a query language, indexing, drivers for different languages as well as making data persistence. MongoDB and MySQL also both store data and support backups. Some of their differences are how the data is modeled, their schema, and their joins. Also, both do have their query language, but they are different. MongoDB has the JSON-based query syntax and MySQL has the standard SQL query language. I would choose to use MySQL when I need complex queries that will need several joins. MongoDB has no native joins but MySQL does. I would use MongoDB when I want to have more flexibility with the data structure and avoid complexity of a rigid schemas. 

Comments

Post a Comment

Popular posts from this blog

My first week

-
I am excited and eager to have started this journey with an amazing cohort and faculty!  The material I reviewed included tips to help me be successful in our online program and the syllabus. D uring module 0, I made a weekly study schedule, and it was my first time making one. It was very interesting and helpful to use. I enjoyed interacting with my cohort and getting familiar with everyone during our discussion. Besides that, my wonderful teammates and I started working on our assignment early which included having a team name and making a collective resume as if we had a business. I suggested a few team names and my teammates agreed on Code Busters. We managed to work together to make our resume and the only thing we could have left out was AI. Our business consists of helping our customers debug their systems. (Our collective resume is included below.) Now continuing to Module 1 my team and I started off the week right by finishing our assignment the day we received it. We rev...
Read more

Second Week

-
Here are the following parts of this week's learning journal assignment. Part 1:  The three things I am good at are asking questions, taking notes, and gathering my materials. When looking over material or doing assignments, I always have questions, and I try to figure them out to understand what I am doing. In the SQ3R method, questions are great for learning because it covers the why, what, how, who, where, and when. I also enjoy implementing note taking. I have a notebook for my CST 300 class, and I also use my notes on my computer to make sure I get everything done. Taking notes helps memorize what you are writing. I am also good at having my materials on my desk where I study. I keep everything together so it’s easily accessible. The three things that I need to work on more are time management, where I study, and having a correct schedule that works for me. I always struggled with time management, and I felt it this week because I did several assignments on the day it was due....
Read more

Fourth Week

-
 Part 1: One educational goal of mine is to receive As and Bs throughout my journey in this program. This aligns with my second educational goal, getting a 180 out of 200 on my Ethics Argument Essay in my CST 300 class. I want to accomplish this goal by getting help from others. During this class, I received an 84 out of 100 on my Industry Analysis essay. I wasn’t too far out but the Ethics argument essay will be difficult. My last educational goal is to get ahead of my assignments by managing my time. I am always busy studying, working, being with my family, and trying to leave time for myself. I spend over twenty hours trying to figure out or perfect assignments and reviewing them in the Modules. Part 2: My career goal that I can work on is making projects to start my portfolio. Starting this can help recruiters and myself to acknowledge the progress I will be making. Considering I will have more knowledge by the end of this program. I also want to learn new program languages and...
Read more