CN110737432B

CN110737432B - Script aided design method and device based on root list

Info

Publication number: CN110737432B
Application number: CN201910894233.3A
Authority: CN
Inventors: 黄沙沙
Original assignee: Individual
Current assignee: Individual
Priority date: 2019-09-20
Filing date: 2019-09-20
Publication date: 2023-10-20
Anticipated expiration: 2039-09-20
Also published as: CN110737432A

Abstract

The invention provides a script aided design method and device based on a root list, wherein the method specifically comprises the following steps: establishing a keyword table; establishing an caliber system based on the keyword table; acquiring Chinese keywords corresponding to a query instruction input by a user by using the caliber system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese-English comparison root list; generating a target query instruction according to the English keywords corresponding to the obtained query instruction, and writing attribute information corresponding to the target query instruction into template attributes corresponding to a preset script template to generate a target script. The invention can unify the keyword data specification, is easy to maintain, does not need to repeatedly establish scripts, avoids repeated labor and saves workload.

Description

Script aided design method and device based on root list

Technical Field

The invention relates to the field of scripts, in particular to a script aided design method and device based on a root table.

Background

Script (Script) is an extension of a batch file, a program that is saved in plain text, and generally a computer Script program is a defined set of combinations of control computer operations in which certain logical branches can be implemented, and the Script can be typically temporarily invoked and executed by an application program.

In the prior art, each modeling is to rewrite a script, obtain corresponding key field data according to a combination of dimension and index, and build a table, but the method has the advantages of large workload, no unified specification of the key field data, great amount of repeated labor, increased code length and difficult maintenance.

Disclosure of Invention

The embodiment of the invention provides a script aided design method and a script aided design device based on a root table, which mainly aim to solve the problems that in the prior art, corresponding key field data is acquired according to the combination of dimension and index, when a table is established, the workload is large, the key field data is not uniform and standard, a large amount of repeated labor is caused, and meanwhile, the code length is increased, so that the maintenance is not easy.

In a first aspect, an embodiment of the present invention provides a method for script aided design based on a root table, including:

establishing a keyword table;

based on the 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 caliber system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese-English comparison root list;

generating a target query instruction according to the English keywords corresponding to the obtained query instruction, and writing attribute information corresponding to the target query instruction into template attributes corresponding to a preset script template to generate a target script.

In a second aspect, the present invention further provides a script aided design device based on a root table, where the device 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 utilizing the caliber system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese-English comparison root list;

And the script generation module is used for generating a target query instruction according to the English keywords corresponding to the acquired query instruction, writing attribute information corresponding to the target query instruction into template attributes corresponding to a preset script template, and generating a target script.

In a third aspect, the present invention provides a root table-based script aided design apparatus, the apparatus comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements part or all of the steps of any one of the root table-based script aided design methods 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, where the program executes to implement part or all of the steps of any one of the script aided design methods based on a root table described in the foregoing embodiments.

The beneficial effects are 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 keywords 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 caliber system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese-English comparison root list; generating a target query instruction according to the English keywords corresponding to the obtained query instruction, and writing attribute information corresponding to the target query instruction into template attributes corresponding to a preset script template to generate a target script. In summary, it can be seen that the preset Chinese and English comparison word root table is used for obtaining the English keywords corresponding to the query instruction, so that the keyword data specification is unified, the later maintenance is easy, meanwhile, the auxiliary design of the script is completed by using the preset script template, the script is not required to be repeatedly built, 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 will be more readily apparent from the following description of the embodiments.

Drawings

In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

FIG. 1 is a flow chart of a method for assisting in designing a script based on a root table according to an embodiment of the present invention;

FIG. 2 is a schematic flow chart of establishing a keyword table in another method for assisting in designing a script based on a root table according to an embodiment of the present invention;

FIG. 3 is a schematic flow chart of an aperture system established in another method for assisting in designing a script based on a root table according to an embodiment of the present invention;

fig. 4 is a flow chart of another script aided design method based on a root table according to the third embodiment of the present invention;

fig. 5 is a schematic structural diagram of a script aided design device 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 device based on a root table according to an embodiment of the present invention.

Detailed Description

In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.

The following will describe in detail.

The terms "first," "second," "third," and "fourth" and the like in the description and in the claims and drawings are used for distinguishing between different objects and not necessarily for describing a particular sequential or chronological order. Furthermore, the terms "comprise" and "have," as well as any variations thereof, are intended to cover a non-exclusive inclusion. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those listed steps or elements but may 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 association relationship of associated objects, meaning that there may be three relationships, e.g., a and/or B, which may represent: a exists alone, A and B exist together, and B exists alone. The character "/" generally indicates that the context-dependent object is an "or" relationship.

Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the application. The appearances of such phrases 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. Those of skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments.

Embodiments of the present application are described below with reference to the accompanying drawings.

Example 1

According to one aspect of the present application, there is provided a script aided design method based on a root table, which specifically includes the following steps, as shown in fig. 1:

s1, establishing a keyword table;

it should be noted that, the execution body of the embodiment of the present application is a data management server, which is formed by one or more computers running in a local area network and data management system software, and the data management server provides management services for user data.

Specifically, the source data table in the data warehouse during the verification of the data daily 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 keywords obtained through extraction are generated into a keyword table, and the keywords in the keyword table are in one-to-one correspondence with the description information in each row of source data.

S2, selecting at least one keyword as a dimension keyword and an index keyword according to a preset rule based on 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;

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, for example, the dimension is a city, the corresponding index is Shenzhen, and Shenzhen is the attribute value of the dimension of the city.

And automatically generating a dimension-index combination, such as city-Shanghai, by using the selected dimension keywords and index keywords, if the source data of the Shanghai is required to be queried from a data warehouse, automatically generating and obtaining a corresponding data query instruction 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 instruction, determining a field name as a city by using the flow web page access daily table and the dimension, generating a query instruction corresponding to the determined table name, the field name and the dimension-index combination, and further, generating query instructions corresponding to all the dimension-index combinations by using a traversal principle. And establishing a caliber system by using the dimension-index combination and the corresponding query instruction. The caliber system comprises a table name, a table field, a dimension keyword, an index keyword and query instructions corresponding to all dimension-index combinations. And corresponding query instructions are automatically generated according to the dimension-index combination, and the corresponding query instructions are executed when the query is needed, so that the needed 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 caliber system, and acquiring English keywords corresponding to the query instruction according to a preset Chinese-English comparison root list;

receiving a query instruction input by a user, acquiring a Chinese keyword corresponding to the query instruction according to the established caliber 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 caliber system, and acquiring a dimension keyword and an index keyword which are successfully matched, namely the Chinese keyword corresponding to the query instruction.

It should be noted that, the preset chinese-english comparison root list is a comparison list of chinese roots and english roots, for example, as shown in the following table 1:

TABLE 1

And comparing and translating the Chinese keywords corresponding to the query instruction obtained through the caliber system by using the Chinese and English comparison word root table set in the table 1 to obtain English keywords corresponding to the Chinese keywords of the query instruction, so that the keyword data specification is unified in such a way, and the later maintenance is easy.

S4, generating a target query instruction according to the English keywords corresponding to the obtained query instruction, and writing attribute information corresponding to the target query instruction into template attributes corresponding to a preset script template to generate a target script.

It should be noted that, generating a target query instruction according to the english keyword unified by the specification, where 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 dimensions and indexes, for example, a query instruction in which a query dimension is a city and an index is access number from a data warehouse, and the query condition of the query instruction is defined by the city and the access number; the query step is to extract the sequence of the source data from the data warehouse in the execution process of the query instruction, for example, the query instruction with the dimension as the city and the index as the access frequency is queried from the data warehouse, the query step is to extract the source data with the dimension as the city first, and then extract the source data with the index as the access frequency from the extracted source data with the dimension as the city; the query result may be a manner of feeding back the source data obtained by the query after the query instruction is executed, for example, but not limited to, a table, a bar graph, a thermodynamic diagram, etc., and is not limited in particular. 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 reused, the attribute information corresponding to the query instruction can be automatically written into the template attribute of the preset script template for different query instructions, the target script can be generated, the script does not need to be repeatedly built, a large amount of repeated labor is avoided, the code length is shortened, and the workload is saved; of course, according to the actual situation, different types of script templates can be set to meet the query requirements of source data of different topic categories or the source data query requirements of different application scenes, so that the source data query efficiency is further improved.

Example two

On the basis of the embodiment, the invention also provides a script aided design method based on the root list, which specifically comprises the following steps, as shown in fig. 2:

s1, establishing a keyword table;

the specific implementation manner of step S1 has been described in detail in the foregoing embodiments, which is not repeated herein, and further, step S1 may be implemented to establish a keyword table by the following steps, which are 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;

at preset intervals, for example, checking the data warehouse every day, verifying whether the original data in the data warehouse and the final data after daily updating are balanced, so that a user can extract and clean data which has value for enterprises from the source data, clean the source data in the data warehouse, in which the original data and the final data after daily updating are unbalanced, and finally store the source data in the data warehouse. The data in the data warehouse will typically be retained for a long period of time for the enterprise to perform query operations for use in enterprise decisions. Thus, checking the data warehouse every day is the data base for the enterprise to perform the query operation.

S12, replacing the description information in the description field by using a keyword, and establishing 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, the corresponding description information in the description field is replaced by a keyword, and a keyword table is established.

The keywords in the keyword table uniquely correspond to the description information corresponding to each line of source data. As shown in table 2 below:

TABLE 2

Table 2 is a key table 2 established after replacing the description information in the flow Web page access history table with a key according to the definition of the source data table.

Also for example, as shown in table 3 below:

TABLE 3 Table 3

Table 3 is a key table 3 created after replacing the description information in the access daily table for the traffic Web page with a key according to the definition of the source data table.

As shown in fig. 3, the step S2 of establishing a caliber system may specifically include the following steps:

preferably, on the basis of the foregoing embodiment, the step S2 selects at least one keyword as a dimension keyword according to a preset rule based on the keyword of the keyword table, and 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;

and randomly acquiring a first source data table from a source data table generated in the process of counting the data warehouse in the preset time, and determining at least one primary key in the first source data table, wherein the primary key is also called a primary key (primary key), is a unique key in the table, and the value of the primary key is used for uniquely identifying a record in the table and can uniquely determine a certain data in the table or uniquely determine a certain entity.

S22, calculating the times of taking at least one primary key in each first source data table as an external key, and selecting the primary key with the times of taking the external key being greater than or equal to a preset times threshold 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 the proportion of at least one main key in each first source data table as an external key, and selecting the main key with the proportion larger than or equal to a preset proportion threshold value as a dimension key of the first source data table from the at least one main key in the first source data table, wherein the first source data table is any one source data table in the source data tables;

and respectively calculating the times or the proportion of each primary key as an external key of 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 common key is a primary key in one relationship, the common key is called a foreign key of another relationship, and the foreign key represents a related relationship between two relationships. A table in which foreign keys of another relationship are primary keys is called a primary table, and a table having the foreign keys is called a secondary table of the primary table. That is, the first source data table is a master table, and 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 the external key of the source data table 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 can be understood as the number of source data tables in a master-slave relationship between the first source data table and other source data tables in a data warehouse, and the proportion that a certain primary key in the first source data table is used as a foreign key can be understood as the ratio of the number of source data tables in a master-slave relationship between the first source data table and other source data tables in the data warehouse to the number of source data tables except the first source data table; if the number of times that a certain primary key in the first source data table is used as an external key is greater than or equal to a preset number of times threshold, the primary key is used as a dimension key of the first source data table; or if the ratio of the number of the source data tables in the master-slave relation with other source data tables in the data warehouse and the number of the source data tables except the first source data table is greater than or equal to a preset proportion threshold value, the primary key is used as a dimension key of the first source data table, and the dimension key is set as the dimension of the caliber system.

The key word with the number of times larger than or equal to the preset number of times is selected as the dimension key word, or the key word with the number of times larger than or equal to the preset proportion threshold is selected as the dimension key word, so that the accuracy of dimension selection is improved, the method can be more suitable for the processing requirement of big data, and meanwhile, the dimension key word is selected by using the statistics of the outer key, the processing efficiency of later-stage data is improved, and the consistency of the data is maintained.

Preferably, on the basis of the foregoing embodiment, the step S2 selects at least one keyword as the index keyword according to a preset rule based on the keyword in the keyword table, and specifically includes:

s23, acquiring a second source data table in the source data table, and determining at least one keyword except an external key in the second source data table;

the second source data table is a data table of a subordinate relationship in a master-slave relationship of the first source data table, the foreign key is excluded from the second source data table, at least one keyword is determined, and the at least one keyword does not comprise a main keyword which is used as the foreign key and the number of times or the proportion of the foreign key is greater than or equal to a preset number of times threshold value or a preset proportion threshold value.

S24, calculating the use quantity of each keyword except the external key in the second source data table, and selecting at least one keyword from at least one keyword except the external key in the second source data table as an index keyword, wherein the index keyword is a keyword with the use quantity being larger than or equal to a preset use quantity threshold value;

or preferably, calculating the use rate of each keyword except the external key in the second source data table, and selecting at least one keyword from at least one keyword except the external key in the second source data table as an index keyword, wherein the index keyword is a keyword with the use rate being greater than or equal to a preset use rate threshold;

or preferably, calculating the use frequency of each keyword except the external key in the second source data table, and selecting at least one keyword from at least one keyword except the external key in the second source data table as an index keyword, wherein the index keyword is the keyword with the use number larger than or equal to a preset use frequency threshold, and the second source data table is any one source data table except the first source data table in the source data tables;

And respectively calculating the use quantity, the use rate or the use frequency of at least one keyword except the external key in each second source data table, selecting the keywords with the use quantity larger than or equal to a preset use quantity threshold value as index keywords, or selecting the keywords with the use rate larger than or equal to a preset use rate threshold value as index keywords, or selecting the keywords with the use frequency larger than or equal to a preset use frequency threshold value as index keywords, and setting the index keywords as indexes of the caliber system. By the method, unusual keywords or inconsistent keywords can be screened, so that data cleaning of a data warehouse is facilitated, data utilization efficiency is improved, and data consistency is maintained.

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 built through the dimension-index combination, which specifically includes:

s25, carrying out dimension splitting according to different theme categories according to the dimension keywords, and storing the split dimension keywords into a plurality of dimension tables, wherein the plurality of dimension tables correspond to a plurality of theme categories;

And carrying out dimension splitting on the dimension keywords according to different theme categories, wherein the theme categories can be preset, carrying out dimension splitting on all the dimension keywords, storing the split dimension keywords into a plurality of different dimension tables, and each dimension table corresponds to one theme category. For example, the dimension keyword login ID, the page ID and the browser cookie in table 2 and the theme categories of the dimension keyword login ID, the page ID, the browser cookie, the IP, the city and the channel identifier in table 3 are Web, the theme categories can be preset to be App, user behavior and the like, the dimension keyword is split according to the theme categories, and the management of massive data in a dimension and layering manner is realized, so that the collection, storage and rapid and accurate data query of massive data are realized, the data processing efficiency is improved, and timely and accurate data basis is provided for the decision of enterprises.

S26, carrying out index splitting according to the index keywords and different dimensions, and storing the split index keywords into a plurality of index tables, wherein the index tables correspond to the dimensions;

it should be noted that, in the same manner as in step S41, the index keywords are split in dimensions according to different topic categories, where the topic categories may be preset, all the index keywords are split in dimensions, the split index keywords are stored in a plurality of different index tables, and each index table corresponds to one topic category. For example, the first access date, the last access date, the time of insertion, the user insertion and the partition date of the index key words in table 2, and the topic categories of the index key words in table 3, such as the access times, the landing page times, the exit page times, the insertion time, the user insertion and the partition date, are Web, so that the index key words with the topic categories being Web can be seen to be the attribute values of the dimension key words in the step S41, the topic categories can be preset to be App, user behaviors and the like, the index key words can be split according to the topic categories, and the management of the massive data in a dimension and hierarchy manner can be realized, thereby realizing the collection, storage and rapid and accurate data query of the massive data, improving the data processing efficiency and providing timely and accurate data basis for the decision of enterprises.

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 a caliber system by utilizing 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

Table 4 is a dimension-index combination table, including subject categories, dimensions, and indexes, and is presented herein for illustrative purposes only and is not intended to limit the scope of the present invention.

According to the dimension-index combination in table 4, corresponding query instructions, such as city-access times, namely, query topic categories are Web from a data warehouse, query topic types are Web, query instructions for specifying the website access times of the city are automatically generated, parameters about specific specified cities or access times in the query instructions can be variables, according to specific required parameters input by a user, corresponding source data meeting the user input parameters can be queried from the data warehouse through executing the query instructions after assignment, and the source data query efficiency is improved.

Each dimension-index combination in table 4 corresponds to a query instruction, and the dimension-index combination and the query instruction corresponding thereto are used to build a caliber system, for example, as shown in table 5:

TABLE 5

If a user needs to inquire source data corresponding to a dimension-index combination, determining a corresponding inquiry instruction according to the dimension-index combination, inputting a specific inquiry parameter, automatically executing the assigned inquiry instruction, and finishing inquiry of the source data corresponding to the dimension-index combination from the data warehouse.

The beneficial effects are that: according to the embodiment of the invention, the keyword is utilized to replace the description information corresponding to the description field in the source data table by periodically carrying out the source data table of the data warehouse verification statistics, so that the keyword table is established, whether the source data in the data warehouse are balanced with the updated final data or not is verified periodically, the data consistency is improved, the user can extract and clear the data valuable to the enterprise from the source data, and finally the data are stored in the data warehouse, and the data basis of the enterprise for query operation is provided; automatically generating aperture combinations of dimension-indexes according to the keyword table, and establishing an aperture system, so that the generated aperture combinations of dimension-indexes can be adapted to the data change of the data warehouse, and the data change of the data warehouse can be reflected better; based on the keywords of the keyword table, the accuracy of dimension selection is improved by selecting keywords with the number of external keys or the proportion being greater than or equal to a preset number of times threshold or a preset proportion threshold as dimension keywords, so that the dimension keywords can be more suitable for large data processing requirements, and meanwhile, dimension keywords are selected by using external key statistics, so that the processing efficiency of later-stage data is improved and the consistency of the data is maintained; based on the keywords of the keyword table, keywords with low use rate or inconsistent keywords can be screened by selecting the keywords with the use number, the use rate and the use frequency reaching the threshold value from the keywords except the keys as index keywords, so that the data cleaning of a data warehouse is facilitated, the data utilization efficiency is improved, and the data consistency is maintained; according to the dimension keywords and the index keywords, dimension splitting is carried out according to different theme categories, the split dimension keywords and index keywords are stored into a plurality of dimension tables, the plurality of dimension tables correspond to a plurality of theme categories, the dimension keywords and the index keywords are split according to the theme categories, and the management of massive data in a dimension-division and layering manner is realized, so that the collection, storage and rapid and accurate data query of massive data are realized, the data processing efficiency is improved, timely and accurate data basis is provided for the decision of enterprises, the caliber system is utilized to obtain Chinese keywords corresponding to the query instructions, and English keywords corresponding to the query instructions are obtained according to a preset Chinese and English comparison root table, so that the keyword data specification is unified, and the later maintenance is easy; generating a target query instruction according to the English keywords corresponding to the acquired query instruction, writing attribute information corresponding to the target query instruction into template attributes corresponding to a preset script template, and generating a target script without repeatedly establishing the script, thereby avoiding a great deal 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 method for script aided design based on a root table, which specifically includes the following steps, as shown in fig. 4:

s1, establishing a keyword table;

preferably, the step S3 may specifically include the following steps:

s31, receiving a query instruction input by a user, and matching the query instruction with a standard query instruction in the caliber system to obtain a dimension-index combination corresponding to the standard query instruction which is successfully matched;

Preferably, the step S31 may specifically include the steps of:

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 caliber system;

the text content of the query instruction comprises the dimension keywords and index keywords in the corresponding query conditions, and the dimension keywords and index keywords are matched with the standard text content of the standard query instruction in the caliber system, wherein the standard text content is the dimension keywords and index keywords 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 caliber system is greater than or equal to a preset matching degree threshold, determining that the query instruction and the standard query instruction in the caliber system are successfully matched, and acquiring a dimension-index combination corresponding to the standard query instruction which is successfully matched according to the caliber 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 caliber system is larger than or equal to a preset matching degree threshold, determining that the query instruction is successfully matched with the standard query instruction in the caliber system, otherwise, prompting the user to input the query instruction again, and further, recording a log of the matching failure so as to update the caliber system in the later period to meet the user requirement. The specific implementation manner may include that word-by-word checking is performed on the word content of the query instruction input by the user and the standard word content of the standard query instruction in the caliber system, if the checking accuracy is greater than or equal to a preset accuracy, it may be determined that the matching degree between the word content of the query instruction input by the user and the standard word content of the standard query instruction in the caliber system is greater than or equal to the preset matching degree threshold, where the checking accuracy is used to indicate that the word content of the query instruction input by the user and the standard word content of the standard query instruction in the caliber system are checked to be the correct word number to account for the word number percentage of the word 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 caliber system are improved.

S32, obtaining Chinese keywords corresponding to the query instructions according to the dimension-index combinations corresponding to the standard query instructions successfully matched;

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 caliber system is successful, acquiring a standard dimension-index combination corresponding to the standard query instruction which is successfully matched, 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, so as to acquire the Chinese keyword corresponding to the query instruction input by the user.

S33, 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-English comparison root table;

splitting the obtained Chinese keywords corresponding to the query instruction input by the user, for example, city and access times, obtaining Chinese root words after splitting as city, access and times, and translating by the Chinese and English comparison root word table preset in the table 1 to obtain English root words as city, visit and time.

S34, combining the at least one English root word to generate English keywords corresponding to the query instruction.

And taking the obtained English root as the city, the visit and the time. And combining to generate English keywords city, visit_time. Generating a target query instruction according to the English keywords city and the English_time, wherein the query condition corresponding to the target query instruction comprises a city-English_time dimension-index combination formed by the English keywords.

The beneficial effects are 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 keywords 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 the standard query instruction in the caliber 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 caliber system is greater than or equal to a preset matching degree threshold, determining that the query instruction and the standard query instruction in the caliber system are successfully matched, and acquiring a dimension-index combination corresponding to the successfully matched standard query instruction according to the caliber system, thereby being beneficial to improving 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 caliber system; obtaining Chinese keywords corresponding to the query instructions according to the dimension-index combination corresponding to the standard query instructions which are successfully matched, splitting the Chinese keywords corresponding to the query instructions into at least one Chinese root, obtaining at least one English root corresponding to the at least one Chinese root through the preset Chinese-English comparison root table, combining the at least one English root to generate English keywords corresponding to the query instructions, generating target query instructions according to the obtained English keywords corresponding to the query instructions, and writing attribute information corresponding to the target query instructions into template attributes corresponding to a preset script template to generate a target script. And splitting the Chinese keywords into a plurality of roots by setting a root list, and acquiring corresponding English roots from the root list. The operation of generating English keywords for each Chinese keyword is avoided. Therefore, the maintenance of keywords and the management of a database are facilitated, the keyword data specification is unified, the later maintenance is easy, meanwhile, the auxiliary design of the script is completed by utilizing the preset script template, the script is not required to be repeatedly built, a large amount of repeated labor is avoided, the code length is shortened, and the workload is saved.

Example IV

The embodiment of the invention provides a script aided design device 500 based on a root table, as shown in fig. 5, the device comprises:

a first establishing module 510, configured to establish a keyword table;

the second establishing module 520 is configured to select 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 generate a dimension-index combination according to the dimension keyword and the index keyword, and establish an caliber system through the dimension-index combination;

the english keyword obtaining module 530 is configured to receive a query instruction input by a user, obtain a chinese keyword corresponding to the query instruction using the caliber system, and obtain an english keyword corresponding to the query instruction according to a preset chinese-english comparison root table;

the script generation module 540 is configured to generate a target query instruction according to the english keyword corresponding to the obtained query instruction, and write attribute information corresponding to the target query instruction into a template attribute corresponding to a preset script template, so as to generate a target script.

The embodiment of the invention provides a script aided design device 500 based on a root table, which corresponds to the script aided design method based on the root table in the above embodiment, and the script aided design device 500 further comprises a plurality of units for corresponding to the corresponding steps of the script aided design method to realize corresponding functions. Since the steps of the script aided design method have been described in detail in the above embodiments, the description of the device 500 is omitted.

The beneficial effects are that: according to the embodiment of the invention, a keyword table is pre-established through a first establishment module, a second establishment module selects at least one keyword as a dimension keyword and an index keyword according to a preset rule based on keywords of the keyword table, and automatically generates a dimension-index combination according to the dimension keyword and the index keyword, and an 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 utilizing the caliber system, and acquires English keywords corresponding to the query instruction according to a preset Chinese-English comparison root list; and the script generation module generates a target query instruction according to the English keywords corresponding to the acquired query instruction, and writes attribute information corresponding to the target query instruction into template attributes corresponding to a preset script template to generate a target script. In summary, it can be seen that the preset Chinese and English comparison word root table is used for obtaining the English keywords corresponding to the query instruction, so that the keyword data specification is unified, the later maintenance is easy, meanwhile, the auxiliary design of the script is completed by using the preset script template, the script is not required to be repeatedly built, 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 root table-based script aided design apparatus 600, where the apparatus includes a memory 610, a processor 620, and a computer program 630 stored in the memory 610 and capable of running on the processor 620, where the processor 620 implements the steps of any of the root table-based script aided design methods described in the foregoing embodiments when executing the computer program 630.

The embodiment of the invention also provides a computer storage medium, wherein the computer storage medium can store a program, and the program can be executed by the computer storage medium, and the program comprises part or all of the steps of any script aided design method based on a root table described in the embodiment of the method.

It should be noted that, for simplicity of description, the foregoing method embodiments are all described as a series of acts, but it should be understood by those skilled in the art that the present invention is not limited by the order of acts described, as some steps may be performed in other orders or concurrently in accordance with the present invention. Further, those skilled in the art will also appreciate that the embodiments described in the specification are all preferred embodiments, and that the acts and modules referred to are not necessarily required for the present invention.

In the foregoing embodiments, the descriptions of the embodiments are emphasized, and for parts of one embodiment that are not described in detail, reference may be made to related descriptions of other embodiments.

In the several embodiments provided by the present application, it should be understood that the disclosed apparatus may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative, such as the division of the units, merely a logical function division, and there may be additional manners of dividing the actual implementation, such as multiple units or components may be combined or integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, or may be in electrical or other forms.

The units described as separate units may or may not be physically separate, and units shown 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 may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.

The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable memory. Based on this understanding, the technical solution of the present invention may be embodied essentially or partly in the form of a software product, or all or part of the technical solution, 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 perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned memory includes: a U-disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.

Those of ordinary skill in the art will appreciate that all or a portion of the steps in the various methods of the above embodiments may be implemented by a program that instructs associated hardware, and the program may be stored in a computer readable memory, which may include: flash disk, read-Only Memory (ROM), random access Memory (Random Access Memory, RAM), magnetic disk or optical disk.

The foregoing has outlined rather broadly the more detailed description of embodiments of the invention, wherein the principles and embodiments of the invention are explained in detail using specific examples, the above examples being provided solely to facilitate the understanding of the method and core concepts of the invention; meanwhile, as those skilled in the art will have variations in the specific embodiments and application scope in accordance with the ideas of the present invention, the present description should not be construed as limiting the present invention in view of the above.

Claims

1. The script aided design method based on the root list is characterized by comprising the following steps:

establishing a keyword table;

based on the keywords of the keyword table, selecting at least one keyword as a dimension keyword and an index keyword according to a preset rule, carrying out dimension splitting according to different theme categories according to the dimension keyword, and storing the split dimension keyword into a plurality of dimension tables, wherein the plurality of dimension tables correspond to a plurality of theme categories; carrying out index splitting according to the index keywords and different dimensions, and storing the split index keywords into a plurality of index tables, wherein the index tables correspond to the dimensions; 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 utilizing the dimension-index combination and the standard query instructions corresponding to the dimension-index combination;

Receiving a query instruction input by a user, matching the query instruction with a standard query instruction in the caliber system, and obtaining a dimension-index combination corresponding to the standard query instruction which is successfully matched; acquiring a Chinese keyword corresponding to the query instruction according to the dimension-index combination corresponding to the standard query instruction successfully matched; 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 a preset Chinese-English comparison root table; combining the at least one English root word to generate English keywords corresponding to the query instruction;

2. The script aided design method of claim 1, wherein the establishing a 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, and establishing a keyword table.

3. The script aided design method of claim 2, wherein the selecting at least one keyword as a dimension keyword based on the keyword of the keyword table according to a preset rule specifically comprises:

acquiring a first source data table in the source data tables, 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 an external key, and selecting the primary key with the times larger than or equal to a preset times 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 alternatively, the process may be performed,

calculating the proportion of at least one main key in each first source data table as an external key, and selecting the main key with the proportion larger than or equal to a preset proportion threshold value from the at least one main key in the first source data table as a dimension key of the first source data table, wherein the first source data table is any one source data table in the source data tables.

4. The script aided design method of claim 3, wherein the selecting at least one keyword as an index keyword according to a preset rule based on the keyword of the keyword table specifically comprises:

Acquiring a second source data table in the source data table, and determining at least one keyword except for an external key in the second source data table;

calculating the use quantity of each keyword except the external key in the second source data table, and selecting at least one keyword from at least one keyword except the external key in the second source data table as an index keyword, wherein the index keyword is a keyword with the use quantity being larger than or equal to a preset use quantity threshold value;

or alternatively, the process may be performed,

calculating the utilization rate of each keyword except the external key in the second source data table, and selecting at least one keyword from at least one keyword except the external key in the second source data table as an index keyword, wherein the index keyword is a keyword with the utilization rate being greater than or equal to a preset utilization rate threshold;

or alternatively, the process may be performed,

calculating the use frequency of each keyword except the external key in the second source data table, and selecting at least one keyword from at least one keyword except the external key in the second source data table as an index keyword, wherein the index keyword is the keyword with the use number larger than or equal to a preset use frequency threshold value, and the second source data table is any one source data table except the first source data table in the source data table.

5. The script aided design method of claim 1, wherein the receiving the query command input by the user, matching the query command with the standard query command in the caliber system, and obtaining the dimension-index combination corresponding to the standard query command which 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 a standard query instruction in the caliber 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 caliber system is larger than or equal to a preset matching degree threshold, determining that the query instruction and the standard query instruction in the caliber system are successfully matched, and acquiring a dimension-index combination corresponding to the standard query instruction which is successfully matched according to the caliber system.

6. Script aided design device based on root list, its characterized in that, the device specifically includes:

the first establishing module is used for establishing a keyword table;

the second building 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, carrying out dimension splitting according to different theme categories according to the dimension keyword, and storing the split dimension keyword into a plurality of dimension tables, wherein the plurality of dimension tables correspond to a plurality of theme categories; carrying out index splitting according to the index keywords and different dimensions, and storing the split index keywords into a plurality of index tables, wherein the index tables correspond to the dimensions; 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 utilizing the dimension-index combination and the standard query instructions corresponding to the dimension-index combination;

The English keyword acquisition module is used for receiving a query instruction input by a user, matching the query instruction with a standard query instruction in the caliber system, and acquiring a dimension-index combination corresponding to the standard query instruction which is successfully matched; acquiring a Chinese keyword corresponding to the query instruction according to the dimension-index combination corresponding to the standard query instruction successfully matched; 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 a preset Chinese-English comparison root table; combining the at least one English root word to generate English keywords corresponding to the query instruction;

7. A root table based script aided design apparatus comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of a root table based script aided design method as claimed in any one of claims 1 to 5 when the computer program is executed by the processor.

8. A computer readable storage medium storing a computer program, wherein the computer program when executed by a processor implements the steps of a root table based script aided design method according to any one of claims 1 to 5.