Data query method, device, apparatus and medium
By analyzing query intent through the intelligent interaction module and combining it with data recognition, progressive positioning, and access control modules, the cumbersome data querying and security risks in the BI system are solved, achieving efficient and accurate data querying and security control.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- NEW TREND INT LOGIS TECH
- Filing Date
- 2026-05-07
- Publication Date
- 2026-06-05
AI Technical Summary
Existing BI systems have cumbersome data query operations, making it difficult to quickly match user needs, resulting in low query accuracy and difficulty in achieving precise control, and posing a security risk of data leakage.
The system employs an intelligent interaction module to parse query intent, combined with a data recognition module, a progressive positioning module, and an access control module. Through filtering and verification strategies, it achieves efficient and accurate data querying while ensuring data security.
It enables simple and quick data retrieval, ensuring data security and improving query efficiency and accuracy.
Smart Images
Figure CN122152897A_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of data processing technology, and in particular to a data query method, apparatus, device, and medium. Background Technology
[0002] As enterprises deepen their digital transformation, Business Intelligence (BI) systems have become core tools for data analysis and decision support. These systems contain a large amount of data resources, including datasets, views, and dashboards, used to present various business data metrics. Currently, when users access BI data, they typically need to manually filter and locate target data from numerous dashboards and views. This process is cumbersome, inefficient, and makes it difficult to quickly match their data query needs. Furthermore, existing BI data access methods lack intelligent demand identification and location mechanisms, failing to automatically explore data levels based on user query intent, resulting in low query accuracy and potential data search bias. In addition, datasets in BI systems often contain sensitive corporate information, and current technologies lack granular data access control for users and roles, making precise management difficult and posing a security risk of data leakage.
[0003] Therefore, existing BI (Business Intelligence) systems suffer from cumbersome data querying, difficulty in quickly matching their own data query needs, low query accuracy, difficulty in achieving precise control, and security risks of data leakage, resulting in low query efficiency. Summary of the Invention
[0004] This invention provides a data query method, apparatus, device, and medium, aiming to solve the problems of cumbersome operation, difficulty in quickly matching one's own data query needs, low query accuracy, difficulty in achieving precise control, and security risks of data leakage in existing BI (Business Intelligence) system data query methods, resulting in low query efficiency.
[0005] To address the aforementioned problems, in a first aspect, embodiments of the present invention provide a data query method applied to a business intelligence system, the method comprising: When a query command is received from a user, the intelligent interaction module parses the query command to obtain the query intent and sends the user data obtained from the user to the data recognition module. The data recognition module obtains data resources from the connected data source, identifies the data resources based on the user data to obtain accessible data, and sends the accessible data to the intelligent interaction module. The intelligent interaction module sends the query intent and the accessible data to the progressive positioning module; The progressive positioning module filters the accessible data based on the filtering strategy and the query intent to obtain filtering results, and sends the filtering results to the intelligent interaction module. The intelligent interaction module sends the filtering results and the user data to the access control module; The access control module verifies the filtering results based on the verification strategy and the user data to obtain the query results, and then sends the query results to the intelligent interaction module. The intelligent interaction module integrates and processes the query intent and the query results to obtain query data, and then sends the query data to the user terminal.
[0006] Secondly, embodiments of this application provide a data query device applied to a business intelligence system, the device comprising: The intelligent interaction module is used to parse the query instruction sent by the user terminal to obtain the query intent when it receives the query instruction sent by the user terminal, and send the obtained user data from the user terminal to the data recognition module. The data identification module is used to obtain data resources from the connected data source, identify the data resources according to the user data to obtain accessible data, and send the accessible data to the intelligent interaction module. The intelligent interaction module is also used to send the query intent and the accessible data to the progressive positioning module; The progressive positioning module is used to filter the accessible data based on the filtering strategy and the query intent to obtain filtering results, and send the filtering results to the intelligent interaction module. The intelligent interaction module is also used to send the filtering results and the user data to the permission control module; The access control module is used to verify the filtering results based on the verification strategy and the user data to obtain query results, and send the query results to the intelligent interaction module. The intelligent interaction module is also used to integrate the query intent and the query result to obtain query data, and send the query data to the user terminal.
[0007] Thirdly, embodiments of this application provide a computer device, the computer device including a memory and a processor connected to the memory; the memory is used to store a computer program, and the processor is used to run the computer program stored in the memory to perform the method described in the first aspect above.
[0008] Fourthly, embodiments of this application provide a storage medium storing a computer program, the computer program including program instructions, which, when executed by a processor, implement the method described in the first aspect above.
[0009] This invention provides a data query method, apparatus, device, and medium applied to a business intelligence system. The method includes: when a query command is received from a user terminal, an intelligent interaction module parses the query command to obtain a query intent and sends the acquired user data from the user terminal to a data identification module; the data identification module obtains data resources from a connected data source, identifies the data resources based on the user data to obtain accessible data, and sends the accessible data to the intelligent interaction module; the intelligent interaction module sends the query intent and the accessible data to a progressive positioning module; the progressive positioning module filters the accessible data based on a filtering strategy and the query intent to obtain a filtering result, and sends the filtering result to the intelligent interaction module; the intelligent interaction module sends the filtering result and the user data to an access control module; the access control module verifies the filtering result based on a verification strategy and the user data to obtain a query result, and sends the query result to the intelligent interaction module; the intelligent interaction module integrates the query intent and the query result to obtain query data, and sends the query data to the user terminal. Therefore, this embodiment of the invention allows users to input query commands into the intelligent interaction module, which then controls the data recognition module, the progressive positioning module, and the permission control module to output query data to the user. This method is simple to operate, quickly meets query needs, and provides high accuracy, achieving precise control while ensuring data security, thereby improving query efficiency. Attached Figure Description
[0010] To more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the following description of the embodiments will be briefly introduced. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.
[0011] Figure 1 A flowchart illustrating the data query method provided in an embodiment of the present invention; Figure 2 A schematic block diagram of a data query device provided in an embodiment of the present invention; Figure 3 A schematic block diagram of a computer device provided for an embodiment of the present invention. Detailed Implementation
[0012] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.
[0013] It should be understood that, when used in this specification and the appended claims, the terms "comprising" and "including" indicate the presence of the described features, integrals, steps, operations, elements and / or components, but do not exclude the presence or addition of one or more other features, integrals, steps, operations, elements, components and / or collections thereof.
[0014] It should also be understood that the terminology used in this specification is for the purpose of describing particular embodiments only and is not intended to limit the invention. As used in this specification and the appended claims, the singular forms “a,” “an,” and “the” are intended to include the plural forms unless the context clearly indicates otherwise.
[0015] It should also be further understood that the term "and / or" as used in this specification and the appended claims refers to any combination of one or more of the associated listed items and all possible combinations, and includes such combinations.
[0016] It should be noted that if any AI models, software tools, or components not belonging to the applicant appear in the embodiments of this application, they are merely illustrative examples and do not represent actual use. The user personal information involved in the embodiments of this application is obtained by an entity authorized (knowing and consenting) by the relevant parties or fully authorized by all parties through various legal and compliant means. The collection, storage, use, processing, transmission, provision, and disclosure of the information, data, and signals involved all comply with relevant laws and regulations and do not violate public order and good morals.
[0017] Please see Figure 1 , Figure 1 This is a flowchart illustrating the data query method provided in an embodiment of the present invention. Figure 1 As shown, this embodiment of the invention provides a data query method applied to a business intelligence system, which mainly includes an intelligent interaction module, a data recognition module, a progressive positioning module, and an access control module. The intelligent interaction module is communicatively connected to the data recognition module, the progressive positioning module, and the access control module. As the core control module of the system, the intelligent interaction module realizes unified scheduling, is responsible for receiving user queries, coordinating the collaborative work of various modules, and outputting the final result.
[0018] The method includes the following steps S110-S170.
[0019] S110. When a query instruction is received from the user terminal, the intelligent interaction module parses the query instruction to obtain the query intent and sends the obtained user data from the user terminal to the data recognition module.
[0020] In this embodiment, the query instruction is sent by the user terminal. For example, the query instruction could be "view the transaction data of the customers I'm following up with this month," "view the core data indicators corresponding to the monthly revenue dashboard of a sales department in a certain region," or "view the views and datasets related to customer conversion rates." The query instruction can include one or more of the following: data indicator query, view viewing, and dashboard viewing. After receiving the query instruction, the intelligent interaction module parses the query instruction to obtain the query intent. Simultaneously, it acquires the user data from the user terminal and sends the user data to the data recognition module. The user data can include user identifiers, identity data, role data, etc.
[0021] The intelligent interaction module parses the query command to obtain the query intent. Specifically, the intelligent interaction module uses a large language model as the core engine and combines it with natural language processing (NLP) technology to perform semantic understanding and intent parsing on the query command to obtain the query intent.
[0022] S120. The data identification module obtains data resources from the connected data source, identifies the data resources according to the user data to obtain accessible data, and sends the accessible data to the intelligent interaction module.
[0023] In this embodiment, after receiving the user data, the data identification module can obtain data resources from the connected data source, identify the data resources based on the user data to obtain accessible data, and send the accessible data to the intelligent interaction module. Here, the data source refers to the data source corresponding to the business intelligence system.
[0024] The data identification module obtains data resources from the connected data source, and identifies the data resources based on the user data to obtain accessible data. Specifically, the user identifier in the user data is used as a query condition to search and identify the accessible data in the data resources.
[0025] S130, the intelligent interaction module sends the query intent and the accessible data to the progressive positioning module.
[0026] In this embodiment, after obtaining the query intent and the accessible data, the intelligent interaction module can send the query intent and the accessible data to the progressive positioning module.
[0027] S140. The progressive positioning module filters the accessible data based on the filtering strategy and the query intent to obtain the filtering results, and sends the filtering results to the intelligent interaction module.
[0028] In this embodiment, after receiving the query intent and the accessible data, the progressive positioning module can filter the accessible data based on the filtering strategy and the query intent to obtain filtering results, and send the filtering results to the intelligent interaction module.
[0029] In one embodiment, the progressive positioning module filters the accessible data based on a filtering strategy and the query intent to obtain filtering results, including: The keyword set is obtained by locating the query intent; The user dashboard is obtained by matching the accessible data with the keyword set. Obtain the user view corresponding to the user dashboard, and filter the user view using the keyword set to obtain the target view; The target view is determined to obtain the corresponding filtered dataset; The filtered dataset is used as the filtering result.
[0030] In this embodiment, the process of locating the query intent to obtain a keyword set specifically involves dividing the query intent into several words using a segmentation rule. Each of these words is then used in a pre-defined thesaurus to generate a query result. If the query result is empty, the corresponding word is deleted; if the query result is not empty, the corresponding word is used as a keyword. These several keywords form the keyword set. The segmentation rule is based on the query object, limiting conditions, etc. The query object refers to the main body of the queried data, and the limiting conditions include time, location, etc.
[0031] The user dashboard is obtained by matching the accessible data based on the keyword set. Specifically, the keyword set is used as a matching condition in the dashboard data of the accessible data to obtain the user dashboard. The accessible data includes dashboard data, view data, and datasets; one dashboard data is bound to multiple view data, and one view data is bound to one dataset.
[0032] The process involves obtaining the user view corresponding to the user dashboard and filtering the user view using the keyword set to obtain the target view. Specifically, the user view corresponding to the user dashboard is obtained from the view data in the accessible data, and the target view is obtained by filtering using the keyword set as a filtering condition.
[0033] The step involves determining the target view to obtain the corresponding filter dataset, and then using the filter dataset as the filter result. Specifically, the step involves obtaining the corresponding bound dataset data from the target view as the filter dataset, and then using the filter dataset as the filter result.
[0034] S150, The intelligent interaction module sends the filtering results and the user data to the permission control module.
[0035] In this embodiment, after determining the filtering results and the user data, the intelligent interaction module sends the filtering results and the user data to the permission control module.
[0036] S160. The permission control module verifies the filtering results based on the verification strategy and the user data to obtain the query results, and sends the query results to the intelligent interaction module.
[0037] In this embodiment, after receiving the filtering results and the user data, the permission control module performs verification processing on the filtering results based on the verification strategy and the user data to obtain the query results, and sends the query results to the intelligent interaction module.
[0038] In one embodiment, the access control module verifies the filtering results based on the verification strategy and the user data to obtain query results, including: Within a pre-defined access control set, obtain the user permissions corresponding to the user data; The row-level and column-level filtering conditions are obtained using the user permissions. The filtering results are filtered according to the row-level filtering conditions to obtain filtered data; The query results are obtained by validating the filtered data according to the column-level filtering conditions.
[0039] In this embodiment, the user permissions corresponding to the user data are obtained from a preset permission control set. The user permissions are then used to obtain row-level and column-level filtering conditions. Specifically, the permission control set is a user and role permission configuration table, where row-level permissions are implemented through the association between user identifiers (IDs), role identifiers, and dataset records. From the permission control set, the corresponding user permissions are obtained using the user identifiers and role data in the user data. The user permissions are then decomposed to obtain the row-level and column-level filtering conditions.
[0040] The process involves filtering the filtering results according to the row-level filtering conditions to obtain filtered data; and then validating the filtered data according to the column-level filtering conditions to obtain the query results. Specifically, firstly, the filtering results are filtered according to the row-level filtering conditions to obtain filtered data. For example, a sales specialist can only view the customer data they are following up with (row-level filtering condition: "user_id=current user ID"), while a department manager can view all sales data for their department (row-level filtering condition: "dept_id=current department ID"). Secondly, the filtered data is validated according to the column-level filtering conditions to obtain the query results. For example, the column-level filtering conditions are implemented by configuring the dataset fields that users and roles can view. For instance, ordinary employees cannot view sensitive fields such as "customer contact information" and "transaction price" in the dataset, while administrators can view all fields. During the user query process, the permission control module automatically concatenates the row-level and column-level filtering conditions based on the user's identity and role.
[0041] In one embodiment, before the data identification module obtains data resources from the connected data source, it further includes: Obtain the model context protocol and use the model context protocol to connect the data recognition module with the data source.
[0042] In this embodiment, the data recognition module is interactively connected to the data source by obtaining the Model Context Protocol (MCP) to obtain the data resources from the data source. With the openness and standardized interface capabilities of the MCP protocol, a standardized interactive connection between the data recognition module and the BI data source is realized, which can flexibly adapt to BI systems with different architectures, reduce the complexity of system integration, and adapt to the diverse deployment needs of enterprises.
[0043] S170. The intelligent interaction module integrates the query intent and the query result to obtain query data, and sends the query data to the user terminal.
[0044] In this embodiment, the query intent and the query results are integrated to obtain query data in tabular form. For example, the data such as the monthly transaction amount and number of transactions of the customer followed up by the sales specialist are presented in tabular form, and the data source and permission description are marked in natural language.
[0045] In summary, this embodiment of the invention discloses that when a query command is received from a user terminal, the intelligent interaction module parses the query command to obtain the query intent and sends the acquired user data from the user terminal to a data identification module; the data identification module obtains data resources from a connected data source, identifies the data resources based on the user data to obtain accessible data, and sends the accessible data to the intelligent interaction module; the intelligent interaction module sends the query intent and the accessible data to a progressive positioning module; the progressive positioning module filters the accessible data based on a filtering strategy and the query intent to obtain a filtering result, and sends the filtering result to the intelligent interaction module; the intelligent interaction module sends the filtering result and the user data to a permission control module; the permission control module verifies the filtering result based on a verification strategy and the user data to obtain a query result, and sends the query result to the intelligent interaction module; the intelligent interaction module integrates the query intent and the query result to obtain query data, and sends the query data to the user terminal. As can be seen, the embodiments of the present invention input query commands into the intelligent interaction module, and the intelligent interaction module controls the data recognition module, the progressive positioning module, and the permission control module to complete the output of query data to the user terminal. The operation is simple, fast, and meets query needs with high accuracy, achieving precise control and ensuring data security, thereby improving query efficiency.
[0046] Figure 2 This is a schematic block diagram of a data query device provided in an embodiment of the present invention. Figure 2 As shown, this embodiment of the invention provides a data query device 700 that implements the method described above, applied to a business intelligence system. The business intelligence system refers to a BI system, which mainly includes an intelligent interaction module, a data recognition module, a progressive positioning module, and an access control module. The intelligent interaction module is connected to the data recognition module, the progressive positioning module, and the access control module. The intelligent interaction module acts as the core brain of the system, which coordinates and manages the system, receives user queries, coordinates the collaborative work of various modules, and outputs the final results.
[0047] Please see Figure 2 The data query device 700 includes: The intelligent interaction module 701 is used to parse the query instruction sent by the user terminal to obtain the query intent when it receives the query instruction sent by the user terminal, and send the obtained user data from the user terminal to the data recognition module. The data identification module 702 is used to obtain data resources from the connected data source, identify the data resources according to the user data to obtain accessible data, and send the accessible data to the intelligent interaction module. The intelligent interaction module 701 is also used to send the query intent and the accessible data to the progressive positioning module; The progressive positioning module 703 is used to filter the accessible data based on the filtering strategy and the query intent to obtain the filtering results, and send the filtering results to the intelligent interaction module. The intelligent interaction module 701 is also used to send the filtering results and the user data to the permission control module; The access control module 704 is used to verify the filtering results based on the verification strategy and the user data to obtain query results, and send the query results to the intelligent interaction module. The intelligent interaction module 701 is also used to integrate the query intent and the query result to obtain query data, and send the query data to the user terminal.
[0048] In some embodiments, the progressive positioning module 703 filters the accessible data based on a filtering strategy and the query intent to obtain filtering results, including: The keyword set is obtained by locating the query intent; The user dashboard is obtained by matching the accessible data with the keyword set. Obtain the user view corresponding to the user dashboard, and filter the user view using the keyword set to obtain the target view; The target view is determined to obtain the corresponding filtered dataset; The filtered dataset is used as the filtering result.
[0049] In some embodiments, the access control module 704 performs verification processing on the filtering results based on the verification strategy and the user data to obtain query results, including: Within a pre-defined access control set, obtain the user permissions corresponding to the user data; The row-level and column-level filtering conditions are obtained using the user permissions. The filtering results are filtered according to the row-level filtering conditions to obtain filtered data; The query results are obtained by validating the filtered data according to the column-level filtering conditions.
[0050] In some embodiments, before the data identification module 702 obtains data resources from the connected data source, it further includes: Obtain the model context protocol and use the model context protocol to connect the data recognition module with the data source.
[0051] It should be noted that those skilled in the art can clearly understand that the specific implementation process of the above-mentioned device can be referred to the corresponding description in the foregoing method embodiments. For the sake of convenience and brevity, it will not be repeated here.
[0052] The above-described device can be implemented as a computer program, and the computer program can be implemented in, for example... Figure 3 It runs on the computer device shown.
[0053] Please see Figure 3 , Figure 3 This is a schematic block diagram of an electronic device provided in an embodiment of the present invention. The electronic device 800 can be a terminal or a server. The terminal can be an electronic device with communication functions. The server can be a standalone server or a server cluster composed of multiple servers.
[0054] See Figure 3 The electronic device 800 includes a processor 802, a memory, and a network interface 805 connected via a system bus 801. The memory may include a non-volatile storage medium 803 and internal memory 804.
[0055] The non-volatile storage medium 803 may store an operating system 8031 and a computer program 8032. The computer program 8032 includes program instructions that, when executed, cause the processor 802 to perform a data query method.
[0056] The processor 802 provides computing and control capabilities to support the operation of the entire electronic device 800.
[0057] The internal memory 804 provides an environment for the execution of the computer program 8032 in the non-volatile storage medium 803. When the computer program 8032 is executed by the processor 802, the processor 802 can execute a data query method.
[0058] This network interface 805 is used for network communication with other devices. Those skilled in the art will understand that... Figure 3The structure shown is merely a block diagram of a portion of the structure related to the present invention and does not constitute a limitation on the electronic device 800 to which the present invention is applied. The specific electronic device 800 may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.
[0059] The processor 802 is used to run a computer program 8032 stored in the memory to perform the following steps: When a query command is received from a user, the intelligent interaction module parses the query command to obtain the query intent and sends the user data obtained from the user to the data recognition module. The data recognition module obtains data resources from the connected data source, identifies the data resources based on the user data to obtain accessible data, and sends the accessible data to the intelligent interaction module. The intelligent interaction module sends the query intent and the accessible data to the progressive positioning module; The progressive positioning module filters the accessible data based on the filtering strategy and the query intent to obtain filtering results, and sends the filtering results to the intelligent interaction module. The intelligent interaction module sends the filtering results and the user data to the access control module; The access control module verifies the filtering results based on the verification strategy and the user data to obtain the query results, and then sends the query results to the intelligent interaction module. The intelligent interaction module integrates and processes the query intent and the query results to obtain query data, and then sends the query data to the user terminal.
[0060] It should be understood that, in this embodiment of the invention, the processor 802 may be a Central Processing Unit (CPU), or it may be other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor.
[0061] It will be understood by those skilled in the art that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program includes program instructions and can be stored in a storage medium, which is a computer-readable storage medium. The program instructions are executed by at least one processor in the computer system to implement the process steps of the embodiments of the above methods.
[0062] Therefore, the present invention also provides a storage medium. This storage medium can be a computer-readable storage medium. The storage medium stores a computer program, wherein the computer program includes program instructions. When executed by a processor, the program instructions cause the processor to perform the following steps: When a query command is received from a user, the intelligent interaction module parses the query command to obtain the query intent and sends the user data obtained from the user to the data recognition module. The data recognition module obtains data resources from the connected data source, identifies the data resources based on the user data to obtain accessible data, and sends the accessible data to the intelligent interaction module. The intelligent interaction module sends the query intent and the accessible data to the progressive positioning module; The progressive positioning module filters the accessible data based on the filtering strategy and the query intent to obtain filtering results, and sends the filtering results to the intelligent interaction module. The intelligent interaction module sends the filtering results and the user data to the access control module; The access control module verifies the filtering results based on the verification strategy and the user data to obtain the query results, and then sends the query results to the intelligent interaction module. The intelligent interaction module integrates and processes the query intent and the query results to obtain query data, and then sends the query data to the user terminal.
[0063] The storage medium can be any computer-readable storage medium capable of storing program code, such as a USB flash drive, portable hard drive, read-only memory (ROM), magnetic disk, or optical disk.
[0064] Those skilled in the art will recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of both. To clearly illustrate the interchangeability of hardware and software, the components and steps of the various examples have been generally described in terms of functionality in the foregoing description. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementations should not be considered beyond the scope of this invention.
[0065] In the several embodiments provided by this invention, it should be understood that the disclosed apparatus and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative. For example, the division of each unit is merely a logical functional division, and there may be other division methods in actual implementation. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed.
[0066] The steps in the method of this invention can be adjusted, merged, or reduced in order according to actual needs. The units in the device of this invention can be merged, divided, or reduced according to actual needs. Furthermore, the functional units in the various embodiments of this invention can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit.
[0067] If the integrated unit is implemented as a software functional unit and sold or used as an independent product, it can be stored in a storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause an electronic device (which may be a personal computer, a terminal, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention.
[0068] The above description is merely a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any person skilled in the art can easily conceive of various equivalent modifications or substitutions within the technical scope disclosed in the present invention, and these modifications or substitutions should all be covered within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.
Claims
1. A data query method, characterized in that, Applied to business intelligence systems, the method includes: When a query command is received from a user, the intelligent interaction module parses the query command to obtain the query intent and sends the user data obtained from the user to the data recognition module. The data recognition module obtains data resources from the connected data source, identifies the data resources based on the user data to obtain accessible data, and sends the accessible data to the intelligent interaction module. The intelligent interaction module sends the query intent and the accessible data to the progressive positioning module; The progressive positioning module filters the accessible data based on the filtering strategy and the query intent to obtain filtering results, and sends the filtering results to the intelligent interaction module. The intelligent interaction module sends the filtering results and the user data to the access control module; The access control module verifies the filtering results based on the verification strategy and the user data to obtain the query results, and then sends the query results to the intelligent interaction module. The intelligent interaction module integrates and processes the query intent and the query results to obtain query data, and then sends the query data to the user terminal.
2. The method according to claim 1, characterized in that, The progressive positioning module filters the accessible data based on the filtering strategy and the query intent to obtain filtering results, including: The keyword set is obtained by locating the query intent; The user dashboard is obtained by matching the accessible data with the keyword set. Obtain the user view corresponding to the user dashboard, and filter the user view using the keyword set to obtain the target view; The target view is determined to obtain the corresponding filtered dataset; The filtered dataset is used as the filtering result.
3. The method according to claim 1, characterized in that, The access control module verifies the filtering results based on the verification strategy and the user data to obtain query results, including: Within a pre-defined access control set, obtain the user permissions corresponding to the user data; The row-level and column-level filtering conditions are obtained using the user permissions. The filtering results are filtered according to the row-level filtering conditions to obtain filtered data; The query results are obtained by validating the filtered data according to the column-level filtering conditions.
4. The method according to claim 1, characterized in that, Before the data recognition module obtains data resources from the connected data source, it also includes: Obtain the model context protocol and use the model context protocol to connect the data recognition module with the data source.
5. A data query device, characterized in that, The device, used in a business intelligence system, includes: The intelligent interaction module is used to parse the query instruction sent by the user terminal to obtain the query intent when it receives the query instruction sent by the user terminal, and send the obtained user data from the user terminal to the data recognition module. The data identification module is used to obtain data resources from the connected data source, identify the data resources according to the user data to obtain accessible data, and send the accessible data to the intelligent interaction module. The intelligent interaction module is also used to send the query intent and the accessible data to the progressive positioning module; The progressive positioning module is used to filter the accessible data based on the filtering strategy and the query intent to obtain filtering results, and send the filtering results to the intelligent interaction module. The intelligent interaction module is also used to send the filtering results and the user data to the access control module; The access control module is used to verify the filtering results based on the verification strategy and the user data to obtain query results, and send the query results to the intelligent interaction module. The intelligent interaction module is also used to integrate the query intent and the query result to obtain query data, and send the query data to the user terminal.
6. The apparatus according to claim 5, characterized in that, The process of filtering the accessible data based on the filtering strategy and the query intent to obtain the filtering results includes: The keyword set is obtained by locating the query intent; The user dashboard is obtained by matching the accessible data with the keyword set. Obtain the user view corresponding to the user dashboard, and filter the user view using the keyword set to obtain the target view; The target view is determined to obtain the corresponding filtered dataset; The filtered dataset is used as the filtering result.
7. The apparatus according to claim 5, characterized in that, The process of validating the filtering results based on the validation strategy and the user data to obtain the query results includes: Within a pre-defined access control set, obtain the user permissions corresponding to the user data; The row-level and column-level filtering conditions are obtained using the user permissions. The filtering results are filtered according to the row-level filtering conditions to obtain filtered data; The query results are obtained by validating the filtered data according to the column-level filtering conditions.
8. The apparatus according to claim 5, characterized in that, Before obtaining data resources from the connected data source, the process also includes: Obtain the model context protocol and use the model context protocol to connect the data recognition module with the data source.
9. A computer device, characterized in that, The computer device includes a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the method as described in any one of claims 1-4.
10. A storage medium, characterized in that, The storage medium stores a computer program, which includes program instructions that, when executed by a processor, can implement the method as described in any one of claims 1-4.