CN102117293B - Dynamic file positioning and query method - Google Patents
Dynamic file positioning and query method Download PDFInfo
- Publication number
- CN102117293B CN102117293B CN200910247756.5A CN200910247756A CN102117293B CN 102117293 B CN102117293 B CN 102117293B CN 200910247756 A CN200910247756 A CN 200910247756A CN 102117293 B CN102117293 B CN 102117293B
- Authority
- CN
- China
- Prior art keywords
- field
- information
- file
- transaction
- type
- 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 38
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 15
- 230000008878 coupling Effects 0.000 claims description 8
- 238000010168 coupling process Methods 0.000 claims description 8
- 238000005859 coupling reaction Methods 0.000 claims description 8
- 238000010276 construction Methods 0.000 claims description 6
- 238000011068 loading method Methods 0.000 claims description 3
- 238000006243 chemical reaction Methods 0.000 claims description 2
- 230000008569 process Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 4
- 230000008901 benefit Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000005194 fractionation Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
Images
Landscapes
- Position Fixing By Use Of Radio Waves (AREA)
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, bank card file is carried out simply and fast to 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 split software: after the every line item in file reading all fractionation, the field obtaining is mated with the condition field of appointment one by one, and then check with conditional value, thereby the correctness of all field informations in every transaction record is concluded the business, is verified in identification; Yet, if each field validation failure cannot be carried out subsequent treatment; (2) use Document Editing instrument (for example ultraEdit): first by File Open, then contrast file layout standard and compare; Yet which cannot effectively be identified transaction, be difficult to process larger file, and manual contrast locating is low to the mode accuracy of inquiry, speed is slow, more cannot directly obtain type of transaction and amount field is directly added up.
Summary of the invention
In order to solve the existing defect of above-mentioned prior art scheme, the present invention proposes a kind of can Kinematic Positioning bank card file, and can carry out to the bank card chronological file of appointment the method for Transaction Inquiries and statistics.
One of object of the present invention is achieved through the following technical solutions:
File Kinematic Positioning and a querying method, described file Kinematic Positioning and querying method comprise the steps:
(A1) typing user Query Information;
(A2), according to described user's Query Information, locate selecteed condition field, selecteed type of transaction field, transaction statistics format fields and result display field;
(A3) according to oriented described condition field, obtain the information in line item, and the information in described line item is mated with the information of typing, carry out type of transaction coupling simultaneously;
(A4) according to the type of transaction of having mated, locate the information in described line item, and with type of transaction, with amount field, roll before poor;
(A5) Query Result is carried out to line item;
Wherein, in step (A2), obtain the sequence of selected condition field in whole format fields, according to all form field lengths before described sequence and each interfield decollator length, the length of calculating the reference position of described condition field and recording described condition field itself.
In the above in disclosed scheme, preferably, step (A2) further comprises: according to file type attribute, judge and in file layout field, whether comprise type of transaction field, if comprise type of transaction field, according to the mode of step (A2), obtain 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, type of transaction is converted to file layout field in internal memory, and according to described field the sequence in whole format fields, obtain the length of corresponding reference position and described field itself.
In disclosed scheme, preferably, described bank card file Kinematic Positioning and querying method are performed under windows platform in the above.
In disclosed scheme, preferably, described step (A2) further comprises in the above:
(B1) load configurations file;
(B2) load the conditional information of typing;
(B3) locating information of querying condition field;
(B4) according to locating information, directly flowing water is carried out to value;
(B5) locating information value is processed.
In disclosed scheme, preferably, step (B1) further comprises in the above:
According to selecting filename to be processed, load associated documents name parameter;
Load channel translation information, transaction translation information and amount of money statistical information;
Parameter is loaded in internal memory, and to take respectively structure, container be object.
In disclosed scheme, preferably, step (B3) further comprises in the above:
According to condition field title, in file layout field internal memory, search, for all field length values before described field, and the shared length of field separator is added up, obtain the reference position of condition field in a line flowing water, and using described condition field self length as deflected length.Be recorded in condition internal storage structure body.
In disclosed scheme, preferably, step (B4) further comprises in the above:
When inquiring about or add up, by a line flowing water obtaining, according to each condition field reference position, deflected length, use substring directly to obtain assigned address content.
In disclosed scheme, preferably, step (B5) further comprises in the above
According to the locator value of obtaining in step B4, in the information that described locator value is located and construction of condition body container, the conditional value of typing carries out accurately/fuzzy matching, if the match is successful, according to the construction of condition body content of all loadings in condition container, circulation execution step (B4); If run into, it fails to match, directly abandons described flowing water, takes off a line flowing water and re-execute step (B4).
File Kinematic Positioning disclosed in this invention and querying method tool have the following advantages: by using Kinematic Positioning Techniques And, in the process that file is processed, avoided the every line item of whole chronological file all to split the process of checking, can realize fast inquiry to chronological file, statistic of classification etc. and process action; For processing the larger chronological file of trading volume, described file Kinematic Positioning and querying method have stable, inquire about and mate accurately the feature of highly-efficient treatment, and the method is performed under windows platform, thereby can meet the performance requirement of user to file processing.
Accompanying drawing explanation
By reference to 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 that file Kinematic Positioning is processed 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 Query Information; (A2), according to described user's Query Information, locate selecteed condition field, selecteed type of transaction field, transaction statistics format fields and result display field; (A3) according to oriented described condition field, obtain the information in line item, and the information in described line item is mated with the information of typing, carry out type of transaction coupling simultaneously; (A4) according to the type of transaction of having mated, locate the information in described line item, and with type of transaction, with amount field, roll before poor; (A5) Query Result is carried out to line item.Wherein, in described steps A 2, obtain the sequence of selected condition field in whole format fields, according to all form field lengths before sequence and each interfield decollator length, calculate the reference position of this condition field and the length of record field itself; According to file type attribute, judge and in file layout field, whether comprise type of transaction field, if comprise type of transaction field, according to aforementioned manner, obtain reference position and the length of itself, if do not comprise type of transaction, type of transaction is converted to file layout field in internal memory, and comprises following field: type of message, type of message and service point condition code, and according to these fields the sequence in whole format fields, obtain the length of corresponding reference position and itself.Described step 2 also comprises: load need statistics format fields (all kinds of amount field such as capital, service charge) corresponding to file type, and obtain reference position and itself length according to foregoing mode; Obtain all display format fields in internal memory, and obtain reference position and itself length according to foregoing mode.In steps A 3, read in after line item, according to condition field reference position and field length, employing is read substring mode and is located the information obtaining in line item, carry out fuzzy matching (if exact matching with the information of typing, carry out exact matching), if the packets of information in line item contains or be consistent with entry information, be considered as this condition field coupling.Otherwise abandon this line item, take off a line recording processing; Simultaneously, read in after line item, according to condition field reference position and field length, location obtains the information in line item, carry out fuzzy matching (if exact matching carries out exact matching) with the information of typing, the packets of information in line item containing or when consistent with entry information, if there is type of transaction field in file layout, be considered as coupling.If there is no type of transaction field in file layout, after conversion to comprise field information all consistent, be considered as type of transaction coupling.Otherwise abandon this line item, take off a line recording processing.In steps A 4, according to after type of transaction classification, location obtains the information in this line item, with the same amount field of type of transaction (as being capital field), roll before poor.In steps A 5, Query Result is carried out to record, according to display field reference position and field length, location obtains the information in line item, enter and show result treatment process, and secondary file is when generate, after specifying the Information locating needing, combine, in writing in files.
Figure 2 shows that the process flow diagram that file Kinematic Positioning is processed 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 querying method further comprises: (B1) load configurations file; (B2) load the conditional information of typing; (B3) locating information of querying condition field; (B4) according to locating information, directly flowing water is carried out to value; (B5) locating information value is processed.In step B1, according to selecting filename to be processed, load associated documents name parameter, comprising: file layout field name, length, condition field whether, amount field whether, whether channel information etc.; Load channel translation information, load transaction translation information, load amount of money statistical information; Parameter is loaded in internal memory, and take respectively structure, container is object, for follow-up.In step B2, conditional information to typing, the inquiry field that comprises selection, the conditional value of input, mode record to each condition with structure, comprise respectively: field name, field length (load and obtain from parameter), initial conditions storage container (may comprise a plurality of input values); Successively each alternative condition is loaded in internal memory container in structure mode respectively, for follow-up.In step B3, according to condition field title, in file layout field internal memory, search, because file layout field is arranged in order, for all field length values before this field, and the shared length of field separator adds up, obtain the reference position of condition field in a line flowing water, and using this condition field self length as deflected length.Be recorded in condition internal storage structure body.In step B4, when inquiring about or add up, by a line flowing water obtaining, according to each condition field reference position, deflected length, use substring directly to obtain assigned address content.In step B5, according to the locator value of obtaining in step B4, in the information that this locator value is located and construction of condition body container, the conditional value of typing carries out accurately/fuzzy matching, if the match is successful, according to the construction of condition body content of all loadings in condition container, circulation step B4.If run into, it fails to match, directly abandons this row flowing water, takes off a line flowing water and re-execute step B4; If meet all conditions content, enter type of transaction translation, the amount of money rolls poor processing; According to step B3, B4, by the field value of getting combinations matches in internal memory, obtain type of transaction; By amount field according to borrow, borrow directional statistics roll 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: in the situation that not departing 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 a querying method, described file Kinematic Positioning and querying method comprise the steps:
(A1) typing user Query Information, described Query Information comprises type of transaction information;
(A2) according to described user's Query Information, locate selecteed field;
(A3) according to oriented described field, obtain the information in line item, and the information in described line item is mated with the information of typing, wherein, carry out in the following way type of transaction coupling: the packets of information in line item containing or when consistent with entry information, if there is type of transaction field in file layout, be considered as coupling, if there is no type of transaction field in file layout, if the field information comprising after conversion is all consistent, be considered as type of transaction coupling;
(A4), according to the type of transaction of having mated, the amount field of locating in described line item is rolled poor operation to carry out the amount of money;
(A5) Query Result is carried out to line item;
Wherein, in step (A2), obtain the sequence of selecteed condition field in whole format fields, according to all form field lengths before described sequence and each interfield decollator length, the length of calculating the reference position of described condition field and recording 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 step (A2) comprises selecteed condition field, selecteed type of transaction field, transaction statistics format fields and result display field.
3. file Kinematic Positioning according to claim 1 and querying method, it is characterized in that, step (A2) further comprises: according to file type attribute, judge and in file layout field, whether comprise type of transaction field, if comprise type of transaction field, according to the mode of step (A2), obtain 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, type of transaction is converted to file layout field in internal memory, and according to described field the sequence in whole format fields, obtain the length of corresponding reference position and described field itself.
4. according to file Kinematic Positioning and querying method described in any claim in claim 1-2, it is characterized in that, described file Kinematic Positioning and querying method are performed under windows platform.
5. according to file Kinematic Positioning and querying method described in any claim in claim 1-2, it is characterized in that, described step (A2) further comprises:
(B1) load configurations file;
(B2) load the conditional information of typing;
(B3) locating information of querying condition field;
(B4) according to locating information, directly flowing water is carried out to value;
(B5) locating information value is processed.
6. file Kinematic Positioning according to claim 5 and querying method, is characterized in that, step (B1) further comprises:
According to selecting filename to be processed, load associated documents name parameter;
Load channel translation information, transaction translation information and amount of money statistical information;
Parameter is loaded in internal memory, and to take respectively structure, container be object.
7. file Kinematic Positioning according to claim 5 and querying method, is characterized in that, step (B3) further comprises:
According to condition field title, in file layout field internal memory, search, for all field length values before described field, and the shared length of field separator is added up, obtain the reference position of condition field in a line flowing water, and described condition field self length is recorded in condition internal storage structure body as deflected length.
8. file Kinematic Positioning according to claim 5 and querying method, is characterized in that, step (B4) further comprises:
When inquiring about or add up, by a line flowing water obtaining, according to each condition field reference position, deflected length, use substring directly to obtain assigned address content.
9. file Kinematic Positioning according to claim 5 and querying method, is characterized in that, step (B5) further comprises:
According to the locator value of obtaining in step (B4), in the information that described locator value is located and construction of condition body container, the conditional value of typing carries out accurately/fuzzy matching, if the match is successful,, according to the construction of condition body content of all loadings in condition container, circulation performs step (B4); If run into, it fails to match, directly abandons flowing water, takes off a line 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 CN102117293A (en) | 2011-07-06 |
| CN102117293B true 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) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105930325B (en) * | 2015-11-19 | 2019-05-24 | 中国银联股份有限公司 | A kind of file report compares the conversed analysis method and device of difference |
| CN108418703B (en) * | 2018-01-10 | 2021-06-25 | 北京思特奇信息技术股份有限公司 | Early warning method and system based on real-time event detection |
| CN109697216B (en) * | 2018-12-18 | 2021-04-20 | 中国银行股份有限公司 | Clearing transaction information processing method, device 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102117293A (en) | 2011-07-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101133429B (en) | Document/image searching method, and document/image recording and searching device | |
| US10740372B2 (en) | System and method for extracting data from a non-structured document | |
| CN107122369B (en) | Service data processing method, device and system | |
| US5867596A (en) | Method for diagram recognition by using recognizing rules and system for implementing the method | |
| CN102023989A (en) | Information retrieval method and system thereof | |
| US20060167911A1 (en) | Automatic data pattern recognition and extraction | |
| CN104298736A (en) | Method and device for aggregating and connecting data as well as database system | |
| CN102567297A (en) | Data conversion device and data conversion method | |
| CN108875077A (en) | Column storage method, device, server and the storage medium of database | |
| CN102117293B (en) | Dynamic file positioning and query method | |
| 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 | |
| CN108664471A (en) | Text region error correction method, device, equipment and computer readable storage medium | |
| CN115905630A (en) | Graph database query method, device, equipment and storage medium | |
| CN114970475A (en) | excel table analysis method, system, equipment and storage medium | |
| EP1988475A1 (en) | Object reference method and system based on object storage library | |
| CN102110006A (en) | System and method for expanding and developing application business | |
| US11308130B1 (en) | Constructing ground truth when classifying data | |
| CN104915435A (en) | Data query method and device | |
| US10782942B1 (en) | Rapid onboarding of data from diverse data sources into standardized objects with parser and unit test generation | |
| CN107909054A (en) | The method for evaluating similarity and device of picture text | |
| CN108073678A (en) | Applied to document analyzing and processing method, system and the device in big data analysis | |
| CN104408097A (en) | Hybrid indexing method and system based on character field hot update | |
| CN115391584A (en) | Method and device for extracting invoice information, computer equipment and storage medium | |
| CN109815470A (en) | Accreditation data creation method, device, computer equipment 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 |