Show simple item record

dc.contributor.advisorWagner, Paul J.
dc.contributor.authorYost, Andrew
dc.descriptionColor poster with text describing research conducted by Andrew Yost advised by Paul J. Wagner.en
dc.description.abstractThe complexity of the Oracle database management system (DBMS) query execution process in addition to the lack of available resources detailing the process have historically made teaching the process quite difficult. In response to this difficulty members of our group had developed an application to visually simulate the execution process for certain SQL statements executed against an Oracle DBMS. As an extension to this project we have expanded the previous simulator to include functionality for dynamic SQL interaction with an instance of the Oracle DBMS. By extending previous design patterns as well as incorporating a facade design pattern for data access, the simulator was redesigned to retain the static execution functionality existing previously, but also to provide new dynamic query submission and visualization capabilities. By interacting with an Oracle DBMS instance through Java Database Connectivity, the simulator provides a visual representation of the execution process for user-generated queries within a specific oracle DBMS environment. We have also incorporated the ability for the simulator to extract and display the execution plan developed during the query execution process. These capabilities allow the simulator to visualize both the execution of a broad range of queries as well as changes in the DMS environment.en
dc.description.sponsorshipUniversity of Wisconsin--Eau Claire Office of Research and Sponsored Programs.en
dc.format.extent668672 bytes
dc.format.extent785102 bytes
dc.relation.ispartofseriesUSGZE AS589en
dc.subjectOracle (Computer file)en
dc.subjectSQL/ORACLE (Computer program language)en
dc.subjectDatabase managementen
dc.subjectRelational databasesen
dc.subjectComputer simulationen
dc.subjectJava (Computer program language)en
dc.subjectApplication program interfaces (Computer software)en
dc.titleDeveloping a dynamic visualization of the Oracle Query Execution Processen

Files in this item


This item appears in the following Collection(s)

  • Student Research Day
    Posters of collaborative student/faculty research presented at Student Research Day

Show simple item record