Learning Journal Week 5

 What the author means by slow indexes is that indexes are supposed to speed up look ups on a data table. However, there are aspects of indexes that can slow down searches. For example if we're looking for several different cells that match the value we're looking for, the index has to traverse the tree to get to our first match, but but then has to follow the chain of nodes to capture all the matches. This can take pretty long if there are many table rows that match our search value. Also, the accessing of the table itself can increase the time it takes to search for a value as well.

It seems consistent with our text's and how it recommends approaches to database design that avoid redundancy. The more unique our value, the faster it is to find all instances of it.

Comments

Post a Comment

Popular posts from this blog

Journal Week 4

 This week we learned about security, particularly about encryption and how keys are used in networks to protect data. It's interesting to learn about encryption techniques that are now obsolete due to improvements in computing processors. I wonder how long it would take for currently recommended encryption methods to become obsolete. Also, I found the examples in the lectures helpful. Thinking of the data exchange across a network as a conversation between two people (and possibly three if we include an eavesdropper) helps me understand the flow of data and vulnerabilities that can arise.
Read more

Week 5: CST438 Journal

 This week, we learned about the plan and document process for engineering projects. It's based on gathering software requirements and documenting them, as well as documenting the progress that is made in the design and implementation of software and its cost. We went over the some of the differences in this approach when compared to the agile method. We also learned about UML diagrams, with special attention to three types of these (use case, sequence, and class). I've been exposed to class UML diagrams before, but the other two behavioral type of diagrams were somewhat new to me.
Read more

This week

 This week we continued to learn about HTTP, plus DNS and email protocols. I find the the material very interesting based on the lecture videos, but I still need to finish catching up on the reading. I think I need to review some of the earlier material on calculations and measuring response and request times, since quiz questions in later chapters seem to require this. I didn't have the technical issues I had last week. Although I do wish the labs could be turned in as assignments rather than quizzes (more flexibility for asking questions and dealing with technical vm issues).
Read more