Skip to main content

CST 363 - Week 4

This week involved a lot of work finishing up our group project, completing the exam, and brushing up on our SQL skills before the final exam.

 I had to learn much about OLAP queries, the type of user that would require them, and how to implement them into our existing project database this week. An OLAP approach to database queries is directly related to business intelligence and other types of metrics-based intelligence, so it was important to understand OLAP principles in order to incorporate them into our project. 

 Additionally, I also learned about how to effectively refactor/redesign a database using a star schema, and when it is most effective. Our artists and records database is a perfect example of an application that can utilize a star schema well because it is an internal application that benefits from simplified queries (who was the best selling artist of the year?) and fast aggregations. Data integrity is an issue, but it is not quite as serious as if the app was used by external customers. 

 It was a tough and long week with a lot of work, and I still feel like I am a novice at SQL, but I am looking forward to the next few weeks of the class and hopefully finishing it on a high note.  

Comments

Post a Comment

Popular posts from this blog

CST 499 - Week 7

This week, our group finished recording and editing our capstone project video and prepared our presentation for the capstone festival. Although I wish the capstone festival was held in person (and it could not due to current circumstances), I am excited to show off our project and hard work to other computer science students, friends, and family. I hope they'll enjoy it and learn something cool while doing so. 
Post a Comment
Read more

The Final Journal

It's the end of a long, four year journey, and what a journey it has been. I never thought I could pull off finishing my second bachelor's degree four years ago when I first went to that introduction to programming class at my community college. I would like to thank all the friends I've made along the way and the people who have helped me through the last two years. Although it was difficult at times taking class while working 40+ hours a week, I'm proud of myself for making it through. I don't think I'll be a student enrolled in classes anytime soon, but I'll always be a lifelong student. See you all around.
Post a Comment
Read more

CST 499 - Week 3

This week, we finished our ILP portfolios and turned in the final versions of our resume and cover letter. My group also completed the first part of the capstone report. I'll admit that creating a portfolio showcasing my past work was not at the top of my priority list when I first started studying computer science, although at this point in my educational and professional career I've learned how important it is to have such a portfolio. Like other creative professions, having a solid body of work to show to a potential employer, or even for personal documentation is one of the best ways to display your talents as an engineer. Also, all the assignments I've completed during my academic career, both at CSUMB and elsewhere, have given me a good start to my portfolio. I tend to prefer classic, plain styling like  Brian Kernighan's  home page (he has a pretty nice portfolio too), although I've come to appreciate highly stylized portfolios that make use of WebKit ani...
Post a Comment
Read more