"아카이브 구축 현황"의 두 판 사이의 차이

2020년 11월 10일 (화) 14:18 판

use hanyang2
select * from hanyangData ..... 20,834

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

select distinct id from hanyangAttribute .....  6,906

select * from hanyangAttribute ..... 54,898

select * from hanyangLinks ..... 41,270

관계	건수
annotator	6
calligrapher	512
commemorates	2
contributor	24
creator	155
depicts	87
hasAdoptedHeir	5
hasAffiliation	5
hasAppointee	652
hasBrother	37
hasDaughter	364
hasDescendant	86
hasDisciple	186
hasPart	263
hasSon	487
hasSonInLaw	13
hasWife	328
inscriber	7
isAffinalKinOf	20
isEnshrinedIn	834
isEpitaphOf	556
isFellowOf	1
isLineageKinOf	17
isMentionedIn	24
isOfficialPositionOf	2749
isSameAs	2
isShownBy	429
isSteleOf	1
isTombOf	84
knows	82
participatesIn	42
publisher	21
servedAs	22555
translator	9
wasPosthumouslyPromotedTo	190
writer	869

select distinct source from hanyangRefLinks .....  8,659

select * from hanyangRefData where class='WebResource' ..... 19,529

select groupName, count(*) from hanyangRefData
group by class, groupName having class='WebResource'
order by groupName desc

@@ 46번째 줄: / 46번째 줄: @@
 ==Contextual Relations==
-* 지식 노드 상호간의 의미적 연관관계 31,704건을 조사 작성
+* 지식 노드 상호간의 의미적 연관관계 41,270건을 조사 작성
-  select * from hanyangLinks ..... '''31,704'''
+  select * from hanyangLinks ..... '''41,270'''
 {|class="wikitable" style="text-align:left"