Sains Malaysiana 46(11)(2017): 2195-2204

http://dx.doi.org/10.17576/jsm-2017-4611-21

 

Construction of Trace Element in Coal of China Database Management System: Based on WebGIS

(Pembinaan Unsur Surih dalam Arang Batu Sistem Pengurusan Pangkalan Data China: Berdasarkan WebGIS)

 

LIU YANG1, XUE BAI2*, YINJIE HU1, QIQI WANG1 & JUN DENG1

 

1China University of Mining & Technology, Beijing, Beijing 100083, China

 

2China National Institute of Standardization, Beijing 100191, China

 

Received: 9 January 2017/Accepted: 6 June 2017

 

ABSTRACT

The combination of geographic information system and mineral energy data management is helpful to promote the study of mineral energy and its ecological damage and environmental pollution caused by its development and utilization, which has important application value. The Trace Elements in Coal of China Database Management System (TECC) is established in this paper, applying the techniques of B/S three-layer structure, Oracle database, AJAX and WebGIS. TECC is the first database system which aims at managing the data of trace elements in coal in China. It includes data management and analysis module, document management module, trace elements in coal data maintenance module and authority management module. The data entry specification is put forward in the present study and the spatial data is included in TECC system. The system achieves the functions of data query, analysis, management, maintenance and map browsing, thematic map drawing as well as satellite video display, which lay the foundation for the analysis of large data of trace elements in coal. It is a practical platform for the acquisition, management, exchange and sharing of trace element research and geochemical research data of coal.

 

Keywords: Database; data entry specification; spatial data; trace element in coal; WebGIS

 

ABSTRAK

Gabungan sistem maklumat geografi dan pengurusan data tenaga mineral membantu untuk menggalakkan kajian tenaga mineral dan kerosakan ekologi serta pencemaran alam sekitar yang disebabkan oleh pembangunan dan penggunaannya yang mempunyai nilai aplikasi penting. Sistem pengurusan pangkalan data unsur surih arang batu di China (TECC) telah dibangunkan dalam kertas ini dengan menggunakan teknik struktur B/S tiga lapisan, pangkalan data Oracle, AJAX dan WebGIS. TECC adalah sistem pangkalan data pertama yang bertujuan untuk menguruskan data unsur surih dalam arang batu di China. Ia merangkumi pengurusan data dan analisis modul, modul pengurusan dokumen, modul penyelenggaraan data unsur surih dalam arang batu serta autoriti pengurusan modul. Spesifikasi kemasukan data dikemukakan dalam kajian ini dan data ruang dimasukkan ke dalam sistem TECC. Sistem ini telah mencapai fungsi pertanyaan data, analisis, pengurusan, penyelenggaraan dan peta pelayaran, lukisan peta tema serta paparan video satelit yang meletakkan asas untuk analisis data yang besar daripada unsur surih dalam arang batu. Ia merupakan satu platform yang praktik untuk pengambilalihan, pengurusan, pertukaran dan perkongsian data penyelidikan unsur surih dan penyelidikan geokimia dalam arang batu.

 

Kata kunci: Data ruang; unsur surih dalam arang batu; pangkalan data; WebGIS; spesifikasi kemasukan data

REFERENCES

Ashraf, M.A., Hussin, N.H. & Gharibreza, M. 2017. Studies on the removal of heavy metals from aqueous solution using immobilized Typha angustata L. Earth Science Pakistan 1(1): 12-16.

Cao, D.Y., Zhao, Z.F., Huang, P., Li, Y. & Wei, W.C. 2005. The design and development of China coal quality database system based on Oracle9i. China Mining Magazine 14(6): 1-3.

Cchen, M.S., Chen, W.M. & Tao, Y.L. 1984. Establishment of a national coal resource database coal quality. Coal Science and Technology 9(51): 48-50.

Chen, W.M. 1996. The data bank of Chinese coal rank source. Clean Coal Technology 2(1): 55-57.

Han, L., Qiu, F.T. & Zhu, D.M. 2009. Design and implementation of integrated coal geological information database management system. Opencast Mining Technology 6: 37-38.

Ichiyama, Y., Hanafusa, Y. & Soma, S. 2011. The “GANSEKI” database of ocean-floor rock samples. Journal of the Geological Society of Japan 117(10): 579-584.

Johnson, R.H. 2012. Geochemical data from groundwater at the proposed Dewey Burdock uranium in-situ recovery mine, Edgemont, South Dakota. U.S. Geological Survey, Open-File Report, 2012-1070.

Nie, L.S., Wang, X.Q., Xu, S.F. & Wang, W. 2012. Global geochemical data management: Development of chemical earth software. Earth Science Frontiers 19(3): 43-48.

Qu, Q.Y., Liu, G.J., Sun, M., Qi, C.C. & Liu, Y. 2016. A review of the geochemistry of tin (Sn) in Chinese coals: Measurement, concentration, distribution and modes of occurrence. Earth Science Frontiers 23(3): 68-73.

Radaideh, J.A., Alazba, A.A., Amin, M.N., Shatnawi, Z.N. & Amin, M.T. 2016. Improvement of indoor air quality using local fabricated activated carbon from date stones. Sains Malaysiana 45(1): 59-69.

Sarbas, B. & Nohl, U. 2009. The GEOROC database - A decade of ‘online geochemistry’. Geochmica et Cosmochimica Acta 73(13): A1158.

Sardar, M.S., Zafar, S. & Farahani, M.R. 2017. Computing Sanskruti index of the polycyclic aromatic hydrocarbons. Geology, Ecology, and Landscapes 1(1): 37-40.

Spear, F.S., Hallett, B., Pyle, J.M., Adalı, S., Szymanski, B.K., Waters, A., Linder, Z., Pearce, S.O., Fyffe, M., Goldfarb, D., Glickenhouse, N. & Buletti, H. 2013. MetPetDB: A database for metamorphic geochemistry. Geochemistry Geophysics Geosystems 10(12): 185-196.

Tang, X.Y. & Huang, W.H. 2004. Trace Elements in Coal of China. Beijing: The Commercial Press.

Tang, X.Y. & Huang, W.H. 2002. Trace elements of coal and its significances on research. Coal Geology of China 14(S1): 2-5.

U.S. Department of the Interior. 2014. Geochemistry of soils from the RASS database. U.S. Geological Survey. https: //minerals.usgs.gov/.

Walker, J.D., Lehnert, K.A., Hofmann, A.W., Sarbas, B. & Carlson, R.W. 2005. Earth Chem: International Collaboration for Solid Earth Geochemistry in Geoinformatics. AGU Fall Meeting. San Francisco: AGU Fall Meeting Abstracts.

Wang, W., Qin, Y., Qian, F.C., Ye, L.F., Hao, W.D., Yuan, L. & Jin, F. 2014. Partitioning of element from coal by different solvents extraction. Fuel 125: 73-80.

Wang, X., Dai, S., Chou, C.L., Zhang, M., Wang, J., Song, X., Wang, W., Jiang, Y., Zhou, Y. & Ren, D. 2012. Mineralogy and geochemistry of Late Permian coals from the Taoshuping Min, Yunnan Province, China: Evidences for the sources of minerals. International Journal of Coal Geology 96-97: 49-59.

Yang, L., Dong, X.Y. & Meng, D.Y. 2014. The common determination method of the trace elements in coal. China Mining Magazine 23(S2): 293-300.

Zhang, X.T. & Huang, M. 2014. Design and implementation of database system for coal resource survey. Bulletin of Surveying and Mapping S2: 292-296.

Zhou, P.G., Mao, J.G., Hou, S.S., Li, A. & Liu, S.D. 2007. The design and construction of landslide warning system based on WebGIS. Earth Science Frontiers 14(06): 38-42.

Zhuang, X. 2000. Energy database of China application in energy research. The Fifth Symposium on Science Database and Information Technology. Beijing: Science Press. pp. 249-253.

Zou, J.H., Liu, D., Tian, H.M., Liu, F., Li, T. & Yang, H.Y. 2013. Geochemistry of trace and rare earth elements in the Late Paleozoic coal from Adaohai Mine, Inner Mongolia. Journal of China Coal Society 38(06): 1012-1018.

 

*Corresponding author; email: baixue@cnis.gov.cn

 

 

 

 

 

 

 

 

 

 

 

 

previous