Biodiversity Science ›› 2016, Vol. 24 ›› Issue (7): 838-846.doi: 10.17520/biods.2015344

Special Issue: Marine Biodiversity Under Global Climate Change

• Orginal Article • Previous Article     Next Article

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

Hua Feng1, Wenhao Cao2, 3, Xiaoyang Tian1, Zhiqiang Cheng2, Tao Yan2, 3, *()   

  1. 1 School of Computer Science and Education Software, Guangzhou University, Guangzhou 510006
    2 Key Laboratory of Tropical Marine Bio-resources and Ecology, South China Sea Institute of Oceanology, Chinese Academy of Sciences, Guangzhou 510301
    3 Key Laboratory of Marine Environmental Corrosion and Bio-fouling, Institute of Oceanology, Chinese Academy of Sciences, Qingdao, Shandong 266071
  • Received:2015-12-07 Accepted:2016-06-25 Online:2016-08-04
  • Yan Tao

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

Fig. 1

Schematic diagram of the data management system for marine fouling organisms"

Fig. 2

Workflow diagram of the data management system for marine fouling organisms"

Fig. 3

Process entity relationship diagram of the data manage- ment system for marine fouling organisms"

Table 1

“Stations” form structure of the data management system for marine fouling organisms"

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

Table 2

“Sampling” form structure of the data management system for marine fouling organisms"

字段 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 (cm2)
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

Table 3

“Samples” form structure of the data management system for marine fouling organisms"

字段 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./m2) 空值 Null
wet weight 实数 Real number 湿重 Wet biomass (g/m2) 空值 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

Table 4

The corresponding relationships between the user role and page accessibility and jump strategy"

Unauthorized user
Ordinary user
Login.aspx 可访问
Jump to Change Your Password
Jump to Data Query
Jump to Data Query
SignUp.aspx 可访问
Jump to Change Your Password
Jump to Data Query
Jump to Data Query
Find your password
PswRecovery.aspx 可访问
Jump to Change Your Password
Jump to Data Query
Jump to Data Query
Data query
Query.aspx 跳转到登录
Jump to Login
Jump to Change Your Password
Jump to Data Query
Data editing
Edit.aspx 跳转到登录
Jump to Login
Jump to Change Your Password
Jump to Data Query
User management
UsersManage.aspx 跳转到登录
Jump to Login
Jump to Change Your Password
Jump to Data Query
Change your password
ChangePsw.aspx 跳转到登录
Jump to Login

Fig. 4

Data editing screenshot of the data management system for marine fouling organisms"

[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)
[1] Ke Wang Mingjun Zhao Jinhe Su Liu Yang Hong Deng Yonghui Wang Haijun Wu Yi Li Hongmei Wu Xiaodan Wei Tiezheng Wei Lei Cai Yijian Yao. (2020) The Use of Checklist of Fungi in China Database in the Red List Assessment of Macrofungi in China . Biodiv Sci, 28(1): 0-0.
[2] Fengyun Zhao, Yu Li, Tom Hsiang, Shuyan Liu. (2019) Species diversity of myxomycetes in two forests of the Lesser Khinggan Mountains, China . Biodiv Sci, 27(8): 896-902.
[3] CUI Li, GUO Feng, ZHANG Jia-Lei, YANG Sha, WANG Jian-Guo, MENG Jing-Jing, GENG Yun, LI Xin-Guo, WAN Shu-Bo. (2019) Improvement of continuous microbial environment in peanut rhizosphere soil by Funneliformis mosseae . Chin J Plant Ecol, 43(8): 718-728.
[4] Jiang Kaiwen, Pan Bo, Tian Bin. (2019) Recent taxonomic changes for Fabaceae (Leguminosae) genera in China . Biodiv Sci, 27(6): 689-697.
[5] Zhang Xue, Li Xing’an, Su Qinzhi, Cao Qina, Li Chenyi, Niu Qingsheng, Zheng Hao. (2019) A curated 16S rRNA reference database for the classification of honeybee and bumblebee gut microbiota . Biodiv Sci, 27(5): 557-566.
[6] Xie Dan,Wang Yuqin,Zhang Xiaoshuang,Wu Yu,Yang Jingyuan,Zhang Daigui. (2019) A catalogue of plant type specimens and history of plant collecting in Shennongjia National Park . Biodiv Sci, 27(2): 211-218.
[7] Hongli Ji, Xuanhuai Zhan, Li Zhang, Yansong Peng, Saixia Zhou, Wan Hu. (2019) Diversity and biogeographical characteristics of lycophytes and ferns in Mufu Mountains, China . Biodiv Sci, 27(11): 1251-1259.
[8] Bo Wang,Yong Huang,Jiatang Li,Qiang Dai,Yuezhao Wang,Daode Yang. (2018) Amphibian species richness patterns in karst regions in Southwest China and its environmental associations . Biodiv Sci, 26(9): 941-950.
[9] Shuang Tang,Shu Shen,Junming Shi,Yaohui Fang,Hualin Wang,Zhihong Hu,Fei Deng. (2018) A review and novel classification of Bunyavirales . Biodiv Sci, 26(9): 1004-1015.
[10] Luo Junjie, Wang Ying, Shang Hui, Zhou Xile, Wei Hongjin, Huang Sunan, Gu Yufeng, Jin Dongmei, Dai Xiling, Yan Yuehong. (2018) Phylogeny and Systematics of the Genus Microlepia (Dennstaedtiaceae) based on Palynology and Molecular Evidence . Chin Bull Bot, 53(6): 782-792.
[11] Hongwen Huang. (2018) “Science, art and responsibility”: The scientific and social function changes of a 500-year history of botanical gardens. II. Intension of sciences . Biodiv Sci, 26(3): 304-314.
[12] XU Hao, HU Chao-Chen, XU Shi-Qi, SUN Xin-Chao, LIU Xue-Yan. (2018) Effects of exotic plant invasion on soil nitrogen availability . Chin J Plant Ecol, 42(11): 1120-1130.
[13] Chi Zhang, Bo Zhou, Jialong Wu, Meirong Lv, Xufei Chen, Zhongyou Yuan, Ling Xiao, Jun Dai. (2018) Application of earthworms on soil remediation in southern China . Biodiv Sci, 26(10): 1091-1102.
[14] Fenglin Zhang,Xin Wang,Jian Zhang. (2018) Biodiversity information resources. II. Environmental data . Biodiv Sci, 26(1): 53-65.
[15] Xingfeng Si, Yuhao Zhao, Chuanwu Chen, Peng Ren, Di Zeng, Lingbing Wu, Ping Ding. (2017) Beta-diversity partitioning: methods, applications and perspectives . Biodiv Sci, 25(5): 464-480.
Full text