DATABASE SYSTEMS
Session 1: Introduction & Relational Model
DATABASE
• Organized collection of inter-related data that models some aspect of the real-world.
• Databases are the core component of most computer applications.
DATABASE EXAMPLE
• Create a database that models a digital music store to keep track of artists and albums.
• Things we need for our store:
→ Information about Artists
→ What Albums those Artists released
FLAT FILE STRAWMAN
• Store our database as comma-separated value (CSV) files that we manage ourselves in our application code.
→ Use a separate file per entity.
→ The application must parse the files each time they want to read/update records.
• Example: Create a database that models a digital music store.
• Example: Get the year that GZA went solo.
1
Session 1: Introduction & Relational Model
DATABASE
• Organized collection of inter-related data that models some aspect of the real-world.
• Databases are the core component of most computer applications.
DATABASE EXAMPLE
• Create a database that models a digital music store to keep track of artists and albums.
• Things we need for our store:
→ Information about Artists
→ What Albums those Artists released
FLAT FILE STRAWMAN
• Store our database as comma-separated value (CSV) files that we manage ourselves in our application code.
→ Use a separate file per entity.
→ The application must parse the files each time they want to read/update records.
• Example: Create a database that models a digital music store.
• Example: Get the year that GZA went solo.
1
