CST 363: Week 7 Learning Journal

Comparison of MongoDB and MySQL

Similarities: 

  • Both are widely used database management systems for storing and managing data.
  • They support querying, indexing, and data replication for performance and reliability. 
  • Both can be integrated into a variety of applications, from small projects to large-scale enterprise systems. 
Differences: 
  • Data Model: Mongo DB is a NoSQL, document-oriented database that stores data in flexible JSON-like documents, while MySQL is a relational database that organizes data into structured tables with rows and columns. 
  • Schema: MongoDB allows for dynamic, flexible schema, whereas MySQL enforces a predefined schema with relationships between tables. 
  • Query Language: MySQL uses SQL (Structured Query Language), while MongoDB uses its own query language with JSON-style syntax. 
  • Use Cases: MongoDB excels with unstructured or semi-structured data and rapid development needs, while MySQL is ideal for structured data with clear relationships and transactions requiring strong consistency. 
When to use when: 
  • Choose MongoDB when dealing with large volumes of unstructured data, real-time analytics, or applications where the data model evolves quickly. 
  • Choose MySQL when data integrity, transactions (ACID compliance), and complex queries across multiple related tables are essential. 


Comments

Post a Comment

Popular posts from this blog

CST 349 - Week 4 Learning Journal

 Part One: Set your Educational Goals My primary educational goal in CS program is to develop a string and practical mastery of core CS concepts, including algorithms, programming languages, software engineering, and systems. I envision myself confidently solving algorithmic problems, understanding complex system architectures, and applying discrete mathematics to real-world challenges. I want to graduate with a skill set that allows me to design efficient software solutions, analyze problems from multiple perspectives, and communicate technical ideas clearly. I hope to excel on the capstone projects, future internships and collaborative environments by applying the knowledge I have gained. Beyond the CS program, I plan to continue to learn through a masters program and certificate programs. I also plan to continue learning in emerging areas such as AI, ML, and cybersecurity.  Part Two: Set your Career Goals A mathematical engineer / data engineer job after graduation in Sprin...
Read more

CST349 Week 2 - Learning Journal

Image
Reflecting Learning Strategy:      Top 3  Strengths:           - Keeping notes organized: I have structured my notes in a format that is clear for me and easy to                        understand.           - Time management/awareness: Since working a full time job and being a full time student, I have                   learned to manage my time effectively and in a way that has not hindered my education or work.           - Re-reading and understanding main/key points: I have learned that the most effective way to learn                   for me while reading is summarizing key points/topic/ideas in my own words.       Top 3 Weaknees          - Test-taking: ...
Read more

CST 349 - Week 5 Learning Journal

Part One: Support and Comment on Teammates' Goals https://rrh-cst349.blogspot.com/2025/09/week-4.html?sc=1759766413145#c3682610505999987379 https://annies-cs-journey.blogspot.com/2025/09/week-4-my-csumb-journey.html?sc=1759766670451#c6148798155532794758 Part 2: Possible Capstone Ideas Idea 1: Data Pipeline for Real-Time Analytics on Public Data Description: Build an end-to-end engineering pipeline that ingests, cleans and processes real-time data (ex: stock market, or sports stats). Store the data in a structured format, then build an API for real-time analytics.  Idea 2: Machine Learning-Data Cleaning Assistant Description: Create a tool that detects and corrects anomalies, duplicates or missing values in datasets using both statistical rules and machine learning models. (Ex: applying clusters to detect outliers to fill missing values). Package the tool into a library or web interface.  Idea 3: Graph Analytics Platform for Network Data Description: Build a platform to analyze...
Read more