PostgreSQL の XML 機能解説と将来拡張への提言

Size: px

Start display at page:

Download "PostgreSQL の XML 機能解説と将来拡張への提言"

きみとしおうじ
7 years ago
Views:

1 B 1

2 PostgreSQL "Let's Postgres" 2

3 PostgreSQL XML URL 3

4 4

5 Storage Query Language XML Schemas Programming Interface 5

6 XML A RDB B XML 6

7 RDB ID ID

8 RDB ID ID XML

9 XML ID 9

10 XML A) RDB B) XML 10

11 RDB ID ID XML

12 XML XMLPGSQL XML XML2 Xpath XSLT 12

13 XML XML Xpath RDB XML SQL/XML 13

14 XML xml CREATE TABLE meibo(id integer, detail ); id ID ( integer ) detail ( xml ) <name> </mame> < >ayoshida@ </ > <name> </mame> < >mabe@ </ > <name> </mame> < >ghibiki@ </ > 14

15 XML Xpath SELECT xpath( /employee[name/text()= ], ditail) FROM meibo; id ID ( integer ) detail ( xml ) <name> </mame> < >ayoshida@ </ > <name> </mame> < >mabe@ </ > <name> </mame> < >ghibiki@ </ > 15

RDB XML SQL/XML Id ID Employee email 12345678 ayoshida@xxx.co.

16 RDB XML SQL/XML Id ID Employee select xmlelement (name , )from meibo; 16

17 4. XML SQL/XML SQL/XML XPath 1. XPath XML 3. xml2 XSLT XSLT GIN 2. GIN 17

<start>1970-04-01</start> <end>1980-03-31</end>

</career> <period> <start>1980-04-01</start>

18 PostgreSQL OS Windows XP <work-record> <period> <start> </start> <end> </end> </period> <content> </content> <role> </role> </career> <period> <start> </start> <end> </end> </period> <content> Web </content> <role> </role> </career> <period> <start> </start> <end/> </period> <content>it </content> <role> </role> </career> </work-record> 18

psql PostgreSQL Id name department age email

19 psql PostgreSQL Id name department age Work_history 1031 IT 45 <work-record>.com <period> d.com d.com d.com bcd.com <work-record> <period> <work-record> <period> <work-record> <period> <work-record> <period>.csv CSV 19

20 20 <work-record> <period> <start> </start> <end> </end> </period> <content> </content> <role> </role> </career> <period> <start> </start> <end> </end> </period> <content> Web </content> <role> </role> </career> <period> <start> </start> <end/> </period> <content>it </content> <role> </role> </career> </work-record> child descendant or self descendant parent ancestor ancestor or self following following sibling preceding preceding sibling self /work record/career[role/text()= ]

id,name,<role> Id name department age email Work_history 1031 IT 45 ikuta@abcd.

21 id,name,<role> Id name department age Work_history 1031 IT 45 <work-record> <period> <start> </start> <end> </end> </period> <content> </content> <role> </role> </career> <period> <start> </start> <end> </end> </period> <content> Web </content> <role> </role> </career> <period> <start> </start> <end/> </period> <content>it </content> <role> </role> </career> </work-record> XML = 21

22 B-Tree XML GIN XPath xpath( /work-record/career/role/text(),work_history) xpath {,, } {, } {, } { } { } 22

Id name department age email Work_history 1 2 3 299 300 XPath INDEX <work-record> <period> <start>1970-04-01</start> <end>1980-03-31</end> </period> <content> </content> <role> </role> </career>

23 Id name department age Work_history XPath INDEX <work-record> <period> <start> </start> <end> </end> </period> <content> </content> <role> </role> </career> <period> <start> </start> <end> </end> </period> <content> Web </content> <role> </role> </career> <period> <start> </start> <end/> </period> <content>it </content> <role> </role> </career> </work-record> 1. Meibo

24 XML XSLT XML HTML 24

25 Id name departm ent age Work_history 1031 IT 45 com <work-record> <period> <start> </start> <end> </end> </period> <content> </content> <role> </role> </career> <period> <start> </start> <end> </end> </period> <content> Web </content> <role> </role> </career> <period> <start> </start> <end/> </period> <content>it </content> <role> </role> </career> </work-record> 25

<?xml version="1.0" encoding= Shift_JIS"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.

match="work-record"> XSLT <h1> </h1> <table frame="border" width="50%"> <tr><th> </th><th> </th><th> </th><th> </th></tr> <xsl:for-each

select="content"/></td> <td><xsl:value-of select="role"/></td> </tr> </xsl:for-each> </table> </xsl:template> </xsl:stylesheet> I d na me depart ment

26 <?xml version="1.0" encoding= Shift_JIS"?> <xsl:stylesheet version="1.0" xmlns:xsl=" <xsl:output method="html"/> <xsl:template match="/"> <html ><xsl:apply-templates/></html> </xsl:template> <xsl:template match="work-record"> XSLT <h1> </h1> <table frame="border" width="50%"> <tr><th> </th><th> </th><th> </th><th> </th></tr> <xsl:for-each select="career"> <tr> <td><xsl:value-of select="period/start"/></td> <td><xsl:value-of select="period/end"/></td> <td><xsl:value-of select="content"/></td> <td><xsl:value-of select="role"/></td> </tr> </xsl:for-each> </table> </xsl:template> </xsl:stylesheet> I d na me depart ment 1031 IT Work_history <work-record> <period> <start> </start> <end> </end> </period> <content> </content> <role> </role> </career> <period> <start> </start> xslt_process xslt_process() WHERE name = ' '

27 xmlelement() xmlforest() xmlattributes() xmlcomment() xmlconcat() xmlpi() xmlroot() xmlagg() xmlparse() xmlserialize() XML XML XML XML XML XML XML XML XML xmlconcat XML XML (PostgreSQL ) 27

declaration name root person email mail-list name person email XML

28 declaration name root person mail-list name person XML SQL/XML id name work_history 1031 <work record> 28

29 XML SELECT select xmlroot(xmlelement(name mail_list, (select xmlagg( xmlelement(name person, xmlelement(name name, name), xmlelement(name , ) )) from meibo)),version '1.0',standalone yes); 29

30 XPath XSLT XQL/XML XML PostgreSQL XML 6 Postgresql XML 30

31 Storage Query Language XML Programming Interface 31

32 Schemas Web Service 32

33 XML Xerces 33

34 XML 34

35 XML XML Xpath RDB XML SQL/XML 35

36 XML 36

_02_3.ppt

_02_3.ppt XML DB Oracle Corporation Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 2 Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 3 RDB-XML RDB XML Oracle Corporation 4 XML RDB [Oracle] Extract ExtractValue