CN110019211A - The methods, devices and systems of association index - Google Patents
The methods, devices and systems of association index Download PDFInfo
- Publication number
- CN110019211A CN110019211A CN201711205172.2A CN201711205172A CN110019211A CN 110019211 A CN110019211 A CN 110019211A CN 201711205172 A CN201711205172 A CN 201711205172A CN 110019211 A CN110019211 A CN 110019211A
- Authority
- CN
- China
- Prior art keywords
- field
- data
- index field
- field value
- new data
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of methods, devices and systems of association index, are related to computer field.One specific embodiment of this method includes: the more new data for obtaining at least one service database；Wherein, any service database includes an at least fragment data table, and any fragment data table includes master index field and at least one target index field；The current corresponding relationship in fragment data table, between the field value of master index field and the field value of target index field is determined using the more new data, and the current corresponding relationship is stored.The embodiment can establish the corresponding relationship between master index field and target index field using the more new data of service database, to realize efficient, the accurate inquiry based on target index field.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of methods, devices and systems of association index.
Background technique
With the rapid development of Internet application, the bottleneck problem of mass data stored and accessed as system design.
In practical application often using point library divide table technology store data in different database in different tables of data, with reduction
The data volume and read-write operation of single database improve data-handling efficiency.
Point library divides table to be that a field in tables of data is carried out hash operations, and data are placed in not according to operation result
In same table or in different databases.When inquiry, the field value for increasing master index field in querying condition can position institute
Need data.But the field value often needed to use except master index field in concrete application is inquired, and allows for looking into this way
Inquiry is difficult to realize.
The prior art generally passes through following two method and solves the above problems:
1. carrying out a point library according to inquiry field divides table.That is, when needing to increase the query function of a certain field, base
A point library is carried out in the field and divides table, and dividing in table database in a point library can be inquired by the field.Wherein, table number is divided in a point library
According to library refer to include point library divide table generate tables of data database.
2. establishing target index field and master in a manner of hard coded while storing data in table database is divided in a point library
The corresponding relationship of index field.Wherein, target index field refers in the tables of data that point library divides table to generate, master index field
Except inquiry field.When inquiry, corresponding master index field is obtained according to target index field, using the master index field into
Row inquiry.
In the implementation of the present invention, the inventor finds that the existing technology has at least the following problems:
1. for the above-mentioned first method of the prior art, when querying condition increases or changes, data scale also with
Expansion, will lead to that data scale is more huge in this way, and greatly increase the workload of later data maintenance.
2. needing to invade original code for the above-mentioned second method of the prior art, i.e., divide library point in data insertion
After table database, be further added by target index field to master index field mapping logic, so that system availability is poor, looks into
It is lower to ask efficiency.
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.
Detailed description of the invention
Attached drawing for a better understanding of the present invention, does not constitute an undue limitation on the present invention.Wherein:
Fig. 1 is the key step schematic diagram of the method for association index according to an embodiment of the present invention；
Fig. 2 is the major part schematic diagram of the device of association index according to an embodiment of the present invention；
Fig. 3 is the major part schematic diagram of the system of association index according to an embodiment of the present invention；
Fig. 4 is to can be applied to exemplary system architecture figure therein according to embodiments of the present invention；
Fig. 5 is the structural schematic diagram for the electronic equipment for realizing the method for the embodiment of the present invention.
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.
Claims (17)
1. a kind of method of association index characterized by comprising
Obtain the more new data of 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；
It is determined in fragment data table using the more new data, the field value of the field value of master index field and target index field
Between current corresponding relationship, the current corresponding relationship is stored.
2. the method according to claim 1, wherein the updated data package includes: service database mark, data
Table mark, data line before changing and changed data row.
3. according to the method described in claim 2, it is characterized in that, the method further includes:
After the more new data for obtaining at least one service database, the service database in the more new data is identified,
Tables of data mark is verified, and the update rejection of data of non-fragment data table will be corresponded to.
4. the method according to claim 1, wherein described determine fragment data table using the more new data
In, the current corresponding relationship between the field value of master index field and the field value of target index field, by the current correspondence
Relationship storage includes:
The target index field that field value changes is determined from the more new data for corresponding to fragment data table, is changed to described in judgement
Increase or change or deletes；
When being judged as increase: by the field value and the more new data in this more new data, after target index field change
The field value of middle master index field is stored in linked database；
When being judged as change: by the field value and the more new data in this more new data, after target index field change
The field value of middle master index field is stored in linked database；Before changing by linked database storage, the target index field
Field value and linked database storage, corresponding with field value master index field field value deletion；
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.
5. according to the method described in claim 4, it is characterized in that, the linked database is key value database.
6. the method according to claim 1, wherein by after the current corresponding relationship storage, the method
Further comprise:
Receive the inquiry instruction for the carrying query word that service database is sent；Wherein, the query word is in fragment data table
Target index field；
The field value for obtaining master index field corresponding with the query word returns to the field value to service database.
7. -6 any method according to claim 1, which is characterized in that the more new data is binary log data.
8. a kind of device of association index characterized by comprising
Data acquisition module, for obtaining the more new data of 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；
Index association module determines in fragment data table, the field value and mesh of master index field for the more new data described in
The current corresponding relationship between the field value of index field is marked, the current corresponding relationship is stored.
9. a kind of system of association index characterized by comprising data capture unit, message queue and index association table
Member；Wherein,
Data capture unit is used to obtain the more new data of at least one service database, using message queue by the update number
It is sent according to index associative cell；Wherein, any service database includes an at least fragment data table, any fragment data table
Including master index field and at least one target index field；
Index associative cell is used to determine in fragment data table using the more new data, the field value of master index field and target
The current corresponding relationship is stored in linked database by the current corresponding relationship between the field value of index field.
10. system according to claim 9, which is characterized in that the updated data package includes: service database mark, number
According to table mark, data line before changing and changed data row.
11. system according to claim 10, which is characterized in that data capture unit is further used for:
After the more new data for obtaining at least one service database, the service database in the more new data is identified,
Tables of data mark is verified, and the update rejection of data of non-fragment data table will be corresponded to；
After sending more new data, the file name of the more new data and reading position are stored.
12. system according to claim 9, which is characterized in that index associative cell is further used for:
Store tables of data mark, the field of the field name of master index field and target index field of any fragment data table
Name；
For any more new data corresponding to fragment data table, which is obtained according to the tables of data mark in this more new data
The master index field and target index field of data；
The target index field that field value change is determined from the target index field of acquisition, be changed to described in judgement to increase or
Change or deletes；
When being judged as increase: by the field value and the more new data in this more new data, after target index field change
The field value of middle master index field is stored in linked database；
When being judged as change: by the field value and the more new data in this more new data, after target index field change
The field value of middle master index field is stored in linked database；Before changing by linked database storage, the target index field
Field value and linked database storage, corresponding with field value master index field field value deletion；And
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.
13. system according to claim 12, which is characterized in that the linked database is key value database.
14. system according to claim 9, which is characterized in that index associative cell is further used for:
Receive the inquiry instruction for the carrying query word that service database is sent；Wherein, the query word is in fragment data table
Target index field；
The field value for obtaining master index field corresponding with the query word returns to the field value to service database.
15. according to any system of claim 9-14, which is characterized in that the more new data is binary log number
According to.
16. a kind of electronic equipment characterized by comprising
One or more processors；
Storage device, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
The now method as described in any in claim 1-7.
17. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that described program is processed
The method as described in any in claim 1-7 is realized when device executes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711205172.2A CN110019211A (en) | 2017-11-27 | 2017-11-27 | The methods, devices and systems of association index |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711205172.2A CN110019211A (en) | 2017-11-27 | 2017-11-27 | The methods, devices and systems of association index |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110019211A true CN110019211A (en) | 2019-07-16 |
Family
ID=67185968
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711205172.2A Pending CN110019211A (en) | 2017-11-27 | 2017-11-27 | The methods, devices and systems of association index |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019211A (en) |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489417A (en) * | 2019-07-25 | 2019-11-22 | 深圳壹账通智能科技有限公司 | A kind of data processing method and relevant device |
| CN110704428A (en) * | 2019-09-06 | 2020-01-17 | 深圳壹账通智能科技有限公司 | Data indexing method and device for block chain, computer equipment and storage medium |
| CN111159205A (en) * | 2019-11-27 | 2020-05-15 | 京东数字科技控股有限公司 | Data processing method and system |
| CN111339171A (en) * | 2020-02-07 | 2020-06-26 | 拉扎斯网络科技（上海）有限公司 | Data query method, device and equipment |
| CN111488341A (en) * | 2020-03-27 | 2020-08-04 | 北京金山云网络技术有限公司 | Database index management method and device and electronic equipment |
| CN111723210A (en) * | 2020-06-29 | 2020-09-29 | 深圳壹账通智能科技有限公司 | Method and device for storing data table, computer equipment and readable storage medium |
| CN112395157A (en) * | 2020-11-13 | 2021-02-23 | 广州至真信息科技有限公司 | Audit log obtaining method and device, computer equipment and storage medium |
| CN112416932A (en) * | 2020-11-18 | 2021-02-26 | 青岛海尔科技有限公司 | Method and device for establishing field association relationship |
| CN112417230A (en) * | 2020-11-30 | 2021-02-26 | 中国民航信息网络股份有限公司 | Freight rate data processing method and device and electronic equipment |
| CN112597149A (en) * | 2020-11-25 | 2021-04-02 | 贝壳技术有限公司 | Data table similarity determination method and device |
| CN112612865A (en) * | 2020-12-17 | 2021-04-06 | 杭州迪普科技股份有限公司 | Document storage method and device based on elastic search |
| CN112699187A (en) * | 2020-12-29 | 2021-04-23 | 中国联合网络通信集团有限公司 | Associated data processing method, device, equipment, medium and product |
| CN112835904A (en) * | 2021-02-04 | 2021-05-25 | 北京电解智科技有限公司 | Data processing method and data processing device |
| CN113094370A (en) * | 2021-04-13 | 2021-07-09 | 北京精鸿软件科技有限公司 | Data index construction method and device, storage medium and electronic equipment |
| CN113111120A (en) * | 2020-01-13 | 2021-07-13 | 北京京东振世信息技术有限公司 | Method and device for verifying service data |
| CN113434600A (en) * | 2021-06-30 | 2021-09-24 | 青岛海尔科技有限公司 | Data synchronization method and device |
| CN113568907A (en) * | 2021-07-14 | 2021-10-29 | 彩讯科技股份有限公司 | Method, device, server and storage medium for processing station information message |
| CN113742535A (en) * | 2021-09-03 | 2021-12-03 | 上海微盟企业发展有限公司 | Generalized retrieval method, device, equipment and storage medium |
| CN115168409A (en) * | 2022-09-05 | 2022-10-11 | 金蝶软件（中国）有限公司 | Data query method and device for database sub-tables and computer equipment |
| CN115237927A (en) * | 2022-09-20 | 2022-10-25 | 神州医疗科技股份有限公司 | Method and system for updating data table based on cache and data processing rule |
| CN115994145A (en) * | 2023-02-09 | 2023-04-21 | 中国证券登记结算有限责任公司 | Method and device for processing data |
| WO2024050972A1 (en) * | 2022-09-05 | 2024-03-14 | 金蝶软件（中国）有限公司 | Database table sharding method and apparatus, computer device, and storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101727465A (en) * | 2008-11-03 | 2010-06-09 | 中国移动通信集团公司 | Methods for establishing and inquiring index of distributed column storage database, device and system thereof |
| CN104391863A (en) * | 2014-10-23 | 2015-03-04 | 中国建设银行股份有限公司 | Data storage method and device |
| CN104598652A (en) * | 2015-02-14 | 2015-05-06 | 广州华多网络科技有限公司 | Database inquiry method and database inquiry device |
| CN105488050A (en) * | 2014-09-17 | 2016-04-13 | 阿里巴巴集团控股有限公司 | Database multi-index method, apparatus and system |
| CN105512200A (en) * | 2015-11-26 | 2016-04-20 | 华为技术有限公司 | Distributed database processing method and device |
| CN106156088A (en) * | 2015-04-01 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of index data processing method, data query method and device |
| CN106802891A (en) * | 2015-11-26 | 2017-06-06 | 中国电信股份有限公司 | The querying method of the non-burst field of distributed data base, system and equipment |
| CN107169046A (en) * | 2017-04-25 | 2017-09-15 | 广东网金控股股份有限公司 | A kind of database index lookup method, device and user terminal |
| CN107180081A (en) * | 2017-04-28 | 2017-09-19 | 广东亿迅科技有限公司 | The call method and device of massive relation type database |
-
2017
- 2017-11-27 CN CN201711205172.2A patent/CN110019211A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101727465A (en) * | 2008-11-03 | 2010-06-09 | 中国移动通信集团公司 | Methods for establishing and inquiring index of distributed column storage database, device and system thereof |
| CN105488050A (en) * | 2014-09-17 | 2016-04-13 | 阿里巴巴集团控股有限公司 | Database multi-index method, apparatus and system |
| CN104391863A (en) * | 2014-10-23 | 2015-03-04 | 中国建设银行股份有限公司 | Data storage method and device |
| CN104598652A (en) * | 2015-02-14 | 2015-05-06 | 广州华多网络科技有限公司 | Database inquiry method and database inquiry device |
| CN106156088A (en) * | 2015-04-01 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of index data processing method, data query method and device |
| CN105512200A (en) * | 2015-11-26 | 2016-04-20 | 华为技术有限公司 | Distributed database processing method and device |
| CN106802891A (en) * | 2015-11-26 | 2017-06-06 | 中国电信股份有限公司 | The querying method of the non-burst field of distributed data base, system and equipment |
| CN107169046A (en) * | 2017-04-25 | 2017-09-15 | 广东网金控股股份有限公司 | A kind of database index lookup method, device and user terminal |
| CN107180081A (en) * | 2017-04-28 | 2017-09-19 | 广东亿迅科技有限公司 | The call method and device of massive relation type database |
Cited By (33)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489417B (en) * | 2019-07-25 | 2023-03-28 | 深圳壹账通智能科技有限公司 | Data processing method and related equipment |
| CN110489417A (en) * | 2019-07-25 | 2019-11-22 | 深圳壹账通智能科技有限公司 | A kind of data processing method and relevant device |
| CN110704428A (en) * | 2019-09-06 | 2020-01-17 | 深圳壹账通智能科技有限公司 | Data indexing method and device for block chain, computer equipment and storage medium |
| CN111159205A (en) * | 2019-11-27 | 2020-05-15 | 京东数字科技控股有限公司 | Data processing method and system |
| CN113111120A (en) * | 2020-01-13 | 2021-07-13 | 北京京东振世信息技术有限公司 | Method and device for verifying service data |
| CN113111120B (en) * | 2020-01-13 | 2023-09-01 | 北京京东振世信息技术有限公司 | Service data verification method and device |
| CN111339171A (en) * | 2020-02-07 | 2020-06-26 | 拉扎斯网络科技（上海）有限公司 | Data query method, device and equipment |
| CN111488341A (en) * | 2020-03-27 | 2020-08-04 | 北京金山云网络技术有限公司 | Database index management method and device and electronic equipment |
| CN111488341B (en) * | 2020-03-27 | 2023-08-22 | 北京金山云网络技术有限公司 | Database index management method and device and electronic equipment |
| CN111723210A (en) * | 2020-06-29 | 2020-09-29 | 深圳壹账通智能科技有限公司 | Method and device for storing data table, computer equipment and readable storage medium |
| CN112395157A (en) * | 2020-11-13 | 2021-02-23 | 广州至真信息科技有限公司 | Audit log obtaining method and device, computer equipment and storage medium |
| CN112395157B (en) * | 2020-11-13 | 2023-08-08 | 广州至真信息科技有限公司 | Audit log acquisition method and device, computer equipment and storage medium |
| CN112416932A (en) * | 2020-11-18 | 2021-02-26 | 青岛海尔科技有限公司 | Method and device for establishing field association relationship |
| CN112597149A (en) * | 2020-11-25 | 2021-04-02 | 贝壳技术有限公司 | Data table similarity determination method and device |
| CN112597149B (en) * | 2020-11-25 | 2022-11-22 | 贝壳技术有限公司 | Data table similarity determination method and device |
| CN112417230B (en) * | 2020-11-30 | 2024-01-30 | 中国民航信息网络股份有限公司 | Freight rate data processing method and device and electronic equipment |
| CN112417230A (en) * | 2020-11-30 | 2021-02-26 | 中国民航信息网络股份有限公司 | Freight rate data processing method and device and electronic equipment |
| CN112612865A (en) * | 2020-12-17 | 2021-04-06 | 杭州迪普科技股份有限公司 | Document storage method and device based on elastic search |
| CN112699187A (en) * | 2020-12-29 | 2021-04-23 | 中国联合网络通信集团有限公司 | Associated data processing method, device, equipment, medium and product |
| CN112699187B (en) * | 2020-12-29 | 2023-05-16 | 中国联合网络通信集团有限公司 | Associated data processing method, device, equipment, medium and product |
| CN112835904A (en) * | 2021-02-04 | 2021-05-25 | 北京电解智科技有限公司 | Data processing method and data processing device |
| CN113094370A (en) * | 2021-04-13 | 2021-07-09 | 北京精鸿软件科技有限公司 | Data index construction method and device, storage medium and electronic equipment |
| CN113434600A (en) * | 2021-06-30 | 2021-09-24 | 青岛海尔科技有限公司 | Data synchronization method and device |
| CN113434600B (en) * | 2021-06-30 | 2023-06-09 | 青岛海尔科技有限公司 | Data synchronization method and device |
| CN113568907A (en) * | 2021-07-14 | 2021-10-29 | 彩讯科技股份有限公司 | Method, device, server and storage medium for processing station information message |
| CN113742535A (en) * | 2021-09-03 | 2021-12-03 | 上海微盟企业发展有限公司 | Generalized retrieval method, device, equipment and storage medium |
| CN115168409B (en) * | 2022-09-05 | 2023-02-28 | 金蝶软件（中国）有限公司 | Data query method and device for database sub-tables and computer equipment |
| CN115168409A (en) * | 2022-09-05 | 2022-10-11 | 金蝶软件（中国）有限公司 | Data query method and device for database sub-tables and computer equipment |
| WO2024050972A1 (en) * | 2022-09-05 | 2024-03-14 | 金蝶软件（中国）有限公司 | Database table sharding method and apparatus, computer device, and storage medium |
| CN115237927B (en) * | 2022-09-20 | 2022-11-29 | 神州医疗科技股份有限公司 | Method and system for realizing data table updating based on cache and data processing rule |
| CN115237927A (en) * | 2022-09-20 | 2022-10-25 | 神州医疗科技股份有限公司 | Method and system for updating data table based on cache and data processing rule |
| CN115994145A (en) * | 2023-02-09 | 2023-04-21 | 中国证券登记结算有限责任公司 | Method and device for processing data |
| CN115994145B (en) * | 2023-02-09 | 2023-08-22 | 中国证券登记结算有限责任公司 | Method and device for processing data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110019211A (en) | The methods, devices and systems of association index | |
| CN108846753B (en) | Method and apparatus for processing data | |
| CN109683998A (en) | Internationalize implementation method, device and system | |
| CN110019080B (en) | Data access method and device | |
| CN109413127A (en) | A kind of method of data synchronization and device | |
| CN110019125A (en) | The method and apparatus of data base administration | |
| CN109388654A (en) | A kind of method and apparatus for inquiring tables of data | |
| CN112527649A (en) | Test case generation method and device | |
| WO2021023149A1 (en) | Method and apparatus for dynamically returning message | |
| CN109918425A (en) | A kind of method and system realized data and import non-relational database | |
| CN109918191A (en) | A kind of method and apparatus of the anti-frequency of service request | |
| CN111339743B (en) | Account number generation method and device | |
| CN110110196A (en) | A kind of information push method and device | |
| CN110019539A (en) | A kind of method and apparatus that the data of data warehouse are synchronous | |
| CN109597810A (en) | A kind of task cutting method, device, medium and electronic equipment | |
| CN110321252B (en) | Skill service resource scheduling method and device | |
| CN113312355A (en) | Data management method and device | |
| CN115496544A (en) | Data processing method and device | |
| CN109144991A (en) | Dynamic divides method, apparatus, electronic equipment and the computer of table can storage medium | |
| CN111865576B (en) | Method and device for synchronizing URL classification data | |
| CN110109912A (en) | A kind of identifier generation method and device | |
| CN110399397A (en) | A kind of data query method and system | |
| CN110705935B (en) | Logistics document processing method and device | |
| CN112711572B (en) | Online capacity expansion method and device suitable for database and table division | |
| CN113704242A (en) | Data processing method and device |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200522 Address after: 710100 Building 5, center square, aerospace city, No. 666, East Chang'an Street, national civil aerospace industry base, Xi'an City, Shaanxi Province Applicant after: Xi'an jingxundi Supply Chain Technology Co.,Ltd. Address before: East Building 11, 100195 Beijing city Haidian District xingshikou Road No. 65 west Shan creative garden district 1-4 four layer of 1-4 layer Applicant before: BEIJING JINGDONG SHANGKE INFORMATION TECHNOLOGY Co.,Ltd. Applicant before: BEIJING JINGDONG CENTURY TRADING Co.,Ltd. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190716 |