Learning Journal 07 - CST363-30_2253

Flavio Cervantes

CST363-30_2253

  • Compare MongoDB with MySQL. 
  • MongoDB utilizes flexible JSON style layout, while SQL utilizes strict uniformity with tables of rows and columns, otherwise known as Schemas.  The flexibility of MongoDB is utilized for big data usages such as storing log files, dynamic applications that can involve many changes of data needing to be stored with inserts or updates. Examples of these would be custom mobile applications, log files for different types of apps., or a data science analytic app. On the other hand, SQL is best for apps. such as banking, financial, or warehouse inventory where integrity, standardization databases are needed. With mySQL one achieves the ability to use complex queries and join tables together, it also focuses on extensively structured relationships to ensure reliable queries . 
  • What are some similarities? 
  • The similarities are that they both support high availability setups, which provide reliability by using live replication in case a database goes down, the listener egresses a command to fail over the databases to the backup node.  This is one of many different ways that one can setup replication for either MySQL or MongoDB. They also both support Azure or AWS cloud databases if configured accordingly. Both databases offer basic security functionality such as administrative, contributor, or read only permissions.  Last but not least, they offer flexibility with the operating system one wants to use, all one has to do is ensure the correct driver or API is configured. 
  • What are some differences? 
  • The differences between MongoDB and MySQL are that MONGODB is their age in the industry, which affects their history. MongoDB is a fast-growing community, while mySQL has a well-respected matured history due to its standardization.      As far as the language one uses to run queries, MongoDB utilizes MQL, while MySQL uses SQL. The joins is MySQL are also more extensive, one is able to utilize, inner, outer, left join, etc. while in MongoDB, one uses $lookup, or find (); Lastly, the schema in MySQL predefines the columns and types before the data can be inserted. In MongoDB, the data can be dynamic/evolving.  This is by design; hence it is importance to understand the best type of databases for one’s selves. 
  • When would you choose one over the other? 
    I would choose the mySQL over MongoDB if I was creating an application such as QuickBooks. Since values can be configured in tables of rows and columns, and ensures reliability in complex queries. as business demands continue to expand. This ensures locks and measures in place; which is best for structured or transactional data. 

Comments

Post a Comment

Popular posts from this blog

Learning Journal - CSUMB - January 6, 2025

 Greetings,     This week I learned about the campus of CSUMB, and how it was a military base before officially becoming a CSU in the mid 90's. The vision of our school is based on collaboration, teaching us skills that are essential for the modern workforce, and to provide the best possible curriculum with relevant technologies that will help us excel in our future, if we do our part and endeavor the challenges that Computer Science conveys. I also learned about the different ways to format APA style, depending if it is a website, book, or personal interview. At my previous schools, we would utilize MLA, so this is a great learning experience.  I also refreshed on the importance of plagiarism, and why it is extremely important to do on our work, even with all the tools we have such as AI, 3rd party websites, etc. The challenge I overcame this week was to have a deeper understanding of how Dynatrace operates, and all the different components that shape a successf...
Read more

Learning Journal - Week IV

     Educational Goals My education goals in the CS program are to strengthen my engineering foundational skills. I also want to strengthen my programming skills by expanding my knowledge in python and Unix. I am working on obtaining a stronger understanding in machine learning, artificial intelligence and software engineering. This will be accomplished by working on small scale assignments or projects that introduce me into these respective technologies.  Career Goals My career goal is to continue to promote within the company I am currently working at or to move to another company and take on a more challenging engineer related role such as an Architect III or  Software Engineer. Wild guess of your percentile of the ETS Computer Science test After viewing the ETS page, test description and sample test I feel that this test will challenge me greatly but is a great standard as a computer science major. The percentile that I feel I will obtain is arou...
Read more

Learning Journal - CSUMB - January 15, 2025

Image
      Lecture: Week 2 Learning Journal Post      Part 1: Review and Reflect Learning Strategy       The tops three areas that I am good at is to stick to my schedule, unless an emergency comes up, I like to stick to my schedule from the beginning of the day, until the end of the day. I am also good at studying when I have "planned" for it, I usually plan my studies in the evening and over my online educational journey, I have been disciplined enough to stay on track. Lastly, I am good at thinking skills, I can think critically, and come up with ideas or a desire to research something and learn about it. This ability is used in our everyday life’s, at home, while studying, and at work.  The top three areas that I feel I am weak in is where to study, sometimes it is easier to study at home but that is where I can easily get distracted at. I also feel that I am weak in is reading, sometimes when I am tired, it is hard to read all the m...
Read more