CN109241137A - A kind of line number fuzzy query method and device - Google Patents
A kind of line number fuzzy query method and device Download PDFInfo
- Publication number
- CN109241137A CN109241137A CN201810984423.XA CN201810984423A CN109241137A CN 109241137 A CN109241137 A CN 109241137A CN 201810984423 A CN201810984423 A CN 201810984423A CN 109241137 A CN109241137 A CN 109241137A
- Authority
- CN
- China
- Prior art keywords
- record
- field
- line number
- inquiry
- fuzzy query
- 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
- 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
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of line number fuzzy query method and devices, are related to Financial Information e-management technical field.The inquiry field that user inputs is split at least one critical field first by the line number fuzzy query method, determining and each corresponding first record of critical field and the second record corresponding with the inquiry field, then first record and second record are merged, shown after duplicate removal.The inquiry field that user inputs is split into critical field by the line number fuzzy query method, search and the critical field or the entire inquiry matched record of field respectively, expand the range of data search, the accuracy of user query is improved, also shows that connection line number query result to the more accurate feedback of user by merging, duplicate removal.
Description
Technical field
The present invention relates to Financial Information e-management technical fields, in particular to a kind of line number fuzzy query side
Method and device.
Background technique
With the development of the social economy, the finance data amount of the world today is increasingly huge, while with the countries in the world world
The quickening of change process and domestic each province and city exchange it is increased, the of ac of finance data is also in that explosion type increases.Each
In the routine operation of big bank, when teller's transacting business process, is frequently necessary to the connection line number and name of each financial institution in the typing whole nation
Claim, can then be consumed when numerous, the corresponding Unionpay number of bank quantity inputs very complicated, then by word for word keying in bank's name or Unionpay number
Take the plenty of time.Therefore the connection line number query function used on an electronic device has been indispensable common function.
But existing line number query function need user inputted when carrying out connection line number inquiry complete bank name or
Join line number, matched line number record could be found in systems, the input for making user need to carry out is complicated for operation, expends the time
It is long, while the wrong query result of rear line display in input error, inquire poor accuracy, in some instances it may even be possible to cause great
Economic loss.
Summary of the invention
In view of this, the embodiment of the present invention is designed to provide a kind of line number fuzzy query method and device, with solution
The problem that inquiry velocity existing for certainly above-mentioned existing line number querying method is slow, inquiry accuracy is low.
In a first aspect, the embodiment of the invention provides a kind of line number fuzzy query method, the line number fuzzy query
The inquiry field that user inputs is split at least one critical field first by method, determines corresponding with each critical field the
One record and the second record corresponding with the inquiry field, then first record and second record are closed
And it is shown after duplicate removal.
It is comprehensive in a first aspect, split at least one critical field in the inquiry field by user's input, it is described
Line number fuzzy query method includes: to judge whether the inquiry field includes separator that user is actively entered；If so, described
" the inquiry field that user inputs is split at least one critical field " includes: to look into according to the separator by what user inputted
It askes field and splits at least one critical field.
It is comprehensive in a first aspect, it is described judge whether the inquiry field includes the separator that user is actively entered after,
The line number fuzzy query method further include: if it is not, described " split at least one key for the inquiry field that user inputs
Field " includes: that the inquiry field of user's input is split at least one critical field according to word for word fractionation rule.
Synthesis is in a first aspect, the determination the first record corresponding with each critical field, comprising: achieves note in connection line number
Search determines described comprising being recorded as the first record comprising any keyword comprising record in record.
Synthesis is in a first aspect, the determination the second record corresponding with the inquiry field, comprising: achieves note in connection line number
Search determines described comprising being recorded as the second record comprising the inquiry field comprising record in record.
Synthesis is in a first aspect, the determination the second record corresponding with the inquiry field, comprising: achieves note in connection line number
Searched in record it is identical with the inquiry field is equal to record, determine and described be equally recorded as the second record.
Synthesis is in a first aspect, the line number fuzzy query method further include: determines the inquiry field of user's input
For number；The third record of the field headed by the inquiry field is determined in connection line number file record；And in the row
The 4th record comprising the inquiry field is determined in number file record；Third record and the 4th record are closed
And it is shown after duplicate removal.
Second aspect, the embodiment of the invention provides a kind of line number fuzzy query device, the line number fuzzy query
Device includes that field splits module, the first record search module and processing display module.The field splits module for that will use
The inquiry field of family input splits at least one critical field.The first record search module is for determining and each key
Corresponding first record of field, determines the second record corresponding with the inquiry field.The processing display module is used for institute
It states the first record and second record is merged, shown after duplicate removal.
Comprehensive second aspect, the line number fuzzy query device further include inquiry field type judgment module and the second note
Record search module.The inquiry field type judgment module is used to determine that the inquiry field of user's input to be number.It is described
Second record search module is used to determine the third record of the field headed by the inquiry field in connection line number file record,
The 4th record comprising the inquiry field is determined in the line number file record.
The third aspect, the embodiment of the invention also provides a kind of computer-readable storage medium, the storage medium is deposited
It is stored in computer, the storage medium includes a plurality of instruction, and a plurality of instruction is configured such that the computer executes
Above-mentioned method.
Beneficial effect provided by the invention is:
The present invention provides a kind of line number fuzzy query method and device, the line number fuzzy query method is by user
The inquiry field of input splits into multiple critical fielies, using in subsequent query by each critical field as individual inquiry word
Duan Jinhang record matching obtains the first record, improves the accuracy rate and serious forgiveness of connection line number inquiry.Meanwhile also user being inputted
Complete inquiry field carry out record matching as complete individually inquiry field, obtain the second record, further increase
The serious forgiveness of the line number fuzzy query method.Further, the line number fuzzy query method is also by described first
Record and it is described second record merge, duplicate removal, avoid the user effort plenty of time carry out query result screening and phase
The cumbersome user's operation answered improves the search efficiency of connection line number inquiry and the precise degrees of query result.
Other features and advantages of the present invention will be illustrated in subsequent specification, also, partly be become from specification
It is clear that by implementing understanding of the embodiment of the present invention.The objectives and other advantages of the invention can be by written theory
Specifically noted structure is achieved and obtained in bright book, claims and attached drawing.
Detailed description of the invention
In order to illustrate the technical solution of the embodiments of the present invention more clearly, below will be to needed in the embodiment attached
Figure is briefly described, it should be understood that the following drawings illustrates only certain embodiments of the present invention, therefore is not construed as pair
The restriction of range for those of ordinary skill in the art without creative efforts, can also be according to this
A little attached drawings obtain other relevant attached drawings.
Fig. 1 is a kind of flow chart for line number fuzzy query method that first embodiment of the invention provides；
Fig. 2 is a kind of flow chart for critical field splitting step that first embodiment of the invention provides；
Fig. 3 is a kind of flow chart for bank name query steps that first embodiment of the invention provides；
Fig. 4 is a kind of module map for line number fuzzy query device that second embodiment of the invention provides；
Fig. 5 shows a kind of structural block diagram of electronic equipment 200 that can be applied in the embodiment of the present application.
Icon: 100- joins line number fuzzy query device；105- inquires field type judgment module；110- field is split
Module；120- first records search module；125- second records search module；130- handles display module；200- electronics
Equipment；201- memory；202- storage control；203- processor；204- Peripheral Interface；205- input-output unit；
206- audio unit；207- display unit.
Specific embodiment
Below in conjunction with attached drawing in the embodiment of the present invention, technical solution in the embodiment of the present invention carries out clear, complete
Ground description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.Usually exist
The component of the embodiment of the present invention described and illustrated in attached drawing can be arranged and be designed with a variety of different configurations herein.Cause
This, is not intended to limit claimed invention to the detailed description of the embodiment of the present invention provided in the accompanying drawings below
Range, but it is merely representative of selected embodiment of the invention.Based on the embodiment of the present invention, those skilled in the art are not doing
Every other embodiment obtained under the premise of creative work out, shall fall within the protection scope of the present invention.
It should also be noted that similar label and letter indicate similar terms in following attached drawing, therefore, once a certain Xiang Yi
It is defined in a attached drawing, does not then need that it is further defined and explained in subsequent attached drawing.Meanwhile of the invention
In description, term " first ", " second " etc. are only used for distinguishing description, are not understood to indicate or imply relative importance.
Next the technical term that the embodiment of the present invention may relate to is explained, it is exactly a ground that bank, which joins line number,
The unique identification mark of bank of area, the large-amount payment system organized for the People's Bank small amount payment system city commercial silver
Row bank draft system the trans-regional payment such as whole nation check image system (the local bill Document Automatic Clearing System Based containing some cities)
Account settlement business.Bank's connection line number is formed by 12: 3+1 bit check positions of the city codes+4 of Routing Number+4 Bank Number.
First embodiment
Through the applicant the study found that existing line number querying method to generally require user completely defeated by the row name of bank
Enter to inquire corresponding line number, or connection line number completely inputted to obtain corresponding row name, need user carry out it is complicated,
Time-consuming input operation, and the connection line number query result of mistake can be shown when the error occurs in input, and can not be to user
Error checking and prompt are carried out, there is a problem of that connection line number search efficiency is low, accuracy rate is low.To solve the above-mentioned problems, this hair
Bright first embodiment provides a kind of line number fuzzy query method.
Referring to FIG. 1, Fig. 1 is a kind of flow chart for line number fuzzy query method that first embodiment of the invention provides.
Specific step is as follows for the line number fuzzy query method:
Step S10: the inquiry field that user inputs is split at least one critical field by query service device.
Step S20: the query service device determines corresponding with each critical field first in Unionpay's file record
Record.
Step S30: query service device determination in Unionpay's file record is corresponding with the inquiry field
Second record.
Step S40: the query service device merges first record and second record, carries out after duplicate removal
Display.
For step S10, the query service device can be the common Cloud Server with data computing capability, be used for
The inquiry field of user's input is received and processed, and is searched and the inquiry in the database for being stored with Unionpay's file record
The record of fields match, be also used to merge the record of acquisition, duplicate removal and generate query result show information.User is defeated
When entering the inquiry field, it can be and inputted in the inquiry field input area that system gives, and the inquiry field is defeated
Entering region can be division input type, such as is labeled with the input area of " bank's name " and is labeled with the input of " connection line number "
Region, then the query service device directly passes through input area still " connection line number " input area acquisition from " bank's name "
Inquiry field determine the type of the inquiry field, i.e., the described inquiry field is bank's name (for being inquired pair by bank
The connection line number answered) or connection line number (for inquiring bank's name by connection line number).Optionally, the length of the critical field can be with
It is a character or multiple characters, the upper limit of number of characters can be adjusted as the case may be.
For step S20, it may be assumed that query service device determination in Unionpay's file record is corresponding with each critical field
First record.Wherein, first record may include a plurality of record, as long as with one or more critical fielies for splitting out
In any one critical field it is corresponding record be the first record.Meanwhile the data source of first record is usually
Connection line number file record in Unionpay's database.
For step S30, it is described second record may include a plurality of record, and it is described second record need be with completely
The corresponding record of field is inquired, therefore entire inquiry field can also be considered as a list by the query service device in this step
Only critical field.Meanwhile recorded with described first it is identical, it is described second record data source be also in Unionpay's database
Join line number file record.
If user checks that the query result stage can take considerable time when not succinct accurate enough in view of query result
Query result screening is carried out, therefore also needs to be implemented step S40 i.e. " the query service device is to first record and described the
Two records are merged, are shown after duplicate removal ", to carry out automatic screening to the query result finally shown to user.It is optional
Ground, the query service device directly by database carry out query result output when, can according to corresponding database manipulation into
The merging of row record, duplicate removal, by taking SQL database as an example, it is described merge, the specific steps of duplicate removal can be with are as follows: (1) it is more in look-up table
Remaining repetition record, repeating record is judged according to single field (peopleId)；(2) repetition note extra in table is deleted
Record, repeating record is judged according to single field (peopleId), and only there are the smallest records of rowid；(3) more in look-up table
Remaining repetition records (multiple fields)；(4) it deletes repetition extra in table and records (multiple fields), it is the smallest that only there are rowid
Record.
In above-mentioned line number fuzzy query method, query service device splits into bank's name inquiry field that user inputs more
Then a critical field is successively inquired record corresponding with each keyword match in connection line number file record, while being joined
In line number file record inquiry with, as the corresponding record of keyword, improved using entirely inquiring field join line number inquire it is accurate
Property and serious forgiveness, and the record for inquiring acquisition twice is merged, be shown after duplicate removal, greatly improve the aobvious of query result
Show succinct degree and accuracy, user is avoided to waste more time cost on screening query result.
Optionally, it is contemplated that user may carry out personalized critical field to inquiry field according to self-demand and tear open
Point.Referring to FIG. 2, Fig. 2 is a kind of flow chart for critical field splitting step that first embodiment of the invention provides, step S10
It is rapid including following sub-portion:
Step S11: the query service device judges whether the inquiry field includes separator that user is actively entered.
Step S12: if so, the query service device according to the separator by the inquiry field that user inputs split into
A few critical field.
Step S13: if it is not, the query service device is split into according to the regular inquiry field by user's input is word for word split
At least one critical field.
For step S11, the separator can be " % " that user inputs wherein while input inquiry field,
The symbols such as "/".
For step S13, if only one character of the inquiry field of user's input, the critical field which obtains
It is just overlapped with inquiry field, optionally, the query service device can in advance carry out the number of characters for inquiring field in such cases
Judgement can also be according to former step to fractionation in only one character of inquiry field of user's input without S10 and S20
Complete key section afterwards carries out record search.
The line number fuzzy query method can be preferably according to the autonomous of user by above-mentioned key word split step
Wish splits inquiry field, and regular by inquiry word according to scheduled word for word fractionation when user actively split
Section is split completely, and the accuracy and accuracy of connection line number inquiry are improved while providing biggish independence for user.
Optionally, it after for splitting inquiry field by step S10, needs to be existed according to the critical field after fractionation
Search meets the record of matching condition in connection line number file record, wherein the matching condition may include comprising matching and accurate
Matching: comprising matching, i.e., the record comprising critical field or complete inquiry field is and the critical field or inquiry word
The corresponding record of section；Equivalent matching, i.e., with the critical field or complete inquiry field it is identical be recorded as with it is described
Critical field or the corresponding record of inquiry field.Therefore step S20 is specifically as follows: the query service device is achieved in connection line number
Search determines described comprising being recorded as the first record comprising any keyword comprising record in record；Step S30 specifically can be with
The search that includes: the query service device in connection line number file record comprising the inquiry field comprising record, determine described in
Comprising being recorded as the second record；And connection line number file record in search it is identical with the inquiry field be equal to record, really
It is calmly described to be equally recorded as the second record.
Optionally, in order to which user is when checking final display result, the query service device can also judge to merge, go
Whether the query result after weight is one, directly carries out feedback to user at only one and shows, raw when for more than one
Display corresponding lists are fed back at drop-down list rear line.
Simultaneously inquiry record is carried out to include that matching and equivalent matched embodiment further improve connection line number and look into
The accuracy of inquiry, while serious forgiveness is greatly improved, it avoids user that from can not getting when inputting some wrong word and thinks originally
The matching result wanted.
As an implementation, line number fuzzy query method provided in this embodiment further includes by connection line number inquiry
The function of bank's name, referring to FIG. 3, Fig. 3 is a kind of flow chart for bank name query steps that first embodiment of the invention provides,
The step is specific as follows:
Step S50: the query service device determines that the inquiry field of user's input is number.
Step S60: the query service device determines the field headed by the inquiry field in connection line number file record
Third record.
Step S70: the query service device determines the comprising the inquiry field in the line number file record
Four records.
Step S80: the query service device merges third record and the 4th record, carries out after duplicate removal
Display.
For step S60, the lead-in section refers to the beginning field of a record, such as field " 123456789 ", " 1 ",
" 12 ", " 123 ", " 123456 " type field be the lead-in section of field " 123456789 ".
It is provided above by the embodiment of bank's name inquiry connection line number for the connection line number fuzzy query method of the present embodiment
It inquires user rapidly by bank's name distich line number, has the line number fuzzy query method preferably suitable
With property and practicability.
Second embodiment
In order to which the line number fuzzy query method of first embodiment of the invention offer, the present invention second is better achieved
Embodiment additionally provides a kind of line number fuzzy query device 100.
Referring to FIG. 4, Fig. 4 is a kind of module map for line number fuzzy query device that second embodiment of the invention provides.
Joining line number fuzzy query device 100 includes that field splits the record search module 120 of module 110, first and handles aobvious
Show module 130.
Field splits module 110, and the inquiry field for inputting user splits at least one critical field.
First record search module 120, for determining the first record corresponding with each critical field, determination is looked into described
Ask corresponding second record of field.
Display module 130 is handled, for merging to first record and second record, showing after duplicate removal
Show.
As an implementation, connection line number fuzzy query device 100 can also include inquiry field type judgment module
105 and second record search module 125.
Field type judgment module 105 is inquired, for determining that the inquiry field of user's input is number.
Second record search module 125, for determining the field headed by the inquiry field in connection line number file record
Third record, in the line number file record determine comprising it is described inquiry field the 4th record.
It is apparent to those skilled in the art that for convenience and simplicity of description, the device of foregoing description
Specific work process, no longer can excessively be repeated herein with reference to the corresponding process in preceding method.
3rd embodiment
Referring to figure 5., Fig. 5 shows a kind of structural block diagram of electronic equipment 200 that can be applied in the embodiment of the present application.
Electronic equipment 200 may include connection line number fuzzy query device 100, memory 201, storage control 202, processor 203, outer
If interface 204, input-output unit 205, audio unit 206, display unit 207.
The memory 201, storage control 202, processor 203, Peripheral Interface 204, input-output unit 205, sound
Frequency unit 206, each element of display unit 207 are directly or indirectly electrically connected between each other, to realize the transmission or friendship of data
Mutually.It is electrically connected for example, these elements can be realized between each other by one or more communication bus or signal wire.The row
Number fuzzy query device 100 includes that at least one can be stored in the memory in the form of software or firmware (firmware)
In 201 or be solidificated in connection line number fuzzy query device 100 operating system (operating system, OS) in software function
Module.The processor 203 is for executing the executable module stored in memory 201, such as connection line number fuzzy query device
100 software function modules or computer program for including.
Wherein, memory 201 may be, but not limited to, random access memory (Random Access Memory,
RAM), read-only memory (Read Only Memory, ROM), programmable read only memory (Programmable Read-
Only Memory, PROM), erasable read-only memory (Erasable Programmable Read-Only Memory,
EPROM), electricallyerasable ROM (EEROM) (Electric Erasable Programmable Read-Only Memory,
EEPROM) etc..Wherein, memory 201 is for storing program, and the processor 203 is after receiving and executing instruction, described in execution
Program, method performed by the server that the stream process that aforementioned any embodiment of the embodiment of the present invention discloses defines can be applied to
In processor 203, or realized by processor 203.
Processor 203 can be a kind of IC chip, the processing capacity with signal.Above-mentioned processor 203 can
To be general processor, including central processing unit (Central Processing Unit, abbreviation CPU), network processing unit
(Network Processor, abbreviation NP) etc.；Can also be digital signal processor (DSP), specific integrated circuit (ASIC),
Ready-made programmable gate array (FPGA) either other programmable logic device, discrete gate or transistor logic, discrete hard
Part component.It may be implemented or execute disclosed each method, step and the logic diagram in the embodiment of the present invention.General processor
It can be microprocessor or the processor 203 be also possible to any conventional processor etc..
Various input/output devices are couple processor 203 and memory 201 by the Peripheral Interface 204.Some
In embodiment, Peripheral Interface 204, processor 203 and storage control 202 can be realized in one single chip.Other one
In a little examples, they can be realized by independent chip respectively.
Input-output unit 205 realizes user and the server (or local terminal) for being supplied to user input data
Interaction.The input-output unit 205 may be, but not limited to, the equipment such as mouse and keyboard.
Audio unit 206 provides a user audio interface, may include one or more microphones, one or more raises
Sound device and voicefrequency circuit.
Display unit 207 provides an interactive interface (such as user's operation circle between the electronic equipment 200 and user
Face) or for display image data give user reference.In the present embodiment, the display unit 207 can be liquid crystal display
Or touch control display.It can be the capacitance type touch control screen or resistance of support single-point and multi-point touch operation if touch control display
Formula touch screen etc..Single-point and multi-point touch operation is supported to refer to that touch control display can sense on the touch control display one
Or at multiple positions simultaneously generate touch control operation, and the touch control operation that this is sensed transfer to processor 203 carry out calculate and
Processing.
It is appreciated that structure shown in fig. 5 is only to illustrate, the electronic equipment 200 may also include more than shown in Fig. 5
Perhaps less component or with the configuration different from shown in Fig. 5.Each component shown in Fig. 5 can use hardware, software
Or combinations thereof realize.
It is apparent to those skilled in the art that for convenience and simplicity of description, the device of foregoing description
Specific work process, no longer can excessively be repeated herein with reference to the corresponding process in preceding method.
In conclusion the embodiment of the invention provides a kind of line number fuzzy query method and device, the line number mould
Paste querying method and the inquiry field that user inputs split into multiple critical fielies, in subsequent query by each critical field
Record matching is carried out as individual inquiry field and obtains the first record, improves the accuracy rate and serious forgiveness of connection line number inquiry.
Meanwhile also record matching is carried out using the complete inquiry field of user's input as complete individually inquiry field, acquisition the
Two records, further improve the serious forgiveness of the line number fuzzy query method.Further, the line number fuzzy query
Method also by it is described first record and it is described second record merge, duplicate removal, avoid the user effort plenty of time from being inquired
As a result screening and corresponding cumbersome user's operation, improve the accurate of the search efficiency and query result for joining line number inquiry
Degree.
In several embodiments provided herein, it should be understood that disclosed device and method can also pass through
Other modes are realized.The apparatus embodiments described above are merely exemplary, for example, flow chart and block diagram in attached drawing
Show the device of multiple embodiments according to the present invention, the architectural framework in the cards of method and computer program product,
Function and operation.In this regard, each box in flowchart or block diagram can represent the one of a module, section or code
Part, a part of the module, section or code, which includes that one or more is for implementing the specified logical function, to be held
Row instruction.It should also be noted that function marked in the box can also be to be different from some implementations as replacement
The sequence marked in attached drawing occurs.For example, two continuous boxes can actually be basically executed in parallel, they are sometimes
It can execute in the opposite order, this depends on the function involved.It is also noted that every in block diagram and or flow chart
The combination of box in a box and block diagram and or flow chart can use the dedicated base for executing defined function or movement
It realizes, or can realize using a combination of dedicated hardware and computer instructions in the system of hardware.
In addition, each functional module in each embodiment of the present invention can integrate one independent portion of formation together
Point, it is also possible to modules individualism, an independent part can also be integrated to form with two or more modules.
It, can be with if the function is realized and when sold or used as an independent product in the form of software function module
It is stored in a computer readable storage medium.Based on this understanding, technical solution of the present invention is substantially in other words
The part of the part that contributes to existing technology or the technical solution can be embodied in the form of software products, the meter
Calculation machine software product is stored in a storage medium, including some instructions are used so that a computer equipment (can be a
People's computer, server or network equipment etc.) it performs all or part of the steps of the method described in the various embodiments of the present invention.
And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), arbitrary access
The various media that can store program code such as memory (RAM, Random Access Memory), magnetic or disk.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field
For art personnel, the invention may be variously modified and varied.All within the spirits and principles of the present invention, made any to repair
Change, equivalent replacement, improvement etc., should all be included in the protection scope of the present invention.It should also be noted that similar label and letter exist
Similar terms are indicated in following attached drawing, therefore, once being defined in a certain Xiang Yi attached drawing, are then not required in subsequent attached drawing
It is further defined and explained.
The above description is merely a specific embodiment, but scope of protection of the present invention is not limited thereto, any
Those familiar with the art in the technical scope disclosed by the present invention, can easily think of the change or the replacement, and should all contain
Lid is within protection scope of the present invention.Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
It should be noted that, in this document, relational terms such as first and second and the like are used merely to a reality
Body or operation are distinguished with another entity or operation, are deposited without necessarily requiring or implying between these entities or operation
In any actual relationship or order or sequence.Moreover, the terms "include", "comprise" or its any other variant are intended to
Non-exclusive inclusion, so that the process, method, article or equipment including a series of elements is not only wanted including those
Element, but also including other elements that are not explicitly listed, or further include for this process, method, article or equipment
Intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that
There is also other identical elements in process, method, article or equipment including the element.
Claims (10)
1. a kind of line number fuzzy query method, which is characterized in that the line number fuzzy query method includes:
The inquiry field that user inputs is split into at least one critical field；
Determine the first record corresponding with each critical field；And
Determine the second record corresponding with the inquiry field；
First record and second record are merged, shown after duplicate removal.
2. line number fuzzy query method according to claim 1, which is characterized in that in the inquiry for inputting user
Field splits at least one critical field, and the line number fuzzy query method includes:
Judge whether the inquiry field includes separator that user is actively entered；
If so, described " the inquiry field that user inputs is split at least one critical field " includes: according to the separator
The inquiry field that user inputs is split into at least one critical field.
3. line number fuzzy query method according to claim 2, which is characterized in that in the judgement inquiry field
It whether include the line number fuzzy query method after the separator that user is actively entered further include:
If it is not, " the inquiry field that user inputs is split at least one critical field " includes: according to word for word fractionation rule
The inquiry field that user inputs then is split into at least one critical field.
4. line number fuzzy query method according to claim 1, which is characterized in that the determination and each critical field
Corresponding first record, comprising:
Search determines described comprising being recorded as the first note comprising any keyword comprising record in connection line number file record
Record.
5. line number fuzzy query method according to claim 1, which is characterized in that the determination and the inquiry field
Corresponding second record, comprising:
Search determines described comprising being recorded as the second note comprising the inquiry field comprising record in connection line number file record
Record.
6. line number fuzzy query method according to claim 5, which is characterized in that the determination and the inquiry field
Corresponding second record, comprising:
Search is identical with the inquiry field in connection line number file record is equal to record, determines and described is equally recorded as second
Record.
7. line number fuzzy query method according to claim 1, which is characterized in that the line number fuzzy query method
Further include:
The inquiry field for determining user's input is number；
The third record of the field headed by the inquiry field is determined in connection line number file record；And it is deposited in the line number
The 4th record comprising the inquiry field is determined in shelves record；
Third record and the 4th record are merged, shown after duplicate removal.
8. a kind of line number fuzzy query device, which is characterized in that the line number fuzzy query device includes:
Field splits module, and the inquiry field for inputting user splits at least one critical field；
First record search module, for determining the first record corresponding with each critical field, determination and the inquiry field
Corresponding second record；
Display module is handled, for merging to first record and second record, showing after duplicate removal.
9. line number fuzzy query device according to claim 8, which is characterized in that the line number fuzzy query device
Further include:
Field type judgment module is inquired, for determining that the inquiry field of user's input is number；
Second record search module, for determining the third note of the field headed by the inquiry field in connection line number file record
Record determines the 4th record comprising the inquiry field in the line number file record.
10. a kind of computer-readable storage medium, which is characterized in that be stored with meter in the computer-readable storage medium
Calculation machine program instruction, when the computer program instructions are read and run by a processor, perform claim requires any one of 1-5
Step in the method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810984423.XA CN109241137A (en) | 2018-08-27 | 2018-08-27 | A kind of line number fuzzy query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810984423.XA CN109241137A (en) | 2018-08-27 | 2018-08-27 | A kind of line number fuzzy query method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109241137A true CN109241137A (en) | 2019-01-18 |
Family
ID=65069366
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810984423.XA Pending CN109241137A (en) | 2018-08-27 | 2018-08-27 | A kind of line number fuzzy query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109241137A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113535822A (en) * | 2021-07-23 | 2021-10-22 | 中信银行股份有限公司 | Bank connection number matching method and matching device, storage medium and equipment |
| CN114817293A (en) * | 2022-03-31 | 2022-07-29 | 华能信息技术有限公司 | Data query method and system based on distributed SQL |
| CN113535822B (en) * | 2021-07-23 | 2024-05-24 | 中信银行股份有限公司 | Bank line number matching method and device, storage medium and equipment |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2010003129A2 (en) * | 2008-07-03 | 2010-01-07 | The Regents Of The University Of California | A method for efficiently supporting interactive, fuzzy search on structured data |
| CN106528651A (en) * | 2016-10-08 | 2017-03-22 | 温州大学 | Home database-oriented fuzzy query method |
| CN106934069A (en) * | 2017-04-24 | 2017-07-07 | 中国工商银行股份有限公司 | Data retrieval method and system |
| CN107436911A (en) * | 2017-05-24 | 2017-12-05 | 阿里巴巴集团控股有限公司 | Fuzzy query method, device and inquiry system |
| CN108073655A (en) * | 2016-11-15 | 2018-05-25 | 南京途牛科技有限公司 | A kind of data query method and device |
| CN108388635A (en) * | 2018-02-24 | 2018-08-10 | 杭州朗和科技有限公司 | Data search method, device, medium and computing device |
-
2018
- 2018-08-27 CN CN201810984423.XA patent/CN109241137A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2010003129A2 (en) * | 2008-07-03 | 2010-01-07 | The Regents Of The University Of California | A method for efficiently supporting interactive, fuzzy search on structured data |
| CN106528651A (en) * | 2016-10-08 | 2017-03-22 | 温州大学 | Home database-oriented fuzzy query method |
| CN108073655A (en) * | 2016-11-15 | 2018-05-25 | 南京途牛科技有限公司 | A kind of data query method and device |
| CN106934069A (en) * | 2017-04-24 | 2017-07-07 | 中国工商银行股份有限公司 | Data retrieval method and system |
| CN107436911A (en) * | 2017-05-24 | 2017-12-05 | 阿里巴巴集团控股有限公司 | Fuzzy query method, device and inquiry system |
| CN108388635A (en) * | 2018-02-24 | 2018-08-10 | 杭州朗和科技有限公司 | Data search method, device, medium and computing device |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113535822A (en) * | 2021-07-23 | 2021-10-22 | 中信银行股份有限公司 | Bank connection number matching method and matching device, storage medium and equipment |
| CN113535822B (en) * | 2021-07-23 | 2024-05-24 | 中信银行股份有限公司 | Bank line number matching method and device, storage medium and equipment |
| CN114817293A (en) * | 2022-03-31 | 2022-07-29 | 华能信息技术有限公司 | Data query method and system based on distributed SQL |
| CN114817293B (en) * | 2022-03-31 | 2022-11-08 | 华能信息技术有限公司 | Data query method and system based on distributed SQL |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11227104B2 (en) | Composite data creation with refinement suggestions | |
| US8631080B2 (en) | Email characterization | |
| US8612438B2 (en) | Techniques for dynamic cross-filtering | |
| US20090006315A1 (en) | Structured method for schema matching using multiple levels of ontologies | |
| US10546348B1 (en) | Cleaning noise words from transaction descriptions | |
| CN110489481B (en) | Data analysis method and device for industry data and data analysis server | |
| CN111639480A (en) | Text labeling method based on artificial intelligence, electronic device and storage medium | |
| CN105354194A (en) | Intelligent commodity classifying method and system | |
| CN102375885A (en) | Method and device for providing search suggestions corresponding to query sequence | |
| CN110674358A (en) | Enterprise information comparison analysis method and device, computer equipment and storage medium | |
| EP2530610A1 (en) | Apparatus and method of searching and visualizing instance path | |
| CN101661484A (en) | Query method and query system | |
| US20160092960A1 (en) | Product recommendations over multiple stores | |
| KR20100060734A (en) | System for visualization of patent information by forming the keyword based semantic network and method therefor | |
| CN107870915A (en) | Instruction to search result | |
| CN109726295A (en) | Brand knowledge map display methods, device, figure server and storage medium | |
| CN110825817B (en) | Enterprise suspected association judgment method and system | |
| CN112507133A (en) | Method, device, processor and storage medium for realizing association search based on financial product knowledge graph | |
| US11514031B2 (en) | Product navigator | |
| CN109241137A (en) | A kind of line number fuzzy query method and device | |
| CN109902215A (en) | A kind of method and system of deals match | |
| CN105373622A (en) | Information processing method and device | |
| CN114297515B (en) | Information recommendation method and device, electronic equipment and storage medium | |
| CN109284423A (en) | Business option card lookup method and device | |
| CN108985908A (en) | Real estate information sharing method, device, computer readable storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190118 |