"논문준비"의 두 판 사이의 차이
(→OWL) |
(→Related Ontology) |
||
| 2번째 줄: | 2번째 줄: | ||
===[[OWL-Time]]=== | ===[[OWL-Time]]=== | ||
===[[OWL-ref]]=== | ===[[OWL-ref]]=== | ||
| + | ==sql== | ||
| + | use hiblue | ||
| + | |||
| + | select top 10 * from dynasty | ||
| + | select top 10* from emporor | ||
| + | |||
| + | select e.emperor_id, e.name as emperorName, d.dynasty_id, d.name as dynastyName, e.short_name_eng from dynasty d , emporor e where e.dynasty_id=d.dynasty_id | ||
| + | select top 10 * from t_month | ||
| + | select top 10 * from t_era | ||
| + | select top 10 * from t_era_names | ||
| + | |||
| + | select * from era | ||
| + | select era_id, name as eraName, emperor_id, language_id into era from t_era , t_era_names where t_era.id=t_era_names.era_id | ||
| + | select e.emperor_id, e.name as emperorName, d.dynasty_id, d.name as dynastyName, era_id, eraname, language_id, e.short_name_eng from dynasty d , emporor e, era where e.dynasty_id=d.dynasty_id and e.emperor_id=era.emperor_id | ||
| + | |||
| + | select distinct e.emperor_id, d.dynasty_id, era_id into yearLink from dynasty d , emporor e, era where e.dynasty_id=d.dynasty_id and e.emperor_id=era.emperor_id | ||
| + | |||
| + | |||
| + | select * from yearLink | ||
| + | |||
| + | use hiblue | ||
| + | |||
| + | |||
| + | select * from t_month | ||
| + | select * from 번역연호 | ||
| + | select distinct 나라_한글, 나라_한자, 지역 into k_dynasty from 번역연호 | ||
| + | select distinct 묘호_한글, 묘호_한자, 시호_한글, 시호_한자, 휘이름 into k_emperor from 번역연호 | ||
| + | select distinct 서기, 단기, 간지 into k_year from 번역연호 | ||
| + | select distinct 서기, 나라_한글, 휘이름 into k_yearLink from 번역연호 | ||
2018년 7월 9일 (월) 16:10 판
Related Ontology
OWL-Time
OWL-ref
sql
use hiblue
select top 10 * from dynasty select top 10* from emporor
select e.emperor_id, e.name as emperorName, d.dynasty_id, d.name as dynastyName, e.short_name_eng from dynasty d , emporor e where e.dynasty_id=d.dynasty_id select top 10 * from t_month select top 10 * from t_era select top 10 * from t_era_names
select * from era select era_id, name as eraName, emperor_id, language_id into era from t_era , t_era_names where t_era.id=t_era_names.era_id select e.emperor_id, e.name as emperorName, d.dynasty_id, d.name as dynastyName, era_id, eraname, language_id, e.short_name_eng from dynasty d , emporor e, era where e.dynasty_id=d.dynasty_id and e.emperor_id=era.emperor_id
select distinct e.emperor_id, d.dynasty_id, era_id into yearLink from dynasty d , emporor e, era where e.dynasty_id=d.dynasty_id and e.emperor_id=era.emperor_id
select * from yearLink
use hiblue
select * from t_month
select * from 번역연호
select distinct 나라_한글, 나라_한자, 지역 into k_dynasty from 번역연호
select distinct 묘호_한글, 묘호_한자, 시호_한글, 시호_한자, 휘이름 into k_emperor from 번역연호
select distinct 서기, 단기, 간지 into k_year from 번역연호
select distinct 서기, 나라_한글, 휘이름 into k_yearLink from 번역연호
