CST 363 Week 7

  

WELCOME TO WEEK 7

Learning Journal - MySQL vs MongoDB

Both MongoDB and MySQL have query projection, unique keys, and indexes. Relational databases support unique keys and auto-incremented primary keys. In MongoDB, all documents have a unique _id attribute that can also be autogenerated when there is no value set at insert time. Both use a query language to interact with data. MySQL uses SQL, while MongoDB uses its own query language based on JSON-like documents.

Another similarity is that both systems support indexing to enhance query performance. MongoDB and MySQL also both support replication, which allows data to be copied for redundancy and high availability.

Some differences between the two databases are that MySQL supports query joins, while MongoDB does not. MySQL is a relational database that uses tables, columns, and rows, which enforces a strict schema. MongoDB, on the other hand, is a document database that stores data in flexible, JSON-like documents, allowing easy changes.

If an application requires complex transactions and strong data integrity, MySQL would be best, especially where a predefined schema is made and the data structure is not expected to change a lot. However, MongoDB is better for applications that require flexibility and scalability. 

Comments

Post a Comment

Popular posts from this blog

CST 300 Week 1

Image
WELCOME TO WEEK 1           Week 1 out 100 has begun! Im thrilled to share my journey while completing the CS Online program at California State University Monterey Bay. I can't wait to see what the next two years will bring.  https://www.prepbaseballreport.com/upload/school_logos/thumbs/334_thumb.png      This week I read a little bit of the history of CSUMB. It used to be an Army Base, Fort Ord, from the 50's to the 70's. Well known celebrities such as Clint Eastwood and Jimi Hendrix received training at Fort Ord.       I learned a few tips in order to succeed in online learning. The one that stood out the most was the importance of creating an organized schedule and planning study sessions. The online learning environment can make it easy for students to procrastinate. Therefore, engaging with others and logging into canvas at least three times a week should be helpful to maintain focus. Looking forward to next week!   
Read more

CST 300 Week 4

Image
  WELCOME TO WEEK 4 Educational & Career Goals This I learned that it is essential to use these 7 Career Goals in order to succeed:  Self-Assessment Networking Tracking Accomplishments Know Your Worth  Update Your Skills Negotiate Allow for Downtime https://cdn.shortpixel.ai/spai/w_1052+q_lossy+ret_img+to_webp/tipsforlawyers.com/wp-content/uploads/2021/01/Goal-setting-2048x1152.jpg      Tracking accomplishments is one goal that I want to apply to my career. It will help me in the future when I begin applying for jobs. Having everything documented will save me from trying to remember things and possibly leaving things out. This goal will also help me create my portfolio. Another career goal that I want to apply is to update my skills and begin networking. For instance, updating my skills by learning new programming languages, will be beneficial when being considered for interviews. Networking will also be beneficial, as job recruitment has changed from what it used to in the past. 
Read more

CST 300 Week 3

Image
       WELCOME TO WEEK 3 Work Styles & Conflict Styles      This week, I learned about the different work styles there are and conflict styles in action.  Each work style, whether it's about getting it right, getting it done, getting along, or getting appreciation, seeks something distinct. For instance, Get it Right wants the facts, to focus on details, and values being right. Get it Done on the other hand, focuses on deadlines and is not afraid of mistakes. They also focus on tasks being done and speeding up. Get Along is people oriented, they are aware of the needs of others, are social, direct, and want everyone satisfied. Last but not least is Get Appreciation. They tend to like to contribute, give positive feedback, and they like assertiveness.      I also learned about the different conflict styles, which are: Avoiding Forcing Accommodating Compromising Collaborating. https://www.red-thread.com/wp-content/uploads/sites/779/2016/08/Blog_Header_work-style.jpg?w=1770&h=
Read more