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

2020년 10월 12일 (월) 08:44 판

use hanyang2
select * from hanyangData ..... 11,693

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 ..... 31,704

관계	건수
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

@@ 29번째 줄: / 29번째 줄: @@
 |-
 | WebResource || 3D 지도 || 429
-|}}
+|}
 ==Attribute==