Platform-independent method and system for graphically presenting the ...

A
i

< in

d

FIG. 5B

<! ELEMENT EXPLAIN_REPORT (APPLICATIONJXPLAINJDATA) + >

<! ATTLIST EXPLA1N_REP0RT PLATFORM (OS390 | AS400 | SQLDS | WORKSTAT
ION) #REQUIRED>

<! ATTLIST EXPLAIN_REPORT PRODUCTVERSION CDATA #REQUIRED>

kkkikkikkkkkikkkkUkkkkkkUlkkk ^

<! - - An application contains header information and EXPLAIN irrfbrma fon for - - >

<! - - one or more statements.

kkkkkkkkkUkkkklUikkkkkkkUH'k ^

f <! ELEMENT APPLICATfON_EXPLAIN DATA (

412^ APPLICATIONS,
4J3_r~ DB_CONFIGURATION_PARMS?(
414 ^r- BINDJWAMETERS?,
415^- SWT_ACCESS_PLAN+) >

<! ELEMENT APPLICATION_EXPLAIN DATA (

COLLECTIONJD?, VERSION?, DBRM?)>

<! ELEMENT DB_CONF!GURAT!ON_PARMS (ITEM+) >

<! ELEMENT BlNDj)ARAMETERS (BINDJIME, OPTIMIZAnONPARAMETERS?, ITE FIG. 5C

M*)>

<! ELEMENT 0PTIMIZAT10N_PARAWIETERS (ITEM*) >

a

<! - - A statement access plan contains EXPLAIN information and staff sties for - - >

<] - - one SQL statement

- - >

<! ELEMENT STMTACCESS_PLAN (STMTJTOPERTiES?, SQL_TEXT,

GRAPH NODES, GRAPH ARCS, OBJECT S
TATS+)> ~"

<! ELEMENT STMT_PROPERTES ( COST?, ITEM* )>

<! ELEMENT SQLJEXT (ORIGINALJSQL, OPTIMIZED_SQL?) >

*

<! - - GRAPH NODES represents all nodes of the access plan and each no des - - >

<! - - information. Graph Arcs is a paired list of the ID of the p arent Node - - >