「人名權威檔」資料庫欄位建置表

Size: px

Start display at page:

Download "「人名權威檔」資料庫欄位建置表"

迁尔
5 years ago
Views:

1 ( version 0.2) 1

2 Entities - Relationship Model

3 ( ) Int Varchar Text byte byte byte Id Int 20 Name Surname Varchar 20 Forename Varchar 20 Alternate Type Varchar 10 Other Names Varchar 20 reference Title Varchar 100 Volume Varchar 20 Pages Varchar 20 Country Varchar 20 3

4 B&D w. Begin Year Varchar 20 Calendar Month Varchar 20 Day Varchar 20 End Year Varchar 20 Month Varchar 20 Day Varchar 20 ( ) Native place Original Varchar 40 Contemporary Varchar 40 Biography Content Text - Reference Title Varchar 100 Volume Varchar 20 Pages Varchar 20 Education Period Varchar 80 Education Varchar 80 Remarks Varchar 40 Specialty Specialty Varchar 60 Reference Title Varchar 100 Volume Varchar 20 Pages Varchar 20 Title Title Varchar 80 Daterange Varchar 80 Reference Title Varchar 100 Volume Varchar 20 Pages Varchar 20 Works Works Varchar 80 Version Varchar 80 multimedia Path Varchar 40 Electronic name Varchar 20 Type Varchar 10 Relationship Related Persons Varchar 20 Relation Varchar 8 Reference Title Varchar 100 Volume Varchar 20 Pages Varchar 20 URI Varchar 60 Cataloging Cataloger Name Varchar 10 History Cataloging Date Varchar 30 Modifier Name Varchar 10 Modified Date Varchar 30 4

5 [ ] 辞 ( ) 辞 ( 1 ) ( ) ( 1 ) 歴 ( 1 ) ( ) 歴 ( 1 ) ( 1 ) 1 Chicago ( ) ( ) ( 76 ) ( ) 湾湾辞 ( 図 1989 ) ( ) 辞辞 ( ) 総総 ( ) ( 1937 ) ( ) ( ) ( 22 5

6 Chicago 88 6 ) ( ) ( ) ( ( 会 ) ( 会 ) 辞 ( ) 辞 ( 1994 ) 歴歴 ( ) 6.1 MARC 21 Format for Authority Data MARC 21 Format for Authority Data MARC 21 Format for Authority Data - - CDWA Authority- Creator Identification RELATED PEOPLE (1) MARC 21 Format for Authority Data mapping MARC 21 Format for Authority Data 001 CONTROL NUMBER 100 HEADING--PERSONAL NAME $a Personal name 400 SEE FROM TRACING PERSONAL NAME $e Relator term 400 SEE FROM TRACING PERSONAL NAME $a Personal name 670 SOURCE DATA FOUND $a Source citation,, 100 HEADINGPERSONAL NAME $z Geographic subdivision 100 HEADING--PERSONAL NAME $d Dates associated with a name 100 HEADING--PERSONAL NAME $z Geographic subdivision $z ( ) 678 BIOGRAPHICAL OR HISTORICAL DATA $a Biographical or historical data 670 SOURCE DATA FOUND $a Source citation CDWA Authority- Creator Identification 6

7 CDWA Authority- Creator MARC 21 Format for Authority Data Identification,, 100 HEADING--PERSONAL NAME $c titles and other words associated with a name 100 $c,, 100 HEADING--PERSONAL NAME $g Miscellaneous information 670 SOURCE DATA FOUND $a Source citation,, 100 HEADING PERSONAL NAME $c titles and other words associated with a name 100 $c, 670 SOURCE DATA FOUND $a Source citation,, 100 HEADING--PERSON AL NAME $t Title of a work 100 HEADING--PERSON AL NAME $s Version 856 ELECTRONIC LOCATION AND ACCESS $d path 856 ELECTRONIC LOCATION AND ACCESS $f electronic name 856 ELECTRONIC LOCATION AND ACCESS $q electronic format type RELATED PEOPLE- NAME RELATED PEOPLE- RELATIONSHIP TYPE 670 SOURCE DATA FOUND $a Source citation,, 856 ELECTRONIC LOCATION AND ACCESS $u Uniform Resource Identifier 040 CATALOGING SOURCE $a Original cataloging agency 008 FIXED-LENGTH DATA ELEMENTS Date entered on file 040 CATALOGING SOURCE $d Modifying agency 005 DATE AND TIME OF LATEST TRANSACTION 1CDWA Authority- Creator Identification 7

8 6.2 Dublin Core mapping Dublin Core Dublin Core Identifier Title Title-Alternative Title-Alternative Relation-References Coverage-Spatial Coverage-Temporal Coverage-Spatial Description-Abstract Relation-References Description Description Relation-References Description Relation-References Relation Relation Relation Relation Relation Relation Relation Relation-References 8

9 Identifier Contributor Date Contributor Date-Modified Dublin Core I L L A A H D D S S I L A H D S ( 5 ) ( 5 ) ( 5 ) ( 6 ) ( 6 ) 9

10 I L A H D S 6 ) 6 ) 5 - (surname) - (other names) authority access table 6 10

12 Entities-Relationship Model N 1 1 URI ( ) 12

13 E-R model single-value entity multi-valued entity relationship of entities

14 : TH P TH-P

15 5. vs vs vs

16 16

( Version 0.4 ) 1

( Version 0.4 ) 1 3 3.... 3 3 5.... 9 10 12 Entities-Relationship Model. 13 14 15.. 17 2 ( ) version 0.3 Int TextVarchar byte byte byte 3 Id Int 20 Name Surname Varchar 20 Forename Varchar 20 Alternate