스토리 데이터베이스
leeaxe
http://dh.aks.ac.kr/~leeaxe/wiki/index.php/%EB%8C%80%EB%AC%B8
MediaWiki 1.27.3
first-letter
미디어
특수
토론
사용자
사용자토론
스토리 데이터베이스
스토리 데이터베이스토론
파일
파일토론
미디어위키
미디어위키토론
틀
틀토론
도움말
도움말토론
분류
분류토론
소도구
소도구토론
소도구정의
소도구정의토론
대문
0
1
1045
1043
2017-11-05T15:01:10Z
Leeaxe
1
/* (3) 서사구조정보 */
wikitext
text/x-wiki
==시뮬레이션 기반 스토리 데이터베이스 설계==
=== 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 || [[호랑이의 보은]]
|}
phcu34zpy9ph6fem6nnpevjxxrrgv5k