CN112434042A - Data relationship construction method and device, electronic equipment and storage medium - Google Patents
Data relationship construction method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN112434042A CN112434042A CN202011398489.4A CN202011398489A CN112434042A CN 112434042 A CN112434042 A CN 112434042A CN 202011398489 A CN202011398489 A CN 202011398489A CN 112434042 A CN112434042 A CN 112434042A
- Authority
- CN
- China
- Prior art keywords
- target
- operation instruction
- name
- table name
- data warehouse
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application relates to the technical field of data processing, and discloses a method and a device for constructing a data relationship, electronic equipment and a storage medium, wherein the method comprises the following steps: replacing target parameters in the initial operation instruction for the target data warehouse with first table names corresponding to the target parameters to obtain a target operation instruction comprising the first table names, wherein the first table names are table names of a first table, and the first table is a data table for executing operation corresponding to the target operation instruction; acquiring a first table name included by the target operation instruction, and determining a dependency table corresponding to the first table from a second table stored in the target data warehouse according to the first table name; and establishing the corresponding relation of the first table and the dependency table. By implementing the embodiment of the application, the accuracy of the corresponding relation between the data tables established in the data warehouse can be improved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and an apparatus for constructing a data relationship, an electronic device, and a storage medium.
Background
The data warehouse is used as a data support system of various decision-making systems, and can be used for storing various service data daily used by the decision-making systems, so that the data warehouse can be conveniently requested at any time.
In practice, it is found that due to the large amount of data in the data warehouse, the decision system usually requests the data tables required by the business through the corresponding relationship between the data tables, so as to improve the requesting efficiency. However, the corresponding relationship established by the conventional method for establishing the corresponding relationship of the data table is low in accuracy, and is not beneficial to a decision system to ask for the data table required by the service through the corresponding relationship between the data tables.
Disclosure of Invention
The embodiment of the application discloses a method and a device for constructing a data relation, electronic equipment and a storage medium, which can improve the accuracy of the corresponding relation between data tables established in a data warehouse.
A first aspect of an embodiment of the present application discloses a method for constructing a data relationship, where the method includes:
replacing target parameters in an initial operation instruction for a target data warehouse with first table names corresponding to the target parameters to obtain a target operation instruction comprising the first table names, wherein the first table names are table names of first tables, and the first tables are data tables to be subjected to operation corresponding to the target operation instruction;
acquiring a first table name included in the target operation instruction, and determining a dependency table corresponding to the first table from a second table stored in the target data warehouse according to the first table name;
and establishing a corresponding relation between the first table and the dependency table.
A second aspect of the embodiments of the present application discloses a data relationship building apparatus, including:
a replacing unit, configured to replace a target parameter in an initial operation instruction for a target data warehouse with a first table name corresponding to the target parameter, so as to obtain a target operation instruction including the first table name, where the first table name is a table name of a first table, and the first table is a data table on which an operation corresponding to the target operation instruction is to be executed;
a determining unit, configured to obtain a first table name included in the target operation instruction, and determine, according to the first table name, a dependency table corresponding to the first table from a second table stored in the target data warehouse;
and the establishing unit is used for establishing the corresponding relation between the first table and the dependency table.
A third aspect of the embodiments of the present application discloses an electronic device, including:
a memory storing executable program code;
a processor coupled with the memory;
the processor calls the executable program code stored in the memory to execute the method for constructing the data relationship disclosed in the first aspect of the embodiment of the present application.
A fourth aspect of the embodiments of the present application discloses a computer-readable storage medium, which stores a computer program, wherein the computer program causes a computer to execute the method for constructing a data relationship disclosed in the first aspect of the embodiments of the present application.
A fifth aspect of embodiments of the present application discloses a computer program product, which, when run on a computer, causes the computer to perform part or all of the steps of any one of the methods of the first aspect of embodiments of the present application.
A sixth aspect of the present embodiment discloses an application publishing platform, where the application publishing platform is configured to publish a computer program product, where the computer program product, when running on a computer, causes the computer to perform part or all of the steps of any one of the methods in the first aspect of the present embodiment.
Compared with the prior art, the embodiment of the application has the following beneficial effects:
in the related art, when an operation instruction for a data warehouse is received, the operation instruction is usually directly analyzed to index a dependency table in the data warehouse according to the analyzed content, and in the embodiment of the application, it is considered that the direct analysis operation instruction is easy to cause analysis errors due to interference of reasons such as field renaming, code annotation information and the like, so that the subsequent indexing is performed on the wrong dependency table, and further the wrong corresponding relation is established. Therefore, when the operation instruction is received, the target operation in the initial operation instruction can be replaced by the corresponding first table name in a parameter replacement mode, and then the dependency table of the first table is matched in the plurality of second tables stored in the target data warehouse by using the characteristics that the error probability of the table names in the operation instruction is low and the table names cannot be swapped, so that the error probability of the matched dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings without creative efforts.
Fig. 1 is a schematic view of an application scenario of a construction method applicable to a data relationship disclosed in an embodiment of the present application;
FIG. 2 is a schematic flow chart diagram illustrating a method for constructing a data relationship disclosed in an embodiment of the present application;
FIG. 3 is a flow chart illustrating another method for constructing data relationships disclosed in the embodiments of the present application;
FIG. 4 is a flow chart illustrating a method for constructing a data relationship according to an embodiment of the present disclosure;
FIG. 5 is a schematic structural diagram of an apparatus for constructing data relationships disclosed in an embodiment of the present application;
FIG. 6 is a schematic structural diagram of another data relationship construction device disclosed in the embodiments of the present application;
fig. 7 is a schematic structural diagram of an electronic device disclosed in an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that the terms "first", "second", "third" and "fourth", etc. in the description and claims of the present application are used for distinguishing different objects, and are not used for describing a specific order. The terms "comprises," "comprising," and "having," and any variations thereof, of the embodiments of the present application, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The embodiment of the application discloses a method and a device for constructing a data relation, electronic equipment and a storage medium, which can improve the accuracy of the corresponding relation between data tables established in a data warehouse.
The technical solution of the present application will be described in detail with reference to specific examples.
In order to more clearly illustrate the method, the apparatus, the electronic device and the storage medium for constructing the data relationship disclosed in the embodiments of the present application. Firstly, an application scenario suitable for the data relationship construction method is introduced, and the data relationship construction method can be applied to construction of table level blood relationship in various data warehouses. The data warehouse is a theme-oriented, integrated, stable and historical change-reflecting data set and can be used for supporting various management decision systems; and the table-level consanguinity relationship represents the corresponding relationship among all tables stored in the data warehouse, so that the management decision system can rapidly ask for various tables required by the business through the consanguinity relationship.
In actual operation, when various management decision systems want to write or read data in a data warehouse, the data to be written or read can be indicated through operation instructions written in SQL (Structured Query Language) (of course, the operation instructions written in SQL also include operation instructions for modifying data, deleting data, etc., but are not limited thereto), and then the operation instructions are sent to an executor (e.g., a spark calculation engine, an SQL executor, etc., but are not limited thereto) for execution.
In an embodiment, as shown in fig. 1, the method for constructing a data relationship disclosed in the embodiment of the present application may intercept a target operation instruction that has been subjected to parameter replacement (for example, a parameter indicating a table name is replaced with a table name of a first table to be written into a data warehouse, a parameter indicating a date is replaced with a date, and the like, which is not limited herein) in a process that the management decision system 110 sends an operation instruction to the executor 120 to execute, and obtain the first table name included in the target operation instruction; and then, by utilizing the characteristics that the error probability of the table names in the operation instruction is low and the table names cannot be swapped, the dependency table of the first table is matched in the data warehouse according to the first table name, so that the error probability of the indexed dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved.
Referring to fig. 2, fig. 2 is a schematic flow chart of a method for constructing a data relationship, which is disclosed in the embodiment of the present application, and the method for constructing a data relationship can be applied to various electronic devices such as a personal computer, a notebook computer, a mobile phone, and various network servers. The method for constructing the data relationship can comprise the following steps:
202. target parameters in the initial operation instructions for the target data warehouse are replaced by first table names corresponding to the target parameters, so that the target operation instructions comprising the first table names are obtained, the first table names are table names of the first table, and the first table is a data table of operations corresponding to the target operation instructions to be executed.
The data warehouse can be provided with a plurality of data warehouses according to different types, sources or roles of data stored in the data warehouses, so that the management decision system can generate an initial operation instruction (an instruction written by SQL and used for reading, writing or changing data stored in the data warehouse) aiming at a target data warehouse (any one of the plurality of data warehouses is provided and is not limited herein) according to business requirements, optionally, the initial operation instruction can also be a shell script and is not limited herein), and the initial operation instruction is sent to an executor (for example, a spark calculation engine, an SQL executor and the like and is not limited herein) to be executed so as to access corresponding data resources in the target data warehouse.
In practice, it is found that, after the initial operation instruction for the target data warehouse is obtained, the initial operation instruction is usually directly parsed, and the corresponding data resource is accessed in the target data warehouse according to the parsed content. However, since the direct analysis of the initial operation instruction is prone to cause analysis errors due to interference of field renaming, code annotation information and the like, the related technology is prone to index the wrong dependency table, and further establish the wrong data corresponding relation. Therefore, according to the embodiment of the application, the initial operation instruction is not analyzed, the target operation in the initial operation instruction is replaced by the corresponding first table name in a parameter replacement mode, and then the dependency table of the first table is matched in the plurality of second tables stored in the target data warehouse by using the characteristics that the error probability of the table names in the operation instruction is low and the table names cannot be changed, so that the error probability of the matched dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved.
Therefore, before matching the dependency table, the electronic device needs to determine a first table name of the data table of the operation corresponding to the target operation instruction to be executed according to the parameters included in the initial operation instruction. In actual implementation, the initial operation instruction usually includes a plurality of different parameters to refer to different information, such as: the parameter indicating date information, the parameter indicating table name information, and the like are not limited herein. Therefore, when a certain target information carried by the initial operation instruction is modified, all the target information carried by the initial operation instruction can be uniformly modified only by modifying the parameters corresponding to the target information, and the maintenance is convenient.
Optionally, in step 202, before the initial operation instruction is sent to the actuator to be executed, the electronic device may replace the target parameter, which refers to the first table name in the initial operation instruction, with the first table name corresponding to the target parameter, so as to obtain the target operation instruction including the first table name, thereby facilitating the electronic device to extract the first table name subsequently.
In one embodiment, the electronic device may call an execution function in a public script (a program pre-stored by the electronic device and capable of replacing the first table name with the target parameter in the initial operation instruction by using the first table name corresponding to the target parameter, and delete the annotation information, so as to improve the efficiency of parameter replacement.
The initial operation command may be a data write command to the target data warehouse, a data read command to the target data warehouse, or the like, and is not limited herein. When the initial operation instruction is a data write instruction for the target data warehouse, the first table name recorded in the initial operation instruction may be a table name of a first table, and the first table is a table to be written into the target data warehouse.
In another embodiment, the electronic device may also replace other parameters included in the initial operation instruction with corresponding information, so as to realize visualization of the operation instruction, so that the user may intuitively know various attributes of the initial operation instruction. Optionally, the electronic device may replace the parameter indicating the date information in the initial operation instruction with the date information indicated by the parameter, so that the user can conveniently know the date information such as the generation date and the execution date of the initial operation instruction.
For example, assuming that the parameter a refers to the generation date of the initial operation instruction and the parameter b specifies the execution date of the initial operation instruction, the parameter a in the initial operation instruction may be replaced with the generation date of the initial operation instruction and the parameter b in the initial operation instruction may be replaced with the execution date of the initial operation instruction when performing parameter replacement.
204. And acquiring a first table name included by the target operation instruction, and determining a dependency table corresponding to the first table in a second table stored in the target data warehouse according to the first table name.
In the embodiment of the application, before the initial operation instruction is sent to the actuator to be executed, the electronic device replaces the target parameter, which refers to the first table name, in the initial operation instruction with the first table name corresponding to the target parameter, so as to obtain the target operation instruction including the first table name, and then the target operation instruction, which has executed the preprocessing operation such as parameter replacement, is usually sent to the actuator to be executed. After the target operation command is sent to the actuator for execution, the target operation command is usually analyzed and responded, which may cause disorder of information recorded in the target operation command. Therefore, in order to obtain an accurate table name, the electronic device can intercept the target operation instructions in the process that the target operation instructions are sent to the actuator, and obtain the first table name included in the target operation instructions to serve as a basis for subsequent dependency table matching, so that the accuracy of a subsequently matched dependency table is improved.
Furthermore, after the first table name is obtained, the electronic device may match the first table name with second table names of a plurality of second tables stored in the target data warehouse one by one to determine that a target second table with the second table name matching with the first table name is used as a dependency table corresponding to the first table, and because the table name recorded in the target operation instruction has a low error probability and is not available for replacement, the first table name obtained by the electronic device from the target operation instruction is usually correct, so that the accuracy of the dependency table corresponding to the first table matched according to the first table name is improved; in addition, the electronic equipment exhaustively exhausts all table names of the whole target data warehouse for matching, ensures that the matched dependency table is definitely an existing table, and avoids the matched code segments, table alias or other disordered characters, further reduces the error probability of the indexed dependency table, and improves the accuracy of the corresponding relation between the data tables established in the data warehouse.
206. And establishing a corresponding relation between the first table and the dependency table.
In the embodiment of the application, after determining the dependency table corresponding to the first table in the target data warehouse, the electronic device may write the first table and the dependency table into the result file together to establish a corresponding relationship between the first table and the dependency table. Optionally, after writing the first table and the dependency table thereof into the result file, the electronic device may analyze the content in the result file, perform a correction judgment and/or a filtering operation on the analyzed content, and further re-establish the corresponding relationship between the first table and the dependency table thereof, so as to improve the accuracy of the corresponding relationship between the established data tables.
In one practical application scenario, when a user browses news using a mobile browser, the browser typically breaks through advertisements in the news. In order to deliver the advertisements, the server corresponding to the mobile phone browser needs to generate a write instruction so as to write the first table recording the advertisement data into the advertisement delivery data warehouse. If the advertisement is a targeted advertisement targeted to be seen by the pregnant woman group, in order to avoid that other users who are not the pregnant woman group also see the advertisement, the construction device of the data relationship disclosed by the embodiment of the application can be used for intercepting a writing instruction generated by a server corresponding to the mobile phone browser, replacing a parameter of a first table name in the writing instruction, which is used for referring to the first table, with the first table name, and acquiring the first table name from the instruction; and then matching a second table recorded with the data of the pregnant women in the advertisement putting data warehouse according to the first table name, and establishing a corresponding relation between the first table and the dependence table. Therefore, the targeted advertisement can be targeted to be delivered to pregnant women, and the delivery efficiency of the advertisement is improved.
By implementing the method disclosed by each embodiment, it is considered that the direct analysis operation instruction is easy to cause analysis errors due to interference of reasons such as field renaming, code annotation information and the like, so that a wrong dependency table is subsequently indexed, and a wrong corresponding relation is established. Therefore, the first table name of the first table to be written into the data warehouse included in the operation instruction can be determined in a parameter replacement mode; and then, by utilizing the characteristics that the error probability of the table names in the operation instruction is low and the table names cannot be swapped, the dependency table of the first table is matched in the data warehouse by the first table name, so that the error probability of the indexed dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved.
Referring to fig. 3, fig. 3 is a schematic flow chart of another data relationship construction method disclosed in the embodiment of the present application, where the data relationship construction method can be applied to various electronic devices such as a personal computer, a notebook computer, a mobile phone, and various network servers. The method for constructing the data relationship can comprise the following steps:
302. and determining the parameters arranged at fixed positions in the initial operation instructions for the target data warehouse as target parameters.
As described above, in the embodiment of the present application, the initial operation instruction for the data warehouse may include a plurality of different parameters to refer to different information, such as: the parameter indicating date information, the parameter indicating table name information, and the like are not limited herein. In contrast, in order to avoid that the electronic device replaces all or part of the parameters indicating other information as the first table name by mistake when performing parameter replacement, the wrong table name is replaced. Alternatively, the electronic device may determine, as a target parameter referring to the first table name, a parameter arranged at a fixed position among a plurality of parameters included in the initial operation instruction for the data warehouse. For example, the electronic device may determine a second parameter arranged from the beginning among a plurality of parameters included in the initial operation instruction for the data warehouse as a target parameter referring to the first table name.
By implementing the method, the electronic equipment can be prevented from wrongly replacing all or part of parameters referring to other information as the first table name when parameter replacement is performed, and further the situation that the wrong table name is replaced is avoided.
304. And replacing the target parameters with the corresponding first table names according to the defined replacement relation so as to obtain the target operation instruction comprising the first table names.
In the embodiment of the application, the electronic device may first define a replacement relationship between the parameter included in the initial instruction and the information indicated by the parameter, and write the replacement relationship into a public script subsequently called by the electronic device, and then, when the electronic device runs the public script, replace the target parameter with the first table name according to the replacement relationship defined in the public script, so as to obtain the target operation instruction including the first table name.
In practice, it is found that the target operation instruction not only includes various parameters, but also often includes a code and annotation information for explaining the meaning of the code or the parameters, and the existence of the annotation information easily causes the subsequent electronic equipment to acquire an incorrect table name when acquiring the first table name included in the target operation instruction. Alternatively, after replacing the target parameter with the first table name according to the defined replacement relationship, the electronic device may delete the annotation information included in the initial operation instruction to obtain the target operation instruction including the first table name.
By implementing the method, the electronic equipment can delete the release information in the initial operation instruction, so that the content of the target operation instruction is cleaner, and the subsequent electronic equipment is prevented from acquiring an error table name when acquiring the first table name included in the target operation instruction.
306. And acquiring a first table name included by the target operation instruction, and determining a dependency table corresponding to the first table in a second table stored in the target data warehouse according to the first table name.
In the embodiment of the application, in the process that the electronic device replaces the target parameter in the initial operation instruction with the first table name to obtain the target operation instruction, the converted identifier may be further added to the target operation instruction to indicate that the target parameter in the target operation instruction has been replaced with the first table name, and the first table name may be extracted. Therefore, optionally, the electronic device may intercept, in the operation instruction (including the initial operation instruction and the target operation instruction) sent to the actuator for execution, the target operation instruction including the converted identifier, and obtain the first table name included in the intercepted target operation instruction.
By implementing the method, the electronic equipment can quickly and accurately intercept the target operation instruction which is subjected to preprocessing operations such as parameter replacement and the like through the converted identifier, so that the efficiency and the accuracy of obtaining the first table name are improved, and the efficiency and the accuracy of subsequent dependent table indexing are further improved.
After the electronic equipment acquires the first table name included in the target operation instruction; optionally, the electronic device may store the first table name in the first file, and add the first table name and other identification information (for example, the storage path of the file, the first table name, the data of the first table record corresponding to the first table name, the identification information of the target data warehouse, and the like, which are not limited herein) to the name of the first file, so that the electronic device may quickly determine various information of the stored first table name by reading the file name of the first file.
As described above, the data warehouse may be provided in plural numbers depending on the type, source, or role of data stored therein, so that it is not necessary for the electronic device to match the first table name with the second table stored in each data warehouse. Optionally, the electronic device may determine, from the multiple data warehouses, the target data warehouse corresponding to the identification information according to the identification information of the target data warehouse included in the name of the first file, for example, the identification information corresponding to the first table name includes "ad", and "ad" is an identifier of the advertisement delivery data warehouse, and then the electronic device may determine, from the multiple data warehouses, the advertisement delivery data warehouse and determine the advertisement delivery data warehouse as the target data warehouse. And the electronic device may determine, according to the first table name included in the name of the first file, a dependency table corresponding to the first table in the second table stored in the target data warehouse.
By implementing the method, after the first table name included by the target operation instruction is acquired, the electronic device can store the first table name into the file, and the file is named by the identification information corresponding to the first table name, so that the electronic device can conveniently and quickly determine various information of the first table name stored in the electronic device by reading the file name of the first file, and the efficiency of storing and reading the first table name is improved.
308. And establishing a corresponding relation between the first table and the dependency table.
By implementing the method disclosed in each embodiment, the first table name of the first table to be written into the data warehouse included in the operation instruction can be determined in a parameter replacement mode; further, by utilizing the characteristics that the table name error probability is low and the table name is not available for line replacement in the operation instruction, the dependency table of the first table is matched in the data warehouse by the first table name, so that the error probability of the indexed dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved; the release information in the initial operation instruction can be deleted, so that the content of the target operation instruction is cleaner, and the condition that the subsequent electronic equipment acquires the wrong table name when acquiring the first table name included in the target operation instruction is avoided; target operation instructions subjected to preprocessing operations such as parameter replacement can be quickly and accurately intercepted through the converted identifiers, so that the efficiency and accuracy of obtaining the first table name are improved, and the efficiency and accuracy of subsequent dependent table indexing are improved; after the first table name included by the target operation instruction is acquired, the first table name can be stored in the file, and the file is named by the identification information corresponding to the first table name, so that the electronic equipment can conveniently and quickly determine various information of the stored first table name by reading the file name of the first file, and the storage and reading efficiency of the first table name is improved.
Referring to fig. 4, fig. 4 is a schematic flow chart of another method for constructing a data relationship disclosed in the embodiment of the present application, where the method for constructing a data relationship can be applied to various electronic devices such as a personal computer, a notebook computer, a mobile phone, and various network servers. The method for constructing the data relationship can comprise the following steps:
402. target parameters in the initial operation instructions for the target data warehouse are replaced by first table names corresponding to the target parameters, so that the target operation instructions comprising the first table names are obtained, the first table names are table names of the first table, and the first table is a data table of operations corresponding to the target operation instructions to be executed.
404. And acquiring a first table name included by the target operation instruction, and matching the first table name with second table names of a plurality of second tables stored in the target data warehouse one by one to determine a target second table with the second table name matched with the first table name.
In this embodiment of the application, after obtaining the first table name included in the target operation instruction, the electronic device may obtain second table names of a plurality of second tables stored in the target data warehouse, and match the first table name with the plurality of second table names one by one (optionally, the electronic device may perform full character cycle matching on the first table name and the plurality of second table names one by one), so as to determine the target second table whose second table name matches the first table name. Therefore, the matched target second table is ensured to be the existing table, the matched code segments, table alias or other disordered characters can not occur, the error probability of the indexed dependency table is further reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved.
As an optional implementation manner, after matching the first table name with the second table names of the plurality of second tables stored in the target data warehouse one by one to determine a target second table whose second table name matches the first table name, the electronic device may obtain a third table and a fourth table from a metadata database used for constructing the target data warehouse, where the third table records the first identifier corresponding to each database included in the target data warehouse, and the fourth table records the second identifier corresponding to the second table included in each database.
It should be noted that, in the embodiment of the present application, the target data warehouse may be built based on Hive (Hive is a data warehouse tool, and an electronic device may build the target data warehouse based on the data warehouse tool). In practice, the target data warehouse built may include a plurality of databases so that there are different types of data, and each database includes a plurality of second tables of the same type. Wherein the second table name of each second table is generally composed of the corresponding second identifier and the corresponding first identifier of the database stored in the second table. The identifiers may be recorded in two tables in the metadata database of the target data warehouse, where a third table may be used to record the first identifiers corresponding to the respective databases included in the target database, and a fourth table may be used to record the second identifiers corresponding to the respective second tables included in each database.
In this regard, the electronic device may generate second table names of a plurality of second tables stored in the target data warehouse according to the third table and the fourth table, where each second table name is composed of a second identifier recorded in the fourth table by the corresponding second table and a first identifier corresponding to a database stored in the second table.
In an embodiment, the electronic device may store all the generated second table names into the second file, and add identification information corresponding to the target data warehouse (e.g., a data type stored in the target data warehouse, an amount of stored data, etc.) to the name of the second file, so that the electronic device may find the second file according to the name of the second file and read the second table name recorded by the second file.
By implementing the method, the electronic equipment can acquire the identification information from the metadata database for constructing the target data warehouse to generate the second table name of the second table stored in the target data warehouse, so that the second table name of the second table stored in the target data warehouse is not omitted and the accuracy of the second table name is ensured, thereby reducing the error probability of the matched dependency table and improving the accuracy of the corresponding relation between the data tables established in the data warehouse.
406. And determining the target second table as a dependency table corresponding to the first table.
In this embodiment of the application, after the first table name is matched with the second table names of the plurality of second tables stored in the target data warehouse one by one, the target second table whose second table name is matched with the first table name may be determined as the dependency table corresponding to the first table. The dependency table is a table having a corresponding relationship with the first table, for example, a pre-dependency table of the first table, and for example, data recorded in the dependency table is related to data recorded in the first table, and the like, and is not limited herein.
However, in practice it has been found that matching the second table name of the target second table with the first table name may be a partial match of the second table name with the first table name, for example: the first table name is "tbl _ hour" and the second table name is "tbl", where the first table name and "tbl" in the second table name match, but only the first table name can be said to contain "tbl", but not the target second table is a dependent table of the first table.
For this, optionally, the electronic device may add a non-null character (for example, an integer such as 0 to 9, an alphabet such as a to z, or an underline) to the second table name of the target second table to obtain a temporary second table name; furthermore, the electronic device may determine whether the temporary second table name still matches the first table name according to a regular expression (which may be set by a developer according to the added non-empty character, for example, "_ 0-9 a-z", "_ 0-9", and the like, but not limited thereto), and if the temporary second table name does not match the first table name, it indicates that the second table name of the target second table is completely matched with the first table name, but not partially matched, and the electronic device may determine the target second table as the dependency table corresponding to the first table.
By implementing the method, the electronic equipment can be prevented from determining the second table with the second table name only partially matched with the first table name as the dependency table corresponding to the first table, so that the error probability of the indexed dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved.
Optionally, the electronic device may read a first file recorded with a first table name and a second file recorded with a second table name of a second table stored in the target data warehouse, and convert all the table names recorded in the first file and the second file into lower case, so as to unify the characters into a standard, thereby facilitating subsequent processing; the electronic equipment can delete the annotation information in the first file and the second file, so that the influence of the annotation information on the subsequent table name matching is avoided; the electronic device may further match the first table name with the plurality of second table names one by one, add a non-null character in the second table name of the target second table whose second table name matches the first table name to obtain a temporary second table name, and if it is determined according to the regular expression that the temporary second table name does not match the first table name, it is determined that the second table name is completely matched with the first table name, but not partially matched, and the target second table is a dependent table corresponding to the first table.
408. And establishing a corresponding relation between the first table and the dependency table.
By implementing the method disclosed in each embodiment, the first table name of the first table to be written into the data warehouse included in the operation instruction can be determined in a parameter replacement mode; further, by utilizing the characteristics that the table name error probability is low and the table name is not available for line replacement in the operation instruction, the dependency table of the first table is matched in the data warehouse by the first table name, so that the error probability of the indexed dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved; the identification information can be acquired from the metadata database for constructing the target data warehouse to generate the second table name of the second table stored in the target data warehouse, so that the second table name of the second table stored in the target data warehouse is not omitted, and the accuracy of the second table name is ensured, so that the error probability of the matched dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved; and the second table with the second table name only partially matched with the first table name can be prevented from being determined as the dependency table corresponding to the first table, so that the error probability of the indexed dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved.
Referring to fig. 5, fig. 5 is a schematic structural diagram of a data relationship constructing apparatus disclosed in an embodiment of the present application, where the data relationship constructing apparatus may apply the electronic devices disclosed in the above embodiments, and the data relationship constructing apparatus may include: a replacing unit 501, a determining unit 502 and a establishing unit 503, wherein:
a replacing unit 501, configured to replace a target parameter in an initial operation instruction for a target data warehouse with a first table name corresponding to the target parameter, so as to obtain a target operation instruction including the first table name, where the first table name is a table name of a first table, and the first table is a data table on which an operation corresponding to the target operation instruction is to be executed;
a determining unit 502, configured to obtain a first table name included in the target operation instruction, and determine, according to the first table name, a dependency table corresponding to the first table in a second table stored in the target data warehouse;
the establishing unit 503 is configured to establish a corresponding relationship between the first table and the dependency table.
The construction device for implementing the data relationship considers that the direct analysis operation command is easy to cause analysis errors due to interference of reasons such as field renaming, code annotation information and the like, so that the subsequent index is carried out on an incorrect dependency table, and an incorrect corresponding relationship is further established. Therefore, the first table name of the first table to be written into the data warehouse included in the operation instruction can be determined in a parameter replacement mode; and then, by utilizing the characteristics that the error probability of the table names in the operation instruction is low and the table names cannot be swapped, the dependency table of the first table is matched in the data warehouse by the first table name, so that the error probability of the indexed dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved.
Referring to fig. 6, fig. 6 is a schematic structural diagram of another data relationship construction apparatus disclosed in the embodiments of the present application, and the data relationship construction apparatus can also apply the electronic devices disclosed in the embodiments. The data relationship building apparatus shown in fig. 6 may be optimized by the data relationship building apparatus shown in fig. 5, and compared with the data relationship building apparatus shown in fig. 5, the data relationship building apparatus shown in fig. 6 includes a replacing unit 501, configured to replace a target parameter in an initial operation instruction for a target data warehouse with a first table name corresponding to the target parameter, so as to obtain a target operation instruction including the first table name, specifically, the method may be:
a replacing unit 501, configured to determine, as a target parameter, a parameter arranged in a fixed position in an initial operation instruction for a target data warehouse; and replacing the target parameter with the corresponding first table name according to the defined replacement relation so as to obtain the target operation instruction comprising the first table name.
The device for constructing the data relationship can determine the first table name of the first table to be written into the data warehouse in the operation instruction in a parameter replacement mode; and then, by utilizing the characteristics that the error probability of the table names in the operation instruction is low and the table names cannot be swapped, the dependency table of the first table is matched in the data warehouse by the first table name, so that the error probability of the indexed dependency table is reduced, and the accuracy of the corresponding relation between the data tables established in the data warehouse is improved.
As an optional implementation manner, the replacement unit 501 is configured to replace the target parameter with the first table name according to the defined replacement relationship, and a manner of obtaining the target operation instruction including the first table name may specifically be:
and a replacing unit 501, configured to replace the target parameter with the first table name according to the defined replacement relationship, and delete the annotation information included in the initial operation instruction, so as to obtain the target operation instruction including the first table name, where the annotation information is information used for explaining a meaning of the code or the parameter included in the initial operation instruction.
By implementing the data relation construction device, the release information in the initial operation instruction can be deleted, so that the content of the target operation instruction is cleaner, and the subsequent acquisition of an error table name when the first table name included in the target operation instruction is acquired is avoided.
As an alternative implementation, the data relationship building apparatus shown in fig. 6 may further include: an adding unit 504, wherein:
an adding unit 504, configured to, after the determining unit 502 obtains the first table name included in the target operation instruction, store the first table name to the first file, and add the first table name and identification information corresponding to the target data warehouse to the name of the first file;
the way that the determining unit 502 is configured to determine, according to the first table name, the dependency table corresponding to the first table in the second table stored in the target data warehouse may specifically be:
a determining unit 502, configured to determine a target data warehouse according to the identification information included in the name of the first file; and determining a dependency table corresponding to the first table in a second table stored in the target data warehouse according to the first table name included in the name of the first file.
By implementing the data relation building device, after the first table name included in the target operation instruction is acquired, the first table name can be stored in the file, and the file is named by the identification information corresponding to the first table name, so that various kinds of information of the first table name stored in the file can be quickly determined by reading the file name of the first file, and the efficiency of storing and reading the first table name is improved.
As an optional implementation manner, the target operation instruction includes a converted identifier, which is used to indicate that the target parameter in the target operation instruction has been replaced by the first table name, and the manner that the determining unit 502 is used to obtain the first table name included in the target operation instruction may specifically be:
a determining unit 502, configured to intercept a target operation instruction including the converted identifier, in the operation instruction sent to the executor for execution; and acquiring a first table name included by the target operation instruction.
By implementing the data relation construction device, the target operation instruction subjected to preprocessing operations such as parameter replacement can be quickly and accurately intercepted through the converted identifier, so that the efficiency and the accuracy of obtaining the first table name are improved, and the efficiency and the accuracy of subsequent dependent table indexing are further improved.
As an optional implementation manner, the manner that the determining unit 502 is configured to determine, according to the first table name, the dependency table corresponding to the first table in the second table stored in the target data warehouse may specifically be:
a determining unit 502, configured to match the first table name with second table names of multiple second tables stored in the target data warehouse one by one, so as to determine a target second table whose second table name matches the first table name; and determining the target second table as a dependency table corresponding to the first table.
The construction device for implementing the data relation exhaustively exhausts all table names of the whole target data warehouse for matching, ensures that the matched dependency table is definitely an existing table, and does not appear to be matched by code segments, table aliases or other disordered characters, reduces the error probability of the indexed dependency table, and improves the accuracy of the corresponding relation between the data tables established in the data warehouse.
As an optional implementation manner, the manner that the determining unit 502 is used to determine the target second table as the dependency table corresponding to the first table may specifically be:
a determining unit 502, configured to add a non-empty character in the second table name of the target second table to obtain a temporary second table name; and if the temporary second table name is judged not to be matched with the first table name according to the regular expression, determining the target second table as a dependency table corresponding to the first table.
By implementing the data relation building device, the second table with the second table name only partially matched with the first table name can be prevented from being determined as the dependency table corresponding to the first table, so that the error probability of the indexed dependency table is reduced, and the accuracy of the corresponding relation between the data tables built in the data warehouse is improved.
As an alternative implementation, the data relationship building apparatus shown in fig. 6 may further include: an acquisition unit 505 and a generation unit 506, wherein:
an obtaining unit 505, configured to, before the determining unit 502 matches the first table name with second table names of multiple second tables stored in the target data warehouse one by one to determine a target second table whose second table name matches the first table name, obtain a third table and a fourth table from a metadata base used for constructing the target data warehouse, where the third table records first identifiers corresponding to the databases included in the target data warehouse, and the fourth table records second identifiers corresponding to the second tables included in the databases;
a generating unit 506, configured to generate second table names of multiple second tables stored in the target data warehouse according to the third table and the fourth table, where each second table name is composed of a second identifier corresponding to a corresponding second table and a first identifier corresponding to a database stored in the corresponding second table.
The device for constructing the data relationship can acquire the identification information from the metadata database for constructing the target data warehouse to generate the second table name of the second table stored in the target data warehouse, so as to ensure that the second table name of the second table stored in the target data warehouse is not omitted and the accuracy of the second table name is ensured, thereby reducing the error probability of the matched dependency table and improving the accuracy of the corresponding relationship between the data tables established in the data warehouse.
Referring to fig. 7, fig. 7 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure. As shown in fig. 7, the electronic device may include:
a memory 701 in which executable program code is stored;
a processor 702 coupled to the memory 701;
the processor 702 calls the executable program code stored in the memory 701 to execute the data relationship construction method disclosed in each of the above embodiments.
The embodiment of the application discloses a computer-readable storage medium, which stores a computer program, wherein the computer program enables a computer to execute the data relationship construction method disclosed by each embodiment.
The embodiment of the present application also discloses an application publishing platform, wherein the application publishing platform is used for publishing a computer program product, and when the computer program product runs on a computer, the computer is caused to execute part or all of the steps of the method in the above method embodiments.
It should be appreciated that reference throughout this specification to "one embodiment" or "an embodiment" means that a particular feature, structure or characteristic described in connection with the embodiment is included in at least one embodiment of the present application. Thus, the appearances of the phrases "in one embodiment" or "in an embodiment" in various places throughout this specification are not necessarily all referring to the same embodiment. Furthermore, the particular features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. Those skilled in the art should also appreciate that the embodiments described in this specification are all alternative embodiments and that the acts and modules involved are not necessarily required for this application.
In various embodiments of the present application, it should be understood that the size of the serial number of each process described above does not mean that the execution sequence is necessarily sequential, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated units, if implemented as software functional units and sold or used as a stand-alone product, may be stored in a computer accessible memory. Based on such understanding, the technical solution of the present application, which is a part of or contributes to the prior art in essence, or all or part of the technical solution, may be embodied in the form of a software product, stored in a memory, including several requests for causing a computer device (which may be a personal computer, a server, a network device, or the like, and may specifically be a processor in the computer device) to execute part or all of the steps of the above-described method of the embodiments of the present application.
It will be understood by those skilled in the art that all or part of the steps in the methods of the embodiments described above may be implemented by hardware instructions of a program, and the program may be stored in a computer-readable storage medium, where the storage medium includes Read-Only Memory (ROM), Random Access Memory (RAM), Programmable Read-Only Memory (PROM), Erasable Programmable Read-Only Memory (EPROM), One-time Programmable Read-Only Memory (OTPROM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Compact Disc Read-Only Memory (CD-ROM), or other Memory, such as a magnetic disk, or a combination thereof, A tape memory, or any other medium readable by a computer that can be used to carry or store data.
The method, the apparatus, the electronic device, and the storage medium for constructing a data relationship disclosed in the embodiments of the present application are described in detail above, and a specific example is applied in the present application to explain the principle and the implementation of the present application, and the description of the above embodiments is only used to help understand the method and the core idea of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present application.
Claims (11)
1. A method for constructing data relationships, the method comprising:
replacing target parameters in an initial operation instruction for a target data warehouse with first table names corresponding to the target parameters to obtain a target operation instruction comprising the first table names, wherein the first table names are table names of first tables, and the first tables are data tables to be subjected to operation corresponding to the target operation instruction;
acquiring a first table name included in the target operation instruction, and determining a dependency table corresponding to the first table from a second table stored in the target data warehouse according to the first table name;
and establishing a corresponding relation between the first table and the dependency table.
2. The method according to claim 1, wherein replacing a target parameter in the initial operation instruction for the target data warehouse with a first table name corresponding to the target parameter to obtain a target operation instruction including the first table name comprises:
determining parameters arranged at fixed positions in the initial operation instructions for the target data warehouse as target parameters;
and replacing the target parameters with the corresponding first table names according to the defined replacement relation so as to obtain the target operation instruction comprising the first table names.
3. The method of claim 2, wherein replacing the target parameter with the first table name according to a defined replacement relationship to obtain a target operation instruction including the first table name comprises:
replacing the target parameter with the first table name according to a defined replacement relationship, and deleting annotation information included in the initial operation instruction to obtain the target operation instruction including the first table name, wherein the annotation information is information for explaining the meaning of a code or a parameter included in the initial operation instruction.
4. The method of claim 1, wherein after the obtaining the first table name included in the target operation instruction, the method further comprises:
storing the first table name to a first file, and adding the first table name and identification information corresponding to the target data warehouse in the name of the first file;
and determining a dependency table corresponding to the first table in a second table stored in a target data warehouse according to the first table name, including:
determining a target data warehouse according to the identification information included in the name of the first file;
and determining a dependency table corresponding to the first table in a second table stored in the target data warehouse according to the first table name included in the name of the first file.
5. The method according to any one of claims 1 to 4, wherein the target operation instruction comprises a converted identifier, and the converted identifier is used for indicating that a target parameter in the target operation instruction has been replaced by a first table name; and the obtaining of the first table name included in the target operation instruction includes:
intercepting a target operation instruction comprising the converted identifier in an operation instruction sent to an actuator for execution;
and acquiring a first table name included by the target operation instruction.
6. The method of claim 1, wherein determining, from the first table name, a dependency table corresponding to the first table in a second table stored in a target data warehouse comprises:
matching the first table name with second table names of a plurality of second tables stored in the target data warehouse one by one to determine a target second table with the second table name matched with the first table name;
and determining the target second table as a dependency table corresponding to the first table.
7. The method of claim 6, wherein determining the target second table as the dependency table corresponding to the first table comprises:
adding non-null characters in the second table name of the target second table to obtain a temporary second table name;
and if the temporary second table name is judged not to be matched with the first table name according to the regular expression, determining that the target second table is a dependent table corresponding to the first table.
8. The method of any of claims 6 or 7, wherein prior to said matching said first table name to a second table name of a plurality of second tables stored by said target data warehouse one by one to determine a target second table having a second table name matching said first table name, said method further comprises:
acquiring a third table and a fourth table from a metadata database for constructing a target data warehouse, wherein the third table records first identifications corresponding to all databases included in the target data warehouse, and the fourth table records second identifications corresponding to all second tables included in all databases;
and generating second table names of a plurality of second tables stored in the target data warehouse according to the third table and the fourth table, wherein each second table name consists of a second identifier corresponding to the corresponding second table and a first identifier corresponding to a database stored in the corresponding second table.
9. An apparatus for building data relationships, comprising:
a replacing unit, configured to replace a target parameter in an initial operation instruction for a target data warehouse with a first table name corresponding to the target parameter, so as to obtain a target operation instruction including the first table name, where the first table name is a table name of a first table, and the first table is a data table on which an operation corresponding to the target operation instruction is to be executed;
a determining unit, configured to obtain a first table name included in the target operation instruction, and determine, according to the first table name, a dependency table corresponding to the first table from a second table stored in the target data warehouse;
and the establishing unit is used for establishing the corresponding relation between the first table and the dependency table.
10. An electronic device comprising a memory storing executable program code, and a processor coupled with the memory; the processor calls the executable program codes stored in the memory to execute the data relationship construction method of any one of claims 1 to 8.
11. A computer-readable storage medium storing a computer program, wherein the computer program causes a computer to execute the method of constructing a data relationship according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011398489.4A CN112434042A (en) | 2020-12-03 | 2020-12-03 | Data relationship construction method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011398489.4A CN112434042A (en) | 2020-12-03 | 2020-12-03 | Data relationship construction method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112434042A true CN112434042A (en) | 2021-03-02 |
Family
ID=74691807
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011398489.4A Pending CN112434042A (en) | 2020-12-03 | 2020-12-03 | Data relationship construction method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112434042A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103902653A (en) * | 2014-02-28 | 2014-07-02 | 珠海多玩信息技术有限公司 | Method and device for creating data warehouse table blood relationship graph |
| CN106055582A (en) * | 2016-05-20 | 2016-10-26 | 中国农业银行股份有限公司 | Method and apparatus for replacing table name of database |
| US20190005086A1 (en) * | 2017-07-02 | 2019-01-03 | Equalum Ltd. | System and method for system for determining database relations based on data monitoring |
| CN111309726A (en) * | 2020-01-17 | 2020-06-19 | 北京明略软件系统有限公司 | Directed graph generation method and device and readable storage medium |
| CN111639143A (en) * | 2020-06-05 | 2020-09-08 | 广州市玄武无线科技股份有限公司 | Data blood relationship display method and device of data warehouse and electronic equipment |
| CN111695071A (en) * | 2020-07-14 | 2020-09-22 | 深圳市欢太科技有限公司 | Page display method and related device |
-
2020
- 2020-12-03 CN CN202011398489.4A patent/CN112434042A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103902653A (en) * | 2014-02-28 | 2014-07-02 | 珠海多玩信息技术有限公司 | Method and device for creating data warehouse table blood relationship graph |
| CN106055582A (en) * | 2016-05-20 | 2016-10-26 | 中国农业银行股份有限公司 | Method and apparatus for replacing table name of database |
| US20190005086A1 (en) * | 2017-07-02 | 2019-01-03 | Equalum Ltd. | System and method for system for determining database relations based on data monitoring |
| CN111309726A (en) * | 2020-01-17 | 2020-06-19 | 北京明略软件系统有限公司 | Directed graph generation method and device and readable storage medium |
| CN111639143A (en) * | 2020-06-05 | 2020-09-08 | 广州市玄武无线科技股份有限公司 | Data blood relationship display method and device of data warehouse and electronic equipment |
| CN111695071A (en) * | 2020-07-14 | 2020-09-22 | 深圳市欢太科技有限公司 | Page display method and related device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111459985B (en) | Identification information processing method and device | |
| CN111506559B (en) | Data storage method, device, electronic equipment and storage medium | |
| CN111339171B (en) | Data query method, device and equipment | |
| CN109241384B (en) | Scientific research information visualization method and device | |
| CN112269816B (en) | Government affair appointment correlation retrieval method | |
| CN110134681B (en) | Data storage and query method and device, computer equipment and storage medium | |
| CN110109981B (en) | Information display method and device for work queue, computer equipment and storage medium | |
| CN106202440B (en) | Data processing method, device and equipment | |
| CN109241075A (en) | Processing method, equipment and the computer readable storage medium of index basic data | |
| CN109739938A (en) | A kind of correlating method, device and the equipment of more accounts | |
| CN111026613B (en) | Log processing method and device | |
| US20200311125A1 (en) | Information processing apparatus and non-transitory computer readable medium storing program | |
| CN112434042A (en) | Data relationship construction method and device, electronic equipment and storage medium | |
| CN115732052A (en) | Case report table generation method and device based on structured clinical project | |
| CN115098738A (en) | Service data extraction method and device, storage medium and electronic equipment | |
| CN111563123B (en) | Real-time synchronization method for hive warehouse metadata | |
| CN110851517A (en) | Source data extraction method, device and equipment and computer storage medium | |
| CN114153830B (en) | Data verification method and device, computer storage medium and electronic equipment | |
| CN113840020B (en) | Positioning method and device based on IP address information, electronic equipment and storage medium | |
| CN111079391B (en) | Report generation method and device | |
| CN110515923B (en) | Data migration method and system between distributed databases | |
| CN109783131B (en) | Method, device and equipment for acquiring version function difference and storage medium | |
| CN116450805A (en) | Text processing method, device, equipment and storage medium | |
| CN111061721B (en) | Data processing method and device | |
| CN116562241A (en) | Annotation adding method, annotation adding device, computer equipment and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |