Page 103 - ASBIRES-2017_Preceedings

GRAPHQL QUERY SAVER: ENHANCING THE PERFORMANCE OF GRAPHQL API WITH A QUERY
SAVING FACILITY
3.2 Database Design
The database for the proposed system was
developed by creating the ER diagram,
converting it to the relational schema and
normalizing it to the third normal form. The
final relational schema diagram for the
proposed system is described in Figure 2.
Figure 2: Database design
3.3 System Design
The use case diagram for the proposed
system is described in Figure 3. It is used to
analyze the system and do the designing.
Figure 3: System design
3.4 System Testing
Testing procedures were to get idea
whether system goals have been achieved.
Testing techniques such as white box testing,
black box testing, unit testing, integration
testing, acceptance testing and system testing
were done to ensure this.
93
4 RESULTS AND DISSCUSSION
4.1.Features of the Developed System
Since this is a modification for the
existing system the newly developed part
connects to the existing system. A user can
enter a query/mutation for a relevant area
and they can execute the query/mutation and
get the result. Additionally, now there is save
button, when user click this button a pop up
window will appear and ask to save details
like name for query/mutation, relevant
project details the query/mutation belongs,
category and description about
query/mutation, the user want to save.
When user submits these details, the
query is saved in a server along with the
details given by the user. A screenshot of the
proposed system is given in Figure 4.
Figure 4: Screenshot of the proposed system
In addition to the save button there is a
query view button when user click this
button a drawer will appear with 2 drop
down menus, one to select project and other
to select category. When user select project,
user can see all the saved query and mutation
names that belongs to that project. If user
select category he can see saved query and
mutations for that category.
When user hover over the name of each
saved query/mutation user can see
description about that saved query/mutation