CST363: Week 7

 Compare MongoDB to MySQL


Similarities

Both are database models that are used to store data and use querying to filter and sort stored data. Additionally, both use indexing to help with returning queries. Both types of databases also have APIs to help integrate them with programming languages like Java so that they can be used in large scale projects seamlessly.


Differences

While MySQL uses table based schemas organized in documents and rows, MongoDB uses a document based storage where information is held in filetypes like JSON. Because of this MySQL is more structured and designed to be less flexible and rigid, where as the design of a database using MongoDB can be more easily manipulated and altered.


When would you use one over the other

It is best to use MongoDB in situations where the documents will be altered more frequently and when the structure for the database needs to be more flexible. With MySQL's more structured database you are able to make better use of its complex querying abilities to easily sort more set in stone information from a large database. MySQL's structures design also lends itself to insure that data integrity is paramount. On the other hand MongoDB is perfect for when you need frequent and high speed database checks.

Comments

Post a Comment

Popular posts from this blog

CST300 Week 2: Drafts and Peer Reviews

Image
Part 1. Review and Reflect Learning Strategy      The top 3 effective study skills that I am strong in are Surveying, Making and revising a schedule, and Recite. Anytime I am presented with a new set of coursework I carefully overview the material and create a study plan allocating the time that will be required to cover and review it.      The 3 I am weakest in are Outlining textbooks, Where to study, and reciting. For one, I don't typically mark on textbooks, I also typically study at my computer which can often lead to distraction if I'm not careful, and lastly I can sometimes find myself reading through a section without fully grasping what I just covered.   Part 2: Preview Time Management Skills Part 3: Project Management Basics     The three video presentations, Introduction to Project Management, A WNS Masterclass, and Project Management in Under 5, were all incredible resources in learns key aspects about project management. The ...
Read more

Week 4

  Part One: Set Your Educational Goals     I have always told myself that I want to continuously develop my skills as a developer. There is always more to learn and new avenues to explore. As far as a set in stone goal to achieve, completing my Bachelor's is first and foremost. Once I achieve that I can start focusing on other certifications that may be beneficial to my career. Part Two: Set Your Career Goals      For my career goal, I hope to one day be in the position to design software systems. I enjoy writing code, but its always been building more than just producing that has fascinated me the most. My ideal role would be as a Software Architect. As an architect more of my responsibilities would revolve around developing the overall structure and project design rather than just working on coding tasks.     Even beyond that, it is a dream of mine to open a game development studio. Much of my spare time is spent working on small personal p...
Read more

CST334 Week 2

    This week has been a great introduction to how CPU process selection works in operating systems. We covered a range of scheduling algorithms, including FIFO (First In, First Out), LIFO (Last In, First Out), Shortest Job First (SJF), and Round Robin (RR). I learned how each algorithm has its own strategy for picking which process should run next, and how these choices affect system performance and metrics like response times.      I also learned to calculating those performance metrics such as response time, turnaround time, average arrival time, and average turnaround time. For Round Robin scheduling in particular, I learned how to calculate how long a process will stay in the system based on the time slice and the number of other processes in the queue. These exercises helped me understand the mechanics of how schedulers work and why the design choices made are so important.      One of the most interesting parts was comparing the pros and ...
Read more