"회의록 20210805"의 두 판 사이의 차이
| 229번째 줄: | 229번째 줄: | ||
<syntaxhighlight lang="SQL"> | <syntaxhighlight lang="SQL"> | ||
select b.item as 편찬자, count(b.item) as 건수 | select b.item as 편찬자, count(b.item) as 건수 | ||
| − | from | + | from temp01Links a |
cross apply fn_split(note,',') b | cross apply fn_split(note,',') b | ||
group by b.item | group by b.item | ||
order by b.item | order by b.item | ||
</syntaxhighlight> | </syntaxhighlight> | ||
2021년 8월 4일 (수) 21:16 판
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
- 편찬자 별 링크 건수
| 편찬자 | 건수 |
|---|---|
| 김은숙 | 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
