"회의록 20210805"의 두 판 사이의 차이

hanyang2
이동: 둘러보기, 검색
10번째 줄: 10번째 줄:
 
</syntaxhighlight>
 
</syntaxhighlight>
  
−
*Class별 노드 건수
+
*Class 별 노드 건수
 
{| class="wikitable sortable" style="background-color:white;"
 
{| class="wikitable sortable" style="background-color:white;"
 
! class !! 건수
 
! class !! 건수
77번째 줄: 77번째 줄:
 
group by b.item
 
group by b.item
 
order by b.item
 
order by b.item
 +
</syntaxhighlight>
 +
 +
 +
 +
===Link Report===
 +
*링크: 1,494건
 +
<syntaxhighlight lang="SQL">
 +
select * from temp01Links
 +
</syntaxhighlight>
 +
 +
*Relation 별 링크 건수
 +
{| class="wikitable sortable"
 +
! 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
 +
|}
 +
<syntaxhighlight lang="SQL">
 +
select distinct relation, count(*) as 건수
 +
from temp01Links
 +
group by relation
 +
order by relation
 
</syntaxhighlight>
 
</syntaxhighlight>

2021년 8월 4일 (수) 21:11 판

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

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

Node Report

  • 노드: 1,665건
select * from temp01Data
  • 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 건수
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
원본 주소 "http://dh.aks.ac.kr/hanyang2/wiki/index.php?title=회의록_20210805&oldid=2454"