대문
스토리 데이터베이스
목차
시뮬레이션 기반 스토리 데이터베이스 설계
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 | 호랑이의 보은 |
