Data exploration method and device, equipment and storage medium

Abstract

The invention provides a data probing method, device and equipment and a storage medium, and the method comprises the steps: building a connection with a target database through a data probing key in the target data probing account and data probing equipment when a database connection operation of the target data probing account for the target database is detected; after connection with the target database is completed, a data exploration function implementation interface for the target database is displayed, and the data exploration function implementation interface comprises at least one data exploration function triggering area corresponding to the target database; and when a data probing function triggering operation for any data probing function triggering area in the at least one data probing function triggering area is detected, performing data probing on the target database according to a templated data probing function corresponding to any data probing function triggering area. According to the embodiment of the invention, data probing can be conveniently carried out, so that the data probing efficiency is improved.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a data exploration method, apparatus, device and storage medium. Background Art

[0002] Currently, data exploration users are often required to write data exploration statements to explore different business data, which results in cumbersome operations and long exploration times. Therefore, there is currently no good solution for how to conveniently explore data and improve its efficiency. Summary of the Invention

[0003] In view of this, an embodiment of the present invention provides a data exploration method, apparatus, device and storage medium to solve the problem that data exploration is cumbersome due to related technologies; that is, an embodiment of the present invention can display at least one data exploration function trigger area corresponding to the target database after the data exploration device establishes a connection with the target database, so as to perform data exploration on the target database through the templated data exploration function corresponding to any data exploration function trigger area, thereby conveniently performing data exploration to improve data exploration efficiency, and can limit the devices that establish connection with the database through the target data exploration account and data exploration key, thereby achieving efficient data exploration through the templated data exploration function while preventing the data exploration authority of the target data exploration account from being leaked.

[0004] According to one aspect of an embodiment of the present invention, a data exploration method is provided. The method is applied to a data exploration device, and the method includes:

[0005] When a database connection operation of a target data exploration account to a target database is detected, establishing a connection with the target database by using the target data exploration account and a data exploration key in the data exploration device;

[0006] After completing the connection with the target database, displaying a data exploration function implementation interface for the target database, the data exploration function implementation interface including at least one data exploration function triggering area corresponding to the target database, each data exploration function triggering area being used to trigger a templated data exploration function;

[0007] When a data exploration function triggering operation is detected for any one of the at least one data exploration function triggering areas, data exploration is performed on the target database according to the templated data exploration function corresponding to any one of the data exploration function triggering areas.

[0008] According to another aspect of an embodiment of the present invention, a data exploration apparatus is provided, the apparatus running on a data exploration device, the apparatus comprising:

[0009] a connection unit configured to, upon detecting a database connection operation of a target data exploration account to a target database, establish a connection with the target database using the target data exploration account and a data exploration key in the data exploration device;

[0010] a processing unit configured to display a data exploration function implementation interface for the target database after completing connection with the target database, wherein the data exploration function implementation interface includes at least one data exploration function triggering area corresponding to the target database, each data exploration function triggering area being configured to trigger a templated data exploration function;

[0011] The processing unit is further configured to, when a data exploration function triggering operation is detected for any one of the at least one data exploration function triggering areas, perform data exploration on the target database according to the templated data exploration function corresponding to any one of the data exploration function triggering areas.

[0012] According to another aspect of an embodiment of the present invention, a data exploration device is provided, which includes a processor and a memory storing a program, wherein the program includes instructions, which, when executed by the processor, enable the processor to perform the above-mentioned method.

[0013] According to another aspect of an embodiment of the present invention, a non-transitory computer-readable storage medium storing computer instructions is provided, wherein the computer instructions are used to enable a computer to execute the above-mentioned method.

[0014] An embodiment of the present invention can establish a connection with the target database through the target data exploration account and the data exploration key in the data exploration device when a database connection operation of the target data exploration account for the target database is detected; after completing the connection with the target database, a data exploration function implementation interface for the target database can be displayed, and the data exploration function implementation interface includes at least one data exploration function trigger area corresponding to the target database, and one data exploration function trigger area is used to trigger a templated data exploration function; based on this, when a data exploration function trigger operation for any data exploration function trigger area in at least one data exploration function trigger area is detected, data exploration can be performed on the target database according to the templated data exploration function corresponding to any data exploration function trigger area. It can be seen that the embodiment of the present invention can display at least one data exploration function trigger area corresponding to the target database after the data exploration device establishes a connection with the target database, so as to perform data exploration on the target database through the templated data exploration function corresponding to any data exploration function trigger area, thereby conveniently performing data exploration to improve data exploration efficiency, and can limit the devices that establish a connection with the database through the target data exploration account and data exploration key, thereby achieving efficient data exploration through the templated data exploration function while preventing the data exploration authority of the target data exploration account from being leaked. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Further details, features and advantages of the present invention are disclosed in the following description of exemplary embodiments in conjunction with the accompanying drawings, in which:

[0016] Figure 1 A schematic flow chart of a data exploration method according to an exemplary embodiment of the present invention is shown;

[0017] Figure 2 A schematic diagram of a data exploration tool according to an exemplary embodiment of the present invention is shown;

[0018] Figure 3 A schematic diagram showing an interface for implementing a data exploration function according to an exemplary embodiment of the present invention is shown;

[0019] Figure 4 A schematic flow chart of another data exploration method according to an exemplary embodiment of the present invention is shown;

[0020] Figure 5 A schematic block diagram of a data exploration device according to an exemplary embodiment of the present invention is shown;

[0021] Figure 6 A block diagram of an exemplary electronic device capable of implementing the embodiments of the present invention is shown. DETAILED DESCRIPTION

[0022] Embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present invention are shown in the accompanying drawings, it should be understood that the present invention can be implemented in various forms and should not be construed as limited to the embodiments described herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of the present invention. It should be understood that the drawings and embodiments of the present invention are for illustrative purposes only and are not intended to limit the scope of protection of the present invention.

[0023] It should be understood that the various steps described in the method embodiments of the present invention may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present invention is not limited in this respect.

[0024] The term "including" and its variations used in this document are open inclusions, that is, "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one other embodiment"; the term "some embodiments" means "at least some embodiments". The relevant definitions of other terms will be given in the following description. It should be noted that the concepts of "first", "second", etc. mentioned in the present invention are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0025] It should be noted that the modifications of "one" and "multiple" mentioned in the present invention are illustrative rather than restrictive. Those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0026] The names of the messages or information exchanged between multiple devices in the embodiments of the present invention are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0027] It should be noted that the execution subject of the data exploration method provided in the embodiment of the present invention can be a data exploration device, that is, the data exploration method can be applied to the data exploration device; optionally, a data exploration device can be composed of one or more electronic devices, then the execution subject of the data exploration method provided in the embodiment of the present invention can be one or more electronic devices constituting the data exploration device, and the embodiment of the present invention does not limit this; wherein, the electronic device can be a terminal (i.e., a client) or a server, then when the execution subject includes multiple electronic devices, and the multiple electronic devices include at least one terminal and at least one server, the data exploration method provided in the embodiment of the present invention can be jointly executed by the terminal and the server. Accordingly, the terminals mentioned here can include but are not limited to: smart phones, tablet computers, laptops, desktop computers, intelligent voice interaction devices, etc. The server mentioned here can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides cloud services, cloud databases, cloud computing (cloud computing), cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN (Content Delivery Network), and basic cloud computing services such as big data and artificial intelligence platforms, etc.

[0028] Optionally, the data exploration device may include a data exploration tool (e.g., a data exploration tool implemented through an application program). The data exploration device may then execute the data exploration method through the data exploration tool. In other words, the execution entity of the data exploration method provided in the embodiments of the present invention may also be the data exploration tool in the data exploration device. Alternatively, the data exploration device may be referred to as a data exploration tool, a data exploration machine, or the like. Optionally, the data exploration device may refer to a device (i.e., a machine) bound to a data exploration key. In this case, when the device is bound to a data exploration key, the device may be used as a data exploration device to execute the data exploration method provided in the embodiments of the present invention.

[0029] Based on the above description, an embodiment of the present invention proposes a data exploration method, which can be executed by the data exploration device mentioned above, that is, it can be executed by the electronic device (terminal or server) constituting the data exploration device; or, the data exploration method can be executed by the data exploration tool in the data exploration device, that is, it can be executed by the data exploration device through the data exploration tool. For the sake of convenience, the following description will be based on the example of the data exploration method executed by the data exploration device; Figure 1 As shown, the data exploration method may include the following steps S101-S103:

[0030] S101 , when a database connection operation of a target data exploration account to a target database is detected, a connection is established with the target database using the target data exploration account and a data exploration key in a data exploration device.

[0031] The data exploration device is bound to a data exploration key. That is, a designated storage location of the data exploration device stores the data exploration key, so that the data exploration device includes the data exploration key. Optionally, the designated storage location can be set based on experience or actual needs, and this is not limited in this embodiment of the present invention. Optionally, the data exploration key can be set based on experience or actual needs, and this is not limited in this embodiment of the present invention.

[0032] Optionally, when a probe login operation is detected, the data exploration device may authenticate the probe login account indicated by the probe login operation; after the probe login account indicated by the probe login operation passes the identity authentication, the data exploration key is obtained; based on this, the data exploration device can obtain the data exploration key through the designated storage location. It should be understood that when a device does not obtain the data exploration key through the designated storage location, the device does not include the data exploration key, and then the device is not a data exploration device. At this time, the device will not be able to establish a connection with the target database through the target data exploration account, thereby effectively preventing the leakage of account permissions (i.e., the data exploration permissions of the target data exploration account). The data exploration account (also known as the account number) can be bound to the data exploration device through the data exploration key (also referred to as the key) to ensure that the data exploration account can only access the database through the data exploration device, which can effectively improve the security of database access.

[0033] Optionally, the probe login account indicated by the probe login operation can be any probe login account, and the embodiment of the present invention does not limit this. Optionally, when the probe login account indicated by the probe login operation is authenticated, if the probe login account indicated by the probe login operation is a probe login account in the specified probe login account set, it can be determined that the probe login account indicated by the probe login operation has passed the identity authentication; if the probe login account indicated by the probe login operation is not a probe login account in the specified probe login account set, it can be determined that the probe login account indicated by the probe login operation has not passed the identity authentication; or, if the probe login account indicated by the probe login operation is a probe login account in the specified probe login account set, and the probe login password indicated by the probe login operation is the login password of the probe login account indicated by the probe login operation (that is, the probe login password indicated by the probe login operation is correct), it can be determined that the probe login account indicated by the probe login operation has passed the identity authentication, and so on; the embodiment of the present invention does not limit this. Optionally, the specified set of login accounts to be probed may be set based on experience or actual needs, and this is not limited in the embodiments of the present invention; illustratively, the specified set of login accounts to be probed may include all employee accounts or all employee accounts of a department, and so on.

[0034] It should be noted that the embodiments of the present invention do not limit the specific implementation of the probe login operation. For example, a user (such as a user with a probe login account) can enter the probe login account and / or corresponding probe login password into the data exploration device through an input device such as a keyboard to perform the probe login operation, so that the data exploration device can detect the probe login operation and determine the probe login account and / or probe login password indicated by the probe login operation; alternatively, the user can perform the probe login operation by scanning a code through a smart terminal (such as a mobile phone, etc.), etc.

[0035] Optionally, the above-mentioned target data exploration account may be the same as the exploration login account used to log in to the data exploration device (i.e., the exploration login account indicated by the exploration login operation, which may also be referred to as the currently logged-in exploration login account or the exploration login account that has successfully logged in, etc.), or may be different. The embodiment of the present invention does not limit this. Optionally, when the target data exploration account is the same as the exploration login account used to log in to the data exploration device, the user can perform the database connection operation without entering the target data exploration account when performing the database connection operation. At this time, the data exploration device can use the currently logged-in exploration login account as the target data exploration account; when the target data exploration account is different from the exploration login account used to log in to the data exploration device, the user needs to enter the target data exploration account (such as by keyboard input or by scanning the code to enter the target data exploration account) to perform the database connection operation, so that the data exploration device determines the target data exploration account, and then detects the database connection operation of the target data exploration account for the target database, and so on. Optionally, the login data exploration device may also refer to a login data exploration tool, that is, it may also refer to a data exploration tool in the login data exploration device. Optionally, the target data exploration account may be any data exploration account, which is not limited in the embodiment of the present invention.

[0036] It should be noted that the embodiments of the present invention do not limit the specific implementation methods of the database connection operation. For example, after logging into the data exploration device, the data exploration device may display a database connection trigger interface, and the database connection trigger interface may include a database connection selection button for each database in M databases. Then, when the M databases include the target database, the user may perform a selection operation (such as a click operation or a long press operation (i.e., an operation in which the pressing time is greater than a preset pressing time threshold)) on the database connection selection button of the target database to implement the database connection operation for the target database, where M is a non-negative integer; optionally, when the target data exploration account is the currently logged-in exploration login account, the user may perform a selection operation on the database connection selection button of the target database to implement the database connection operation for the target database. When the target data exploration account is not the currently logged-in exploration login account, a data exploration account input area may be displayed after performing a selection operation on the database connection selection button of the target database to guide the user to enter the target data exploration account, thereby performing the database connection operation for the target database, and so on; based on this, the embodiments of the present invention may implement the database connection operation in an interactive manner, i.e., the user may interactively perform the database connection operation, etc., such as Figure 2As shown. For another example, the user can perform custom configuration in the database connection trigger interface (that is, write a script to connect to the target database) to perform database connection operations for the target database, and so on. It can be seen that the embodiment of the present invention can complete the connection to the target database through interactive or custom configuration and other methods. Optionally, the M databases can be at least one of the following databases, in which case the database connection selection buttons of all databases for which the target data exploration account has data exploration permissions can be displayed, and so on. Optionally, the preset pressing time threshold can be set according to experience or according to actual needs, and the embodiment of the present invention does not limit this.

[0037] Optionally, the target data exploration account may have data exploration permissions for each of at least one database. The target data exploration account's data exploration permissions for the at least one database can be applied for through a unified data exploration permission approval process; the target database is a database within the at least one database. Optionally, the at least one database may include all databases that support the unified data exploration permission approval process for data exploration permissions. In other words, the target data exploration account can be a universal account with access permissions (i.e., data exploration permissions) for at least one database. Optionally, a user can submit a unified data exploration permission approval process for the target data exploration account for at least one database. Approval personnel can then use this unified data exploration permission approval process to uniformly authorize the target data exploration account for the at least one database (i.e., grant the target data exploration account data exploration permissions for each database through the unified data exploration permission approval process). This unified data exploration permission approval process allows the target data exploration account to be authorized by the business systems of each database, thereby avoiding access to different databases through different data exploration accounts, avoiding the time-consuming approval process associated with applying for multiple accounts, and effectively avoiding issues such as high maintenance and management costs caused by excessive accounts. Optionally, at least one database that supports a unified data exploration permission approval process to apply for data exploration permissions can be set according to experience or actual needs, and the embodiment of the present invention does not limit this. Then accordingly, the embodiment of the present invention can bind a unified permission account (i.e., an account with data exploration permissions for each database in at least one database, such as a target data exploration account) to a data exploration device through a data exploration key, that is, the unified permission account can only perform data exploration on any database in at least one database through the data exploration device, thereby realizing unified permission management and control of the data exploration device. It should be noted that the embodiment of the present invention does not limit the specific application process of the unified data exploration permission approval process.

[0038] Based on this, the embodiments of the present invention can solve problems such as long approval processes and high maintenance costs by building a unified machine (i.e., by binding a data exploration key to build a unified data exploration device for executing the data exploration method) and a whitelist account (i.e., an account with data exploration permissions for each database in at least one database, such as a target data exploration account). In other words, the embodiments of the present invention can conveniently implement a permission approval process for at least one database through a unified data exploration permission approval process for at least one database, and can perform data exploration on each database separately through an account with data exploration permissions for each database in at least one database, without the need to access different databases through different accounts, which can effectively reduce the account maintenance cost.

[0039] Optionally, the number of target databases can be one or more, that is, the target database can include one or more databases in at least one database, and the embodiment of the present invention does not limit this. Based on this, when the number of target databases is one, the target database can be any database in at least one database, and the embodiment of the present invention does not limit this; when the number of target databases is multiple, the data exploration device can establish a connection with each target database in the multiple target databases respectively to display the data exploration function implementation interface of each target database respectively, and so on. Optionally, the data exploration function implementation interface of different target databases can be the same interface (that is, the data exploration function implementation areas of different target databases can be displayed in the same data exploration function implementation interface at this time), or different interfaces (such as displaying the data exploration function implementation interface of different target databases by switching interfaces, etc.), and the embodiment of the present invention does not limit this. For the sake of convenience, the following description will be based on one target database as an example.

[0040] Optionally, when establishing a connection with the target database through the target data exploration account and the data exploration key in the data exploration device, the data exploration device can use the target data exploration account and the data exploration key to generate a database connection request, and the database connection request can carry the target data exploration account and the data exploration key, etc. Based on this, the database connection request can be sent to the target database, so that the target database allows the data exploration device (i.e., the data exploration device that sends the database connection request) to establish a connection after verifying that the target data exploration account has the data exploration permission of the target database and the data exploration key is correct, thereby realizing the establishment of a connection between the data exploration device and the target database. Optionally, the number of data exploration devices can be one or more, and the embodiment of the present invention does not limit this. For the sake of ease of explanation, the following description will be based on one data exploration device as an example, that is, the description will be based on a data exploration device that detects the database connection operation of the target data exploration account for the target database.

[0041] S102, after completing the connection with the target database, displaying the data exploration function implementation interface for the target database, the data exploration function implementation interface includes at least one data exploration function trigger area corresponding to the target database, and a data exploration function trigger area is used to trigger a templated data exploration function.

[0042] Among them, a templated data exploration function supports implementation through a data exploration function templated script, that is, the corresponding templated data exploration function can be implemented by executing the data exploration function templated script corresponding to a templated data exploration function, that is, a data exploration function templated script can be used to implement a templated data exploration function.

[0043] Optionally, the at least one templated data exploration function corresponding to different databases may be the same or different, and this is not limited in the embodiments of the present invention. Specifically, a templated data exploration function corresponding to a database can implement data exploration for the corresponding database according to the corresponding templated data exploration function. Optionally, the at least one data exploration function triggering area corresponding to different databases may be the same or different, and this is not limited in the embodiments of the present invention. Accordingly, the embodiments of the present invention do not limit the specific display content of the data exploration function implementation interface.

[0044] In an embodiment of the present invention, the at least one data exploration function triggering area corresponding to the target database may include the data exploration function triggering area of each templated data exploration function in the at least one templated data exploration function corresponding to the target database. Optionally, the data exploration function triggering area of a templated data exploration function may be the area where the data exploration function identifier of the corresponding templated data exploration function is located, such as Figure 3 As shown; or, the data exploration function triggering area of a templated data exploration function can be a selection box before the data exploration function identifier of the corresponding templated data exploration function, etc.; the embodiment of the present invention does not limit this. Optionally, the data exploration function identifier of a templated data exploration function can be the data exploration function name of the corresponding templated data exploration function, or can be the data exploration function number of the corresponding templated data exploration function, etc., and the embodiment of the present invention does not limit this. Optionally, Figure 3 The data profiling function implementation interface shown may be used to indicate tool capabilities supported by a data profiling device.

[0045] Optionally, at least one templated data exploration function corresponding to a database may include but is not limited to at least one of the following: structural information exploration function (such as exploring the corresponding field information and field format of the database), data range exploration function (such as exploring the data range of fields of each numerical type), data level exploration function (such as exploring the amount of data in the table), enumeration distribution exploration function (such as exploring the enumeration distribution of all fields of the enumeration type), special character exploration function (such as exploring the number and position of specified special characters), null value exploration function (such as exploring the number and position of null values), time format exploration function (such as exploring the time format, etc.), sampling data exploration function (such as exploring a certain sampling result, etc.), etc.; the embodiment of the present invention is not limited to this.

[0046] S103: When a data exploration function triggering operation is detected for any data exploration function triggering area in at least one data exploration function triggering area, data exploration is performed on the target database according to the templated data exploration function corresponding to any data exploration function triggering area.

[0047] Optionally, the data exploration function triggering operation for any data exploration function triggering area may be a click operation on any data exploration function triggering area; or, it may be a long press operation on any data exploration function triggering area; or, it may include an area selection operation (such as a click operation or a long press operation, etc.) and a data exploration parameter setting operation on any data exploration function triggering area. In this case, when the area selection operation on any data exploration function triggering area is detected, the data exploration parameter setting area of the templated data exploration function corresponding to any data exploration function triggering area may be displayed. Then, after the data exploration parameter setting operation is detected in the data exploration parameter setting area, it may be determined that the data exploration function triggering operation for any data exploration function triggering area is detected, and so on. The embodiment of the present invention does not limit this. Optionally, based on this, the embodiment of the present invention does not limit the specific implementation methods of the data exploration function triggering operation and the data exploration parameter setting operation.

[0048] In an embodiment of the present invention, after performing data exploration on a target database according to the templated data exploration function corresponding to any data exploration function triggering area, the data exploration device can obtain the templated data exploration results of the templated data exploration function corresponding to any data exploration function triggering area under the target database (also referred to as the templated data exploration results of the templated data exploration function corresponding to any data exploration function triggering area for the target database). Optionally, the data exploration device can output the templated exploration results to a designated file directory (i.e., store them in a designated file directory) for users to view multiple times, thereby achieving the sedimentation and reuse of knowledge assets. Based on this, an embodiment of the present invention can select one or more capabilities to be explored to complete automated execution and / or result display. Optionally, the designated file directory can be set based on experience or actual needs, and the embodiment of the present invention is not limited to this. Optionally, each database can correspond to a designated file directory, in which case the above-mentioned templated data exploration results can be output to the designated file directory corresponding to the target database; optionally, the designated file directories corresponding to different databases can be the same or different, and the embodiment of the present invention is not limited to this. Alternatively, a data exploration function may correspond to a designated file directory, in which case the templated data exploration results may be output to the designated file directory corresponding to any data exploration function triggering region, and so on. Optionally, the designated file directories corresponding to different data exploration functions may be the same or different, and this is not limited in the embodiment of the present invention. In other words, the embodiment of the present invention does not limit the file directories in which different data exploration results are stored.

[0049] From the above, it can be seen that the embodiments of the present invention can implement various operations (such as database connection operations and data exploration function triggering operations, etc.) through automated scripts; optionally, the execution of automated scripts can be used to implement interactive execution of corresponding operations, and automated scripts can include templated scripts and custom scripts (i.e., custom configured scripts), etc.

[0050] An embodiment of the present invention can establish a connection with the target database through the target data exploration account and the data exploration key in the data exploration device when a database connection operation of the target data exploration account for the target database is detected; after completing the connection with the target database, a data exploration function implementation interface for the target database can be displayed, and the data exploration function implementation interface includes at least one data exploration function trigger area corresponding to the target database, and one data exploration function trigger area is used to trigger a templated data exploration function; based on this, when a data exploration function trigger operation for any data exploration function trigger area in at least one data exploration function trigger area is detected, data exploration can be performed on the target database according to the templated data exploration function corresponding to any data exploration function trigger area. It can be seen that the embodiment of the present invention can display at least one data exploration function trigger area corresponding to the target database after the data exploration device establishes a connection with the target database, so as to perform data exploration on the target database through the templated data exploration function corresponding to any data exploration function trigger area, thereby conveniently performing data exploration to improve data exploration efficiency, and can limit the devices that establish a connection with the database through the target data exploration account and data exploration key, thereby achieving efficient data exploration through the templated data exploration function while preventing the data exploration authority of the target data exploration account from being leaked.

[0051] Based on the above description, an embodiment of the present invention further proposes another data exploration method. Accordingly, the data exploration method can be executed by the data exploration device mentioned above, that is, it can be executed by the electronic device (terminal or server) constituting the data exploration device; or, the data exploration method can be executed by the data exploration tool in the data exploration device, that is, it can be executed by the data exploration device through the data exploration tool. For the sake of convenience, the following description will be based on the example of the data exploration method executed by the data exploration device; please refer to Figure 4 , the data exploration method may include the following steps S401-S405:

[0052] S401 : When a database connection operation of a target data exploration account to a target database is detected, a connection is established with the target database using the target data exploration account and a data exploration key in a data exploration device.

[0053] S402, after completing the connection with the target database, displaying the data exploration function implementation interface for the target database, the data exploration function implementation interface includes at least one data exploration function trigger area corresponding to the target database, and a data exploration function trigger area is used to trigger a templated data exploration function.

[0054] S403: When a data exploration function triggering operation is detected for any data exploration function triggering area in at least one data exploration function triggering area, data exploration is performed on the target database according to the templated data exploration function corresponding to any data exploration function triggering area.

[0055] Optionally, a templated data exploration function supports implementation through a data exploration function templated script; based on this, when detecting that the target editing account performs an editing operation on the data exploration function templated script of the target database, the data exploration device can verify the editing authority of the target editing account, that is, verify whether the target editing account has the editing authority for the templated data exploration function corresponding to the target database. If the target editing account has the editing authority for the templated data exploration function corresponding to the target database, it can be determined that the target editing account has passed the editing authority verification; if the target editing account does not have the editing authority for the templated data exploration function corresponding to the target database, it can be determined that the target editing account has not passed the editing authority verification; accordingly, after the target editing account passes the editing authority verification, the exploration function templated script of the target database can be edited according to the data exploration function templated script editing operation, thereby realizing the editing of the templated data exploration function corresponding to the target database (that is, realizing the editing of the data exploration function templated script corresponding to the target database), so as to obtain the updated templated data exploration function corresponding to the target database, and thus obtain the updated data exploration function templated script corresponding to the target database. Optionally, the target editing account may be the same as or different from the target data exploration account, and this is not limited in the embodiment of the present invention. It should be noted that the embodiment of the present invention does not limit the specific implementation of the data exploration function template script editing operation.

[0056] Optionally, the data exploration function templated script editing operation may include a data exploration function templated script adding operation, and may also include a data exploration function templated script deleting operation, and may also include a data exploration function templated script modifying operation, and so on; the embodiment of the present invention does not limit this. Optionally, the templated data exploration function corresponding to a database may be pre-set, or may be obtained by editing the data exploration function templated script editing operation for the corresponding database, and the embodiment of the present invention does not limit this. Based on this, after obtaining the templated data exploration function corresponding to the updated target database, the data exploration function implementation interface of the target database may be updated so that the data exploration function implementation interface of the target database includes the data exploration function trigger area of each templated data exploration function corresponding to the updated target database, and so on.

[0057] Optionally, the data exploration function implementation interface may further include a data exploration function selection execution area, such as the data exploration function selection execution area may be Figure 3, etc.; based on this, the data exploration device can also respond to the area selection operation (such as a click operation or a long press operation, etc.) detected in the data exploration function selection execution area, and display a templated data exploration function selection interface. The templated data exploration function selection interface may include a data exploration function selection area for each templated data exploration function in at least one templated data exploration function corresponding to the target database. A data exploration function selection area supports the selection of the templated data exploration function corresponding to the corresponding data exploration function selection area. The data exploration function selection area of a templated data exploration function can be indicated by the data exploration function identifier of the corresponding templated data exploration function; accordingly, the data exploration device The device can respond to a templated data exploration function selection operation detected in a templated data exploration function selection interface (that is, it can respond to a templated data exploration function selection operation for one or more data exploration function selection areas detected in a templated data exploration function selection interface), and perform data exploration on the target database according to the one or more templated data exploration functions selected in the templated data exploration function selection operation (the one or more selected templated data exploration functions may include the templated data exploration function corresponding to each data exploration function selection area in the one or more selected data exploration function selection areas), thereby obtaining the data exploration results of each templated data exploration function in the one or more templated data exploration functions under the target database. It should be noted that the embodiment of the present invention does not limit the specific implementation method of the templated data exploration function selection operation. Based on this, the embodiment of the present invention can perform data exploration on the database according to multiple templated data exploration functions at one time, thereby effectively improving the data exploration efficiency.

[0058] Optionally, the data exploration function implementation interface may further include a data exploration writing selection area; for example, the data exploration writing selection area may be as follows: Figure 3 The custom writing area shown in , etc., is not limited in this embodiment of the present invention.

[0059] S404 : responding to the detected area selection operation for the data exploration and writing selection area, and displaying the data exploration and writing area.

[0060] Optionally, the area selection operation on the data exploration and writing selection area may be a click operation on the data exploration and writing selection area, or a long press operation on the data exploration and writing selection area, etc., which is not limited in the embodiment of the present invention.

[0061] Optionally, the data exploration writing area may be located in the data exploration function implementation interface, or may not be located in the data exploration function implementation interface (such as displayed in the form of a pop-up window, etc.), and this embodiment of the present invention does not limit this.

[0062] Based on this, the user can write a data exploration script in the data exploration writing area to input the data exploration writing script in the data exploration writing area, thereby executing the data exploration writing script execution operation for the data exploration writing script. It should be noted that the embodiments of the present invention do not limit the specific implementation method of the data exploration writing script execution operation; for example, the data exploration writing area may include an execution button, and the data exploration writing script execution operation may refer to a click operation on the execution button, or a long press operation on the execution button, etc.

[0063] S405 , in response to a data exploration script execution operation detected in the data exploration script execution area, executing the data exploration script indicated by the data exploration script execution operation, thereby performing data exploration on the target database according to the data exploration function implemented by the data exploration script.

[0064] Based on this, the data exploration device can obtain scripted data exploration results in the target database based on the data exploration function implemented by the data exploration script; and / or can output the scripted data exploration results to a corresponding file directory, such as a target file directory. Optionally, the target file directory can be the same as or different from the specified file directory, which is not limited in this embodiment of the present invention.

[0065] An embodiment of the present invention can establish a connection with the target database through the target data exploration account and the data exploration key in the data exploration device when a database connection operation of the target data exploration account for the target database is detected; after completing the connection with the target database, a data exploration function implementation interface for the target database can be displayed, and the data exploration function implementation interface includes at least one data exploration function trigger area corresponding to the target database, and a data exploration function trigger area is used to trigger a templated data exploration function; when a data exploration function trigger operation for any data exploration function trigger area in at least one data exploration function trigger area is detected, data exploration can be performed on the target database according to the templated data exploration function corresponding to any data exploration function trigger area. Correspondingly, the data exploration function implementation interface may also include a data exploration writing selection area; based on this, it can respond to the detected area selection operation for the data exploration writing selection area and display the data exploration writing area; then, it can respond to the data exploration writing script execution operation detected in the data exploration writing area and execute the data exploration writing script indicated by the data exploration writing script execution operation, thereby performing data exploration on the target database according to the data exploration function implemented by the data exploration writing script. It can be seen that the embodiment of the present invention can conveniently implement data exploration through the templated data exploration function, and thus, by setting templates and automated exploration tools, it can solve the problem that customized statements executed by different people cannot be reused, as well as solve the problems that may lead to inaccurate data exploration results, time-consuming writing, and users needing to have learning costs for writing statements. It can also implement non-templated data exploration functions through custom editing of code, so as to quickly implement complex or personalized data exploration functions; based on this, the embodiment of the present invention can perform data exploration on the basic information and overall picture of the data in a simple, reliable and fast execution method, which can avoid the long-term data exploration caused by using other complex methods, resulting in a longer development cycle, or avoid data processing errors or even rework due to incorrect execution methods.

[0066] Based on the description of the relevant embodiments of the above data exploration method, the embodiment of the present invention further proposes a data exploration device, which can be a computer program (including program code) running in an electronic device; Figure 5 As shown, the data exploration device may include a connection unit 501 and a processing unit 502. The data exploration device may execute Figure 1 or Figure 4 The data exploration method shown, that is, the data exploration device can run the above units:

[0067] The connection unit 501 is configured to establish a connection with the target database by using the target data exploration account and the data exploration key in the data exploration device when a database connection operation of the target data exploration account to the target database is detected;

[0068] Processing unit 502 is configured to display a data exploration function implementation interface for the target database after completing the connection with the target database, wherein the data exploration function implementation interface includes at least one data exploration function triggering area corresponding to the target database, and each data exploration function triggering area is used to trigger a templated data exploration function;

[0069] The processing unit 502 is further configured to, when a data exploration function triggering operation is detected for any data exploration function triggering area in the at least one data exploration function triggering area, perform data exploration on the target database according to the templated data exploration function corresponding to any data exploration function triggering area.

[0070] In one embodiment, the processing unit 502 may further be configured to:

[0071] When a probe login operation is detected, performing identity authentication on the probe login account indicated by the probe login operation;

[0072] After the probe login account indicated by the probe login operation passes the identity authentication, the data probe key is obtained.

[0073] In another embodiment, a templated data exploration function is supported by a data exploration function templated script, and the processing unit 502 may be further configured to:

[0074] When detecting that a target editing account performs an editing operation on a templated script of a data exploration function of the target database, performing editing authority verification on the target editing account;

[0075] After the target editing account passes the editing authority verification, the target database is edited using the exploration function templated script according to the data exploration function templated script editing operation.

[0076] In another embodiment, the data exploration function implementation interface further includes a data exploration writing selection area, and the processing unit 502 can also be used to:

[0077] responding to a detected area selection operation on the data exploration and writing selection area, and displaying the data exploration and writing area;

[0078] In response to a data profiling script execution operation detected in the data profiling writing area, the data profiling script indicated by the data profiling script execution operation is executed, thereby performing data profiling on the target database according to the data profiling function implemented by the data profiling script.

[0079] In another embodiment, the data exploration function implementation interface further includes a data exploration function selection execution area, and the processing unit 502 may further be configured to:

[0080] In response to an area selection operation detected in the data exploration function selection execution area, a templated data exploration function selection interface is displayed, wherein the templated data exploration function selection interface includes a data exploration function selection area for each templated data exploration function of the at least one templated data exploration function corresponding to the target database, and each data exploration function selection area supports selection of the templated data exploration function corresponding to the corresponding data exploration function selection area;

[0081] In response to a templated data exploration function selection operation detected in the templated data exploration function selection interface, data exploration is performed on the target database according to one or more templated data exploration functions selected in the templated data exploration function selection operation.

[0082] In another embodiment, the target data exploration account has data exploration permissions for each database in at least one database, and the target data exploration account supports application for data exploration permissions for the at least one database through a unified data exploration permission approval process; wherein, the target database is a database in the at least one database.

[0083] According to one embodiment of the present invention, Figure 5 Each unit in the data exploration device shown can be individually or completely combined into one or several other units to form a unit, or one (or some) of the units can be further divided into multiple functionally smaller units to form a unit, which can achieve the same operation without affecting the realization of the technical effects of the embodiments of the present invention. The above-mentioned units are divided based on logical functions. In actual applications, the functions of one unit can also be implemented by multiple units, or the functions of multiple units can be implemented by one unit. In other embodiments of the present invention, any data exploration device can also include other units. In actual applications, these functions can also be implemented with the assistance of other units, and can be implemented by the collaboration of multiple units.

[0084] According to another embodiment of the present invention, the program can be executed by running a program on a general electronic device such as a computer including a central processing unit (CPU), a random access memory (RAM), a read-only memory (ROM), and other processing elements and storage elements. Figure 1 or Figure 4 A computer program (including program code) for each step involved in the corresponding method shown in Figure 5 The data exploration device shown in and the data exploration method of the embodiment of the present invention are implemented. The computer program can be recorded on a computer storage medium, for example, and loaded into the above-mentioned electronic device through the computer storage medium and run therein.

[0085] An embodiment of the present invention can establish a connection with the target database through the target data exploration account and the data exploration key in the data exploration device when a database connection operation of the target data exploration account for the target database is detected; after completing the connection with the target database, a data exploration function implementation interface for the target database can be displayed, and the data exploration function implementation interface includes at least one data exploration function trigger area corresponding to the target database, and one data exploration function trigger area is used to trigger a templated data exploration function; based on this, when a data exploration function trigger operation for any data exploration function trigger area in at least one data exploration function trigger area is detected, data exploration can be performed on the target database according to the templated data exploration function corresponding to any data exploration function trigger area. It can be seen that the embodiment of the present invention can display at least one data exploration function trigger area corresponding to the target database after the data exploration device establishes a connection with the target database, so as to perform data exploration on the target database through the templated data exploration function corresponding to any data exploration function trigger area, thereby conveniently performing data exploration to improve data exploration efficiency, and can limit the devices that establish a connection with the database through the target data exploration account and data exploration key, thereby achieving efficient data exploration through the templated data exploration function while preventing the data exploration authority of the target data exploration account from being leaked.

[0086] Based on the description of the above method and apparatus embodiments, exemplary embodiments of the present invention further provide a data exploration device, comprising: at least one processor; and a memory communicatively connected to the at least one processor. The memory stores a computer program executable by the at least one processor, and when executed by the at least one processor, the computer program causes the data exploration device to perform a method according to an embodiment of the present invention.

[0087] Exemplary embodiments of the present invention further provide a non-transitory computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor of a computer, is used to cause the computer to perform a method according to an embodiment of the present invention.

[0088] An exemplary embodiment of the present invention further provides a computer program product, comprising a computer program, wherein when the computer program is executed by a processor of a computer, the computer is configured to cause the computer to perform a method according to an embodiment of the present invention.

[0089] refer to Figure 6 , a structural block diagram of an electronic device 600 (i.e., an electronic device 600 constituting a data exploration device) that can serve as a server or client of the present invention will now be described, which is an example of a hardware device that can be applied to various aspects of the present invention. The electronic device is intended to represent various forms of digital electronic computer devices, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0090] like Figure 6 As shown, the electronic device 600 includes a computing unit 601, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 602 or a computer program loaded from a storage unit 608 into a random access memory (RAM) 603. Various programs and data required for the operation of the electronic device 600 can also be stored in the RAM 603. The computing unit 601, the ROM 602, and the RAM 603 are connected to each other via a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.

[0091] Multiple components within electronic device 600 are connected to I / O interface 605, including an input unit 606, an output unit 607, a storage unit 608, and a communication unit 609. Input unit 606 can be any type of device capable of inputting information into electronic device 600. Input unit 606 can receive input numeric or character information and generate key input signals related to user settings and / or function control of the electronic device. Output unit 607 can be any type of device capable of presenting information and may include, but is not limited to, a display, a speaker, a video / audio output terminal, a vibrator, and / or a printer. Storage unit 608 may include, but is not limited to, a magnetic disk or an optical disk. Communication unit 609 allows electronic device 600 to exchange information / data with other devices via computer networks such as the Internet and / or various telecommunication networks and may include, but is not limited to, a modem, a network card, an infrared communication device, a wireless communication transceiver and / or a chipset, such as a Bluetooth™ device, a WiFi device, a WiMax device, a cellular communication device, and / or the like.

[0092] The computing unit 601 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the computing unit 601 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various computing units that run machine learning model algorithms, digital signal processors (DSPs), and any appropriate processors, controllers, microcontrollers, etc. The computing unit 601 performs the various methods and processes described above. For example, in some embodiments, the data exploration method may be implemented as a computer software program that is tangibly contained in a machine-readable medium, such as a storage unit 608. In some embodiments, part or all of the computer program may be loaded and / or installed on the electronic device 600 via the ROM 602 and / or the communication unit 609. In some embodiments, the computing unit 601 may be configured to perform the data exploration method in any other appropriate manner (e.g., by means of firmware).

[0093] The program code for implementing the method of the present invention can be written in any combination of one or more programming languages. Such program code can be provided to a processor or controller of a general-purpose computer, a special-purpose computer, or other programmable data processing device so that when the program code is executed by the processor or controller, the functions / operations specified in the flow chart and / or block diagram are implemented. The program code can be executed entirely on the machine, partially on the machine, as a stand-alone software package, partially on the machine and partially on a remote machine, or entirely on a remote machine or server.

[0094] In the context of the present invention, machine-readable medium can be a tangible medium that can contain or store a program for use with an instruction execution system, device or equipment or used in combination with an instruction execution system, device or equipment. Machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. Machine-readable medium can include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. More specific examples of machine-readable storage media can include electrical connections based on one or more lines, portable computer disks, hard disks, random access memories (RAM), read-only memories (ROM), erasable programmable read-only memories (EPROM or flash memory), optical fibers, portable compact disk read-only memories (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0095] As used herein, the terms "machine-readable medium" and "computer-readable medium" refer to any computer program product, apparatus, and / or device (e.g., a magnetic disk, an optical disk, a memory, a programmable logic device (PLD)) for providing machine instructions and / or data to a programmable processor, including machine-readable media that receive machine instructions as machine-readable signals. The term "machine-readable signal" refers to any signal used to provide machine instructions and / or data to a programmable processor.

[0096] To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the computer. Other types of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic input, voice input, or tactile input).

[0097] The systems and techniques described herein can be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network (LAN), a wide area network (WAN), and the Internet.

[0098] Computer systems may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The client and server relationship arises through computer programs running on the respective computers and having a client-server relationship to each other.

[0099] Furthermore, it should be understood that the above disclosure is only a preferred embodiment of the present invention and certainly cannot be used to limit the scope of the present invention. Therefore, equivalent changes made according to the claims of the present invention are still within the scope of the present invention.

Claims

1. A data exploration method, characterized in that: The method is applied to a data exploration device, and includes: When a database connection operation of a target data exploration account to a target database is detected, establishing a connection with the target database by using the target data exploration account and a data exploration key in the data exploration device; After completing the connection with the target database, displaying a data exploration function implementation interface for the target database, the data exploration function implementation interface including at least one data exploration function triggering area corresponding to the target database, each data exploration function triggering area being used to trigger a templated data exploration function; When a data exploration function triggering operation is detected for any one of the at least one data exploration function triggering areas, data exploration is performed on the target database according to the templated data exploration function corresponding to any one of the data exploration function triggering areas.

2. The method according to claim 1, characterized in that The method further comprises: When a probe login operation is detected, performing identity authentication on the probe login account indicated by the probe login operation; After the probe login account indicated by the probe login operation passes the identity authentication, the data probe key is obtained.

3. The method according to claim 1 or 2, characterized in that A templated data exploration function is supported by a data exploration function templated script, and the method further includes: When detecting that a target editing account performs an editing operation on a templated script of a data exploration function of the target database, performing editing authority verification on the target editing account; After the target editing account passes the editing authority verification, the target database is edited using the exploration function templated script according to the data exploration function templated script editing operation.

4. The method according to claim 1 or 2, characterized in that The data exploration function implementation interface further includes a data exploration writing selection area, and the method further includes: responding to a detected area selection operation on the data exploration and writing selection area, and displaying the data exploration and writing area; In response to a data profiling script execution operation detected in the data profiling writing area, the data profiling script indicated by the data profiling script execution operation is executed, thereby performing data profiling on the target database according to the data profiling function implemented by the data profiling script.

5. The method according to claim 1 or 2, characterized in that The data exploration function implementation interface further includes a data exploration function selection execution area, and the method further includes: In response to an area selection operation detected in the data exploration function selection execution area, a templated data exploration function selection interface is displayed, wherein the templated data exploration function selection interface includes a data exploration function selection area for each templated data exploration function of the at least one templated data exploration function corresponding to the target database, and each data exploration function selection area supports selecting the templated data exploration function corresponding to the corresponding data exploration function selection area; In response to a templated data exploration function selection operation detected in the templated data exploration function selection interface, data exploration is performed on the target database according to one or more templated data exploration functions selected in the templated data exploration function selection operation.

6. The method according to claim 1 or 2, characterized in that The target data exploration account has data exploration permissions for each database in at least one database, and the target data exploration account supports application for data exploration permissions for the at least one database through a unified data exploration permission approval process; wherein, the target database is a database in the at least one database.

7. A data exploration device, characterized in that: The device runs on a data exploration device and includes: a connection unit configured to, upon detecting a database connection operation of a target data exploration account to a target database, establish a connection with the target database using the target data exploration account and a data exploration key in the data exploration device; a processing unit configured to display a data exploration function implementation interface for the target database after completing connection with the target database, wherein the data exploration function implementation interface includes at least one data exploration function triggering area corresponding to the target database, each data exploration function triggering area being configured to trigger a templated data exploration function; The processing unit is further configured to, when a data exploration function triggering operation is detected for any one of the at least one data exploration function triggering areas, perform data exploration on the target database according to the templated data exploration function corresponding to any one of the data exploration function triggering areas.

8. The device according to claim 7, characterized in that The processing unit is further configured to: When a probe login operation is detected, performing identity authentication on the probe login account indicated by the probe login operation; After the probe login account indicated by the probe login operation passes the identity authentication, the data probe key is obtained.

9. A data exploration device, characterized in that: include: processor; as well as Memory for storing programs, The program includes instructions, which, when executed by the processor, cause the processor to perform the method according to any one of claims 1 to 6.

10. A non-transitory computer-readable storage medium storing computer instructions, wherein: The computer instructions are used to enable a computer to execute the method according to any one of claims 1 to 6.

Images