GEOB 270 Lecture Notes - Lecture 9: Object-Relational Database, Data Manipulation Language, Data Definition Language
25 Dec 2016
School
Department
Course
Professor
Document Summary
Linking data to place: how the characteristics (or attributes) of the geographic features are associated with that geography, movi(cid:374)g fro(cid:373) geo(cid:373)etry to (cid:858)places(cid:859) Storing attribute data: attribute data sets stored separately from spatial data, feature identifier is associated to attribute table. Line or arc attribute table: good organization of attribute data is very important (census data) In socioeconomic gis applications, attribute data component = much larger than spatial component in the database (few provinces, hundreds of variables) Database management: moving from data to database. Attribute linkages spatial data or attribute data(database) Old approaches: paper data stores/computer file systems. Enhanced access (multiple users/multiple levels of security) Redundancy minimized (one dataset sorted/searched multiple ways) Independence of data from application: access = controlled and centralized, standard query languages (structured query language, sql, databases are similar to gis in that they create mainland of information, linked through known relationship.
