CN111026775A - Method and device for determining correlation index, server and storage medium - Google Patents

Method and device for determining correlation index, server and storage medium Download PDF

Info

Publication number
CN111026775A
CN111026775A CN201911275487.3A CN201911275487A CN111026775A CN 111026775 A CN111026775 A CN 111026775A CN 201911275487 A CN201911275487 A CN 201911275487A CN 111026775 A CN111026775 A CN 111026775A
Authority
CN
China
Prior art keywords
index
information
queried
determining
distance
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
Application number
CN201911275487.3A
Other languages
Chinese (zh)
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.)
Big Data Center Of State Grid Corp Of China
Original Assignee
Big Data Center Of State Grid Corp Of China
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 Big Data Center Of State Grid Corp Of China filed Critical Big Data Center Of State Grid Corp Of China
Priority to CN201911275487.3A priority Critical patent/CN111026775A/en
Publication of CN111026775A publication Critical patent/CN111026775A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the invention discloses a method, a device, a server and a storage medium for determining a correlation index. The method comprises the following steps: when a related index query request is received, acquiring identification information of an index to be queried; determining a relation distance between the index to be inquired and each index to be selected in the index library according to the identification information and the index relation map of the index library; and determining the correlation index of the index to be queried according to the relationship distance. By adopting the technical scheme, the embodiment of the invention establishes the index relation map containing the indexes of different services stored in the database for the index database, and determines the associated index of the index to be inquired according to the index relation map, thereby meeting the associated index inquiry requirements of different services, reducing faults existing among cross-service data relations and improving the accuracy and comprehensiveness of the associated index inquiry result.

Description

Method and device for determining correlation index, server and storage medium
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method, an apparatus, a server, and a storage medium for determining a correlation index.
Background
The enterprise data has the characteristics of diversified sources, large quantity and wide distribution. Physically, the data are in discrete states, but actually, business data often have close association in business logic. When performing service management, associated data query needs to be performed on data. In a traditional mode, a fixed data relation model is generally established to realize the association query among data, that is, a worker sets data associated with each data in advance, and when a user performs the association query, the set associated data is displayed to the user.
However, the traditional data association mode is too dependent on the data structure setting of the service information system, different services often adopt different data structures, and when the services change, the fixed data relation model can no longer meet the new association query requirement.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method, an apparatus, a server, and a storage medium for determining a correlation index, so as to solve the technical problem that the existing correlation query scheme cannot meet the query requirements of correlation indexes of different services.
In a first aspect, an embodiment of the present invention provides a method for determining a correlation index, including:
when a related index query request is received, acquiring identification information of an index to be queried;
determining a relation distance between the index to be inquired and each index to be selected in the index library according to the identification information and the index relation map of the index library;
and determining the correlation index of the index to be queried according to the relationship distance.
In a second aspect, an embodiment of the present invention provides an apparatus for determining a correlation index, including:
the information acquisition module is used for acquiring the identification information of the index to be inquired when the associated index inquiry request is received;
the distance determining module is used for determining the relationship distance between the index to be inquired and each index to be selected in the index library according to the identification information and the index relationship map of the index library;
and the index determining module is used for determining the associated index of the index to be inquired according to the relation distance.
In a third aspect, an embodiment of the present invention provides a server, including:
one or more processors;
a memory for storing one or more programs,
when the one or more programs are executed by the one or more processors, the one or more processors implement the method for determining the relevance metric according to the embodiment of the present invention.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method for determining the correlation index according to the embodiment of the present invention.
In the technical scheme for determining the correlation index, when a correlation index query request is received, identification information of an index to be queried is obtained, a relationship distance between the index to be queried and each index to be selected in an index library is determined according to the identification information and an index relationship map of the index library, and the correlation index of the index to be queried is determined according to the relationship distance. By adopting the technical scheme, the index relation map containing the indexes of different services stored in the database is established for the index database, and the correlation index of the index to be inquired is determined according to the index relation map, so that the correlation index inquiry requirements of different services can be met, the fault existing among cross-service data relations is reduced, and the accuracy and the comprehensiveness of the correlation index inquiry result are improved.
Drawings
Other features, objects and advantages of the invention will become more apparent upon reading of the detailed description of non-limiting embodiments made with reference to the following drawings:
fig. 1 is a schematic flowchart of a method for determining a correlation index according to an embodiment of the present invention;
fig. 2 is a schematic flowchart of a method for determining a correlation index according to a second embodiment of the present invention;
fig. 3 is a block diagram of a device for determining a correlation index according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a server according to a fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some but not all of the relevant aspects of the present invention are shown in the drawings. In addition, the embodiments and features of the embodiments of the present invention may be combined with each other without conflict
Example one
The embodiment of the invention provides a method for determining a correlation index. The method can be executed by a device for determining the associated index, wherein the device can be realized by software and/or hardware, can be generally integrated in a server with an associated index query function, and is suitable for the conditions of performing associated query and retrieval. Fig. 1 is a schematic flowchart of a method for determining a correlation index according to an embodiment of the present invention, as shown in fig. 1, the method includes:
s110, when the associated index query request is received, the identification information of the index to be queried is obtained.
In this embodiment, the server may obtain the identification information of the index to be queried when receiving the association index query request, so as to determine the index on which the user needs to perform the association index query based on the identification information of the index to be queried, so as to query the association index associated with the index from the index library. The index to be inquired is an index of the user to inquire the associated index of the user; the correlation index query request can be sent to the server by the user side; the identification information of the index to be queried can be understood as information capable of uniquely determining the identity of the index to be queried, such as an identity ID of the index to be queried, and the identification information can be distributed by a user side or a server, and preferably can be distributed by the server when the user constructs the index to be queried or stores the index to be queried in an index library, so as to avoid the situation that the index to be queried and other indexes stored in the index library have the same identification information, and ensure that each piece of distributed identification information can uniquely identify one index.
Illustratively, when a user needs to query the associated index of a certain index, the user selects the index and clicks an associated index query key; when a user side detects that a correlation index query key is triggered by a user, determining that the user needs to perform correlation index query operation, determining a selected index as an index to be queried, acquiring identification information of the index to be queried, generating a correlation index query request carrying the identification information, and sending the correlation index query request to a server; correspondingly, after receiving the associated index query request sent by the user side, the server analyzes the associated index query request, and then the identification information of the index to be queried can be obtained. The server may further analyze the associated index query request to obtain the identity information of the user side that sent the associated index query request, so that communication may be subsequently performed with the user side based on the identity information, for example, the determined associated index information of the associated index of the index to be queried is sent to the user side, so that the associated index information is displayed to the user through the user side.
And S120, determining the relationship distance between the index to be queried and each index to be selected in the index library according to the identification information and the index relationship map of the index library.
Specifically, the index relational graph of the index library can be obtained through rendering according to graph information of the index relational graph, the index to be queried in the index relational graph is identified according to the identification information of the index to be queried, and the distance between the index to be queried and each index to be selected having a connection relation with the index to be queried is determined, so that the relational distance between the index to be queried and each index to be selected in the index library is obtained; or directly inquiring from the map information of the index relation map according to the identification information of the index to be inquired to obtain the position coordinate of the index to be inquired in the index relation map, inquiring from the map information of the index relation map according to the identification information of each index to be selected to obtain the position coordinate of the index to be inquired in the index relation map, and calculating the relation distance between the index to be inquired and each index to be selected according to the position coordinate of the index to be inquired and the position coordinate of each index to be selected.
In this step, the relationship distance between the index to be queried and the index to be selected may be understood as a distance between the index to be queried and the index to be selected in the index relationship map, that is, a distance between the identification information of the index to be queried and the identification information of the index to be selected in the index relationship map, where the distance may be used to represent a degree of association between the index to be queried and the index to be selected, and the magnitude of the relationship distance is inversely proportional to the degree of association between the index to be queried and the index to be selected, that is, the greater the relationship distance between the index to be queried and the index to be selected is, the weaker the degree of association between; the smaller the relationship distance between the index relationship map and the target relationship map is, the stronger the correlation degree between the index relationship map and the target relationship map is. The identification information of each index (such as the index to be queried and the index to be selected) may be presented in the index relationship map in the form of an icon, and accordingly, the relationship distance between the index to be queried and the index to be selected may specifically be a distance between an icon of the index to be queried and an icon of the index to be selected in the index relationship map, that is, a length of a line segment connecting the two icons, which is described below by taking this case as an example.
S130, determining the correlation index of the index to be inquired according to the relation distance.
In this embodiment, the index to be queried, of which the distance from the relationship with the index to be queried is within the set distance range, may be selected as the association index of the index to be queried; or sorting the to-be-selected indexes having connection relations with the to-be-queried indexes in the index relation map according to the sequence of the relation distances from small to large, and acquiring a set number of the to-be-selected indexes as the associated indexes of the query indexes according to the sequence from front to back, which is not limited in this embodiment. The correlation index can be understood as a candidate index having a correlation relationship with the index to be queried in the index library.
In the method for determining the associated index provided in the embodiment of the present invention, when a request for querying the associated index is received, identification information of an index to be queried is obtained, a relationship distance between the index to be queried and each index to be selected in an index library is determined according to the identification information and an index relationship map of the index library, and the associated index of the index to be queried is determined according to the relationship distance. By adopting the technical scheme, the index relation map containing the indexes of each service stored in the database is established for the index database, and the associated index of the index to be inquired is determined according to the index relation map, so that the query requirement of the associated indexes of different services can be met, the fault existing among cross-service data relations is reduced, and the accuracy and the comprehensiveness of the query result of the associated index are improved.
On the basis of the foregoing embodiment, before acquiring the identification information of the index to be queried when the associated index query request sent by the user end is received, the method may further include: and in response to the condition that the index to be inquired is stored in an index library, updating the index relation map of the index library. In this embodiment, when a new index (such as an index to be queried) is stored in the index library, the index relationship map of the index library may be updated, that is, the index newly stored in the index library is added to the index relationship map of the index library, so as to ensure that a user can query and obtain a relevant index of the index to be queried based on the updated index relationship map when there is a requirement for querying a relevant index. Specifically, after the index to be queried is constructed, the user side automatically or based on the storage operation of the user sends a storage request carrying the index to be queried to the server, and the server stores the index to be queried carried in the storage request in an index library; correspondingly, the server can update the index relation map in the index library after the index to be queried is stored in the index library.
Example two
Fig. 2 is a flowchart illustrating a method for determining a correlation index according to a second embodiment of the present invention. In this embodiment, on the basis of the above embodiment, the "updating the index relationship map of the index library" is optimized as follows: acquiring index information to be inquired of an index to be inquired, wherein the index information to be inquired comprises access rule information, attribute characteristic information and index dimension information; determining the relation distance between the index to be queried and each index to be selected in the index library according to the index information to be queried; and adding the identification information of the index to be inquired into the index relation map of the index library according to the relation distance.
Further, after the determining the correlation index of the index to be queried according to the relationship distance information, the method further includes: and feeding back the associated index information of the associated index to the user side sending the associated index query request so as to enable the user side to display the associated index information.
Further, after the sending the relevant index information of the relevant index to the user side, the method further includes: when an associated report query request sent by the user side is received, acquiring associated report information of an associated report which refers to the associated index, and sending the associated report information to the user side so as to display the associated report information to the user through the user side, wherein the associated report query request is generated by the user side when the user clicks the associated index information.
Correspondingly, as shown in fig. 2, the method for determining the correlation index provided in this embodiment includes:
s210, in response to the condition that the index to be queried is stored in the index library, acquiring index information to be queried of the index to be queried, wherein the index information to be queried comprises access rule information, attribute feature information and index dimension information.
Specifically, when the index to be queried is stored in the index library, the index to be queried may be analyzed to obtain access rule information, attribute feature information, and index dimension information of the index to be queried. The data source of the index to be queried can be analyzed to obtain the access rule information of the index to be queried; the attribute feature information of the index to be queried may include the attribute feature information of the index to be queried itself, and may further include the attribute feature information of a report to which the index to be queried belongs and/or the attribute feature information of a parent index and a child index of the index to be queried, where the attribute feature information may include information such as the type, the field to which the index belongs, the industry and/or an explanation label of a corresponding index or report, and may be obtained by performing semantic analysis on name information of the corresponding report or index, for example, performing word segmentation processing on the attribute information of the index to be queried according to a pre-established professional lexicon of each field, and performing part-of-speech classification on each word after word segmentation; the index dimension information of the index to be queried can be obtained by analyzing the relevant definition of the data dimension of the index to be queried by a user.
S220, determining the relationship distance between the index to be queried and each index to be selected in the index library according to the index information to be queried.
In this embodiment, when determining the relationship distance between the index to be queried and each index to be selected in the index library, only the hard association relationship between the index to be queried and each index to be selected, that is, the operational relationship between the index to be queried and each index to be selected may be considered, for example, the relationship distance between the index to be queried and the index to be selected having an operational relationship therewith is determined as a first preset distance, and the relationship distance between the index to be queried and the index to be selected having an operational relationship therewith is determined as a second preset distance; the soft association relationship between the index to be queried and each of the indexes to be selected, that is, the similarity between the index to be queried and each of the indexes to be selected may also be further considered, for example, a first distance factor between the index to be queried and each of the indexes to be selected is obtained according to the operational relationship between the index to be queried and each of the indexes to be selected, a second distance factor between the index to be queried and each of the indexes to be selected is determined according to the similarity between the index to be queried and each of the indexes to be selected, and the relationship distance between the index to be queried and each of the indexes to be selected is determined based on the first distance factor and the second distance factor. The index to be selected can be other indexes stored in an index library except the index to be inquired; the first preset distance and the second preset distance can be set as required, and the first preset distance is only required to be smaller than the second preset distance, and preferably, the second preset distance can be set to be a value far smaller than the first preset distance.
In order to further improve the accuracy of the determined relationship distance, preferably, the relationship distance between the index to be queried and each index to be selected in the index library may be determined based on the operation relationship and similarity between the index to be queried and each index to be selected in the index library. At this time, the determining of the relationship distance between the index to be queried and each index to be selected in the index library according to the index information to be queried may be optimized as follows: judging whether the index to be selected is an operation factor of the index to be inquired or not according to the access rule information aiming at each index to be selected in an index library, generating a judgment result, and determining a first distance factor between the index to be inquired and the index to be selected according to the judgment result; calculating the similarity between the index to be queried and the index to be selected according to the attribute feature information and the index dimension information, and determining a second distance factor between the index to be queried and the index to be selected according to the similarity; and calculating the weighted sum of the first distance factor and the second distance factor to obtain the relation distance between the index to be inquired and the index to be selected in the index relation map of the index library.
For example, whether an operation relationship exists between the index to be queried and the selected index is judged according to the access rule information of the index to be queried for each index to be selected, if so, a first distance factor between the index to be queried and the selected index is determined as a first preset distance, and if not, the first distance factor between the index to be queried and the selected index is determined as a second preset distance; the method comprises the steps of obtaining attribute feature vectors and dimension feature vectors of indexes to be inquired according to the part of speech of each word obtained by word segmentation, combining the attribute feature vectors and the dimension feature vectors to obtain feature vectors of the indexes to be inquired, calculating the similarity between the indexes to be inquired and the indexes to be selected according to the feature vectors of the indexes to be inquired and the feature vectors of the indexes to be selected, and determining a second distance factor between the indexes to be inquired and the indexes to be selected according to the similarity according to a conversion relation between preset similarity and a second distance factor; and further, according to a preset weight value of the first distance factor and the second distance factor, calculating a weighted sum of the first distance factor and the second distance factor, and obtaining a relation distance between the index to be inquired and the index to be selected. The weight values of the first distance factor and the second distance factor can be set in advance according to needs.
And S230, adding the identification information of the index to be inquired into the index relation map of the index library according to the relation distance.
In this embodiment, the size of the relationship distance between the index to be queried and each index to be selected may not be considered, the position of the index to be queried in the index relationship map is directly determined according to the relationship distance between the index to be queried and each index to be selected, the icon of the index to be queried is drawn at the position, and the connection relationship between the icon of the index to be queried and the icon of each index to be selected in the index relationship map is established, that is, the icon of the index to be queried and the icon of each index to be selected are connected; the relation distance between the index to be queried and each index to be selected can be considered, after the relation distance between the index to be queried and each index to be selected in the index library is determined, the index to be selected, of which the relation distance between the index to be queried and each index to be selected is smaller than or equal to a preset distance threshold value, is determined as a target index to be selected, of which the relation with the index to be queried exists, the position of the index to be queried in the index relation map is determined according to the relation distance between the index to be queried and each target index to be selected, the icon of the index to be queried is drawn at the position, the connection relation between the icon of the index to be queried and the icon of each target index to be selected in the index relation map is established, so that the index to be queried, of which the correlation degree with the index to be queried in the index library is weak, is filtered, and the.
S240, when the associated index query request is received, acquiring the identification information of the index to be queried.
And S250, determining the relationship distance between the index to be inquired and each index to be selected in the index library according to the identification information and the index relationship map of the index library.
And S260, determining the correlation index of the index to be queried according to the relation distance.
And S270, feeding back the associated index information of the associated index to the user side sending the associated index query request so that the user side can display the associated index information.
Illustratively, the server generates a query result carrying associated index information of the associated index, and sends the query result to the user side according to the identity information of the user side carried in the associated index query request; and the user side receives and analyzes the query result sent by the server to obtain the associated index information of the associated index which has an associated relation with the index to be queried, and displays the associated index information to the user.
S280, when receiving an associated report query request sent by the user side, obtaining associated report information of an associated report which refers to the associated index, and sending the associated report information to the user side so as to display the associated report information to the user through the user side, wherein the associated report query request is generated by the user side when the user clicks the associated index information.
In this embodiment, after the associated index information is displayed to the user, associated chart information of an associated chart to which the associated index belongs may be further displayed to the user, so that the user can know the use environment of the associated index. At this time, the method for determining the association index provided in this embodiment may further include: when any index in the index library is monitored to be quoted, the quoted information of the index is recorded, and the quoted information comprises report information of a report which quotes the index. The reference information can further comprise position information of the index in the report, so that the index can be positioned based on the position information after the report information is subsequently displayed to a user.
Specifically, when monitoring that the indexes to be selected (including the associated indexes of the indexes to be inquired) in the index library are quoted, the server records report information of a report which quotes the indexes to be selected; when a user needs to query the associated report information of the associated report to which a certain associated index of indexes to be queried belongs, clicking the associated index information of the associated index displayed on a screen of the user; correspondingly, after detecting that a user clicks the associated index information of a certain associated index, the user side generates an associated report inquiry request carrying the identification information of the associated index, and sends the associated report inquiry request to the server; the server receives and analyzes the associated report inquiry request sent by the user side to obtain the identification information of the associated index, obtains the associated report information of the associated report which refers to the associated index according to the identification information, and sends the associated report information to the user side; therefore, the user side displays the received associated report information to the user.
In order to further improve the accuracy of the relationship distance between the indexes in the index relationship map, preferably, the embodiment may further correct the distance between the index to be queried and each associated index in the index relationship map according to the click condition of the associated index information of the associated index of the index to be queried by each user. At this time, correspondingly, after the sending the relevant index information of the relevant index to the user side, the method may further include: and correcting the relation distance between the index to be inquired and the correlation index in the index relation map according to the click rate of the correlation index information. For example, a correspondence relationship between the click rate and the relationship distance may be set in advance, and when the click rate of a certain related index increases, the relationship distance between the relevant index and the index to be queried may be appropriately shortened according to the correspondence relationship, and when the click rate of a certain related index decreases, the relationship distance between the relevant index and the index to be queried may be appropriately increased according to the correspondence relationship. Wherein, the click rate can be the ratio of the number of times of clicking the associated index information by the user to the number of times of displaying the associated index information,
according to the method for determining the associated index provided by the embodiment of the invention, when a new index is stored in the index library, the index relation map is updated according to the access rule information, the attribute information and the index dimension information of the newly stored index, when an associated chart query request sent by a user side is received, the associated report information of the associated report which refers to the associated index is obtained and displayed to the user through the user side, so that the automatic discovery of the associated index can be realized, and the discovery of the data relation which is not easily perceived by a person can be assisted by the user; the method can also realize automatic construction and dynamic update of the index relation map, improve the accuracy of the determined associated index and the comprehensiveness of the information thereof, and reduce the difficulty of index management and use.
EXAMPLE III
The third embodiment of the invention provides a recommendation device for correlation indexes. The device can be realized by software and/or hardware, can be generally integrated in a server with a function of associated index query, is suitable for the conditions of associated query and retrieval, and can determine the associated index of the index to be queried by executing a method for determining the associated index. Fig. 3 is a block diagram of a structure of an apparatus for determining a correlation index according to a third embodiment of the present invention, as shown in fig. 3, the apparatus includes an information obtaining module 301, a distance determining module 302, and an index determining module 303, wherein,
the information acquisition module 301 is configured to acquire identification information of an index to be queried when a related index query request is received;
a distance determining module 302, configured to determine, according to the identification information and an index relation map of an index library, a relation distance between the index to be queried and each index to be selected in the index library;
and an index determining module 303, configured to determine a correlation index of the to-be-queried index according to the relationship distance.
In the device for determining the associated index provided by the third embodiment of the present invention, when the information obtaining module receives the associated index query request, the information obtaining module obtains the identification information of the index to be queried, the distance determining module determines the relationship distance between the index to be queried and each index to be selected in the index library according to the identification information and the index relationship map of the index library, and the index determining module determines the associated index of the index to be queried according to the relationship distance. By adopting the technical scheme, the index relation map containing the indexes of different services stored in the database is established for the index database, and the correlation index of the index to be inquired is determined according to the index relation map, so that the correlation index inquiry requirements of different services can be met, the fault existing among cross-service data relations is reduced, and the accuracy and the comprehensiveness of the correlation index inquiry result are improved.
Further, the apparatus for determining the correlation index may further include: and the map updating module is used for responding to the condition that the index to be inquired is stored in the index library and updating the index relation map of the index library before acquiring the identification information of the index to be inquired when the associated index inquiry request sent by the user side is received.
In the foregoing solution, the map updating module may include: the information acquisition unit is used for acquiring index information to be inquired of an index to be inquired, wherein the index information to be inquired comprises access rule information, attribute characteristic information and index dimension information; the distance determining unit is used for determining the relation distance between the index to be queried and each index to be selected in the index library according to the index information to be queried; and the information adding unit is used for adding the identification information of the index to be inquired into the index relation map of the index library according to the relation distance.
Further, the apparatus for determining the correlation index may further include: and the index feedback module is used for feeding back the associated index information of the associated index to the user side sending the associated index query request after determining the associated index of the index to be queried according to the relationship distance information so that the user side can display the associated index information.
Further, the apparatus for determining the correlation index may further include: a report obtaining module, configured to obtain associated report information referencing an associated report of the associated index when receiving an associated report query request sent by the user side after sending the associated index information of the associated index to the user side, and send the associated report information to the user side, so as to display the associated report information to the user through the user side, where the associated report query request is generated by the user side when the user clicks the associated index information.
Further, the apparatus for determining the correlation index may further include: and the distance correction module is used for correcting the relation distance between the index to be inquired and the correlation index in the index relation map according to the click rate of the correlation index information.
Further, the apparatus for determining the correlation index may further include: and the report recording module is used for recording the reference information of the indexes when monitoring that any index in the index library is referred, wherein the reference information comprises report information of a report which refers to the indexes.
The determination device for the correlation index provided by the third embodiment of the present invention is capable of executing the determination method for the correlation index provided by any embodiment of the present invention, and has a functional module and a beneficial effect corresponding to the execution of the determination method for the correlation index. For details of the technology that are not described in detail in this embodiment, reference may be made to a method for determining a correlation index provided in any embodiment of the present invention.
Example four
Fig. 4 is a schematic structural diagram of a server according to a fourth embodiment of the present invention, as shown in fig. 4, the server includes a processor 40 and a memory 41, and may further include an input device 42 and an output device 43; the number of the processors 40 in the server may be one or more, and one processor 40 is taken as an example in fig. 4; the processor 40, the memory 41, the input device 42 and the output device 43 in the server may be connected by a bus or other means, and the bus connection is exemplified in fig. 4.
The memory 41 serves as a computer-readable storage medium, and may be used to store software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the determination method of the correlation index in the embodiment of the present invention (for example, the information acquisition module 301, the distance determination module 302, and the index determination module 303 in the determination device of the correlation index). The processor 40 executes various functional applications of the server and data processing by executing software programs, instructions, and modules stored in the memory 41, that is, implements the above-described method for determining the correlation index.
The memory 41 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal, and the like. Further, the memory 41 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, memory 41 may further include memory located remotely from processor 40, which may be connected to a server over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 42 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the server. The output device 43 may include a display device such as a display screen.
An embodiment of the present invention further provides a storage medium containing computer-executable instructions, which when executed by a computer processor, perform a method for determining a correlation index, the method including:
when a related index query request is received, acquiring identification information of an index to be queried;
determining a relation distance between the index to be inquired and each index to be selected in the index library according to the identification information and the index relation map of the index library;
and determining the correlation index of the index to be queried according to the relationship distance.
Of course, the storage medium provided by the embodiment of the present invention includes computer-executable instructions, and the computer-executable instructions are not limited to the method operations described above, and may also perform related operations in the method for determining the correlation index provided by any embodiment of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
It should be noted that, in the embodiment of the apparatus for determining a correlation indicator, each included unit and each included module are only divided according to functional logic, but are not limited to the above division as long as the corresponding function can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims (10)

1. A method for determining a correlation index includes:
when a related index query request is received, acquiring identification information of an index to be queried;
determining a relation distance between the index to be inquired and each index to be selected in the index library according to the identification information and the index relation map of the index library;
and determining the correlation index of the index to be queried according to the relationship distance.
2. The method according to claim 1, wherein before acquiring the identification information of the metric to be queried when receiving the association metric query request sent by the user side, the method further comprises:
and in response to the condition that the index to be inquired is stored in an index library, updating the index relation map of the index library.
3. The method of claim 2, wherein updating the index relationship graph of the index library comprises:
acquiring index information to be inquired of an index to be inquired, wherein the index information to be inquired comprises access rule information, attribute characteristic information and index dimension information;
determining the relation distance between the index to be queried and each index to be selected in the index library according to the index information to be queried;
and adding the identification information of the index to be inquired into the index relation map of the index library according to the relation distance.
4. The method according to any one of claims 1 to 3, wherein after determining the correlation index of the index to be queried according to the relationship distance information, the method further comprises:
and feeding back the associated index information of the associated index to the user side sending the associated index query request so as to enable the user side to display the associated index information.
5. The method according to claim 4, wherein after the sending the associated index information of the associated index to the user terminal, further comprising:
when an associated report query request sent by the user side is received, acquiring associated report information of an associated report which refers to the associated index, and sending the associated report information to the user side so as to display the associated report information to the user through the user side, wherein the associated report query request is generated by the user side when the user clicks the associated index information.
6. The method of claim 5, further comprising:
and correcting the relation distance between the index to be inquired and the correlation index in the index relation map according to the click rate of the correlation index information.
7. The method of claim 5, further comprising:
when any index in the index library is monitored to be quoted, the quoted information of the index is recorded, and the quoted information comprises report information of a report which quotes the index.
8. An apparatus for determining a correlation index, comprising:
the information acquisition module is used for acquiring the identification information of the index to be inquired when the associated index inquiry request is received;
the distance determining module is used for determining the relationship distance between the index to be inquired and each index to be selected in the index library according to the identification information and the index relationship map of the index library;
and the index determining module is used for determining the associated index of the index to be inquired according to the relation distance.
9. A server, comprising:
one or more processors;
a memory for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement a method of determining a relevance metric as recited in any of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, which program, when being executed by a processor, is adapted to carry out the method of determining a relevance indicator as claimed in any one of claims 1 to 7.
CN201911275487.3A 2019-12-12 2019-12-12 Method and device for determining correlation index, server and storage medium Pending CN111026775A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911275487.3A CN111026775A (en) 2019-12-12 2019-12-12 Method and device for determining correlation index, server and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911275487.3A CN111026775A (en) 2019-12-12 2019-12-12 Method and device for determining correlation index, server and storage medium

Publications (1)

Publication Number Publication Date
CN111026775A true CN111026775A (en) 2020-04-17

Family

ID=70206413

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911275487.3A Pending CN111026775A (en) 2019-12-12 2019-12-12 Method and device for determining correlation index, server and storage medium

Country Status (1)

Country Link
CN (1) CN111026775A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111782691A (en) * 2020-05-13 2020-10-16 北京三快在线科技有限公司 Index relevance determination method and device, electronic equipment and storage medium
CN111880989A (en) * 2020-07-14 2020-11-03 中国银联股份有限公司 Configuration item management method and device
CN112445875A (en) * 2020-12-14 2021-03-05 招商局金融科技有限公司 Data association and inspection method and device, electronic equipment and storage medium
CN112463564A (en) * 2020-11-30 2021-03-09 中国工商银行股份有限公司 Method and device for determining correlation index influencing host state
CN113422796A (en) * 2021-05-06 2021-09-21 北京沃东天骏信息技术有限公司 Information processing method and device and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107609152A (en) * 2017-09-22 2018-01-19 百度在线网络技术(北京)有限公司 Method and apparatus for expanding query formula
WO2018107610A1 (en) * 2016-12-15 2018-06-21 平安科技(深圳)有限公司 Service data processing method, system and device, and computer-readable storage medium
CN109740034A (en) * 2018-12-20 2019-05-10 北京华夏电通科技有限公司 The case-involving information query method of enterprise and device based on graphic data base
CN109800335A (en) * 2019-01-23 2019-05-24 平安科技(深圳)有限公司 Generation method, device, computer equipment and the storage medium of enterprise's map

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2018107610A1 (en) * 2016-12-15 2018-06-21 平安科技(深圳)有限公司 Service data processing method, system and device, and computer-readable storage medium
CN107609152A (en) * 2017-09-22 2018-01-19 百度在线网络技术(北京)有限公司 Method and apparatus for expanding query formula
CN109740034A (en) * 2018-12-20 2019-05-10 北京华夏电通科技有限公司 The case-involving information query method of enterprise and device based on graphic data base
CN109800335A (en) * 2019-01-23 2019-05-24 平安科技(深圳)有限公司 Generation method, device, computer equipment and the storage medium of enterprise's map

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111782691A (en) * 2020-05-13 2020-10-16 北京三快在线科技有限公司 Index relevance determination method and device, electronic equipment and storage medium
CN111880989A (en) * 2020-07-14 2020-11-03 中国银联股份有限公司 Configuration item management method and device
CN111880989B (en) * 2020-07-14 2024-05-17 中国银联股份有限公司 Configuration item management method and device
CN112463564A (en) * 2020-11-30 2021-03-09 中国工商银行股份有限公司 Method and device for determining correlation index influencing host state
CN112463564B (en) * 2020-11-30 2024-03-05 中国工商银行股份有限公司 Method and device for determining associated index influencing host state
CN112445875A (en) * 2020-12-14 2021-03-05 招商局金融科技有限公司 Data association and inspection method and device, electronic equipment and storage medium
CN112445875B (en) * 2020-12-14 2024-03-01 招商局金融科技有限公司 Data association and verification method and device, electronic equipment and storage medium
CN113422796A (en) * 2021-05-06 2021-09-21 北京沃东天骏信息技术有限公司 Information processing method and device and storage medium

Similar Documents

Publication Publication Date Title
CN111026775A (en) Method and device for determining correlation index, server and storage medium
CN107784044B (en) Table data query method and device
CN109634698B (en) Menu display method and device, computer equipment and storage medium
US20160171978A1 (en) Voice recognition system and construction method thereof
CN110135590B (en) Information processing method, information processing apparatus, information processing medium, and electronic device
WO2018212790A1 (en) Estimated query performance
US20220318319A1 (en) Focus Events
CN112328688B (en) Data storage method, device, computer equipment and storage medium
CN111737564A (en) Information query method, device, equipment and medium
CN111045848B (en) Log analysis method, terminal device and computer readable storage medium
CN111047434B (en) Operation record generation method and device, computer equipment and storage medium
CN109885729B (en) Method, device and system for displaying data
CN116055551A (en) Information pushing method, device and system, electronic equipment and storage medium
CN111046082A (en) Data source determination method, device, server and storage medium
CN113111239B (en) General database operation method, device and storage medium thereof
CN114253995A (en) Data tracing method, device, equipment and computer readable storage medium
CN111026972B (en) Subscription data pushing method, device, equipment and storage medium in Internet of things
CN112836124A (en) Image data acquisition method and device, electronic equipment and storage medium
CN116955856A (en) Information display method, device, electronic equipment and storage medium
CN109684351B (en) Execution plan viewing method, device, server and storage medium
CN111797095A (en) Index construction method and JSON data query method
US20220284060A1 (en) Question Answering Method and Apparatus Based on Knowledge Graph
CN110716911B (en) Data processing method and device, electronic equipment and storage medium
CN116010347A (en) Resource updating method, device, system, electronic equipment and storage medium
CN116303571A (en) Data query method, device, 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