CN102117293A - Dynamic file positioning and query method - Google Patents
Dynamic file positioning and query method Download PDFInfo
- Publication number
- CN102117293A CN102117293A CN2009102477565A CN200910247756A CN102117293A CN 102117293 A CN102117293 A CN 102117293A CN 2009102477565 A CN2009102477565 A CN 2009102477565A CN 200910247756 A CN200910247756 A CN 200910247756A CN 102117293 A CN102117293 A CN 102117293A
- Authority
- CN
- China
- Prior art keywords
- field
- information
- file
- transaction
- condition
- 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.)
- Granted
Links
Images
Abstract
The invention discloses a dynamic file positioning and query method, which comprises the following steps of: inputting user query information; positioning a selected condition field, a selected transaction type field, a transaction counting format field and a result display result according to the user query information; obtaining information in row records according to the positioned condition field, matching the information in the row records with the input information, and simultaneously performing transaction type matching; positioning the information in the row records according to a matched transaction type, and netting the information with a field of the same transaction type and the same amount of money; and performing row recording on a query result.
Description
Technical field
The present invention relates to file Kinematic Positioning and querying method, more specifically, relate to bank card file Kinematic Positioning and querying method.
Background technology
At present, along with becoming increasingly abundant of the growing of banking and bank card business kind, the bank card file is carried out the simple and rapid Kinematic Positioning and inquiry becomes more and more important.In existing bank card document handling method, mainly contain following two kinds of processing modes: (1) is used and is split software: after reading the every line item and whole fractionation the in the file, the field that obtains is mated with the condition field of appointment one by one, and then check, thereby the correctness of all field informations in the identification transaction, the every transaction record of checking with conditional value; Yet, if each field validation failure can't be carried out subsequent treatment; (2) use file edit tool (for example ultraEdit):, contrast the file layout standard again and compare earlier with File Open; Yet this mode can't effectively be discerned transaction, is difficult to handle bigger file, and the mode accuracy of manual location comparison inquiry is low, speed is slow, more can't directly obtain type of transaction and amount field is directly added up.
Summary of the invention
In order to solve the existing defective of above-mentioned prior art scheme, the present invention proposes a kind of can Kinematic Positioning bank card file, and can carry out the method for Transaction Inquiries and statistics to the bank card chronological file of appointment.
One of purpose of the present invention is achieved through the following technical solutions:
A kind of file Kinematic Positioning and querying method, described file Kinematic Positioning and querying method comprise the steps:
(A1) typing user inquiring information;
(A2), locate selecteed condition field, selecteed type of transaction field, transaction statistics format fields and display field as a result according to described user inquiring information;
(A3) mate according to the information in the oriented described condition field acquisition line item, and with the information of information in the described line item and typing, carry out the type of transaction coupling simultaneously;
(A4) according to the type of transaction of having mated, locate the information in the described line item, and with roll with amount field with type of transaction before poor;
(A5) Query Result is carried out line item;
Wherein, in step (A2), obtain the sequence of selected condition field in whole format fields, according to all form field lengths before the described sequence and each interfield decollator length, the length of calculating the reference position of described condition field and writing down described condition field itself.
In the disclosed in the above scheme, preferably, step (A2) further comprises: according to the file type attribute, judge and whether comprise the type of transaction field in the file layout field, if comprise the type of transaction field, then the mode according to step (A2) obtains the reference position of described type of transaction field and the length of described type of transaction field itself, if do not comprise type of transaction, then in internal memory, type of transaction is converted to the file layout field, and, obtain the corresponding reference position and the length of described field itself according to the sequence of described field in whole format fields.
In the disclosed in the above scheme, preferably, described bank card file Kinematic Positioning and querying method are performed under the windows platform.
In the disclosed in the above scheme, preferably, described step (A2) further comprises:
(B1) load configurations file;
(B2) conditional information of loading typing;
(B3) locating information of querying condition field;
(B4) directly flowing water is carried out value according to locating information;
(B5) the locating information value is handled.
In the disclosed in the above scheme, preferably, step (B1) further comprises:
According to selecting filename to be processed, load the associated documents name parameter;
Load channel translation information, transaction translation information and amount of money statistical information;
Parameter is loaded in the internal memory, and is object with structure, container respectively.
In the disclosed in the above scheme, preferably, step (B3) further comprises:
According to the condition field title, in file layout field internal memory, search, for all the field length values before the described field, and the shared length of field separator is added up, obtain the reference position of condition field in delegation's flowing water, and with described condition field self length as deflected length.Be recorded in the condition internal storage structure body.
In the disclosed in the above scheme, preferably, step (B4) further comprises:
When inquiring about or add up,,, use substring directly to obtain the assigned address content according to each condition field reference position, deflected length with the delegation's flowing water that obtains.
In the disclosed in the above scheme, preferably, step (B5) further comprises
According to the locator value of obtaining among the step B4, the conditional value of typing carries out accurately/fuzzy matching in information that described locator value is located and the construction of condition body container, if the match is successful, then according to the construction of condition body content of all loadings in the condition container, circulation execution in step (B4); It fails to match if run into, and then directly abandons described flowing water, takes off delegation's flowing water and re-execute step (B4).
File Kinematic Positioning disclosed in this invention and querying method have following advantage: by using the Kinematic Positioning technology, in the process that file is handled, avoided the every line item of whole chronological file is all split the process of checking, can realize fast that action is handled in the inquiry, statistic of classification etc. to chronological file; For handling the bigger chronological file of trading volume, described file Kinematic Positioning and querying method have stable, and inquiry is accurate with coupling, the characteristics of highly-efficient treatment, and this method is performed under the windows platform, thereby can satisfy the performance requirement of user to file processing.
Description of drawings
In conjunction with the accompanying drawings, technical characterictic of the present invention and advantage will be understood better by those skilled in the art, wherein:
Fig. 1 is file Kinematic Positioning and querying method process flow diagram according to an embodiment of the invention;
Fig. 2 is the process flow diagram handled of file Kinematic Positioning according to an embodiment of the invention;
Embodiment
Fig. 1 is file Kinematic Positioning and querying method process flow diagram according to an embodiment of the invention.As shown in Figure 1, file Kinematic Positioning disclosed in this invention and querying method comprise the steps: (A1) typing user inquiring information; (A2), locate selecteed condition field, selecteed type of transaction field, transaction statistics format fields and display field as a result according to described user inquiring information; (A3) mate according to the information in the oriented described condition field acquisition line item, and with the information of information in the described line item and typing, carry out the type of transaction coupling simultaneously; (A4) according to the type of transaction of having mated, locate the information in the described line item, and with roll with amount field with type of transaction before poor; (A5) Query Result is carried out line item.Wherein, in described steps A 2, obtain the sequence of selected condition field in whole format fields,, calculate the reference position of this condition field and the length of record field itself according to all form field lengths before the sequence and each interfield decollator length; According to the file type attribute, judge and whether comprise the type of transaction field in the file layout field, if comprise the type of transaction field, then obtain reference position and the length of itself according to aforementioned manner, if do not comprise type of transaction, then in internal memory, type of transaction is converted to the file layout field, and comprises following field: type of message, type of message and service point condition code, and, obtain corresponding reference position and the length of itself according to the sequence of these fields in whole format fields.Described step 2 also comprises: load the need statistics format fields (for example all kinds of amount field such as capital, service charge) of file type correspondence, and obtain reference position and itself length according to foregoing mode; Obtain all display format fields in the internal memory, and obtain reference position and itself length according to foregoing mode.In steps A 3, after reading in line item, according to condition field reference position and field length, employing is read the substring mode and is located the information that obtains in the line item, carry out fuzzy matching (if accurately mate with the information of typing, then accurately mate), if the information in the line item comprises or consistent with entry information, then be considered as this condition field coupling.Otherwise abandon this line item, take off delegation's recording processing; Simultaneously, after reading in line item, according to condition field reference position and field length, the location obtains the information in the line item, carry out fuzzy matching (, then accurately mating) with the information of typing, when the information in the line item comprises or is consistent with entry information if accurately mate, if the type of transaction field is arranged in the file layout, then be considered as coupling.If there is not the type of transaction field in the file layout, then after the conversion to comprise field information all consistent, be considered as the type of transaction coupling.Otherwise abandon this line item, take off delegation's recording processing.In steps A 4, according to after the type of transaction classification, the location obtains the information in this line item, with roll with the same amount field of type of transaction (as being the capital field) before poor.In steps A 5, Query Result is carried out record, according to display field reference position and field length, the location obtains the information in the line item, enters the display result processing procedure, and secondary file is when generating, information location back combination according to specifying needs writes in the file.
Figure 2 shows that the process flow diagram of file Kinematic Positioning processing according to an embodiment of the invention.As shown in Figure 2, the steps A 2 in bank card file Kinematic Positioning disclosed in this invention and the querying method further comprises: (B1) load configurations file; (B2) conditional information of loading typing; (B3) locating information of querying condition field; (B4) directly flowing water is carried out value according to locating information; (B5) the locating information value is handled.In step B1, according to selecting filename to be processed, load the associated documents name parameter, comprising: file layout field name, length, condition field whether, amount field whether, whether channel information etc.; Load the channel translation information, load the transaction translation information, load amount of money statistical information; Parameter is loaded in the internal memory, is object with structure, container respectively, for follow-up use.In step B2,, comprise the inquiry field of selection to the conditional information of typing, the conditional value of input to the mode record of each condition with structure, comprises respectively: field name, field length (loading acquisition) from parameter, initial conditions storage container (may comprise a plurality of input values); Successively each alternative condition is loaded in the internal memory container in the structure mode respectively, for follow-up use.In step B3, according to the condition field title, in file layout field internal memory, search, because the file layout field is arranged in order, for all the field length values before this field, and the shared length of field separator adds up, and obtains the reference position of condition field in delegation's flowing water, and with this condition field self length as deflected length.Be recorded in the condition internal storage structure body.In step B4, when inquiring about or add up,,, use substring directly to obtain the assigned address content according to each condition field reference position, deflected length with the delegation's flowing water that obtains.In step B5, according to the locator value of obtaining among the step B4, the conditional value of typing carries out accurately/fuzzy matching in information that this locator value is located and the construction of condition body container, if the match is successful, then according to the construction of condition body content of all loadings in the condition container, circulation step B4.It fails to match if run into, and then directly abandons this row flowing water, takes off delegation's flowing water and re-execute step B4; If meet all conditions content, then enter type of transaction translation, the amount of money rolls difference and handles; According to step B3, B4,, obtain type of transaction with field value combinations matches in internal memory of getting; With amount field according to borrow, that the credit side rolls to statistics is poor.
Although the present invention is described by above-mentioned preferred implementation, its way of realization is not limited to above-mentioned embodiment.Should be realized that: under the situation that does not break away from purport of the present invention and scope, those skilled in the art can make different variations and modification to the present invention.
Claims (9)
1. file Kinematic Positioning and querying method, described file Kinematic Positioning and querying method comprise the steps:
(A1) typing user inquiring information;
(A2) according to described user inquiring information, locate selecteed field;
(A3) mate according to the information in the oriented described field acquisition line item, and with the information of information in the described line item and typing, carry out the type of transaction coupling simultaneously;
(A4) according to the type of transaction of having mated, locate the information in the described line item;
(A5) Query Result is carried out line item;
Wherein, in step (A2), obtain the sequence of selecteed condition field in whole format fields, according to all form field lengths before the described sequence and each interfield decollator length, the length of calculating the reference position of described condition field and writing down described condition field itself.
2. file Kinematic Positioning according to claim 1 and querying method, it is characterized in that the described selecteed field in the step (A2) comprises selecteed condition field, selecteed type of transaction field, transaction statistics format fields and display field as a result.
3. file Kinematic Positioning according to claim 1 and querying method, it is characterized in that, step (A2) further comprises: according to the file type attribute, judge and whether comprise the type of transaction field in the file layout field, if comprise the type of transaction field, then the mode according to step (A2) obtains the reference position of described type of transaction field and the length of described type of transaction field itself, if do not comprise type of transaction, then in internal memory, type of transaction is converted to the file layout field, and, obtain the corresponding reference position and the length of described field itself according to the sequence of described field in whole format fields.
4. according to described file Kinematic Positioning of any claim among the claim 1-2 and querying method, it is characterized in that described file Kinematic Positioning and querying method are performed under the windows platform.
5. according to described file Kinematic Positioning of any claim among the claim 1-2 and querying method, it is characterized in that described step (A2) further comprises:
(B1) load configurations file;
(B2) conditional information of loading typing;
(B3) locating information of querying condition field;
(B4) directly flowing water is carried out value according to locating information;
(B5) the locating information value is handled.
6. according to described file Kinematic Positioning of any claim among the claim 1-2 and querying method, it is characterized in that step (B1) further comprises:
According to selecting filename to be processed, load the associated documents name parameter;
Load channel translation information, transaction translation information and amount of money statistical information;
Parameter is loaded in the internal memory, and is object with structure, container respectively.
7. according to described file Kinematic Positioning of any claim among the claim 1-2 and querying method, it is characterized in that step (B3) further comprises:
According to the condition field title, in file layout field internal memory, search, for all the field length values before the described field, and the shared length of field separator is added up, obtain the reference position of condition field in delegation's flowing water, and with described condition field self length as deflected length.Be recorded in the condition internal storage structure body.
8. according to described file Kinematic Positioning of any claim among the claim 1-2 and querying method, it is characterized in that step (B4) further comprises:
When inquiring about or add up,,, use substring directly to obtain the assigned address content according to each condition field reference position, deflected length with the delegation's flowing water that obtains.
9. according to described file Kinematic Positioning of any claim among the claim 1-2 and querying method, it is characterized in that step (B5) further comprises
According to the locator value of obtaining among the step B4, the conditional value of typing carries out accurately/fuzzy matching in information that described locator value is located and the construction of condition body container, if the match is successful, then according to the construction of condition body content of all loadings in the condition container, circulation execution in step (B4); It fails to match if run into, and then directly abandons described flowing water, takes off delegation's flowing water and re-execute step (B4).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910247756.5A CN102117293B (en) | 2009-12-30 | 2009-12-30 | Dynamic file positioning and query method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910247756.5A CN102117293B (en) | 2009-12-30 | 2009-12-30 | Dynamic file positioning and query method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102117293A true CN102117293A (en) | 2011-07-06 |
| CN102117293B CN102117293B (en) | 2014-03-19 |
Family
ID=44216067
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910247756.5A Active CN102117293B (en) | 2009-12-30 | 2009-12-30 | Dynamic file positioning and query method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102117293B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105930325A (en) * | 2015-11-19 | 2016-09-07 | 中国银联股份有限公司 | Reverse analysis method and device for file report comparative difference |
| CN108418703A (en) * | 2018-01-10 | 2018-08-17 | 北京思特奇信息技术股份有限公司 | A kind of method for early warning and system based on real-time event detecting |
| CN109697216A (en) * | 2018-12-18 | 2019-04-30 | 中国银行股份有限公司 | Exchange information processing method, apparatus and system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5617567A (en) * | 1990-05-21 | 1997-04-01 | Financial System Technology Pty. Ltd. | Data processing system and method for retrieving and entity specified in a search path record from a relational database |
| CN101158977A (en) * | 2007-11-21 | 2008-04-09 | 金蝶软件（中国）有限公司 | Method and system for processing multiple services bills data |
| CN101751423A (en) * | 2008-12-08 | 2010-06-23 | 北大方正集团有限公司 | Article duplicate checking method and system |
-
2009
- 2009-12-30 CN CN200910247756.5A patent/CN102117293B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5617567A (en) * | 1990-05-21 | 1997-04-01 | Financial System Technology Pty. Ltd. | Data processing system and method for retrieving and entity specified in a search path record from a relational database |
| CN101158977A (en) * | 2007-11-21 | 2008-04-09 | 金蝶软件（中国）有限公司 | Method and system for processing multiple services bills data |
| CN101751423A (en) * | 2008-12-08 | 2010-06-23 | 北大方正集团有限公司 | Article duplicate checking method and system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105930325A (en) * | 2015-11-19 | 2016-09-07 | 中国银联股份有限公司 | Reverse analysis method and device for file report comparative difference |
| CN105930325B (en) * | 2015-11-19 | 2019-05-24 | 中国银联股份有限公司 | A kind of file report compares the conversed analysis method and device of difference |
| CN108418703A (en) * | 2018-01-10 | 2018-08-17 | 北京思特奇信息技术股份有限公司 | A kind of method for early warning and system based on real-time event detecting |
| CN109697216A (en) * | 2018-12-18 | 2019-04-30 | 中国银行股份有限公司 | Exchange information processing method, apparatus and system |
| CN109697216B (en) * | 2018-12-18 | 2021-04-20 | 中国银行股份有限公司 | Clearing transaction information processing method, device and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102117293B (en) | 2014-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102831052B (en) | Test exemple automation generating apparatus and method | |
| US10740372B2 (en) | System and method for extracting data from a non-structured document | |
| CN101770470B (en) | File type identifying and analyzing method and system | |
| CN107122369B (en) | Service data processing method, device and system | |
| CN106156239B (en) | Table extraction method and device | |
| CN104298736A (en) | Method and device for aggregating and connecting data as well as database system | |
| CN108664471A (en) | Text region error correction method, device, equipment and computer readable storage medium | |
| CN111367976A (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN110362596A (en) | A kind of control method and device of text Extracting Information structural data processing | |
| CN103136244A (en) | Parallel data mining method and system based on cloud computing platform | |
| CN102117293B (en) | Dynamic file positioning and query method | |
| CN111382182A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN104317850A (en) | Data processing method and device | |
| CN114970475A (en) | excel table analysis method, system, equipment and storage medium | |
| CN103870511A (en) | Shared memory-based information inquiring equipment and method | |
| EP1988475A1 (en) | Object reference method and system based on object storage library | |
| CN103336850A (en) | Method and device for confirming index word in database retrieval system | |
| US20100205175A1 (en) | Cap-sensitive text search for documents | |
| CN107909054A (en) | The method for evaluating similarity and device of picture text | |
| CN102110006A (en) | System and method for expanding and developing application business | |
| CN115391584A (en) | Method and device for extracting invoice information, computer equipment and storage medium | |
| CN113779934B (en) | Multi-mode information extraction method, device, equipment and computer readable storage medium | |
| CN107092607B (en) | Ticket storage method and device | |
| CN109815470A (en) | Accreditation data creation method, device, computer equipment and storage medium | |
| CN114495138A (en) | Intelligent document identification and feature extraction method, device platform and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |