Design and development of a data management system for marine fouling organisms

doi:10.17520/biods.2015344

Abstract

Abstract:

Biofouling, the unwanted assemblage of marine organisms colonizing submerged parts of ships and artificial facilities, has a negative impact on human activities related to the sea. The development of fouling communities is closely related to a variety of factors such as temperature, salinity, depth, season, immersion time, geographic location, distance from shore and substratum type. To facilitate systematic analysis and processing of data on marine fouling and clarify the intrinsic relationship between the various elements mentioned above, it is necessary to build a technical platform to integrate scattered and sporadic information and to share this data through a network. By means of internet technology, the ASP.NET framework and MySQL database, the MS Visual Studio 2013 software was used to devise a data management system for marine fouling organisms under the Windows 7 or Windows Server 2008 R2 (recommended) operating system. From the system, data integration, storage and management of fouling organisms are implemented via the network. Query and retrieval of data can be conducted under single or multiple search conditions and the results are exported in several formats according to the user’s requirements. The data management system for marine fouling organisms provides a useful and effective way to help data analysis and decision-making for research, industry and administration.

Key words: fouling organisms, database, taxonomy, ecology, biogeography

Hua Feng, Wenhao Cao, Xiaoyang Tian, Zhiqiang Cheng, Tao Yan. Design and development of a data management system for marine fouling organisms[J]. Biodiv Sci, 2016, 24(7): 838-846.

Add to citation manager EndNote|Ris|BibTeX

URL: https://www.biodiversity-science.net/EN/10.17520/biods.2015344

https://www.biodiversity-science.net/EN/Y2016/V24/I7/838

Figures/Tables 8

References 37

[37]	[袁骐, 沈新强 (2004) 海洋渔业生态环境监测数据库系统的设计和实现. 海洋渔业, 26, 266-270.]
[38]	Zhang H, Cao WH, Wu ZW, Song XK, Wang JJ, Yan T (2015) Biofouling on deep-sea submersible buoy systems off Xisha and Dongsha Islands in the northern South China Sea. International Biodeterioration & Biodegradation, 104, 92-96.
[39]	Zhao B, Tang LJ, Wu QH, Chen JK (2000) The establishment and application of Shanghai Biodiversity Information Management System. Chinese Biodiversity, 8, 233-237. (in Chinese with English abstract)
	[赵斌, 唐礼俊, 吴千红, 陈家宽 (2000) 上海市生物多样性信息管理系统的建立和应用. 生物多样性, 8, 233-237.]
[40]	Zhu L, Xue H (2007) The mapping model of the object-oriented relational database systems and its applications. Computer Engineering & Science, 29(12), 120-122. (in Chinese with English abstract)
	[朱玲, 薛贺 (2007) 对象关系数据库系统映射模型及应用. 计算机工程与科学, 29(12), 120-122.]
[1]	Alberte RS, Snyder S, Zahuranec B, Whetstone M (1992) Biofouling research needs for the United States Navy: program history and goals. Biofouling, 6, 91-95.
[2]	Connell SD (2001) Urban structures as marine habitats: an experimental comparison of the composition and abundance of subtidal epibiota among pilings, pontoons and rocky reefs. Marine Environmental Research, 52, 115-125.
[3]	Edyvean RGJ, Terry LA, Picken GB (1985) Marine fouling and its effects on offshore structures in the North Sea—a review. International Biodeterioration, 21, 277-284.
[4]	Fitridge I, Dempster T, Guenther J, de Nys R (2012) The impact and control of biofouling in marine aquaculture: a review. Biofouling, 28, 649-669.
[5]	Gao H, Liang JR, Gao YH, Luo QQ, Li XS, Chen CP (2006) Construction of a database of common marine phytoplankton in coastal waters of China. Journal of Xiamen University (Natural Science), 45(Suppl.1), 230-233. (in Chinese with English abstract)
	[高华, 梁君荣, 高亚辉, 骆巧琦, 李雪松, 陈长平 (2006) 我国沿海常见浮游植物检索数据库的建立. 厦门大学学报(自然科学版), 45(Suppl.1), 230-233.]
[6]	General Administration of Quality Supervision, Inspection and Quarantine of China, Standardization Administration of China(2007a) Specifications for Oceanographic Survey--Part 6: Marine Biological Survey. China Standards Press, Beijing. (in Chinese)
	[中华人民共和国国家质量监督检验检疫总局, 中国国家标准化管理委员会(2007a) 海洋调查规范第6部分: 海洋生物调查. 中国标准出版社, 北京.]
[7]	General Administration of Quality Supervision, Inspection and Quarantine of China, Standardization Administration of China(2007b) Specifications for Oceanographic Survey--Part 4: Survey of Chemical Parameters in Sea Water. China Standards Press, Beijing. (in Chinese)
	[中华人民共和国国家质量监督检验检疫总局, 中国国家标准化管理委员会(2007b) 海洋调查规范第4部分: 海水化学要素调查. 中国标准出版社, 北京.]
[8]	General Administration of Quality Supervision, Inspection and Quarantine of China, Standardization Administration of China(2007c) Specifications for Oceanographic Survey--Part 9: Guidelines for Marine Ecological Survey. China Standards Press, Beijing. (in Chinese)
	[中华人民共和国国家质量监督检验检疫总局, 中国国家标准化管理委员会(2007c) 海洋调查规范第9部分: 海洋生态调查指南. 中国标准出版社, 北京.]
[9]	Glasby TM (1999) Differences between subtidal epibiota on pier pilings and rocky reefs at marinas in Sydney, Australia. Estuarine, Coastal and Shelf Science, 48, 281-290.
[10]	Griffiths HJ, Linse K, Crame JA (2003) SOMBASE--Southern Ocean Mollusc Database: a tool for biogeographic analysis in diversity and ecology. Organisms Diversity & Evolution, 3, 207-213.
[11]	Gu J, Gong JX, Jiao NZ, Zhao SJ (2002) Jiaozhou Bay ecological GIS database. Marine Sciences, 26(1), 13-16. (in Chinese)
	[顾军, 龚建新, 焦念志, 赵淑江 (2002) 胶州湾海洋生态环境GIS数据库的构筑. 海洋科学, 26(1), 13-16.]
[12]	Heaf NJ (1979) The effect of marine growth on the performance of fixed offshore platforms in the North Sea. In: Proceedings of the 11th Annual Offshore Technology Conference, pp. 255-268. Houston, Texas.
[13]	Huang B, Xu FS, Dang HY (1996) The management information system of Bivalvia Mollusca database in China Seas. Oceanologia et Limnologia Sinica, 27, 220-223. (in Chinese with English abstract)
	[黄勃, 徐凤山, 党宏月 (1996) 中国海域双壳类软体动物数据库的结构与功能. 海洋与湖沼, 27, 220-223.]
[14]	Huang LJ, Zheng XF, Luo T (2004) Research on object relationship mapping. Computer Engineering and Design, 25, 1994-1995. (in Chinese with English abstract)
	[黄丽娟, 郑雪峰, 罗涛 (2004) 对象映射关系型数据库技术研究. 计算机工程与设计, 25, 1994-1995.]
[15]	Huang ZG, Cai RX (1984) Marine Biofouling and Its Prevention, Vol. I, pp. 1-37. China Ocean Press, Beijing. (in Chinese)
	[黄宗国, 蔡如星 (1984) 海洋污损生物及其防除(上册), pp. 1-37. 海洋出版社, 北京.]
[16]	Li J, Yan T, Cao WH, Chen C, Chen RJ (2010) Advances in research of marine fouling in offshore areas. Marine Science Bulletin, 29(1), 113-119. (in Chinese with English abstract)
	[李静, 严涛, 曹文浩, 陈池, 陈如江 (2010) 近海污损生物生态研究进展. 海洋通报, 29(1), 113-119.]
[17]	Liu ML, Yan T (2006) A review of marine fouling communities in the South China Sea. Marine Science Bulletin, 25(1), 84-91. (in Chinese with English abstract)
	[刘勐伶, 严涛 (2006) 南海污损生物生态研究进展. 海洋通报, 25(1), 84-91.]
[18]	Marine Technology Directorate Limited (1992) Appraisal of Marine Growth on Offshore Installations, pp. 15-24. Marine Technology Directorate Limited, London.
[19]	Neville A, Hodgkiess T (2000) Localised effects of macrofouling species on electrochemical corrosion of corrosion resistant alloys. British Corrosion Journal, 35(1), 54-59.
[20]	Page HM, Dugan JE, Dugan DS, Richards JB, Hubbard DM (1999) Effects of an offshore oil platform on the distribution and abundance of commercially important crab species. Marine Ecology Progress Series, 185, 47-57.
[21]	Perkol-Finkel S, Zilman G, Sella I, Miloh T, Benayahu Y (2008) Floating and fixed artificial habitats: spatial and temporal patterns of benthic communities in a coral reef environment. Estuarine, Coastal and Shelf Science, 77, 491-500.
[22]	Qiao HJ, Han Y, Li N, Ji LQ (2004) A model of biodiversity information integration. Biodiversity Science, 12, 553-561. (in Chinese with English abstract)
	[乔慧捷, 韩艳, 李诺, 纪力强 (2004) 生物多样性数据集成模式初探. 生物多样性, 12, 553-561.]
[23]	Schultz MP, Bendick JA, Holm ER, Hertel WM (2011) Economic impact of biofouling on a naval surface ship. Biofouling, 27, 87-98.
[24]	Shao KT, Lai KC, Lin YC, Ko CJ, Lee H, Hung LY, Chen YC, Chen LS (2010) Experience and strategy of biodiversity data integration in Taiwan. Biodiversity Science, 18, 444-453. (in Chinese with English abstract)
	[邵广昭, 赖昆祺, 林永昌, 柯智仁, 李瀚, 洪铃雅, 陈岳智, 陈丽西 (2010) 台湾生物多样性资料整合之经验与策略. 生物多样性, 18, 444-453.]
[25]	Shao KT, Lee H, Lin YC, Lai KC (2014) A review of marine biodiversity information resources. Biodiversity Science, 22, 253-263. (in Chinese with English abstract)
	[邵广昭, 李瀚, 林永昌, 赖昆祺 (2014) 海洋生物多样性信息资源. 生物多样性, 22, 253-263.]
[26]	Spaanjaars I (translated by Liu WQ, Zhang GX) (2010) Beginning ASP.NET 4 in C# and VB, pp. 514-542. Tsinghua University Press, Beijing. (in Chinese)
	[刘伟琴, 张格仙 (译) (2010)ASP.NET 4入门经典: 涵盖C#和VB.NET, pp. 514-542. 清华大学出版社, 北京.]
[27]	Su TY, Liu HX, Liu BH, Han JY, Yang FL (2008) Design of Yellow Sea larger marine ecosystem database. Advances in Marine Science, 26, 243-250. (in Chinese with English abstract)
	[苏天赟, 刘海行, 刘保华, 韩京云, 杨凤丽 (2008) 黄海大海洋生态系数据库设计. 海洋科学进展, 26, 243-250.]
[28]	Swift MR, Fredriksson DW, Unrein A, Fullerton B, Patursson O, Baldwin K (2006) Drag force acting on biofouled net panels. Aquacultural Engineering, 35, 292-299.
[29]	Venkatesan R, Murthy PS (2009) Macrofouling control in power plants. In: Marine and Industrial Biofouling (eds Flemming HC, Murthy PS, Venkatesan R), pp. 265-291. Springer, Berlin.
[30]	Wilhelmsson D, Malm T (2009) Fouling assemblages on offshore wind power plants and adjacent substrata. Estuarine, Coastal and Shelf Science, 79, 459-466.
[31]	Woods Hole Oceanographic Institution (1952) Marine Fouling and Its Prevention, pp. 3-20. United States Naval Institute, Annapolis, Maryland.
[32]	Yan T, Cao WH (2008) Ecology of marine fouling organism in Huanghai and Bohai Seas. Journal of Marine Sciences, 26(3), 107-118. (in Chinese with English abstract)
	[严涛, 曹文浩 (2008) 黄、渤海污损生物生态特点及研究展望. 海洋学研究, 26(3), 107-118.]
[33]	Yan T, Liu SS, Cao WH (2008) Marine biofouling on aquaculture facilities in the coastal waters of China and prevention methods. Marine Science Bulletin, 27(1), 102-110. (in Chinese with English abstract)
	[严涛, 刘姗姗, 曹文浩 (2008) 中国沿海水产设施污损生物特点及防除途径. 海洋通报, 27(1), 102-110.]
[34]	Yan T, Yan WX, Dong Y, Wang HJ, Yan Y, Liang GH (2009) Marine fouling on floating installations west of Dongsha Islands, the northern South China Sea. International Biodeterioration & Biodegradation, 63, 1079-1087.
[35]	Yan T, Zhang H, Li YQ, Cao WH, Hu BR (2014) An overview of fouling sedentary polychaetes. Acta Ecologica Sinica, 34, 6049-6057. (in Chinese with English abstract)
	[严涛, 张慧, 李韵秋, 曹文浩, 胡碧茹 (2014) 污损性管栖多毛类生态特点及研究展望. 生态学报, 34, 6049-6057.]
[36]	Yang TX, Yan T, Chen C, Cao WH, Chen RJ, Cheng ZQ, Hu YF (2013) Research on the effects of marine macro-fouling organisms on metal corrosion. Industrial Safety and Environmental Protection, 39(11), 69-71. (in Chinese with English abstract)
	[杨天笑, 严涛, 陈池, 曹文浩, 陈如江, 程志强, 胡煜峰 (2013) 大型海洋污损生物对金属材料腐蚀影响及研究展望. 工业安全与环保, 39(11), 69-71.]
[37]	Yuan Q, Shen XQ (2004) Design and development of the database for marine fisheries eco-environmental monitoring. Marine Fisheries, 26, 266-270. (in Chinese with English abstract)

字段 Field	类型 Type	说明 Description	备注 Remark
name	字符串 Character string	站位名称 Station’s name	用作标识符 Used for identifier
alias	字符串 Character string	站位别名 Station’s alias	空值 Null
location	字符串 Character string	站位地点 Station position
depth	实数 Real number	站位水深 Station depth
longitude	实数 Real number	站位经度 Longitude
latitude	实数 Real number	站位纬度 Latitude
distance	实数 Real number	离岸距离(公里) Distance from shore (km)
facility	字符串 Character string	设施类型 Type of facility
settingdate	日期 Date	设施布设时间 Deployment date
retrievaldate	日期 Date	设施回收时间 Retrieval date

字段 Field	类型 Type	说明 Description	备注 Remark
name	字符串 Character string	站位名称 Station’s name	用作标识符 Used for identifier
alias	字符串 Character string	站位别名 Station’s alias	空值 Null
location	字符串 Character string	站位地点 Station position
depth	实数 Real number	站位水深 Station depth
longitude	实数 Real number	站位经度 Longitude
latitude	实数 Real number	站位纬度 Latitude
distance	实数 Real number	离岸距离(公里) Distance from shore (km)
facility	字符串 Character string	设施类型 Type of facility
settingdate	日期 Date	设施布设时间 Deployment date
retrievaldate	日期 Date	设施回收时间 Retrieval date

字段 Field	类型 Type	说明 Description	备注 Remark
id	序号 SN		用作标识符 Used for identifier
oridinal	字符串 Character string	试板编号 Serial number of test panels	“采样点”不用 Not for sampling positions
direction	字符串 Character string	采样方位 Sampling position	“试板”不用 Not for panel tests
s_name	字符串 Character string	调查站位 Investigation station	“站位”的标识符 Station identifier
depth	实数 Real number	采样点深度 Sampling depth
temperature	实数 Real number	采样点温度 Temperature of sampling point
salinity	实数 Real number	采样点盐度 Salinity of sampling point
method	枚举 Enumeration	采样方式 Sampling method
survey_time	自然数 Natural number	浸海时间(月) Immersion time (Month)
area	实数 Real number	采样面积 Sampling area (cm²)
thickness	实数 Real number	样品厚度 Fouling thickness	空值 Null
biomass	实数 Real number	总生物量 Total biomass	空值 Null
sv_time	日期 Date	试板回收时间 Retrieval date	“采样点”不用 Not for sampling positions
notices	字符串 Character string	备注 Remarks	空值 Null

字段 Field	类型 Type	说明 Description	备注 Remark
id	序号 SN		用作标识符 Used for identifier
oridinal	字符串 Character string	试板编号 Serial number of test panels	“采样点”不用 Not for sampling positions
direction	字符串 Character string	采样方位 Sampling position	“试板”不用 Not for panel tests
s_name	字符串 Character string	调查站位 Investigation station	“站位”的标识符 Station identifier
depth	实数 Real number	采样点深度 Sampling depth
temperature	实数 Real number	采样点温度 Temperature of sampling point
salinity	实数 Real number	采样点盐度 Salinity of sampling point
method	枚举 Enumeration	采样方式 Sampling method
survey_time	自然数 Natural number	浸海时间(月) Immersion time (Month)
area	实数 Real number	采样面积 Sampling area (cm²)
thickness	实数 Real number	样品厚度 Fouling thickness	空值 Null
biomass	实数 Real number	总生物量 Total biomass	空值 Null
sv_time	日期 Date	试板回收时间 Retrieval date	“采样点”不用 Not for sampling positions
notices	字符串 Character string	备注 Remarks	空值 Null

字段 Field	类型 Type	说明 Description	备注 Remark
sp_id	序号 SN		用作标识符 Used for identifier
s_id	序号 SN		“采样”的标识符 Sampling identifier
snum	字符串 Character string	样本编号 Serial number of samples
gettime	日期 Date	采样时间 Sampling date	用于“采样点” For sampling positions
name	字符串 Character string	物种名 Species name
cover	实数 Real number	覆盖面积 Coverage area	空值 Null
density	实数 Real number	密度 Density (ind./m²)	空值 Null
wet weight	实数 Real number	湿重 Wet biomass (g/m²)	空值 Null
size	实数 Real number	个体大小 Individual size	空值 Null
alive	自然数 Natural number	成活个体数 Number of individuals alive	空值 Null
died	自然数 Natural number	死亡个体数 Number of dead individuals	空值 Null
notices	字符串 Character string	备注 Remarks	空值 Null