CN106021349A - A foreign exchange data submitting method and device - Google Patents
A foreign exchange data submitting method and device Download PDFInfo
- Publication number
- CN106021349A CN106021349A CN201610302648.3A CN201610302648A CN106021349A CN 106021349 A CN106021349 A CN 106021349A CN 201610302648 A CN201610302648 A CN 201610302648A CN 106021349 A CN106021349 A CN 106021349A
- Authority
- CN
- China
- Prior art keywords
- data
- foreign exchange
- business datum
- foreign
- newly
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24562—Pointer or reference processing operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a foreign exchange data submitting method and device. The method comprises the steps of obtaining newly-added business data associated with foreign exchange; comparing the business data associated with foreign exchange with preset data warehouse layer data; keeping business data with the data dictionary parameter changed as newly-added foreign exchange business data; generating a report according to the newly-added foreign exchange business data and submitting the report to the administration of foreign exchange. Before generating a report according to mapping rules, the method first compares business data associated with foreign exchange with preset data warehouse layer data; only the data with the data dictionary parameter changed are truly-added foreign exchange business data; only the business data with the data dictionary parameter changed are kept and the business data with the data dictionary parameter unchanged are removed, so that the business data quantity processed by the mapping rules is reduced and standard report generating efficiency is increased.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to method and dress that a kind of foreign exchange data are reported and submitted
Put.
Background technology
Along with China's expanding economy, the opening of capital, foreign currency operation gets more and more, and government is also to foreign exchange
Supervision increasingly pay attention to, the ageing requirement to reporting and submitting foreign exchange data is more and more higher.People's Bank of China
Require that each big bank before 9, reported and submitted the knot of the previous day at second day according to the interface specification of the Administration of Foreign Exchange
Sell foreign exchange data.
Bank according to the requirement of the Administration of Foreign Exchange, using the business datum relevant to foreign exchange newly-increased every day as
Data source, sets up mapping ruler and business datum carries out screening processing, according to the foreign exchange industry of the Administration of Foreign Exchange
Business data standard generates the form of specification, by report submitting to the Administration of Foreign Exchange.Due to every day newly-increased with
The business datum amount that foreign exchange is relevant is very big, and mapping ruler is complicated, and the time generating specification form is long, is difficult to
Meet the timeliness requirement of the Administration of Foreign Exchange.
Summary of the invention
Present invention solves the technical problem that and be to provide a kind of foreign exchange datagram delivery method and device, thus
The quantity of the foreign currency operation data utilizing mapping ruler screening processing can be reduced, improve and generate specification report
The efficiency of table.
To this end, the technical scheme that the present invention solves technical problem is:
A kind of method that foreign exchange data are reported and submitted, described method includes:
Obtain the business datum that newly-increased foreign exchange is relevant；
The data of business datum relevant for described foreign exchange with the data warehouse layer preset are compared, retains
The business datum that data dictionary parameter changes is as newly-increased foreign currency operation data, described data warehouse layer
Data are the foreign currency operation data that all data dictionary parameters of historical storage change, described data word
Allusion quotation parameter is the parameter that the foreign currency operation data acquisition platform interface specification of the Administration of Foreign Exchange requires middle regulation；
According to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange.
Optionally, described method also includes:
Described newly-increased foreign currency operation data are stored to described data warehouse layer.
Optionally, described method also includes:
Extract the major key of described newly-increased foreign currency operation data；
The most described according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange it is:
Data genaration report submitting according to described major key and described data warehouse layer is to the Administration of Foreign Exchange.
Optionally, described method also includes:
Retain the business datum work meeting default foreign exchange data type in the business datum that described foreign exchange is relevant
The business datum required for interface specification, described foreign exchange data type is the foreign exchange industry according to the Administration of Foreign Exchange
Business data acquisition platform interface specification requires default；
The most described business datum that described foreign exchange is relevant compares with the data of the data warehouse layer preset
For:
The business datum required by described interface specification compares with the data of the data warehouse layer preset.
Optionally, described method also includes:
Described newly-increased foreign currency operation data are divided into many parts of business datums according to preset rules；
The most described according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange it is:
Many parts of business datum parallel processings are generated report submitting to the Administration of Foreign Exchange.
The device that a kind of foreign exchange data are reported and submitted, described device includes:
Acquisition module, for obtaining the business datum that newly-increased foreign exchange is relevant；
Comparison module, for the data of the business datum that described foreign exchange is relevant with the data warehouse layer preset
Compare, retain the business datum that changes of data dictionary parameter as newly-increased foreign currency operation data,
Described data warehouse layer data is the foreign currency operation number that all data dictionary parameters of historical storage change
According to, described data dictionary parameter is the foreign currency operation data acquisition platform interface specification requirement of the Administration of Foreign Exchange
The parameter of middle regulation；
Generation module, is used for according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange.
Optionally, described device also includes:
Memory module, for storing described newly-increased foreign currency operation data to described data warehouse layer.
Optionally, described device also includes:
Extraction module, for extracting the major key of described newly-increased foreign currency operation data；
The most described generation module, for according to described major key and the data genaration form of described data warehouse layer
Report and submit to the Administration of Foreign Exchange.
Optionally, described device also includes:
Reservation module, meets default foreign exchange data class for retaining in the business datum that described foreign exchange is relevant
The business datum that the business datum of type requires as interface specification, described foreign exchange data type is according to foreign exchange
The foreign currency operation data acquisition platform interface specification of management board requires default；
The most described comparison module, for the business datum required by described interface specification and the data bins preset
The data of storehouse layer compare.
Optionally, described device also includes:
Divide module, for described newly-increased foreign currency operation data are divided into many parts of business according to preset rules
Data；
The most described generation module, for generating report submitting to outer header by many parts of business datum parallel processings
Reason office.
By technique scheme, the method have the advantages that:
The invention provides the method and device that a kind of foreign exchange data are reported and submitted, obtain what newly-increased foreign exchange was correlated with
Business datum；The data of business datum relevant for described foreign exchange with the data warehouse layer preset are compared,
The business datum that reservation data dictionary parameter changes is as newly-increased foreign currency operation data, described data bins
Storehouse layer data is the business datum that all data dictionary parameters of historical storage change, described data word
Allusion quotation parameter is the parameter that the foreign currency operation data acquisition platform interface specification of the Administration of Foreign Exchange requires middle regulation；
According to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange.Utilizing mapping ruler raw
Before becoming form, first the data of business datum relevant for described foreign exchange with default data warehouse layer are compared
Relatively, the data that numeral dictionary parameter changes are only the foreign currency operation data of true increase, an encumbrance
The business datum changed according to dictionary parameter, rejects the business datum that data dictionary parameter does not changes,
Reduce the business datum amount that mapping ruler processes, improve the efficiency generating specification form.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to reality
Execute the required accompanying drawing used in example or description of the prior art to be briefly described, it should be apparent that below,
Accompanying drawing in description is only some embodiments of the present invention, for those of ordinary skill in the art,
On the premise of not paying creative work, it is also possible to obtain other accompanying drawing according to these accompanying drawings.
The method example flow chart that Fig. 1 reports and submits for a kind of foreign exchange data that the embodiment of the present invention provides；
Another example flow chart of method that Fig. 2 reports and submits for a kind of foreign exchange data that the embodiment of the present invention provides；
The device exemplary construction schematic diagram that Fig. 3 reports and submits for a kind of foreign exchange data that the embodiment of the present invention provides；
Another exemplary construction of device signal that Fig. 4 reports and submits for a kind of foreign exchange data that the embodiment of the present invention provides
Figure.
Detailed description of the invention
Report and submit the implementation of efficiency in order to provide raising foreign exchange data, embodiments provide one
The preferred embodiments of the present invention are entered by the method and device that foreign exchange data are reported and submitted below in conjunction with Figure of description
Row explanation.
Embodiment one
The method example flow chart that Fig. 1 reports and submits for a kind of foreign exchange data that the embodiment of the present invention provides, described
Method includes:
101: obtain the business datum that newly-increased foreign exchange is relevant.
Bank all can process substantial amounts of business every day, produces substantial amounts of business datum, wherein, a part of industry
Business data are the business datums relevant to foreign exchange.According to the regulation of the Administration of Foreign Exchange, bank every day will be by
Foreign currency operation data are reported and submitted in as requested.By SQLLDR by business datum relevant for the foreign exchange newly-increased every day
Operation data storage (Operational Data Store, the ODS) layer being recorded in data base, as dividing
The source data of analysis.
102: the data of business datum relevant for described foreign exchange with the data warehouse layer preset are compared,
The business datum that reservation data dictionary parameter changes is as newly-increased foreign currency operation data, described data bins
Storehouse layer data is the business datum that all data dictionary parameters of historical storage change, described data word
Allusion quotation parameter is the parameter that the foreign currency operation data acquisition platform interface specification of the Administration of Foreign Exchange requires middle regulation.
In the foreign currency operation data acquisition platform interface specification of the Administration of Foreign Exchange, regulation has data dictionary parameter,
The Administration of Foreign Exchange only focuses on produced business datum when the data dictionary parameter of defined changes.?
In foreign exchange associated traffic data in ODS layer, a part of foreign exchange associated traffic data is to be joined by data dictionary
Number change produces, the foreign currency operation data that i.e. Administration of Foreign Exchange is paid close attention to；Another part foreign exchange is correlated with industry
Business data, are not produced by data dictionary Parameters variation, the foreign exchange industry that the Bu Shi Administration of Foreign Exchange is paid close attention to
Business data.
Data warehouse (Data Warehouse, DW) layer storage have data dictionary parameter to change after institute
The all of foreign currency operation data produced.The data of the data of ODS layer with DW layer are compared, protects
Stay the business datum that data dictionary parameter changes as newly-increased foreign currency operation data, i.e. retain outer header
The foreign currency operation data that reason office is paid close attention to, reject the business datum that data dictionary parameter does not changes.
103: according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange.
There is the mapping ruler arranged according to the interface specification of the Administration of Foreign Exchange in each bank, utilizes and maps rule
Then it is analyzed newly-increased foreign currency operation data processing, generates form.In prior art, utilize and map rule
Then analyze is the business datum that foreign exchange is relevant, i.e. the business datum of ODS layer, and data volume is big, causes raw
The efficiency becoming form is low.In the present invention, reject the business that in ODS layer, data dictionary parameter does not changes
Data, only retain the business datum that data dictionary parameter changes, utilize the business that mapping ruler is analyzed
Data reduce, and improve the efficiency generating form.
When implementing, described method also includes:
Described newly-increased foreign currency operation data are stored to described data warehouse layer.
After every secondary acquisition increases foreign currency operation data newly, it is required for storing to institute newly-increased foreign currency operation data
State data warehouse layer, update the foreign currency operation data in described data warehouse layer, in order to as dividing next time
The history foreign currency operation data of the business datum that analysis foreign exchange is relevant.
When implementing, optionally, described method also includes:
Extract the major key of described newly-increased foreign currency operation data；
The most described according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange it is:
Data genaration report submitting according to described major key and described data warehouse layer is to the Administration of Foreign Exchange.
The data of business datum relevant for described foreign exchange with the data warehouse layer preset are compared, retains
After the business datum that data dictionary parameter changes is as newly-increased foreign currency operation data, can directly store
Newly-increased foreign currency operation data, it is also possible to extract the major key of described newly-increased foreign currency operation data, only store master
Key generates incremental layer (Increase) data.The major key of the newly-increased foreign currency operation data of storage is new with directly storage
Increase foreign currency operation data to compare, the memory space needed for minimizing.
When implementing, optionally, described method also includes:
Described newly-increased foreign currency operation data are divided into many parts of business datums according to preset rules；
The most described according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange it is:
Many parts of business datum parallel processings are generated report submitting to the Administration of Foreign Exchange.
Described preset rules includes region zones, and type of transaction divides, and be correlated with nationality's division etc. of foreign exchange is multiple
Any one or more in division rule.Newly-increased foreign currency operation data are divided into many according to preset rules
Many parts of business datums are utilized mapping ruler parallel processing by part business datum, improve further and generate form
Efficiency.
Embodiment two
Another example flow chart of method that Fig. 2 reports and submits for a kind of foreign exchange data that the embodiment of the present invention provides,
Embodiment two is distinguished as with embodiment one, in the business datum that described foreign exchange is relevant and the data preset
Before the data of depot layer compare, the business datum that the increase described foreign exchange of reservation is relevant meet default
The step of the business datum that the business datum of foreign exchange data type requires as interface specification, described method bag
Include:
201: obtain the business datum that newly-increased foreign exchange is relevant.
202: retain the business number meeting default foreign exchange data type in the business datum that described foreign exchange is relevant
According to the business datum required as interface specification, described foreign exchange data type is according to outside the Administration of Foreign Exchange
Converge what service data acquisition platform interface code requirement was preset.
Retain the business datum meeting default foreign exchange data type in the business datum that described foreign exchange is relevant,
It is to retain customer type in the business datum that described foreign exchange is relevant, outside type of transaction and Account Type meet
The business datum that the foreign currency operation data acquisition platform interface specification of management board that converges requires.
Such as, filtering according to the nationality of client, only storage customer type is the business datum of foreign nationality client；
Filter according to the post number related to, only the noble metal transaction data in storage foreign currency operation data；
Filtering according to the account data relating to adjusting code, individual's account information is according to adjusting code, only outside storage
Remittance business datum.
The business datum that foreign exchange is relevant is carried out first step filtration, in the business datum that rejecting foreign exchange is relevant not
Meet the business datum of default foreign exchange data type, only retain the industry meeting default foreign exchange data type
Business data.As such, it is possible to reduce the business datum that compares with the data of data warehouse layer preset
Quantity, improves the speed finding newly-increased foreign exchange data, improves the efficiency generating form further.
203: the business datum required by described interface specification compares with the data of default data warehouse layer
Relatively, the business datum that reservation data dictionary parameter changes is as newly-increased foreign currency operation data, described number
The foreign currency operation data changed according to all data dictionary parameters that depot layer data are historical storage, institute
State the foreign currency operation data acquisition platform interface specification that data dictionary parameter is the Administration of Foreign Exchange and require middle regulation
Parameter.
Step 203 is similar with step 102 implementation in embodiment one, retouching of reference example one
State, repeat no more here.Step 203 differs only in step 102, with default data warehouse
The amount of the business datum that the data of layer compare is different.The business that described interface specification in step 203 requires
Data are business datum a portions that the described foreign exchange in step 102 is relevant.
The business datum required by described interface specification compares with the data of the data warehouse layer preset,
In the business datum that described interface specification requires, eliminate and do not met default foreign exchange data type
Business datum, the business datum amount compared with the data of default data warehouse layer reduces, and improves ratio
Speed relatively, quickly obtains newly-increased foreign currency operation data.
204: described newly-increased foreign currency operation data are stored to described data warehouse layer.
After every secondary acquisition increases foreign currency operation data newly, it is required for storing to institute newly-increased foreign currency operation data
State data warehouse layer, update the foreign currency operation data in described data warehouse layer, in order to as dividing next time
The history foreign currency operation data of the business datum that analysis foreign exchange is relevant.
205: extract the major key of described newly-increased foreign currency operation data.
Extracting the major key of described newly-increased foreign currency operation data, only storage major key generates incremental layer (Increase)
Data.Compared with the major key foreign currency operation data newly-increased with directly storage of the newly-increased foreign currency operation data of storage, subtract
Few required memory space.
206: according to the data genaration report submitting of described major key and described data warehouse layer to exchange control
Office.
Major key is unique mark identifying newly-increased foreign currency operation data, can be from described number according to major key
According to depot layer data search to storage newly-increased foreign currency operation data.According to default mapping ruler, logical
Cross major key and find newly-increased foreign currency operation data, generate report submitting to the Administration of Foreign Exchange.
Embodiment two is compared with embodiment one, and embodiment two performs twice filtration.Filter for the first time, by
The business datum that foreign exchange is relevant obtains the business datum that interface specification requires, rejects the business number that foreign exchange is relevant
The business datum of default foreign exchange data type is not met according to；Second time filters, by interface specification requirement
Business datum obtain newly-increased foreign currency operation data, reject what described data dictionary parameter did not change
Business datum.After twice filtration, the newly-increased foreign currency operation data volume of gained is few, according to default mapping ruler
Generate time minimizing required during form, improve the efficiency generating form.
When implementing, optionally, described method also includes:
Described newly-increased foreign currency operation data are divided into many parts of business datums according to preset rules；
The most described according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange it is:
Many parts of business datum parallel processings are generated report submitting to the Administration of Foreign Exchange.
Described preset rules includes region zones, and type of transaction divides, and be correlated with nationality's division etc. of foreign exchange is multiple
Any one or more in division rule.Newly-increased foreign currency operation data are divided into many according to preset rules
Many parts of business datums are utilized mapping ruler parallel processing by part business datum, improve further and generate form
Efficiency.
Embodiment three
The device exemplary construction schematic diagram that Fig. 3 reports and submits for a kind of foreign exchange data that the embodiment of the present invention provides,
Device shown in Fig. 3 is and the device corresponding to the method shown in Fig. 1, and described device includes:
Acquisition module 301, for obtaining the business datum that newly-increased foreign exchange is relevant.
Comparison module 302, for the number of the business datum that described foreign exchange is relevant with the data warehouse layer preset
According to comparing, retain the business datum that changes of data dictionary parameter as newly-increased foreign currency operation data,
Described data warehouse layer data is the foreign currency operation number that all data dictionary parameters of historical storage change
According to, described data dictionary parameter is the foreign currency operation data acquisition platform interface specification requirement of the Administration of Foreign Exchange
The parameter of middle regulation.
Generation module 303, is used for according to described newly-increased foreign currency operation data genaration report submitting to exchange control
Office.
Optionally, described device also includes:
Memory module, for storing described newly-increased foreign currency operation data to described data warehouse layer.
Optionally, described device also includes:
Extraction module, for extracting the major key of described newly-increased foreign currency operation data；
The most described generation module, for according to described major key and the data genaration form of described data warehouse layer
Report and submit to the Administration of Foreign Exchange.
Optionally, described device also includes:
Divide module, for described newly-increased foreign currency operation data are divided into many parts of business according to preset rules
Data；
The most described generation module, for generating report submitting to outer header by many parts of business datum parallel processings
Reason office.
Device shown in Fig. 3 is and the device corresponding to the method shown in Fig. 1, specific implementation method and Fig. 1
Shown method is similar to, and with reference to the description of the method shown in Fig. 1, repeats no more here.
Embodiment four
Another exemplary construction of device signal that Fig. 4 reports and submits for a kind of foreign exchange data that the embodiment of the present invention provides
Figure, the device shown in Fig. 4 is and the device corresponding to the method shown in Fig. 2, and described device includes:
Acquisition module 401, for obtaining the business datum that newly-increased foreign exchange is relevant.
Reservation module 402, meets default foreign exchange data for retaining in the business datum that described foreign exchange is relevant
The business datum that the business datum of type requires as interface specification, described foreign exchange data type is according to outward
The foreign currency operation data acquisition platform interface specification of remittance management board requires default.
Comparison module 403, for the business datum required by described interface specification and the data warehouse layer preset
Data compare, retain the business datum that changes of data dictionary parameter as newly-increased foreign currency operation
Data, described data warehouse layer data is the foreign exchange that all data dictionary parameters of historical storage change
Business datum, described data dictionary parameter is the foreign currency operation data acquisition platform interface rule of the Administration of Foreign Exchange
The parameter that model specifies in requiring.
Memory module 404, for storing described newly-increased foreign currency operation data to described data warehouse layer.
Extraction module 405, for extracting the major key of described newly-increased foreign currency operation data.
Generation module 406, for according to described major key and the data genaration report submitting of described data warehouse layer
To the Administration of Foreign Exchange.
Optionally, described device also includes:
Divide module, for described newly-increased foreign currency operation data are divided into many parts of business according to preset rules
Data；
The most described generation module, for generating report submitting to outer header by many parts of business datum parallel processings
Reason office.
Device shown in Fig. 4 is and the device corresponding to the method shown in Fig. 2, specific implementation method and Fig. 2
Shown method is similar to, and with reference to the description of the method shown in Fig. 2, repeats no more here.
The above is only the preferred embodiment of the present invention, it is noted that for the art
For those of ordinary skill, under the premise without departing from the principles of the invention, it is also possible to make some improvement
And retouching, these improvements and modifications also should be regarded as protection scope of the present invention.
Claims (10)
1. the method that foreign exchange data are reported and submitted, it is characterised in that described method includes:
Obtain the business datum that newly-increased foreign exchange is relevant；
The data of business datum relevant for described foreign exchange with the data warehouse layer preset are compared, retains
The business datum that data dictionary parameter changes is as newly-increased foreign currency operation data, described data warehouse layer
Data are the foreign currency operation data that all data dictionary parameters of historical storage change, described data word
Allusion quotation parameter is the parameter that the foreign currency operation data acquisition platform interface specification of the Administration of Foreign Exchange requires middle regulation；
According to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange.
Method the most according to claim 1, it is characterised in that described method also includes:
Described newly-increased foreign currency operation data are stored to described data warehouse layer.
Method the most according to claim 2, it is characterised in that described method also includes:
Extract the major key of described newly-increased foreign currency operation data；
The most described according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange it is:
Data genaration report submitting according to described major key and described data warehouse layer is to the Administration of Foreign Exchange.
4. according to the method described in claim 1-3 any one, it is characterised in that described method is also wrapped
Include:
Retain the business datum work meeting default foreign exchange data type in the business datum that described foreign exchange is relevant
The business datum required for interface specification, described foreign exchange data type is the foreign exchange industry according to the Administration of Foreign Exchange
Business data acquisition platform interface specification requires default；
The most described business datum that described foreign exchange is relevant compares with the data of the data warehouse layer preset
For:
The business datum required by described interface specification compares with the data of the data warehouse layer preset.
Method the most according to claim 4, it is characterised in that described method also includes:
Described newly-increased foreign currency operation data are divided into many parts of business datums according to preset rules；
The most described according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange it is:
Many parts of business datum parallel processings are generated report submitting to the Administration of Foreign Exchange.
6. the device that foreign exchange data are reported and submitted, it is characterised in that described device includes:
Acquisition module, for obtaining the business datum that newly-increased foreign exchange is relevant；
Comparison module, for the data of the business datum that described foreign exchange is relevant with the data warehouse layer preset
Compare, retain the business datum that changes of data dictionary parameter as newly-increased foreign currency operation data,
Described data warehouse layer data is the foreign currency operation number that all data dictionary parameters of historical storage change
According to, described data dictionary parameter is the foreign currency operation data acquisition platform interface specification requirement of the Administration of Foreign Exchange
The parameter of middle regulation；
Generation module, is used for according to described newly-increased foreign currency operation data genaration report submitting to the Administration of Foreign Exchange.
Device the most according to claim 6, it is characterised in that described device also includes:
Memory module, for storing described newly-increased foreign currency operation data to described data warehouse layer.
Device the most according to claim 7, it is characterised in that described device also includes:
Extraction module, for extracting the major key of described newly-increased foreign currency operation data；
The most described generation module, for according to described major key and the data genaration form of described data warehouse layer
Report and submit to the Administration of Foreign Exchange.
9. according to the device described in claim 6-8 any one, it is characterised in that described device also wraps
Include:
Reservation module, meets default foreign exchange data class for retaining in the business datum that described foreign exchange is relevant
The business datum that the business datum of type requires as interface specification, described foreign exchange data type is according to foreign exchange
The foreign currency operation data acquisition platform interface specification of management board requires default；
The most described comparison module, for the business datum required by described interface specification and the data bins preset
The data of storehouse layer compare.
Device the most according to claim 9, it is characterised in that described device also includes:
Divide module, for described newly-increased foreign currency operation data are divided into many parts of business according to preset rules
Data；
The most described generation module, for generating report submitting to outer header by many parts of business datum parallel processings
Reason office.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610302648.3A CN106021349A (en) | 2016-05-09 | 2016-05-09 | A foreign exchange data submitting method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610302648.3A CN106021349A (en) | 2016-05-09 | 2016-05-09 | A foreign exchange data submitting method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106021349A true CN106021349A (en) | 2016-10-12 |
Family
ID=57099189
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610302648.3A Pending CN106021349A (en) | 2016-05-09 | 2016-05-09 | A foreign exchange data submitting method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106021349A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107784578A (en) * | 2017-11-22 | 2018-03-09 | 中国银行股份有限公司 | Bank's foreign exchange data monitoring and managing method and device |
| CN112650744A (en) * | 2020-12-31 | 2021-04-13 | 广州晟能软件科技有限公司 | Data management method for preventing secondary pollution of data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103595807A (en) * | 2013-11-20 | 2014-02-19 | 中国银行股份有限公司 | Data synchronous updating method and device |
| CN104182900A (en) * | 2014-08-07 | 2014-12-03 | 深圳市雁联计算系统有限公司 | Business data processing method, device and system |
| CN105512939A (en) * | 2015-12-04 | 2016-04-20 | 中国建设银行股份有限公司 | Foreign exchange transaction-related data storage and query method, declaration method and system |
-
2016
- 2016-05-09 CN CN201610302648.3A patent/CN106021349A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103595807A (en) * | 2013-11-20 | 2014-02-19 | 中国银行股份有限公司 | Data synchronous updating method and device |
| CN104182900A (en) * | 2014-08-07 | 2014-12-03 | 深圳市雁联计算系统有限公司 | Business data processing method, device and system |
| CN105512939A (en) * | 2015-12-04 | 2016-04-20 | 中国建设银行股份有限公司 | Foreign exchange transaction-related data storage and query method, declaration method and system |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107784578A (en) * | 2017-11-22 | 2018-03-09 | 中国银行股份有限公司 | Bank's foreign exchange data monitoring and managing method and device |
| CN107784578B (en) * | 2017-11-22 | 2021-08-20 | 中国银行股份有限公司 | Bank foreign exchange data supervision method and device |
| CN112650744A (en) * | 2020-12-31 | 2021-04-13 | 广州晟能软件科技有限公司 | Data management method for preventing secondary pollution of data |
| CN112650744B (en) * | 2020-12-31 | 2024-04-30 | 广州晟能软件科技有限公司 | Data treatment method for preventing secondary pollution of data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10115108B1 (en) | Rendering transaction data to identify fraud detection rule strength | |
| CN105930159A (en) | Image-based interface code generation method and system | |
| US20090006315A1 (en) | Structured method for schema matching using multiple levels of ontologies | |
| CN106844324B (en) | Method for exporting variable column data into Excel format | |
| CN106528821B (en) | A method of it changing column data and imports database | |
| CN107885788A (en) | A kind of business datum check method | |
| CN104142946A (en) | Method and system for aggregating and searching service objects of same type | |
| CN106293541A (en) | A kind of blog management method storing system and system | |
| EP1510935A1 (en) | Mapping a data from a data warehouse to a data mart | |
| CN106021349A (en) | A foreign exchange data submitting method and device | |
| CN104408128B (en) | A kind of reading optimization method indexed based on B+ trees asynchronous refresh | |
| CN105912723A (en) | Storage method of custom field | |
| CN116611678A (en) | Data processing method, device, computer equipment and storage medium | |
| CN116843486A (en) | Financial tax data processing method, system, equipment and storage medium | |
| CN110032664A (en) | A method of quickly establishing the full node address index of bit coin block chain | |
| CN105930323A (en) | File generating method and apparatus | |
| CN113592529B (en) | Potential customer recommendation method and device for bond products | |
| CN106651994A (en) | Bubble chart display method and device | |
| CN110941952A (en) | Method and device for perfecting audit analysis model | |
| CN106126633B (en) | Processing method, the device and system of noble metal data | |
| CN107133391A (en) | The generation method and system of construction drawing | |
| CN113610629A (en) | Method and device for screening client data features from large-scale feature set | |
| WO2020244069A1 (en) | Product publishing method and apparatus, computer equipment, and storage medium | |
| CN113449208A (en) | Space query method, device, system and storage medium | |
| CN102495788B (en) | Internal storage counting method and device of embedded system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161012 |