 |
 |
 |
 |
 |
 |
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
|
|||
|
