lecture1.ppt-piazza.pptVIP

* DBMSs were invented to solve all these problems! * Back to the red words Safe: from system failures from malicious users Convenient: simple commands to debit account, get balance, write statement, transfer funds, etc. also unexpected queries should be easy Efficient: dont scan the entire file to get balance of one account, get all accounts with low balances, get large transactions, etc. massive data! - DBMSs carefully tuned for performance Slide from K.Minami * Schemas and Data Similar to types and variables in programming languages Schema – the logical structure of the database schema