Summary of the invention
In view of this, the embodiment of the present invention provides a kind of methods, devices and systems of association index, business number can be utilized
The corresponding relationship between master index field and target index field is established according to the more new data in library, is indexed to realize based on target
Efficient, the accurate inquiry of field.
To achieve the above object, according to an aspect of the invention, there is provided a kind of method of association index.
The method of the association index of the embodiment of the present invention includes: the more new data for obtaining at least one service database;Its
In, any service database includes an at least fragment data table, and any fragment data table includes master index field and at least one
A target index field;It is determined in fragment data table using the more new data, the field value of master index field and target index
Current corresponding relationship between the field value of field stores the current corresponding relationship.
Optionally, the updated data package includes: service database mark, tables of data mark, data line before changing and
Changed data row.
Optionally, the method further includes: obtain at least one service database more new data after, to institute
Service database mark, the tables of data stated in more new data are identified and are verified, and will correspond to the update number of non-fragment data table
According to giving up.
Optionally, described determined in fragment data table using the more new data, the field value of master index field and target
The current corresponding relationship storage is included: from corresponding to fragment number by the current corresponding relationship between the field value of index field
According to the target index field for determining field value change in the more new data of table, it is changed to increase or change or delete described in judgement;
When being judged as increase: will be main in the field value and the more new data in this more new data, after target index field change
The field value of index field is stored in linked database;When being judged as change: by this more new data, the target index field
The field value of master index field is stored in linked database in field value and the more new data after change;By associated data
Library storage, target index field field value before changing and linked database storage, corresponding with field value master
The field value of index field is deleted;When being judged as deletion: before changing by linked database storage, the target index field
The field value of master index field that field value and linked database store, corresponding with the field value is deleted.
Optionally, the linked database is key value database.
Optionally, after the current corresponding relationship being stored, the method further includes: receive service database hair
The inquiry instruction of the carrying query word sent;Wherein, the query word is in the target index field of fragment data table;Acquisition and institute
The field value for stating the corresponding master index field of query word returns to the field value to service database.
Optionally, the more new data is binary log data.
To achieve the above object, according to another aspect of the invention, a kind of device of association index is provided.
The device of the association index of the embodiment of the present invention can include: data acquisition module can be used for obtaining at least one industry
The more new data of business database;Wherein, any service database includes an at least fragment data table, any fragment data table packet
Include master index field and at least one target index field;Index association module can be used for being determined using the more new data and divide
Current corresponding relationship in sheet data table, between the field value of master index field and the field value of target index field, will be described
Current corresponding relationship storage.
Optionally, the more new data can include: service database mark, tables of data mark, data line before changing with
And changed data row.
Optionally, data acquisition module can be further used for: obtain at least one service database more new data it
Afterwards, service database mark, the tables of data mark in the more new data are verified, non-fragment data table will be corresponded to
Update rejection of data.
Optionally, index association module can be further used for: word is determined from the more new data for corresponding to fragment data table
The target index field of segment value change is changed to described in judgement increase or change or delete;When being judged as increase: more by this
The field value storage of master index field in field value and the more new data in new data, after target index field change
In linked database;When being judged as change: by the field value in this more new data, after target index field change, and
The field value of master index field is stored in linked database in the more new data;By linked database storage, target index
The field value of field field value before changing and linked database storage, corresponding with field value master index field is deleted
It removes;When being judged as deletion: by linked database storage, the field value and incidence number of the target index field before changing
It is deleted according to the field value of library storage, corresponding with field value master index field.
Optionally, the linked database is key value database.
Optionally, index association module can be further used for: receive the inquiry for the carrying query word that service database is sent
Instruction;Wherein, the query word is in the target index field of fragment data table;Obtain master index corresponding with the query word
The field value of field returns to the field value to service database.
Optionally, the more new data is binary log data.
To achieve the above object, according to another aspect of the invention, a kind of system of association index is provided.
The system of the association index of the embodiment of the present invention can include: data capture unit, message queue and index association
Unit;Wherein, data capture unit can be used for obtaining the more new data of at least one service database, using message queue by institute
More new data is stated to send to index associative cell;Wherein, any service database includes an at least fragment data table, Ren Yifen
Sheet data table includes master index field and at least one target index field;Index associative cell can be used for utilizing the update number
According to the current corresponding pass determined in fragment data table, between the field value and the field value of target index field of master index field
System, is stored in linked database for the current corresponding relationship.
Optionally, the more new data can include: service database mark, tables of data mark, data line before changing with
And changed data row.
Optionally, data capture unit can be further used for: obtain at least one service database more new data it
Afterwards, service database mark, the tables of data mark in the more new data are verified, non-fragment data table will be corresponded to
Update rejection of data;After sending more new data, the file name of the more new data and reading position are stored.
Optionally, index associative cell can be further used for: store tables of data mark, the master index of any fragment data table
The field name of field and the field name of target index field;For any more new data corresponding to fragment data table, according to
Tables of data mark in the more new data obtains the master index field and target index field of the more new data;From the mesh of acquisition
The target index field for determining field value change in index field is marked, is changed to increase or change or delete described in judgement;Sentencing
When breaking to increase: by master index in the field value and the more new data in this more new data, after target index field change
The field value of field is stored in linked database;When being judged as change: by this more new data, the target index field change
The field value of master index field is stored in linked database in field value and the more new data afterwards;By associated data inventory
Storage, target index field field value before changing and linked database storage, corresponding with field value master index
The field value of field is deleted;And when being judged as deletion: before changing by linked database storage, the target index field
The field value of master index field that field value and linked database store, corresponding with the field value is deleted.
Optionally, the linked database is key value database.
Optionally, index associative cell can be further used for: receive the inquiry for the carrying query word that service database is sent
Instruction;Wherein, the query word is in the target index field of fragment data table;Obtain master index corresponding with the query word
The field value of field returns to the field value to service database.
Optionally, the more new data is binary log data.
To achieve the above object, according to another aspect of the invention, a kind of electronic equipment is provided.
A kind of electronic equipment of the invention includes: one or more processors;Storage device, for storing one or more
Program, when one or more of programs are executed by one or more of processors, so that one or more of processors
The method for realizing association index provided by the present invention.
To achieve the above object, in accordance with a further aspect of the present invention, a kind of computer readable storage medium is provided.
A kind of computer readable storage medium of the invention, is stored thereon with computer program, described program is by processor
The method of association index provided by the present invention is realized when execution.
According to the technique and scheme of the present invention, one embodiment in foregoing invention have the following advantages that or the utility model has the advantages that
Under the premise of not invading original code, using the more new data of service database establish master index field and target index field it
Between corresponding relationship, thus make user can based on target index field carry out efficiently, accurately inquiry, overcome in the prior art
The defect and invade system availability caused by original code that point library divides data caused by table huge are carried out using multiple fields
Poor, the lower defect of search efficiency;Meanwhile the foundation of index field corresponding relationship and the read-write of service database are mutually only
It is vertical, it is lower with original code degree of coupling;In addition, after sending more new data, the file name and reading of real-time storage more new data
Fetch bit is set, it can be ensured that the accurate synchronization of data and the high availability of system.
Further effect possessed by above-mentioned non-usual optional way adds hereinafter in conjunction with specific embodiment
With explanation.
Specific embodiment
Below in conjunction with attached drawing, an exemplary embodiment of the present invention will be described, including the various of the embodiment of the present invention
Details should think them only exemplary to help understanding.Therefore, those of ordinary skill in the art should recognize
It arrives, it can be with various changes and modifications are made to the embodiments described herein, without departing from scope and spirit of the present invention.Together
Sample, for clarity and conciseness, descriptions of well-known functions and structures are omitted from the following description.
The technical solution of the embodiment of the present invention utilizes the update number of service database under the premise of not invading original code
According to the corresponding relationship established between master index field and target index field, to make user that can carry out based on target index field
Efficiently, accurately inquire, overcome in the prior art using multiple fields carry out the defect for dividing data caused by table huge in point library,
And system availability caused by the original code of intrusion is poor, the lower defect of search efficiency;Meanwhile index field corresponding relationship
Foundation and service database read-write it is mutually indepedent, it is lower with original code degree of coupling;In addition, after sending more new data,
The file name and reading position of real-time storage more new data, it can be ensured that the accurate synchronization of data and the High Availabitity of system
Property.
It should be pointed out that in the absence of conflict, the technical characteristic in the embodiment of the present invention and embodiment can
To be combined with each other.
Fig. 1 is the key step schematic diagram according to the method for the association index of the present embodiment.
As shown in Figure 1, the method for the association index of the embodiment of the present invention can execute in accordance with the following steps:
Step S101: the more new data of at least one service database is obtained.
In this step, service database is that table database is divided in a point library, divides list processing to obtain through excessive library wherein being stored with
Fragment data table.Wherein, point library divides table to refer to break through the I/O of single-node data library server (input/output) ability
Limitation solves database scaling concern, and data level is distributed to different databases by a series of segmentation rules
Or the operation in tables of data.
In embodiments of the present invention, a point library divides list processing can be following any:
1. a tables of data in certain database is divided into multiple tables, it is stored in different databases.
2. a tables of data in certain database is divided into multiple tables, it is stored in the database.
It is understood that fragment data table is the tables of data for dividing list processing to obtain by point library.Preferably, this step
In any service database include an at least fragment data table, include master index field in each fragment data table with
At least one target index field.It is understood that master index field refers to the word for carrying out hash operations when table is divided in point library
Section, target index field refer to the field used when in fragment data table except master index field, user query.Practical application
In, it include non-fragment data table toward contact, i.e., not through excessive library point in service database other than comprising fragment data table
The tables of data of list processing.
In practical application, the more new data of service database can be the update number of any data table in service database
According to.Preferably, more new data can be the binary log binlog data for being able to record data alteration.
In embodiments of the present invention, after obtaining more new data, more new data can be resolved to JAVA (JAVA is a kind of
Object-Oriented Programming Language) object, the more new data after parsing is as unit of data line, including service database mark, data
Table mark, the data of all fields of data line before changing, the data of all fields of changed data row.In practical application,
Data line before changing is identical as the field value of the master index field of changed data row.
In concrete application, the data change of more new data reflection generally has following several situations:
1., if the field value of the field is sky before changing, becoming for a certain field of the data line in this more new data
The field value of the field is a certain data more afterwards, then illustrates that the field value of the field increases.
2. for a certain field of the data line in this more new data, if the field value of the field is a certain number before changing
According to the field value of the field is sky after change, then illustrates that the field value of the field is deleted.
3. for a certain field of the data line in this more new data, if the field value of the field is a certain number before changing
According to the field value of the field is another data after change, then illustrates that the field value of the field changes.
It, can be according to preset proof rule to more new data after parsing more new data in an optional implementation
It is verified.Specifically, proof rule, which can be, identifies the canonical table verified to service database mark and tables of data
Up to formula.By the verifying, can determine corresponding to fragment data table more new data (i.e. the more new data be certain fragment data
What table generated) and (i.e. the more new data is that certain non-fragment data table generates corresponding to the more new data of non-fragment data table
).
Specifically, to update data verification when, included respectively service database mark and tables of data mark with
Corresponding regular expression is matched: in successful match, sending next link for more new data;It otherwise will more new data
Give up.
Step S102: it is determined in fragment data table using more new data, the field value of master index field and target index word
Current corresponding relationship between the field value of section, current corresponding relationship is stored.
In this step, the current corresponding relationship refers to: when fragment data table generates more new data, master index field
Field value and target index field field value corresponding relationship, i.e., master index field and target index in the fragment data table
The newest corresponding relationship of field.
Specifically, before the current corresponding relationship of determination, it is necessary first to be directed to any fragment data table, the number is stored in advance
According to the field name of the tables of data mark of table, master index field field name and each target index field.After obtaining more new data,
The tables of data in more new data is selected to identify in pre-stored tables of data mark, so that it is determined that the tables of data identifies corresponding master
Index field field name and each target index field field name, in this way, can determine update according to master index field field name
The master index field of data line in data is that can determine to update the data line in data according to target index field field name
Target index field.
Further, in each target index field of the data line of determining more new data, field value change is obtained
Target index field stores the target index field after change and the corresponding relationship of master index field.
Specifically, first determine whether that above-mentioned change is any in increasing, change and deleting:
If it is determined that field value increase, then by this more new data the target index field change after field value, with
And the field value of master index field is stored in linked database in the more new data.Wherein, linked database can be Redis etc.
Key value database.In field of computer technology, key value database (key-value database) refers to data according to key-value pair
Form carries out tissue, index and the database of storage, and Redis is a kind of high-performance key value database of open source.
If it is determined that field value changes, then the field value after changing the target index field in this more new data, with
And the field value of master index field is stored in linked database in the more new data;By the target index of linked database storage
Field field value before changing and the field value of the master index field corresponding with the field value of linked database storage are deleted
It removes.
Deleted if it is field value, then by the target index field field value before changing of linked database storage, with
And the field value of the master index field corresponding with the field value of linked database storage is deleted.
Such as: the tables of data that certain fragment data table is stored in advance is identified as A, the entitled order number of master index field field, mesh
Mark the entitled user mobile phone of index field field, then for acquisition, tables of data be identified as the more new data of A, it is first determined this is more
The order number field of new data is master index field, user mobile phone field is target index field, then judges user mobile phone word
Whether the field value (i.e. user mobile phone number) of section changes:
It is key (key) with increased user mobile phone number, with the order number in more new data if user mobile phone number increases
The field value (i.e. order number) of field is value (value), is stored in linked database;
If user mobile phone number is deleted, it is key (key) with the user mobile phone number before deleting, is inquired in linked database
Respective record (including the master index field field value as value in record), later by the record deletion;
If user mobile phone number changes, it is key (key) with the user mobile phone number before changing, is inquired in linked database
Respective record, later by the record deletion;And with change after user mobile phone number be key (key), with the order in more new data
Number be value (value), be stored in linked database.
In practical application, when by the storage of above-mentioned field value to linked database, generally requires and added in field value front end
It is distinguished corresponding to the prefix of different field with showing.
In addition, in this step, the second proof rule also can be set, the tables of data mark etc. in more new data is carried out
Verifying, to meet the business demand of fining.
It is understood that source data table carry out a point library divide table formed fragment data table during, can using step
Method shown in rapid S101, step S102 establishes the index field corresponding relationship in fragment data table.
According to above-mentioned steps S101, step S102, the present invention can establish the master index field and target of fragment data table
The corresponding relationship of index field, while can use binary log etc. more new data dynamic updates above-mentioned corresponding relationship.Herein
On the basis of, service database can provide a user the inquiry based on target index field.
Specifically, receive service database send carrying in target index field query word inquiry instruction it
Afterwards, the field value that corresponding with query word master index field is obtained from linked database, by the field value to business datum
Library returns.Data needed for service database can be determined according to the field value or according to the field value and query word.
According to the method for the embodiment of the present invention as can be seen that the present invention can utilize under the premise of not invading original code
The more new data of service database establishes the corresponding relationship between master index field and target index field, to make user Ke Ji
In target index field carry out efficiently, accurately inquiry, overcome and carry out a point library using multiple fields in the prior art table is divided to make
At the huge defect of data and the original code of intrusion caused by system availability is poor, the lower defect of search efficiency;Together
When, the foundation of index field corresponding relationship and the read-write of service database are mutually indepedent, lower with original code degree of coupling;This
Outside, using the field value of key value database storage master index field and target index field, storage data quantity can be reduced, is guaranteed
The efficient read-write of data.
Fig. 2 is the major part schematic diagram of the device of association index according to an embodiment of the present invention.
As shown in Fig. 2, the device 200 of the association index of the embodiment of the present invention can include: data acquisition module 201 and index
Relating module 202.Wherein:
Data acquisition module 201 can be used for obtaining the more new data of at least one service database;Wherein, any business number
It include an at least fragment data table according to library, any fragment data table includes master index field and at least one target index word
Section;
Index association module 202 can be used for determining in fragment data table using the more new data, the word of master index field
Current corresponding relationship between segment value and the field value of target index field stores the current corresponding relationship.
Generally, the more new data can include: service database mark, tables of data mark, data line before changing with
And changed data row.
As a preferred embodiment, data acquisition module 201 can be further used for: obtain at least one service database
More new data after, in the more new data service database mark, tables of data mark verify, will correspond to non-
The update rejection of data of fragment data table.
Specifically, index association module 202 can be further used for: determine from the more new data for corresponding to fragment data table
The target index field of field value change is changed to described in judgement increase or change or delete;When being judged as increase: by this
The field value of master index field is deposited in field value and the more new data in more new data, after target index field change
Storage is in linked database;When being judged as change: by this more new data, the target index field change after field value, with
And the field value of master index field is stored in linked database in the more new data;By linked database storage, the target rope
Draw field field value before changing and linked database storage, corresponding with field value master index field field value
It deletes;When being judged as deletion: by linked database storage, the field value of target index field before changing, and association
The field value of database purchase, corresponding with field value master index field is deleted.
In an optional implementation, the linked database is key value database, and the more new data is binary system day
Will data.
In embodiments of the present invention, index association module 202 can be further used for: receive the carrying that service database is sent
The inquiry instruction of query word;Wherein, the query word is in the target index field of fragment data table;It is obtained from linked database
The field value for taking master index field corresponding with the query word returns to the field value to service database.
As it can be seen that in an embodiment of the present invention, under the premise of not invading original code, utilizing the update of service database
Data establish the corresponding relationship between master index field and target index field, thus make user can based on target index field into
Row efficiently, accurately inquiry, overcome in the prior art using multiple fields carry out point library divide data caused by table it is huge lack
Fall into and the original code of intrusion caused by system availability is poor, the lower defect of search efficiency;Meanwhile index field is corresponding
The foundation of relationship and the read-write of service database are mutually indepedent, lower with original code degree of coupling.
Fig. 3 is the major part schematic diagram of the system of association index according to an embodiment of the present invention.
As shown in figure 3, the system of the association index of the embodiment of the present invention can include: data capture unit 301, message queue
302 and index associative cell 303.Wherein:
Data capture unit 301 can be used for obtaining the more new data of service database 304, will more using message queue 302
New data is sent to index associative cell 303;Wherein, any service database 304 includes an at least fragment data table, any
Fragment data table includes master index field and at least one target index field.
Generally, more new data can include: service database mark, tables of data mark, data line and change before changing
Data line after more.In practical application, more new data can be binary log data.And data capture unit 301 can be into one
Step is used for: after the more new data for obtaining at least one service database, to the service database mark in the more new data
Knowledge, tables of data mark are verified, and the update rejection of data of non-fragment data table will be corresponded to.
In concrete application, data capture unit 301 before being communicated with service database 304, message queue 302,
It needs to be determined that IP (Internet Protocol, Internet protocol) address of each 304 server of service database, port numbers, use
Name in an account book, password, it is thus necessary to determine that IP address, user name, password, message subject, the message of Message Queuing Middleware server are sent
The time span of time-out, it is also necessary to determine and the verifying verified is identified with tables of data to service database mark in more new data
Rule.
In addition, after data capture unit 301 is also used to that data publication to message queue 302 will be updated, by the update number
According to file name and reading position storage, reading state is saved when to break in systems, from storage when system is restored
File, position continue to read, so that realization is efficient, accurately updates data acquisition, it is ensured that the high availability of system.
In embodiments of the present invention, above data can be stored in configuration file or configuration number by data capture unit 301
According in library, to realize data configuration in a manner of more flexible, make system that can carry out dynamic configuration in the process of running.System
When system starting, data capture unit 301 obtains the data in configuration file or configuration database first, obtains business datum later
The access mandate in library 304 is simultaneously communicated with message queue 302, then can according to the file name of the more new data of storage with
And reading position obtains more new data.
Index associative cell 303 is used to determine in fragment data table using more new data, the field value of master index field with
The current corresponding relationship is stored in linked database 305 by the current corresponding relationship between the field value of target index field.
Preferably, linked database 305 can be the key value database of such as Redis.
Specifically, index associative cell 303 is in advance by the word of the tables of data mark of any fragment data table, master index field
The field name of section name and target index field is stored in configuration file or configuration database, when system starts, obtains configuration text
Configuration data in part or configuration database.It is understood that this data configuration method can equally make system realize number
According to dynamic configuration.
In concrete application, index associative cell 303 subscribes to 302 theme of message queue, so as to obtain from message queue 302
More new data.For any more new data corresponding to fragment data table, is identified and determined according to the tables of data in this more new data
The master index field and target index field of the more new data.
Further, index associative cell 303 determines the target rope of field value change from the target index field of acquisition
Draw field, and be changed to increase or change or delete described in judgement:
When being judged as increase: by this more new data, the target index field change after field value and the update
The field value of master index field is stored in linked database 305 in data;
When being judged as change: by this more new data, the target index field change after field value and the update
The field value of master index field is stored in linked database 305 in data;Linked database 305 is stored, target index
The field value of master index field that field field value before changing and linked database 305 store, corresponding with the field value
It deletes;
When being judged as deletion: linked database 305 the is stored, field value of target index field before changing, with
And linked database 305 store, the field value deletion of corresponding with field value master index field.
In addition, when index associative cell 303 can also store the field value prefix of each field, linked database caches expired
Between, the second proof rule.Wherein, field value prefix be used for before field value is stored in database addition field value front end with
Show difference, the second proof rule is for further verifying more new data, to meet the business demand of fining.
In practical application, it is if desired the increase of a certain fragment data table or delete target index field, can be associated in index
In the configuration file or configuration database of unit 303, increase or delete the target index field for corresponding to tables of data mark
Field name, and by index associative cell 303 load configuration data.
By above-mentioned setting, the master index field that the present invention can establish fragment data table is corresponding with target index field
Relationship, while can use binary log etc. more new data dynamic updates above-mentioned corresponding relationship.On this basis, business datum
Library 304 can provide a user the inquiry based on target index field.
Specifically, index associative cell 303 is receiving the carrying of the transmission of service database 304 in target query field
After the inquiry instruction of query word, the field value of master index field corresponding with the query word is obtained from linked database 305,
The field value is returned to service database 304.Service database 304 can be according to the field value or according to the field value
And query word determines required data.
Technical solution according to an embodiment of the present invention utilizes service database under the premise of not invading original code
More new data establishes the corresponding relationship between master index field and target index field, to make user that can be based on target index word
Duan Jinhang efficiently, accurately inquiry, overcome and carry out a point library using multiple fields in the prior art and divide data caused by table huge
Defect and the original code of intrusion caused by system availability is poor, the lower defect of search efficiency;Meanwhile index field
The foundation of corresponding relationship and the read-write of service database are mutually indepedent, lower with original code degree of coupling;In addition, being updated sending
After data, the file name and reading position of real-time storage more new data, it can be ensured that the accurate synchronizations of data and system
High availability.
Fig. 4 is shown can be using the exemplary system architecture of the method or apparatus of the association index of the embodiment of the present invention
400。
As shown in figure 4, system architecture 400 may include terminal device 401,402,403, network 404 and server 405
(this framework is only example, and the component for including in specific framework can be according to the adjustment of application concrete condition).Network 404 to
The medium of communication link is provided between terminal device 401,402,403 and server 405.Network 404 may include various connections
Type, such as wired, wireless communication link or fiber optic cables etc..
User can be used terminal device 401,402,403 and be interacted by network 404 with server 405, to receive or send out
Send message etc..Various telecommunication customer end applications, such as the application of shopping class, net can be installed on terminal device 401,402,403
(merely illustrative) such as the application of page browsing device, searching class application, instant messaging tools, mailbox client, social platform softwares.
Terminal device 401,402,403 can be the various electronic equipments with display screen and supported web page browsing, packet
Include but be not limited to smart phone, tablet computer, pocket computer on knee and desktop computer etc..
Server 405 can be to provide the server of various services, such as utilize terminal device 401,402,403 to user
The shopping class website browsed provides the back-stage management server (merely illustrative) supported.Back-stage management server can be to reception
To the data such as information query request analyze etc. processing, and by processing result (such as target push information, product letter
Breath -- merely illustrative) feed back to terminal device.
It should be noted that the method for association index provided by the embodiment of the present invention is generally executed by server 405, phase
Ying Di, the device of association index are generally positioned in server 405.
It should be understood that the number of terminal device, network and server in Fig. 4 is only schematical.According to realization need
It wants, can have any number of terminal device, network and server.
The present invention also provides a kind of electronic equipment.
The electronic equipment of the embodiment of the present invention includes: one or more processors;Storage device, for storing one or more
A program, when one or more of programs are executed by one or more of processors, so that one or more of processing
The method that device realizes association index provided by the present invention.
Below with reference to Fig. 5, it illustrates the computer systems 500 for the electronic equipment for being suitable for being used to realize the embodiment of the present invention
Structural schematic diagram.Electronic equipment shown in Fig. 5 is only an example, function to the embodiment of the present invention and should not use model
Shroud carrys out any restrictions.
As shown in figure 5, computer system 500 includes central processing unit (CPU) 501, it can be read-only according to being stored in
Program in memory (ROM) 502 or be loaded into the program in random access storage device (RAM) 503 from storage section 508 and
Execute various movements appropriate and processing.In RAM503, be also stored with computer system 500 operate required various programs and
Data.CPU501, ROM 502 and RAM 503 is connected with each other by bus 504.Input/output (I/O) interface 505 also connects
To bus 504.
I/O interface 505 is connected to lower component: the importation 506 including keyboard, mouse etc.;It is penetrated including such as cathode
The output par, c 507 of spool (CRT), liquid crystal display (LCD) etc. and loudspeaker etc.;Storage section 508 including hard disk etc.;
And the communications portion 509 of the network interface card including LAN card, modem etc..Communications portion 509 via such as because
The network of spy's net executes communication process.Driver 510 is also connected to I/O interface 505 as needed.Detachable media 511, such as
Disk, CD, magneto-optic disk, semiconductor memory etc. be mounted on as needed on driver 510, so as to from reading thereon
Computer program is mounted into storage section 508 as needed.
Particularly, disclosed embodiment, the process of key step figure description above may be implemented as according to the present invention
Computer software programs.For example, the embodiment of the present invention includes a kind of computer program products comprising be carried on computer-readable
Computer program on medium, the computer program include the program code for executing method shown in key step figure.?
In above-described embodiment, which can be downloaded and installed from network by communications portion 509, and/or from removable
Medium 511 is unloaded to be mounted.When the computer program is executed by central processing unit 501, executes and limited in system of the invention
Above-mentioned function.
It should be noted that computer-readable medium shown in the present invention can be computer-readable signal media or meter
Calculation machine readable storage medium storing program for executing either the two any combination.Computer readable storage medium for example can be --- but not
Be limited to --- electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor system, device or device, or any above combination.Meter
The more specific example of calculation machine readable storage medium storing program for executing can include but is not limited to: have the electrical connection, just of one or more conducting wires
Taking formula computer disk, hard disk, random access storage device (RAM), read-only memory (ROM), erasable type may be programmed read-only storage
Device (EPROM or flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), light storage device, magnetic memory device,
Or above-mentioned any appropriate combination.In the present invention, computer readable storage medium can be it is any include or storage journey
The tangible medium of sequence, the program can be commanded execution system, device or device use or in connection.In this hair
In bright, computer-readable signal media may include in a base band or as carrier wave a part propagate data-signal, wherein
Carry computer-readable program code.The data-signal of this propagation can take various forms, including but not limited to electric
Magnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be computer-readable storage medium
Any computer-readable medium other than matter, the computer-readable medium can be sent, propagated or transmitted for being held by instruction
Row system, device or device use or program in connection.The program code for including on computer-readable medium
It can transmit with any suitable medium, including but not limited to: wireless, electric wire, optical cable, RF etc. or above-mentioned any conjunction
Suitable combination.
Flow chart and block diagram in attached drawing are illustrated according to the system of various embodiments of the invention, method and computer journey
The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation
A part of one module, program segment or code of table, a part of above-mentioned module, program segment or code include one or more
Executable instruction for implementing the specified logical function.It should also be noted that in some implementations as replacements, institute in box
The function of mark can also occur in a different order than that indicated in the drawings.For example, two boxes succeedingly indicated are practical
On can be basically executed in parallel, they can also be executed in the opposite order sometimes, this is depending on related function.?
It should be noted that the combination of block diagram or each box in flow chart and the box in block diagram or flow chart, can use execution
The dedicated hardware based systems of defined functions or operations realizes, or can use specialized hardware and computer instruction
Combination is to realize.
Being described in unit involved in the embodiment of the present invention can be realized by way of software, can also be by hard
The mode of part is realized.Described unit also can be set in the processor, for example, can be described as: a kind of processor packet
Include data acquisition module and index association module, wherein the title of these modules is not constituted under certain conditions to the module
The restriction of itself, for example, data acquisition module is also described as " sending the module of more new data to index association module ".
As on the other hand, the present invention also provides a kind of computer-readable medium, which be can be
Included in equipment described in above-described embodiment;It is also possible to individualism, and without in the supplying equipment.Above-mentioned meter
Calculation machine readable medium carries one or more program, when said one or multiple programs are executed by the equipment, so that
The step of equipment executes includes: the more new data for obtaining at least one service database;Wherein, any service database includes
An at least fragment data table, any fragment data table include master index field and at least one target index field;Using institute
State more new data determine it is current in fragment data table, between the field value of master index field and the field value of target index field
Corresponding relationship stores the current corresponding relationship.
Technical solution according to an embodiment of the present invention utilizes service database under the premise of not invading original code
More new data establishes the corresponding relationship between master index field and target index field, to make user that can be based on target index word
Duan Jinhang efficiently, accurately inquiry, overcome and carry out a point library using multiple fields in the prior art and divide data caused by table huge
Defect and the original code of intrusion caused by system availability is poor, the lower defect of search efficiency;Meanwhile index field
The foundation of corresponding relationship and the read-write of service database are mutually indepedent, lower with original code degree of coupling;In addition, being updated sending
After data, the file name and reading position of real-time storage more new data, it can be ensured that the accurate synchronizations of data and system
High availability.
Above-mentioned specific embodiment, does not constitute a limitation on the scope of protection of the present invention.Those skilled in the art should be bright
It is white, design requirement and other factors are depended on, various modifications, combination, sub-portfolio and substitution can occur.It is any
Made modifications, equivalent substitutions and improvements etc. within the spirit and principles in the present invention, should be included in the scope of the present invention
Within.