CSE 385 Lecture Notes - Lecture 2: Unique Key, Binary Search Algorithm, Linear Search

• School: Miami University
• Department: Computer Science & Software Engineering
• Course: CSE 385
• Professor: Mr. Michael Stahr

Document Summary

Cse 385 - lecture 3 - retrieving data from single table. Staging database: used to test what you are doing. Real database: used once you"re sure it"s working. Test database: like real and can be used for testing purposes. Master database used to store information about schema. Check with db_id if ap" is null delete it. Tables can only have one primary key clustered identity field. Binary trees that are able to find data quickly. If you index from linear search to binary search speed is greatly increased! Using primary key from another table as field in another is called foreign key . Soft delete: don"t actually delete but mark as and then don"t show in queries; safer. Views do not execute as fast as a normal table. However, we can add indexes to views to make it execute almost as fast as table. example, vendorid is primary key for vendors table and primary key in invoices table.