회의록 20210805

2021. 08. 04. 데이터 구축 현황

• 데이터 업로드: temp01Data, temp01Links
• 전체 노드: 1,665건
• 전체 링크: 1,494건

Node Report

전체 노드

• 노드: 1,665건

select * from temp01Data

class 별 노드 건수

• Class 별 노드 건수

class	건수
Actor	307
Architecture	66
Clothing	169
Concept	34
Event	127
Heritage	4
Multimedia	59
Object	80
Place	170
Record	484
Story	165

select class, count(*) from temp01Data
group by class order by class

편찬자 별 노드 건수

• 편찬자 별 노드 건수

편찬자	건수
김은숙	145
김지영	99
김혁	131
김현승	251
린지	85
박려정	31
박수정	120
박지윤	108
박현정	199
이순구	50
이재열	114
이한나	242
임민혁	78

select b.item as 편찬자, count(b.item) as 건수
from temp01Data a
cross apply fn_split(note,',') b
group by b.item
order by b.item

Link Report

전체 링크

• 링크: 1,494건

select * from temp01Links

Relation 별 링크 건수

• Relation 별 링크 건수

relation	건수
administrates	4
applies	3
author	31
calligrapher	4
commemorates	1
compiles	24
contributor	1
creator	4
currentLocation	6
dealWith	11
depicts	27
documents	62
formerLocation	1
goesWith	18
happenedAt	17
hasCousin	1
hasDaughter	1
hasOtherName	7
hasPart	300
hasPhoto	1
hasSiteIn	1
hasSon	4
hasWife	4
illustrator	5
includes	1
isAuthorOf	1
isConjugal	1
isDepictedIn	3
isDesignatedAs	4
isDonatedTo	1
isExhibitedAt	11
isHeldIn	1
isMemberOf	1
isNear	16
isPartOf	69
isPreviousInSequence	25
isPublishedBy	29
isRelatedTo	297
isShownBy	286
isVictimOf	3
isWornAt	25
isYoungerBrother	2
mentions	93
owns	4
participatesIn	21
possess	28
sameAs	8
socializesWith	4
tiedUp	1
translator	1
wasDesignated	1
wasExhibited	1
wasSerialized	1
wears	10
writer	4
writesComment	3

select distinct relation, count(*) as 건수
from temp01Links
group by relation order by relation

편찬자 별 링크 건수

• 편찬자 별 링크 건수

편찬자	건수
김은숙	184
김현승	363
린지	76
박려정	37
박현정	437
이재열	161
이한나	236

select b.item as 편찬자, count(b.item) as 건수
from temp01Links a
cross apply fn_split(note,',') b
group by b.item
order by b.item