Integrated Curation Data Model: Factual Data

Database Schema

Node Tabel Schema: xxxData

create table concertData (
	id nvarchar(40) not null,
	class nvarchar(16) null,
	groupName nvarchar(16) null,
	partName nvarchar(40) null,
	label nvarchar(80) null,
	infoUrl nvarchar(256) null,
	iconUrl nvarchar(256) null,
	primary key(id)
)

Edge Table Schema: xxxLinks

create table concertLinks (
	source  nvarchar(40)  not null,
	target  nvarchar(40) not null,
	relation nvarchar(40) not null,
	attribute nvarchar(40) null,
	primary key (source, target, relation )
)

SQL Script

Insert Node Data

insert into xxxData (id, class, groupName, partName, label, infoUrl, iconUrl )
select id, class, groupName, partName, label, infoUrl, iconUrl  
	from xxxData$

Insert Link Data

insert into xxxLinks (source, target, relation)
select source, target, relation from xxxLinks$

Data Service Tools

Story01.py

• URL: http://dh.aks.ac.kr/cgi-bin/encyves/Story01.py
• 매개 변수: db = Database Name, project = Data Table Prefix, key = Factual Data Node Identifier
• 기능: Core Node를 중심으로 하는 1 Hop 네트워크 그래프 반환
• 예시: http://dh.aks.ac.kr/cgi-bin/encyves/Story01.py?db=common&project=concert&key=Handel

Story02.py

• URL: http://dh.aks.ac.kr/cgi-bin/encyves/Story02.py
• 매개 변수: db = Database Name, project = Data Table Prefix, key = Factual Data Node Identifier
• 기능: Core Node를 중심으로 하는 2 Hop 네트워크 그래프 반환
• 예시: http://dh.aks.ac.kr/cgi-bin/encyves/Story02.py?db=common&project=concert&key=Handel

Query.py

• URL: http://dh.aks.ac.kr/cgi-bin/encyves/Query.py
• 매개 변수: db = Database Name, project = Data Table Prefix, key = String
• 기능: 주어진 문자열을 포함하는 데이터의 노드 리스트 반환
• 예시: http://dh.aks.ac.kr/cgi-bin/encyves/Query.py?db=common&project=concert&key=Paganini