izpis_h1_title_alt

Pretvorba PL/SQL izvorne kode v graf prehodov aplikacije : diplomsko delo
Bac, Luka (Author), Slivnik, Boštjan (Mentor) More about this mentor... This link opens in a new window

URLURL - Presentation file, Visit http://eprints.fri.uni-lj.si/2981/ New window

Abstract
Pri obratnem inženiringu aplikacij je analitiku v pomoč pregledni graf funkcijskih klicev aplikacije. Prikazali smo delovanje razvite aplikacije, ki avtomatsko generira tak graf. Za njegovo predstavitev smo uporabili atomični model odseka (ASM) s približkom grafa prehodov aplikacije (ATG). Aplikacija je bila razvita na primeru informacijskega sistema e-Študent. Sistem temelji na podatkovni bazi proizvajalca Oracle, na voljo nam je bila izvozna datoteka baze, iz katere je bilo treba pridobiti izvorne datoteke s funkcijami, dinamičnimi strukturami in procedurami v jeziku PL/SQL. Najprej je bilo treba bazo restavrirati, nato pa iz nje izvleči izvorno kodo. Za to kodo smo nato z odprtokodnim orodjem flex definirali potrebno leksikalno zgradbo jezika PL/SQL – v tem primeru predvsem opis funkcijskih klicev. Nato smo z uporabo dobljenega leksikalnega analizatorja generirali s programskim jezikom Python tekstovno datoteko v formatu za opis grafov DOT. To datoteko smo z orodji iz paketa Graphviz pretvorili v grafe, ki nakazujejo, katere datoteke kličejo katere funkcije, kar je v pomoč pri razumevanju strukture sistema. Te grafe smo poskusili narediti bolj berljive z dodatkom funkcij Javascript in stilov CSS za obarvanje povezav ter z izračunom vhodne in izhodne stopnje vozlišč, s pomočjo katere lahko izločimo posamezna vozlišča.

Language:Slovenian
Keywords:PL/SQL, Oracle SQL, atomični model odseka, graf prehodov aplikacije, model interakcij komponent, Flex, Graphviz, Python, računalništvo, visokošolski strokovni študij, računalništvo in informatika, diplomske naloge
Work type:Bachelor thesis/paper (mb11)
Tipology:2.11 - Undergraduate Thesis
Organization:FRI - Faculty of computer and information science
Year:2015
Publisher:[L. Bac]
Number of pages:37 str.
UDC:004.65(043.2)
COBISS.SI-ID:1536308419 Link is opened in a new window
Views:366
Downloads:105
Metadata:XML RDF-CHPDL DC-XML DC-RDF
 
Average score:(0 votes)
Your score:Voting is allowed only to logged in users.
:
Share: Bookmark and Share

Secondary language

Language:English
Title:Transforming PL/SQL source code into an application transition graph
Abstract:
A graph providing an overview of an application would serve the reverse engineering effort well. We have walked through the workings of an application that was developed to automatically generate one such graph, which was represented by an Atomic Section Model with an approximation of its Application Targeted Graph. The case-study for this application was the student information system e-Študent. This system uses an Oracle Database to host the data, while our effort only had access to a database dump from which to retrieve the PL/SQL source code in the form of functions, dynamic structures and procedures. The first step was to restore the database itself, followed by scraping the source code into text files which were then analyzed using a lexical analyzer developed by the open source tool flex, in which we defined the required PL/SQL lexical structure, focused mainly on recognizing function calls. This output was then fed through a Python script that generated a file in the DOT format, describing the function calls of the individual input files. This was presented by rendering it into a graph with the open source graph visualization software Graphviz. These graphs were then made easier to read by injecting Javascript functions and CSS styles to enable highlighting of edges and vertices. In addition, the application calculates the in and out degree of each vertex, which can help the analyst in deciding to exclude certain vertices.

Keywords:PL/SQL, atomic section model, application transition graph, component interaction model, Flex, Graphviz, Python, computer science, computer and information science, diploma

Similar documents

Similar works from RUL:
Similar works from other Slovenian collections:

Comments

Leave comment

You have to log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back