生物多样性 ›› 2016, Vol. 24 ›› Issue (7): 838-846.doi: 10.17520/biods.2015344

所属专题: 全球气候变化下的海洋生物多样性专辑

• • 上一篇    下一篇

海洋污损生物数据管理系统的设计与构建

冯华1, 曹文浩2, 3, 田晓阳1, 程志强2, 严涛2, 3, , A;*()   

  1. 1 .广州大学计算机科学与教育软件学院, 广州 510006
    2 .中国科学院南海海洋研究所热带海洋生物资源与生态重点实验室, 广州 510301
    3 .中国科学院海洋环境腐蚀与生物污损重点实验室, 山东青岛 266071
  • 收稿日期:2015-12-07 接受日期:2016-06-25 出版日期:2016-07-20
  • 通讯作者: 严涛 E-mail:yantao@scsio.ac.cn
  • 基金项目:
    国家自然科学基金(41176102)、广州市科技计划项目(2013J4300046)、湛江市科技计划项目(2013C01022)和中国科学院海洋环境腐蚀与生物污损重点实验室开放课题(MCKF201601)

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-07-20
  • Contact: Yan Tao E-mail:yantao@scsio.ac.cn

固着或栖息在船舶和人工设施水下部位的海洋污损生物, 会对人们的涉海活动产生不利影响, 其群落的形成和发展过程与温度、盐度、深度、季节、海域、浸海时间、离岸距离和附着基类型等多种因素密切相关。为便于系统分析和综合处理各海区污损生物资料, 理清各要素之间的内在关系, 需要一个能将上述因子与生物群落参数有机地结合起来的数据平台, 将分散、零星的资料予以归纳整合并通过网络共享, 以更好地为生产实践和科学研究服务。本研究采用Internet技术, 应用ASP.NET框架和MySQL数据库, 使用MS Visual Studio 2013设计并开发了服务端部署在Windows 7或Windows Server 2008 R2 (推荐)操作系统上的海洋污损生物数据管理系统, 实现了基于网络的海洋污损生物数据集成、储存与管理, 可完成来源不同、时相变化和海区多样的污损生物数据资料的集成与储存, 能通过单一或多种组合条件进行查询和检索, 并可根据用户的需要导出多种格式的检索结果报表。该系统具备操作简便、方便网络共享、易于升级更新和开拓新功能等特点, 能有效满足科研、生产和管理部门的需要。

关键词: 污损生物, 数据库, 分类, 生态, 生物地理

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

图1

海洋污损生物数据管理系统结构示意图"

图2

海洋污损生物数据管理系统工作流程示意图"

图3

海洋污损生物数据管理系统业务流程实体关系示意图"

表1

海洋污损生物数据管理系统“站位”表结构"

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

表2

海洋污损生物数据管理系统“采样”表结构"

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

表3

海洋污损生物数据管理系统“样本”表结构"

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

表4

用户角色与页面的可访问性及跳转策略的对应关系"

功能
Function
页面
Page
游客
Visitor
未授权用户
Unauthorized user
普通用户
Ordinary user
管理员
Administrator
登录
Login
Login.aspx 可访问
Accessible
跳转到密码修改
Jump to Change Your Password
跳转到数据查询
Jump to Data Query
跳转到数据查询
Jump to Data Query
注册
Registration
SignUp.aspx 可访问
Accessible
跳转到密码修改
Jump to Change Your Password
跳转到数据查询
Jump to Data Query
跳转到数据查询
Jump to Data Query
找回密码
Find your password
PswRecovery.aspx 可访问
Accessible
跳转到密码修改
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
可访问
Accessible
数据编辑
Data editing
Edit.aspx 跳转到登录
Jump to Login
跳转到密码修改
Jump to Change Your Password
跳转到数据查询
Jump to Data Query
可访问
Accessible
用户管理
User management
UsersManage.aspx 跳转到登录
Jump to Login
跳转到密码修改
Jump to Change Your Password
跳转到数据查询
Jump to Data Query
可访问
Accessible
密码修改
Change your password
ChangePsw.aspx 跳转到登录
Jump to Login
可访问
Accessible
可访问
Accessible
可访问
Accessible

图4

海洋污损生物数据管理系统数据编辑界面"

[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] 王科 赵明君 苏锦河 杨柳 邓红 王永会 吴海军 李熠 吴红梅 卫晓丹 魏铁铮 蔡磊 姚一建. (2020) 中国菌物名录数据库在红色名录编制中的作用(大型真菌红色名录专辑). 生物多样性, 28(1): 0-0.
[2] 李紫晶,莎娜,史亚博,佟旭泽,董雷,张小青,孙蔷,梁存柱. (2019) 内蒙古西鄂尔多斯地区半日花荒漠群落特征及其分类. 植物生态学报, 43(9): 806-816.
[3] 施晶晶,赵鸣飞,王宇航,薛峰,康慕谊,江源. (2019) 黄土高原腹地人工林下草本层群落构建机制. 植物生态学报, 43(9): 834-842.
[4] 袁海生, 魏玉莲, 周丽伟, 秦问敏, 崔宝凯, 何双辉. (2019) 东北4种林木干基腐朽病原真菌潜在分布范围预测及其生态位分析. 生物多样性, 27(8): 873-879.
[5] 崔利, 郭峰, 张佳蕾, 杨莎, 王建国, 孟静静, 耿耘, 李新国, 万书波. (2019) 摩西斗管囊霉改善连作花生根际土壤的微环境. 植物生态学报, 43(8): 718-728.
[6] 赵凤云, 李玉, TomHsiang, 刘淑艳. (2019) 小兴安岭两种林地的黏菌物种多样性. 生物多样性, 27(8): 896-902.
[7] 贾丙瑞. (2019) 凋落物分解及其影响机制. 植物生态学报, 43(8): 648-657.
[8] 孔嘉鑫, 张昭臣, 张健. (2019) 基于多源遥感数据的植物物种分类与识别: 研究进展与展望. 生物多样性, 27(7): 796-812.
[9] 符义稳, 田大栓, 汪金松, 牛书丽, 赵垦田. (2019) 内蒙古和青藏高原草原植物叶片与根系氮利用效率空间格局及影响因素. 植物生态学报, 43(7): 566-575.
[10] 蒋凯文, 潘勃, 田斌. (2019) 近年来中国国产豆科的属级分类学变动. 生物多样性, 27(6): 689-697.
[11] 黄玫, 王娜, 王昭生, 巩贺. (2019) 磷影响陆地生态系统碳循环过程及模型表达方法. 植物生态学报, 43(6): 471-479.
[12] 刘璐, 葛结林, 舒化伟, 赵常明, 徐文婷, 申国珍, 谢宗强. (2019) 神农架常绿落叶阔叶混交林碳氮磷化学计量比. 植物生态学报, 43(6): 482-489.
[13] 李萌, 尉婷婷, 史博洋, 郝希阳, 徐海根, 孙红英. (2019) 环境DNA技术在淡水底栖大型无脊椎动物多样性监测中的应用. 生物多样性, 27(5): 480-490.
[14] 汤永康, 武艳涛, 武魁, 郭之伟, 梁存柱, 王敏杰, 常佩静. (2019) 放牧对草地生态系统服务和功能权衡关系的影响. 植物生态学报, 43(5): 408-417.
[15] 李晗溪, 黄雪娜, 李世国, 战爱斌. (2019) 基于环境DNA-宏条形码技术的水生生态系统入侵生物的早期监测与预警. 生物多样性, 27(5): 491-504.
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed