CST 363 - Week 5

Slow Indexes

I learned that even if a query uses an index, it can still be slow. It’s not the index itself that’s slow, but what happens after. If the index finds a lot of matches, the database has to scan extra pages and go back to the table for each row. That’s what really slows things down, not a “bad” index.

Week 5 Reflection:

This week was interesting and fun as well because of the practical assignments we did. Lab 18 was a good practical experience where we designed a real-world database for a pharmacy system. Setting up the tables and connecting everything made it easier to see how this stuff would actually work outside of class.

Comments

Post a Comment

Popular posts from this blog

Week 4 - Educational & Career Goals, ETS Readiness, and Learning Reflections

Part One: Educational Goals My goal in the CS program is to develop a good foundation in software development which specifically includes front-end and back-end technology. I also want to get a really good understanding of algorithms and develop problem solving skills. Programming languages are another important part of this plan. In fact, that is the essence of CS. I’ve done C++, Python, Java, Javascript and other languages, but want to revise them all again and this time create a nice portfolio utilizing some of the languages. The next goal is to hopefully land internships or full-time entry jobs to get real-world experience. All this is while attaining my bachelors. Part Two: Career Goals I want to start now in terms of career goals meaning that I want to start getting experience as soon as possible. This means I have to get into an entry level job and build from there. Something attainable can be taking courses on UI/UX design and get a career related to that. As I get used to that...
Read more

Week 2 - Learning Strategies | Time Management | Project Management | Previous Capstones | Week Summary

Image
Learning Strategies Top 3 Study Skills I'm Good At: Following the SQ3R method: Survey | Question | Read | Recite   |   Review I didn't even know I followed this until I examined myself with it.  Minimizing Distractions While Studying: I’m good at selecting quiet, distraction-free environments like my study room at the corner of my house so not many people walk by throughout the day allowing me to focus deeply on the material. Looking for main ideas in paragraphs and extracting key details. Top 3 Areas I Need to Improve On: Creating/Following a Schedule:  I am not good at creating a schedule and even worse at following it. I'll try it for a day but then things pop up and I get inconsistent. I feel like I can't keep a good schedule when studying formally like school. However, this class is training us like we are working a job. Therefore, it is getting easier to follow a schedule as if we are needing to meet deadlines so I am enjoying it.  Time...
Read more

Week 5 - Team Comments, Capstone Ideas, Weekly Journal, Industry Expert Interview

Image
  Part One: Team Comments  Comment for Jian:  Jian's Week 4 Journal Comment for Noah:  Noah's Week 4 Journal   Part Two: Capstone Ideas 1. User-friendly appointment booking system for small businesses - Many small businesses have a hard time with inefficient and difficult scheduling systems. This project would create a simple, mobile-friendly appointment booking system with features like automatic reminders and calendar, significantly improving customer experience and reducing no-shows.  2. Smart navigation system or app for public spaces - Many people struggle with navigating crowded places like malls, airports, or large events. This project would create a user-friendly mobile app that provides real-time navigation indoors, showing the least crowded paths based on foot traffic data. It could also include accessibility-friendly routes for users with disabilities, improving overall user experience and convenience. 3. AI-powered smart form auto...
Read more