1 / 9

Relational Databases

Alex Wood. Relational Databases. Why Relational Databases?. Originally, Databases Were Stored as “Flat Files” Flat Files Are Very Poor at Handling Queries Breaking Data into Relational Models: Increases Flexibility Improves Query Performance

chars
Download Presentation

Relational Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Alex Wood Relational Databases

  2. Why Relational Databases? • Originally, Databases Were Stored as “Flat Files” • Flat Files Are Very Poor at Handling Queries • Breaking Data into Relational Models: • Increases Flexibility • Improves Query Performance • Uses Less Space (Avoiding Excessive “NULL” Fields)‏

  3. Flat File DBs are OK for Storage of Data Unlikely to Be Significantly Modified Adding New Columns is Difficult How Do You Model a List of an Author's Books in a Flat DB? Flat Files Are Evil Number, Name, Position, Age, College|27, Jordan Babineaux, SS, 27, Southern Arkansas|83, Deion Branch, WR, 30, Louisville|79, Red Bryant, DT, 25, Texas A&M|81, Nate Burleson, WR, 28, Nevada|11, Deon Butler, WR, 23, Penn State|89, John Carlson, TE, 25, Notre Dame|59, Aaron Curry, LB, 23, Wake Forest

  4. A Few Tables

  5. A Few Tables How do we model relationships?

  6. Relation Tables • Using only shared keys, facilitates easy linking of tables in queries. • Allows for modular data storage. • Can add attributes to further describe relation.

  7. Deriving Interesting Information • How many students from a given school does a company hire? • What percent of employees come from that school? • What is the average commute distance of a company's employees?

  8. Our Project • The CTPP Project involves storing game state and game results for an educational video game. • We are able to leverage Relational Databases to efficiently store game data, and build queries to obtain interesting information for post-game analysis. • Dealing with changing requirements for stored data is a manageable obstacle with this implementation.

  9. Questions?

More Related