文(wen)章(zhang)來(lai)源:中國航空集團公司 發布時間(jian):2010-12-14
由中(zhong)國航(hang)(hang)(hang)(hang)空集(ji)團(tuan)公司(si)自主開發的(de)(de)“中(zhong)航(hang)(hang)(hang)(hang)集(ji)團(tuan)節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)數(shu)(shu)(shu)據(ju)庫管(guan)(guan)理系(xi)統(tong)(tong)”已(yi)于(yu)日前(qian)完(wan)(wan)成,現已(yi)在中(zhong)航(hang)(hang)(hang)(hang)集(ji)團(tuan)內各(ge)二級(ji)企(qi)業安(an)裝使(shi)用。過去,中(zhong)航(hang)(hang)(hang)(hang)集(ji)團(tuan)及所屬(shu)企(qi)業節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)數(shu)(shu)(shu)據(ju)統(tong)(tong)計(ji)和分(fen)(fen)析(xi)均采用EXCEL表格方式進行,數(shu)(shu)(shu)據(ju)的(de)(de)安(an)全(quan)性和關(guan)聯性差(cha)(cha),數(shu)(shu)(shu)據(ju)存儲分(fen)(fen)散,只能(neng)(neng)(neng)(neng)(neng)進行一(yi)些(xie)較為(wei)簡(jian)單的(de)(de)查(cha)詢、統(tong)(tong)計(ji)和分(fen)(fen)析(xi),并且耗時耗力,易(yi)出差(cha)(cha)錯,工(gong)作(zuo)(zuo)效(xiao)率(lv)較低(di)。新的(de)(de)節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)管(guan)(guan)理數(shu)(shu)(shu)據(ju)庫以(yi)VBA+SQL為(wei)開發語言,除了具備國資委(wei)對(dui)中(zhong)央企(qi)業要求的(de)(de)相關(guan)統(tong)(tong)計(ji)監(jian)(jian)測內容外,還增加了許多(duo)行業特色(se)功(gong)能(neng)(neng)(neng)(neng)(neng),可對(dui)總部、子公司(si)、分(fen)(fen)公司(si)、營業部等不同層級(ji)的(de)(de)相關(guan)數(shu)(shu)(shu)據(ju)進行數(shu)(shu)(shu)十種類型的(de)(de)查(cha)詢、統(tong)(tong)計(ji)和分(fen)(fen)析(xi),能(neng)(neng)(neng)(neng)(neng)夠自動計(ji)算出企(qi)業的(de)(de)節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)量、節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)金額(e)、減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)量,對(dui)企(qi)業節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)考核指標的(de)(de)完(wan)(wan)成情況實時跟蹤(zong)管(guan)(guan)理,同時能(neng)(neng)(neng)(neng)(neng)夠對(dui)系(xi)統(tong)(tong)數(shu)(shu)(shu)據(ju)的(de)(de)異常波動予以(yi)識別示警。數(shu)(shu)(shu)據(ju)庫系(xi)統(tong)(tong)的(de)(de)數(shu)(shu)(shu)據(ju)導出、導入功(gong)能(neng)(neng)(neng)(neng)(neng)確保了各(ge)層級(ji)單位節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)數(shu)(shu)(shu)據(ju)的(de)(de)共享,避免了數(shu)(shu)(shu)據(ju)的(de)(de)重復(fu)錄入。節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)管(guan)(guan)理數(shu)(shu)(shu)據(ju)庫的(de)(de)投入使(shi)用,將(jiang)會對(dui)中(zhong)航(hang)(hang)(hang)(hang)集(ji)團(tuan)完(wan)(wan)善節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)監(jian)(jian)測、統(tong)(tong)計(ji)和分(fen)(fen)析(xi)工(gong)作(zuo)(zuo)、提升工(gong)作(zuo)(zuo)效(xiao)率(lv)、細(xi)化節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)管(guan)(guan)理發揮(hui)重要的(de)(de)推動作(zuo)(zuo)用,標志著中(zhong)航(hang)(hang)(hang)(hang)集(ji)團(tuan)節(jie)(jie)(jie)能(neng)(neng)(neng)(neng)(neng)減(jian)(jian)(jian)排(pai)(pai)(pai)(pai)(pai)信息(xi)化管(guan)(guan)理水平(ping)躍(yue)上一(yi)個新臺階。