"아카이브 구축 현황"의 두 판 사이의 차이

hanyang
이동: 둘러보기, 검색
(→‎Node Description)
65번째 줄: 65번째 줄:
 
! style="width:200px" | 관계 ||  style="width:100px" | 건수  
 
! style="width:200px" | 관계 ||  style="width:100px" | 건수  
 
|-
 
|-
−
| administrates || 17
+
| administrates || style="text-align:right" |  17
 
|-
 
|-
−
| annotator || 8
+
| annotator || style="text-align:right" |  8
 
|-
 
|-
−
| appearsIn || 179
+
| appearsIn || style="text-align:right" |  179
 
|-
 
|-
−
| calligrapher || 549
+
| calligrapher || style="text-align:right" |  549
 
|-
 
|-
−
| commemorates || 15
+
| commemorates || style="text-align:right" |  15
 
|-
 
|-
−
| constructor || 85
+
| constructor || style="text-align:right" |  85
 
|-
 
|-
−
| contributor || 280
+
| contributor || style="text-align:right" |  280
 
|-
 
|-
−
| creator || 244
+
| creator || style="text-align:right" |  244
 
|-
 
|-
−
| currentLocation || 155
+
| currentLocation || style="text-align:right" |  155
 
|-
 
|-
−
| depicts || 344
+
| depicts || style="text-align:right" |  344
 
|-
 
|-
−
| documents || 41
+
| documents || style="text-align:right" |  41
 
|-
 
|-
−
| formerLocation || 7
+
| formerLocation || style="text-align:right" |  7
 
|-
 
|-
−
| goesWith || 191
+
| goesWith || style="text-align:right" |  191
 
|-
 
|-
−
| happenedAt || 17
+
| happenedAt || style="text-align:right" |  17
 
|-
 
|-
−
| hasAdoptedHeir || 5
+
| hasAdoptedHeir || style="text-align:right" |  5
 
|-
 
|-
−
| hasAffiliation || 8
+
| hasAffiliation || style="text-align:right" |  8
 
|-
 
|-
−
| hasAppointee || 654
+
| hasAppointee || style="text-align:right" |  654
 
|-
 
|-
−
| hasBrother || 54
+
| hasBrother || style="text-align:right" |  54
 
|-
 
|-
−
| hasConcubine || 71
+
| hasConcubine || style="text-align:right" |  71
 
|-
 
|-
−
| hasDaughter || 423
+
| hasDaughter || style="text-align:right" |  423
 
|-
 
|-
−
| hasDaughterInLaw || 13
+
| hasDaughterInLaw || style="text-align:right" |  13
 
|-
 
|-
−
| hasDescendant || 86
+
| hasDescendant || style="text-align:right" |  86
 
|-
 
|-
−
| hasDisciple || 186
+
| hasDisciple || style="text-align:right" |  186
 
|-
 
|-
−
| hasDrawing || 86
+
| hasDrawing || style="text-align:right" |  86
 
|-
 
|-
−
| hasEnglishExplanation || 147
+
| hasEnglishExplanation || style="text-align:right" |  147
 
|-
 
|-
−
| hasGrandDaughter || 1
+
| hasGrandDaughter || style="text-align:right" |  1
 
|-
 
|-
−
| hasGrandson || 6
+
| hasGrandson || style="text-align:right" |  6
 
|-
 
|-
−
| hasPart || 2833
+
| hasPart || style="text-align:right" |  2833
 
|-
 
|-
−
| hasParticipant || 32
+
| hasParticipant || style="text-align:right" |  32
 
|-
 
|-
−
| hasPerformance || 48
+
| hasPerformance || style="text-align:right" |  48
 
|-
 
|-
−
| hasPhoto || 136
+
| hasPhoto || style="text-align:right" |  136
 
|-
 
|-
−
| hasReferenceNote || 653
+
| hasReferenceNote || style="text-align:right" |  653
 
|-
 
|-
−
| hasSister || 6
+
| hasSister || style="text-align:right" |  6
 
|-
 
|-
−
| hasSisterInLaw || 3
+
| hasSisterInLaw || style="text-align:right" |  3
 
|-
 
|-
−
| hasSiteIn || 2
+
| hasSiteIn || style="text-align:right" |  2
 
|-
 
|-
−
| hasSon || 542
+
| hasSon || style="text-align:right" |  542
 
|-
 
|-
−
| hasSonInLaw || 20
+
| hasSonInLaw || style="text-align:right" |  20
 
|-
 
|-
−
| hasSubject || 1
+
| hasSubject || style="text-align:right" |  1
 
|-
 
|-
−
| hasText || 6
+
| hasText || style="text-align:right" |  6
 
|-
 
|-
−
| hasVersion || 2
+
| hasVersion || style="text-align:right" |  2
 
|-
 
|-
−
| hasWife || 277
+
| hasWife || style="text-align:right" |  277
 
|-
 
|-
−
| includes || 1141
+
| includes || style="text-align:right" |  1141
 
|-
 
|-
−
| inscriber || 21
+
| inscriber || style="text-align:right" |  21
 
|-
 
|-
−
| isAffinalKinOf || 19
+
| isAffinalKinOf || style="text-align:right" |  19
 
|-
 
|-
−
| isDeliveryPlaceOf || 1
+
| isDeliveryPlaceOf || style="text-align:right" |  1
 
|-
 
|-
−
| isDepictedIn || 6
+
| isDepictedIn || style="text-align:right" |  6
 
|-
 
|-
−
| isDerivativeOf || 4
+
| isDerivativeOf || style="text-align:right" |  4
 
|-
 
|-
−
| isDesignatedAs || 13
+
| isDesignatedAs || style="text-align:right" |  13
 
|-
 
|-
−
| isEnshrinedIn || 834
+
| isEnshrinedIn || style="text-align:right" |  834
 
|-
 
|-
−
| isEpitaphOf || 556
+
| isEpitaphOf || style="text-align:right" |  556
 
|-
 
|-
−
| isFellowOf || 1
+
| isFellowOf || style="text-align:right" |  1
 
|-
 
|-
−
| isLineageKinOf || 18
+
| isLineageKinOf || style="text-align:right" |  18
 
|-
 
|-
−
| isMadeOf || 1
+
| isMadeOf || style="text-align:right" |  1
 
|-
 
|-
−
| isMemberOf || 33
+
| isMemberOf || style="text-align:right" |  33
 
|-
 
|-
−
| isMentionedIn || 56
+
| isMentionedIn || style="text-align:right" |  56
 
|-
 
|-
−
| isNear || 189
+
| isNear || style="text-align:right" |  189
 
|-
 
|-
−
| isNewNameOf || 1
+
| isNewNameOf || style="text-align:right" |  1
 
|-
 
|-
−
| isOfficialPositionOf || 911
+
| isOfficialPositionOf || style="text-align:right" |  911
 
|-
 
|-
−
| isPartOf || 274
+
| isPartOf || style="text-align:right" |  274
 
|-
 
|-
−
| isPerformedAt || 56
+
| isPerformedAt || style="text-align:right" |  56
 
|-
 
|-
−
| isPerformedBy || 22
+
| isPerformedBy || style="text-align:right" |  22
 
|-
 
|-
−
| isPreviousInSequence || 38
+
| isPreviousInSequence || style="text-align:right" |  38
 
|-
 
|-
−
| isProducedIn || 1
+
| isProducedIn || style="text-align:right" |  1
 
|-
 
|-
−
| isRelatedIn || 7
+
| isRelatedIn || style="text-align:right" |  7
 
|-
 
|-
−
| isRelatedTo || 2813
+
| isRelatedTo || style="text-align:right" |  2813
 
|-
 
|-
−
| isSameAs || 126
+
| isSameAs || style="text-align:right" |  126
 
|-
 
|-
−
| isShowBy || 427
+
| isShowBy || style="text-align:right" |  427
 
|-
 
|-
−
| isShownBy || 1407
+
| isShownBy || style="text-align:right" |  1407
 
|-
 
|-
−
| isSiteOf || 21
+
| isSiteOf || style="text-align:right" |  21
 
|-
 
|-
−
| isSteleOf || 1
+
| isSteleOf || style="text-align:right" |  1
 
|-
 
|-
−
| isStoredIn || 29
+
| isStoredIn || style="text-align:right" |  29
 
|-
 
|-
−
| isTombOf || 85
+
| isTombOf || style="text-align:right" |  85
 
|-
 
|-
−
| isUsedIn || 470
+
| isUsedIn || style="text-align:right" |  470
 
|-
 
|-
−
| isWornAt || 37
+
| isWornAt || style="text-align:right" |  37
 
|-
 
|-
−
| knows || 81
+
| knows || style="text-align:right" |  81
 
|-
 
|-
−
| mentions || 1024
+
| mentions || style="text-align:right" |  1024
 
|-
 
|-
−
| mightBeRelatedTo || 1
+
| mightBeRelatedTo || style="text-align:right" |  1
 
|-
 
|-
−
| onlineReference || 10021
+
| onlineReference || style="text-align:right" |  10021
 
|-
 
|-
−
| participatesIn || 342
+
| participatesIn || style="text-align:right" |  342
 
|-
 
|-
−
| plays || 95
+
| plays || style="text-align:right" |  95
 
|-
 
|-
−
| Publisher || 39
+
| Publisher || style="text-align:right" |  39
 
|-
 
|-
−
| references || 49
+
| references || style="text-align:right" |  49
 
|-
 
|-
−
| servedAs || 64712
+
| servedAs || style="text-align:right" |  64712
 
|-
 
|-
−
| translator || 9
+
| translator || style="text-align:right" |  9
 
|-
 
|-
−
| type || 390
+
| type || style="text-align:right" |  390
 
|-
 
|-
−
| wasPosthumouslyPromotedTo || 296
+
| wasPosthumouslyPromotedTo || style="text-align:right" |  296
 
|-
 
|-
−
| wears || 121
+
| wears || style="text-align:right" |  121
 
|-
 
|-
−
| writer || 870
+
| writer || style="text-align:right" |  870
 
|-
 
|-
 
|}
 
|}
258번째 줄: 258번째 줄:
 
! style="width:100px" | class || style="width:100px" | 유형 || style="width:100px" | 건수
 
! style="width:100px" | class || style="width:100px" | 유형 || style="width:100px" | 건수
 
|-
 
|-
−
| 해설 || 12114
+
| 해설 || style="text-align:right" |  12,114
 
|-
 
|-
−
| 참고 || 2137
+
| 참고 || style="text-align:right" |  2,137
 
|-
 
|-
−
| 원문 || 1400
+
| 원문 || style="text-align:right" |  1,400
 
|-
 
|-
−
| 사진 || 8954
+
| 사진 || style="text-align:right" |  8,954
 
|-
 
|-
−
| 동영상 || 22
+
| 동영상 || style="text-align:right" |  22
 
|-
 
|-
−
| 그림 || 35
+
| 그림 || style="text-align:right" |  35
 
|-
 
|-
−
| 도면 || 6
+
| 도면 || style="text-align:right" |  6
 
|-
 
|-
−
| 3D_지도 || 429
+
| 3D_지도 || style="text-align:right" |  429
 
|}
 
|}
  
 
[[분류:한양도성타임머신]] [[분류:프로젝트_관리]]
 
[[분류:한양도성타임머신]] [[분류:프로젝트_관리]]

2021년 3월 4일 (목) 02:07 판

기준일시: 2021. 3. 04. 00:00

Node Description

  • 33,314 개 지식 노드 작성
use hanyang
select * from hanyangData ..... 33,314
  • Class 별 노드 건수
select class, count(*) from hanyangData 
group by class order by class
class 범주 건수
Actor 인물 7,042
Architecture 건물 816
Clothing 복식 541
Concept 개념 7,960
Event 사건 358
Food 음식 213
Heritage 국가지정문화재 14
Multimedia 멀티미디어 어셋 1,835
Object 물품 1252
Place 장소 1013
Record 기록물 2103
Translation 영문 해설 146
WebResource 웹 자원 인덱스 10,021

Attribute

  • 6,906 개 노드에 대해 54,898 건의 속성 정보 작성, 수집, 정리
select distinct id from hanyangAttribute .....  6,906

select * from hanyangAttribute ..... 54,898


Contextual Relations

  • 지식 노드 상호간의 의미적 연관관계 47,086건을 조사 작성
select * from hanyangLinks ..... 96,102

select distinct relation, count(*) from hanyangLinks
  group by relation
  order by relation
관계 건수
administrates 17
annotator 8
appearsIn 179
calligrapher 549
commemorates 15
constructor 85
contributor 280
creator 244
currentLocation 155
depicts 344
documents 41
formerLocation 7
goesWith 191
happenedAt 17
hasAdoptedHeir 5
hasAffiliation 8
hasAppointee 654
hasBrother 54
hasConcubine 71
hasDaughter 423
hasDaughterInLaw 13
hasDescendant 86
hasDisciple 186
hasDrawing 86
hasEnglishExplanation 147
hasGrandDaughter 1
hasGrandson 6
hasPart 2833
hasParticipant 32
hasPerformance 48
hasPhoto 136
hasReferenceNote 653
hasSister 6
hasSisterInLaw 3
hasSiteIn 2
hasSon 542
hasSonInLaw 20
hasSubject 1
hasText 6
hasVersion 2
hasWife 277
includes 1141
inscriber 21
isAffinalKinOf 19
isDeliveryPlaceOf 1
isDepictedIn 6
isDerivativeOf 4
isDesignatedAs 13
isEnshrinedIn 834
isEpitaphOf 556
isFellowOf 1
isLineageKinOf 18
isMadeOf 1
isMemberOf 33
isMentionedIn 56
isNear 189
isNewNameOf 1
isOfficialPositionOf 911
isPartOf 274
isPerformedAt 56
isPerformedBy 22
isPreviousInSequence 38
isProducedIn 1
isRelatedIn 7
isRelatedTo 2813
isSameAs 126
isShowBy 427
isShownBy 1407
isSiteOf 21
isSteleOf 1
isStoredIn 29
isTombOf 85
isUsedIn 470
isWornAt 37
knows 81
mentions 1024
mightBeRelatedTo 1
onlineReference 10021
participatesIn 342
plays 95
Publisher 39
references 49
servedAs 64712
translator 9
type 390
wasPosthumouslyPromotedTo 296
wears 121
writer 870

Reference

  • 시맨틱 데이터 가운데 10,021 개 노드와 관련이 있는 25,097 건의 웹 자원 조사, 수집, 정리
 select * from hanyangRefData where class='SemanticData' ..... 10,021

 select * from hanyangRefData where class='WebResource'  ..... 25,097

select groupName, count(*) from hanyangRefData
group by class, groupName having class='WebResource'
order by groupName desc
class 유형 건수
해설 12,114
참고 2,137
원문 1,400
사진 8,954
동영상 22
그림 35
도면 6
3D_지도 429
원본 주소 "http://dh.aks.ac.kr/hanyang/wiki/index.php?title=아카이브_구축_현황&oldid=39741"