M t phn mm thu thp v hin

th d liu thng s in ba pha

I.

Tng quan chung v phn mm

Phn mm thu thp v hin th d liu thng s in ba pha l phn mm c thit

k dnh cho cc thit b o in thng minh, c dng gim st, cnh bo,
phn tch n nh ca li in ba pha. Phn mm s dng cc giao thc truyn
thng thng dng a d liu ln my ch trung tm. D liu s c hin th
mt cch thi gian thc ln giao din web ca phn mm di dng th. Ngoi
ra, ngi dng c th xem li th thay i ca tng thng s trong mt khong
thi xc nh, phc v cho vic in n v phn tch s c ca li in.

II.

Cu trc ca phn mm

Phn mm gm 2 thnh phn chnh

1. Phn mm thu thp d liu t my tnh trm

Phn mm thu thp d liu t my tnh trm c ci t trong my tnh trm
in. Phn mm ny c nhim v kt ni v nhn d liu t thit b o qua giao
thc RS232, x l, m ha v truyn d liu ln my ch trung tm. Ngoi chc
nng chnh, phn mm cn c thit k module lu tr d liu offline s dng h
qun tr CSDL MySQL, phng trng hp kt ni vi my ch trung tm b ngt,
m bo s ton vn ca d liu. D liu ny s c chuyn n my ch trung
tm ngay khi kt ni c thit lp li.

2. Phn mm my ch trung tm
Phn mm my ch trung tm c ci t my ch trung tm, c nhim v nhn
cc d liu t phn mm trm, gii m v lu tr d liu. Ngoi ra, phn mm my
ch trung tm cn cho php quan st d liu bng nhiu phng php khc nhau
phc v cc yu cu phn tch d liu: hin th gi tr tng thng s, hin th
th bin i, xut ra tp d liu (Excel, CSV). Phn mm my ch c thit k
lu tr d liu mt cch khoa hc, cho php hin th nhanh, thi gian thc, d dng
truy xut v in n. Ngi dng s truy cp n my ch trung tm qua giao thc
Web HTTP.

III.

M t cc tnh nng ca phn mm

1. Thu thp s liu t cc thit b trong h thng thng qua trm

ch
Cc thng s in c thu thp bng phn mm my tnh trm. Khi c khi
chy, chng trnh s qut cc cng COM c sn hin th ra mn hnh di dng
danh sch, ngi dng chn cng kt ni tng ng vi cng COM vt l kt ni vi

thit b. Khi kt ni c thit lp, chng trnh s t ng gi mt chui xc thc

xung thit b o v bt u ch d liu c gi ln t .
Khi nhn c d liu, phn mm s thc hin cc cng vic
-

Ti to li cc thng s (v1, v2, v3, a1, a2, a3, va, pf, hz, w, var, q) t cc
byte nhn c theo cng thc c thng nht
Kim tra li
Hin th ln mn hnh
M ha v gi ln my ch
Lu tr offline nu gp li ng truyn

Hnh 1:Phn mm my tnh trm thu thp d liu t thit b o thng minh

2. X l theo giao thc cng nghip

My ch trung tm s lm nhim v thu thp d liu c gi t my trm v x l
theo cc giao thc chun trong cng nghip. C th, my trm s kt ni vi my
ch qua giao thc TCP-IP trn mng Internet. Hai my s thng nht cc khung bn
tin v mt s phng php m ha, gii m m bo tnh bo mt, xc thc v

ton vn d liu. Trong phn mm ny, chng ti s dng phng php m ha

AES-CBC-256 v ch k in t MD5.
[Gi]
-

M ha cc thng s cn gi i bng thut ton AES-CBC-256 vi mt khu

dnh ring cho my tnh trm
Thm chui ch k in t vo cui bn tin bng cch chy hm MD5 cho
ton b d liu trc
Gi ln my ch

[Nhn]
-

c ID ca my tnh trm trong bn tin

Kim tra ch k in t xc thc ton vn ca bn tin
Ly mt khu gii m ca my trm c lu trong CSDL
Gii m
Lu vo CSDL
Hin th ln mn hnh giao din Web

Khung bn tin c truyn i

Device ID

Data (encrypted)

Digital Signature

3. Qun l s liu theo c s d liu NoSQL. H tr truy xut ra Excel

a. CSDL NoSQL - MongoDB
Phn mm my ch trung tm c chy trn c s h CSDL MongoDB.
MongoDB l mt c s d liu ti liu m ngun m, v c s d liu hng u
NoSQL. NoSQL c nhng c im ng ch sau
-

NoSQL lu tr d liu ca mnh theo dng cp gi tr key value.

S dng s lng ln cc node lu tr thng tin M hnh phn tn di s
kim sot phn mm, chp nhn d liu b trng lp do mt s node s lu
cng thng tin ging nhau
Phi quan h khng c rng buc no cho vic nht qun d liu
Tnh nht qun khng theo thi gian thc: Sau mi thay i CSDL, khng cn
tc ng ngay n tt c cc CSDL lin quan m c lan truyn theo thi
gian.

MongoDB l mt ti liu nh hng c s d liu a nn tng. Phn loi nh l mt

c s d liu NoSQL, MongoDB cng trnh cc cu trc c s d liu quan h da
trn bng truyn thng ng h ti liu JSON ging nh vi cc lc nng ng
(MongoDB gi cc nh dng BSON), lm cho vic tch hp cc d liu trong mt s
loi ng dng d dng hn v nhanh hn. c pht hnh di s kt hp ca Giy
php Cng cng GNU Affero General v Giy php Apache, MongoDB l phn mm
min ph v m ngun m.
Nh nhng c im trn, chng ti thy MongoDB rt ph hp vi cc ng dng
thu thp v truy xut d liu cm bin thi gian thc nh phn mm ny.

T , chng ti thit k cc Collection nh sau

-

Params: Lu tr record v cc thng s in ca 1 thit b ti 1 thi im

nht nh
Setting: Lu tr cc thng tin v 1 thit b: tn, ngng cnh bo cho tng
thng s

Params
_id
DeviceID
V1
V2
V3
A1
A2
A3
VA
PF
Hz
W
Var
Q
Setting
_id
DeviceID
Name
V1_min
V1_max
V2_min
V2_max
V3_min
V3_max
A1_min
A1_max
A2_min
A2_max
A3_min
A3_max
VA_min
VA_max
PF_min
PF_max
Hz_min
Hz_max
W_min
W_max
Var_min

Var_max
Q_min
Q_max

b. Truy xut d liu ra file excel

Trong nhiu trng hp, ngi dng mun s dng d liu thu thp c vo mc
ch nghin cu, phn tch d liu ln. V vy, phn mm c thit k truy xut
d liu di dng file excel, tr ra cc tp bao gm bng, vi mi bn ghi tng ng
1 hng.

Hnh 2. Tm kim d liu theo thi gian v cho php truy xut ra file (Download)

Hnh 3. Kiu d liu trong file Excel

4. Hin th thng tin dng ha

phc v cho vic gim st d liu mt cch trc quan, phn mm c cung cp
cc chc nng hin th thng tin dng ha. y, cc thng s s c hin th
ln cc bng trn giao din web. Thm na, theo di s thay i ca cc thng
s, phn mm c thm phn hin th dng th thi gian.

Hnh 4. Hin th ha dng bng thng s

Hnh 5. Hin th ha di dng th thi gian

5. Hin th thng tin dng th theo thi gian thc

Chc nng hin th thi gian thc l rt cn thit i vi cc ng dng thu thp d
liu t cm bin. iu ny gip cho ngi dng c th quan st trng thi hin ti
ca li in, nhn bit s c v a ra cc gii php kp thi khc phc. Chc
nng ny c thc thi trong phn mm s dng cng ngh SocketIO, ph hp
vi mi trng pht trin ng dng Web.

Hnh 6. Hin th d liu thi gian thc

6. Cho php t cc ngng cnh bo trn tng thit b c th

Ngi dng c th ci t cc ngng cnh bo trn tng thit b. Khi vt ngng,
h thng s gi cc cnh bo n ngi dng bng cch hin th trn giao din
cng nh gi email n ngi qun l.

Hnh 7. Ci t cc ngng cnh bo trn tng thit b c th

Hnh 8. Cnh bo ra mn hnh hin th (vin ) khi thng s vt ngng

7. Cho php ci t cc thng s truyn thng

Phn mm cn cho php ngi dng ci t cc thng s truyn thng di dng
cc file config, thay i cc kiu khung truyn ph hp vi tng thit b.