CIS 3530 Lecture Notes - Lecture 1: Database, Hash Table, Postgresql

• School: University of Guelph
• Department: Computing and Information Science
• Course: CIS 3530
• Professor: Fangjyu Wang

Document Summary

Main components of a db: interrelated le (each le would store a table, application programs to manipulate the data, user interface. Database management system (dbms) - a softwar system for developing databases. Its a collection of programs that carry out many activities. Update data / add data / delete data. The software system to develop database. ex: mysql, postgresql. You use a dbms to develop a database, it is not a db in and of itself. A property of a single item in that table. A single logical db is spread across many physical computers connected over a network. Homogeneous - the hardware and software on the computers is the same. Heterogenous - the hard/software can be di erent on the computers connected through the net. Batch sequential processing - have to go through the entire row, from beginning to end to nd the data. The physical data structure is the actual size/type of the eld or column.