CN110837365A - Script aided design method and device based on root table - Google Patents
Script aided design method and device based on root table Download PDFInfo
- Publication number
- CN110837365A CN110837365A CN201911089735.5A CN201911089735A CN110837365A CN 110837365 A CN110837365 A CN 110837365A CN 201911089735 A CN201911089735 A CN 201911089735A CN 110837365 A CN110837365 A CN 110837365A
- Authority
- CN
- China
- Prior art keywords
- keyword
- query instruction
- dimension
- index
- source data
- 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
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/33—Intelligent editors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/40—Transformation of program code
- G06F8/41—Compilation
- G06F8/44—Encoding
- G06F8/443—Optimisation
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a script aided design method and a script aided design device based on a root table, wherein the method specifically comprises the following steps: establishing a keyword table; establishing a caliber system based on the keyword table; acquiring Chinese keywords corresponding to a query instruction input by a user by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table; and generating a target query instruction according to the English keyword corresponding to the acquired query instruction, and writing attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template to generate a target script. The implementation of the invention can ensure that the keyword data is standard and uniform, is easy to maintain, does not need to repeatedly establish scripts, avoids repeated labor and saves workload.
Description
Technical Field
The invention relates to the field of scripts, in particular to a script aided design method and device based on a root word list.
Background
A Script (Script) is an extension of a batch file, and is a program for storing plain text, and a general computer Script program is a definite series of combinations for controlling a computer to perform operation actions, in which certain logic branches can be implemented, and the Script can be usually called and executed temporarily by an application program.
However, in the prior art, each modeling is performed by rewriting a script, acquiring corresponding key field data according to a dimension-index combination, and establishing a table, but this way is not only heavy in workload, but also the key field data is not uniform in specification, which causes a lot of repeated labor, and meanwhile, the code length is increased, and thus, the method is not easy to maintain.
Disclosure of Invention
The embodiment of the invention provides a script aided design method and device based on a root table, and mainly aims to solve the problems that in the prior art, corresponding key field data are obtained according to dimension-index combination, when a table is established, not only is the workload large, but also the key field data are not unified and standard, so that a large amount of repeated labor is caused, meanwhile, the code length is increased, and the maintenance is difficult.
In a first aspect, an embodiment of the present invention provides a script aided design method based on a root table, which specifically includes:
establishing a keyword table;
based on keywords of the keyword table, selecting at least one keyword as a dimension keyword and an index keyword according to a preset rule, automatically generating a dimension-index combination according to the dimension keyword and the index keyword, and establishing a caliber system through the dimension-index combination;
receiving a query instruction input by a user, acquiring Chinese keywords corresponding to the query instruction by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table;
and generating a target query instruction according to the English keyword corresponding to the acquired query instruction, and writing attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template to generate a target script.
In a second aspect, the present invention further provides a script aided design apparatus based on a root table, where the apparatus includes:
the first establishing module is used for establishing a keyword table;
the second establishing module is used for selecting at least one keyword as a dimension keyword and an index keyword according to a preset rule based on the keywords of the keyword table, automatically generating a dimension-index combination according to the dimension keyword and the index keyword, and establishing a caliber system through the dimension-index combination;
the English keyword acquisition module is used for receiving a query instruction input by a user, acquiring Chinese keywords corresponding to the query instruction by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table;
and the script generation module is used for generating a target query instruction according to the obtained English keyword corresponding to the query instruction, writing the attribute information corresponding to the target query instruction into the template attribute corresponding to the preset script template, and generating a target script.
In a third aspect, the present invention provides a script aided design apparatus based on a root table, the apparatus including a memory, a processor and a computer program stored in the memory and operable on the processor, wherein the processor implements some or all of the steps of any one of the script aided design methods based on a root table described in the above embodiments when executing the computer program.
In a fourth aspect, the present invention further provides a computer storage medium, where the computer storage medium may store a program, and when the program is executed, the program implements part or all of the steps of any one of the script aided design methods based on the root word table described in the above embodiments.
Has the advantages that: according to the embodiment of the invention, a keyword table is established in advance, at least one keyword is selected as a dimension keyword and an index keyword according to a preset rule based on the keyword of the keyword table, a dimension-index combination is automatically generated according to the dimension keyword and the index keyword, and a caliber system is established through the dimension-index combination; receiving a query instruction input by a user, acquiring Chinese keywords corresponding to the query instruction by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table; and generating a target query instruction according to the English keyword corresponding to the acquired query instruction, and writing attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template to generate a target script. In conclusion, the English keywords corresponding to the query instruction are obtained through the preset Chinese and English comparison root table, so that the keyword data are standard and uniform, the later maintenance is easy, meanwhile, the auxiliary design of the script is completed by utilizing the preset script template, the script does not need to be repeatedly established, a large amount of repeated labor is avoided, the code length is shortened, and the workload is saved.
These and other aspects of the invention are apparent from and will be elucidated with reference to the embodiments described hereinafter.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic flowchart of a script aided design method based on a root table according to an embodiment of the present invention;
fig. 2 is a schematic flowchart illustrating a process of creating a keyword table in another script aided design method based on a root table according to an embodiment of the present invention;
fig. 3 is a schematic flowchart illustrating a process of establishing a caliber system in another script aided design method based on a root table according to an embodiment of the present invention;
fig. 4 is a flowchart illustrating another script aided design method based on a root table according to a third embodiment of the present invention;
fig. 5 is a schematic structural diagram of a script aided design apparatus based on a root table according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of a script aided design apparatus based on a root table according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, 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 invention.
The following are detailed below.
The terms "first," "second," "third," and "fourth," etc. in the description and claims of the invention and in the accompanying drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus. The term "and/or" is used to describe an associative relationship of associated objects, meaning that three relationships may exist, e.g., a and/or B, may mean: a exists alone, A and B exist simultaneously, and B exists alone. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the invention. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is explicitly and implicitly understood by one skilled in the art that the embodiments described herein can be combined with other embodiments.
Embodiments of the present application are described below with reference to the drawings.
Example one
According to an aspect of the present invention, there is provided a script aided design method based on a root table, specifically including the following steps, as shown in fig. 1:
s1, establishing a keyword table;
it should be noted that the execution subject of the embodiment of the present invention is a data management server, the data management server is composed of one or more computers running in a local area network and data management system software, and the data management server provides a management service for user data.
Specifically, a source data table when data in a data warehouse is checked every day can be counted, wherein the source data table comprises table names, description fields and description information corresponding to the description fields, keywords are extracted from the description information in each row of source data in the counted source data table, the extracted keywords are generated into a keyword table, and the keywords in the keyword table correspond to the description information in each row of source data one to one.
S2, based on keywords of the keyword table, selecting at least one keyword as a dimension keyword and an index keyword according to a preset rule, automatically generating a dimension-index combination according to the dimension keyword and the index keyword, and establishing an aperture system through the dimension-index combination;
selecting at least one keyword from each generated keyword table according to a preset rule as a dimension keyword of the keyword table, and setting the dimension keyword as the dimension of the caliber system; and selecting at least one keyword as an index keyword of the keyword table, and setting the dimension keyword as an index of the caliber system. The index is the attribute value of the dimension set above, for example, the dimension is a city, the corresponding index is Shenzhen, and Shenzhen is the attribute value of the dimension of the city.
The selected dimension key words and the selected index key words are automatically generated into dimension-index combinations, such as city-Shanghai, source data of which the login city is Shanghai are inquired from a data warehouse if necessary, the corresponding data query instructions are automatically generated according to the generated flow web page access daily table-city-Shanghai, wherein the flow web page access daily table is a table name required in the data query instructions, the field name can be determined as city according to the flow web page access daily table and the dimension, the corresponding query instructions are generated according to the determined table name, the field name and the dimension-index combinations, and further, the query instructions corresponding to all the dimension-index combinations can be generated through a traversal principle. And establishing an aperture system by using the dimension-index combination and the corresponding query instruction. The caliber system comprises a table name, a table field, dimension keywords, index keywords and query instructions corresponding to all dimension-index combinations. And the corresponding query instruction is automatically generated according to the dimension-index combination, and the corresponding query instruction is executed when the query is needed, so that the required source data can be queried from the data warehouse, the workload of a user is reduced, and the data processing efficiency is improved.
S3, receiving a query instruction input by a user, acquiring Chinese keywords corresponding to the query instruction by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table;
receiving a query instruction input by a user, and acquiring a Chinese keyword corresponding to the query instruction according to the established aperture system, specifically, the query instruction comprises a dimension-index combination for setting a query condition, matching the dimension-index combination in the query instruction with the dimension-index combination in the aperture system, and acquiring a successfully matched dimension key and index key, namely the Chinese keyword corresponding to the query instruction.
It should be noted that the preset chinese-english comparison root table is a comparison table of a chinese root and an english root, for example, as shown in table 1 below:
TABLE 1
And performing contrast translation on the Chinese keywords corresponding to the query instruction acquired through the aperture system by using the Chinese and English contrast root table set in the table 1 to acquire English keywords corresponding to the Chinese keywords of the query instruction, so that the keyword data are standard and uniform, and later maintenance is facilitated.
And S4, generating a target query instruction according to the English keyword corresponding to the acquired query instruction, writing attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template, and generating a target script.
It should be noted that, a target query instruction is generated according to the english keywords unified by the specification, and attribute information corresponding to the target query instruction includes a query condition, a query step, and a query result, where the query condition is a query condition defined by a dimension and an index, for example, a query instruction in which the query dimension is a city and the index is an access number is queried from a data warehouse, and the query condition of the query instruction is defined by the city and the access number; in the query step, the sequence of the source data is extracted from the data warehouse in the query instruction execution process, for example, the query instruction with the dimensionality of a city and the index of the access frequency is queried from the data warehouse, and the query step is to extract the source data with the dimensionality of the city first and then extract the source data with the index of the access frequency from the extracted source data with the dimensionality of the city; the query result may be a manner of feeding back the source data obtained by the query after executing the query instruction, for example, but not limited to, a table, a bar chart, or a thermodynamic diagram, and the like. The attribute information corresponding to the query instruction is written into the template attribute corresponding to the preset script template to generate the target script, so that the script template can be repeatedly used, and the attribute information corresponding to the query instruction can be automatically written into the template attribute of the preset script template aiming at different query instructions to generate the target script without repeatedly establishing the script, thereby avoiding a large amount of repeated labor, shortening the code length and saving the workload; of course, different types of script templates can be set according to the needs of actual situations to meet the query requirements of source data of different subject categories or the query requirements of source data of different application scenarios, thereby further improving the query efficiency of source data.
Has the advantages that: according to the embodiment of the invention, a keyword table is established in advance, at least one keyword is selected as a dimension keyword and an index keyword according to a preset rule based on the keyword of the keyword table, a dimension-index combination is automatically generated according to the dimension keyword and the index keyword, and a caliber system is established through the dimension-index combination; receiving a query instruction input by a user, acquiring Chinese keywords corresponding to the query instruction by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table; and generating a target query instruction according to the English keyword corresponding to the acquired query instruction, and writing attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template to generate a target script. In conclusion, the English keywords corresponding to the query instruction are obtained through the preset Chinese and English comparison root table, so that the keyword data are standard and uniform, the later maintenance is easy, meanwhile, the auxiliary design of the script is completed by utilizing the preset script template, the script does not need to be repeatedly established, a large amount of repeated labor is avoided, the code length is shortened, and the workload is saved.
Example two
On the basis of the above embodiment, the present invention further provides a script aided design method based on a root table, which specifically includes the following steps, as shown in fig. 2:
s1, establishing a keyword table;
the specific implementation of step S1 has been described in detail in the foregoing embodiments, and is not described herein again, and further, step S1 may also implement the following steps to establish the keyword table, specifically as follows:
s11, checking the data warehouse at intervals of preset time, and counting a source data table generated in the preset time, wherein the source data table comprises description fields;
and checking the data warehouse at preset time intervals, such as every day, verifying whether the original data in the data warehouse and the final data after daily updating are balanced or not, so that a user can extract and clean data with value for enterprises from the source data, and the source data in the data warehouse, which is unbalanced with the original data after daily updating, is cleaned and finally stored in the data warehouse. The data in the data warehouse will typically be retained for long periods of time for the enterprise to perform query operations for enterprise decision-making. Therefore, the data warehouse is checked every day, and the data base for the enterprise to perform query operation is provided.
And S12, replacing the description information in the description field by using keywords to establish a keyword table.
And counting a source data table generated in the preset time, wherein the source data table comprises at least one description field, the description field comprises corresponding description information, and the corresponding description information in the description field is replaced by keywords to establish a keyword table.
It should be noted that the keywords in the keyword table uniquely correspond to the description information corresponding to each line of source data. For example as shown in table 2 below:
TABLE 2
Table 2 is a keyword table 2 created after the description information in the traffic Web page access history table is replaced with keywords according to the definitions of the source data table.
As further shown in table 3 below:
TABLE 3
Table 3 is a keyword table 3 created after the description information in the traffic Web page access calendar is replaced with keywords according to the definitions of the source data table.
S2, based on keywords of the keyword table, selecting at least one keyword as a dimension keyword and an index keyword according to a preset rule, automatically generating a dimension-index combination according to the dimension keyword and the index keyword, and establishing an aperture system through the dimension-index combination;
as shown in fig. 3, the step S2 of establishing the caliber system may specifically include the following steps:
preferably, on the basis of the above embodiment, in step S2, based on the keywords in the keyword table, at least one of the keywords is selected as a dimension keyword according to a preset rule, which specifically includes:
s21, acquiring a first source data table in the source data tables, and determining at least one primary key in the first source data table;
randomly acquiring a first source data table from a source data table generated in the process of checking the data warehouse within the preset time, determining at least one primary key in the first source data table, wherein the primary key is also called a primary key (primary key) and is a unique key in the table, the value of the primary key is used for uniquely identifying a certain record in the table, and a certain row of data in the table or a certain entity can be uniquely determined.
S22, calculating the times of taking at least one primary key in each first source data table as a foreign key, and selecting the primary key with the times of taking the foreign key being more than or equal to a preset time threshold value from the at least one primary key in the first source data table as a dimension key of the first source data table;
or, preferably, calculating a proportion of at least one primary key in each first source data table as a foreign key, and selecting the primary key, as the foreign key, of which the proportion is greater than or equal to a preset proportion threshold value from the at least one primary key in the first source data table as a dimension key of the first source data table, where the first source data table is any one of the source data tables;
and respectively calculating the times or proportion of each primary key as a foreign key by using at least one primary key determined in the first source data table. It should be noted that the foreign key is also called a foreign key, and if the public key is a primary key in one relationship, the public key is called a foreign key of another relationship, and the foreign key represents a relevant relationship between the two relationships. A table having a foreign key in another relationship as a primary key is referred to as a primary table, and a table having such a foreign key is referred to as a secondary table of the primary table. That is, the first source data table is a master table, the source data tables other than the first source data table are slave tables, and the number of times or the proportion of each master key in the first source data as a foreign key of the source data tables other than the first source data table is calculated. The number of times that a certain primary key in the first source data table is used as a foreign key may be understood as the number of source data tables in a master-slave relationship with other source data tables in the data warehouse, and the ratio of the certain primary key in the first source data table as the foreign key may be understood as the ratio of the number of source data tables in the master-slave relationship with other source data tables in the data warehouse to the number of source data tables other than the first source data table; if the frequency of taking a certain primary key in the first source data table as a foreign key is greater than or equal to a preset frequency threshold value, taking the primary key as a dimension key word of the first source data table; or, if the ratio of the number of the source data tables in the master-slave relationship with other source data tables in the data warehouse to the number of the source data tables except the first source data table is greater than or equal to a preset ratio threshold, taking the primary key as the dimension key of the first source data table, and setting the dimension key as the dimension of the aperture system.
The method has the advantages that the keywords with the foreign key times larger than or equal to the preset time threshold are selected as the dimension keywords, or the keywords with the foreign key times larger than or equal to the preset proportion threshold are selected as the dimension keywords, so that the dimension selection accuracy is improved, the method can be more suitable for the requirement of large data processing, meanwhile, the dimension keywords are selected by utilizing foreign key statistics, the processing efficiency of later-stage data is improved, and the consistency of the data is kept.
Preferably, on the basis of the above embodiment, in step S2, based on the keywords in the keyword table, at least one of the keywords is selected as an index keyword according to a preset rule, which specifically includes:
s23, acquiring a second source data table in the source data table, and determining at least one keyword except an exception key in the second source data table;
the second source data table is a data table of a subordinate relationship in the principal-subordinate relationship of the first source data table, and at least one keyword is determined except for a foreign key from the second source data table, wherein the at least one keyword does not include a primary keyword which is used as the foreign key and is used as a foreign key, and the frequency or the proportion of the foreign key is greater than or equal to a preset frequency threshold or a preset proportion threshold.
S24, calculating the usage number of each keyword except the foreign key in the second source data table, and selecting at least one keyword from at least one keyword except the foreign key in the second source data table as an index keyword, wherein the index keyword is a keyword of which the usage number is greater than or equal to a preset usage number threshold;
or, preferably, calculating a usage rate of each keyword in the second source data table except for the foreign key, and selecting at least one keyword from at least one keyword in the second source data table except for the foreign key as an index keyword, where the index keyword is a keyword of which the usage rate is greater than or equal to a preset usage rate threshold;
or, preferably, the usage frequency of each keyword in the second source data table except the foreign key is calculated, at least one keyword is selected from at least one keyword in the second source data table except the foreign key as an index keyword, the index keyword is a keyword of which the usage number is greater than or equal to a preset usage frequency threshold, and the second source data table is any one of the source data tables except the first source data table;
and respectively calculating the use number, the use rate or the use frequency of at least one keyword except for the foreign key in each second source data table, selecting the keyword of which the use number is greater than or equal to a preset use number threshold value as an index keyword, or selecting the keyword of which the use rate is greater than or equal to a preset use rate threshold value as an index keyword, or selecting the keyword of which the use frequency is greater than or equal to a preset use frequency threshold value as an index keyword, and setting the index keyword as an index of the aperture system. By the method, the frequently-used keywords or inconsistent keywords can be screened, so that data cleaning of a data warehouse is facilitated, the data utilization efficiency is improved, and the data consistency is kept.
Preferably, on the basis of the above embodiment, in step S2, a dimension-index combination is automatically generated according to the dimension keyword and the index keyword, and a caliber system is established through the dimension-index combination, which specifically includes:
s25, performing dimension splitting according to the dimension keywords and different theme categories, and storing the split dimension keywords into a plurality of dimension tables, wherein the dimension tables correspond to the theme categories;
and dimension splitting is carried out on the dimension keywords according to different topic categories, wherein the topic categories can be preset, dimension splitting is carried out on all the dimension keywords, the dimension keywords after splitting are stored in a plurality of different dimension tables, and each dimension table corresponds to one topic category. For example, the theme categories of the dimension keyword login ID, the page ID, the browser cookie and the dimension keyword login ID, the page ID, the browser cookie, the IP, the city and the channel identifier in table 2 and table 3 are Web, the theme categories can be preset as App, user behavior and the like, and the dimension keywords are split according to the theme categories, so that the management of the mass data in different dimensions and layers is realized, the collection and storage of the mass data and the fast and accurate data query are realized, the data processing efficiency is improved, and a timely and accurate data basis is provided for the decision of enterprises.
S26, according to the index keywords, index splitting is carried out according to different dimensionalities, and the split index keywords are stored into a plurality of index tables, wherein the index tables correspond to the multiple dimensionalities;
it should be noted that, in the step S41, the index keywords are subjected to dimension splitting according to different topic categories, where the topic categories may be preset, all the index keywords are subjected to dimension splitting, and the split index keywords are stored in a plurality of different index tables, where each index table corresponds to one topic category. For example, the index keyword first access date, last access date, insertion time, user insertion and partition date in table 2, and the topic category of the index keyword access times, landing page times, exit page times, insertion time, user insertion and partition date in table 3 are Web, it can be seen that the index keyword whose topic category is Web is the attribute value of the dimension keyword in step S41, the topic category can also be preset to App, user behavior and the like, the index keyword is split according to the topic category, and management of the mass data in a dimensionality-based and hierarchical manner is realized, so that collection, storage and rapid and accurate data query of the mass data are realized, the efficiency of data processing is improved, and a timely and accurate data basis is provided for enterprise decision making.
And S27, automatically generating a dimension-index combination table according to the external keys of the index tables and the dimension tables, wherein the dimension-index combination table comprises the dimension-index combination and standard query instructions corresponding to the dimension-index combination, and establishing an aperture system by using the dimension-index combination and the standard query instructions corresponding to the dimension-index combination.
Automatically generating a dimension-index combination table from the plurality of index tables and the plurality of dimension tables, for example, as shown in table 4 below:
TABLE 4
Table 4 is a dimension-index combination table, which includes subject categories, dimensions, and indexes, and is only for illustration and not intended to limit the scope of the present invention.
According to the dimension-index combination in table 4, a corresponding query instruction is automatically generated, for example, the city-visit number, that is, the query subject category in the data warehouse is Web, the website visit number of the current day of the city is specified, the query instruction with the query subject type being Web and the website visit number of the current day of the city is automatically generated, in the query instruction, the parameter related to the specific specified city or visit number may be a variable, according to the specific required parameter input by the user, by executing the assigned query instruction, the corresponding source data meeting the user input parameter can be obtained by querying from the data warehouse, and the source data query efficiency is improved.
Each dimension-index combination in table 4 above corresponds to a query instruction, and a caliber system is established by using the dimension-index combination and its corresponding query instruction, as shown in table 5:
TABLE 5
If a user needs to inquire the source data corresponding to the dimension-index combination, the corresponding inquiry instruction is determined according to the dimension-index combination, the specific inquiry parameter is input, the inquiry instruction after assignment is automatically executed, and the inquiry of the source data corresponding to the dimension-index combination from the data warehouse is completed.
S3, receiving a query instruction input by a user, acquiring Chinese keywords corresponding to the query instruction by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table;
and S4, generating a target query instruction according to the English keyword corresponding to the acquired query instruction, writing attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template, and generating a target script.
Has the advantages that: according to the embodiment of the invention, the source data table for performing data warehouse number checking statistics at regular intervals is used for replacing the description information corresponding to the description field in the source data table by using the keywords, so that the keyword table is established, whether the source data in the data warehouse and the updated final data are balanced or not is periodically verified, the data consistency is favorably improved, so that a user can extract and clear the data with useful value for an enterprise from the source data, and the data are finally stored in the data warehouse, and a data basis for the enterprise to perform query operation is provided; automatically generating a dimension-index caliber combination according to the keyword table, and establishing a caliber system, so that the generated dimension-index combination can be adapted to the data change of the data warehouse, and the data change of the data warehouse can be better reflected; based on the keywords of the keyword table, selecting the keywords with the times or the proportion larger than or equal to a preset time threshold or a preset proportion threshold as the dimension keywords, so that the accuracy of dimension selection is improved, the dimension selection can be more suitable for the requirement of big data processing, and meanwhile, the dimension keywords are selected by utilizing foreign key statistics, so that the processing efficiency of later data is improved and the consistency of the data is kept; based on the keywords of the keyword table, the keywords of which the use number, the use rate and the use frequency reach threshold values are selected from the keywords except the foreign keys to serve as index keywords, so that the keywords with low use rate or inconsistent keywords can be screened, data cleaning of a data warehouse is facilitated, the data utilization efficiency is improved, and the data consistency is kept; performing dimensionality splitting according to the dimensionality key words and the index key words and storing the split dimensionality key words and the index key words into a plurality of dimensionality tables, wherein the dimensionality tables correspond to a plurality of topic categories, splitting the dimensionality key words and the index key words according to the topic categories, and realizing management of the dimensionality and the hierarchy of mass data, so that collection, storage and rapid and accurate data query of the mass data are realized, the data processing efficiency is improved, timely and accurate data basis is provided for decision making of enterprises, Chinese key words corresponding to query instructions are obtained by using a caliber system, English key words corresponding to the query instructions are obtained according to a preset Chinese and English comparison word root table, and the key word data are standard and uniform and are easy for later maintenance; and generating a target query instruction according to the obtained English keyword corresponding to the query instruction, writing attribute information corresponding to the target query instruction into the template attribute corresponding to the preset script template, and generating a target script without repeatedly establishing the script, thereby avoiding a large amount of repeated labor, shortening the code length and saving the workload.
EXAMPLE III
On the basis of any one of the above embodiments, the present invention further provides another script aided design method based on a root word list, which specifically includes the following steps, as shown in fig. 4:
s1, establishing a keyword table;
s2, based on keywords of the keyword table, selecting at least one keyword as a dimension keyword and an index keyword according to a preset rule, automatically generating a dimension-index combination according to the dimension keyword and the index keyword, and establishing an aperture system through the dimension-index combination;
s3, receiving a query instruction input by a user, acquiring Chinese keywords corresponding to the query instruction by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table;
preferably, step S3 may specifically include the following steps:
s31, receiving a query instruction input by a user, matching the query instruction with a standard query instruction in the aperture system, and acquiring a dimension-index combination corresponding to the standard query instruction which is successfully matched;
receiving a query instruction input by a user, and acquiring a Chinese keyword corresponding to the query instruction according to the established aperture system, specifically, the query instruction comprises a dimension-index combination for setting a query condition, matching the dimension-index combination in the query instruction with the dimension-index combination in the aperture system, and acquiring a successfully matched dimension key and index key, namely the Chinese keyword corresponding to the query instruction.
Preferably, step S31 may specifically include the following steps:
s311, receiving a query instruction input by a user, and matching the text content of the query instruction with the standard text content of the standard query instruction in the aperture system;
the text content of the query instruction includes the dimension keyword and the index keyword in the corresponding query condition, and the dimension keyword and the index keyword are matched with the standard text content of the standard query instruction in the caliber system, wherein the standard text content is the dimension keyword and the index keyword in the table 5.
S312, if the matching degree of the text content of the query instruction and the standard text content of the standard query instruction in the aperture system is larger than or equal to a preset matching degree threshold value, determining that the query instruction is successfully matched with the standard query instruction in the aperture system, and obtaining a dimension-index combination corresponding to the successfully matched standard query instruction according to the aperture system.
If the matching degree between the text content of the query instruction input by the user and the standard text content of the standard query instruction in the aperture system is larger than or equal to a preset matching degree threshold value, determining that the query instruction is successfully matched with the standard query instruction in the aperture system, otherwise, prompting the user to input the query instruction again, and further recording a log of matching failure so as to update the aperture system at a later stage and meet the user requirement. The specific implementation manner may include that the text content of the query instruction input by the user and the standard text content of the standard query instruction in the aperture system are checked word by word, if the check accuracy is greater than or equal to a preset accuracy, it may be determined that the matching degree between the text content of the query instruction input by the user and the standard text content of the standard query instruction in the aperture system satisfies that the matching degree is greater than or equal to a preset matching degree threshold, where the check accuracy is used to indicate that the number of words, which are checked correctly between the text content of the query instruction input by the user and the standard text content of the standard query instruction in the aperture system, accounts for the percentage of the number of words of the text content of the query instruction input by the user. By the method, the matching efficiency and accuracy between the text content of the query instruction input by the user and the standard text content of the standard query instruction in the aperture system are improved.
S32, acquiring Chinese keywords corresponding to the query instruction according to the dimension-index combination corresponding to the successfully matched standard query instruction;
and under the condition that the matching between the text content of the query instruction input by the user and the standard text content of the standard query instruction in the aperture system is successful, acquiring a standard dimension-index combination corresponding to the successfully matched standard query instruction, and acquiring a standard dimension keyword and a standard index keyword, namely the dimension keyword and the index keyword in the table 5, according to the standard dimension-index combination to obtain the Chinese keyword corresponding to the query instruction input by the user.
S33, splitting the Chinese keyword corresponding to the query instruction into at least one Chinese root, and obtaining at least one English root corresponding to the at least one Chinese root through the preset Chinese-English reference root table;
splitting the acquired Chinese keywords corresponding to the query instruction input by the user, such as cities and access times, obtaining Chinese roots as the cities, the access times after splitting, and translating by using a Chinese and English comparison root table preset in the table 1 to obtain English roots as the cities, the visits and the times.
And S34, combining the at least one English root word to generate an English keyword corresponding to the query instruction.
And taking the obtained English root words as city, visit and times. And combining to generate English keywords city and visit _ times. And generating a target query instruction according to the English keywords city and the visit _ times, wherein the query condition corresponding to the target query instruction comprises a city-visit _ times dimension-index combination consisting of the English keywords.
And S4, generating a target query instruction according to the English keyword corresponding to the acquired query instruction, writing attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template, and generating a target script.
It should be noted that, a target query instruction is generated according to the english keywords unified by the specification, and attribute information corresponding to the target query instruction includes a query condition, a query step, and a query result, where the query condition is a query condition defined by a dimension and an index, for example, a query instruction in which the query dimension is a city and the index is an access number is queried from a data warehouse, and the query condition of the query instruction is defined by the city and the access number; in the query step, the sequence of the source data is extracted from the data warehouse in the query instruction execution process, for example, the query instruction with the dimensionality of a city and the index of the access frequency is queried from the data warehouse, and the query step is to extract the source data with the dimensionality of the city first and then extract the source data with the index of the access frequency from the extracted source data with the dimensionality of the city; the query result may be a manner of feeding back the source data obtained by the query after executing the query instruction, for example, but not limited to, a table, a bar chart, or a thermodynamic diagram, and the like. The attribute information corresponding to the query instruction is written into the template attribute corresponding to the preset script template to generate the target script, so that the script template can be repeatedly used, and the attribute information corresponding to the query instruction can be automatically written into the template attribute of the preset script template aiming at different query instructions to generate the target script without repeatedly establishing the script, thereby avoiding a large amount of repeated labor, shortening the code length and saving the workload; of course, different types of script templates can be set according to the needs of actual situations to meet the query requirements of source data of different subject categories or the query requirements of source data of different application scenarios, thereby further improving the query efficiency of source data.
Has the advantages that: according to the embodiment of the invention, a keyword table is established in advance, at least one keyword is selected as a dimension keyword and an index keyword according to a preset rule based on the keyword of the keyword table, a dimension-index combination is automatically generated according to the dimension keyword and the index keyword, and a caliber system is established through the dimension-index combination; receiving a query instruction input by a user, matching the text content of the query instruction with the standard text content of a standard query instruction in the aperture system, if the matching degree of the text content of the query instruction and the standard text content of the standard query instruction in the aperture system is greater than or equal to a preset matching degree threshold value, determining that the query instruction is successfully matched with the standard query instruction in the aperture system, and acquiring a dimension-index combination corresponding to the successfully matched standard query instruction according to the aperture system, so that the matching efficiency and accuracy between the text content of the query instruction input by the user and the standard text content of the standard query instruction in the aperture system are improved; acquiring the Chinese keyword corresponding to the query instruction according to the dimension-index combination corresponding to the successfully matched standard query instruction, splitting the Chinese keyword corresponding to the query instruction into at least one Chinese root word, acquiring at least one English root word corresponding to the at least one Chinese root word through the preset Chinese and English comparison root word table, combining the at least one English root word to generate the English keyword corresponding to the query instruction, generating a target query instruction according to the acquired English keyword corresponding to the query instruction, writing the attribute information corresponding to the target query instruction into the template attribute corresponding to the preset script template, and generating a target script. The Chinese keywords are divided into a plurality of roots by setting a root table, and corresponding English roots are obtained from the root table. The operation of generating English keywords for each Chinese keyword is avoided. The method is favorable for maintaining the keywords and managing the database, ensures that the keyword data is standard and uniform, is easy for later maintenance, simultaneously utilizes the preset script template to complete the auxiliary design of the script, does not need to repeatedly establish the script, avoids a large amount of repeated labor, shortens the code length and saves the workload.
Example four
An embodiment of the present invention provides a script aided design apparatus 500 based on a root table, as shown in fig. 5, the apparatus includes:
a first establishing module 510, configured to establish a keyword table;
a second establishing module 520, configured to select at least one keyword as a dimension keyword and an index keyword according to a preset rule based on the keyword of the keyword table, automatically generate a dimension-index combination according to the dimension keyword and the index keyword, and establish a caliber system through the dimension-index combination;
an english keyword obtaining module 530, configured to receive a query instruction input by a user, obtain a chinese keyword corresponding to the query instruction by using the aperture system, and obtain an english keyword corresponding to the query instruction according to a preset chinese-english comparison root table;
and the script generating module 540 is configured to generate a target query instruction according to the obtained english keyword corresponding to the query instruction, and write attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template to generate a target script.
The embodiment of the present invention provides a device 500 for script aided design based on a root table, which is a method for script aided design based on a root table corresponding to the above embodiment, and the device 500 for script aided design further includes a plurality of units for implementing corresponding functions corresponding to corresponding steps of the method for script aided design. Since the steps of the script aided design method have been described in detail in the above embodiments, they are not repeated in this apparatus 500.
Has the advantages that: the method comprises the steps that a keyword table is pre-established through a first establishing module, at least one keyword is selected as a dimension keyword and an index keyword according to a preset rule based on the keyword of the keyword table through a second establishing module, a dimension-index combination is automatically generated according to the dimension keyword and the index keyword, and a caliber system is established through the dimension-index combination; the English keyword acquisition module receives a query instruction input by a user, acquires Chinese keywords corresponding to the query instruction by using the aperture system, and acquires English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table; and the script generation module generates a target query instruction according to the English keyword corresponding to the acquired query instruction, writes attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template, and generates a target script. In conclusion, the English keywords corresponding to the query instruction are obtained through the preset Chinese and English comparison root table, so that the keyword data are standard and uniform, the later maintenance is easy, meanwhile, the auxiliary design of the script is completed by utilizing the preset script template, the script does not need to be repeatedly established, a large amount of repeated labor is avoided, the code length is shortened, and the workload is saved.
EXAMPLE five
The embodiment of the present invention further provides a device 600 for script aided design based on a root word list, where the device includes a memory 610, a processor 620, and a computer program 630 stored in the memory 610 and operable on the processor 620, and is characterized in that when the computer program 630 is executed by the processor 620, the steps of any method for script aided design based on a root word list described in the above embodiments are implemented.
An embodiment of the present invention further provides a computer storage medium, where the computer storage medium may store a program, and when the program is executed, the program includes some or all of the steps of any one of the script aided design methods based on a root table described in the above method embodiments.
It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the order of acts, as some steps may occur in other orders or concurrently in accordance with the invention. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required by the invention.
In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus may be implemented in other manners. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one type of division of logical functions, and there may be other divisions when actually implementing, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of some interfaces, devices or units, and may be an electric or other form.
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 invention 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 unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable memory. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a memory and includes several instructions for causing a computer device (which may be a personal computer, a server, a network device, or the like) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned memory comprises: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by associated hardware instructed by a program, which may be stored in a computer-readable memory, which may include: flash Memory disks, Read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.
The above embodiments of the present invention are described in detail, and the principle and the implementation of the present invention are explained by applying specific embodiments, and the above description of the embodiments is only used to help understanding the method of the present invention and the core idea thereof; meanwhile, for a person skilled in the art, according to the idea of the present invention, 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 invention.
Claims (10)
1. A script aided design method based on a root word list is characterized by comprising the following steps:
establishing a keyword table;
based on keywords of the keyword table, selecting at least one keyword as a dimension keyword and an index keyword according to a preset rule, automatically generating a dimension-index combination according to the dimension keyword and the index keyword, and establishing a caliber system through the dimension-index combination;
receiving a query instruction input by a user, acquiring Chinese keywords corresponding to the query instruction by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table;
and generating a target query instruction according to the English keyword corresponding to the acquired query instruction, and writing attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template to generate a target script.
2. The script aided design method according to claim 1, wherein the creating of the keyword table specifically comprises:
checking the data warehouse at intervals of preset time, and counting a source data table generated in the preset time, wherein the source data table comprises description fields;
and replacing the description information in the description field by using a keyword to establish a keyword table.
3. The script aided design method according to claim 2, wherein the selecting at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table specifically comprises:
acquiring a first source data table in the source data table, and determining at least one primary key in the first source data table;
calculating the times of taking at least one primary key in each first source data table as a foreign key, and selecting the primary key with the times of taking the foreign key being more than or equal to a preset time threshold value from the at least one primary key in the first source data table as a dimension key word of the first source data table;
alternatively, the first and second electrodes may be,
calculating the proportion of at least one primary key in each first source data table as a foreign key, and selecting the primary key with the proportion of the foreign key being greater than or equal to a preset proportion threshold value from the at least one primary key in the first source data table as a dimension key word of the first source data table, wherein the first source data table is any one of the source data tables.
4. The script aided design method according to claim 3, wherein the selecting at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table specifically comprises:
acquiring a second source data table in the source data table, and determining at least one keyword except an exception key in the second source data table;
calculating the use number of each keyword except the foreign key in the second source data table, and selecting at least one keyword from at least one keyword except the foreign key in the second source data table as an index keyword, wherein the index keyword is a keyword of which the use number is greater than or equal to a preset use number threshold;
alternatively, the first and second electrodes may be,
calculating the utilization rate of each keyword except the foreign key in the second source data table, and selecting at least one keyword from at least one keyword except the foreign key in the second source data table as an index keyword, wherein the index keyword is a keyword of which the utilization rate is greater than or equal to a preset utilization rate threshold value;
alternatively, the first and second electrodes may be,
calculating the use frequency of each keyword in the second source data table except the foreign key, selecting at least one keyword from at least one keyword in the second source data table except the foreign key as an index keyword, wherein the index keyword is a keyword of which the use number is greater than or equal to a preset use frequency threshold value, and the second source data table is any one source data table in the source data table except the first source data table.
5. The script aided design method according to claim 4, wherein the automatically generating a dimension-index combination according to the dimension keyword and the index keyword, and establishing a caliber system through the dimension-index combination specifically comprises:
dimension splitting is carried out according to the dimension keywords and different theme categories, the split dimension keywords are stored into a plurality of dimension tables, and the dimension tables correspond to the theme categories;
index splitting is carried out according to the index keywords and different dimensions, the split index keywords are stored into a plurality of index tables, and the index tables correspond to the dimensions;
and automatically generating a dimension-index combination table according to the external keys of the index tables and the dimension tables, wherein the dimension-index combination table comprises the dimension-index combination and standard query instructions corresponding to the dimension-index combination, and establishing a caliber system by using the dimension-index combination and the standard query instructions corresponding to the dimension-index combination.
6. The script aided design method according to any one of claims 1 to 5, wherein the receiving a query instruction input by a user, acquiring a Chinese keyword corresponding to the query instruction by using the aperture system, and acquiring an English keyword corresponding to the query instruction according to a preset Chinese-English reference root table specifically comprises:
receiving a query instruction input by a user, matching the query instruction with a standard query instruction in the aperture system, and acquiring a dimension-index combination corresponding to the standard query instruction which is successfully matched;
acquiring Chinese keywords corresponding to the query instruction according to the dimension-index combination corresponding to the successfully matched standard query instruction;
splitting the Chinese keywords corresponding to the query instruction into at least one Chinese root, and acquiring at least one English root corresponding to the at least one Chinese root through the preset Chinese and English comparison root table;
and combining the at least one English root word to generate an English keyword corresponding to the query instruction.
7. The script aided design method according to claim 6, wherein the receiving a query instruction input by a user, matching the query instruction with a standard query instruction in the aperture system, and obtaining a dimension-index combination corresponding to the standard query instruction that is successfully matched specifically comprises:
receiving a query instruction input by a user, and matching the text content of the query instruction with the standard text content of the standard query instruction in the aperture system;
and if the matching degree of the text content of the query instruction and the standard text content of the standard query instruction in the aperture system is greater than or equal to a preset matching degree threshold value, determining that the query instruction is successfully matched with the standard query instruction in the aperture system, and acquiring a dimension-index combination corresponding to the successfully matched standard query instruction according to the aperture system.
8. A script aided design device based on a root table is characterized by specifically comprising:
the first establishing module is used for establishing a keyword table;
the second establishing module is used for selecting at least one keyword as a dimension keyword and an index keyword according to a preset rule based on the keywords of the keyword table, automatically generating a dimension-index combination according to the dimension keyword and the index keyword, and establishing a caliber system through the dimension-index combination;
the English keyword acquisition module is used for receiving a query instruction input by a user, acquiring Chinese keywords corresponding to the query instruction by using the aperture system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table;
and the script generation module is used for generating a target query instruction according to the obtained English keyword corresponding to the query instruction, writing the attribute information corresponding to the target query instruction into the template attribute corresponding to the preset script template, and generating a target script.
9. A device for script aided design based on a root table, the device comprising a memory, a processor and a computer program stored in the memory and operable on the processor, wherein the processor when executing the computer program implements the steps of a method for script aided design based on a root table according to any one of claims 1 to 7.
10. A computer-readable storage medium, in which a computer program is stored, which, when being executed by a processor, carries out the steps of a method for script aided design based on a root table according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911089735.5A CN110837365A (en) | 2019-11-08 | 2019-11-08 | Script aided design method and device based on root table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911089735.5A CN110837365A (en) | 2019-11-08 | 2019-11-08 | Script aided design method and device based on root table |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110837365A true CN110837365A (en) | 2020-02-25 |
Family
ID=69575006
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911089735.5A Pending CN110837365A (en) | 2019-11-08 | 2019-11-08 | Script aided design method and device based on root table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110837365A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115826991A (en) * | 2023-02-14 | 2023-03-21 | 江西曼荼罗软件有限公司 | Software script generation method, system, computer and readable storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109145110A (en) * | 2018-06-29 | 2019-01-04 | 深圳市彬讯科技有限公司 | Information classification processing, tag queries method and apparatus based on label |
| CN109144997A (en) * | 2018-06-11 | 2019-01-04 | 玖富金科控股集团有限责任公司 | Data correlation method, device and storage medium |
| CN109388654A (en) * | 2017-08-04 | 2019-02-26 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for inquiring tables of data |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN110321344A (en) * | 2019-05-20 | 2019-10-11 | 平安普惠企业管理有限公司 | Information query method, device, computer equipment and the storage medium of associated data |
| CN110737432A (en) * | 2019-09-20 | 2020-01-31 | 黄沙沙 | script aided design method and device based on root list |
-
2019
- 2019-11-08 CN CN201911089735.5A patent/CN110837365A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109388654A (en) * | 2017-08-04 | 2019-02-26 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for inquiring tables of data |
| CN109144997A (en) * | 2018-06-11 | 2019-01-04 | 玖富金科控股集团有限责任公司 | Data correlation method, device and storage medium |
| CN109145110A (en) * | 2018-06-29 | 2019-01-04 | 深圳市彬讯科技有限公司 | Information classification processing, tag queries method and apparatus based on label |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN110321344A (en) * | 2019-05-20 | 2019-10-11 | 平安普惠企业管理有限公司 | Information query method, device, computer equipment and the storage medium of associated data |
| CN110737432A (en) * | 2019-09-20 | 2020-01-31 | 黄沙沙 | script aided design method and device based on root list |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115826991A (en) * | 2023-02-14 | 2023-03-21 | 江西曼荼罗软件有限公司 | Software script generation method, system, computer and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3571606B1 (en) | Query language interoperability in a graph database | |
| US9519862B2 (en) | Domains for knowledge-based data quality solution | |
| US8924365B2 (en) | System and method for range search over distributive storage systems | |
| CN109977110A (en) | Data cleaning method, device and equipment | |
| CN110716950B (en) | Caliber system establishment method, caliber system establishment device, caliber system establishment equipment and computer storage medium | |
| CN108027818A (en) | Inquiry based on figure | |
| CN108319661A (en) | A kind of structured storage method and device of spare part information | |
| CN108647357B (en) | Data query method and device | |
| CN110737432B (en) | Script aided design method and device based on root list | |
| CN111008521A (en) | Method and device for generating wide table and computer storage medium | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| US20150379112A1 (en) | Creating an on-line job function ontology | |
| CN114329096A (en) | Method and system for processing native map database | |
| CN115858513A (en) | Data governance method, data governance device, computer equipment and storage medium | |
| CN115203435A (en) | Entity relation generation method and data query method based on knowledge graph | |
| CN109636303B (en) | Storage method and system for semi-automatically extracting and structuring document information | |
| Shen et al. | A Generic Framework for Top-${\schmi k} $ Pairs and Top-${\schmi k} $ Objects Queries over Sliding Windows | |
| CN113535766A (en) | Workflow configuration method, workflow configuration device, electronic device, and storage medium | |
| CN110222047A (en) | A kind of dynamic list generation method and device | |
| CN110837365A (en) | Script aided design method and device based on root table | |
| JP6896870B2 (en) | Systems and methods for efficient delivery of warning messages | |
| CN110837508A (en) | Method, device and equipment for establishing aperture system and computer storage medium | |
| CN115221254A (en) | Multi-data source processing method, device, equipment and storage medium | |
| CN114860759A (en) | Data processing method, device and equipment and readable storage medium | |
| CN114003717A (en) | Data processing method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 518000 R & D building 3501, block a, building 7, Vanke Cloud City Phase I, Xingke 1st Street, Xili community, Xili street, Nanshan, Shenzhen, Guangdong Applicant after: Tubatu Group Co.,Ltd. Address before: 1001-a, 10th floor, bike technology building, No.9, Keke Road, high tech Zone, Nanshan District, Shenzhen, Guangdong 518000 Applicant before: SHENZHEN BINCENT TECHNOLOGY Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200225 |
|
| WD01 | Invention patent application deemed withdrawn after publication |