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

2021년 6월 22일 (화) 05:42 판

use hanyang2
select * from hanyangData ..... 23,833

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 ..... 47,086

select distinct relation, count(*) from hanyangLinks
  group by relation
  order by relation

관계	건수
administrates	4
annotator	8
appearsIn	179
calligrapher	548
commemorates	4
constructor	89
contributor	25
creator	212
currentLocation	5
depicts	199
documents	7
formerLocation	2
goesWith	68
happenedAt	17
hasAdoptedHeir	5
hasAffiliation	7
hasAppointee	654
hasBrother	36
hasDaughter	364
hasDescendant	85
hasDisciple	187
hasDrawing	456
hasEvent	2
hasMember	207
hasPart	1,393
hasParticipant	33
hasPerformance	48
hasSon	490
hasSonInLaw	15
hasWife	338
includes	88
inscriber	21
isAffinalKinOf	20
isCalligrapherOf	1
isDepictedIn	2
isDerivativeOf	1
isDocumentedIn	4
isEnshrinedIn	834
isEpitaphOf	556
isFellowOf	1
isLineageKinOf	17
isMemberOf	33
isMentionedIn	59
isNear	229
isOfficialPositionOf	2,750
isPartOf	441
isPerformedAt	49
isPerformedBy	20
isPreviousInSequence	27
isRelatedTo	1,224
isSameAs	4
isShownBy	982
isSteleOf	1
isStoredIn	28
isTombOf	84
isUsedIn	295
knows	82
mentions	107
mightBeRelatedTo	1
participatesIn	359
plays	95
publisher	29
sameAs	6
servedAs	22,556
translator	9
type	10
wasPosthumouslyPromotedTo	189
wears	28
writer	870
onlineReference	9,287

 select * from hanyangRefData where class='SemanticData' ..... 9,287

 select * from hanyangRefData where class='WebResource'  ..... 21,198

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