1) Curriculum positioningThis course is a key link between basic computer knowledge, geographic information system and other pre-course courses and professional practice courses, facing the job needs in the fields of surveying and mapping geographic information, urban planning, municipal management, land and resources, with vocational ability training as the core, work process as the guide, and actual project tasks as the carrier, to create a curriculum system of "theory sufficient, practice first, and literacy adaptation". The course not only focuses on the basic theory of spatial database technology, but also focuses on practical application scenarios in the industry, cultivates students' ability to solve practical problems in spatial data management and application, and is one of the core courses to cultivate high-quality technical and skilled talents and adapt to the needs of industries such as new basic surveying and mapping.(2) Curriculum objectivesCombined with the requirements of industry positions and talent training goals, the teaching objectives of this course are divided into three dimensions: knowledge objectives, ability objectives and quality objectives, which are interrelated and coordinated:1. Knowledge objectives: master the basic concepts and development history of databases and relational databases, and understand the core principles, data models (such as Geodatabase data models) and technical specifications of spatial databases; Familiar with the collection, editing, and storage processes of spatial data, and master the basic usage of SQL language and spatial query language (GSQL). Understand the functional characteristics of mainstream spatial database software (SQL Server, PostgreSQL+PostGIS, ArcGIS, etc.), and know the development trend of spatial database and theoretical knowledge related to innovation and entrepreneurship.2. Ability objectives: be proficient in operating mainstream spatial database software, complete the creation and management of databases and data tables; Possess the ability of requirements analysis, conceptual design, logical design and physical design of spatial databases. master the warehousing, quality inspection, update and maintenance methods of spatial data, and be able to use spatial query and analysis technology to solve practical project problems; Cultivate innovative thinking and problem-solving skills, and be able to independently complete the design and implementation of simple spatial database projects.3. Quality objectives: cultivate law-abiding, serious and rigorous, excellence craftsman spirit and professional ethics of love and dedication; Establish noble professional ethics and the awareness of serving the society, and cultivate the spirit of cooperation of dedication and teamwork; Develop good habits of standardized operation and data security, improve independent learning and sustainable development capabilities, and have a certain sense of innovation and entrepreneurial potential.(3) The main content of the courseThe course content follows the hierarchical principle of "low-intermediate-high", and is divided into two modules: theoretical teaching and practical teaching.1. Basic theoretical modules: covering the basic concepts of data and information, the development history of data management technology (manual management, document management, database management); the core principles, composition structure and SQL language foundation of relational databases; The definition, characteristics, composition and differences and connections between spatial databases and relational databases; the basic theory of spatial data model, spatial index, spatial query and analysis; Industry application scenarios and development trends of spatial database technology.2. Practical operation module: including mainstream software practice (SQL Server 2008, PostgreSQL+PostGIS, ArcGIS, etc.), including software installation and environment configuration, database and data table creation, data addition and editing; Spatial database design and practical operation, complete the whole process from requirements analysis to physical implementation; Spatial data storage and quality inspection, mastering data format conversion, topology construction, error correction and other skills; Spatial query and analysis practice, using relevant tools to complete tasks such as spatial retrieval, overlay analysis, and proximity analysis; Comprehensive project training, combined with practical scenarios such as natural resource database construction and teaching management database construction, complete the design and implementation of complete spatial database projects, and improve comprehensive application capabilities
