TELKOM
NIKA Indonesia
n
Journal of
Electrical En
gineering
Vol.12, No.4, April 201
4, pp. 3177 ~ 3
1
8
4
DOI: http://dx.doi.org/10.11591/telkomni
ka.v12i4.4924
3177
Re
cei
v
ed Se
ptem
ber 18, 2013; Revi
se
d No
vem
ber
18, 2013; Accepted Decem
ber 9 20
13
Design on Controlling-Management System of Gas
Station
Xiaoning Jiang
1
, Jing Liu*
2
Z
heji
ang Go
ng
shan
g Univ
ersi
t
y
, Han
g
zho
u
, Chin
a
*Corres
p
o
ndi
n
g
author, e-ma
i
l
: jian
g
x
ia
oni
ng
@mail.zj
gsu.e
du.cn
1
, onthe
wa
y@p
op.zjgs
u.edu.cn
2
A
b
st
r
a
ct
W
i
th the s
u
stai
ned
a
nd r
a
p
i
d
grow
th of
do
mestic
fue
l
c
ons
umptio
n, co
ns
umers
have
made
mor
e
and
mor
e
hig
h
deman
d on the service of
ga
s station. A sta
b
le a
nd effi
cie
n
t refueli
ng system w
h
ich ba
s
e
d
on IC card is d
e
vel
ope
d in thi
s
paper. The
ma
in p
u
rpos
e
of this system i
s
to reali
z
e
th
e
commu
n
ic
atio
n of
pos ter
m
i
nal
a
nd tank
er effici
ently thro
ug
h p
r
otocol
c
onver
sion, a
nd th
e r
equ
ired fu
nctio
n
s of pos t
e
rmi
na
l
and
tank
er ar
e
als
o
ac
hiev
ed
. In ord
e
r to
monitor
the gas
station much mor
e
c
onve
n
i
e
ntly,
w
e
des
ig
n a
real-ti
m
e
monit
o
rin
g
front-en
d
interface w
h
ic
h bas
ed
o
n
Aj
ax techn
o
lo
gy, and w
e
can
also co
ntrol th
e
tanker thr
o
ugh the front-end
interf
ace. A
stable refueling
system
c
a
n
improve
the econom
ic benefit and
compa
n
y'
s core competitiv
en
ess. F
o
r it can
provi
de
scie
n
tific ma
na
ge
me
n
t
and effective control of mon
e
y
,
staff, oil, oil depot, equipm
ent and
s
o
on. So refueling
system
has realistic
necess
i
ty and
im
port
ant
me
an
ing
of
i
m
provi
ng th
e w
o
rking
efficie
n
cy
of the
g
a
s stat
ion
an
d r
e
d
u
ci
ng th
e
oper
atio
nal
of th
e v
a
rio
u
s
costs.
Ke
y
w
ords
:
re
al-ti
m
e, stabl
e, interface,
arch
i
t
ecture, protoc
ol conv
ersio
n
Copy
right
©
2014 In
stitu
t
e o
f
Ad
van
ced
En
g
i
n
eerin
g and
Scien
ce. All
rig
h
t
s reser
ve
d
.
1. Introduc
tion
Advance
d
i
n
ternation
a
l
o
il co
mpa
n
y
empha
si
ze
s
the con
s
tru
c
tion of i
n
formation
techn
o
logy, whi
c
h improves the econo
mic ben
efit
th
roug
h inform
ation mana
ge
ment techn
o
l
ogy.
In re
cent ye
a
r
s, the
nu
mb
er of
ga
s
station ha
s
a bi
g
increa
se
in
our
co
untry,
but the
qualit
y is
still relatively lag, the most important of wh
ich i
s
the backwa
r
d inf
o
rmatio
n ma
nagem
ent [1-5].
This
ca
uses to incre
a
se
cost, po
or
efficien
cy
an
d lo
w
core
comp
etitiveness fo
r comp
any. T
h
is
mean
s that China'
s oil an
d
petro
chemi
c
al indu
stry
wi
ll face the
strong p
r
e
s
sure
of internatio
nal
comp
etition. There for p
r
o
m
oting
the
constructio
n
of
informati
z
at
ion is a
n
imp
o
rtant supp
ort of
becoming
a
transnation
a
l
enterpri
s
e g
r
oup
with
strong inte
rnati
onal
com
petitiveness. So
to
desi
gn a
stable refuelin
g system i
s
critically
ne
eded to
sav
e
co
sts, rea
lize info
rmati
on
manag
eme
n
t and imp
r
ove
core competit
iveness. Th
i
s
system i
s
de
signed to
cha
n
ge the p
r
e
s
ent
situation of
g
a
s station, which su
pplie
s
a
bette
r solu
tion of empl
o
y
ee's
ard
uou
s an
d in
effici
ent
task [6, 7]. In this pa
pe
r
we di
scu
sse
d the tran
sa
ction p
r
o
c
e
s
s of gas
station in detail
an
d
desi
gne
d a system about
busi
n
e
ss p
a
ttern an
d re
al-t
ime monitori
n
g
of gas stati
on.
Comp
ared wi
th other types of refueling sys
tem, the main advanta
g
e
s are as foll
ows:
(1)
Reali
z
e re
levant prefe
r
e
n
tial by POS termin
als;
(2) P
r
ovide
s
functio
nality for real-time
m
onitori
ng oil
gun an
d trad
ing data
whi
c
h ba
sed
on B/S;
(3) Ea
sy to put into use whiteout ch
ang
ing
origi
nal system of station, and can
be very
conve
n
ient to
add more bu
sine
ss req
u
irements.
The
stru
cture
of the pap
er
is a
s
follo
ws:
we fi
rst detail
the syste
m
a
r
chite
c
tu
re in
se
ction
2, introdu
ce t
he syste
m
's f
unctio
n
s in d
e
tail in
se
ctio
n 3, we give
an overvie
w
of relevant key
techn
o
logy in
Section 4,
se
ction 5 int
r
odu
ce
the d
a
taba
se d
e
si
gn, se
ction
6
con
c
lu
de
s the
pape
r.
2. Sy
stem
Structure
In this section, we will disc
uss the
structur
e of this
system mai
n
l
y
from the following
asp
e
ct
s: phy
sical a
r
chite
c
ture, l
ogi
cal
archit
e
c
tu
re,
runtime
archite
c
ture
a
nd devel
op
ment
architectu
re.
Evaluation Warning : The document was created with Spire.PDF for Python.
ISSN: 23
02-4
046
TELKOM
NI
KA
Vol. 12, No. 4, April 2014: 3177 – 3
184
3178
2.1. Ph
y
s
ical Architectur
e
Physical a
r
chitecture de
scrib
e
s the el
ement
of the system, the relation
ship
of each
element a
nd
how to
depl
o
y
them to hardwa
r
e, it
can
reflect th
e org
anization of
software
sy
ste
m
s
whe
n
the syst
em is ru
nnin
g
.
The physi
cal
architectu
re o
f
the system is sh
own in Figure 1.
Figure 1. Physical Architecture
This sy
stem i
s
m
a
inly
resp
onsi
b
le fo
r th
e commu
nica
tions
of F
C
C(Tanker controller)an
d
pos termi
nal
s, re
ceive
dat
a from
F
C
C
and
se
nd
co
mmand
s to
p
o
s te
rmin
als
or F
C
C, an
other
importa
nt part is the real-ti
m
e monito
rin
g
interfa
c
e
which
ba
sed
o
n
B/S in the structu
r
e of LA
MP,
throu
c
h which we can al
so
send
comm
a
nd
to FCC an
d control oil g
un co
nvenie
n
t
ly.
2.2. Logical Architec
ture
Logi
cal
archit
ecture mea
n
s that we can
cla
ssify the system into se
veral logi
cal
unit, and
every unit perform
e their own functio
n
s. The logi
cal architectu
re of the system is sh
own
in
Figure 2.
Figure 2. Logi
cal Archite
c
tu
re
Evaluation Warning : The document was created with Spire.PDF for Python.
TELKOM
NIKA
ISSN:
2302-4
046
De
sign o
n
Co
ntrolling
-
Ma
n
agem
ent Syst
em
of Gas Station (Xiao
n
in
g Jian
g)
3179
Presenting l
a
yer is th
e o
u
termo
s
t laye
r
of the
three l
a
yers,
w
hi
ch i
s
closest to
u
s
ers, a
nd
is u
s
ed to
dispalay data,
re
ceive u
s
e
r
in
put and
provide interf
ace
s
to sup
p
o
r
t hu
man inte
ra
ction
with bu
sine
ss processe.
This
system
mainly
incl
ude
s oil gun
state and t
r
an
sa
ction d
a
ta
monitori
ng int
e
rface, cont
ro
l interface a
n
d
admini
s
trati
v
e user inte
rf
ace.
Busine
ss log
i
c layer is the co
re pa
rt of the three layers, it mainly focu
s on the
formulatio
n o
f
busi
n
e
s
s ru
les, im
pleme
n
tations of
b
u
sin
e
ss
pro
c
esse
s a
nd
d
e
sig
n
of
rele
vant
busi
n
e
ss req
u
irem
ents. It mean
s that this layer i
s
related to the busi
n
e
ss d
o
main. The rol
e
of
busi
n
e
ss lo
gi
c layer i
s
crit
ical to the th
ree laye
rs, it
is in bet
wee
n
pre
s
e
n
ting
layer an
d data
layer,whi
c
h
pl
ay the
role
of
co
nne
cting
li
nk
of
t
he t
w
o
lay
e
r
s
.
I
n
t
h
i
s
sy
st
e
m
b
u
si
nes
s l
ogi
c lay
e
r
mainly incl
ud
es g
e
t real
-ti
m
e data a
nd t
r
an
sa
cti
on d
a
t
a,chan
ge p
r
i
c
e, op
en o
r
close
oil gu
n, stop
refuelin
g, call
back lost hi
story data, sign
in or sign o
u
t with pos te
rminal and
so
on.
Data laye
r i
s
respon
sibl
e to the a
c
ce
ss
to t
he data, it
can
be
data
base, text files an
d
so
on. we no
w
use MYSQ
L and some te
xt files as dat
a layer. In this layer
we sh
ould provide
the
interfaces to realize the access of data.
2.3. Runtime
Architectur
e
This p
a
rt det
ails ho
w to
sched
ule ba
ckgr
oun
d processe
s, as yo
u can
se
e from the
followin
g
pict
ure, we
call this sy
stem as GKS, POS-1, POS-2 mea
n
s POS termi
nals an
d FCC-1,
FCC-2, F
C
C-3 mea
n
s
different ta
nker
controlle
rs
. T
he runtime a
r
chite
c
tu
re of
the sy
stem
is
s
h
ow
n
in
F
i
gu
r
e
3
.
Figure 3. Run
t
ime Archite
c
t
u
re
This
system
manily con
s
i
s
ts of four kin
d
s
of pro
c
e
s
se
s:
1. pos_
age
ntd
It is responsible for the in
teraction of POS and scheduled
.Its function are as follows:
(1) Sen
d
re
qu
ests to sch
e
d
u
led in the way of sche
dul
e get.
(2) S
ent to P
O
S termin
als
the re
sult
s th
at the scri
pt return, a
nd
wri
t
e error l
og to
the log
file if necessary.
(3) Invo
ke scripts and
com
p
lete the ope
ration of the databa
se.
2. sch
edul
ed
pro
c
e
s
s
It is respon
si
ble for the
in
teractio
n of
p
o
s_
age
ntd a
nd fcc_
age
ntd, invoke
scri
pts a
nd
sen
d
req
u
e
s
ts to fcc_
age
n
t
d in the way of fcc_g
e
t an
d then retu
rn
the result to the req
u
e
s
ter.
3. fcc_a
gentd
It is resp
on
sible for the intera
ction of schedul
ed and
FCC.
Its function a
r
e as follo
ws:
Evaluation Warning : The document was created with Spire.PDF for Python.
ISSN: 23
02-4
046
TELKOM
NI
KA
Vol. 12, No. 4, April 2014: 3177 – 3
184
3180
(1) F
o
r the
requ
est
s
whi
c
h come
s from sche
dule
d
, fcc_
agent
d is re
sp
on
sible for
proto
c
ol conv
ersi
on, and th
en se
nd it to FCC lo
ng con
nectio
n
.
(2) Fo
r the result
s whi
c
h
come
s from
FCC, fcc_a
gentd is respon
sible for
proto
c
ol
conve
r
si
on, a
nd then send
it to sched
ule
d
.
(3)
For th
e d
a
ta whi
c
h
se
nd by F
CC
a
u
tomaticly, fcc_a
gentd i
s
resp
on
sible fo
r invoki
ng
scripts to p
u
t data into data
base and
wr
it
e the error lo
g to the log file.
4. scripts
The pu
rpo
s
e
of script
s
a
r
e pa
rse or
con
s
tru
c
te JSON, put da
ta into database a
nd
invoke
d by pos_
age
ntd, sche
dule a
nd fcc a
gentd
2.4. Dev
e
lop
m
ent Ar
chite
c
ture
(1)
di
re
ctory orga
nization
/root/gks_te
s
t
/
gks_bin sto
r
e
exe
c
utabl
e
files
，
such as p
o
s_
agentd, fcc_
agentd,
sched
uled, fcc_
simulato
r, sched
ule get
and fcc get.
/root/gks_te
s
t
/
gks_conf st
ore
config files,
su
ch a
s
pos_ag
entd.conf, fcc_a
g
e
n
td.conf
and sch
edul
e
d
.conf
/root/gks_te
s
t
/
gks_log
s
tore
log file
s, such
as po
s_age
ntd.log,
fcc_ag
entd.
conf
and
sched
uled.
co
nf
/root/gk_test/
g
ks_pi
d store
pid files
/root/gks_te
s
t
/
gks_script stor
e scri
pt files mai
n
ly includ
e com
m
and script, such a
s
fcc_
co
mman
d
and po
s_
co
mmand
/
r
oot
/
g
k
_
t
e
st
/
g
k
s
_
s
r
c
st
o
r
e
sour
ce
cod
e
/var/www/htm
l store ph
p files
(2) thir
d-
party
library
json-c
libmysql
c
lient
Libiconv
3.
Sy
stem Function An
aly
s
is
In ord
e
r to
analysi
s
the
function
of
the sy
stem,
we fi
rst int
r
odu
ce
the
busi
n
e
ss
transactio
n
s
of gas statio
n, which is very importa
nt to realize the function
s o
f
the system. We
cla
ssif
y
ea
ch
t
r
ans
act
i
o
n
pro
c
e
ss i
n
t
o
f
i
v
e
st
ates, a
nd detail
s
of how to p
r
o
c
e
ss
comm
and
s is
s
h
ow
n
in
F
i
gu
r
e
4
.
Figure 4. The
State Transit
ion Dia
g
ra
m of Busine
ss
Evaluation Warning : The document was created with Spire.PDF for Python.
TELKOM
NIKA
ISSN:
2302-4
046
De
sign o
n
Co
ntrolling
-
Ma
n
agem
ent Syst
em
of Gas Station (Xiao
n
in
g Jian
g)
3181
The tra
n
sacti
on state i
n
cl
u
de initial stat
e, aut
hori
z
e
d
of oil gun,e
n
d
of refuelin
g ,begin to
settle acco
un
t, end of settle accou
n
t an
d can
c
el a
u
th
orization of oi
l gun.
(1) Initial
stat
e: in this stat
e, the inform
ation
of oil gu
n is n
o
t exist in the datab
a
s
e, an
d if
now receive
a authori
zati
on
comm
and from P
O
S
t
e
rminal, sy
stem
will
send the
comm
and to
FCC afte
r protocol
conve
r
sio
n
and th
en insert
ne
w re
co
rd
s into the datab
ase. If recei
v
e
authori
z
atio
n su
ccessfully from
FCC, turn to next s
t
ate.
(2) Autho
r
ize
d
of oil
gun:
in this state,
if receive a
a
u
thori
z
ation
comman
d
fro
m
POS
terminal,
syst
em will
se
nd
doubl
e-panti
ng to POS
t
e
rmin
al, if re
ceive a
can
c
el autho
ri
zati
on
comm
and, sy
stem will sen
d
can
c
el aut
hori
z
ation
co
mmand to F
CC after p
r
ot
ocol
conve
r
si
on
and still
hold this
state,
if receive a
auth
o
rizati
on faile
d inform
ation
from F
CC,
system will
se
nd
authori
z
atio
n failed to POS terminal.
(3) End of refuelin
g: in this state,
if receive a
u
thori
z
ation
comm
and from POS
terminal,
s
yst
e
m will
sen
d
“have n
o
t sett
le acco
unt
yet” to POS terminal, if re
cei
v
e settle a
c
count
comm
and
sy
stem
will
sen
d
settlement
amount
and
i
n
tegral
to P
O
S termin
al
and
ch
ange
the
informatio
n of state in the databa
se at the same time.
(4) Be
gin to
settle a
c
coun
t: in this state
if receive a
authori
z
atio
n
comm
and from POS
terminal,
syst
em
will send
the comma
nd
to F
C
C after protocol
con
v
ersio
n
a
nd t
hen i
n
sert n
e
w
records into t
he database. If receive the informat
ion of transaction from
POS terminal, will turn
to next state.
(5) End of settle account:
in this state
if receive a authori
z
atio
n
comma
nd from POS
terminal,
syst
em
will send
the comma
nd
to F
C
C after protocol
con
v
ersio
n
a
nd t
hen i
n
sert n
e
w
records into t
he datab
ase and this
state
will hold on.
Implementati
on of all the functio
n
s mu
st be
base
d
on
the state tran
sition dia
g
ra
m. The
function
s can
be con
c
lu
de
d as follo
ws:
(1) Pro
c
e
s
s
busi
n
e
s
s an
d data
b
e
tween P
O
S a
n
d PC o
r
F
C
C a
n
d
PC, f
o
r
som
e
importa
nt data, save them
to the databa
se.
(2) F
o
r po
s te
rminal:
Re
ceive auth
o
rization
com
m
and, send
compl
e
te
info
rmation of oil
gun an
d cal
c
ulate
different di
scount ba
se
d o
n
differe
nt user
card
, send
fundam
ental
data,save
th
e re
co
rd
of si
gn
in/sign o
u
t an
d transactio
n
informatio
n.
For F
CC:
Send
auth
o
ri
zation com
m
and corre
c
tly,
reveic
e pre
s
ent
tra
n
sact
ion
data or history
record,
Send cha
nge pri
c
e comm
and,
sto
p
refueli
ng co
mmand,o
pen/
clo
s
e
oil
g
un comm
and an
d
so on,
(3) re
al-time
monitori
ng of
oil gu
n a
nd t
r
an
sa
ction
da
ta, use
r
s can
overvie
w
all
of state
of the oil gun
s and the late
st tran
sa
ction
reco
rd.
4. Relev
a
nt
Ke
y
Technolog
y
4.1. Protocol
Conv
ersion
Figure 5. Protocol
Conve
r
si
on
Evaluation Warning : The document was created with Spire.PDF for Python.
ISSN: 23
02-4
046
TELKOM
NI
KA
Vol. 12, No. 4, April 2014: 3177 – 3
184
3182
Becau
s
e of
different protocol of POS
term
inal an
d FCC, so
we ne
ed to con
s
id
er
proto
c
ol
conv
ersi
on. Both
POS and F
C
C send
com
m
and in th
e format of
JSO
N
, the structu
r
e of
them are diffe
rent.
Whe
n
pos terminal se
nd comman
d
to FCC, GKS ha
ve to do protocol conve
r
si
on. The
pro
c
e
ss i
s
sh
own a
s
follo
ws:
POS age
ntd
receive the
p
a
ckets from
POS (J
S
O
N-POS) an
d th
en
send
the
packet
s
to
corre
s
p
ondin
g
modul
e, this mod
u
le
will do a serie
s
of pro
c
e
ssi
n
g
step
s an
d
then send n
e
w
JSON packet
(JS
O
N-GKS
)
to
scheduled, sche
duled will
send the ne
w
JSON packet to F
CC-
Agentd, FCC-Agentd n
eed
to parse the
conte
n
ts
of th
e packet
(JS
O
N-FCC)
an
d then send it
to
FCC, we ca
n visuali
s
e the pro
c
e
s
s as
（
JS
O
N
-
P
OS
）
→
（
JSON
-GKS
）
→
（
JS
ON
-F
CC
）
.
Similarly, response from F
CC
will be
（
JS
O
N
-F
C
C
）
→
（
JS
ON
-G
K
S
）
→
（
JS
ON-POS
）
.
4.2. Real-time Monitoring
Technique
In this
syste
m
, real
-time
monitori
ng [8
, 9] ca
n be
i
m
pleme
n
ted
with AJAX te
chn
o
logy
and Caching
techn
o
logy.
(1) A
J
AX technolo
g
y
Ajax works li
ke this: ad
d
a middle lay
e
r
bet
ween
client an
d se
rver, ma
ke the user
operation
s
an
d se
rver resp
onse as
yn
ch
ronou. requ
ests from cli
ent
will be d
one
by ajax engin
e
,
and ajax en
gi
ne will submit
the reque
st to serve
r
.
The main
co
mpone
nts of ajax techn
o
lo
gy are JavaS
c
ript, XML
H
T
T
PReq
ue
st and DOM.
In tradition
al
ways
of interaction [1
0], cl
ient se
nd
a reque
st to
se
rver, and
re
su
lt are
sent
ba
ck
from the
se
rver, so
users might have
a long
wait
b
e
fore th
ey se
e anything
h
appe
n, so
user
experie
nce was bad. Thi
s
probl
em ca
n be solved
by
ajax technol
o
g
y. The
bigg
e
s
t adva
n
tage
o
f
ajax is that u
s
ers
ca
n g
e
t
what th
ey wa
nt wi
tho
u
t pa
ge refre
s
h,thi
s
b
enefits fro
m
XMLHTTP
and
XMLHTTP
Re
que
st.
In this syste
m
, the data informatio
n of o
il gun and
trading will
be se
nt to server by
XmlHttpRe
qu
est obj
ect,
server
retu
rn
s a re
sp
on
se,
and th
en refresh p
age
s b
y
DOM, we
can
also
config
ure update inte
rval.
(2) Ca
chin
g
tech
nolo
g
y
In practi
ce, th
e tra
n
sactio
n
data of
oil
gu
n c
han
ge ve
ry frequ
ently, if we
sto
r
e
the
s
e
kin
d
of inform
ation into
RDBMS
and fetch them from
it, this
will degrade dat
abase perform
a
nce, so
we
choo
se
memcached.
Memcached
is de
sign
ed
to
store i
n
formation in me
mory, it norm
a
lly
run
s
a
s
a d
a
e
mon i
n
the
backg
rou
nd
whe
n
started
and
a
c
cept
con
n
e
c
tion
s f
r
om th
e
clien
t
at
any time.
Wh
en a
cli
ent h
a
s
con
n
e
c
ted,
it can
a
c
cess
obje
c
t an
d ev
ery o
b
ject
ha
s a
uni
que
ke
y,
you
can
g
e
t
you want with this key.
Fo
r the
obj
ect
s
a
r
e sto
r
ed
in m
e
mory. So
use mem
c
a
c
h
e
d
can b
e
qui
ckl
y and efficien
tly.
We get the informatio
n of oil gun such as
p
r
ice, oil produ
ct, pump, amo
unt from
memcache
wi
th ajax tech
n
o
logy. Fact
s
proved th
at
they wo
rked
well, u
s
er
get
good
re
sults
from
Web
b
r
o
w
sers, the
follo
wi
ng pi
ctu
r
e i
s
the
sn
ap
sh
ot of a
c
tual
operating
sit
uation f
r
om
gas
station, wh
en
the oil gun is pumping oil,
the colo
ur will
turn to gree
n
.
Figure 6. The
Interface of
Oil Gun Monit
o
ring
Evaluation Warning : The document was created with Spire.PDF for Python.
TELKOM
NIKA
ISSN:
2302-4
046
De
sign o
n
Co
ntrolling
-
Ma
n
agem
ent Syst
em
of Gas Station (Xiao
n
in
g Jian
g)
3183
5. Databa
se
De
sign
Good
data
b
a
se
de
sig
n
i
s
ve
ry imp
o
r
tant
fo
r a
high
pe
rform
ance
system
. In the
desi
gning of t
h
is sy
stem we cho
o
se mysql.
5.1. Data
bas
e
Choice
s
The re
ason
s we choo
se M
YSQL are the
following:
(1) MySQ
L h
a
s p
o
werful f
eature
s
,it inte
grate
stored pro
c
ed
ures,
v
i
ew
, subq
uery, it also
sup
port full-t
e
xt indexes,
copy, que
ry
ca
che a
nd ot
her a
d
van
c
e
d
feature
s
, a
nd it contai
ns rich
config
uratio
n option
s
(2)The d
a
tab
a
se m
ana
ge
ment syste
m
is an o
pen
so
urce sy
stem
and to u
s
e thi
s
ki
nd of
database
will reduce the
costs which is very important to
small to medium
-si
z
ed busi
n
esses.
(3) MYSQL
can be u
s
ed
conve
n
iently, it r
uns on a
wide variety
of platforms MYSQL
c
o
mbines
PHP, C, C+
+
,
J
A
VA perfec
t
ly.
5.2. Structu
r
e Design o
f
Databa
se
For th
ere
a
r
e
too ma
ny ta
bles built
during
the
devel
op
of
thi
s
sy
stem, so we mainly
introdu
ce
se
veral impo
rta
n
t tables, an
d the entit
y-relation
ship di
agra
m
of these table
s
a
r
e
s
h
ow
n
as
fo
llo
w
s
:
Figure 7. Th
e Entity-relationship Di
agram of Databa
se
6. Conclu
sion
In this p
ape
r,
we
mainly in
trodu
ce
a ma
nagem
ent
system
whi
c
h
b
a
se
d on
IC
card
and
we de
scri
be the tran
sa
ctio
n model of g
a
s
station
in
detail. The sy
stem r
ealized
the function
of
sign
in/si
gn
o
u
t and
auth
o
rization
of em
ployee.po
s te
rminal
s
ca
n g
e
t the info
rm
ation of
uses'
IC
card
automa
t
icly and
a
c
t
acco
rdi
ngly. For F
CC,th
e sy
stem
ca
n al
so
re
alize the
rel
e
va
nt
function
s th
rough t
r
an
smi
t
ing protocol. Espe
cially
we d
e
si
gn
a
real
-time m
onitorin
g
inte
rface
whi
c
h g
r
eatl
y
facilitated manag
eme
n
t person
nel
of of gas
station. The
system ha
s b
een
operated in g
a
s statio
n for more than
h
a
lf a year,
practices sho
w
that
t
he syste
m
is stabl
e a
n
d
Evaluation Warning : The document was created with Spire.PDF for Python.
ISSN: 23
02-4
046
TELKOM
NI
KA
Vol. 12, No. 4, April 2014: 3177 – 3
184
3184
has go
od
utility and i
s
cha
r
acteri
ze
d by
real-time
pe
rforma
nce a
n
d
flexible exp
a
nsibility, so th
is
system i
s
im
portant fo
r improvin
g the
overa
ll ma
n
ageme
n
t of gas
station,
and ha
s b
r
ig
ht
appli
c
ation fu
ture.
Ackn
o
w
l
e
dg
ements
This
wo
rk
wa
s
supp
ort
ed by the
Nation
al
Nature S
c
ie
nce
Fou
nda
tion of
Chin
a(6
127
2
306), the Imp
o
rtant Scie
nce and Te
ch
n
o
logy Speci
a
l
Project of Z
hejian
g
Provi
n
ce
(201
1C110
41
), the Public Project of Scien
c
e an
d
Techn
o
logy
Plan in Zhejiang Provin
ce
(201
2C210
01
), the Public Project of Scien
c
e an
d
Techn
o
logy
Plan in Zhejiang Provin
ce
(201
3C310
42
), the
Colle
g
e
Student
s'
Scien
c
e
and
Technol
ogy
Innovation
Activities Pla
n
of
Zhejian
g
Pro
v
ince (1
130
JQ421
205
8G).
Referen
ces
[1]
Lia
ng Z
h
iho
ng,
Lu J
un. D
e
sig
n
on
Informati
o
n
Man
a
g
e
ment
S
y
stem
of Ga
s Station. F
i
fth
Internatio
na
l
Confer
ence
on
Intellig
ent Co
mputatio
n T
e
chno
log
y
and A
u
tomatio
n
. 201
2: 139-1
41.
[2]
Z
hen
Ran, Z
h
u W
e
i-l
u
, Ya
n
g
Guo-fu.
Desi
gn
of Ce
ntral
Monitor
&Co
n
trol S
y
stem
in
the
Refue
lli
n
g
Station.
Jian
gs
u Electrica
l
Ap
paratus.
20
06 (
4
): 11-13.
[3]
Song
Hon
g
w
e
i, Z
hen Ra
n.
Desig
n
a
n
d
Real
iz
ati
on
of Gas station C
entr
a
l Co
ntrol S
y
stem.
Microco
m
p
u
ter
Informati
on.
2
006; (16): 1
06-
107, 14
9.
[4]
Z
hang
Z
ongr
e
n
, Z
han
g L
u
g
uo. T
he Des
i
g
n
of C
o
mp
uter
Conc
entrati
ng
Contro
l S
y
ste
m
in F
i
ghte
r
Plan
e Service
Station.
Microc
omputer Infor
m
ation
. 20
01; (0
5): 14, 19.
[5]
W
A
NG Jian, L
I
U Yanh
en
g, D
O
NGT
i
anzhe.
Desig
n
and
Imple
m
entatio
n
o
f
W
PKI-based
Gas Stati
o
n
Online Paym
ent System
, 29t
h Chi
nese C
o
n
t
rol Confer
enc
e. 2010: 4
132-
413
5.
[6]
Ren
Xu
hu, Ca
i Liju
an, Yan
g
Lei. Rese
arc
h
and re
a
liz
ati
on of forecour
t cont
roller at gas station
.
Industria
l Instrumentati
on &
Auto
matio
n
.
20
10; (3): 39-44.
[7]
W
e
ihu
a
Xio
ng.
Desi
gn
on S
e
lf-service S
y
st
em of Gas Sta
t
ion
w
h
ich
Bas
ed o
n
IC C
a
rd
.
Science &
T
e
chno
logy Inf
o
rmatio
n
. 200
9
:
78.
[8]
Xu
efen
g
Liu,
Jing
Z
hu, J
i
an
hua
Ma
o, Xia
o
min
g
S
hao,
Lo
ngl
on
g L
u
.
Desi
gn
of Re
al-tim
e
Commun
i
cati
o
n
Ad
apter
for
Different Pr
oto
c
ol S
ens
ors i
n
Sens
or W
e
b.
T
E
LKOMNIKA Indo
nes
ia
n
Journ
a
l of Elec
trical Eng
i
ne
eri
n
g
. 201
2: 110
1
-
110
5.
[9]
Liji
ng Z
h
a
ng, W
e
i Xi
on
g, Xu
ehu
i Xian.
Res
earch o
n
W
eb-
base
d
Rea
l
-tim
e Monitor
i
ng S
y
stem on SV
G
and C
o
met.
T
E
LKOMNIKA Indon
esia
n Jour
nal of
Electric
al
Engin
eeri
ng.
2
012: 11
42-
114
6.
[10]
W
e
igu
o
H
an,
Lipi
ng
Di,
Pei
s
hen
g Z
h
ao,
Xi
ao
ya
n
Li.
U
s
ing
Ajax
for
Desktop-
like
Geosp
a
tial
W
e
b
Appl
icatio
n De
velo
p
m
ent.
17t
h Internatio
na
l Confer
ence
on
Geoinformatic
s
. 2009.
Evaluation Warning : The document was created with Spire.PDF for Python.