UNIT 44 - DATABASE CONCEPTS II

UNIT 44 - DATABASE CONCEPTS II

Compiled with assistance from Gerald White, California State University, Sacramento

  • A. INTRODUCTION
  • B. DATA SECURITY
  • C. CONCURRENT USERS
  • D. SECURITY AGAINST DATA LOSS
  • E. UNAUTHORIZED USE
  • REFERENCES
  • EXAM AND DISCUSSION QUESTIONS
  • NOTES

    UNIT 44 - DATABASE CONCEPTS II

    Compiled with assistance from Gerald White, California State University, Sacramento

    A. INTRODUCTION

    Databases for spatial data

    The relational model in GIS

    B. DATA SECURITY

    Integrity constraints

    Transactions

    C. CONCURRENT USERS

    Three types of concurrent access

    Checkout/checkin

    Determining extent of data locking

    Deadlock

    D. SECURITY AGAINST DATA LOSS

    E. UNAUTHORIZED USE

    Summary

    REFERENCES

    Standard database texts listed under unit 43

    Abel, D.J., 1989. "SIRO-DBMS: a database tool-kit for geographical information systems," International Journal of Geographical Information Systems 3:103-116. An extension of the relational model for spatial data.

    Frank, A.U., 1984. "Requirements for database systems suitable to manage large spatial databases," Proceedings, International Symposium on Spatial Data Handling, University of Zurich, pp. 38-60.

    Nyerges, T.L., 1989. "Schema integration analysis for the development of GIS databases," International Journal of Geographical Information Systems 3:153-184. Looks at formal procedures for comparing and merging spatial database schemas.

    EXAM AND DISCUSSION QUESTIONS

    1. In what ways are the database issues of GIS different from those of databases generally?

    2. What is meant by data integrity in a spatial database? Give examples.

    3. Give examples of the ways in which the integrity of a spatial database can degrade without adequate access controls.

    4. Examine the database access controls which exist in any GIS to which you have access. Would they be adequate for a large, production-oriented agency application?


    Back to Geography 370 Home Page

    Back to Geography 470 Home Page

    Back to GIS & Cartography Course Information Home Page



    Please send comments regarding content to: Brian Klinkenberg
    Please send comments regarding web-site problems to: The Techmaster
    Last Updated: August 30, 1997.