CS Online Learning Journal

 CST-363 Week 5 This is our fifth week in CST-363, also known as Intro. to Database Systems. Questions This week we were asked to an article on slow indexes by Markus Winand , and answer the following question: If indexes are supposed to speed up performance of query,  what does the author mean by a slow index?     An index lookup goes through three steps, traversing the tree, going through the leaf node chain, and fetching the table data. These two steps may require reading multiple blocks of data, and thus may make the index lookup inefficient. Vocabulary Transactions Transaction: A sequence of database operations that must be either completed or rejected as a whole. Partial execution of a transaction results in inconsistent or incorrect data Commit: When a database saves complete transaction results. Rollback: When a database rejects an incomplete transaction, and resets data to initial values. ACID: All transactions must be atomic, consistent, isolated, and dura...

 CST 363 Week 4 This is our fourth week in CST-363, also known as Intro to Database Design. Questions Briefly summarize 5 things that you have learned in the course so far. While I was familiar with basic SQL statements, such as SELECT statements, I have learned more advanced statements. I have also learned how how relational databases function are designed, how databases are implemented from an Entity-Relationship Model, how normalization and denormalization can improve database performance, and how databases are physically stored on hardware. List at least 3 questions that you still have about databases.  So far we have focused on relational databases. I am interested to see NoSQL databases and how they work. Related to NoSQL, I am interested in seeing examples in Big Data, how it differs from relational data, and how it is handled compared to relational data. So far we have programmed SQL files, and Java replications of a database. I am interested to see how SQL and other p...