Lecture-4a_Bb_1SlidePerPage

Lecture-4a_Bb_1SlidePerPage - Geographic Databases & ESRIs...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Geographic Databases & ESRI’s Geodatabase Model Creating & Maintaining Geographic Databases
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Outline Databases Capabilities of DBMS Types of DBMS ESRI Geodatabase Data Model
Background image of page 2
Definitions Database An integrated set of ___________ on a particular ___________ • Can be stored in stand-alone files or • Managed centrally by a ___________ ___________ ___________ (DBMS) Geographic (Spatial) Database Database containing geographic data of a particular ___________ for a particular ___________ __________ __________ __________ (DBMS) Software application designed to organize the efficient and effective storage and access of data
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Advantages of DBMS All Data Is Stored In A Central Warehouse Eliminates ___________ • Produces Great Savings – An Institution Doesn’t End Up Paying 5 People In 5 Different Departments To Produce The Same Product Data Sharing • Each User In The ‘___________’ Will Always Have Access To The ‘___________ & ___________’ Versions Of Data Data Maintenance • DBMS Enables ___________ Users To ___________ The Same Dataset Simultaneously
Background image of page 4
Some Capabilities of DBMS Load Data General/Customized Tools are provided/created to enable the addition of new data to the database Indexing Improve ___________ speed Query Language DBMS will support ___________ ___________ /manipulation ___________ (SQL) for filtering/sorting through the Database Controlled Update Very flexible tools for providing ‘___________’ read/write permissions. Handled via a ‘___________ ___________’
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Main Types of DBMS in GIS Relational Database Management System (RDBMS) RDBMS is the most popular type of DBMS • Over 95% of data in DBMS is in RDBMS • DB2; SQL Server, Access; Oracle A relational database is comprised of ___________, each a two-dimensional list in a _____ /_______ structure. Each single _____ stores a feature class. • Columns contain feature properties or attributes • Rows contain features • Data stored in the intersection (cell) of row & column is a value Name ID Major Level CSE David Frank Joan 9001 6001 6564 GEO BIO 1 4 2
Background image of page 6
Tables may be ___________ Database tables can be joined together based on a KEY to create new tables, or views of the database Codd (1970) suggested a set of rules to divide tables into normal forms to improve ___________, ___________, and reduce ___________ For performance issues, Non-Normalized tables are often used in GIS Main Types of DBMS in GIS
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Object (ODBMS) Based on ___________-___________ concept, to store object state and behavior in database; • Provide Object-Oriented query tools Designed To Improve On RDBMS • Not Commercially Successful RDBMS Were _______ ___________ Within Industry To Be Discarded In Favor Of ODBMS • Instead existing RDBMS were extended to become…
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/21/2011 for the course GIS 4043C taught by Professor Roberts during the Spring '11 term at FAU.

Page1 / 34

Lecture-4a_Bb_1SlidePerPage - Geographic Databases & ESRIs...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online