Data query method and device, storage medium and electronic device

Abstract

The application discloses a data query method and device, a storage medium and an electronic device, relates to the technical field of smart homes, and comprises the following steps: performing metadata analysis on first data in a data warehouse, and determining metadata information of the first data according to a result of the metadata analysis; adding different types of metadata carried by the first data to a retrieval database based on the metadata information; in the case that a positioning condition corresponding to to-be-queried data is acquired from the retrieval database, determining target metadata matched with the positioning condition from the retrieval database, so as to confirm a data query result fed back to a use object according to the target metadata. By adopting the technical solution, the problems that data cannot be quickly found and fed back to a use object in the related art are solved.

Description

Technical Field

[0001] This application relates to the field of smart home technology, and more specifically, to a data query method and apparatus, a storage medium and an electronic device. Background Technology

[0002] In related technologies, as enterprises accelerate their internal digital transformation, data grows rapidly, but this also brings various data usage problems. In related technologies, data retrieval through data fields requires querying a large amount of data, which leads to low data search efficiency.

[0003] Regarding the issues in related technologies, such as the inability to quickly find data and provide feedback to users, existing technologies do not offer good solutions for the above scenarios. Summary of the Invention

[0004] This invention provides a data query method and apparatus, storage medium and electronic device to at least solve the problems in related technologies such as the inability to quickly find data and provide feedback to users.

[0005] According to one aspect of the present invention, a data query method is provided, comprising: performing metadata analysis on first data in a data warehouse, and determining metadata information of the first data based on the result of the metadata analysis; adding different types of metadata carried by the first data to a retrieval database based on the metadata information; and, when the retrieval database obtains a location condition corresponding to the data to be queried, determining target metadata matching the location condition from the retrieval database, so as to confirm the data query result to be fed back to the user based on the target metadata.

[0006] In an optional embodiment, before the retrieval database obtains the location conditions corresponding to the data to be queried, the method further includes: determining the permission information of the user accessing the retrieval database; if the permission information indicates that the user has the required permissions, receiving the data request input by the user according to preset prompt information; and determining the data location conditions for performing metadata query based on the data request.

[0007] In an optional embodiment, the method further includes: initiating a permission application process for the retrieval database when the permission information indicates that the user does not have the required permissions; and sending the identity information of the user who wants to use the retrieval database and the target permission information to be applied for to the retrieval database.

[0008] In an optional embodiment, after adding different types of metadata carried by the first data to the retrieval database based on the metadata information, the above method further includes: determining multiple data types of the metadata corresponding to the first data; dividing the metadata corresponding to the first data based on the data type, and determining the data graph corresponding to each data type; and storing the multiple data graphs corresponding to the multiple data types in a graph database that assists the retrieval database.

[0009] In an optional embodiment, after determining the target metadata that matches the positioning conditions from the retrieval database, the above method further includes: filling the target metadata into a preset asset map template to obtain a target asset map; and sending the determined target asset map to a display interface associated with the retrieval database.

[0010] In an optional embodiment, after determining that the target asset map is sent to the display interface associated with the retrieval database, the method further includes: detecting the operation data of the user on the display interface; and displaying the data asset acquisition progress on the target asset map based on the operation data.

[0011] In an optional embodiment, after determining the target metadata matching the positioning conditions from the retrieval database, the method further includes: obtaining feedback information from the user regarding the target metadata; if the feedback information indicates that the target metadata is invalid data, sending an update instruction to the retrieval database, wherein the update instruction is used to perform data updates on different types of metadata in the retrieval database; if the feedback information indicates that the target metadata is valid data, sending an inquiry message to the user, wherein the inquiry message is used to inquire whether the user wants to end the current data acquisition process.

[0012] According to another aspect of the present invention, a data query apparatus is also provided, comprising: a determining module, configured to perform metadata analysis on first data in a data warehouse and determine metadata information of the first data based on the result of the metadata analysis; an adding module, configured to add different types of metadata carried by the first data to a retrieval database based on the metadata information; and a matching module, configured to, when the retrieval database obtains a location condition corresponding to the data to be queried, determine target metadata matching the location condition from the retrieval database, so as to confirm the data query result to be fed back to the user based on the target metadata.

[0013] In an optional embodiment, the above apparatus further includes: a permission module, configured to determine permission information of a user object accessing the retrieval database; when the permission information indicates that the user object has the required permissions, receive data requests input by the user object according to preset prompt information; and determine data location conditions for performing metadata queries based on the data requests.

[0014] In an optional embodiment, the above-mentioned condition module further includes: an application unit, configured to initiate the permission application process for the retrieval database when the permission information indicates that the user does not have the required permission; and send the identity information of the user to be used in the retrieval database and the target permission information to be applied for to the retrieval database.

[0015] In an optional embodiment, the above apparatus further includes: a partitioning module, configured to determine multiple data types of metadata corresponding to the first data; partition the metadata corresponding to the first data based on the data types, and determine a data graph corresponding to each data type; and store the multiple data graphs corresponding to the multiple data types in a graph database that assists the retrieval database.

[0016] In an optional embodiment, the above apparatus further includes: a filling module, configured to fill the target metadata into a preset asset map template to obtain a target asset map; and to send the determined target asset map to a display interface associated with the retrieval database.

[0017] In an optional embodiment, the above-mentioned filling module further includes: a detection unit, configured to detect the operation data of the user on the display interface; and display the acquisition progress of the data asset on the target asset map based on the operation data.

[0018] In an optional embodiment, the above apparatus further includes: a feedback module, configured to acquire feedback information from the user regarding the target metadata; if the feedback information indicates that the target metadata is invalid data, send an update instruction to the retrieval database, wherein the update instruction is used to perform data updates on different types of metadata in the retrieval database; if the feedback information indicates that the target metadata is valid data, send an inquiry message to the user, wherein the inquiry message is used to inquire whether the user should end the current data acquisition process.

[0019] According to another aspect of the present invention, a computer-readable storage medium is also provided, wherein a computer program is stored in the computer program, which is configured to execute the above-described data query method at runtime.

[0020] According to another aspect of the present invention, an electronic device is also provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the data query method described above through the computer program.

[0021] This invention performs metadata analysis on the first data in a data warehouse and determines the metadata information of the first data based on the results of the metadata analysis. Based on the metadata information, different types of metadata carried by the first data are added to a retrieval database. When the retrieval database obtains the location conditions corresponding to the data to be queried, the target metadata matching the location conditions is determined from the retrieval database. The data query results are then confirmed and fed back to the user based on the target metadata. This technical solution solves the problems in related technologies, such as the inability to quickly find data and provide feedback to the user. Furthermore, it enables the processing of data in the data warehouse into data that can be quickly searched and fed back to the user, helping users better understand the meaning of the data, quickly locate the data they want to query, accurately guide which data is more reliable and usable, and conveniently use tools for data analysis. Attached Figure Description

[0022] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application.

[0023] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, for those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0024] Figure 1 This is a schematic diagram of the hardware environment for an optional data query method according to an embodiment of this application;

[0025] Figure 2 This is a flowchart of an optional data query method according to an embodiment of this application;

[0026] Figure 3 This is a schematic diagram of the architecture of an optional data asset mapping system according to an embodiment of this application;

[0027] Figure 4 This is a schematic diagram from the perspective of a business personnel corresponding to an optional data asset map system according to an embodiment of this application;

[0028] Figure 5 This is a schematic diagram from the perspective of an asset map developer for an optional data asset map system according to an embodiment of this application;

[0029] Figure 6 This is a structural block diagram of an optional data query device according to an embodiment of the present invention. Detailed Implementation

[0030] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present application, and not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present application.

[0031] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this application are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of this application described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0032] According to one aspect of the embodiments of this application, a data query method is provided. This data query method is widely applicable to whole-house intelligent digital control application scenarios such as smart homes, smart home ecosystems, and intelligencehouse ecosystems. Optionally, in this embodiment, the above-mentioned data query method can be applied to, for example... Figure 1 The hardware environment shown consists of multiple terminal devices 102 and a server 104. For example... Figure 1 As shown, server 104 is connected to multiple terminal devices 102 via a network and can be used to provide services (such as application services) to terminals or clients installed on terminals. A database can be set up on the server or independently of the server to provide data storage services for server 104. Cloud computing and / or edge computing services can be configured on the server or independently of the server to provide data processing services for server 104.

[0033] The aforementioned network may include, but is not limited to, at least one of the following: wired network, wireless network. The aforementioned wired network may include, but is not limited to, at least one of the following: wide area network, metropolitan area network, local area network. The aforementioned wireless network may include, but is not limited to, at least one of the following: Wi-Fi (Wireless Fidelity), Bluetooth. The terminal device 102 may not be limited to PC, mobile phone, tablet computer, smart air conditioner, smart range hood, smart refrigerator, smart oven, smart stove, smart washing machine, smart water heater, smart washing equipment, smart dishwasher, smart projector, smart TV, smart clothes rack, smart curtains, smart audio-visual equipment, smart socket, smart speaker, smart speaker box, smart fresh air equipment, smart kitchen and bathroom equipment, smart bathroom equipment, smart robot vacuum cleaner, smart window cleaning robot, smart mopping robot, smart air purifier, smart steam oven, smart microwave oven, smart water heater, smart air purifier, smart water dispenser, smart door lock, etc.

[0034] This embodiment provides a data query method, including but not limited to those applied to cloud servers. Figure 2 This is a flowchart of a data query method according to an embodiment of the present invention, which includes the following steps:

[0035] Step S202: Perform metadata analysis on the first data in the data warehouse, and determine the metadata information of the first data based on the results of the metadata analysis;

[0036] It should be noted that the first data mentioned above is the raw data stored in the data warehouse. This raw data needs to be transformed and analyzed to become metadata information, such as technical metadata and business metadata. The technical metadata mentioned above stores data about the technical details of the data warehouse system, while the business metadata mentioned above describes the data in the data warehouse from a business perspective. In essence, it provides a semantic layer between users and the actual system, enabling business personnel who do not understand computer technology to "understand" the data in the data warehouse.

[0037] Step S204: Based on the metadata information, add the different types of metadata carried by the first data to the retrieval database;

[0038] Optionally, the aforementioned retrieval database is a data set formed by converting the entire content of a complete information source into information units that can be recognized and processed by a computer. It is generally used for the rapid retrieval of massive amounts of data. Therefore, storing the business metadata and technical metadata corresponding to the metadata information in the database can facilitate quick retrieval.

[0039] Step S206: If the location conditions corresponding to the data to be queried are obtained from the retrieval database, the target metadata matching the location conditions is determined from the retrieval database, so as to confirm the data query result to be fed back to the user based on the target metadata.

[0040] This invention performs metadata analysis on the first data in a data warehouse and determines the metadata information of the first data based on the results of the metadata analysis. Based on the metadata information, different types of metadata carried by the first data are added to a retrieval database. When the retrieval database obtains the location conditions corresponding to the data to be queried, the target metadata matching the location conditions is determined from the retrieval database. The data query results are then confirmed and fed back to the user based on the target metadata. This technical solution solves the problems in related technologies, such as the inability to quickly find data and provide feedback to the user. Furthermore, it enables the processing of data in the data warehouse into data that can be quickly searched and fed back to the user, helping users better understand the meaning of the data, quickly locate the data they want to query, accurately guide which data is more reliable and usable, and conveniently use tools for data analysis.

[0041] In an optional embodiment, before the retrieval database obtains the location conditions corresponding to the data to be queried, the method further includes: determining the permission information of the user accessing the retrieval database; if the permission information indicates that the user has the required permissions, receiving the data request input by the user according to preset prompt information; and determining the data location conditions for performing metadata query based on the data request.

[0042] In short, to improve data security, it is necessary to restrict permissions for different users. Therefore, corresponding data access permissions can be pre-set for different users in the retrieval database, so that users can only access data corresponding to their own permissions. Furthermore, the permission information can be used to determine whether a user is authorized to access the retrieval database, thereby preventing unauthorized users from accessing the retrieval database. Moreover, if it is determined that the current user can access data in the retrieval database, the location conditions for searching data can be determined based on the data requirements input by the user, and the target data can be determined from the data that the user is currently allowed to access based on the location conditions.

[0043] In an optional embodiment, the method further includes: initiating a permission application process for the retrieval database when the permission information indicates that the user does not have the required permissions; and sending the identity information of the user who wants to use the retrieval database and the target permission information to be applied for to the retrieval database.

[0044] It is understandable that when a user first uses the retrieval database, the database does not have the user's set permissions. Therefore, the permission application process for the retrieval database can be automatically initiated, guiding the user to apply for the use of the retrieval database, and inputting the corresponding identity information and the target permission information to be applied for, thereby completing the authorization of data access and managing the use of data.

[0045] In an optional embodiment, after adding different types of metadata carried by the first data to the retrieval database based on the metadata information, the above method further includes: determining multiple data types of the metadata corresponding to the first data; dividing the metadata corresponding to the first data based on the data type, and determining the data graph corresponding to each data type; and storing the multiple data graphs corresponding to the multiple data types in a graph database that assists the retrieval database.

[0046] To make the data more intuitive to use and display, after determining the primary data, data graphs can be created corresponding to different primary data types by classifying them into data types. These data graphs are used to represent the relationships between different data points, establishing information associations between data, and facilitating users' quick understanding of the data's origin and flow. After determining the data graphs, they need to be stored in a graph database used as an auxiliary retrieval database. It should be noted that the aforementioned graph database uses points and lines as basic storage units, enabling efficient storage and retrieval of graph data. This application does not impose further limitations on this aspect.

[0047] In an optional embodiment, after determining the target metadata that matches the positioning conditions from the retrieval database, the above method further includes: filling the target metadata into a preset asset map template to obtain a target asset map; and sending the determined target asset map to a display interface associated with the retrieval database.

[0048] In an optional embodiment, after determining that the target asset map is sent to the display interface associated with the retrieval database, the method further includes: detecting the operation data of the user on the display interface; and displaying the data asset acquisition progress on the target asset map based on the operation data.

[0049] To enhance the visualization of the database retrieval process, after identifying the target metadata, an asset map template can be used to generate a target asset map that can be displayed on the interface, thus visualizing the data retrieval process and improving the data search experience for the user object.

[0050] In an optional embodiment, after determining the target metadata matching the positioning conditions from the retrieval database, the method further includes: obtaining feedback information from the user regarding the target metadata; if the feedback information indicates that the target metadata is invalid data, sending an update instruction to the retrieval database, wherein the update instruction is used to perform data updates on different types of metadata in the retrieval database; if the feedback information indicates that the target metadata is valid data, sending an inquiry message to the user, wherein the inquiry message is used to inquire whether the user wants to end the current data acquisition process.

[0051] In simple terms, after identifying the target metadata and providing feedback to the users, the system collects feedback from the users to determine whether the currently retrieved data meets their requirements and whether the search is accurate and effective. This avoids applying invalid search results as the final search result, ensuring the accuracy of the search and providing support to accurately guide which data is more reliable and usable.

[0052] Obviously, the embodiments described above are merely some embodiments of the present invention, and not all embodiments. To better understand the above data query method, the process is described below in conjunction with embodiments, but this is not intended to limit the technical solutions of the embodiments of the present invention. Specifically:

[0053] As users of data assets, we are usually concerned with four aspects: what is the data, where is the data, how to obtain the data, and how to use the data.

[0054] What is the data? This requires knowing the data format, such as structured or unstructured; the data definition, such as technical, business, or management; the data usage characteristics, such as frequency, evaluation, quality, and security level; and what information the data contains, such as time period, business category, and information density.

[0055] Where is the data? This requires knowing where the data is stored, what business-related data is available, what data has been used in the past and is worth referencing, and where the auxiliary tools related to data use are located.

[0056] How to acquire data: A series of tools and auxiliary information are needed to help achieve various ways of using data, including data sampling, data querying, data downloading, and establishing a data security sandbox.

[0057] How to use the data: It is necessary to help users obtain the inherent information of the data more quickly and conveniently, such as data summary information, data analysis models, knowledge help guidance, etc.

[0058] Therefore, relevant solutions are needed to address the above-mentioned problems.

[0059] As an optional implementation method, Figure 3 This is a schematic diagram of the architecture of an optional data asset mapping system according to an embodiment of this application. Starting with business metadata and technical metadata, it clarifies the relationships between metadata, inventories asset lists, identifies data owners and stewards, and solves four key problems through technologies such as full-text search, graph databases, and graphical tools. It primarily addresses how to quickly locate data within massive amounts of data, how to retrieve data, and how to use data, thereby improving user efficiency in data utilization. Figure 3 As shown, the system includes: a data warehouse module, a technical metadata module, a business metadata module, a full-text search database module, a graph database module, an API service module, and a unified search entry module;

[0060] Optionally, the aforementioned data warehouse module is used to store raw data assets; the technical metadata module is used to develop and manage the data used in the data warehouse; and the business metadata module is used to describe the data in the data warehouse from a business perspective, providing a semantic layer between users and the actual system, enabling business personnel without computer technology to "understand" the data in the data warehouse. The full-text search database module is used to transform the entire content of a complete information source into a data set formed by information units that can be recognized and processed by a computer, generally used for rapid retrieval of massive amounts of data. Here, business metadata and technical metadata are stored in the database for convenient and rapid querying. The graph database module is used to store graph data efficiently, based on points and lines as storage units. Here, it is used to store the lineage relationships (i.e., data association relationships) between metadata, allowing users to quickly understand the source and flow of the data itself.

[0061] Optionally, the API service module, also known as the data service, is used to build a unified data service bus for enterprises, helping them to manage internal and external API services in a unified manner. The aforementioned data service can provide the ability to quickly generate data APIs from data tables, covering the entire lifecycle management of API publishing, management, operation, and sales. This enables simple, fast, low-cost, and low-risk implementation of microservice aggregation, front-end / back-end separation, and system integration, while opening up functionality and data to partners and developers.

[0062] Optionally, a unified search entry module is provided on the asset map homepage to offer a one-click search service, helping users quickly find the data they want while also providing asset recommendations and asset usage functions.

[0063] Optional, Figure 4This is a schematic diagram from the perspective of a business user in an optional data asset mapping system according to an embodiment of this application. Business users use the asset map to search for assets and obtain permissions through an application process before using the data. Simultaneously, when the business cannot find the desired data, they can submit a request through a problem / request submission portal. Dedicated data developers will process the request, collecting and processing the data before ultimately directing it to the business user.

[0064] Optional, Figure 5 This is a schematic diagram from the perspective of an asset map developer, representing an optional data asset mapping system according to an embodiment of this application. When developing a data model, the data developer needs to determine whether a data table already exists based on requirements, through asset mapping... Figure 1 Key-based search retrieves trusted data tables based on data authentication information. The normal table creation process only proceeds if the desired data table cannot be found.

[0065] In summary, the above implementation methods address four key questions for users: what is data, where is data, how to retrieve data, and how to use data. This helps users better understand the meaning of data, quickly locate the data they want to query, accurately identify which data is more reliable and usable, and conveniently use tools for data analysis.

[0066] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods according to the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) and includes several instructions to cause a terminal device (which may be a mobile phone, computer, server, or network device, etc.) to execute the methods of the various embodiments of the present invention.

[0067] This embodiment also provides a data query device for implementing the above embodiments and preferred embodiments; details already described will not be repeated. As used below, the term "module" can refer to a combination of software and / or hardware that performs a predetermined function. Although the devices described in the following embodiments are preferably implemented in software, hardware implementations, or a combination of software and hardware, are also possible and contemplated.

[0068] Figure 6 This is a structural block diagram of an optional data query device according to an embodiment of the present invention, the device comprising:

[0069] The determination module 62 is used to perform metadata analysis on the first data in the data warehouse, and determine the metadata information of the first data based on the result of the metadata analysis;

[0070] Add module 64 is used to add different types of metadata carried by the first data to the retrieval database based on the metadata information;

[0071] The matching module 66 is used to determine the target metadata that matches the location conditions from the retrieval database when the location conditions corresponding to the data to be queried are obtained from the retrieval database, so as to confirm the data query result to be fed back to the user based on the target metadata.

[0072] Through the modules described above, metadata analysis is performed on the first data in the data warehouse, and the metadata information of the first data is determined based on the results of the metadata analysis. Based on the metadata information, different types of metadata carried by the first data are added to the retrieval database. When the retrieval database retrieves the location conditions corresponding to the data to be queried, the target metadata matching the location conditions is determined from the retrieval database. The data query results are then confirmed and fed back to the user based on the target metadata. This technical solution solves the problems in related technologies, such as the inability to quickly find data and provide feedback to the user. Furthermore, it enables the processing of data in the data warehouse into data that can be quickly searched and fed back to the user, helping users better understand the meaning of the data, quickly locate the data they want to query, accurately guide which data is more reliable and usable, and conveniently use tools for data analysis.

[0073] In an optional embodiment, the above apparatus further includes: a permission module, configured to determine permission information of a user object accessing the retrieval database; when the permission information indicates that the user object has the required permissions, receive data requests input by the user object according to preset prompt information; and determine data location conditions for performing metadata queries based on the data requests.

[0074] In an optional embodiment, the above-mentioned condition module further includes: an application unit, configured to initiate the permission application process for the retrieval database when the permission information indicates that the user does not have the required permission; and send the identity information of the user to be used in the retrieval database and the target permission information to be applied for to the retrieval database.

[0075] In an optional embodiment, the above apparatus further includes: a partitioning module, configured to determine multiple data types of metadata corresponding to the first data; partition the metadata corresponding to the first data based on the data types, and determine a data graph corresponding to each data type; and store the multiple data graphs corresponding to the multiple data types in a graph database that assists the retrieval database.

[0076] In an optional embodiment, the above apparatus further includes: a filling module, configured to fill the target metadata into a preset asset map template to obtain a target asset map; and to send the determined target asset map to a display interface associated with the retrieval database.

[0077] In an optional embodiment, the above-mentioned filling module further includes: a detection unit, configured to detect the operation data of the user on the display interface; and display the acquisition progress of the data asset on the target asset map based on the operation data.

[0078] In an optional embodiment, the above apparatus further includes: a feedback module, configured to acquire feedback information from the user regarding the target metadata; if the feedback information indicates that the target metadata is invalid data, send an update instruction to the retrieval database, wherein the update instruction is used to perform data updates on different types of metadata in the retrieval database; if the feedback information indicates that the target metadata is valid data, send an inquiry message to the user, wherein the inquiry message is used to inquire whether the user should end the current data acquisition process.

[0079] Embodiments of the present invention also provide a computer-readable storage medium storing a computer program, wherein the computer program is configured to perform the steps in any of the above method embodiments when executed.

[0080] Optionally, in this embodiment, the storage medium may be configured to store a computer program for performing the following steps:

[0081] S1, Perform metadata analysis on the first data in the data warehouse, and determine the metadata information of the first data based on the results of the metadata analysis;

[0082] S2, based on the metadata information, add the different types of metadata carried by the first data to the retrieval database;

[0083] S3, if the location conditions corresponding to the data to be queried are obtained from the retrieval database, the target metadata matching the location conditions is determined from the retrieval database, so as to confirm the data query result to be fed back to the user based on the target metadata.

[0084] In one exemplary embodiment, the aforementioned computer-readable storage medium may include, but is not limited to, various media capable of storing computer programs, such as a USB flash drive, read-only memory (ROM), random access memory (RAM), portable hard disk, magnetic disk, or optical disk.

[0085] Specific examples in this embodiment can be found in the examples described in the above embodiments and exemplary implementations, and will not be repeated here.

[0086] Embodiments of the present invention also provide an electronic device including a memory and a processor, the memory storing a computer program and the processor being configured to run the computer program to perform the steps in any of the above method embodiments.

[0087] Optionally, in this embodiment, the processor can be configured to perform the following steps via a computer program:

[0088] S1, Perform metadata analysis on the first data in the data warehouse, and determine the metadata information of the first data based on the results of the metadata analysis;

[0089] S2, based on the metadata information, add the different types of metadata carried by the first data to the retrieval database;

[0090] S3, if the location conditions corresponding to the data to be queried are obtained from the retrieval database, the target metadata matching the location conditions is determined from the retrieval database, so as to confirm the data query result to be fed back to the user based on the target metadata.

[0091] In one exemplary embodiment, the electronic device may further include a transmission device and an input / output device, wherein the transmission device is connected to the processor and the input / output device is connected to the processor.

[0092] Specific examples in this embodiment can be found in the examples described in the above embodiments and exemplary implementations, and will not be repeated here.

[0093] It is obvious to those skilled in the art that the modules or steps of the present invention described above can be implemented using general-purpose computing devices. They can be centralized on a single computing device or distributed across a network of multiple computing devices. They can be implemented using computer-executable program code, and thus can be stored in a storage device for execution by a computing device. In some cases, the steps shown or described can be performed in a different order than those described herein, or they can be fabricated as separate integrated circuit modules, or multiple modules or steps can be fabricated as a single integrated circuit module. Thus, the present invention is not limited to any particular combination of hardware and software.

[0094] The above description is only a preferred embodiment of this application. It should be noted that for those skilled in the art, several improvements and modifications can be made without departing from the principle of this application, and these improvements and modifications should also be considered within the scope of protection of this application.

Claims

1. A data query method, characterized in that, include: Perform metadata analysis on the first data in the data warehouse, and determine the metadata information of the first data based on the results of the metadata analysis; Based on the metadata information, the different types of metadata carried by the first data are added to the retrieval database; When the location conditions corresponding to the data to be queried are obtained from the retrieval database, the target metadata that matches the location conditions is determined from the retrieval database, so as to confirm the data query results to be fed back to the user based on the target metadata; The method further includes: The first data is identified as having multiple data types corresponding to its metadata. Based on these multiple data types, the metadata corresponding to the first data is divided, and a data graph corresponding to each data type is determined to obtain multiple data graphs. These multiple data graphs are used to represent the relationships between metadata corresponding to different types of the first data. The multiple data graphs are then stored in a graph database that assists in the retrieval database.

2. The method according to claim 1, characterized in that, Before the retrieval database obtains the location conditions corresponding to the data to be queried, the method further includes: Determine the permission information of the user object accessing the retrieval database; When the permission information indicates that the user has the required permission, the system receives the data request input by the user according to the preset prompt information. Based on the aforementioned data requirements, the data location conditions for performing metadata queries are determined.

3. The method according to claim 2, characterized in that, The method further includes: If the permission information indicates that the user does not have the required permissions, the permission request process for retrieving the database is initiated. Send the identity information of the user of the search database and the target permission information to be requested to the search database.

4. The method according to claim 1, characterized in that, After determining the target metadata matching the location criteria from the retrieval database, the method further includes: The target metadata is filled into a preset asset map template to obtain the target asset map; The identified target asset map will be sent to the display interface associated with the retrieval database.

5. The method according to claim 4, characterized in that, After determining the target asset map and sending it to the display interface associated with the retrieval database, the method further includes: Detect the user's operation data on the display interface; Based on the operational data, the progress of data asset acquisition is displayed on the target asset map.

6. The method according to claim 1, characterized in that, After determining the target metadata matching the location criteria from the retrieval database, the method further includes: Obtain feedback information from the user regarding the target metadata; If the feedback information indicates that the target metadata is invalid, an update instruction is sent to the retrieval database, wherein the update instruction is used to perform data updates on different types of metadata in the retrieval database; If the feedback information indicates that the target metadata is valid, an inquiry message is sent to the user, wherein the inquiry message is used to ask the user whether to end the current data acquisition process.

7. A data query device, characterized in that, include: The determination module is used to perform metadata analysis on the first data in the data warehouse and determine the metadata information of the first data based on the result of the metadata analysis. An add module is used to add different types of metadata carried by the first data to the retrieval database based on the metadata information; The matching module is used to determine the target metadata that matches the location conditions from the retrieval database when the location conditions corresponding to the data to be queried are obtained from the retrieval database, so as to confirm the data query result to be fed back to the user based on the target metadata; A partitioning module is used to determine multiple data types of metadata corresponding to the first data; The metadata corresponding to the first data is divided based on the multiple data types, and a data graph corresponding to each data type is determined to obtain multiple data graphs. The multiple data graphs are used to describe the relationship between the metadata corresponding to different types of the first data. The multiple data graphs are stored in a graph database that assists the retrieval database.

8. A computer-readable storage medium, characterized in that, The computer-readable storage medium includes a stored program, wherein the program, when executed, performs the method of any one of claims 1 to 6.

9. An electronic device comprising a memory and a processor, characterized in that, The memory stores a computer program, and the processor is configured to execute the method of any one of claims 1 to 6 through the computer program.

Images