Yunnan Tin Mine Geological Database System Applications

It is the developing direction for Yunnan Tin Industry (Group) that the traditional industry will be remolded by high-tech and advanced practical technology in order to accomplish industrialization through digitized mining, and improve digitization by industrialization;And take a new-type industrialization road with higher technology content, better economical benefit and lower resources consuming. That build geological database system of the mine in Yunnan Tin Industry(Group) is an important basis to achieve mine informatization, a requirement to make full use of valuable materials accumulated during the past 100 years, to improve efficiency and quality of geological work ,to adapt to the development of new prospecting technique and method, and a necessary demand to develop advanced productivity. This paper combine with the science and technology cooperation item between Yunnan province and university/academy named The Research of Metallogenetic and Mineral Resource Predication in the Deep and Periphery of Gejiu Tin Deposit (2000YK-05) and the first-type research item of science and technology in Yunnan Tin Industry(Group) named The Exploitation Mine Computer Aid Design System in Yunnan Tin Industry(Group)(No.2001-12), and builds firstly mine geological database of Yunnan Tin Industry(Group) using database technique.The mine geological database is spread and applied in the mines of Yunnan Tin Industry(Group).By running more than 1 yeas, it has been proved that the mine geological database system can meet actual need of the mine production and technique of Yunnan Tin Industry(Group).Besides, the mine geological database system can be shared by mul-softwares.The system's capability is steady.Yunnan Tin Industry(Group) is a old mine which has 100 years exploiting history.Long-term geological exploration and productive construction of the mine have been accumulated abundant data which cotain a mass of geochemical data,geophysical data and science and technology research data.By means of the theory of information,using principle of advanced database technique,this paper analyses mine productive process of Yunnan Tin Industry(Group) and its pertinent data, and puts forward frame which directs to build mine database system.On the basis of the frame,this paper builds three relative dadabases such as engineering database,analyzing and testing database and hole database, and three graphic databases such as raster graph,plane graph and section graph.On the flat of MICROSOFT ACCESS and AUTO CAD,using Basic 6.0 and Visual Lisp2000,the author exploits geological database system software of mine in Yunnan Tin Industry(Group).The software is used and spread in the mine.This paper builds primarily topography database in Gejiu mine area,28 geological plans and section graphs of level from 1360 meter of level to 2350 meter of level, and hole database and measure database of large mines.The database system playes important role in mine area programming,mine system optimization,engineering design,geological work in field and synthesis information predication.