CST 363 - Introduction to Database - Week 7

-

 



Compare MongoDB with MySQL


  1. What are some similarities? Some of the similarities that both applications have are: data storage, indexing and replication. Both MongoDB and MySQL are databases that store data, although they do so in different formats. They both support CRUD (create, read, update, delete) operations. Also, both databases support indexing to improve query performance. MongoDB allows indexing on documents, and MySQL allows indexing on table columns. Finally, both applications support replication to provide data redundancy and improve data availability.
  2. What are some differences? Some of the differences in both applications are: data model, schema design, query language, transactions and use cases. MySQL uses a structed tabular model, while MongoDB uses a flexible document-based data model. MySQL enforces a strict schema where the structure of the data must be defined before data can be inserted, while MongoDB has a flexible schema that allows for dynamic document structures. MySQL uses SQL which is a standardized language for querying and managing relational databases, while MongoDB uses its own query language, which is JSON-like and designed to work with its document-oriented data model.
  3. When would you choose one over the other? Choose MySQL when you have a well-defined schema, need complex transactions, and require strong consistency. It is ideal for traditional applications like enterprise level financial systems, e-commerce platforms, and any application where data relationships and integrity are crucial. Choose MongoDB when you need flexibility in your data model, have rapidly changing data structures, or are dealing with large volumes of unstructured data. It is ideal for modern web applications, real-time analytics, and scenarios where you need to store hierarchical data, such as content management systems or applications involving user-generated content. 

Comments

Post a Comment

Popular posts from this blog

CST 300 - Major ProSeminar - Week 1

-
This week has been busy with various assignments and quizzes, with the official beginning of the Cohort 19 Computer Science online program. I'm thrilled about the exciting two year journey ahead. Prior to the program's official week, our team got together to work on our team resume, a project that turned out to be both enjoyable and productive. We settled on the name 'Bit of Otter' for our team and designed a logo, deciding to focus in the cybersecurity as our business industry. In terms of coursework, this week was to know more about CSUMB and the program's background. The writing lab introduced us to the APA format, which we'll be using for our papers. Emphasizing the importance of citing external sources to avoid plagiarism, we were encouraged to use additional resources for our assignments. The first paper for CST-300 involves researching a company we aspire to work for in the future. Tasks from the Open Learning Initiative (OLI) included a pretest, reading
Read more

CST 300 - Major ProSeminar - Week 2

-
Image
Module 2 - Lecture (75 Minutes)  For Module 2 lecture, we had to watch two videos and read an article. The first video, titled "The Future Is Faster Than You Think," discusses recent technological advancements. These advances have made our lives easier; for instance, creating heat using a candle used to be hard work, but now it's cheaper and simpler. The video also mentions four types of abundance: computation, time, capital, and communication. These abundances help save time, enhance intelligence, and increase lifespan, among other benefits. Technological progress is excellent because it improves our lives. The second video, "Introduction to Project Management," explains the project lifecycle, project leadership, and how to ensure a project's success. A project has a start and end time, a defined goal, and may arise from various factors like market needs, business requirements, technological advancements, customer requests, legal mandates, social needs, or
Read more

CST 300 - Major ProSeminar - Week 4

-
Week 4 - Learning Journal Post Set Your Educational Goals My educational goal in this computer science program is to graduate in two years and secure a job in the artificial intelligence industry immediately after college. To achieve this, I need to conduct a self-assessment and identify the steps necessary for reaching my goal. Improving public speaking is crucial since I've been a shy person since childhood, impacting my communication skills and connections. To address this, I plan to work on public speaking and actively participate in networking events like hackathons and school events to make new connections. Additionally, I recognize the importance of staying updated on evolving technology and being prepared to enhance my skills accordingly. Taking short trips to other countries for decompression and preventing burnout is something I consider valuable. Finally, to enhance my chances of securing a job post-college, I aim to participate in internships while still enrolled in col
Read more