CN103488657A - Data table correlation method and device - Google Patents

Data table correlation method and device Download PDF

Info

Publication number
CN103488657A
CN103488657A CN201210196712.6A CN201210196712A CN103488657A CN 103488657 A CN103488657 A CN 103488657A CN 201210196712 A CN201210196712 A CN 201210196712A CN 103488657 A CN103488657 A CN 103488657A
Authority
CN
China
Prior art keywords
data
fixed function
data sources
function relation
separately
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201210196712.6A
Other languages
Chinese (zh)
Other versions
CN103488657B (en
Inventor
温嘉佳
何秀强
潘璐伽
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Huawei Technologies Co Ltd
Original Assignee
Huawei Technologies Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Huawei Technologies Co Ltd filed Critical Huawei Technologies Co Ltd
Priority to CN201210196712.6A priority Critical patent/CN103488657B/en
Publication of CN103488657A publication Critical patent/CN103488657A/en
Application granted granted Critical
Publication of CN103488657B publication Critical patent/CN103488657B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/18File system types
    • G06F16/182Distributed file systems

Abstract

The embodiment of the invention provides a data table correlation method and device, relates to the field of network information processing, and has contribution to effectively increasing the execution efficiency of data correlation analysis and realizing quasi-instantaneity of data correlation analysis. The method comprises the following steps: reading a distributed computer system file, establishing a key value pair satisfying an equivalent condition in numerical relationship analysis by using respective attribute values of any two data sources in the system file according to the equivalent condition, wherein a stationary functional relationship exists between each data record in each data source and respective attribute value of the data source; traversing the data records in any two data sources for establishing the key value pair according to sequences provided by respective satisfied stationary functional relationships, and finding data record satisfying an optimal condition between respective stationary function relationships in the two data sources. The embodiment of the invention is applied to data table correlation processing.

Description

A kind of tables of data correlating method and device
Technical field
The present invention relates to the network information processing field, relate in particular to a kind of tables of data correlating method and device.
Background technology
We are in large data age now, the data volume that the mankind produce every day according to statistics surpasses 2.5quintillion (10^18) byte, the data volume produced in 2 years in the past accounts for the mankind and collects 90% of data total amount, and along with mobile broadband network, sensor network (sensor network), RFID (radio frequency identification devices, radio frequency identification) fast development of technology such as, the mankind produce the speed of data also in rapid growth.Excavate valuable information from mass data, change data into information, and then excavate the commercial value wherein existed and become hot technology, to help enterprise, obtain business success.The mass data of carrying out data mining comes from a plurality of data sources usually, and some valuable information only has the relation be hidden between a plurality of data sources by association analysis to obtain.Take signalling analysis as example in communication network, and " signaling storm " is the challenging problem that the 3G mobile broadband network faces.The fast universal of smart mobile phone is the major reason that the signaling storm produces, and shows as terminal or business heartbeat mechanism, causes increasing considerably of connection request number of times and paging number of times, so cause paging success rate and the EV-DO cutting off rate deteriorated.Signalling analysis in 3G network is wished by data service, terminal type etc. is carried out to association analysis with signaling consumption, the Different Effects that understanding different pieces of information business, terminal type consume signaling, thereby understand the reason that the signaling storm produces, thereby provide and solve or process suggestion to operator.
Realize the analysis of data correlation by Map-reduce (mapping-linear dependence) framework with the distributed file system HDFS (Hadoop Distributed File System) of bottom in existing technology.Association by Map-reduce for multi-data source, the DataJoin of Hadoop (data connection) mechanism is achieved as follows: with A, B data source (table) is for associated x1, y1 is as the key assignments output of mapping, for the A with identical key assignments, the B table, carry out cartesian product, therefrom selects the result satisfied condition as the association analysis result; From the associative combination of all cartesian products, select to meet the record of optimal conditions.If suppose that A table and B show each own n of list item of identical key assignments, m, the algorithm complex of association phase is O (n*m).If A table and B show that the list item of identical key value is too much, computation complexity is quite high, so has greatly affected the efficiency of association analysis.
Summary of the invention
Embodiments of the invention provide a kind of tables of data correlating method and device, can effectively improve the execution efficiency of data relation analysis, realize the quasi real time property of data relation analysis.
For achieving the above object, embodiments of the invention adopt following technical scheme:
On the one hand, provide a kind of tables of data correlating method, comprising:
Read the distributed computing system file, according to the equivalence condition in the numerical relation analysis with any two data sources in described system file property value separately set up the key-value pair that meets described equivalence condition, there is the fixed function relation between every data record and described data source property value separately in wherein said data source;
The order that the data recording of setting up in any two data sources of described key-value pair is provided according to satisfied separately fixed function relation is respectively traveled through, and in described two data sources, finds the data recording that meets separately optimal conditions between the fixed function relation.
On the one hand, provide a kind of device of tables of data association, comprising:
At least one mapper, for reading the distributed computing system file, according to the equivalence condition in the numerical relation analysis with any two data sources in described system file property value separately set up the key-value pair that meets described equivalence condition, there is the fixed function relation between every data record and described data source property value separately in wherein said data source;
At least one walker, the order provided according to satisfied separately fixed function relation respectively for the data recording of any two data sources that will set up described key-value pair is traveled through, and in described two data sources, finds the data recording that meets separately optimal conditions between the fixed function relation.
Embodiments of the invention provide a kind of tables of data correlating method and device, and the method traveled through in order by employing realizes the association of data, can effectively improve the execution efficiency of data relation analysis, realize the quasi real time property of data relation analysis.
The accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, below will the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain according to these accompanying drawings other accompanying drawing.
The method flow schematic diagram of a kind of tables of data association that Fig. 1 provides for the embodiment of the present invention;
A kind of meeting property conditional search method schematic diagram that Fig. 2 provides for the embodiment of the present invention;
The method flow schematic diagram of a kind of tables of data association that Fig. 3 provides for another embodiment of the present invention;
A kind of tables of data associated apparatus schematic diagram that Fig. 4 provides for the embodiment of the present invention;
A kind of tables of data associated apparatus schematic diagram that Fig. 5 provides for another embodiment of the present invention;
A kind of tables of data associated apparatus schematic diagram that Fig. 6 provides for further embodiment of this invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making under the creative work prerequisite the every other embodiment obtained, belong to the scope of protection of the invention.
Shown in Fig. 1, the tables of data correlating method for the invention process example provides comprises the following steps:
S101, read the distributed computing system file, according to the equivalence condition in the numerical relation analysis with any two data sources in system file property value separately set up the key-value pair that meets equivalence condition, wherein in data source, between every data record and data source property value separately, there is the fixed function relation;
Here in S101, take A, two data sources of B (tables of data) is example, equivalence condition (A.x1=B.y1) in the numerical relation of usining analysis is as A, two satisfied equivalence conditions of data source of B, wherein x1 and y1 are respectively the property value of data source A, B, using property value x1 and y1 as the key-value pair output that meets above-mentioned equivalence condition.In addition, A, every data record in two data sources of B respectively with A, there is fixing funtcional relationship between B, here with respectively with A, B property value separately is variable, there are data recording in data source A and the funtcional relationship of the property value in A to be expressed as f (x1, x2, ...), data recording in data source B and the funtcional relationship of the property value in B are expressed as g (y1, y2, ...), in order to represent general practicality, may comprise a plurality of property values in a data source, funtcional relationship f (x1 wherein, x2, ...) and g (y1, y2, ...) in a plurality of A of can be used as are shown simultaneously, set up the property value of key-value pair between the B data element.
S102, the order that will set up the data recording of any two data sources of key-value pair and provide according to satisfied separately fixed function relation are respectively traveled through, and in two data sources, find the data recording that meets separately optimal conditions between the fixed function relation.
Further alternative, the order that will set up the data recording in any two data sources of key-value pair in step S102 provides according to satisfied separately fixed function relation respectively travels through and comprises: at first, by setting up the data recording that has identical key assignments in any two data sources of key-value pair, according to satisfied separately fixed function relation, sorted respectively; Secondly, the different sequences that generate after sequence are traveled through respectively.
Below just take x1 and y1 describes as example as the key-value pair that meets above-mentioned equivalence condition, to A and B table respectively according to funtcional relationship f separately (x 1, x2 ...) and g (y1, y2 ...) and traveled through after sorting.Next for the record in each A table, find a searching and meet optimal conditions (MIN/MAX (f (x1, x2 in the B table, ...)-g (y1, y2 ...)) record, certainly the optimal conditions here just with obtain funtcional relationship f (x1, x2 ...) and g (y1, y2 ...) maximum or the minimum value of difference be example, this optimal conditions can pass through funtcional relationship f (x1 according to demand certainly, x2, ...) and g (y1, y2 ...) adjusted.Because two sequences sort, therefore, only need to carry out once order traversal to two sequences of sequence, can complete the associated of A and B table.Here suppose that data recording in the A data source is according to funtcional relationship f (x1, x2 ...) order be a11, a12, a13, a14, the data recording in the B data source is according to funtcional relationship g (y1, y2, ...) order be b11, b12, b13, because if | f (a1.x1, a1.x2, a1.x3...)-g (b1.y1, b1.y2, b1.y3...) | be less than | f (a1.x1, a1.x2, a1.x3...)-g (b2.y1, b2.y2, b2.y3...) |, b3 and f (x1 down thereof, x2, ...) and g (y1, y2 ...) difference of function can only be increasing.
Now, A and the data record size in the B data source of supposing to have identical key-value pair are m, n, the algorithm complex two sequences sorted is O (log2m+log2n), and ordering A and B table is carried out to the once algorithm complex of order traversal, be O (m+n), the algorithm complex O (m*n) of the DataJoin mechanism of the prior art of comparing Hadoop is greatly improved on the algorithm execution efficiency.
The tables of data correlating method that the embodiment of the present invention provides, can effectively improve the execution efficiency of data relation analysis, realizes the quasi real time property of data relation analysis.
Further, shown in Fig. 1, the method also comprises:
S103, two data sources of sequential search according to optimal conditions in two data sources meet the data recording of meeting property condition separately between the fixed function relation.
Here with reference to the meeting property conditional search schematic diagram shown in Fig. 2, the tables of data correlating method provided according to above embodiment, be the A1 that records in data source A, finds the Bi that records in the data source B that meets equivalence condition and optimal conditions.Detection record A1 and record Bi and whether meet meeting property condition, if condition meets, the record that simultaneously meets equivalence condition, optimal conditions and meeting property condition has been found in statement, stops continuing search.Otherwise, the current location from B table forward, search for each record backward one by one, and the order that guarantees searching record is according to optimization MIN/MAX { f (x1, x2...)-g (y1, y2...) } sequentially, until find first record that meets meeting property condition, this record is the record that meets equivalence condition, meeting property condition and optimal conditions.Under worst case, for all records in A, need each record in traversal B table, now algorithm complex is O (m*n), at this moment identical with the complexity of the Datajoin of Hadoop.If for the record in A, needing mean ergodic number of times in B is C, and algorithm complex is O (C*m).Here meeting property condition be also f (x1, x2 ...) and g (y1, y2 ...) and between the self-defining special relationship that meets, therefore meeting property condition can be for a plurality of.
In practical problems, optimal condition is usually relevant to meeting property condition, in a lot of situations, the record that meets optimal condition also tends to meet meeting property condition, search like this record or near the record ignoring meeting property condition but meet optimal condition and also be easier to meet meeting property condition, so mean ergodicty number of times C<<| B|, so algorithm complex compared to existing technology can be less.
Optionally, shown in Fig. 3, a kind of tables of data correlating method that another embodiment of the present invention provides comprises the following steps:
S301, read the distributed computing system file, according to the equivalence condition in the numerical relation analysis with any two data sources in system file property value separately set up the key-value pair that meets equivalence condition, wherein in data source, between every data record and data source property value separately, there is the fixed function relation;
The embodiment of this step can repeat no more here with reference to S101 in a upper embodiment.
S302, will set up the data recording that there is identical key assignments in any two data sources of key-value pair and be sorted according to satisfied separately fixed function relation respectively.
For the data recording that there is identical key-value pair in A, B data source, sorted respectively.Certainly the data recording in A, B data source that can unify is here sorted according to key assignments, and the data recording with identical key-value pair will be output in same sequence.The sequencer procedure here can be for being sorted according to key assignments and the intrinsic funtcional relationship of data source simultaneously, to the data recording of identical key assignments, the funtcional relationship intrinsic according to data source sorted, be designated as: A table according to<x 1, f (x1, x2, ...)>, B table is according to<y1, g (y1, y2 ...)>sorted.
S303, the order that will set up the data recording of any two data sources of key-value pair and provide according to satisfied separately fixed function relation are respectively traveled through, and in two data sources, find the data recording that meets separately optimal conditions between the fixed function relation.
Equally, here only need to have identical key assignments (A is x1, and B is y1) and according to f (x1, x2 ...) and g (y1, y2 ...) and sorted sequence, carry out once order and travel through, can complete data relation analysis.Realizing that sequencer procedure can't cause extra computation complexity.Like this, the algorithm complex of association analysis is O (m+n).The process of concrete traversal can, with reference to a upper embodiment step S102, repeat no more here.
The tables of data correlating method that the embodiment of the present invention provides, can effectively improve the execution efficiency of data relation analysis, realizes the quasi real time property of data relation analysis.
Further, optionally, with reference to shown in Fig. 3, the method also comprises:
S304, two data sources of sequential search according to optimal conditions in two data sources meet the data recording of meeting property condition separately between the fixed function relation.
The embodiment of this step can repeat no more here with reference to S103 in a upper embodiment.
The general issue be abstracted in above embodiments of the invention has ubiquity, and the method in above embodiment can be applied directly to the association analysis of signaling daily record and data stream in 3G network.Wherein, the signaling log information is to obtain from the log recording of RNC equipment, and data stream collects at the GGSN place.Wherein, BS (Base station or NodeB, base station), RNC (Radio Network Controller, radio network controller), SGSN (Serving General Packet Radio Service Support Node, the wireless universal packet service support node) and GGSN (Gateway GPRS Support Node, gateway general packet radio serving GPRS support node) formed the basic framework of 3G network.
Wherein the associating policy of data and signaling is as shown in the table:
Figure BDA00001768160600071
Table 1, data-signalling correlated strategy
As shown in table 1, wherein, two data sources (tables of data) with A, two analyses to be associated of B refer to respectively signaling format table and data I P packet format table, major key when carrying out data-signalling correlated is: SGSN IP, RNC IP, RNC TEID, by the temporal information respectively carried in signaling and data, limited, summary is got up, and Correlation Criteria is as follows:
Signaling format table and data I P packet format table set up equivalence condition Data.SRC_IP=Signal.SGSN_IP, Data.DST_IP=Signal.RNC_IP, Data.TEID=Signal.RNC_TEID can be abstract for to A, two data sources of two analyses to be associated of B are set up key-value pair A.x1=B.y1, A.x2=B.y2, the A.x3=B.y3 that meets equivalence condition; The value minimum that the record that meets optimal conditions in search signaling format table and data I P packet format table had both met Data.TIME_DATA-(Signal.Access_TIME+Signal.RRC_RLS_TIME)/2 can abstractly be that two data source A, B fixed function separately concerns f (x1, x2....) and g (y1, y2...) meet optimal conditions MIN/MAX{f (x1 between, x2....)-g (y1, y2...) };
The property value g that f (x1, x2....) and g (y1, y2...) are respectively with A and B as mentioned above (is respectively x1, x2, x3... here in A; Be respectively y1, y2... in B) be the function of variable, each the data record in A (B) all can pass through the value that function f (x1, x2....) (g (y1, y2...)) obtains a definite value type.For example, in above-mentioned 3G network signalling analysis, the value that each in data stream is recorded in optimal conditions is TIME_DATA, and the value of each record in signaling data is (Signal.Access_TIME+Signal.RRC_RLS_TIME)/2, optimal condition is the difference minimized between the two.
Now, A and the data record size in the B data source of supposing to have identical key-value pair are m, n, the algorithm complex two sequences sorted is O (log2m+log2n), and ordering A and B table is carried out to the once algorithm complex of order traversal, be O (m+n), the algorithm complex O (m*n) of the DataJoin mechanism of the prior art of comparing Hadoop, the tables of data correlating method provided by the embodiment of the present invention is greatly improved on the algorithm execution efficiency to the association analysis of signaling daily record and data stream in 3G network.
Shown in Fig. 4, a kind of tables of data associated apparatus 4 that the embodiment of the present invention provides comprises:
At least one mapper 41, for reading the distributed computing system file, according to the equivalence condition in the numerical relation analysis with any two data sources in system file property value separately set up the key-value pair that meets equivalence condition, wherein in data source, between every data record and data source property value separately, there is the fixed function relation;
At least one walker 42, the order provided according to satisfied separately fixed function relation respectively for the data recording of any two data sources that will set up key-value pair is traveled through, and in two data sources, finds the data recording that meets separately optimal conditions between the fixed function relation.
Optionally, shown in Fig. 5, walker 42 also comprises:
The module 421 of shuffling, the data recording that has identical key assignments for any two data sources that will set up key-value pair is sorted according to satisfied separately fixed function relation respectively;
Spider module 422, traveled through respectively for the different sequences by generating after sequence.
Optionally, shown in Fig. 6, this tables of data associated apparatus 4 also comprises:
Shuffler 43, the data recording that has identical key assignments for any two data sources that will set up key-value pair is sorted according to satisfied separately fixed function relation respectively.
Further, walker 42 also for: described walker also for two data sources, according to two data sources of sequential search of optimal conditions, meeting separately the data recording of meeting property condition between the fixed function relation.
The tables of data associated apparatus that the embodiment of the present invention provides, can effectively improve the execution efficiency of data relation analysis, realizes the quasi real time property of data relation analysis.
One of ordinary skill in the art will appreciate that: realize that the hardware that all or part of step of said method embodiment can be relevant by programmed instruction completes, aforesaid program can be stored in a computer read/write memory medium, this program, when carrying out, is carried out the step that comprises said method embodiment; And aforesaid storage medium comprises: various media that can be program code stored such as ROM, RAM, magnetic disc or CDs.
The above; be only the specific embodiment of the present invention, but protection scope of the present invention is not limited to this, anyly is familiar with those skilled in the art in the technical scope that the present invention discloses; can expect easily changing or replacing, within all should being encompassed in protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection domain of described claim.

Claims (8)

1. a tables of data correlating method, is characterized in that, comprising:
Read the distributed computing system file, according to the equivalence condition in the numerical relation analysis with any two data sources in described system file property value separately set up the key-value pair that meets described equivalence condition, there is the fixed function relation between every data record and described data source property value separately in wherein said data source;
The order that the data recording of setting up in any two data sources of described key-value pair is provided according to satisfied separately fixed function relation is respectively traveled through, and in described two data sources, finds the data recording that meets separately optimal conditions between the fixed function relation.
2. method according to claim 1, is characterized in that, the order that the data recording in described any two data sources that will set up described key-value pair provides according to satisfied separately fixed function relation respectively travels through and comprises:
By setting up the data recording that there is identical key assignments in any two data sources of described key-value pair, according to satisfied separately fixed function relation, sorted respectively;
The different sequences that generate after sequence are traveled through respectively.
3. method according to claim 1, is characterized in that, before the order that the data recording in described any two data sources that will set up described key-value pair provides according to satisfied separately fixed function relation is respectively traveled through, also comprises:
By setting up the data recording that there is identical key assignments in any two data sources of described key-value pair, according to satisfied separately fixed function relation, sorted respectively.
4. according to the described method of claim 1~3 any one, it is characterized in that, described find the data recording that meets separately optimal conditions between the fixed function relation in described two data sources after, also comprise:
Meet separately the data recording of meeting property condition between the fixed function relation according to described two data sources of the sequential search of described optimal conditions in described two data sources.
5. a tables of data associated apparatus, is characterized in that, comprising:
At least one mapper, for reading the distributed computing system file, according to the equivalence condition in the numerical relation analysis with any two data sources in described system file property value separately set up the key-value pair that meets described equivalence condition, there is the fixed function relation between every data record and described data source property value separately in wherein said data source;
At least one walker, the order provided according to satisfied separately fixed function relation respectively for the data recording of any two data sources that will set up described key-value pair is traveled through, and in described two data sources, finds the data recording that meets separately optimal conditions between the fixed function relation.
6. device according to claim 5, is characterized in that, described walker comprises:
The module of shuffling, the data recording that has identical key assignments for any two data sources that will set up described key-value pair is sorted according to satisfied separately fixed function relation respectively;
Spider module, traveled through respectively for the different sequences by generating after sequence.
7. device according to claim 5, is characterized in that, described device also comprises:
Shuffler, the data recording that has identical key assignments for any two data sources that will set up described key-value pair is sorted according to satisfied separately fixed function relation respectively.
8. according to the described device of claim 5~7 any one, it is characterized in that, described walker is also for meeting separately the data recording of meeting property condition in described two data sources according to described two data sources of the sequential search of described optimal conditions between the fixed function relation.
CN201210196712.6A 2012-06-14 2012-06-14 A kind of data table correlation method and device Active CN103488657B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201210196712.6A CN103488657B (en) 2012-06-14 2012-06-14 A kind of data table correlation method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201210196712.6A CN103488657B (en) 2012-06-14 2012-06-14 A kind of data table correlation method and device

Publications (2)

Publication Number Publication Date
CN103488657A true CN103488657A (en) 2014-01-01
CN103488657B CN103488657B (en) 2016-12-21

Family

ID=49828895

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210196712.6A Active CN103488657B (en) 2012-06-14 2012-06-14 A kind of data table correlation method and device

Country Status (1)

Country Link
CN (1) CN103488657B (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105786941A (en) * 2014-12-26 2016-07-20 中国移动通信集团上海有限公司 Information mining method and device
CN106951557A (en) * 2017-03-31 2017-07-14 北京希嘉创智教育科技有限公司 Daily record correlating method, device and apply its computer system
WO2018040488A1 (en) * 2016-08-31 2018-03-08 华为技术有限公司 Method and device for processing join query
CN110389989A (en) * 2019-07-15 2019-10-29 阿里巴巴集团控股有限公司 A kind of data processing method, device and equipment
CN116226213A (en) * 2023-02-22 2023-06-06 广州集联信息技术有限公司 Information recommendation system and method based on big data

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050198064A1 (en) * 2004-03-05 2005-09-08 Davidson Susan B. Method and apparatus for validating propagation of XML constraints to relations
CN101237348A (en) * 2008-01-24 2008-08-06 中兴通讯股份有限公司 A realization method for simple network management protocol queue
CN101561817A (en) * 2009-06-02 2009-10-21 天津大学 Conversion algorithm from XQuery to SQL query language and method for querying relational data
CN101610524A (en) * 2008-06-17 2009-12-23 中兴通讯股份有限公司 Signalling correlated testing apparatus and method

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050198064A1 (en) * 2004-03-05 2005-09-08 Davidson Susan B. Method and apparatus for validating propagation of XML constraints to relations
CN101237348A (en) * 2008-01-24 2008-08-06 中兴通讯股份有限公司 A realization method for simple network management protocol queue
CN101610524A (en) * 2008-06-17 2009-12-23 中兴通讯股份有限公司 Signalling correlated testing apparatus and method
CN101561817A (en) * 2009-06-02 2009-10-21 天津大学 Conversion algorithm from XQuery to SQL query language and method for querying relational data

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105786941A (en) * 2014-12-26 2016-07-20 中国移动通信集团上海有限公司 Information mining method and device
WO2018040488A1 (en) * 2016-08-31 2018-03-08 华为技术有限公司 Method and device for processing join query
US11030196B2 (en) 2016-08-31 2021-06-08 Huawei Technologies Co., Ltd. Method and apparatus for processing join query
CN106951557A (en) * 2017-03-31 2017-07-14 北京希嘉创智教育科技有限公司 Daily record correlating method, device and apply its computer system
CN106951557B (en) * 2017-03-31 2020-02-07 北京希嘉创智教育科技有限公司 Log association method and device and computer system applying log association method and device
CN110389989A (en) * 2019-07-15 2019-10-29 阿里巴巴集团控股有限公司 A kind of data processing method, device and equipment
CN110389989B (en) * 2019-07-15 2023-08-01 创新先进技术有限公司 Data processing method, device and equipment
CN116226213A (en) * 2023-02-22 2023-06-06 广州集联信息技术有限公司 Information recommendation system and method based on big data
CN116226213B (en) * 2023-02-22 2023-11-10 广州集联信息技术有限公司 Information recommendation system and method based on big data

Also Published As

Publication number Publication date
CN103488657B (en) 2016-12-21

Similar Documents

Publication Publication Date Title
US20190179615A1 (en) Community discovery method, device, server and computer storage medium
CN101571861B (en) Method and device for converting data table
CN103488657A (en) Data table correlation method and device
CN103621145A (en) Full-reference computation of mobile content quality of experience in real-time
US20190026333A1 (en) Executing Graph Path Queries
US20140297167A1 (en) Vehicle position indexing
US10223435B2 (en) Data transfer between multiple databases
CN107818116B (en) Method and equipment for determining user behavior area position information
CN102779138A (en) Hard disk access method of real time data
CN103167171B (en) Selection method and mobile terminal of contact mode
CN103049355A (en) Method and equipment for database system recovery
CN105335368A (en) Product clustering method and apparatus
CN105022807A (en) Information recommendation method and apparatus
Venkataraman et al. Green mobile devices and networks: energy optimization and scavenging techniques
US8712100B2 (en) Profiling activity through video surveillance
CN108319688A (en) A kind of method and apparatus for user read prompting
CN105684455A (en) Video sharing method and system based on app
CN104408183A (en) Data import method and device of data system
CN105138536A (en) Mobile social network data fragmentation method based on directed hypergraph
CN105338097A (en) Terminal screen size-based flow control method, terminal and business server
KR20150061959A (en) Method and apparatus for processing data based on column
CN104125600B (en) The method for recognizing flux of mobile terminal and device
Natrajan et al. To disaggregate or not to disaggregate, that is not the question
CN105897566A (en) User acquisition method and system for network course
Sujatha et al. An efficient Cloud Storage Model for GOP-Level Video deduplication using adaptive GOP structure

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant