|
|||||
|
|
| 海洋渔业数据仓库的研究与实现 | |
| 引用本文： | 周甦芳,吴健平,崔雪森.海洋渔业数据仓库的研究与实现[J].海洋渔业,2006,28(3):246-250. |
| 作者姓名： | 周甦芳 吴健平 崔雪森 |
| 作者单位： | 1. 中国水产科学研究院渔业遥感信息技术重点开放实验室,上海,200090;华东师范大学,地理信息科学教育部重点实验室,上海,200062 2. 华东师范大学,地理信息科学教育部重点实验室,上海,200062 3. 农业部海洋与河口渔业重点开放实验室,上海,200090 |
| 基金项目： | 国家高技术研究发展计划(863计划);农业部重点实验室基金 |
| 摘 要： | 数据仓库技术作为数据库技术应用的新型手段,是海洋渔业数据集成、实现业务化管理的良好的解决方案。根据海洋渔业的特点,本文提出了构建海洋渔业数据仓库的策略、基本框架,探讨了在海洋环境数据仓库建设过程中数据集市模型设计、建立数据准备区、数据规划和数据提取等四个关键问题,用SQL Server初步建成了海洋渔业数据仓库。 |
| 关 键 词： | 海洋渔业 数据仓库 数据集市 数据模型 数据提取 |
| 文章编号： | 1004-2490（2006）02-0246-05 |
| 收稿时间： | 2006-04-04 |
| 修稿时间： | 2006-04-04 |
The construction of marine fisheries data warehouse |
|
| ZHOU Su-fang,WU Jian-ping,CUI Xue-sen.The construction of marine fisheries data warehouse[J].Marine Fisheries,2006,28(3):246-250. | |
| Authors: | ZHOU Su-fang WU Jian-ping CUI Xue-sen |
| Institution: | 1. Key and Open Laboratory of Fisheries Remote Sensing and Information Technology, East China Sea Fisheries Research Institute, Chinese Academy of Fishery Sciences, Shanghai 200090, China; 2. Key Laboratory of Geographic Information Science, East China Normal University, Ministry of Education, Shanghai 200062, China ; 3. Key and Open Laboratory of Marine and Estuarine Fisheries, Ministry of Agriculture, East China Sea Fisheries Research Institute, Chinese Academy of Fishery Sciences, Shanghai 200090, China |
| Abstract: | As a new method of the database technology application, the data warehouse technology is a better solution for marine fisheries data integration and operational management. In this paper, based on the characteristics of marine fisheries, the construction strategy and the base framework of marine fisheries data warehouse are proposed. Four key problems are then discussed -- the data schema of data mart, the construction of data reserve center, data programming and data extraction. The marine fisheries data warehouse is constructed by using SQL Server. |
| Keywords: | Marine fisheries data warehouse data mart data schema data extraction |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ | |