"아카이브 구축 현황"의 두 판 사이의 차이
(→Node Description) |
|||
65번째 줄: | 65번째 줄: | ||
! style="width:200px" | 관계 || style="width:100px" | 건수 | ! style="width:200px" | 관계 || style="width:100px" | 건수 | ||
|- | |- | ||
− | | administrates || 17 | + | | administrates || style="text-align:right" | 17 |
|- | |- | ||
− | | annotator || 8 | + | | annotator || style="text-align:right" | 8 |
|- | |- | ||
− | | appearsIn || 179 | + | | appearsIn || style="text-align:right" | 179 |
|- | |- | ||
− | | calligrapher || 549 | + | | calligrapher || style="text-align:right" | 549 |
|- | |- | ||
− | | commemorates || 15 | + | | commemorates || style="text-align:right" | 15 |
|- | |- | ||
− | | constructor || 85 | + | | constructor || style="text-align:right" | 85 |
|- | |- | ||
− | | contributor || 280 | + | | contributor || style="text-align:right" | 280 |
|- | |- | ||
− | | creator || 244 | + | | creator || style="text-align:right" | 244 |
|- | |- | ||
− | | currentLocation || 155 | + | | currentLocation || style="text-align:right" | 155 |
|- | |- | ||
− | | depicts || 344 | + | | depicts || style="text-align:right" | 344 |
|- | |- | ||
− | | documents || 41 | + | | documents || style="text-align:right" | 41 |
|- | |- | ||
− | | formerLocation || 7 | + | | formerLocation || style="text-align:right" | 7 |
|- | |- | ||
− | | goesWith || 191 | + | | goesWith || style="text-align:right" | 191 |
|- | |- | ||
− | | happenedAt || 17 | + | | happenedAt || style="text-align:right" | 17 |
|- | |- | ||
− | | hasAdoptedHeir || 5 | + | | hasAdoptedHeir || style="text-align:right" | 5 |
|- | |- | ||
− | | hasAffiliation || 8 | + | | hasAffiliation || style="text-align:right" | 8 |
|- | |- | ||
− | | hasAppointee || 654 | + | | hasAppointee || style="text-align:right" | 654 |
|- | |- | ||
− | | hasBrother || 54 | + | | hasBrother || style="text-align:right" | 54 |
|- | |- | ||
− | | hasConcubine || 71 | + | | hasConcubine || style="text-align:right" | 71 |
|- | |- | ||
− | | hasDaughter || 423 | + | | hasDaughter || style="text-align:right" | 423 |
|- | |- | ||
− | | hasDaughterInLaw || 13 | + | | hasDaughterInLaw || style="text-align:right" | 13 |
|- | |- | ||
− | | hasDescendant || 86 | + | | hasDescendant || style="text-align:right" | 86 |
|- | |- | ||
− | | hasDisciple || 186 | + | | hasDisciple || style="text-align:right" | 186 |
|- | |- | ||
− | | hasDrawing || 86 | + | | hasDrawing || style="text-align:right" | 86 |
|- | |- | ||
− | | hasEnglishExplanation || 147 | + | | hasEnglishExplanation || style="text-align:right" | 147 |
|- | |- | ||
− | | hasGrandDaughter || 1 | + | | hasGrandDaughter || style="text-align:right" | 1 |
|- | |- | ||
− | | hasGrandson || 6 | + | | hasGrandson || style="text-align:right" | 6 |
|- | |- | ||
− | | hasPart || 2833 | + | | hasPart || style="text-align:right" | 2833 |
|- | |- | ||
− | | hasParticipant || 32 | + | | hasParticipant || style="text-align:right" | 32 |
|- | |- | ||
− | | hasPerformance || 48 | + | | hasPerformance || style="text-align:right" | 48 |
|- | |- | ||
− | | hasPhoto || 136 | + | | hasPhoto || style="text-align:right" | 136 |
|- | |- | ||
− | | hasReferenceNote || 653 | + | | hasReferenceNote || style="text-align:right" | 653 |
|- | |- | ||
− | | hasSister || 6 | + | | hasSister || style="text-align:right" | 6 |
|- | |- | ||
− | | hasSisterInLaw || 3 | + | | hasSisterInLaw || style="text-align:right" | 3 |
|- | |- | ||
− | | hasSiteIn || 2 | + | | hasSiteIn || style="text-align:right" | 2 |
|- | |- | ||
− | | hasSon || 542 | + | | hasSon || style="text-align:right" | 542 |
|- | |- | ||
− | | hasSonInLaw || 20 | + | | hasSonInLaw || style="text-align:right" | 20 |
|- | |- | ||
− | | hasSubject || 1 | + | | hasSubject || style="text-align:right" | 1 |
|- | |- | ||
− | | hasText || 6 | + | | hasText || style="text-align:right" | 6 |
|- | |- | ||
− | | hasVersion || 2 | + | | hasVersion || style="text-align:right" | 2 |
|- | |- | ||
− | | hasWife || 277 | + | | hasWife || style="text-align:right" | 277 |
|- | |- | ||
− | | includes || 1141 | + | | includes || style="text-align:right" | 1141 |
|- | |- | ||
− | | inscriber || 21 | + | | inscriber || style="text-align:right" | 21 |
|- | |- | ||
− | | isAffinalKinOf || 19 | + | | isAffinalKinOf || style="text-align:right" | 19 |
|- | |- | ||
− | | isDeliveryPlaceOf || 1 | + | | isDeliveryPlaceOf || style="text-align:right" | 1 |
|- | |- | ||
− | | isDepictedIn || 6 | + | | isDepictedIn || style="text-align:right" | 6 |
|- | |- | ||
− | | isDerivativeOf || 4 | + | | isDerivativeOf || style="text-align:right" | 4 |
|- | |- | ||
− | | isDesignatedAs || 13 | + | | isDesignatedAs || style="text-align:right" | 13 |
|- | |- | ||
− | | isEnshrinedIn || 834 | + | | isEnshrinedIn || style="text-align:right" | 834 |
|- | |- | ||
− | | isEpitaphOf || 556 | + | | isEpitaphOf || style="text-align:right" | 556 |
|- | |- | ||
− | | isFellowOf || 1 | + | | isFellowOf || style="text-align:right" | 1 |
|- | |- | ||
− | | isLineageKinOf || 18 | + | | isLineageKinOf || style="text-align:right" | 18 |
|- | |- | ||
− | | isMadeOf || 1 | + | | isMadeOf || style="text-align:right" | 1 |
|- | |- | ||
− | | isMemberOf || 33 | + | | isMemberOf || style="text-align:right" | 33 |
|- | |- | ||
− | | isMentionedIn || 56 | + | | isMentionedIn || style="text-align:right" | 56 |
|- | |- | ||
− | | isNear || 189 | + | | isNear || style="text-align:right" | 189 |
|- | |- | ||
− | | isNewNameOf || 1 | + | | isNewNameOf || style="text-align:right" | 1 |
|- | |- | ||
− | | isOfficialPositionOf || 911 | + | | isOfficialPositionOf || style="text-align:right" | 911 |
|- | |- | ||
− | | isPartOf || 274 | + | | isPartOf || style="text-align:right" | 274 |
|- | |- | ||
− | | isPerformedAt || 56 | + | | isPerformedAt || style="text-align:right" | 56 |
|- | |- | ||
− | | isPerformedBy || 22 | + | | isPerformedBy || style="text-align:right" | 22 |
|- | |- | ||
− | | isPreviousInSequence || 38 | + | | isPreviousInSequence || style="text-align:right" | 38 |
|- | |- | ||
− | | isProducedIn || 1 | + | | isProducedIn || style="text-align:right" | 1 |
|- | |- | ||
− | | isRelatedIn || 7 | + | | isRelatedIn || style="text-align:right" | 7 |
|- | |- | ||
− | | isRelatedTo || 2813 | + | | isRelatedTo || style="text-align:right" | 2813 |
|- | |- | ||
− | | isSameAs || 126 | + | | isSameAs || style="text-align:right" | 126 |
|- | |- | ||
− | | isShowBy || 427 | + | | isShowBy || style="text-align:right" | 427 |
|- | |- | ||
− | | isShownBy || 1407 | + | | isShownBy || style="text-align:right" | 1407 |
|- | |- | ||
− | | isSiteOf || 21 | + | | isSiteOf || style="text-align:right" | 21 |
|- | |- | ||
− | | isSteleOf || 1 | + | | isSteleOf || style="text-align:right" | 1 |
|- | |- | ||
− | | isStoredIn || 29 | + | | isStoredIn || style="text-align:right" | 29 |
|- | |- | ||
− | | isTombOf || 85 | + | | isTombOf || style="text-align:right" | 85 |
|- | |- | ||
− | | isUsedIn || 470 | + | | isUsedIn || style="text-align:right" | 470 |
|- | |- | ||
− | | isWornAt || 37 | + | | isWornAt || style="text-align:right" | 37 |
|- | |- | ||
− | | knows || 81 | + | | knows || style="text-align:right" | 81 |
|- | |- | ||
− | | mentions || 1024 | + | | mentions || style="text-align:right" | 1024 |
|- | |- | ||
− | | mightBeRelatedTo || 1 | + | | mightBeRelatedTo || style="text-align:right" | 1 |
|- | |- | ||
− | | onlineReference || 10021 | + | | onlineReference || style="text-align:right" | 10021 |
|- | |- | ||
− | | participatesIn || 342 | + | | participatesIn || style="text-align:right" | 342 |
|- | |- | ||
− | | plays || 95 | + | | plays || style="text-align:right" | 95 |
|- | |- | ||
− | | Publisher || 39 | + | | Publisher || style="text-align:right" | 39 |
|- | |- | ||
− | | references || 49 | + | | references || style="text-align:right" | 49 |
|- | |- | ||
− | | servedAs || 64712 | + | | servedAs || style="text-align:right" | 64712 |
|- | |- | ||
− | | translator || 9 | + | | translator || style="text-align:right" | 9 |
|- | |- | ||
− | | type || 390 | + | | type || style="text-align:right" | 390 |
|- | |- | ||
− | | wasPosthumouslyPromotedTo || 296 | + | | wasPosthumouslyPromotedTo || style="text-align:right" | 296 |
|- | |- | ||
− | | wears || 121 | + | | wears || style="text-align:right" | 121 |
|- | |- | ||
− | | writer || 870 | + | | writer || style="text-align:right" | 870 |
|- | |- | ||
|} | |} | ||
258번째 줄: | 258번째 줄: | ||
! style="width:100px" | class || style="width:100px" | 유형 || style="width:100px" | 건수 | ! style="width:100px" | class || style="width:100px" | 유형 || style="width:100px" | 건수 | ||
|- | |- | ||
− | | 해설 || | + | | 해설 || style="text-align:right" | 12,114 |
|- | |- | ||
− | | 참고 || | + | | 참고 || style="text-align:right" | 2,137 |
|- | |- | ||
− | | 원문 || | + | | 원문 || style="text-align:right" | 1,400 |
|- | |- | ||
− | | 사진 || | + | | 사진 || style="text-align:right" | 8,954 |
|- | |- | ||
− | | 동영상 || 22 | + | | 동영상 || style="text-align:right" | 22 |
|- | |- | ||
− | | 그림 || 35 | + | | 그림 || style="text-align:right" | 35 |
|- | |- | ||
− | | 도면 || 6 | + | | 도면 || style="text-align:right" | 6 |
|- | |- | ||
− | | 3D_지도 || 429 | + | | 3D_지도 || style="text-align:right" | 429 |
|} | |} | ||
[[분류:한양도성타임머신]] [[분류:프로젝트_관리]] | [[분류:한양도성타임머신]] [[분류:프로젝트_관리]] |
2021년 3월 4일 (목) 02:07 판
기준일시: 2021. 3. 04. 00:00
Node Description
- 33,314 개 지식 노드 작성
use hanyang select * from hanyangData ..... 33,314
- Class 별 노드 건수
select class, count(*) from hanyangData group by class order by class
class | 범주 | 건수 |
---|---|---|
Actor | 인물 | 7,042 |
Architecture | 건물 | 816 |
Clothing | 복식 | 541 |
Concept | 개념 | 7,960 |
Event | 사건 | 358 |
Food | 음식 | 213 |
Heritage | 국가지정문화재 | 14 |
Multimedia | 멀티미디어 어셋 | 1,835 |
Object | 물품 | 1252 |
Place | 장소 | 1013 |
Record | 기록물 | 2103 |
Translation | 영문 해설 | 146 |
WebResource | 웹 자원 인덱스 | 10,021 |
Attribute
- 6,906 개 노드에 대해 54,898 건의 속성 정보 작성, 수집, 정리
select distinct id from hanyangAttribute ..... 6,906
select * from hanyangAttribute ..... 54,898
Contextual Relations
- 지식 노드 상호간의 의미적 연관관계 47,086건을 조사 작성
select * from hanyangLinks ..... 96,102
select distinct relation, count(*) from hanyangLinks group by relation order by relation
관계 | 건수 |
---|---|
administrates | 17 |
annotator | 8 |
appearsIn | 179 |
calligrapher | 549 |
commemorates | 15 |
constructor | 85 |
contributor | 280 |
creator | 244 |
currentLocation | 155 |
depicts | 344 |
documents | 41 |
formerLocation | 7 |
goesWith | 191 |
happenedAt | 17 |
hasAdoptedHeir | 5 |
hasAffiliation | 8 |
hasAppointee | 654 |
hasBrother | 54 |
hasConcubine | 71 |
hasDaughter | 423 |
hasDaughterInLaw | 13 |
hasDescendant | 86 |
hasDisciple | 186 |
hasDrawing | 86 |
hasEnglishExplanation | 147 |
hasGrandDaughter | 1 |
hasGrandson | 6 |
hasPart | 2833 |
hasParticipant | 32 |
hasPerformance | 48 |
hasPhoto | 136 |
hasReferenceNote | 653 |
hasSister | 6 |
hasSisterInLaw | 3 |
hasSiteIn | 2 |
hasSon | 542 |
hasSonInLaw | 20 |
hasSubject | 1 |
hasText | 6 |
hasVersion | 2 |
hasWife | 277 |
includes | 1141 |
inscriber | 21 |
isAffinalKinOf | 19 |
isDeliveryPlaceOf | 1 |
isDepictedIn | 6 |
isDerivativeOf | 4 |
isDesignatedAs | 13 |
isEnshrinedIn | 834 |
isEpitaphOf | 556 |
isFellowOf | 1 |
isLineageKinOf | 18 |
isMadeOf | 1 |
isMemberOf | 33 |
isMentionedIn | 56 |
isNear | 189 |
isNewNameOf | 1 |
isOfficialPositionOf | 911 |
isPartOf | 274 |
isPerformedAt | 56 |
isPerformedBy | 22 |
isPreviousInSequence | 38 |
isProducedIn | 1 |
isRelatedIn | 7 |
isRelatedTo | 2813 |
isSameAs | 126 |
isShowBy | 427 |
isShownBy | 1407 |
isSiteOf | 21 |
isSteleOf | 1 |
isStoredIn | 29 |
isTombOf | 85 |
isUsedIn | 470 |
isWornAt | 37 |
knows | 81 |
mentions | 1024 |
mightBeRelatedTo | 1 |
onlineReference | 10021 |
participatesIn | 342 |
plays | 95 |
Publisher | 39 |
references | 49 |
servedAs | 64712 |
translator | 9 |
type | 390 |
wasPosthumouslyPromotedTo | 296 |
wears | 121 |
writer | 870 |
Reference
- 시맨틱 데이터 가운데 10,021 개 노드와 관련이 있는 25,097 건의 웹 자원 조사, 수집, 정리
select * from hanyangRefData where class='SemanticData' ..... 10,021
select * from hanyangRefData where class='WebResource' ..... 25,097
select groupName, count(*) from hanyangRefData group by class, groupName having class='WebResource' order by groupName desc
class | 유형 | 건수 |
---|---|---|
해설 | 12,114 | |
참고 | 2,137 | |
원문 | 1,400 | |
사진 | 8,954 | |
동영상 | 22 | |
그림 | 35 | |
도면 | 6 | |
3D_지도 | 429 |