CST 363 - Week 4 Learning Journal

Five Concepts Learned in Intro to Database Systems:

1. Schema and Data Types: Schema defines the structure of a table by specifying column names, their data types and keys, which form the blueprint for how data is stored and accessed. 

2. Conditions and Query Evaluation: Logical conditions are used to filter data and queries apply conditions to return only the rows that satisfy the given query. 

3. Practical Uses of Java Collections: Java structures like ArrayList to manage schemas and tuples, and practiced accessing elements by index to support efficient query and table operations. 

4. Heap tables: Combines schemas, blocked files and bitmaps to create a disk-based table that can insert, delete and lookup rows in a way similar to a simple database storage engine. 

5. Bitmaps: A bitmap efficiently tracks which row slots in a table are free or occupied, helping the system quickly find available space after deletes. 

Questions about databases: 

1. How do real-world database systems efficiently handle concurrent access?

2. What's the difference between heap files, B+ tree indexes, and hash indexes and when should each one be used?

3. What strategies do production databases use to handle concurrent queries and ensure data consistency when multiple user are reading/writing at the same time?

Comments

Post a Comment

Popular posts from this blog

CST 349 - Week 4 Learning Journal

 Part One: Set your Educational Goals My primary educational goal in CS program is to develop a string and practical mastery of core CS concepts, including algorithms, programming languages, software engineering, and systems. I envision myself confidently solving algorithmic problems, understanding complex system architectures, and applying discrete mathematics to real-world challenges. I want to graduate with a skill set that allows me to design efficient software solutions, analyze problems from multiple perspectives, and communicate technical ideas clearly. I hope to excel on the capstone projects, future internships and collaborative environments by applying the knowledge I have gained. Beyond the CS program, I plan to continue to learn through a masters program and certificate programs. I also plan to continue learning in emerging areas such as AI, ML, and cybersecurity.  Part Two: Set your Career Goals A mathematical engineer / data engineer job after graduation in Sprin...
Read more

CST349 Week 2 - Learning Journal

Image
Reflecting Learning Strategy:      Top 3  Strengths:           - Keeping notes organized: I have structured my notes in a format that is clear for me and easy to                        understand.           - Time management/awareness: Since working a full time job and being a full time student, I have                   learned to manage my time effectively and in a way that has not hindered my education or work.           - Re-reading and understanding main/key points: I have learned that the most effective way to learn                   for me while reading is summarizing key points/topic/ideas in my own words.       Top 3 Weaknees          - Test-taking: ...
Read more

CST 349 - Week 5 Learning Journal

Part One: Support and Comment on Teammates' Goals https://rrh-cst349.blogspot.com/2025/09/week-4.html?sc=1759766413145#c3682610505999987379 https://annies-cs-journey.blogspot.com/2025/09/week-4-my-csumb-journey.html?sc=1759766670451#c6148798155532794758 Part 2: Possible Capstone Ideas Idea 1: Data Pipeline for Real-Time Analytics on Public Data Description: Build an end-to-end engineering pipeline that ingests, cleans and processes real-time data (ex: stock market, or sports stats). Store the data in a structured format, then build an API for real-time analytics.  Idea 2: Machine Learning-Data Cleaning Assistant Description: Create a tool that detects and corrects anomalies, duplicates or missing values in datasets using both statistical rules and machine learning models. (Ex: applying clusters to detect outliers to fill missing values). Package the tool into a library or web interface.  Idea 3: Graph Analytics Platform for Network Data Description: Build a platform to analyze...
Read more