Abstract: There are shortcomings of manual count in traditional open-pit management，and partial special database fail to make full use of spatial data.Given this situation，from the view of spatial analysis in GIS，a database construction plan is proposed，which is established for open-pit truck dispatching system and uses SQL Server 2008 as backend database.Based on requirements analysis of the truck dispatching system，conceptual design，logic design，physical design and database building are done.A newly added spatial data type of SQL Server 2008 named Geography is introduced，and it is used for spatial data storage and management.With the fundamental spatial data of open-pit and running track of vehicles as the basis for spatial analysis，a series of common functions are realized，such as display vehicle location，track back and automatic statistics of vehicles workload，etc.This plan ensures the accuracy of automatic statistics and saves the manpower.Moreover，it provides a strong technical support for further promoting the open-pit managerial modernization.

Key words: Open-pit, Truck dispatching system, Spatial data, Database, SQL Server