CSE 278 Lecture Notes - Lecture 10: Database, Data Definition Language, Edgar F. Codd
8 Oct 2018
School
Department
Course
Professor
Document Summary
Large amount of organized information existing over long period of time. Dbms is complex set of software, used to manipulate (create, destroy, and change databases) as well as query (retrieve) information. Codasyl in the 60s defined two main types. Way data is organized, like the above, is called data models. In 70s, ted codd from ibm developed relational model . Most of the standard theory of databases comes from a single paper from him in communications of the acm. In short, the relational model organizes the data, which must be primitive in tables, according to a schema. As computer hardware and storage devices become smaller and smaller, databases have become larger and larger. Data distributed and available through file sharing (distributed databases) Allow to specify schemas using a ddl (data definition language, pt. of dbms) Support storage of large amounts of data. Controls access of many users at a time.
