CST 363 - Module 5

 Week 5,

This week had us practicing more with MySql, using what we already know to find very specific information across multiple tables. In addition, we also learned more about transaction management, such as using commits, rollbacks, and learning about concurrency, schedules and transactions themselves. This could be helpful when preserving information if something unexpected happened. Like someone trying to withdraw cash, but right as the atm is about to dispense the cash and already changed the user's bank information, the power shuts down. This would require measures so that the user's money is protected.

However, I have been asked about something intriguing I want to talk about. If indexes are supposed to speed up the performance of a query, then why can indexes be referred to as slow indexes? Markus Winand talks about this in his website "Use the Index Luke". In short, indexes are great for finding something in a large dataset. However, if there are duplicate values for what you are looking for in the leaf node chain at the end of the tree traversal, then you are performing both a tree traversal and following the leaf node chain. Additionally, with getting multiple "hits" you now have to perform a table access for each hit. Overall, it is something to think about for implementing indexes, though there are work-arounds. 

Comments

Post a Comment

Popular posts from this blog

CST 300 - Module 4

Part 1 - Educational Goals This week's lecture readings in class have to do with setting goals. There are a few different types of goals to consider such as career, financial, family, artistic, attitude, physical, and public service. However, for now let's go over my educational goals. Some things I would particularly like to learn more about are software design and software engineering. I want to be able to create more professional applications to be an important member of any team I may join in the work field. To be more general, I would like to pass all of my classes with a grade higher than a C as I think they all are useful to know, especially for some of the things I want to do in the far future. Part 2 - Career Goals Another type of goal I should talk about is my career goal. Overall, I would like to have enough experience in working with the game development industry. There are a few levels to this goal, one is I would like to work with a company that develops games suc
Read more

CST 300 - Module 2

Image
Part 1 - Review and Reflect Learning Strategy After reading a paper on effective study skills by Dr. Bob Kizlik, I have come to realize there are more aspects of studying than I realized, and I do follow a large amount of them. However, there are also some aspects in which I struggle with that I have noticed, especially recently when it comes to reading. Although, to save your time, I will talk about the top 3 aspects I believe I am good at, and the top 3 I am bad at. One thing I am good at is taking notes. Especially in the digital age we are in, there are many ways to take notes, for me I separate my notes by module and assignment using google docs. Another is getting the main idea in a reading, also allowing me to take notes to reflect on later, instead of re-reading an entire segment of an essay or book. Finally, I feel I am also adept at surveying, to get an idea of what I'm going to study, before I actually study. However, some things I need to work on is to actually read bec
Read more

CST 300 - Module 3

Hello Everyone, Part 1 Last week I mentioned the areas in studying I need to work on such as paying attention to what I am reading, and to stick to a schedule as I often lose focus and prolong assignments. So, after visiting AcademicTips.org, I took some notes on concentration. Some things I am trying to do differently is to further avoid any distractions and to keep focus on my studies by taking breaks less often but do something that needs to be done other than just daydreaming, such as using the time to eat. Part 2 This week’s class module covered quite a bit of material. The readings covered topics such as the Code of Integrity for CSUMB CS Online, going over the rules of what should and should not be done when submitting any work or assisting/receiving assistance. Code of Ethics, as one may expect, be honest, avoid harm, maintain high standards, be professional, and many more aspects of what it is to be ethical in one’s work. This module puts an emphasis on ethics as it is the ma
Read more