290 likes | 452 Views
GIS & Internet. Setting up and Maintaining Online Geographical Database. Contents. Setting up Online Geographical Database. Maintaining Online Geographical Database. Setting up Online Geographical Database. Database Geo-database Online database DBMS Metadata Clearinghouse
E N D
GIS & Internet Setting up and Maintaining Online Geographical Database
Contents Setting up Online Geographical Database Maintaining Online Geographical Database
Setting up Online Geographical Database Database Geo-database Online database DBMS Metadata Clearinghouse ESRI Geodatabase SDE
Database (DB) • A collection of information organized in such a way • that a computer program can quickly • select desired pieces of data
Record point 6459844.23 1342624.26 Field
Database Management System (DBMS) • A collection of programs that enables you to • Enter • Organize • Select data • in a database
Major Enterprise DBMS Vendors IBM Corp. Informix Corp. Oracle Corp. Sybase Inc. etc. All support GIS database
Geographical Database / (GIS DB) • A database for storing spatial data
Online Database • Databases available • to anyone who could link up to them • by computer network worldwide
Metadata • Data about data • A summary document providing content, • quality, type, creation, and spatial information • about a data set
Usage of Metadata Locate, interpret and use data Provide an inventory of data assets Help determine and maintain the value of data Help determine the reliability and currency of data Support decision - making Documents legal issues Help keep data accurate help verify accuracy to support good decision – making Help determine budgets and cost savings
Standards FGDC (Federal Geographic Data Committee) ISO (International Organization for Standardization )
Clearinghouse • A collection of servers • Search for metadata on datasets over the web • Data: producer, user, manager
Web Resources Data Server Computed Links App. Server Clearinghouse Upload data Interactive maps Metadata Documentation Register data Download Search Producer Users
ESRI Metadata Services • ArcGIS, ArcCatolog • Creating, authoring metadata and • sending to a metadata service • ArcIMS • Hosting metadata service • ArcSDE • interface to RDB storing metadata documents • ArcCatolog, Metadata Explorer, Web Browsers, Z39.50 Client • Access to metadata
ESRI Geodatabase & SDE • Geodatabase • A physical store of geographic information • inside a database management system (DBMS) • All data is stored together in a commercial DBMS • (IBM DB2, Informix, Oracle, or Microsoft SQL Server) • Allows multi-user access to continuous databases • through the use of versioning and long transactions • Supports advanced capabilities • Geodatabases can be accessed via the standard menus • and tools in ArcCatalog, ArcMap, and ArcToolbox
SDE Allows spatial data -- points, lines polygons and their associated attributes to be stored in a standard relational database
GIS Data Files DBMS HTMLJavaActiveX ArcExplorer Internet Map Server SDE Server Architecture of SDE
Contents Setting up Online Geographical Database Maintaining Online Geographical Database
Maintaining Online Geographical Database Data Updating Data Security
Data Updating • Always backup the data before the update of the data • Always check the data before issuing a commit • Always know what rows are going to be updated
Maintaining Online Geographical Database Data Updating Data Security
Data passes when requested by authenticated user Additional protection on ports and protocols Web/App. Servers Limitation on ports and protocols Load balancing Block the prevalent virus Firewalls Routers Data Security Security Protection Layers
Virus Scanning Latest version Updated daily Automatically clean any infected files
HTTP SMTP Telnet FTP SSL TCP/ IP SSL Data Encryption SSL --- Secure Socket Layer App. Protocol Connection Protocol
SSL Data Encryption A protocol providing encrypted communications on the Internet. Information exchanged between a user and GIS internet servers should not been intercepted by unauthorized third parties.
Data Backups and Restores Physical data security Permissions User access levels
User Access Levels System Administrator Supervisor Editor Auditor Remote Viewer Database Operator