Database - 기준일시: 2021. 09. 23. 16:00
Node Description
- 8,108 개 지식 노드 작성 (기초와 2020 노드 제외하면 6,664)
use hanyang2
select * from hanyangData ..... 8,108
select * from hanyangData
where note !='기초' and note !='2020' ..... 6,664
select class, count(*) from hanyangData
group by class order by class
| class |
범주 |
건수
|
| Actor |
인물 |
930
|
| Architecture |
건물 |
112
|
| Clothing |
복식 |
301
|
| Concept |
개념 |
108
|
| Event |
사건 |
280
|
| Food |
음식 |
315
|
| Heritage |
문화유산 |
7
|
| Object |
물품 |
270
|
| Place |
장소 |
570
|
| Record |
기록물 |
1187
|
| Story |
스토리 |
197
|
| Multimedia |
멀티미디어 |
302
|
| WebResource |
웹 자원 |
1387
|
| Bibliography |
|
1127
|
| Ghost |
|
1015
|
Attribute
Contextual Relations
- 지식 노드 상호간의 의미적 연관관계 10,084건을 조사 작성
select * from hanyangLinks ..... 10,084
select distinct relation, count(*) from hanyangLinks
group by relation
order by relation
| 관계 |
건수
|
| administrates |
20
|
| applies |
3
|
| author |
28
|
| beAwarded |
53
|
| bibliographicReference |
1651
|
| calligrapher |
4
|
| commemorates |
1
|
| compiles |
23
|
| constructor |
7
|
| contributor |
22
|
| cooks |
59
|
| creator |
113
|
| currentLocation |
70
|
| dealWith |
43
|
| depicts |
28
|
| documents |
120
|
| formerLocation |
6
|
| founder |
44
|
| goesWith |
39
|
| handOverCopyright |
1
|
| happenedAt |
27
|
| hasAdoptedHeir |
1
|
| hasAffiliation |
194
|
| hasAppointee |
13
|
| hasBrother |
16
|
| hasCousin |
1
|
| hasDaughter |
15
|
| hasDaughterInLaw |
1
|
| hasDrawing |
40
|
| hasForm |
36
|
| hasGrandDaughter |
1
|
| hasGrandson |
5
|
| hasHusband |
2
|
| hasIngredient |
403
|
| hasInscription |
2
|
| hasOtherName |
7
|
| hasPart |
589
|
| hasParticipant |
3
|
| hasPhoto |
1
|
| hasReferenceNode |
127
|
| hasSister |
2
|
| hasSiteIn |
2
|
| hasSon |
64
|
| hasSonInLaw |
1
|
| hasTheme |
1
|
| hasVersion |
5
|
| hasWife |
29
|
| illustrator |
5
|
| includes |
923
|
| isAuthorOf |
1
|
| isConjugal |
1
|
| isDepictedIn |
63
|
| isDerivativeOf |
18
|
| isDesignatedAs |
5
|
| isDonatedTo |
1
|
| isEnshrinedIn |
7
|
| isExhibitedAt |
15
|
| isFellowOf |
10
|
| isGarnishedWith |
1
|
| isHeldIn |
1
|
| isKindOf |
1
|
| isMadeBy |
1
|
| isMemberOf |
93
|
| isMentionedBy |
4
|
| isMentionedIn |
14
|
| isNamedAfter |
1
|
| isNamedBy |
2
|
| isNear |
19
|
| isNewNameOf |
2
|
| isPartOf |
44
|
| isPerformedAt |
3
|
| isPostedIn |
27
|
| isPreviousInSequence |
63
|
| isPublishedBy |
37
|
| isRalatedTo |
5
|
| isRelatedTo |
1793
|
| isSameAs |
39
|
| isServedAs |
3
|
| isServedTo |
3
|
| isShownAt |
1208
|
| isShownBy |
579
|
| isShownIn |
60
|
| isSiteOf |
122
|
| isStoredIn |
1
|
| isSuccessorOf |
1
|
| isTombOf |
26
|
| isUsedIn |
22
|
| isVictimOf |
5
|
| isWornAt |
31
|
| isYoungerBrother |
2
|
| knows |
319
|
| leads |
22
|
| locatedAt |
1
|
| member |
12
|
| mentions |
198
|
| mightBeRelatedTo |
3
|
| onlineReference |
1
|
| owns |
22
|
| participatesIn |
39
|
| possess |
11
|
| prepares |
12
|
| publisher |
25
|
| references |
13
|
| sameAs |
24
|
| servedAs |
70
|
| serves |
62
|
| servesAs |
7
|
| socializesWith |
4
|
| tiedUp |
1
|
| translator |
10
|
| type |
8
|
| wasBuriedIn |
1
|
| wasDesignated |
1
|
| wasExhibited |
1
|
| wasSerialized |
1
|
| wears |
11
|
| writer |
17
|
| writesComment |
3
|
Reference
