CN106933948B - Unified warehousing method for financial data - Google Patents
Unified warehousing method for financial data Download PDFInfo
- Publication number
- CN106933948B CN106933948B CN201710044565.3A CN201710044565A CN106933948B CN 106933948 B CN106933948 B CN 106933948B CN 201710044565 A CN201710044565 A CN 201710044565A CN 106933948 B CN106933948 B CN 106933948B
- Authority
- CN
- China
- Prior art keywords
- data
- information
- transaction
- bar code
- financial
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 26
- 238000004458 analytical method Methods 0.000 claims abstract description 40
- 238000012545 processing Methods 0.000 claims abstract description 8
- 238000013461 design Methods 0.000 description 3
- 238000012856 packing Methods 0.000 description 3
- 238000013500 data storage Methods 0.000 description 2
- 238000003556 assay Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
Images
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/22—Indexing; Data structures therefor; Storage structures
Abstract
The invention provides a unified warehousing method of financial data, which is applied to the processing of the financial data of financial machines in a financial system, wherein the financial data provided by each financial machine is analyzed to form an analysis file, and the data information in the analysis file is stored in a database; the database provides a plurality of data tables for storing corresponding data information; the unified warehousing method of the financial data comprises the following steps: step S1, the database calls the analyzed analysis file; step S2, the database acquires the data information in the analysis file and the variable of the data information; and step S3, the database stores the data information of the variables meeting the preset conditions into the corresponding data table. The technical scheme has the advantages that the financial data including the crown word number data can be processed and stored in the database in a unified mode, and the processing is flexible and high in expansibility.
Description
Technical Field
The invention relates to the field of financial systems, in particular to a unified financial data storage method.
Background
In the existing financial system, crown word number data and related data reported by financial machines and tools need to be stored, so that a user can conveniently manage the related data, wherein the financial machines and tools can comprise an ATM (automatic Teller machine), a cash counter and the like, and the related data information of the crown word number data is imported into a corresponding table in a database, and the data information generally comprises the following parts; warehousing common fsn file objects, warehousing transaction fsn file objects with transaction numbers (including over-the-counter transaction files and ATM transaction files), warehousing bar code and crown word number data binding objects, warehousing bundle box bar code binding objects, warehousing transaction numbers and bundle bar code file objects, warehousing over-the-counter transaction information, warehousing tool information, real-time blacklisting of crown word number data and the like, wherein the data formats of the existing golden crown word number data and related data are greatly different; the data format is analyzed and stored respectively, so that the flexibility and expansibility of the solution are insufficient, if a new data format appears, a new code needs to be added to the original solution, and the robustness of the system is reduced to a great extent.
Disclosure of Invention
Aiming at the problems existing in the prior art that the financial data are stored in a database in a financial system, the unified financial data storage method which has strong expansibility, meets the storage requirements of various data formats and can reduce the robustness of the system is provided.
The specific contents are as follows:
a unified warehousing method of financial data is applied to the processing of the financial data of financial machines in a financial system, wherein the financial data provided by each financial machine is analyzed to form an analysis file, and data information in the analysis file is stored in a database;
the database provides a plurality of data tables for storing the corresponding data information; the unified warehousing method of the financial data comprises the following steps:
step S1, the database calls the analyzed file;
step S2, the database acquires the data information in the analysis file and the variable of the data information;
step S3, the database stores the data information of the variables that satisfy the preset condition into the corresponding data table.
Preferably, the database provides a note counter record table for storing note counting records of the note counter;
and a crown word number data table for storing picture data of the crown word number data;
when only the detailed information of the crown word number data is included in the analysis file;
and inserting the data information in the current analysis file into the record table of the cash register and the crown word number data table.
Preferably, the database provides a transaction table for storing transaction information;
and a transaction binding table for storing binding information of the transaction and the crown word number data;
when the variable in the analysis file meets the condition that the detailed information of the crown word number data is not null and the transaction serial number is not null;
and correspondingly inserting the data information in the current analysis file into the crown word number data table, the cash counter record table, the transaction binding table and the transaction table.
Preferably, the database provides a bar code binding table for storing the binding information of the bar code number and the crown word number data;
when the variable in the analysis file meets the condition that the detailed information of the crown word number data is not empty and the bundle bar code is not empty;
and binding the crown word number data and the bundling bar code in the current analysis file, and storing the crown word number data and the bundling bar code in the bar code binding table.
Preferably, the bar code binding table is used for storing the binding information of the bar code number and the crown word number data;
when the bundle bar code in the analysis file is not empty and the bar code information is not empty;
and binding the bundle bar code with the bar code information and storing the bundle bar code and the bar code information in the bar code binding table.
Preferably, when the transaction number in the parsing file is not null and the bundle bar code is not null;
associating and storing the transaction number and the bundle bar code in the transaction binding table.
Preferably, when the transaction information in the analysis file is not empty;
and storing the transaction information into the transaction table.
Preferably, the analysis file further includes identity information of the financial instrument providing the financial data, and the identity information is stored in the database.
Preferably, the database provides a crown word number data blacklist, the database compares the data information in the analysis file with the data of the crown word number data blacklist in real time, and if the comparison result is the same, a prompt message is generated and sent to a financial system accessed by the financial machine.
The technical scheme has the following advantages or beneficial effects: the method can provide uniform processing and storing operations for financial data including crown word number data in a database, has strong processing flexibility and expansibility, and overcomes the defect that the original solution is to add new codes when a new data format appears in the prior art, thereby increasing the robustness of the system.
Drawings
Fig. 1 is a schematic flow chart illustrating an embodiment of a method for unified banking of financial data according to the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict.
The invention is further described with reference to the following drawings and specific examples, which are not intended to be limiting.
The utility model discloses a unified method for putting financial data into a warehouse.
The embodiment of a unified warehousing method of financial data is applied to the processing of the financial data of financial machines in a financial system, wherein the financial data provided by each financial machine is analyzed to form an analysis file, and data information in the analysis file is stored in a database;
the database provides a plurality of data tables for storing corresponding data information;
as shown in fig. 1, the unified banking method for financial data includes the following steps:
step S1, the database calls the analyzed analysis file;
step S2, the database acquires the data information in the analysis file and the variable of the data information;
and step S3, the database stores the data information of the variables meeting the preset conditions into the corresponding data table.
In the above technical solution, the financial data may specifically include crown word number data, transaction number, banknote counting record, transaction information, barcode information, and the like, wherein the database calls the analysis file, analyzes variables in the analysis file, and stores data information in the analysis file into a corresponding data table when a preset condition is satisfied.
In a preferred embodiment, the data table provided by the database comprises:
the cash register record table is used for storing cash register records of the cash register and specifically comprises transaction record numbers, record starting time and ending time, operators, ticket face value, currency, version numbers, operation types, operation numbers, work network numbers, grouping statistics, city numbers, service dates and client numbers.
The picture data for storing the data of the crown word number specifically comprises running time, coin number, coin error, date error, picture file and picture size.
The transaction table is used for storing transaction information, and specifically comprises transaction types, transaction dates, transaction numbers, financial machine tool numbers, operators, financial machine tool physical addresses and IP addresses.
The transaction binding table is used for storing the binding information of the transaction and the crown word number data, and specifically comprises a transaction number, a bar code number, a work network number, a creation date and a bar code type.
The bar code binding table is used for storing the binding information of the bar code number and the crown word number data, and specifically comprises the bar code number, the type, the sub bar code number, the date type, the work network number, the ticket face value, the description and the creation date.
The bar code binding record table is used for storing record information of bar code binding, and specifically comprises bar code binding number, description, time, type and operator.
The bar code table is used for storing bar code information, creating operator, creating date and bar code information.
In a preferred embodiment, when only the detailed information of the crown number data is included in the parsed file;
and inserting the data information in the current analysis file into a note table of the cash register and a crown word number data table.
In the technical scheme, when the financial machine is in a financial system, such as a currency counting machine in the currency counting process, the acquired detailed information of the crown word number data specifically comprises a crown word number data picture and a currency counting record and is stored in a corresponding currency counting machine record table and a crown word number data table.
In a preferred embodiment, when the variables in the parsed file satisfy that the detailed information of the crown number data is not empty and the transaction serial number is not empty;
and correspondingly inserting the data information in the current analysis file into a crown word number data table, a cash counter record table, a transaction binding table and a transaction table.
In the technical scheme, when the amount transaction is carried out in the financial system, a corresponding transaction serial number is formed, at the moment, the specific information in the transaction serial number can be stored in a transaction table,
in a preferred embodiment, when the variables in the parsed file satisfy that the detailed information of the crown-word number data is not empty and the bundle bar code is not empty;
and binding the crown word number data in the current analysis file and the bundle bar code, and storing the binding in a bar code binding table.
In the technical scheme, the method can comprise the steps of counter transaction information binding and ATM transaction information binding;
the fsn file with the transaction number is the fsn file with the transaction number during normal currency counting, and is mainly used for realizing transaction binding blue marks, and when variables meet the following conditions, the fsn file with the transaction number needs to be subject to warehousing treatment:
first, the data information of the crown word number is not null
Second, the trade serial number in the file information is not null
When the file with the transaction number fsn is put into a warehouse, the table inserted into the database and the objects are as follows:
recording a table of a currency count machine;
a prefix number data table;
picture file for data of crown word number
Fourthly, a trading table (generally, only one trading serial number is provided, and if detailed trading information exists, the detailed trading information can be inserted into the trading table;
fifthly, transaction binding table (binding information of transaction and crown word number data)
In a preferred embodiment, when the bundle bar code in the parsing file is not empty, and the bar code information is not empty;
the bundle bar code is bound with the bar code information and stored in a bar code binding table.
In the technical proposal, the device comprises a base,
the design scene of the binding object of the bar code and the crown word number data for warehousing is generally that in a sorting center, after a banknote is sorted, the bar code is printed, then the bar code and the crown word number data of the banknote are bound, and the following variable conditions are met, namely the binding of the bar code and the crown word number data is required:
first, the data of the crown word number is not null
② bundle bar code in file information is not null
When the bar code and the crown word number data are bound with the object to be put in storage, the table inserted into the database and the object are as follows:
a bar code binding table (bar code binding table, the associated fields are main bar code id and sub batch id).
In a preferred embodiment, when the transaction number in the parsed file is not empty, and the bundle barcode is not empty;
the transaction number is associated with and the bundle bar code is stored in a transaction binding table.
In the technical scheme, the design scene of binding the barcode of the packing box is that when a cash center dispenses or transfers money, the barcode of each bundle, each bundle and each box needs to be scanned by equipment and then bound, and the following variable conditions meet the requirement that the operation of binding the barcode of the packing box to an object to be stored in a warehouse is required to be carried out:
not null bundle bar code in file information
② the bundle bar code is not empty
For example, binding the bundle bar code, the bundle bar code number is stored in the bundle bar code variable in the file information, and the bundle bar code number is stored in the bundle bar code information variable in the file information;
when the binding object of the packing box bar code is put into storage, the table inserted into the database and the object are as follows:
bar code binding table (Bar code binding table, associated field is main bar code number and sub bar code number)
And inserting the association relationship between the transaction number and the bundle bar code, wherein the association field is the transaction time and the bar code number.
In a preferred embodiment, when the transaction information in the parsed file is not empty;
and storing the transaction information into a transaction table.
In the technical scheme, the design scene of putting the transaction number and the bundle bar code document object into a warehouse is the process of directly scanning the bar code on the bundle of paper currency and paying without counting the money when a bank teller handles the withdrawal of a large amount of a client; the following variable conditions are satisfied, namely the transaction number and the storage processing of the bundle bar code file object are required to be carried out:
analyzing the file with transaction number not null
② the bundle bar code is not empty
When the transaction number and bundle bar code file object are put into the library, the table inserted into the database and the object are:
(ii) a transaction binding table (inserting a transaction number and a bundle bar code into an association, the association field being a transaction number and a bar code number)
In a preferred embodiment, the analysis file further includes the identity information of the financial tool providing the financial data, and the identity information is stored in the database.
In the technical scheme, the function is mainly that the detailed information of the paper money counter tool is not registered in a financial system when the paper money counter tool is received from the file data, so that the information of the paper money counter tool is temporarily stored in a database and is temporarily bound to a default mechanism for the convenience of a user to inquire the information of the paper money counter tool, and the information of the paper money counter tool stored in the database mainly comprises a machine tool number and an IP address; the user may then modify the information in the financial system for that implement.
In a preferred embodiment, a crown word number data blacklist is provided in the database, the database compares the crown word number data information in the analysis file with the data of the crown word number data blacklist in real time, and if the comparison result is the same, a prompt message is generated and sent to a financial system accessed by a financial machine.
In the technical scheme, if the data information which is clicked in the blacklist is found, namely the crown word number data, the detailed information of the crown word number data is sent to the background of the financial system in a web service mode, and the user is reminded in a yellow small envelope mode on a page of the background of the financial system.
It should be noted that FileInfo is information corresponding to a file (the file is not limited to fsn, and may also be a two-dimensional code associated file of a bundle box, or a transaction information file, etc.), and is composed of four parts:
FileInfo
to an end: file information including file name, serial number of corresponding transaction, bundle bar code and other information
Offset: detailed information of each crown number data
Bars codelist: bar code information
Assay information: transaction information.
While the invention has been described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention.
Claims (9)
1. A unified warehousing method of financial data is applied to the processing of the financial data of financial machines in a financial system and is characterized in that the financial data provided by each financial machine is analyzed to form an analysis file, and data information in the analysis file is stored in a database;
the database provides a plurality of data tables for storing the corresponding data information; the unified warehousing method of the financial data comprises the following steps:
step S1, the database calls the analyzed file;
step S2, the database acquires the data information in the analysis file and the variable of the data information;
step S3, the database stores the data information of the variables meeting preset conditions into the corresponding data table;
the data information in the analysis file comprises at least one of crown word number data, transaction numbers, transaction serial numbers, bundle numbers, bar code information, transaction information and identity information of the financial machines and tools;
the preset condition is that the data information comprises the types of the crown word number data, the transaction number, the transaction serial number, the bundle number, the bar code information, the transaction information and the identity information of the financial machine.
2. The method of claim 1, wherein the database provides a note counter record table for storing note counter records of note counters;
and a crown word number data table for storing picture data of the crown word number data;
when only the detailed information of the crown word number data is included in the analysis file;
and inserting the data information in the current analysis file into the record table of the cash register and the crown word number data table.
3. The method as claimed in claim 2, wherein the database provides a transaction table for storing transaction information;
and a transaction binding table for storing binding information of the transaction and the crown word number data;
when the variable in the analysis file meets the condition that the detailed information of the crown word number data is not null and the transaction serial number is not null;
and correspondingly inserting the data information in the current analysis file into the crown word number data table, the cash counter record table, the transaction binding table and the transaction table.
4. The method of claim 1, wherein the database provides a bar code binding table for storing binding information of bar code number and crown word number data;
when the variable in the analysis file meets the condition that the detailed information of the crown word number data is not empty and the bundle bar code is not empty;
and binding the crown word number data and the bundling bar code in the current analysis file, and storing the crown word number data and the bundling bar code in the bar code binding table.
5. The method of claim 4, wherein the barcode binding table is used for storing the binding information of the barcode number and the crown word number data;
when the bundle bar code in the analysis file is not empty and the bar code information is not empty;
and binding the bundle bar code with the bar code information and storing the bundle bar code and the bar code information in the bar code binding table.
6. The method of claim 3, wherein when the transaction number in the parsed file is not empty and the bundle bar code is not empty;
associating and storing the transaction number and the bundle bar code in the transaction binding table.
7. The method of claim 3, wherein when the transaction information in the parsed file is not empty;
and storing the transaction information into the transaction table.
8. The method of claim 1, wherein the parsed file further includes identification information of the financial instruments providing the financial data and the identification information is stored in the database.
9. The method as claimed in claim 2, wherein the database provides a blacklist of crown number data, the database compares the data information of crown number data in the parsing file with the data of the blacklist of crown number data at any time, and if the comparison result is the same, a prompt message is generated and sent to the financial system accessed by the financial device.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710044565.3A CN106933948B (en) | 2017-01-19 | 2017-01-19 | Unified warehousing method for financial data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710044565.3A CN106933948B (en) | 2017-01-19 | 2017-01-19 | Unified warehousing method for financial data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106933948A CN106933948A (en) | 2017-07-07 |
| CN106933948B true CN106933948B (en) | 2021-03-09 |
Family
ID=59423435
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710044565.3A Active CN106933948B (en) | 2017-01-19 | 2017-01-19 | Unified warehousing method for financial data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106933948B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR102274656B1 (en) * | 2019-11-22 | 2021-07-09 | 주식회사 티맥스엔터프라이즈 | Technique for managing data in blockchain network |
Family Cites Families (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1607534A (en) * | 2003-10-13 | 2005-04-20 | 赵睿 | Paper currency anti-robbing burglar proof system |
| CN101430661B (en) * | 2008-11-18 | 2011-06-01 | 阿里巴巴集团控股有限公司 | Method, system and apparatus for test data batch generation |
| CN102799634B (en) * | 2012-06-26 | 2014-11-12 | 中国农业银行股份有限公司 | Data storage method and device |
| JP2015056010A (en) * | 2013-09-11 | 2015-03-23 | グローリー株式会社 | Bill management system and bill management method |
| US9762603B2 (en) * | 2014-05-10 | 2017-09-12 | Informatica Llc | Assessment type-variable enterprise security impact analysis |
| CN104268977A (en) * | 2014-08-06 | 2015-01-07 | 浙江维融电子科技股份有限公司 | Banknote information management method and system |
| CN104392542B (en) * | 2014-10-29 | 2018-07-06 | 中国建设银行股份有限公司 | A kind of bank note distribution information acquisition management method and device |
| CN105426953B (en) * | 2016-01-18 | 2018-08-17 | 董策 | A kind of data processing method, processing system and paper money counter |
| CN105844784B (en) * | 2016-03-18 | 2020-03-17 | 光荣电子工业（苏州）有限公司 | Paper money processing device |
| CN106023407A (en) * | 2016-05-12 | 2016-10-12 | 四川徽通金融外包服务有限公司 | RMB serial number management system and RMB serial number management based on cloud service |
| CN105957238B (en) * | 2016-05-20 | 2019-02-19 | 聚龙股份有限公司 | A kind of paper currency management method and its system |
-
2017
- 2017-01-19 CN CN201710044565.3A patent/CN106933948B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN106933948A (en) | 2017-07-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR100368586B1 (en) | Business form handling method and system for carrying out the same | |
| US5689579A (en) | Rule-based circuit, method and system for performing item level reconciliation | |
| RU2562765C2 (en) | Banknote processing | |
| US8903154B2 (en) | Enhanced note processing | |
| CN103996140B (en) | Banknote serial number tracking method and system | |
| KR100368587B1 (en) | Sheet handling system | |
| US9092447B1 (en) | Method and system for duplicate detection | |
| US20050281450A1 (en) | System and method for correcting data in financial documents | |
| US8185471B1 (en) | Integrated payment receiving and processing system | |
| US20060219773A1 (en) | System and method for correcting data in financial documents | |
| CN1855154A (en) | Coin warehouse-in and warehouse-out checking method and supporting system based on discriminating sign | |
| JP2015156050A (en) | Banknote management device, banknote processing system, and banknote processing method | |
| CN105447957A (en) | Acquisition method of prefix letters of banknote, and financial service terminal | |
| CN107168973A (en) | A kind of paper money number information processing method, apparatus and system | |
| CN106933948B (en) | Unified warehousing method for financial data | |
| RU2253518C2 (en) | Error recovery of postal addressing by way of using extended clients' codes | |
| CN109214362B (en) | Document processing method and related equipment | |
| US11806758B2 (en) | Method for processing a batch of mailpieces by reading barcodes printed thereon | |
| US8240554B2 (en) | System and method of financial instrument processing with duplicate item detection | |
| CN102646239A (en) | Seal imprint checking system, seal imprint checking device and seal imprint checking method | |
| EP0482116A1 (en) | Image-based document processing system | |
| CN104392542B (en) | A kind of bank note distribution information acquisition management method and device | |
| GB2369914A (en) | An automated teller machine network | |
| US20060218186A1 (en) | Automated data processing using optical character recognition | |
| US6749113B2 (en) | System for card processing, embossing and fulfillment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Lingxizhen Cangnan County of Wenzhou City, Zhejiang province 325800 Yong Jin Road No. 188 Patentee after: Weirong Technology Co.,Ltd. Address before: Lingxizhen Cangnan County of Wenzhou City, Zhejiang province 325800 Yong Jin Road No. 188 Patentee before: ZHEJIANG WEIRONG ELECTRONIC Co.,Ltd. |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A Unified Storage Method for Financial Data Effective date of registration: 20231222 Granted publication date: 20210309 Pledgee: Bank of China Limited by Share Ltd. Cangnan County branch Pledgor: Weirong Technology Co.,Ltd. Registration number: Y2023330003082 |