CN112148771A - Data association query method and device, electronic equipment and storage medium - Google Patents
Data association query method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN112148771A CN112148771A CN202011005246.XA CN202011005246A CN112148771A CN 112148771 A CN112148771 A CN 112148771A CN 202011005246 A CN202011005246 A CN 202011005246A CN 112148771 A CN112148771 A CN 112148771A
- Authority
- CN
- China
- Prior art keywords
- data
- association
- relation
- query
- relationship
- 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
Images
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a method, a device, electronic equipment and a storage medium for associated query of data, wherein the method comprises the following steps: determining at least one data source to be associated selected by a target object, wherein any one data source to be associated comprises a plurality of pieces of data; determining a corresponding data screening condition and a data operation logic aiming at any one data source to be associated; aiming at any one data source to be associated, extracting target data according to the corresponding data screening condition and the data operation logic; and establishing an association relation between the target data according to a preset association relation establishment rule, and performing association query on the target data based on a relation set formed by the association relation. The incidence relation between the data is established in a configuration mode, the incidence query of the data can be flexibly realized based on the relation set formed by the incidence relation, the query times can be reduced, and the query efficiency is improved.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and an apparatus for querying data in association, an electronic device, and a storage medium.
Background
Distributed storage is carried out as the system data is continuously increased, and the data can be stored in a distributed mode, so that the data can be distributed on different storage nodes.
When a user needs to use data for data analysis, the data can be respectively inquired from each storage node according to actual requirements, and the inquiry efficiency is low due to repeated inquiry.
Disclosure of Invention
The embodiment of the invention aims to provide a data association query method, a data association query device, electronic equipment and a storage medium, so as to achieve the beneficial effects of reducing query times and improving query efficiency. The specific technical scheme is as follows:
in a first aspect of the embodiments of the present invention, a method for querying association of data is provided first, where the method includes:
determining at least one data source to be associated selected by a target object, wherein any one data source to be associated comprises a plurality of pieces of data;
determining a corresponding data screening condition and a data operation logic aiming at any one data source to be associated;
aiming at any one data source to be associated, extracting target data according to the corresponding data screening condition and the data operation logic;
and establishing an association relation between the target data according to a preset association relation establishment rule, and performing association query on the target data based on a relation set formed by the association relation.
In an optional embodiment, the extracting, according to the corresponding data screening condition and the data operation logic, target data for any one of the data sources to be associated includes:
screening data according to the corresponding data screening conditions aiming at any data source to be associated;
and performing logical operation on the screening result by using the corresponding data operation logic to generate target data.
In an optional embodiment, the performing, based on the relationship set formed by the association relationships, an association query on the target data includes:
determining a relation operation logic corresponding to the incidence relation;
performing logical operation processing on the association relation by using the relation operation logic;
and performing association query on the target data based on a relationship set formed by the association relationships subjected to the logical operation.
In an optional embodiment, the performing, based on the relationship set formed by the association relationships, an association query on the target data includes:
screening the incidence relation according to a preset incidence relation screening rule;
and performing association query on the target data corresponding to the rest of the association relations based on a relation set formed by the rest of the association relations.
In an optional embodiment, the performing, based on the relationship set formed by the association relationships, an association query on the target data includes:
displaying a relation set formed by the incidence relations;
receiving a relation set editing instruction input by the target object, and editing the relation set according to the editing instruction;
and performing association query on the target data corresponding to the association relationship in the edited relationship set based on the edited relationship set.
In an optional embodiment, the editing the set of relationships according to the editing instruction includes:
judging whether the relation set is called or not;
and if the relation set is not called, editing the relation set according to the editing instruction.
In an optional embodiment, the method further comprises:
and if the relation set is called, prompting that the relation set is unsuccessfully edited.
In a second aspect of the embodiments of the present invention, there is also provided an apparatus for querying association of data, where the apparatus includes:
the data source determining module is used for determining at least one data source to be associated selected by a target object, wherein any data source to be associated comprises a plurality of pieces of data;
the condition and logic determination module is used for determining a corresponding data screening condition and a corresponding data operation logic for any data source to be associated;
the data extraction module is used for extracting target data according to the corresponding data screening conditions and the data operation logic aiming at any data source to be associated;
the relation establishing module is used for establishing an incidence relation between the target data according to a preset incidence relation establishing rule;
and the association query module is used for performing association query on the target data based on a relationship set formed by the association relationships.
In a third aspect of the embodiments of the present invention, there is further provided an electronic device, including a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete communication with each other through the communication bus;
a memory for storing a computer program;
a processor, configured to implement the method for querying data associated with any of the above first aspects when executing a program stored in a memory.
In a fourth aspect of the embodiments of the present invention, there is further provided a storage medium, where instructions are stored, and when the storage medium is run on a computer, the storage medium causes the computer to execute the method for querying data in association with any one of the first aspect.
In a fifth aspect of the embodiments of the present invention, there is also provided a computer program product containing instructions, which when run on a computer, causes the computer to execute the method for querying data in association with any one of the first aspect.
According to the technical scheme provided by the embodiment of the invention, at least one to-be-associated data source selected by a target object is determined, corresponding data screening conditions and data operation logics are determined for any to-be-associated data source, target data are extracted according to the corresponding data screening conditions and the data operation logics for any to-be-associated data source, association relations among the target data are established according to preset association relation establishment rules, and association query is carried out on the target data based on a relation set formed by the association relations. The incidence relation between the data is established in a configuration mode, the incidence query of the data can be flexibly realized based on the relation set formed by the incidence relation, the query times can be reduced, and the query efficiency is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and together with the description, serve to explain the principles of the invention.
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without inventive exercise.
Fig. 1 is a schematic flow chart illustrating an implementation of a data association query method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a method for determining a data source according to an embodiment of the present invention;
FIG. 3 is a schematic diagram illustrating an association relationship between target data according to an embodiment of the present invention;
fig. 4 is a schematic flow chart illustrating an implementation of another data association query method in the embodiment of the present invention;
fig. 5 is a schematic structural diagram of a data association query apparatus shown in the embodiment of the present invention;
fig. 6 is a schematic structural diagram of an electronic device shown in the embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
As shown in fig. 1, an implementation flow diagram of a data association query method provided in an embodiment of the present invention is specifically shown, where the method specifically includes the following steps:
s101, determining at least one data source to be associated selected by a target object, wherein any data source to be associated comprises a plurality of pieces of data.
The sources are different for different data, i.e. from different data sources. For example, for data 1, system a, for data 2, system B, and for data 3, system C may be sourced.
In order to implement association query on data in different data sources, a target object may select at least one data source to be associated by itself, so as to determine at least one data source to be associated selected by the target object, where for any data source to be associated, mass data may be included.
Wherein, the target object (such as a user, a tester, etc.) can select the same data source, thereby realizing the related query of the data in the same data source.
For example, as shown in fig. 2, for the system a, user basic data is stored, for the system B, user request data is stored, and for the system C, processing result data of the user request data is stored, and the user may select the data source to be associated: the embodiment of the invention can determine the data source to be associated selected by the user: system A, system B, system C.
S102, aiming at any data source to be associated, determining a corresponding data screening condition and a corresponding data operation logic.
And for any determined data source to be associated, determining a data screening condition and a data operation logic corresponding to the data source to be associated. For any data source to be associated, the target object may select the data screening condition and the data operation logic corresponding to the data source to be associated by itself.
The data screening condition can be understood as including a key field, a preset threshold value, and a logical relationship between a field value corresponding to the key field and the preset threshold value. For example, a piece of data may include a plurality of fields, and the data filtering condition may be that a field value of field a is equal to 2, where field a is a key field, 2 is a preset threshold, and is equal to a logical relationship between the field value corresponding to the key field and the preset threshold.
The data operation logic may be understood to include a logical operation such as an and operation or an or operation. For example, for two pieces of data included in the data source: data 1 and data 2 are subjected to and operation, and the and operation is data operation logic.
For example, for system a, system B, and system C, the user may select the data filtering condition and the data operation logic corresponding to system a, system B, and system C, respectively, as shown in table 1 below, and further, the embodiment of the present invention may determine the data filtering condition and the data operation logic corresponding to system a, system B, and system C, respectively.
TABLE 1
S103, aiming at any data source to be associated, extracting target data according to the corresponding data screening condition and the data operation logic.
For any data source to be associated, the target data can be extracted according to the corresponding data screening conditions and the data operation logic. For example, the target data may be extracted from the plurality of pieces of data included in the system a based on the correspondence data filtering conditions and the data operation logic shown in table 1 for the system a, the target data may be extracted from the plurality of pieces of data included in the system B based on the correspondence data filtering conditions and the data operation logic shown in table 1 for the systems B and C, and the target data may be extracted from the plurality of pieces of data included in the system C based on the correspondence data filtering conditions and the data operation logic shown in table 1, similarly for the systems B and C.
Further, screening data according to the corresponding data screening conditions for any data source to be associated; and performing logical operation on the screening result by using the corresponding data operation logic to generate target data.
For example, for a plurality of pieces of data included in system a, each piece of data has a plurality of fields, and the data is filtered according to a data filtering condition corresponding to system a, where the data filtering condition may be a plurality of data, so that data satisfying field value of field a equal to 2 can be filtered from system a, and data satisfying field value of field B greater than 3 can be filtered, it should be noted that here, the filtering is divided, so that the filtering results shown in table 2 below can be obtained.
TABLE 2
For the screening results from data screening in system a: the extraction of the target data may be completed by performing an and operation on the screening results 1 (shown in table 1) and the screening results 2 (shown in table 1) or performing an or operation on the screening results 1 and the screening results 2, respectively, and performing a logical operation on the screening results according to the corresponding data operation logic to generate the target data.
It should be noted that, for other data sources to be associated, for example, the processing of the system B and the system C is similar to the processing of the system a, and the details of the embodiments of the present invention are not repeated here.
S104, establishing an association relation between the target data according to a preset association relation establishment rule, and performing association query on the target data based on a relation set formed by the association relation.
In the embodiment of the invention, for the target data, the association relationship between the target data can be established according to the preset association relationship establishing rule. Here, the preset association relationship establishment rule may be an association relationship set according to actual needs.
For example, for the system a, the data screening is performed on the pieces of data included in the system a according to the data screening condition "the field value of the field a is equal to 2" and the field value of the field B is greater than 3 ", so as to obtain the screening results 1 and 2 shown in the above table 2, and the and operation is performed on the screening results 1 and 2, so that the target data, i.e., the aggregate of the screening results 1 and 2, is extracted from the pieces of data included in the system a.
For the system B, according to the data filtering condition that the field value of the field C is equal to 2 and the field value of the field D is greater than 3, the data filtering is performed on the pieces of data included in the system B, so as to obtain the corresponding filtering result 3 and the corresponding filtering result 4, and the filtering result 3 and the filtering result 4 are subjected to and operation, so that the target data, i.e., the aggregate of the filtering results 3 and the filtering results 4, is extracted from the pieces of data included in the system B.
The association relationship between the target data is established according to a preset association relationship establishing rule, where the preset association relationship establishing rule may be in one-to-one correspondence, so that the association relationship shown in fig. 3 may be obtained, the screening result 1 is associated with the screening result 3 to generate an association relationship a, and the screening result 2 is associated with the screening result 4 to generate an association relationship b.
Thus, the association relationship between the target data is established according to the preset association relationship establishing rule, which can be regarded as the establishment of the association relationship between the screening results in different target data, wherein the screening result is the result of data screening on the to-be-associated data source according to the data screening condition.
For the established association relationship, a relationship set may be formed based on the association relationship, and the target data may be subjected to association query based on the relationship set. For example, as shown in fig. 3, a screening result 1 is associated with a screening result 3 to generate an association relationship a, a screening result 2 is associated with a screening result 4 to generate an association relationship b, and thus two association relationships exist, thereby forming a relationship set.
Subsequently, the name, ID, and other identifiers of the relationship set may be input, and the relationship a in the relationship set may query the screening result 1 included in the target data in the system a and the screening result 3 included in the target data in the system B, and the relationship B in the relationship set may query the screening result 2 included in the target data in the system a and the screening result 4 included in the target data in the system B.
Through the above description of the technical solution provided by the embodiment of the present invention, at least one to-be-associated data source selected by a target object is determined, a corresponding data screening condition and a corresponding data operation logic are determined for any to-be-associated data source, target data are extracted according to the corresponding data screening condition and the corresponding data operation logic for any to-be-associated data source, an association relationship between the target data is established according to a preset association relationship establishment rule, and association query is performed on the target data based on a relationship set formed by the association relationship. The incidence relation between the data is established in a configuration mode, the incidence query of the data can be flexibly realized based on the relation set formed by the incidence relation, the query times can be reduced, and the query efficiency is improved.
As shown in fig. 4, an implementation flow diagram of another data association query method provided in the embodiment of the present invention is specifically shown, where the method specifically includes the following steps:
s401, determining at least one data source to be associated selected by a target object, wherein any one data source to be associated comprises a plurality of pieces of data.
In the embodiment of the present invention, this step is similar to the step S101, and the details of the embodiment of the present invention are not repeated herein.
S402, aiming at any data source to be associated, determining a corresponding data screening condition and a data operation logic.
In the embodiment of the present invention, this step is similar to the step S102, and the details of the embodiment of the present invention are not repeated herein.
And S403, aiming at any data source to be associated, extracting target data according to the corresponding data screening condition and the data operation logic.
In the embodiment of the present invention, this step is similar to the step S103, and the details of the embodiment of the present invention are not repeated herein.
S404, establishing an association relation between the target data according to a preset association relation establishment rule.
In the embodiment of the present invention, this step is similar to the step S104, and the details of the embodiment of the present invention are not repeated herein.
S405, determining a relation operation logic corresponding to the association relation.
And S406, performing logic operation processing on the association relation by using the relation operation logic.
For the association relationship, in the embodiment of the present invention, a corresponding relationship operation logic may be determined, and the association relationship may be subjected to a logic operation process according to the relationship operation logic. The relational operation logic may be understood as including logical operations such as and operation or operation, which is not limited in the embodiments of the present invention.
For example, as shown in fig. 3, a filtering result 1 is associated with a filtering result 3 to generate an association a, a filtering result 2 is associated with a filtering result 4 to generate an association b, so that there are two associations, and a user can input a relationship operation logic of the association a and the association b: and operation can be performed on the association relationship a and the association relationship b.
S407, performing association query on the target data based on a relationship set formed by the association relationships subjected to the logical operation.
For the association relationship, after the logical operation processing is performed, association query may be performed on the target data based on a relationship set composed of the association relationships subjected to the logical operation.
For example, as shown in fig. 3, a filtering result 1 is associated with a filtering result 3 to generate an association a, a filtering result 2 is associated with a filtering result 4 to generate an association b, so that there are two associations, and a user can input a relationship operation logic of the association a and the association b: and operation, the association relationship a and the association relationship b can be subjected to and operation, and after the and operation processing, a relationship set can be formed based on the association relationship a and the association relationship b, and the logical relationship between the two is the and relationship.
Subsequently, the name, ID, and other identifiers of the relationship set may be input, and the relationship a in the relationship set may query the screening result 1 included in the target data in the system a and the screening result 3 included in the target data in the system B, and the relationship B in the relationship set may query the screening result 2 included in the target data in the system a and the screening result 4 included in the target data in the system B.
In addition, for the association relationship, after the logical operation processing, the association relationship subjected to the logical operation may be screened according to a preset association relationship screening rule, and based on a relationship set formed by the remaining association relationships, association query may be performed on the target data corresponding to the remaining association relationships. The preset association relationship screening rule may be, for example, a data size corresponding to the association relationship, or may be self-screened by the user, so that unnecessary association relationships may be eliminated.
For example, for the association relationship a and the association relationship b, the data amount corresponding to the association relationship a, that is, the data amount corresponding to the screening result 1 and the screening result 3 is determined, and if the data amount corresponding to the screening result 1 and the screening result 3 is less, the association relationship a can be removed; and determining the data quantity corresponding to the association relationship b, namely the data quantity corresponding to the screening results 2 and 4, and if the data quantity corresponding to the screening results 2 and 4 is less, rejecting the association relationship b.
For the remaining association relations, for example, the association relation a, the association query may be performed on the target data corresponding to the association relation a based on the relation set formed by the association relation a. For example, the user inputs the name, ID, and other identifiers of the relationship set, and the association relationship a in the relationship set can query the filtering result 1 contained in the target data in system a and the filtering result 3 contained in the target data in system B.
In addition, the relationship set composed of the association relationships may be displayed, for example, the number of the relationship set, the name of the relationship set, the creator, the creation start time, the creation end time, and the like may be specifically displayed, which is not limited in the embodiment of the present invention.
The embodiment of the invention can receive a relation set editing instruction input by a user and edit the relation set according to the editing instruction, thereby carrying out association query on target data corresponding to the association in the edited relation set based on the edited relation set. The relationship set editing instruction may be an enabling/disabling instruction, a deleting instruction, or an editing instruction, which is not limited in the embodiment of the present invention.
For example, for a newly added relationship set, the state of the relationship set is disabled, and after a user inputs an enabling instruction, the state of the relationship set is changed to enabled, and only the enabled relationship set can be normally used.
For example, for a relationship set whose state is enabled, after a user inputs a disable instruction, it is determined whether the relationship set is called, for example, whether the relationship set is called by a service such as an index, a sub-report, an alarm, a monitoring chart, or the like, and if the relationship set is not called, the state of the relationship set may be changed to be disabled, and if the relationship set is called, a failure in disabling is prompted.
For example, for a relationship set whose state is enabled, after a user inputs a delete instruction, it is determined whether the relationship set is called, for example, whether the relationship set is called by a service such as an index, a sub-report, an alarm, a monitoring chart, etc., and if the relationship set is not called, the relationship set may be deleted, and if the relationship set is called, a deletion failure is prompted.
For example, after the user inputs an edit instruction for a relationship set whose state is enabled, it is determined whether the relationship set is called, for example, whether the relationship set is called by a service such as an index, a sub-report, an alarm, a monitoring chart, etc., and if the relationship set is not called, the relationship set may be edited, and if the relationship set is called, an edit failure is prompted.
For example, for a set of relationships whose status is enabled, the user may view the set of relationships after entering a detail instruction.
Corresponding to the foregoing method embodiment, an embodiment of the present invention further provides an apparatus for querying association of data, as shown in fig. 5, where the apparatus may include: a data source determination module 510, a condition, logic determination module 520, a data extraction module 530, a relationship establishment module 540, and an association query module 550.
A data source determining module 510, configured to determine at least one data source to be associated selected by a target object, where any of the data sources to be associated includes multiple pieces of data;
a condition and logic determining module 520, configured to determine, for any one of the data sources to be associated, a corresponding data screening condition and a corresponding data operation logic;
a data extraction module 530, configured to extract, for any one of the data sources to be associated, target data according to the corresponding data screening condition and the data operation logic;
a relationship establishing module 540, configured to establish an association relationship between the target data according to a preset association relationship establishing rule;
and an association query module 550, configured to perform association query on the target data based on the relationship set formed by the association relationships.
An embodiment of the present invention further provides an electronic device, as shown in fig. 6, including a processor 61, a communication interface 62, a memory 63, and a communication bus 64, where the processor 61, the communication interface 62, and the memory 63 complete mutual communication through the communication bus 64,
a memory 63 for storing a computer program;
the processor 61 is configured to implement the following steps when executing the program stored in the memory 63:
determining at least one data source to be associated selected by a target object, wherein any one data source to be associated comprises a plurality of pieces of data; determining a corresponding data screening condition and a data operation logic aiming at any one data source to be associated; aiming at any one data source to be associated, extracting target data according to the corresponding data screening condition and the data operation logic; and establishing an association relation between the target data according to a preset association relation establishment rule, and performing association query on the target data based on a relation set formed by the association relation.
The communication bus mentioned in the electronic device may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The communication bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.
The communication interface is used for communication between the electronic equipment and other equipment.
The Memory may include a Random Access Memory (RAM) or a non-volatile Memory (non-volatile Memory), such as at least one disk Memory. Optionally, the memory may also be at least one memory device located remotely from the processor.
The Processor may be a general-purpose Processor, and includes a Central Processing Unit (CPU), a Network Processor (NP), and the like; the Integrated Circuit may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, a discrete Gate or transistor logic device, or a discrete hardware component.
In another embodiment of the present invention, a storage medium is further provided, where instructions are stored, and when the instructions are executed on a computer, the instructions cause the computer to execute the method for querying data associated with any one of the above embodiments.
In yet another embodiment, the present invention further provides a computer program product containing instructions, which when run on a computer, causes the computer to execute the method for querying data associated with any of the above embodiments.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the invention to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored on a storage medium or transmitted from one storage medium to another, for example, from one website, computer, server, or data center to another website, computer, server, or data center via wire (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The storage medium may be any available medium that can be accessed by a computer or a data storage device including one or more available media integrated servers, data centers, and the like. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only for the preferred embodiment of the present invention, and is not intended to limit the scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.
Claims (10)
1. A method for querying association of data, the method comprising:
determining at least one data source to be associated selected by a target object, wherein any one data source to be associated comprises a plurality of pieces of data;
determining a corresponding data screening condition and a data operation logic aiming at any one data source to be associated;
aiming at any one data source to be associated, extracting target data according to the corresponding data screening condition and the data operation logic;
and establishing an association relation between the target data according to a preset association relation establishment rule, and performing association query on the target data based on a relation set formed by the association relation.
2. The method according to claim 1, wherein the extracting target data according to the corresponding data screening condition and the data operation logic for any one of the data sources to be associated comprises:
screening data according to the corresponding data screening conditions aiming at any data source to be associated;
and performing logical operation on the screening result by using the corresponding data operation logic to generate target data.
3. The method according to claim 1, wherein the performing a correlation query on the target data based on the relationship set composed of the correlation relationships comprises:
determining a relation operation logic corresponding to the incidence relation;
performing logical operation processing on the association relation by using the relation operation logic;
and performing association query on the target data based on a relationship set formed by the association relationships subjected to the logical operation.
4. The method according to claim 1, wherein the performing a correlation query on the target data based on the relationship set composed of the correlation relationships comprises:
screening the incidence relation according to a preset incidence relation screening rule;
and performing association query on the target data corresponding to the rest of the association relations based on a relation set formed by the rest of the association relations.
5. The method according to claim 1, wherein the performing a correlation query on the target data based on the relationship set composed of the correlation relationships comprises:
displaying a relation set formed by the incidence relations;
receiving a relation set editing instruction input by the target object, and editing the relation set according to the editing instruction;
and performing association query on the target data corresponding to the association relationship in the edited relationship set based on the edited relationship set.
6. The method of claim 5, wherein said editing the set of relationships according to the editing instructions comprises:
judging whether the relation set is called or not;
and if the relation set is not called, editing the relation set according to the editing instruction.
7. The method of claim 6, further comprising:
and if the relation set is called, prompting that the relation set is unsuccessfully edited.
8. An apparatus for querying association of data, the apparatus comprising:
the data source determining module is used for determining at least one data source to be associated selected by a target object, wherein any data source to be associated comprises a plurality of pieces of data;
the condition and logic determination module is used for determining a corresponding data screening condition and a corresponding data operation logic for any data source to be associated;
the data extraction module is used for extracting target data according to the corresponding data screening conditions and the data operation logic aiming at any data source to be associated;
the relation establishing module is used for establishing an incidence relation between the target data according to a preset incidence relation establishing rule;
and the association query module is used for performing association query on the target data based on a relationship set formed by the association relationships.
9. An electronic device is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor and the communication interface are used for realizing mutual communication by the memory through the communication bus;
a memory for storing a computer program;
a processor for implementing the method steps of any one of claims 1 to 7 when executing a program stored in the memory.
10. A storage medium on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011005246.XA CN112148771A (en) | 2020-09-22 | 2020-09-22 | Data association query method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011005246.XA CN112148771A (en) | 2020-09-22 | 2020-09-22 | Data association query method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112148771A true CN112148771A (en) | 2020-12-29 |
Family
ID=73897575
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011005246.XA Pending CN112148771A (en) | 2020-09-22 | 2020-09-22 | Data association query method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112148771A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080133491A1 (en) * | 2006-11-30 | 2008-06-05 | Inagaki Iwao | Method For Dynamically Finding Relations Between Database Tables |
| WO2011151500A1 (en) * | 2010-05-31 | 2011-12-08 | Helsingin Yliopisto | Arrangement and method for finding relationships among data |
| US20170103104A1 (en) * | 2015-10-07 | 2017-04-13 | International Business Machines Corporation | Query plan based on a data storage relationship |
| CN108038135A (en) * | 2017-11-21 | 2018-05-15 | 平安科技（深圳）有限公司 | Electronic device, the method for multilist correlation inquiry and storage medium |
| CN110825766A (en) * | 2019-11-13 | 2020-02-21 | 恩亿科(北京)数据科技有限公司 | Query condition generation method and device, server and readable storage medium |
-
2020
- 2020-09-22 CN CN202011005246.XA patent/CN112148771A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080133491A1 (en) * | 2006-11-30 | 2008-06-05 | Inagaki Iwao | Method For Dynamically Finding Relations Between Database Tables |
| WO2011151500A1 (en) * | 2010-05-31 | 2011-12-08 | Helsingin Yliopisto | Arrangement and method for finding relationships among data |
| US20170103104A1 (en) * | 2015-10-07 | 2017-04-13 | International Business Machines Corporation | Query plan based on a data storage relationship |
| CN108038135A (en) * | 2017-11-21 | 2018-05-15 | 平安科技（深圳）有限公司 | Electronic device, the method for multilist correlation inquiry and storage medium |
| CN110825766A (en) * | 2019-11-13 | 2020-02-21 | 恩亿科(北京)数据科技有限公司 | Query condition generation method and device, server and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109213604B (en) | Data source management method and device | |
| CN110083475B (en) | Abnormal data detection method and device | |
| CN105760395A (en) | Data processing method, device and system | |
| CN113591068B (en) | Online login device management method and device and electronic device | |
| CN111062013A (en) | Account filtering method and device, electronic equipment and machine-readable storage medium | |
| CN111782728B (en) | Data synchronization method, device, electronic equipment and medium | |
| CN111125240B (en) | Distributed transaction realization method and device, electronic equipment and storage medium | |
| CN110555144A (en) | stream clustering method and device, electronic equipment and medium | |
| CN113010494A (en) | Database auditing method and device and database proxy server | |
| CN110727895B (en) | Sensitive word sending method and device, electronic equipment and storage medium | |
| CN110427538B (en) | Data query method, data storage method, data query device, data storage device and electronic equipment | |
| CN108287659B (en) | Data sampling method and device based on real-time data stream and electronic equipment | |
| CN112148771A (en) | Data association query method and device, electronic equipment and storage medium | |
| CN111294613A (en) | Video processing method, client and server | |
| CN105653540A (en) | Method and device for processing file attribute information | |
| CN110674330B (en) | Expression management method and device, electronic equipment and storage medium | |
| CN111143311B (en) | Inter-application association determination and log association search methods, devices, media and equipment | |
| CN112434215A (en) | Ranking list generation method and device, electronic equipment and storage medium | |
| CN111488490A (en) | Video clustering method, device, server and storage medium | |
| CN112256820A (en) | Document positioning method and device | |
| CN111163088B (en) | Message processing method, system and device and electronic equipment | |
| CN110909171B (en) | Data scheduling method, device, terminal and storage medium | |
| CN112416401B (en) | Data updating method, device and equipment | |
| CN109471917B (en) | Data processing method, device, equipment and medium | |
| CN111143628A (en) | Data generation method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: Room 221, 2 / F, block C, 18 Kechuang 11th Street, Daxing District, Beijing, 100176 Applicant after: Jingdong Technology Holding Co.,Ltd. Address before: Room 221, 2 / F, block C, 18 Kechuang 11th Street, Daxing District, Beijing, 100176 Applicant before: Jingdong Digital Technology Holding Co., Ltd |