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

hanyang2
이동: 둘러보기, 검색
(→‎Contextual Relations)
51번째 줄: 51번째 줄:
  
 
  select * from hanyangLinks ..... '''46,466'''
 
  select * from hanyangLinks ..... '''46,466'''
 +
 +
select distinct relation, count(*) from hanyangLinks
 +
  group by relation
 +
  order by relation
  
 
{|class="wikitable" style="text-align:left"
 
{|class="wikitable" style="text-align:left"
 
! style="width:200px" | 관계 ||  style="width:100px" | 건수  
 
! style="width:200px" | 관계 ||  style="width:100px" | 건수  
 
|-
 
|-
−
| annotator || 6
+
| administrates || 4
 
|-
 
|-
−
| calligrapher || 512
+
| annotator || 8
 
|-
 
|-
−
| commemorates || 2
+
| appearsIn || 179
 
|-
 
|-
−
| contributor || 24
+
| calligrapher || 548
 
|-
 
|-
−
| creator || 155
+
| commemorates || 4
 
|-
 
|-
−
| depicts || 87
+
| constructor || 89
 
|-
 
|-
−
| hasAdoptedHeir || 5
+
| contributor || 25
 
|-
 
|-
−
| hasAffiliation || 5
+
| creator || 212
 
|-
 
|-
−
| hasAppointee || 652
+
| currentLocation || 5
 
|-
 
|-
−
| hasBrother || 37
+
| depicts || 199
 
|-
 
|-
−
| hasDaughter || 364
+
| documents || 7
 
|-
 
|-
−
| hasDescendant || 86
+
| formerLocation || 2
 
|-
 
|-
−
| hasDisciple || 186
+
| goesWith || 68
 
|-
 
|-
−
| hasPart || 263
+
| happenedAt || 17
 
|-
 
|-
−
| hasSon || 487
+
| hasAdoptedHeir || 5
 
|-
 
|-
−
| hasSonInLaw || 13
+
| hasAffiliation || 7
 
|-
 
|-
−
| hasWife || 328
+
| hasAppointee || 654
 
|-
 
|-
−
| inscriber || 7
+
| hasBrother || 36
 
|-
 
|-
−
| isAffinalKinOf || 20
+
| hasDaughter || 364
 
|-
 
|-
−
| isEnshrinedIn || 834
+
| hasDescendant || 85
 
|-
 
|-
−
| isEpitaphOf || 556
+
| hasDisciple || 187
 
|-
 
|-
−
| isFellowOf || 1
+
| hasDrawing || 456
 
|-
 
|-
−
| isLineageKinOf || 17
+
| hasEvent || 2
 
|-
 
|-
−
| isMentionedIn || 24
+
| hasMember || 207
 
|-
 
|-
−
| isOfficialPositionOf || 2749
+
| hasPart || 1393
 
|-
 
|-
−
| isSameAs || 2
+
| hasParticipant || 33
 
|-
 
|-
−
| isShownBy || 429
+
| hasPerformance || 48
 
|-
 
|-
−
| isSteleOf || 1
+
| hasSon || 490
 
|-
 
|-
−
| isTombOf || 84
+
| hasSonInLaw || 15
 
|-
 
|-
−
| knows || 82
+
| hasWife || 338
 
|-
 
|-
−
| participatesIn || 42
+
| includes || 88
 
|-
 
|-
−
| publisher || 21
+
| inscriber || 21
 
|-
 
|-
−
| servedAs || 22555
+
| isAffinalKinOf || 20
 
|-
 
|-
−
| translator || 9
+
| isCalligrapherOf || 1
 
|-
 
|-
−
| wasPosthumouslyPromotedTo || 190
+
| isDepictedIn || 2
 +
|-
 +
| isDerivativeOf || 1
 +
|-
 +
| isDocumentedIn || 4
 +
|-
 +
| isEnshrinedIn || 834
 +
|-
 +
| isEpitaphOf || 556
 +
|-
 +
| isFellowOf || 1
 +
|-
 +
| isLineageKinOf || 17
 +
|-
 +
| isMemberOf || 33
 +
|-
 +
| isMentionedIn || 59
 +
|-
 +
| isNear || 229
 +
|-
 +
| isOfficialPositionOf || 2750
 +
|-
 +
| isPartOf || 441
 +
|-
 +
| isPerformedAt || 49
 +
|-
 +
| isPerformedBy || 20
 +
|-
 +
| isPreviousInSequence || 27
 +
|-
 +
| isRelatedTo || 1224
 +
|-
 +
| isSameAs || 4
 +
|-
 +
| isShownBy || 982
 +
|-
 +
| isSteleOf || 1
 +
|-
 +
| isStoredIn || 28
 +
|-
 +
| isTombOf || 84
 +
|-
 +
| isUsedIn || 295
 +
|-
 +
| knows || 82
 +
|-
 +
| mentions || 107
 +
|-
 +
| mightBeRelatedTo || 1
 +
|-
 +
| participatesIn || 359
 +
|-
 +
| plays || 95
 +
|-
 +
| publisher || 29
 +
|-
 +
| sameAs || 6
 +
|-
 +
| servedAs || 22556
 +
|-
 +
| translator || 9
 +
|-
 +
| type || 10
 +
|-
 +
| wasPosthumouslyPromotedTo || 189
 +
|-
 +
| wears || 28
 +
|-
 +
| writer || 870
 +
|-
 +
| onlineReference || 8660
 
|-
 
|-
−
| writer || 869
 
 
|}
 
|}
  

2020년 12월 7일 (월) 10:03 판

기준일시: 2020. 12. 07. 09:00

Node Description

  • 23,206 개 지식 노드 작성
use hanyang2
select * from hanyangData ..... 23,206
  • Class 별 노드 건수
select class, count(*) from hanyangData 
group by class order by class
class 범주 건수
Actor 인물 6256
Architecture 건물 773
Clothing 복식 104
Concept 개념 2963
Event 사건 86
Food 음식 41
Object 물품 476
Place 장소 872
Record 기록물 2349
WebResource 웹 자원 인덱스 8,659

Attribute

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

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


Contextual Relations

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

select distinct relation, count(*) from hanyangLinks
  group by relation
  order by relation
관계 건수
administrates 4
annotator 8
appearsIn 179
calligrapher 548
commemorates 4
constructor 89
contributor 25
creator 212
currentLocation 5
depicts 199
documents 7
formerLocation 2
goesWith 68
happenedAt 17
hasAdoptedHeir 5
hasAffiliation 7
hasAppointee 654
hasBrother 36
hasDaughter 364
hasDescendant 85
hasDisciple 187
hasDrawing 456
hasEvent 2
hasMember 207
hasPart 1393
hasParticipant 33
hasPerformance 48
hasSon 490
hasSonInLaw 15
hasWife 338
includes 88
inscriber 21
isAffinalKinOf 20
isCalligrapherOf 1
isDepictedIn 2
isDerivativeOf 1
isDocumentedIn 4
isEnshrinedIn 834
isEpitaphOf 556
isFellowOf 1
isLineageKinOf 17
isMemberOf 33
isMentionedIn 59
isNear 229
isOfficialPositionOf 2750
isPartOf 441
isPerformedAt 49
isPerformedBy 20
isPreviousInSequence 27
isRelatedTo 1224
isSameAs 4
isShownBy 982
isSteleOf 1
isStoredIn 28
isTombOf 84
isUsedIn 295
knows 82
mentions 107
mightBeRelatedTo 1
participatesIn 359
plays 95
publisher 29
sameAs 6
servedAs 22556
translator 9
type 10
wasPosthumouslyPromotedTo 189
wears 28
writer 870
onlineReference 8660

Reference

  • 8,659 개 노드와 관련이 있는 19,529 건의 웹 자원 조사, 수집, 정리
select distinct source from hanyangRefLinks .....  8,659

select * from hanyangRefData where class='WebResource' ..... 19,529

select groupName, count(*) from hanyangRefData
group by class, groupName having class='WebResource'
order by groupName desc
class 유형 건수
WebResource 해설 9478
WebResource 원문 1078
WebResource 사진 8544
WebResource 3D_지도 429
원본 주소 "http://dh.aks.ac.kr/hanyang2/wiki/index.php?title=아카이브_구축_현황&oldid=79"