|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/an-overview-of-spatial-data-and-gis-for-the-dba/
课程评论：没有评论
课程名称：DBA的空间数据和GIS概述 课程概述：本课程旨在帮助数据库管理员（DBA）更好地管理空间数据库（也称为地理数据库），通过深入理解空间数据及其收集、存储数据的不同数据类型，以及最终的数据展示。课程旨在为学员与GIS专业人士建立共同语言，提高DBA在空间数据管理中的能力，并阐明空间数据管理的不同之处。 课程的哲学观点是，了解数据的基本特征将助力DBA更高效地管理数据。在课程引言部分，通过举例说明空间数据的创建过程，使DBA对坐标系统的知识有更深入的理解。学员将学习如何选择适合的坐标系统类型，并理解为何某些坐标系统在现实生活中得到广泛应用。 课程还将介绍空间数据共享的策略，告知学员在组织内部如何有效管理空间数据。运营考量部分将涵盖多个主题，包括参与者将了解到空间数据的管理可能面临的三种情境。课程中将以概览的方式介绍版本控制的空间数据及编辑工作，并浅谈ArcSDE的运作方式。 由于这门课程是概述性质，讲授内容将集中于一种编辑供应商的情况，帮助学员理解空间数据操作的性能考量。虽然每个供应商的情境不同，但课程将依据教师的经验提供高水平的例子，扩展学员对GIS在整体操作中可能适用性的思考。 最后，课程设计了一节关于如何将空间能力添加到数据库的介绍，提供几个问题帮助DBA明确空间数据操作的需求。尽管各数据库供应商的具体要求有所不同，但本节课将指引学员创建控件空间的表格（包含几何列）的整体步骤，包括选择坐标系统、定义空间元数据、插入元数据、创建空间索引以及包括空间数据在内的数据插入等内容。 通过本课程，学员将获得关于空间数据和GIS的基本知识，提升在空间数据管理方面的专业能力。
Managing a spatial database, or as some vendors call it, a geodatabase, requires some insight into spatial data, the collection of the data, different datatypes used to store the data, and the ultimate display of the data. This course is meant to give you more common ground with the GIS Professional, to do the best job of managing spatial data as a DBA, and see some differences in how spatial data is managed. The philosophy that is presented is that if you know something about the data, you will do a much better job of managing it as a DBA. So, in the introduction, a few examples are given about how spatial data is created. The DBA will have a better understanding why they should have some knowledge of coordinate systems. Some questions are provided to help you pick a coordinate system type to use, or understand why a certain coordinate system is currently being used. Some examples are provided for what different types of coordinate systems are used for in the real world. Participants are provided enough information to understand the basics of different types of geometries and datatypes that are used to store the spatial data. An introduction is given into the strategy of spatial data sharing in organizations. A section on operational considerations provides several overview lectures of subjects to think about. First, a lecture provides insight into how spatial data might be managed by one or all of three scenarios that have been experienced. A high level view of versioned spatial data and editing is then provided to show how ArcSDE operates. Since this class is an overview, only one editing Vendor situation is presented at a high level. The participant is provided some performance considerations that need to be thought about for spatial data operations. Each Vendor's scenarios might be somewhat different, but these are ones that the instructor has experienced. The participant is given a few high level examples of integrated GIS systems, to broaden the thinking of where GIS might fit into your overall operation. A lecture was designed to give participants an introduction into adding spatial capability to their database. Several questions are provided to help the DBA hone in on the requirements for the spatial data operations. Each database Vendor has their own specifics for spatial data, but this specific lecture will give the general path to making this happen. Participants learn the steps to create a spatially enabled table with a geometry column. Picking the coordinate system Defining the spatial metadata Inserting the metadata Creating the spatial index Inserting the data including the spatial data Running the stats
