2023海洋地質數(shù)據(jù)庫內容與結構

海洋地質數(shù)據(jù)庫內容與結構1

范圍...............................................................................................................................................

12

規(guī)范性引用文件...........................................................................................................................13

術語和定義...................................................................................................................................14

符號、代號和縮略語...................................................................................................................24.1

縮略語...................................................................................................................................24.2

構造型代號....................................................................................................................24.3

實體關系圖符號...................................................................................................................25

命名、編碼和編號.......................................................................................................................35.1

數(shù)據(jù)庫及其對象命名.....................................................................................................35.2

域代碼編碼......................................................................................................................45.3

數(shù)據(jù)組織單元編號..........................................................................................................

46

數(shù)據(jù)庫內容...................................................................................................................................66.1

建庫數(shù)據(jù)........................................................................................................................66.2

元數(shù)據(jù)...........................................................................................................................

67

數(shù)據(jù)庫結構...................................................................................................................................77.1

數(shù)據(jù)組織單元................................................................................................................

77.2

數(shù)據(jù)存儲框架................................................................................................................

77.3

空間子庫框架................................................................................................................

77.4

實體關系圖....................................................................................................................77.5

數(shù)據(jù)字典......................................................................................................................177.6

代碼表.........................................................................................................................

177.7

數(shù)據(jù)結構擴充..............................................................................................................

178

數(shù)據(jù)質量控制.............................................................................................................................18附錄A...............................................................................................................................................

19A.1

說明.............................................................................................................................

19A.2

核心元數(shù)據(jù)內容..........................................................................................................

19附錄B...............................................................................................................................................

28B.1

說明.............................................................................................................................

28B.2

數(shù)據(jù)信息層數(shù)據(jù)實體關系圖.......................................................................................

29B.3

數(shù)據(jù)資源層數(shù)據(jù)集數(shù)據(jù)實體關系圖............................................................................29B.4

數(shù)據(jù)資源層專題數(shù)據(jù)實體關系圖...............................................................................

29附錄C...............................................................................................................................................

67C.1

說明.............................................................................................................................

67C.2

數(shù)據(jù)信息層數(shù)據(jù)實體數(shù)據(jù)字典...................................................................................

67C.3

數(shù)據(jù)信息層實測位置要素類數(shù)據(jù)字典........................................................................70C.4

項目過程管理文檔數(shù)據(jù)實體數(shù)據(jù)字典........................................................................73C.5

成果報告數(shù)據(jù)實體數(shù)據(jù)字典.......................................................................................

74C.6

成果圖件數(shù)據(jù)實體數(shù)據(jù)字典.......................................................................................

76C.7

調查數(shù)據(jù)實體數(shù)據(jù)字典...............................................................................................78C.8

分析數(shù)據(jù)實體數(shù)據(jù)字典...............................................................................................80C.9

單波束測深數(shù)據(jù)實體數(shù)據(jù)字典...................................................................................

82C.10

多波束測深數(shù)據(jù)實體數(shù)據(jù)字典.................................................................................

86I目次IIC.11

C.12

C.13

C.14

C.15

C.16

C.17

C.18

C.19

C.20

C.21

C.22

C.23

C.24

C.25

C.26

C.27

C.28

C.29

C.30

C.31

C.32

C.33

C.34

C.35

C.36

C.37

C.38側掃聲納測量數(shù)據(jù)實體數(shù)據(jù)字典..............................................................................91淺地層剖面測量數(shù)據(jù)實體數(shù)據(jù)字典..........................................................................95單道地震測量數(shù)據(jù)實體數(shù)據(jù)字典..............................................................................99多道地震測量數(shù)據(jù)實體數(shù)據(jù)字典............................................................................103海洋重力測量數(shù)據(jù)實體數(shù)據(jù)字典............................................................................109海洋磁力測量數(shù)據(jù)實體數(shù)據(jù)字典............................................................................113海底熱流測量數(shù)據(jù)實體數(shù)據(jù)字典............................................................................117底質取樣數(shù)據(jù)實體數(shù)據(jù)字典...................................................................................

120底質樣品編錄與取樣數(shù)據(jù)實體數(shù)據(jù)字典................................................................

126鉆孔取樣數(shù)據(jù)實體數(shù)據(jù)字典...................................................................................

128鉆孔樣品編錄與取樣數(shù)據(jù)實體數(shù)據(jù)字典................................................................

132底質樣品分析數(shù)據(jù)實體數(shù)據(jù)字典............................................................................135鉆孔樣品分析數(shù)據(jù)實體數(shù)據(jù)字典............................................................................138沉積物涂片鑒定數(shù)據(jù)實體數(shù)據(jù)字典........................................................................141沉積物粒度分析數(shù)據(jù)實體數(shù)據(jù)字典........................................................................143礦物分析鑒定數(shù)據(jù)實體數(shù)據(jù)字典............................................................................150微體古生物鑒定數(shù)據(jù)實體數(shù)據(jù)字典........................................................................154化學成分分析數(shù)據(jù)實體數(shù)據(jù)字典............................................................................158測年數(shù)據(jù)實體數(shù)據(jù)字典...........................................................................................163古地磁測試數(shù)據(jù)實體數(shù)據(jù)字典...............................................................................

168沉積物物理力學性質試驗數(shù)據(jù)實體數(shù)據(jù)字典........................................................

170海流測量數(shù)據(jù)實體數(shù)據(jù)字典...................................................................................

174溫鹽深測量數(shù)據(jù)實體數(shù)據(jù)字典...............................................................................

181懸浮體樣品分析數(shù)據(jù)實體數(shù)據(jù)字典........................................................................187海水取樣數(shù)據(jù)實體數(shù)據(jù)字典...................................................................................

192環(huán)境地球化學分析數(shù)據(jù)實體數(shù)據(jù)字典....................................................................196水環(huán)境化學要素分析數(shù)據(jù)實體數(shù)據(jù)字典................................................................

198沉積環(huán)境化學要素分析數(shù)據(jù)實體數(shù)據(jù)字典............................................................

200附錄D.............................................................................................................................................206

D.1

數(shù)據(jù)信息層屬性域代碼表.........................................................................................206D.2

數(shù)據(jù)資源層屬性域代碼表.........................................................................................210參考文獻.........................................................................................................................................

214圖

1

實體關系圖符號.....................................................................................................................3圖

2

數(shù)據(jù)總實體關系圖.................................................................................................................8圖

B.1

實體圖示方式...................................................................................................................28圖

B.2

數(shù)據(jù)信息層數(shù)據(jù)實體關系圖..........................................................................................

30圖

B.3

數(shù)據(jù)信息層實測位置要素實體關系圖..........................................................................

31圖

B.4

項目過程管理文檔數(shù)據(jù)實體關系圖..............................................................................

32圖

B.5

成果報告數(shù)據(jù)集數(shù)據(jù)實體關系圖..................................................................................

33圖

B.6

成果圖件數(shù)據(jù)集數(shù)據(jù)實體關系圖..................................................................................

34圖

B.7

調查數(shù)據(jù)集數(shù)據(jù)實體關系圖..........................................................................................

35圖

B.8

分析數(shù)據(jù)集數(shù)據(jù)實體關系圖..........................................................................................

36圖

B.9

單波束測深數(shù)據(jù)實體關系圖..........................................................................................

37圖

B.10

多波束測深數(shù)據(jù)實體關系圖........................................................................................

38圖

B.11

側掃聲納測量數(shù)據(jù)實體關系圖....................................................................................

39圖

B.12

淺地層剖面測量數(shù)據(jù)實體關系圖................................................................................40圖

B.13

單道地震測量數(shù)據(jù)實體關系圖....................................................................................

41圖

B.14

多道地震測量數(shù)據(jù)實體關系圖....................................................................................

42圖

B.15圖

B.16圖

B.17圖

B.18圖

B.19圖

B.20圖

B.21圖

B.22圖

B.23圖

B.24圖

B.25圖

B.26圖

B.27圖

B.28圖

B.29圖

B.30圖

B.31圖

B.32圖

B.33圖

B.34圖

B.35圖

B.36圖

B.37圖

B.38海洋重力測量數(shù)據(jù)實體關系圖....................................................................................

43海洋磁力測量數(shù)據(jù)實體關系圖....................................................................................

44海底熱流測量數(shù)據(jù)實體關系圖....................................................................................

45底質取樣數(shù)據(jù)實體關系圖............................................................................................46底質樣品編錄與取樣數(shù)據(jù)實體關系圖........................................................................

47鉆孔取樣數(shù)據(jù)實體關系圖............................................................................................48鉆孔樣品編錄與取樣數(shù)據(jù)實體關系圖........................................................................

49底質樣品分析數(shù)據(jù)實體關系圖....................................................................................

50鉆孔樣品分析數(shù)據(jù)實體關系圖....................................................................................

51沉積物涂片鑒定數(shù)據(jù)實體關系圖................................................................................

52沉積物粒度分析數(shù)據(jù)實體關系圖................................................................................

53礦物分析鑒定數(shù)據(jù)實體關系圖....................................................................................

54微體古生物鑒定數(shù)據(jù)實體關系圖................................................................................

55化學成分分析數(shù)據(jù)實體關系圖....................................................................................

56測年數(shù)據(jù)實體關系圖.....................................................................................................57古地磁數(shù)據(jù)實體關系圖.................................................................................................58沉積物物理力學性質試驗數(shù)據(jù)實體關系圖................................................................

59海流測量數(shù)據(jù)實體關系圖............................................................................................60溫鹽深測量數(shù)據(jù)實體關系圖........................................................................................

61懸浮體樣品分析數(shù)據(jù)實體關系圖................................................................................

62海水取樣數(shù)據(jù)實體關系圖............................................................................................63環(huán)境地球化學數(shù)據(jù)實體關系圖....................................................................................

64水環(huán)境化學要素分析數(shù)據(jù)實體關系圖........................................................................

65沉積環(huán)境化學要素分析數(shù)據(jù)實體關系圖....................................................................

66表

1

數(shù)據(jù)庫模式對象命名格式.....................................................................................................3表

2

建庫數(shù)據(jù)來源.........................................................................................................................6表

3

數(shù)據(jù)信息層數(shù)據(jù)實體.............................................................................................................9表

4

數(shù)據(jù)資源層數(shù)據(jù)集數(shù)據(jù)實體.................................................................................................9表

5

地形地貌調查數(shù)據(jù)實體.........................................................................................................9表

6

地球物理調查數(shù)據(jù)實體.......................................................................................................11表

7

海洋底質調查數(shù)據(jù)實體.......................................................................................................13表

8

沉積動力調查數(shù)據(jù)實體.......................................................................................................15表

9

環(huán)境地球化學調查數(shù)據(jù)實體...............................................................................................16表

A.1表

A.2表

A.3表

A.4表

C.1表

C.2表

C.3表

C.4表

C.5表

C.6表

C.7表

C.8表

C.9成果報告數(shù)據(jù)集元數(shù)據(jù)表...............................................................................................19成果圖件數(shù)據(jù)集元數(shù)據(jù)表...............................................................................................21調查數(shù)據(jù)集元數(shù)據(jù)表.......................................................................................................23分析數(shù)據(jù)集元數(shù)據(jù)表.......................................................................................................25數(shù)據(jù)字典表頭說明...........................................................................................................67數(shù)據(jù)信息層數(shù)據(jù)實體數(shù)據(jù)字典表..................................................................................

67數(shù)據(jù)信息層實測位置要素類數(shù)據(jù)字典表......................................................................

70項目過程管理文檔數(shù)據(jù)實體數(shù)據(jù)字典表......................................................................

73成果報告數(shù)據(jù)實體數(shù)據(jù)字典表......................................................................................

74成果圖件數(shù)據(jù)實體數(shù)據(jù)字典表......................................................................................

76調查數(shù)據(jù)實體數(shù)據(jù)字典表...............................................................................................78分析數(shù)據(jù)實體數(shù)據(jù)字典表...............................................................................................80單波束測深數(shù)據(jù)實體數(shù)據(jù)字典表..................................................................................

82表

C.10

多波束測深數(shù)據(jù)實體數(shù)據(jù)字典表................................................................................86表

C.11

側掃聲納測量數(shù)據(jù)實體數(shù)據(jù)字典表............................................................................

91表

C.12

淺地層剖面測量數(shù)據(jù)實體數(shù)據(jù)字典表........................................................................

95表

C.13

單道地震測量數(shù)據(jù)實體數(shù)據(jù)字典表............................................................................

99IIIIV表

C.14表

C.15表

C.16表

C.17表

C.18表

C.19表

C.20表

C.21表

C.22表

C.23表

C.24表

C.25表

C.26表

C.27表

C.28表

C.29表

C.30表

C.31表

C.32表

C.33表

C.34表

C.35表

C.36表

C.37表

C.38表D.1表D.2表D.3表D.4表D.5表D.6表D.7表D.8表D.9表

D.10表

D.11表

D.12表

D.13表

D.14表

D.15表

D.16表

D.17表

D.18多道地震測量數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................................

103海洋重力測量數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................................

109海洋磁力測量數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................................

113海底熱流測量數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................................

117底質取樣數(shù)據(jù)實體數(shù)據(jù)字典表..................................................................................

120底質樣品編錄與取樣數(shù)據(jù)實體數(shù)據(jù)字典表..............................................................

126鉆孔取樣數(shù)據(jù)實體數(shù)據(jù)字典表..................................................................................

128鉆孔樣品編錄與取樣數(shù)據(jù)實體數(shù)據(jù)字典表..............................................................

132底質樣品分析數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................................

135鉆孔樣品分析數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................................

138沉積物涂片鑒定數(shù)據(jù)實體數(shù)據(jù)字典表......................................................................

141沉積物粒度分析數(shù)據(jù)實體數(shù)據(jù)字典表......................................................................

143礦物分析鑒定數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................................

150微體古生物鑒定數(shù)據(jù)實體數(shù)據(jù)字典表......................................................................

154化學成分分析數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................................

158測年數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................................................

163古地磁測試數(shù)據(jù)實體數(shù)據(jù)字典表..............................................................................

168沉積物物理力學性質試驗數(shù)據(jù)實體數(shù)據(jù)字典表......................................................

170海流測量數(shù)據(jù)實體數(shù)據(jù)字典表..................................................................................

174溫鹽深測量數(shù)據(jù)實體數(shù)據(jù)字典表..............................................................................

181懸浮體樣品分析數(shù)據(jù)實體數(shù)據(jù)字典表......................................................................

187海水取樣數(shù)據(jù)實體數(shù)據(jù)字典表..................................................................................

192環(huán)境地球化學分析數(shù)據(jù)實體數(shù)據(jù)字典表..................................................................

196水環(huán)境化學要素分析數(shù)據(jù)實體數(shù)據(jù)字典表..............................................................

198沉積環(huán)境化學要素分析數(shù)據(jù)實體數(shù)據(jù)字典表..........................................................

200海域代碼表.....................................................................................................................206地貌單元代碼表.............................................................................................................206調查目的代碼表.............................................................................................................207密級代碼表.....................................................................................................................207機構代碼表.....................................................................................................................208數(shù)據(jù)及類別代碼表.........................................................................................................208元數(shù)據(jù)級別代碼表.........................................................................................................208樣品類型代碼表.............................................................................................................209取樣設備代碼表.............................................................................................................209站型代碼表...................................................................................................................210調查類別代碼表...........................................................................................................210報告類別代碼表...........................................................................................................211專題類型代碼表...........................................................................................................211圖件類別代碼表...........................................................................................................211調查內容代碼表...........................................................................................................212調查數(shù)據(jù)類別代碼表...................................................................................................212分析數(shù)據(jù)類別代碼表...................................................................................................213特殊數(shù)據(jù)編碼代碼表...................................................................................................2131海洋地質數(shù)據(jù)庫內容與結構范圍本文件規(guī)定了海洋地質數(shù)據(jù)庫命名、編碼和編號、數(shù)據(jù)庫內容、數(shù)據(jù)庫結構及數(shù)據(jù)質量控制等要求。本文件適用于海洋地質工作中的海洋區(qū)域地質、海岸帶環(huán)境地質、海洋地球物理、海洋地球化學調查和研究的全過程資料整理、數(shù)據(jù)整編和數(shù)據(jù)庫建設。規(guī)范性引用文件下列文件中的內容通過文中的規(guī)范性引用而構成本文件必不可少的條款。其中，注日期的引用文件，僅該日期對應的版本適用于該文件；不注日期的引用文件，其最新版本（包括所有的修改單）適用于本文件。GB/T

18391.1—2009

信息技術

元數(shù)據(jù)注冊系統(tǒng)（MDR）

第1部分：框架GB/T

19710—2005地理信息元數(shù)據(jù)DZ/T

0268—2014數(shù)字地質數(shù)據(jù)質量檢查與評價DZ/T

0274—2015地質數(shù)據(jù)庫建設規(guī)范的結構與編寫DZ/T

0301—2017海洋地質圖圖例圖式及用色標準DD

2006—05

地質信息元數(shù)據(jù)標準DD

2014—02海洋區(qū)域地質圖數(shù)據(jù)庫建設規(guī)范術語和定義下列術語和定義適用于本文件。3.1數(shù)據(jù)集

dataset采用相同數(shù)據(jù)產品規(guī)范的相關數(shù)據(jù)的可標識集合。[來源：GB/T19710—2005，4.2，有修改]3.2數(shù)據(jù)包

package歸屬同一項目的若干數(shù)據(jù)集的可標識集合。[來源：DD

2014—02，3.3]3.3數(shù)據(jù)實體

data

entity概念數(shù)據(jù)模型的數(shù)據(jù)庫存儲對象，包括非空間數(shù)據(jù)實體和空間數(shù)據(jù)實體。非空間數(shù)據(jù)實體以屬性表定義，空間數(shù)據(jù)實體以幾何類型為點、線、面的要素類定義，實體之間可相互關聯(lián)。[來源：DZ/T

0274—2015，3.1.3，有修改]3.4屬性

attribute描述數(shù)據(jù)實體特征的數(shù)據(jù)項。2[來源：DD

2014—02，3.4]3.5屬性域

domain屬性的有效值集合，屬性數(shù)據(jù)項的數(shù)據(jù)類型、取值范圍（有效規(guī)則、有效值列表、非空等）以及數(shù)據(jù)格式都屬于屬性域的定義范疇。3.6代碼值域

coded

value

domain按一定原則分類、以一定規(guī)則編碼的屬性有效值集合，體現(xiàn)為枚舉型代碼表《Enumeration》或可擴充代碼表《CodeList》構造型的屬性有效值列表。[來源：DD

2014—02，3.5]3.7數(shù)據(jù)庫模式對象

database

schemaobject屬性的有效值集合，屬性數(shù)據(jù)項的數(shù)據(jù)類型、取值范圍（有效規(guī)則、有效值列表、非空等）以概念層數(shù)據(jù)模型在數(shù)據(jù)庫物理層的描述對象，包括源于實體與屬性映射的表、字段，還包括維護數(shù)據(jù)庫完整性、安全性及運行性能的約束、索引、視圖、存儲過程、觸發(fā)器等。[來源：DD

2014—02，3.6]3.8元數(shù)據(jù)

metadata關于數(shù)據(jù)的數(shù)據(jù)，是描述數(shù)據(jù)的內容、覆蓋范圍、質量、現(xiàn)狀、管理方式、數(shù)據(jù)的所有者、數(shù)據(jù)的提供方式等有關的信息。[來源：DD

2006—05，4.3]3.9核心元數(shù)據(jù)

core

metadata保證數(shù)據(jù)資源能被唯一識別的最基本元數(shù)據(jù)項的集合。[來源：DD2014—02，3.12]符號、代號和縮略語縮略語ERD—EntityRelationshipDiagram

實體關系圖構造型代號本文件使用下列構造型代號：a）

《Enumeration》枚舉型代碼表，不允許擴充的屬性有效值集合；b）

《CodeList》可擴充代碼表，允許擴充的屬性有效值集合。實體關系圖符號本文件使用圖

1

符號表示實體之間聯(lián)系的基數(shù)與可選性。3圖1實體關系圖符號命名、編碼和編號數(shù)據(jù)庫及其對象命名基本規(guī)則數(shù)據(jù)庫及其對象命名的基本規(guī)則如下：a）

只采用英文字母、數(shù)字和下劃線；b）英文字母一律大寫；字符之間不得留有空格；避免使用數(shù)據(jù)庫系統(tǒng)的保留字；e）

保證命名空間內的唯一性。數(shù)據(jù)庫命名數(shù)據(jù)庫以英文名首字母按序組合命名，長度不超過

8

個字符。示例：RMGSD，表示海洋區(qū)域地質調查數(shù)據(jù)庫（Regional

Marine

Geological

Survey

Database）。模式對象命名數(shù)據(jù)庫模式對象以下列方式命名：a）

采用對象英文名或縮寫結合類型標識前綴組合命名，命名格式參考表

1；b）盡可能表達對象的實際意義或業(yè)務作用；c）對象類型標識長度不超過

3

個字符，對象名總長度不超過

30

個字符。表1數(shù)據(jù)庫模式對象命名格式模式對象類型標識格

式示例表（Table）<表名>DATASET字段（Column）<字段名>DATASET_ID視圖（View）VWVW_<視圖功能標識>VW_DATASETLIST存儲過程（Stored

Procedure）PRPR_<存儲過程功能標識>PR_DATASETINS函數(shù)（Function）FNFN_<函數(shù)功能標識>FN_DATASETCOUNT觸發(fā)器（Trigger）TRTR_<表名>_<觸發(fā)標識>TR_DATASET_INS索引（Index）IXIX_<表名>_<字段名或縮寫>IX_DATASET_DATASETNM主鍵（Primary

Key）PKPK_<表名>PK_DATASET唯一鍵（Unique

Key）UKUK_<表名>_<字段名或縮寫>UK_SAREA_AREAID級聯(lián)式外鍵（CascadeForeign

Key）CFKCFK_<表名>_<主表名>CFK_DATASET_PACKAGE實體命名實體屬性表以英文名或縮寫組合命名，單詞或縮寫之間用下劃線連接。調查數(shù)據(jù)實體以“SD_”為前綴命名屬性表，分析