GIS Design Aspects and Data Modeling Flashcards
Conceptual Model
describes spatial objects as well as logical and topological relationships between spatial objects and the captured spatial entities
Data Structure Model
expresses the spatial objects of the conceptual model in terms of transfer data structures - based on traditional relational and network models - data structures viewed as spatial data structures are both vector and raster models
Transfer Model
express the logical constructs of the transfer form in terms of implementation-media constructs
File Based Transfer
data is a structured file format
Application Programming Interface (API)
data is accessed and exchanged as needed between software systems
Web Services
data is accessed and exchanged over networks and the internet between software components, using http and other web based protocols
Data Owner
user who creates tables, features classes owns those datasets
User Access
database must verify the user accounts that connect to it
Authentication
database checks the list of users to make sure a user is allowed to make a connection - Operating System (OS) authentication or Database Authentication
Groups
grant users based on their common functions
Public Role
right granted to anyone connected to database
Backup and Recover Database
test backup and recovery plan, ensure backups done on schedule
Database Security
prevent hackers, security models, tasks - authentication, authorization, auditing (making sure the right people have the right access)
Storage and Capacity Planning
disk storage is needed and monitor disk space and watch growth trends
Performance Monitoring
identify bottlenecks, tuning (indexing, queries on speed of return, right monitoring tools, capacity of server hardware
Troubleshooting
quickly ascertain problem and correct it
Other
High Availability and ETL functions - Data extraction, transformation, and loading
Requirements Phase
user needs assessment and workflow loads analysis (baseline and peak traffic)
Design Phase
Infrastructure requirements, network communication capacity, hardware and software procurement, software development and data acquisition must be identified
Construction Phase
system procurement, data acquisition and database design, authorization for application design and development, prototype testing
Implementation Phase
Initial Deployment and operational testing, final system delivery, user training, system maintenance operations
Capacity Planning Tool (CPT)
developed as a framework to promote successful GIS system design and implementation
Enterprise GIS Environment
broad spectrum of technology integration of enterprise technologies connected by local area networks, wide area networks, internet communications
Enterprise Technologies
database servers, storage area networks, windows terminal servers, web servers, map servers, desktop clients
Schema
structure or design of the database or database object (table, view, index, stored procedure, trigger) - defines the tables, fields in each table, relationships between fields - a schema will include information on which fields have domains and what those domains are
Data Dictionary
catalog or table containing information about the datasets stored in a database
Domain
the range of values for a particular metadata element
Attribute Domain
enforces data integrity, identify what values are allowed in a field in a feature class
Coded Value Domain
attribute domain that defines a set of permissible values for an attribute in a geodatabase - it has a code and its equivalent value
Range domain
type of attribute domain that defines the range of permissible values for a numeric attribute
Spatial Domain
allowable range for x,y coordinates and for m,z values
Individual Files
shapefiles, file gdb, personal gdb, tables, spreadsheets, CAD, rasters