本(ben)發明涉(she)及金(jin)融(rong)科技(ji)領(ling)域(yu)或其他相關領(ling)域(yu),具體(ti)而言,涉(she)及一種數(shu)據倉庫的數(shu)據處理(li)方(fang)法、裝置、存儲介質及電子設備。
背景技術:
1、在金融機構各交易系(xi)統(tong)(tong)國產(chan)化改造(zao)過程(cheng)中,新舊(jiu)系(xi)統(tong)(tong)并發運行,同時(shi)產(chan)生數(shu)(shu)(shu)據(ju)文件(jian)下傳(chuan)數(shu)(shu)(shu)據(ju)倉庫(ku),在新系(xi)統(tong)(tong)未穩定前,數(shu)(shu)(shu)據(ju)倉庫(ku)需要只使用(yong)舊(jiu)系(xi)統(tong)(tong)的(de)文件(jian)數(shu)(shu)(shu)據(ju),且數(shu)(shu)(shu)據(ju)倉庫(ku)雖然接收新系(xi)統(tong)(tong)數(shu)(shu)(shu)據(ju)文件(jian),但不依賴(lai)于新系(xi)統(tong)(tong)文件(jian)的(de)下傳(chuan)。在新舊(jiu)系(xi)統(tong)(tong)切(qie)換的(de)情(qing)況下,數(shu)(shu)(shu)據(ju)倉庫(ku)也存在一個切(qie)源的(de)過程(cheng)。目(mu)前,相關技術(shu)中通過人工對數(shu)(shu)(shu)據(ju)倉庫(ku)的(de)數(shu)(shu)(shu)據(ju)來源進(jin)行切(qie)換,效率較低,且穩定性和可靠(kao)性較低。
2、針(zhen)對上述的(de)(de)問題,目前尚(shang)未提出(chu)有效的(de)(de)解決方(fang)案(an)。
技術實現思路
1、本發明實施例提供了一種數據(ju)倉庫的數據(ju)處理(li)方(fang)法、裝(zhuang)置、存(cun)儲介質及電子設備,以(yi)至(zhi)少(shao)解決現有(you)技術(shu)中(zhong)通(tong)過人工對數據(ju)倉庫的數據(ju)來源(yuan)進行切(qie)換,存(cun)在(zai)數據(ju)倉庫的切(qie)源(yuan)效(xiao)率(lv)較(jiao)低(di)的技術(shu)問題。
2、根據(ju)(ju)(ju)(ju)本發明實施例的(de)(de)(de)一(yi)(yi)(yi)個方(fang)面,提供了一(yi)(yi)(yi)種數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)倉(cang)庫(ku)(ku)的(de)(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)處理方(fang)法,包括:接收目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)交(jiao)(jiao)易(yi)(yi)系(xi)統(tong)發送的(de)(de)(de)目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)(jian),其中(zhong),目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)交(jiao)(jiao)易(yi)(yi)系(xi)統(tong)為以(yi)下至(zhi)少之一(yi)(yi)(yi):新交(jiao)(jiao)易(yi)(yi)系(xi)統(tong)、舊交(jiao)(jiao)易(yi)(yi)系(xi)統(tong),目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)(jian)為以(yi)下至(zhi)少之一(yi)(yi)(yi):新交(jiao)(jiao)易(yi)(yi)系(xi)統(tong)的(de)(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)(jian)、舊交(jiao)(jiao)易(yi)(yi)系(xi)統(tong)的(de)(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)(jian);基于目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)(jian)對(dui)應(ying)的(de)(de)(de)目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)加(jia)(jia)(jia)載作(zuo)(zuo)業將目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)(jian)中(zhong)的(de)(de)(de)交(jiao)(jiao)易(yi)(yi)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)映射至(zhi)目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)(jian)對(dui)應(ying)的(de)(de)(de)目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)表(biao),并(bing)(bing)基于目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)表(biao)創(chuang)建目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)表(biao)對(dui)應(ying)的(de)(de)(de)目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)視(shi)圖(tu);獲取開關表(biao),基于第(di)(di)一(yi)(yi)(yi)加(jia)(jia)(jia)載作(zuo)(zuo)業和開關表(biao)從目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)視(shi)圖(tu)中(zhong)確(que)定待進(jin)行數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)加(jia)(jia)(jia)載的(de)(de)(de)視(shi)圖(tu),并(bing)(bing)將待進(jin)行數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)加(jia)(jia)(jia)載的(de)(de)(de)視(shi)圖(tu)中(zhong)的(de)(de)(de)交(jiao)(jiao)易(yi)(yi)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)加(jia)(jia)(jia)載至(zhi)第(di)(di)一(yi)(yi)(yi)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)表(biao),其中(zhong),開關表(biao)用(yong)于確(que)定是(shi)否對(dui)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)倉(cang)庫(ku)(ku)的(de)(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)來源(yuan)進(jin)行切換,第(di)(di)一(yi)(yi)(yi)加(jia)(jia)(jia)載作(zuo)(zuo)業與(yu)目(mu)(mu)標(biao)(biao)(biao)(biao)(biao)加(jia)(jia)(jia)載作(zuo)(zuo)業在數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)倉(cang)庫(ku)(ku)中(zhong)對(dui)應(ying)不同的(de)(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)層。
3、進一(yi)(yi)步地,基(ji)于第一(yi)(yi)加(jia)載作(zuo)業(ye)和(he)開關(guan)表從目標視(shi)圖(tu)中確定(ding)待(dai)進行(xing)數據(ju)(ju)加(jia)載的視(shi)圖(tu),包括(kuo):基(ji)于第一(yi)(yi)加(jia)載作(zuo)業(ye)獲(huo)取當(dang)前日期(qi);對當(dang)前日期(qi)與開關(guan)表中的預設(she)日期(qi)進行(xing)比較,得到比較結(jie)果(guo),其中,預設(she)日期(qi)用于表征對數據(ju)(ju)倉庫的數據(ju)(ju)來(lai)源進行(xing)切換的日期(qi);依據(ju)(ju)比較結(jie)果(guo)從目標視(shi)圖(tu)中確定(ding)待(dai)進行(xing)數據(ju)(ju)加(jia)載的視(shi)圖(tu)。
4、進(jin)(jin)一步(bu)地,依(yi)據(ju)比較結果從(cong)目標視(shi)圖(tu)(tu)中(zhong)(zhong)(zhong)確(que)定(ding)(ding)(ding)待(dai)(dai)進(jin)(jin)行(xing)數(shu)(shu)據(ju)加(jia)載的(de)(de)視(shi)圖(tu)(tu),包括:依(yi)據(ju)比較結果從(cong)開關表中(zhong)(zhong)(zhong)確(que)定(ding)(ding)(ding)目標有效(xiao)(xiao)數(shu)(shu)據(ju),其中(zhong)(zhong)(zhong),目標有效(xiao)(xiao)數(shu)(shu)據(ju)用于表征(zheng)對數(shu)(shu)據(ju)進(jin)(jin)行(xing)處(chu)理的(de)(de)依(yi)據(ju);依(yi)據(ju)目標有效(xiao)(xiao)數(shu)(shu)據(ju)中(zhong)(zhong)(zhong)包含的(de)(de)目標標識(shi)信息從(cong)目標視(shi)圖(tu)(tu)中(zhong)(zhong)(zhong)確(que)定(ding)(ding)(ding)待(dai)(dai)進(jin)(jin)行(xing)數(shu)(shu)據(ju)加(jia)載的(de)(de)視(shi)圖(tu)(tu)。
5、進一(yi)步(bu)地(di),目(mu)標(biao)有(you)效(xiao)數(shu)據(ju)(ju)為以(yi)下之一(yi):第(di)(di)一(yi)條(tiao)(tiao)數(shu)據(ju)(ju)、第(di)(di)二條(tiao)(tiao)數(shu)據(ju)(ju),第(di)(di)一(yi)條(tiao)(tiao)數(shu)據(ju)(ju)與第(di)(di)二條(tiao)(tiao)數(shu)據(ju)(ju)指向的數(shu)據(ju)(ju)來源不同(tong),其中,依據(ju)(ju)比(bi)較(jiao)結果從開關表(biao)中確(que)定目(mu)標(biao)有(you)效(xiao)數(shu)據(ju)(ju),包括:若比(bi)較(jiao)結果表(biao)征(zheng)當前日期(qi)小(xiao)于預設日期(qi),則(ze)將(jiang)第(di)(di)一(yi)條(tiao)(tiao)數(shu)據(ju)(ju)作為目(mu)標(biao)有(you)效(xiao)數(shu)據(ju)(ju);若比(bi)較(jiao)結果表(biao)征(zheng)當前日期(qi)大于等于預設日期(qi),則(ze)將(jiang)第(di)(di)二條(tiao)(tiao)數(shu)據(ju)(ju)作為目(mu)標(biao)有(you)效(xiao)數(shu)據(ju)(ju)。
6、進(jin)一步地(di),目(mu)標(biao)(biao)(biao)標(biao)(biao)(biao)識(shi)信(xin)息(xi)(xi)為(wei)以(yi)下(xia)(xia)之一:新(xin)交(jiao)(jiao)易(yi)(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)(tong)(tong)標(biao)(biao)(biao)識(shi)信(xin)息(xi)(xi)、舊(jiu)交(jiao)(jiao)易(yi)(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)(tong)(tong)標(biao)(biao)(biao)識(shi)信(xin)息(xi)(xi),目(mu)標(biao)(biao)(biao)視(shi)(shi)圖(tu)為(wei)以(yi)下(xia)(xia)之一:新(xin)交(jiao)(jiao)易(yi)(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)文(wen)(wen)(wen)件對(dui)應的(de)(de)(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)表(biao)對(dui)應的(de)(de)(de)(de)(de)視(shi)(shi)圖(tu)、舊(jiu)交(jiao)(jiao)易(yi)(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)文(wen)(wen)(wen)件對(dui)應的(de)(de)(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)表(biao)對(dui)應的(de)(de)(de)(de)(de)視(shi)(shi)圖(tu),其中,依(yi)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)目(mu)標(biao)(biao)(biao)有效(xiao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)中包(bao)含的(de)(de)(de)(de)(de)目(mu)標(biao)(biao)(biao)標(biao)(biao)(biao)識(shi)信(xin)息(xi)(xi)從目(mu)標(biao)(biao)(biao)視(shi)(shi)圖(tu)中確(que)定待(dai)(dai)進(jin)行數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)加(jia)載(zai)的(de)(de)(de)(de)(de)視(shi)(shi)圖(tu),包(bao)括:若(ruo)目(mu)標(biao)(biao)(biao)有效(xiao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)為(wei)第(di)一條(tiao)(tiao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju),則依(yi)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)第(di)一條(tiao)(tiao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)中包(bao)含的(de)(de)(de)(de)(de)舊(jiu)交(jiao)(jiao)易(yi)(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)(tong)(tong)標(biao)(biao)(biao)識(shi)信(xin)息(xi)(xi)確(que)定待(dai)(dai)進(jin)行數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)加(jia)載(zai)的(de)(de)(de)(de)(de)視(shi)(shi)圖(tu)為(wei)舊(jiu)交(jiao)(jiao)易(yi)(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)文(wen)(wen)(wen)件對(dui)應的(de)(de)(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)表(biao)對(dui)應的(de)(de)(de)(de)(de)視(shi)(shi)圖(tu);若(ruo)目(mu)標(biao)(biao)(biao)有效(xiao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)為(wei)第(di)二條(tiao)(tiao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju),則依(yi)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)第(di)二條(tiao)(tiao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)中包(bao)含的(de)(de)(de)(de)(de)新(xin)交(jiao)(jiao)易(yi)(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)(tong)(tong)標(biao)(biao)(biao)識(shi)信(xin)息(xi)(xi)確(que)定待(dai)(dai)進(jin)行數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)加(jia)載(zai)的(de)(de)(de)(de)(de)視(shi)(shi)圖(tu)為(wei)新(xin)交(jiao)(jiao)易(yi)(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)文(wen)(wen)(wen)件對(dui)應的(de)(de)(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)(ju)表(biao)對(dui)應的(de)(de)(de)(de)(de)視(shi)(shi)圖(tu)。
7、進(jin)一(yi)(yi)步地,在接收目標(biao)(biao)交(jiao)易(yi)系(xi)統發送的目標(biao)(biao)數據文件之前,該方法還包括:構建新(xin)交(jiao)易(yi)系(xi)統表(biao)(biao)名(ming)字段(duan)(duan)、舊交(jiao)易(yi)系(xi)統表(biao)(biao)名(ming)字段(duan)(duan)、系(xi)統標(biao)(biao)識(shi)字段(duan)(duan)、開關(guan)指向(xiang)字段(duan)(duan)、開始日(ri)期字段(duan)(duan)、結束日(ri)期字段(duan)(duan)以及第一(yi)(yi)加(jia)載(zai)(zai)作(zuo)業(ye)的作(zuo)業(ye)名(ming)字段(duan)(duan),其中(zhong),開關(guan)指向(xiang)字段(duan)(duan)用(yong)于定義數據加(jia)載(zai)(zai)來源;依據新(xin)交(jiao)易(yi)系(xi)統表(biao)(biao)名(ming)字段(duan)(duan)、舊交(jiao)易(yi)系(xi)統表(biao)(biao)名(ming)字段(duan)(duan)、系(xi)統標(biao)(biao)識(shi)字段(duan)(duan)、開關(guan)指向(xiang)字段(duan)(duan)、開始日(ri)期字段(duan)(duan)、結束日(ri)期字段(duan)(duan)以及第一(yi)(yi)加(jia)載(zai)(zai)作(zuo)業(ye)的作(zuo)業(ye)名(ming)字段(duan)(duan)組成(cheng)開關(guan)表(biao)(biao);對開關(guan)表(biao)(biao)中(zhong)的字段(duan)(duan)進(jin)行參(can)數配(pei)置,生成(cheng)第一(yi)(yi)條(tiao)數據和第二條(tiao)數據。
8、進一(yi)步地,目(mu)(mu)(mu)標(biao)加(jia)(jia)(jia)載(zai)(zai)(zai)(zai)作(zuo)業(ye)為(wei)以(yi)下至少之一(yi):新(xin)(xin)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)加(jia)(jia)(jia)載(zai)(zai)(zai)(zai)作(zuo)業(ye)、舊(jiu)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)加(jia)(jia)(jia)載(zai)(zai)(zai)(zai)作(zuo)業(ye),目(mu)(mu)(mu)標(biao)數(shu)(shu)(shu)據(ju)(ju)(ju)表(biao)為(wei)以(yi)下至少之一(yi):新(xin)(xin)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)表(biao)、舊(jiu)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)表(biao),其中(zhong)(zhong),基于(yu)目(mu)(mu)(mu)標(biao)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)目(mu)(mu)(mu)標(biao)加(jia)(jia)(jia)載(zai)(zai)(zai)(zai)作(zuo)業(ye)將目(mu)(mu)(mu)標(biao)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)中(zhong)(zhong)的(de)(de)(de)(de)(de)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)數(shu)(shu)(shu)據(ju)(ju)(ju)映射至目(mu)(mu)(mu)標(biao)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)目(mu)(mu)(mu)標(biao)數(shu)(shu)(shu)據(ju)(ju)(ju)表(biao),包括:基于(yu)新(xin)(xin)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)加(jia)(jia)(jia)載(zai)(zai)(zai)(zai)作(zuo)業(ye)將新(xin)(xin)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)中(zhong)(zhong)的(de)(de)(de)(de)(de)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)數(shu)(shu)(shu)據(ju)(ju)(ju)映射至新(xin)(xin)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)表(biao);基于(yu)舊(jiu)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)加(jia)(jia)(jia)載(zai)(zai)(zai)(zai)作(zuo)業(ye)將舊(jiu)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)中(zhong)(zhong)的(de)(de)(de)(de)(de)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)數(shu)(shu)(shu)據(ju)(ju)(ju)映射至舊(jiu)交(jiao)(jiao)(jiao)(jiao)易(yi)(yi)系(xi)(xi)(xi)(xi)(xi)統(tong)(tong)(tong)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)(wen)(wen)(wen)件(jian)(jian)(jian)(jian)(jian)對(dui)(dui)(dui)(dui)應(ying)(ying)(ying)的(de)(de)(de)(de)(de)數(shu)(shu)(shu)據(ju)(ju)(ju)表(biao)。
9、根據(ju)(ju)(ju)(ju)本發明實(shi)施例的(de)(de)另一方面,還提(ti)供(gong)了(le)一種數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)倉庫(ku)的(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)處(chu)(chu)理裝置,包括:接收模塊,用于接收目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)交(jiao)易(yi)系(xi)統(tong)(tong)(tong)發送的(de)(de)目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian),其(qi)中(zhong)(zhong),目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)交(jiao)易(yi)系(xi)統(tong)(tong)(tong)為以(yi)(yi)下至(zhi)少之一:新(xin)交(jiao)易(yi)系(xi)統(tong)(tong)(tong)、舊交(jiao)易(yi)系(xi)統(tong)(tong)(tong),目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)為以(yi)(yi)下至(zhi)少之一:新(xin)交(jiao)易(yi)系(xi)統(tong)(tong)(tong)的(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)、舊交(jiao)易(yi)系(xi)統(tong)(tong)(tong)的(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian);處(chu)(chu)理模塊,用于基于目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)對應(ying)的(de)(de)目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)加(jia)(jia)(jia)載(zai)(zai)作(zuo)業將目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)中(zhong)(zhong)的(de)(de)交(jiao)易(yi)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)映射至(zhi)目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)文(wen)件(jian)(jian)對應(ying)的(de)(de)目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)表,并基于目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)表創建目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)表對應(ying)的(de)(de)目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)視圖(tu);確(que)定(ding)模塊,用于獲取開關表,基于第一加(jia)(jia)(jia)載(zai)(zai)作(zuo)業和開關表從目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)視圖(tu)中(zhong)(zhong)確(que)定(ding)待進(jin)行(xing)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)加(jia)(jia)(jia)載(zai)(zai)的(de)(de)視圖(tu),并將待進(jin)行(xing)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)加(jia)(jia)(jia)載(zai)(zai)的(de)(de)視圖(tu)中(zhong)(zhong)的(de)(de)交(jiao)易(yi)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)加(jia)(jia)(jia)載(zai)(zai)至(zhi)第一數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)表,其(qi)中(zhong)(zhong),開關表用于確(que)定(ding)是(shi)否對數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)倉庫(ku)的(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)來(lai)源(yuan)進(jin)行(xing)切換(huan),第一加(jia)(jia)(jia)載(zai)(zai)作(zuo)業與目(mu)(mu)(mu)(mu)標(biao)(biao)(biao)(biao)(biao)加(jia)(jia)(jia)載(zai)(zai)作(zuo)業在數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)倉庫(ku)中(zhong)(zhong)對應(ying)不同的(de)(de)數(shu)(shu)(shu)(shu)(shu)據(ju)(ju)(ju)(ju)層。
10、根據本發明實施例(li)的另(ling)一方面(mian),還提供了一種計(ji)算機程(cheng)序產品(pin),包括計(ji)算機程(cheng)序,計(ji)算機程(cheng)序在被(bei)處理器執行時(shi)實現上述(shu)的數據倉(cang)庫的數據處理方法(fa)。
11、根據本發(fa)明實施例的(de)另一方(fang)面,還提(ti)供了一種計(ji)(ji)算(suan)(suan)機(ji)(ji)可讀(du)存(cun)(cun)(cun)儲介(jie)(jie)質,該計(ji)(ji)算(suan)(suan)機(ji)(ji)可讀(du)存(cun)(cun)(cun)儲介(jie)(jie)質中存(cun)(cun)(cun)儲有計(ji)(ji)算(suan)(suan)機(ji)(ji)程序,其中,計(ji)(ji)算(suan)(suan)機(ji)(ji)程序被設置(zhi)為運行時執行上述的(de)數(shu)(shu)據倉庫(ku)的(de)數(shu)(shu)據處(chu)理方(fang)法。
12、根據(ju)本(ben)發(fa)明(ming)實施例的(de)(de)另一(yi)方面,還提供了一(yi)種(zhong)電(dian)子設備,該電(dian)子設備包(bao)括(kuo)一(yi)個(ge)(ge)或多(duo)個(ge)(ge)處(chu)理(li)器(qi);存儲器(qi),用于存儲一(yi)個(ge)(ge)或多(duo)個(ge)(ge)程(cheng)序(xu)(xu)(xu)(xu),當一(yi)個(ge)(ge)或多(duo)個(ge)(ge)程(cheng)序(xu)(xu)(xu)(xu)被(bei)(bei)一(yi)個(ge)(ge)或多(duo)個(ge)(ge)處(chu)理(li)器(qi)執(zhi)行時(shi),使得一(yi)個(ge)(ge)或多(duo)個(ge)(ge)處(chu)理(li)器(qi)實現用于運(yun)行程(cheng)序(xu)(xu)(xu)(xu),其中,程(cheng)序(xu)(xu)(xu)(xu)被(bei)(bei)設置為運(yun)行時(shi)執(zhi)行上述的(de)(de)數據(ju)倉庫的(de)(de)數據(ju)處(chu)理(li)方法。
13、在本發(fa)明實施例中(zhong)(zhong)(zhong),采用依據(ju)(ju)(ju)開(kai)關(guan)(guan)表(biao)(biao)確定數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)的(de)(de)(de)加載(zai)(zai)來(lai)源(yuan),實現對(dui)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)來(lai)源(yuan)的(de)(de)(de)自動(dong)切(qie)換(huan)的(de)(de)(de)方式,首先接收目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)交(jiao)易(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)發(fa)送的(de)(de)(de)目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)件(jian),其中(zhong)(zhong)(zhong),目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)交(jiao)易(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)為(wei)以下(xia)至(zhi)少之一(yi):新交(jiao)易(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)、舊(jiu)交(jiao)易(yi)(yi)(yi)系(xi)(xi)統(tong)(tong),目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)件(jian)為(wei)以下(xia)至(zhi)少之一(yi):新交(jiao)易(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)的(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)件(jian)、舊(jiu)交(jiao)易(yi)(yi)(yi)系(xi)(xi)統(tong)(tong)的(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)件(jian);基(ji)于目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)件(jian)對(dui)應(ying)(ying)的(de)(de)(de)目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)加載(zai)(zai)作(zuo)業將(jiang)目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)件(jian)中(zhong)(zhong)(zhong)的(de)(de)(de)交(jiao)易(yi)(yi)(yi)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)映射至(zhi)目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)文(wen)件(jian)對(dui)應(ying)(ying)的(de)(de)(de)目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)表(biao)(biao),并基(ji)于目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)表(biao)(biao)創建目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)表(biao)(biao)對(dui)應(ying)(ying)的(de)(de)(de)目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)視圖(tu);獲取開(kai)關(guan)(guan)表(biao)(biao),基(ji)于第一(yi)加載(zai)(zai)作(zuo)業和開(kai)關(guan)(guan)表(biao)(biao)從(cong)目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)視圖(tu)中(zhong)(zhong)(zhong)確定待進(jin)行(xing)(xing)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)加載(zai)(zai)的(de)(de)(de)視圖(tu),并將(jiang)待進(jin)行(xing)(xing)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)加載(zai)(zai)的(de)(de)(de)視圖(tu)中(zhong)(zhong)(zhong)的(de)(de)(de)交(jiao)易(yi)(yi)(yi)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)加載(zai)(zai)至(zhi)第一(yi)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)表(biao)(biao),其中(zhong)(zhong)(zhong),開(kai)關(guan)(guan)表(biao)(biao)用于確定是否對(dui)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)倉庫的(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)來(lai)源(yuan)進(jin)行(xing)(xing)切(qie)換(huan),第一(yi)加載(zai)(zai)作(zuo)業與目(mu)(mu)(mu)標(biao)(biao)(biao)(biao)加載(zai)(zai)作(zuo)業在數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)倉庫中(zhong)(zhong)(zhong)對(dui)應(ying)(ying)不同的(de)(de)(de)數(shu)(shu)(shu)(shu)據(ju)(ju)(ju)層。
14、在上(shang)述過(guo)程中(zhong),通過(guo)創建目標(biao)數據(ju)(ju)表對應的目標(biao)視圖,為通過(guo)加(jia)(jia)載視圖實現數據(ju)(ju)加(jia)(jia)載提供了(le)(le)基(ji)礎,從(cong)而(er)降低(di)了(le)(le)數據(ju)(ju)倉(cang)庫(ku)與上(shang)游系統的耦合,降低(di)了(le)(le)各模塊(kuai)之間的關聯程度,通過(guo)基(ji)于(yu)第一(yi)加(jia)(jia)載作業和(he)(he)開關表從(cong)目標(biao)視圖中(zhong)確定待進行數據(ju)(ju)加(jia)(jia)載的視圖,實現了(le)(le)對數據(ju)(ju)倉(cang)庫(ku)的數據(ju)(ju)來源(yuan)的自(zi)動切換,節省(sheng)了(le)(le)時間成本和(he)(he)人力成本,提高了(le)(le)數據(ju)(ju)倉(cang)庫(ku)的切源(yuan)效率,并且(qie),提高了(le)(le)切源(yuan)穩定性(xing)和(he)(he)可靠(kao)性(xing)。
15、由此可見,通過本發明(ming)的(de)(de)技術(shu)(shu)(shu)方(fang)案,達到(dao)了(le)(le)(le)數(shu)據(ju)倉庫(ku)低耦合自動(dong)化切(qie)源(yuan)(yuan)(yuan)的(de)(de)目的(de)(de),從而實現(xian)(xian)了(le)(le)(le)提高(gao)數(shu)據(ju)倉庫(ku)的(de)(de)切(qie)源(yuan)(yuan)(yuan)效(xiao)率的(de)(de)技術(shu)(shu)(shu)效(xiao)果(guo),進(jin)而解決了(le)(le)(le)現(xian)(xian)有(you)技術(shu)(shu)(shu)中通過人工對數(shu)據(ju)倉庫(ku)的(de)(de)數(shu)據(ju)來源(yuan)(yuan)(yuan)進(jin)行切(qie)換,存在數(shu)據(ju)倉庫(ku)的(de)(de)切(qie)源(yuan)(yuan)(yuan)效(xiao)率較低的(de)(de)技術(shu)(shu)(shu)問(wen)題(ti)。