Matt's CSUMB Journey

When the author says that there is a slow index he means that in large databases with many matching values an index might have to search multiple times through the same blocks to find all of the corresponding data. It might also have to access many blocks if the data is very common within a database. Having to continuously search for the same value can lead to increased search times. 

 5 Things I learned through the first half 1.  I learned the importance of databases and how they can be used by different corporations to store and access data 2. Using java I learned how database systems work behind the scenes 3. I learned the my sql language and how to use my sql workbench 4. I learned about indexes and how they can improve search speed 5. I also learned about normal forms and how different table types can be used for different companies needs 3 Questions 1. What are the other types of databases besides relational? 2. What is the best way to test a database? 3. Is using the modeling feature in my sql the best way to create a database from scratch?

 1. An SQL view is similar to a table but is not stored the same way, a view manipulates or alters the way a table looks to give consistent formatting, or hide sensitive data. Views are useful for allowing ifferent levels of access to one table.  2. SQL is very similar to java just with different syntax, SQL takes in some cases long strings of code to complete a task but feels very similar to writing a sentence where as other languages like java and C++ feel like you are writing out little bits of a though process where muliple lines each serving there own function form a thought process. Both often lead to similar ends and have common steps along the way like predicates, data types, but it is easy to tell that SQL is designed for the very specific purpose of databases where as C++ and Java have broader uses . 

 1.  A table titled Store has columns  a key name, address, and average_price, a second table titled store budget has columns  a key name,  and budget join the two tables to show what store matches each budget.  select s.name, s.address, s.average_price, b.name,  b.budget  from store s join budget b on b.average_price<b.budget; 2. Sql does feel easy to learn and use because many of the key words follow along with how they work in the english language and it feels like I am just writing a sentence when I am writing rather than stringing together individual statements.  At the beginning of this week I had a hard time with join queries but the more I have done them the easier it has gotten.

 1. Spreadsheets are good way to organize and analyze data but the data in each cell is not explicitly linked. Relational databases have built in links between tables, columns, and rows that allow it to easy analyze that data while being sure that a false connection is being made.  2.  A database is a useful tool to have for any program that is going to use data because it holds the connections within the database so that each new piece of data that is inserted does not have to be individually linked. It also allows for the data to be easily displayed in the table format. Ultimately it saves time in the long run to put in the efoort to set up the database. 3. Databases are a very useful tool and I want to go into a database management career so I believe that everything in this class will help me in a future career but understanding one of the most pivotal parts of programming like databases is a valuable skill to have,