"대문"의 두 판 사이의 차이
스토리 데이터베이스
(문서 내용을 "==시뮬레이션 기반 스토리 데이터베이스 설계=="으로 바꿈) |
(→(3) 서사구조정보) |
||
(사용자 2명의 중간 판 22개는 보이지 않습니다) | |||
1번째 줄: | 1번째 줄: | ||
==시뮬레이션 기반 스토리 데이터베이스 설계== | ==시뮬레이션 기반 스토리 데이터베이스 설계== | ||
+ | === 1. 설화 스토리데이터베이스의 구조=== | ||
+ | ==== 1) 설화 스토리 데이터베이스의 개체관계도==== | ||
+ | [[파일:설화 스토리 데이터베이스의 개체관계도.png|1500픽셀|center|섬네일|설화 스토리 데이터베이스의 개체관계도]] | ||
+ | |||
+ | ==== 2) 설화 스토리 데이터베이스의 XML 모델링 ==== | ||
+ | ===== (1) 설화,문장,사건,행위 ===== | ||
+ | [[파일:설화 스토리 설화_문장_사건_행위.png|2500픽셀|center|섬네일|설화_문장_사건_행위 XML 스키마 그래프]] | ||
+ | |||
+ | <?xml version="1.0" encoding="utf-8"?> | ||
+ | <xs:schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> | ||
+ | <xs:element name="설화자료"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="설화"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="설화명" type="xs:string" /> | ||
+ | <xs:element name="문장들"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element maxOccurs="unbounded" name="문장"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="문장내용" type="xs:string" /> | ||
+ | <xs:element name="사건들"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element maxOccurs="unbounded" name="사건"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="사건내용" type="xs:string" /> | ||
+ | <xs:element name="행위들"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element maxOccurs="unbounded" name="행위"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="조작주체" type="xs:string" /> | ||
+ | <xs:element name="접합" type="xs:string" /> | ||
+ | <xs:element name="접합종류" type="xs:string" /> | ||
+ | <xs:element name="접합종류상세" type="xs:string" /> | ||
+ | <xs:element name="상태주체" type="xs:string" /> | ||
+ | <xs:element name="대상" type="xs:string" /> | ||
+ | </xs:sequence> | ||
+ | <xs:attribute name="행위번호" type="xs:unsignedLong" use="required" /> | ||
+ | <xs:attribute name="시상" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="시도" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="양태변형" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="사실진위" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="의도진위" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="부사" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="강도" type="xs:string" use="required" /> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | <xs:attribute name="사건번호" type="xs:unsignedInt" use="required" /> | ||
+ | <xs:attribute name="주어" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="동사" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="대상1" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="대상2" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="사건성격" type="xs:string" use="required" /> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | <xs:attribute name="문장번호" type="xs:string" use="required" /> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | <xs:attribute name="설화번호" type="xs:unsignedInt" use="required" /> | ||
+ | <xs:attribute name="중심명제" type="xs:unsignedLong" use="required" /> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:schema> | ||
+ | |||
+ | ===== (2) 사건관계 ===== | ||
+ | [[파일:사건관계스키마.png|2500픽셀|center|섬네일|사건관계 XML 스키마 그래프]] | ||
+ | <?xml version="1.0" encoding="utf-8"?> | ||
+ | <xs:schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> | ||
+ | <xs:element name="사건관계자료"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="사건관계들"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:choice maxOccurs="unbounded"> | ||
+ | <xs:element name="사건관계"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="사건"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="사건내용" type="xs:string" /> | ||
+ | </xs:sequence> | ||
+ | <xs:attribute name="사건번호" type="xs:unsignedInt" use="required" /> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | <xs:element name="관계" type="xs:string" /> | ||
+ | <xs:element name="대상사건"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="대상사건내용" type="xs:string" /> | ||
+ | </xs:sequence> | ||
+ | <xs:attribute name="대상사건번호" type="xs:unsignedInt" use="required" /> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | <xs:attribute name="관계연번" type="xs:unsignedByte" use="required" /> | ||
+ | <xs:attribute name="사건관계번호" type="xs:string" use="required" /> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | <xs:element name="사건들" /> | ||
+ | </xs:choice> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:schema> | ||
+ | |||
+ | ===== (3) 서사구조정보 ===== | ||
+ | [[파일:서사구조정보.png|2500픽셀|center|섬네일|서사구조정보 XML 스키마 그래프]] | ||
+ | <?xml version="1.0" encoding="utf-8"?> | ||
+ | <xs:schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> | ||
+ | <xs:element name="서사구조정보자료"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="서사구조정보"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="사건들"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element maxOccurs="unbounded" name="사건"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="사건내용" type="xs:string" /> | ||
+ | <xs:element name="양상들"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element maxOccurs="unbounded" name="양상정보"> | ||
+ | <xs:complexType> | ||
+ | <xs:sequence> | ||
+ | <xs:element name="행위주" type="xs:string" /> | ||
+ | <xs:element name="양상" type="xs:string" /> | ||
+ | <xs:element name="조종자" type="xs:string" /> | ||
+ | </xs:sequence> | ||
+ | <xs:attribute name="구조연번" type="xs:unsignedByte" use="required" /> | ||
+ | <xs:attribute name="변경여부" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="실제여부" type="xs:string" use="required" /> | ||
+ | <xs:attribute name="진위" type="xs:string" use="required" /> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | <xs:attribute name="사건번호" type="xs:unsignedInt" use="required" /> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:sequence> | ||
+ | </xs:complexType> | ||
+ | </xs:element> | ||
+ | </xs:schema> | ||
+ | |||
+ | ==== 2) 설화 스토리 데이터베이스의 RDB 모델링 ==== | ||
+ | [[파일:스토리 데이터베이스 테이블 관계도.png|900픽셀|center|섬네일|스토리 데이터베이스 테이블 관계도]] | ||
+ | |||
+ | ==2. 설화별 데이터 == | ||
+ | {|class="wikitable sortable" style = "width:100%;background:white;" | ||
+ | !style = "width:10%" | 설화번호 || 설화명 | ||
+ | |- | ||
+ | | 1130101 ||[[이성계와 산신]] | ||
+ | |- | ||
+ | | 1130102 ||[[ 이성계와 지리산 산신]] | ||
+ | |- | ||
+ | | 1130103 ||[[ 이성계와 우투리]] | ||
+ | |- | ||
+ | | 1130104 ||[[ 이성계의 꿈풀이]] | ||
+ | |- | ||
+ | | 2130210 ||[[ 신거무 장터 유래]] | ||
+ | |- | ||
+ | | 2130708 ||[[ 고창녕과 미인]] | ||
+ | |- | ||
+ | | 2130711 ||[[ 문수보살과 임금]] | ||
+ | |- | ||
+ | | 4150101 ||[[ 주인을 위해 죽은 개]] | ||
+ | |- | ||
+ | | 4150102 ||[[ 주인을 위해 사냥감을 물어다 주는 개]] | ||
+ | |- | ||
+ | | 4150103 ||[[ 묏자리를 찾아 준 개]] | ||
+ | |- | ||
+ | | 4150104 ||[[ 아들을 찾아 준 개]] | ||
+ | |- | ||
+ | | 4150301 ||[[ 두꺼비와 지네의 대결1]] | ||
+ | |- | ||
+ | | 4150302 ||[[ 잉어와 두꺼비의 보은]] | ||
+ | |- | ||
+ | | 4150303 ||[[ 두꺼비와 지네의 대결2]] | ||
+ | |- | ||
+ | | 4150304 ||[[ 두꺼비와 지네의 대결3]] | ||
+ | |- | ||
+ | | 4150305 ||[[ 못에서 지네와 싸운 두꺼비]] | ||
+ | |- | ||
+ | |4150306 || [[원님과 처녀를 구한 두꺼비]] | ||
+ | |- | ||
+ | | 4150307 || [[구렁이를 물리친 두꺼비]] | ||
+ | |- | ||
+ | | 4150308 || [[원님과 딸을 구한 두꺼비]] | ||
+ | |- | ||
+ | | 4150401 || [[전장에서 돌아온 말]] | ||
+ | |- | ||
+ | | 4150402 || [[은혜갚은 물고기]] | ||
+ | |- | ||
+ | | 4150403 || [[아이를 찾은 개]] | ||
+ | |- | ||
+ | | 4150404 || [[부부를 구한 쥐]] | ||
+ | |- | ||
+ | | 4150405 || [[지네와 싸운 쥐]] | ||
+ | |- | ||
+ | | 4150406 || [[은혜 갚은 새]] | ||
+ | |- | ||
+ | | 4150407 || [[은혜 갚은 뱀]] | ||
+ | |- | ||
+ | | 4150408 || [[귀신과 싸운 개]] | ||
+ | |- | ||
+ | | 4150409 || [[도둑과 싸우는 주인을 도운 개]] | ||
+ | |- | ||
+ | | 4150605 || [[의도치 않은 선행과 구렁이의 보은1]] | ||
+ | |- | ||
+ | | 4150803 || [[호랑이의 보은]] | ||
+ | |||
+ | |} |
2017년 11월 5일 (일) 23:31 기준 최신판
목차
시뮬레이션 기반 스토리 데이터베이스 설계
1. 설화 스토리데이터베이스의 구조
1) 설화 스토리 데이터베이스의 개체관계도
2) 설화 스토리 데이터베이스의 XML 모델링
(1) 설화,문장,사건,행위
<?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="설화자료"> <xs:complexType> <xs:sequence> <xs:element name="설화"> <xs:complexType> <xs:sequence> <xs:element name="설화명" type="xs:string" /> <xs:element name="문장들"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="문장"> <xs:complexType> <xs:sequence> <xs:element name="문장내용" type="xs:string" /> <xs:element name="사건들"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="사건"> <xs:complexType> <xs:sequence> <xs:element name="사건내용" type="xs:string" /> <xs:element name="행위들"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="행위"> <xs:complexType> <xs:sequence> <xs:element name="조작주체" type="xs:string" /> <xs:element name="접합" type="xs:string" /> <xs:element name="접합종류" type="xs:string" /> <xs:element name="접합종류상세" type="xs:string" /> <xs:element name="상태주체" type="xs:string" /> <xs:element name="대상" type="xs:string" /> </xs:sequence> <xs:attribute name="행위번호" type="xs:unsignedLong" use="required" /> <xs:attribute name="시상" type="xs:string" use="required" /> <xs:attribute name="시도" type="xs:string" use="required" /> <xs:attribute name="양태변형" type="xs:string" use="required" /> <xs:attribute name="사실진위" type="xs:string" use="required" /> <xs:attribute name="의도진위" type="xs:string" use="required" /> <xs:attribute name="부사" type="xs:string" use="required" /> <xs:attribute name="강도" type="xs:string" use="required" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="사건번호" type="xs:unsignedInt" use="required" /> <xs:attribute name="주어" type="xs:string" use="required" /> <xs:attribute name="동사" type="xs:string" use="required" /> <xs:attribute name="대상1" type="xs:string" use="required" /> <xs:attribute name="대상2" type="xs:string" use="required" /> <xs:attribute name="사건성격" type="xs:string" use="required" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="문장번호" type="xs:string" use="required" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="설화번호" type="xs:unsignedInt" use="required" /> <xs:attribute name="중심명제" type="xs:unsignedLong" use="required" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element>
</xs:schema>
(2) 사건관계
<?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="사건관계자료"> <xs:complexType> <xs:sequence> <xs:element name="사건관계들"> <xs:complexType> <xs:sequence> <xs:choice maxOccurs="unbounded"> <xs:element name="사건관계"> <xs:complexType> <xs:sequence> <xs:element name="사건"> <xs:complexType> <xs:sequence> <xs:element name="사건내용" type="xs:string" /> </xs:sequence> <xs:attribute name="사건번호" type="xs:unsignedInt" use="required" /> </xs:complexType> </xs:element> <xs:element name="관계" type="xs:string" /> <xs:element name="대상사건"> <xs:complexType> <xs:sequence> <xs:element name="대상사건내용" type="xs:string" /> </xs:sequence> <xs:attribute name="대상사건번호" type="xs:unsignedInt" use="required" /> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="관계연번" type="xs:unsignedByte" use="required" /> <xs:attribute name="사건관계번호" type="xs:string" use="required" /> </xs:complexType> </xs:element> <xs:element name="사건들" /> </xs:choice> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element>
</xs:schema>
(3) 서사구조정보
<?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="서사구조정보자료"> <xs:complexType> <xs:sequence> <xs:element name="서사구조정보"> <xs:complexType> <xs:sequence> <xs:element name="사건들"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="사건"> <xs:complexType> <xs:sequence> <xs:element name="사건내용" type="xs:string" /> <xs:element name="양상들"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="양상정보"> <xs:complexType> <xs:sequence> <xs:element name="행위주" type="xs:string" /> <xs:element name="양상" type="xs:string" /> <xs:element name="조종자" type="xs:string" /> </xs:sequence> <xs:attribute name="구조연번" type="xs:unsignedByte" use="required" /> <xs:attribute name="변경여부" type="xs:string" use="required" /> <xs:attribute name="실제여부" type="xs:string" use="required" /> <xs:attribute name="진위" type="xs:string" use="required" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="사건번호" type="xs:unsignedInt" use="required" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element>
</xs:schema>
2) 설화 스토리 데이터베이스의 RDB 모델링
2. 설화별 데이터
설화번호 | 설화명 |
---|---|
1130101 | 이성계와 산신 |
1130102 | 이성계와 지리산 산신 |
1130103 | 이성계와 우투리 |
1130104 | 이성계의 꿈풀이 |
2130210 | 신거무 장터 유래 |
2130708 | 고창녕과 미인 |
2130711 | 문수보살과 임금 |
4150101 | 주인을 위해 죽은 개 |
4150102 | 주인을 위해 사냥감을 물어다 주는 개 |
4150103 | 묏자리를 찾아 준 개 |
4150104 | 아들을 찾아 준 개 |
4150301 | 두꺼비와 지네의 대결1 |
4150302 | 잉어와 두꺼비의 보은 |
4150303 | 두꺼비와 지네의 대결2 |
4150304 | 두꺼비와 지네의 대결3 |
4150305 | 못에서 지네와 싸운 두꺼비 |
4150306 | 원님과 처녀를 구한 두꺼비 |
4150307 | 구렁이를 물리친 두꺼비 |
4150308 | 원님과 딸을 구한 두꺼비 |
4150401 | 전장에서 돌아온 말 |
4150402 | 은혜갚은 물고기 |
4150403 | 아이를 찾은 개 |
4150404 | 부부를 구한 쥐 |
4150405 | 지네와 싸운 쥐 |
4150406 | 은혜 갚은 새 |
4150407 | 은혜 갚은 뱀 |
4150408 | 귀신과 싸운 개 |
4150409 | 도둑과 싸우는 주인을 도운 개 |
4150605 | 의도치 않은 선행과 구렁이의 보은1 |
4150803 | 호랑이의 보은 |