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
Diserahkan:
9 Januari 2017/Diterima: 6 Jun 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
RUJUKAN
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(01): 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.
*Pengarang untuk
surat-menyurat; email: baixue@cnis.gov.cn
|