CN110737432A - script aided design method and device based on root list - Google Patents
script aided design method and device based on root list Download PDFInfo
- Publication number
- CN110737432A CN110737432A CN201910894233.3A CN201910894233A CN110737432A CN 110737432 A CN110737432 A CN 110737432A CN 201910894233 A CN201910894233 A CN 201910894233A CN 110737432 A CN110737432 A CN 110737432A
- Authority
- CN
- China
- Prior art keywords
- keywords
- dimension
- query instruction
- 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.)
- Granted
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 script aided design methods and devices based on a root table, and the methods specifically comprise the steps of establishing a keyword table, establishing an aperture system based on the keyword table, acquiring Chinese keywords corresponding to a query instruction input by a user by using the aperture system, acquiring English keywords corresponding to the query instruction according to a preset Chinese and English comparison root table, 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.
Description
Technical Field
The invention relates to the field of scripts, in particular to an script aided design method and device based on a root word list.
Background
Script (Script) is an extension of batch files, is a program for storing plain texts, and is a computer Script program in , which is a combination of a certain series control computers to perform operation operations, wherein a certain logic branch in can be realized, 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 does not have the specification of the system , which causes a lot of repeated labor, and meanwhile, the code length is increased, and thus, the maintenance is not easy.
Disclosure of Invention
The embodiment of the invention provides script aided design methods and devices based on a root word list, and mainly aims to solve the problems that when a table is established, the workload is high, the key field data does not meet the standard of , a large amount of repeated labor is caused, the code length is increased, and the maintenance is difficult in the prior art by acquiring the corresponding key field data according to the combination of dimensionality and indexes.
, an embodiment of the present invention provides script aided design methods based on a root word list, including:
establishing a keyword table;
selecting at least keywords as dimension keywords and index keywords according to a preset rule based on the keywords of the keyword table, automatically generating a dimension-index combination according to the dimension keywords and the index keywords, and establishing an aperture 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 apparatus for script aided design based on root word list, the apparatus comprising:
, establishing module for establishing keyword table;
the second establishing module is used for selecting at least keywords as dimension keywords and index keywords according to a preset rule based on the keywords of the keyword table, automatically generating a dimension-index combination according to the dimension keywords and the index keywords, 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 script-aided design apparatuses based on root word lists, the apparatuses including a memory, a processor and a computer program stored in the memory and operable on the processor, wherein the processor executes the computer program to implement part or all of the steps of any script-aided design methods based on root word lists described in the above embodiments.
In a fourth aspect, the present invention further provides computer storage media, where the computer storage media may store a program, and when the program is executed, the program implements part or all of the steps of any script aided design method based on a root word list described in the above embodiments.
The method has the advantages that the keyword table is established in advance, at least keywords are selected as dimension keywords and index keywords according to the preset rules based on the keywords of the keyword table, the dimension-index combination is automatically generated according to the dimension keywords and the index keywords, the caliber system is established according to the dimension-index combination, the query instruction input by a user is received, the Chinese keywords corresponding to the query instruction are acquired by the caliber system, the English keywords corresponding to the query instruction are acquired according to the preset Chinese and English comparison word root table, the target query instruction is generated according to the English keywords corresponding to the acquired query instruction, the attribute information corresponding to the target query instruction is written into the template attributes corresponding to the preset script template, and the target script is generated.
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 embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a schematic flowchart of script aided design methods based on a root table according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart illustrating the establishment of a keyword table in another script-assisted design methods based on a root word table according to embodiments of the present invention;
fig. 3 is a schematic flow chart illustrating the establishment of an aperture system in another script-aided design methods based on a root word list according to an embodiment of the present invention;
fig. 4 is a flowchart illustrating another script aided design methods based on a root table according to a third embodiment of the present invention;
FIG. 5 is a schematic structural diagram of script aided design apparatuses based on a root table according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of types of script aided design apparatuses based on a root table according to an embodiment of the present invention.
Detailed Description
For those skilled in the art to better understand the technical solution of the present invention, the technical solution in the embodiment of the present invention will be clearly and completely described below with reference to the drawings in the embodiment of the present invention, and it is obvious that the described embodiment is only a partial embodiment of of the present invention, rather than a complete embodiment.
The following are detailed below.
The terms "," "second," "third," and "fourth," etc. in the description and claims of this invention and the accompanying drawings are used to distinguish between different objects and not necessarily to describe a particular order.
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 embodiments of the present 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.
Embodiments of the present application are described below with reference to the drawings.
Example
According to aspects of the invention, script aided design methods based on a root word list are provided, which specifically comprise 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 the data management server, the data management server is composed of /multiple computers running in the local area network and the data management system software, and the data management server provides the management service of the user data.
Specifically, a source data table when data in a data warehouse is checked every day may be counted, where the source data table includes a table name, a description field, and description information corresponding to the description field, keywords are extracted from the description information in each row of source data in the counted source data table, and the extracted keywords are generated into a keyword table, where the keywords in the keyword table correspond to the description information in each row of source data.
S2, based on keywords of the keyword table, selecting at least keywords as dimension keywords and index keywords according to a preset rule, automatically generating a dimension-index combination according to the dimension keywords and the index keywords, and establishing a caliber system through the dimension-index combination;
selecting at least keywords from every generated keyword tables according to a preset rule as dimension keywords of the keyword tables, setting the dimension keywords as dimensions of the caliber system, selecting at least keywords as index keywords of the keyword tables, and setting the dimension keywords as indexes of the caliber system.
The selected dimension key words and the index key words are automatically generated into dimension-index combinations, such as city-Shanghai, if source data of which the login city is Shanghai is required to be inquired from a data warehouse, the corresponding data query instructions are automatically generated according to the generated flow web page access daily table, the city and the 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 through 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, step , the query instructions corresponding to all the dimension-index combinations can be generated through a traversal principle, a caliber system is established by utilizing the dimension-index combinations and the corresponding query instructions, the caliber system comprises the table name, the table field, the dimension key words, the index key words and the query instructions corresponding to all the dimension-index combinations, the corresponding query instructions are automatically generated according to the dimension-index combinations, and the corresponding query instructions are executed when the query is required, the required source data can be queried, and the work load of data processing of the warehouse 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 the Chinese keywords corresponding to the query instruction obtained by the caliber system are translated in a contrast way by utilizing the Chinese and English contrast root table set in the table 1, and the English keywords corresponding to the Chinese keywords of the query instruction are obtained, so that the keyword data specification system is realized in such a way, 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 keyword of the specification system , attribute information corresponding to the target query instruction includes query conditions, query steps and query results, where the query conditions are query conditions defined by dimensions and indexes, for example, a query instruction with a dimension being a city and an index being an access number is queried from a data warehouse, where the query conditions of the query instruction are defined by the city and the access number, the query steps are a sequence of extracting source data from the data warehouse during execution of the query instruction, for example, the query instructions with the dimension being the city and the index being the access number are extracted from the source data with the dimension being the city, the query steps are extracting source data with the dimension being the city and then extracting source data with the index being the access number from the source data with the dimension being the city, the query results may be a manner of feeding back the source data obtained by querying a script after the query script query instruction is executed, for example, including but not limited to tables, bar charts or thermal charts, or templates, so that the query efficiency of generating the target query instructions is improved, and the query instructions may be automatically set according to the query conditions that the query instructions are repeated.
The method has the advantages that the keyword table is established in advance, at least keywords are selected as dimension keywords and index keywords according to the preset rules based on the keywords of the keyword table, the dimension-index combination is automatically generated according to the dimension keywords and the index keywords, the caliber system is established according to the dimension-index combination, the query instruction input by a user is received, the Chinese keywords corresponding to the query instruction are acquired by the caliber system, the English keywords corresponding to the query instruction are acquired according to the preset Chinese and English comparison word root table, the target query instruction is generated according to the English keywords corresponding to the acquired query instruction, the attribute information corresponding to the target query instruction is written into the template attributes corresponding to the preset script template, and the target script is generated.
Example two
On the basis of the above embodiment, the present invention further provides script aided design methods based on a root word list, which specifically include the following steps, as shown in fig. 2:
s1, establishing a keyword table;
the specific implementation of step S1 is described in detail in the foregoing embodiments, and is not described herein again, and in step , step S1 may further 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;
the data in the data warehouse is generally retained for a long time so that the enterprise can perform query operations for enterprise decision-making.
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 description fields, the description fields comprise corresponding description information, and the corresponding description information in the description fields is replaced by keywords to establish a keyword table.
The keywords in the keyword table correspond to the description information only corresponding to each row 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 keywords as dimension keywords and index keywords according to a preset rule, automatically generating a dimension-index combination according to the dimension keywords and the index keywords, and establishing a caliber 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 keywords are selected as the dimension keywords according to a preset rule, and the method specifically includes:
s21, acquiring a th source data table in the source data tables, and determining at least primary keys in a th source data table;
randomly acquiring th source data table from the source data table generated in the process of counting the data warehouse in the preset time, determining at least 1 primary keys (primary keys) in the 0 th source data table, wherein the primary keys are unique keys in the table, the values of the primary keys are used for identifying records in the unique identification table, and only can determine row data or in the table to determine entities.
S22, calculating the times of taking at least main keys in source data tables as foreign keys, and selecting the main keys with the times of taking the foreign keys being more than or equal to a preset time threshold value from at least main keys in source data tables as dimension keys of source data tables;
or, preferably, the proportion of at least primary keys in every source data tables as foreign keys is calculated, the primary keys with the proportion of the foreign keys being larger than or equal to a preset proportion threshold value are selected from at least primary keys in the source data tables as dimension keys of the source data tables, and the source data table is any source data tables in the source data tables;
the number of times or the proportion of the primary key is equal to the primary key, wherein the primary key is equal to the number of times or the proportion of the primary key is equal to the number of times or the number of times, wherein the primary key is equal to the number of times or the number of times, wherein the number of times or the primary key is equal to the number of times or the number is equal to the number of times, wherein the primary key is equal to the number of times or the number is equal to the number of times, wherein the primary key is equal to the number of times or the primary key is equal to the number of times or the number of times, wherein the number is equal to the primary key is equal to the number of times or the number is equal to the number of times, wherein the number is equal to the.
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 keywords are selected as index keywords according to a preset rule, and the method specifically includes:
s23, acquiring a second source data table in the source data tables, and determining at least keywords except the foreign 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 th source data table, at least keywords are determined except for the foreign key in the second source data table, and the at least keywords do not include the primary keyword which is used as the foreign key and is used as the foreign key, wherein 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 keywords except the foreign key in the second source data table, and selecting at least keywords as index keywords from at least keywords except the foreign key in the second source data table, wherein the index keywords are keywords of which the usage number is greater than or equal to a preset usage number threshold;
or, preferably, calculating the usage rate of each keywords except the foreign key in the second source data table, and selecting at least keywords from at least keywords except the foreign key in the second source data table as index keywords, where the index keywords are keywords whose usage rate is greater than or equal to a preset usage rate threshold;
or, preferably, calculating the usage frequency of every keywords except the foreign key in the second source data table, selecting at least keywords from at least keywords except the foreign key in the second source data table as index keywords, where the index keywords are keywords whose usage number is greater than or equal to a preset usage frequency threshold, and the second source data table is any source data tables except the source data table;
the method comprises the steps of respectively calculating the use number, the use rate or the use frequency of at least keywords except for foreign keys in each second source data tables, selecting the keywords of which the use number is greater than or equal to a preset use number threshold as index keywords, or selecting the keywords of which the use rate is greater than or equal to a preset use rate threshold as index keywords, or selecting the keywords of which the use frequency is greater than or equal to a preset use frequency threshold as index keywords, and setting the index keywords as indexes of the caliber system.
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;
the dimension key words are dimension split according to different subject categories, wherein the subject categories can be preset, all the dimension key words are dimension split, the dimension key words after being split are stored in a plurality of different dimension tables, each dimension tables correspond to subject categories, for example, the subject categories of the dimension key word login ID, the page ID, the browser cookie and the dimension key word login ID, the page ID, the browser cookie, the IP, the city and the channel identification in the table 2 and the table 3 are Web, the subject categories of the App, the user behavior and the like can be preset, the dimension key words are split according to the subject categories, the dimension-based hierarchical management of mass data is realized, the collection, the storage and the rapid and accurate data query of the mass data 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 same step S41, the index keywords are dimensionally split according to different topic categories, where the topic categories may be preset, all the index keywords are dimensionally split, the split index keywords are stored in a plurality of different index tables, each index table corresponds to topic categories, for example, the index keyword first access date, last access date , insertion time, user insertion and partition date in table 2, and the topic categories of the index keyword access times, landing page times, page exit times, insertion time, user insertion and partition date in table 3 are Web, it can be seen that the index keyword of which the topic category is Web is the attribute of the dimension keyword in step S41, the topic category can also be preset as App, user behavior, etc., the index keywords are split according to the topic categories, and management of the massive data in the dimensional and hierarchical level is implemented, thereby implementing collection, storage and fast and accurate data query of the massive data, improving the efficiency of data processing, and providing an accurate basis for enterprise data decision-based on time.
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-indicator combination in table 4 above corresponds to query instructions, and a caliber system is established by using the dimension-indicator combination and its corresponding query instruction, as shown in table 5:
TABLE 5
If the 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 the 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.
The method has the advantages that a source data table for counting verification of a data warehouse is regularly used, description information corresponding to description fields in the source data table is replaced by keywords, a keyword table is established, whether source data in the data warehouse and updated final data are balanced or not is regularly verified, data consistency is improved, so that a user can extract and clear data with a value beneficial to an enterprise from the source data and finally the data are stored in the data warehouse, a data base for query operation of the enterprise is provided, an aperture system is established according to an aperture combination of the keywords table, the generated aperture combination can be adaptive to data change of the data warehouse and better reflect the data change of the data warehouse, based on keywords of the keyword table, a keyword with an English number of times or a ratio larger than or equal to a preset number threshold or a preset ratio threshold is selected as a keyword, accuracy of dimension selection is improved, the requirement for processing of larger data is met, meanwhile, dimension statistics is selected by using the keywords as an English number of times or a ratio larger than or equal to a preset number of times or a ratio threshold value, or a keyword ratio of a preset number of a keyword to a keyword is selected as a keyword, a keyword corresponding index, a keyword is obtained by a keyword, a keyword system, a keyword corresponding index, a keyword is obtained by a keyword, a keyword is obtained by a keyword system, a keyword corresponding index, a keyword is obtained by a keyword system, a keyword is obtained by a keyword with a keyword, a keyword corresponding index, a keyword is obtained by a keyword, a keyword is obtained by a keyword, a keyword is obtained by a keyword with a keyword, a keyword is obtained by a keyword, a keyword is obtained by a keyword, a keyword is obtained by a keyword system, a keyword is obtained by a keyword.
EXAMPLE III
On the basis of any of the above embodiments, the present invention further provides another script aided design methods 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 keywords as dimension keywords and index keywords according to a preset rule, automatically generating a dimension-index combination according to the dimension keywords and the index keywords, and establishing a caliber 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.
The specific implementation manner may include 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 the preset matching degree threshold, and the checking accuracy rate is used for indicating that the correct word count for checking 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 text content of the query instruction input by the user, and the standard 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 higher than or equal to the preset matching degree threshold, so that the accuracy rate of 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 improved by the matching rate between the text content of the query instruction input by the user and the standard text content of the standard query instruction input by the aperture system.
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 keywords corresponding to the query instruction into at least Chinese word roots, and acquiring at least English word roots corresponding to at least Chinese word roots through the preset Chinese and English reference root list;
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 English roots to generate English keywords 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 keyword of the specification system , attribute information corresponding to the target query instruction includes query conditions, query steps and query results, where the query conditions are query conditions defined by dimensions and indexes, for example, a query instruction with a dimension being a city and an index being an access number is queried from a data warehouse, where the query conditions of the query instruction are defined by the city and the access number, the query steps are a sequence of extracting source data from the data warehouse during execution of the query instruction, for example, the query instructions with the dimension being the city and the index being the access number are extracted from the source data with the dimension being the city, the query steps are extracting source data with the dimension being the city and then extracting source data with the index being the access number from the source data with the dimension being the city, the query results may be a manner of feeding back the source data obtained by querying a script after the query script query instruction is executed, for example, including but not limited to tables, bar charts or thermal charts, or templates, so that the query efficiency of generating the target query instructions is improved, and the query instructions may be automatically set according to the query conditions that the query instructions are repeated.
The method has the advantages that a keyword table is established in advance, at least keywords are selected as dimension keywords and index keywords according to preset rules based on the keywords of the keyword table, a dimension-index combination is automatically generated according to the dimension keywords and the index keywords, an aperture system is established through the dimension-index combination, a query instruction input by a user is received, the text content of the query instruction is matched 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 larger than or equal to a preset matching degree threshold value, the matching efficiency and the matching accuracy between the query instruction and the standard text content of the standard query instruction in the aperture system are determined to be successful, the dimension-index combination corresponding to the successfully matched standard query instruction is obtained according to the aperture system, the method is beneficial to improving the matching efficiency and the matching efficiency 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 and the English script corresponding to the standard query instruction and the Chinese script is easy to obtain a large number of English keywords corresponding to the keyword combinations, the keyword information, the keyword database is not needed to be obtained, the keyword database is saved, the keyword database corresponding keyword database is created, the keyword database corresponding to the keyword database, the keyword database corresponding English query instruction, the keyword information of the keyword corresponding English script corresponding keyword is saved, the keyword is saved keyword database, the keyword database is created by the keyword corresponding keyword database, the keyword database is created by the keyword database, the keyword database is created by the keyword database, the keyword database is created, the keyword database is created by the keyword database created by the.
Example four
The embodiment of the present invention provides script aided design apparatuses 500 based on a root table, as shown in fig. 5, the apparatuses include:
, a creating module 510 for creating a keyword table;
a second establishing module 520, configured to select at least keywords as dimension keywords and index keywords according to a preset rule based on the keywords of the keyword table, automatically generate a dimension-index combination according to the dimension keywords and the index keywords, 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 script aided design apparatuses 500 based on the root table provided in the embodiments of the present invention are corresponding to the script aided design methods based on the root table in the above embodiments, and the script aided design apparatuses 500 further include several units for corresponding to the corresponding steps of the script aided design methods to implement the corresponding functions.
The method has the advantages that the keyword table is pre-established through the th establishing module, the second establishing module selects at least keywords as dimension keywords and index keywords according to a preset rule based on the keywords of the keyword table, a dimension-index combination is automatically generated according to the dimension keywords and the index keywords, the dimension-index combination is established through the dimension-index combination, the English keyword obtaining module receives a query instruction input by a user, Chinese keywords corresponding to the query instruction are obtained through the dimension system, English keywords corresponding to the query instruction are obtained according to a preset Chinese and English comparison word root table, the script generating module generates a target query instruction according to the obtained English keywords corresponding to the query instruction, attribute information corresponding to the target query instruction is written into template attributes corresponding to a preset script template, a target script is generated, and in conclusion, the English keyword system corresponding to the query instruction is obtained through the preset Chinese and English comparison word root table, keyword data is easy for later maintenance, meanwhile, a script corresponding to the preset English template attribute is generated, repeated work amount is avoided, and repeated work code design is avoided.
EXAMPLE five
The embodiment of the present invention further provides script aided design apparatuses 600 based on a root word list, where the apparatuses include a memory 610, a processor 620, and a computer program 630 stored in the memory 610 and operable on the processor 620, and when the computer program 630 is executed by the processor 620, the steps of any script aided design methods based on a root word list described in the above embodiments are implemented.
The embodiment of the present invention further provides computer storage media, where the computer storage media may store a program, and when the program is executed, the program includes some or all of the steps of any 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 aforementioned method embodiments are described as series combinations of acts, but those skilled in the art will recognize that the present invention is not limited by the order of acts described, as some steps may occur in other orders or concurrently with other steps in accordance with 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.
For example, the above-described embodiments of the apparatus are merely illustrative, such as the division of the units described, only the logical function divisions, and other divisions may be possible in actual implementation, such as multiple units or components may be combined or integrated into another systems, or features may be omitted, or not executed, another point, and the shown or discussed mutual coupling or direct coupling or communication connection may be through interfaces, indirect coupling or communication connection of the apparatuses or units, and may be electrical or other forms.
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, that is, may be located in places, or may also be distributed on multiple network units.
In addition, the functional units in the embodiments of the present invention may be integrated into processing units, or each unit may exist alone physically, or two or more units are integrated into units.
Based on the understanding, the technical solution of the present invention, which is essentially or partially contributed to by the prior art, or all or part of the technical solution, may be embodied in the form of a software product stored in memories, and includes several instructions for making computer devices (which may be personal computers, servers, or network devices, etc.) execute all or part of the steps of the methods described in the embodiments of the present invention.
It will be understood by those skilled in the art that all or part of the steps in the methods of the above embodiments may be implemented by hardware instructions of a program, which may be stored in computer readable Memory, where the Memory may include flash Memory, Read-Only Memory (ROM), Random Access Memory (RAM), magnetic or optical disk, and the like.
While the embodiments of the present invention have been described in detail, the principles and embodiments of the present invention have been illustrated and described herein by means of specific examples, which are provided only for the purpose of facilitating understanding of the method and the core concept of the present invention, and meanwhile, for those skilled in the art , the description should not be construed as limiting the present invention in view of the above description.
Claims (10)
1, script aided design method based on root list, the method includes:
establishing a keyword table;
selecting at least keywords as dimension keywords and index keywords according to a preset rule based on the keywords of the keyword table, automatically generating a dimension-index combination according to the dimension keywords and the index keywords, and establishing an aperture 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 keywords as dimension keywords according to a preset rule based on the keywords of the keyword table specifically comprises:
obtaining th source data table in the source data tables, and determining at least primary keys in the th source data table;
calculating the times of taking at least main keys in each source data tables as foreign keys, and selecting the main keys with the times of taking the foreign keys being more than or equal to a preset time threshold value from at least main keys in the source data tables as dimension keys of the source data tables;
alternatively, the first and second electrodes may be,
calculating the proportion of at least main keys in each source data tables as foreign keys, selecting the main keys which are used as foreign keys and have the proportion larger than or equal to a preset proportion threshold value from at least main keys in the source data tables as dimension keys of the source data tables, wherein the source data table is any source data tables in the source data tables.
4. The script aided design method according to claim 3, wherein the selecting at least keywords as index keywords 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 tables, and determining at least keywords except an exception key in the second source data table;
calculating the usage number of every keywords except the foreign key in the second source data table, and selecting at least keywords from at least keywords except the foreign key in the second source data table as index keywords, wherein the index keywords are keywords of which the usage number is greater than or equal to a preset usage number threshold;
alternatively, the first and second electrodes may be,
calculating the utilization rate of every keywords except the foreign key in the second source data table, and selecting at least keywords from at least keywords except the foreign key in the second source data table as index keywords, wherein the index keywords are keywords of which the utilization rate is greater than or equal to a preset utilization rate threshold;
alternatively, the first and second electrodes may be,
calculating the use frequency of every keywords except the foreign key in the second source data table, selecting at least keywords from at least keywords except the foreign key in the second source data table as index keywords, wherein the index keywords are keywords 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 source data tables except the 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-5 and , wherein the receiving a query instruction input by a user, obtaining a chinese keyword corresponding to the query instruction by using the aperture system, and obtaining an english keyword corresponding to the query instruction according to a preset chinese-english comparison 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 Chinese roots, and acquiring at least English roots corresponding to the at least Chinese roots through the preset Chinese and English comparison root list;
and combining the at least English roots to generate English keywords 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, script aided design device based on root list, which is characterized in that the device specifically includes:
, establishing module for establishing keyword table;
the second establishing module is used for selecting at least keywords as dimension keywords and index keywords according to a preset rule based on the keywords of the keyword table, automatically generating a dimension-index combination according to the dimension keywords and the index keywords, 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, apparatus for script aided design based on root word list, the apparatus 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 the method for script aided design based on root word list as claimed in any of claims 1 to 7 and .
10, computer-readable storage medium, in which a computer program is stored, which, when being executed by a processor, carries out the steps of the root-table-based script aided design method as claimed in any of claims 1-7- .
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910894233.3A CN110737432B (en) | 2019-09-20 | 2019-09-20 | Script aided design method and device based on root list |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910894233.3A CN110737432B (en) | 2019-09-20 | 2019-09-20 | Script aided design method and device based on root list |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110737432A true CN110737432A (en) | 2020-01-31 |
| CN110737432B CN110737432B (en) | 2023-10-20 |
Family
ID=69269406
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910894233.3A Active CN110737432B (en) | 2019-09-20 | 2019-09-20 | Script aided design method and device based on root list |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110737432B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110837365A (en) * | 2019-11-08 | 2020-02-25 | 深圳市彬讯科技有限公司 | Script aided design method and device based on root table |
| CN110909128A (en) * | 2019-11-08 | 2020-03-24 | 深圳市彬讯科技有限公司 | Method, equipment and storage medium for data query by using root table |
| CN115826991A (en) * | 2023-02-14 | 2023-03-21 | 江西曼荼罗软件有限公司 | Software script generation method, system, computer and readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020103809A1 (en) * | 2000-02-02 | 2002-08-01 | Searchlogic.Com Corporation | Combinatorial query generating system and method |
| CN107729336A (en) * | 2016-08-11 | 2018-02-23 | 阿里巴巴集团控股有限公司 | Data processing method, equipment and system |
| CN109062946A (en) * | 2018-06-21 | 2018-12-21 | 深圳市彬讯科技有限公司 | It is a kind of to highlight method and device based on multiple web pages |
| CN109145110A (en) * | 2018-06-29 | 2019-01-04 | 深圳市彬讯科技有限公司 | Information classification processing, tag queries method and apparatus based on label |
-
2019
- 2019-09-20 CN CN201910894233.3A patent/CN110737432B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020103809A1 (en) * | 2000-02-02 | 2002-08-01 | Searchlogic.Com Corporation | Combinatorial query generating system and method |
| CN107729336A (en) * | 2016-08-11 | 2018-02-23 | 阿里巴巴集团控股有限公司 | Data processing method, equipment and system |
| CN109062946A (en) * | 2018-06-21 | 2018-12-21 | 深圳市彬讯科技有限公司 | It is a kind of to highlight method and device based on multiple web pages |
| CN109145110A (en) * | 2018-06-29 | 2019-01-04 | 深圳市彬讯科技有限公司 | Information classification processing, tag queries method and apparatus based on label |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110837365A (en) * | 2019-11-08 | 2020-02-25 | 深圳市彬讯科技有限公司 | Script aided design method and device based on root table |
| CN110909128A (en) * | 2019-11-08 | 2020-03-24 | 深圳市彬讯科技有限公司 | Method, equipment and storage medium for data query by using root table |
| CN110909128B (en) * | 2019-11-08 | 2023-08-11 | 土巴兔集团股份有限公司 | Method, equipment and storage medium for carrying out data query by using root list |
| CN115826991A (en) * | 2023-02-14 | 2023-03-21 | 江西曼荼罗软件有限公司 | Software script generation method, system, computer and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110737432B (en) | 2023-10-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110321344B (en) | Information query method and device for associated data, computer equipment and storage medium | |
| CN110292775B (en) | Method and device for acquiring difference data | |
| US8990241B2 (en) | System and method for recommending queries related to trending topics based on a received query | |
| WO2019062001A1 (en) | Intelligent robotic customer service method, electronic device and computer readable storage medium | |
| US20140280070A1 (en) | System and method for providing technology assisted data review with optimizing features | |
| CN108647357B (en) | Data query method and device | |
| US20180004781A1 (en) | Data lineage analysis | |
| US9305076B1 (en) | Flattening a cluster hierarchy tree to filter documents | |
| CN110737432A (en) | script aided design method and device based on root list | |
| CN110659282B (en) | Data route construction method, device, computer equipment and storage medium | |
| CN110716950B (en) | Caliber system establishment method, caliber system establishment device, caliber system establishment equipment and computer storage medium | |
| CN110046298A (en) | Query word recommendation method and device, terminal device and computer readable medium | |
| CN111008521A (en) | Method and device for generating wide table and computer storage medium | |
| CN110990403A (en) | Business data storage method, system, computer equipment and storage medium | |
| CN110727857A (en) | Method and device for identifying key features of potential users aiming at business objects | |
| CN115203435A (en) | Entity relation generation method and data query method based on knowledge graph | |
| CN101976394A (en) | Data acquiring and counting system and method | |
| US20150379112A1 (en) | Creating an on-line job function ontology | |
| CN113538154A (en) | Risk object identification method and device, storage medium and electronic equipment | |
| CN109636303B (en) | Storage method and system for semi-automatically extracting and structuring document information | |
| CN111444368B (en) | Method and device for constructing user portrait, computer equipment and storage medium | |
| WO2019080419A1 (en) | Method for building standard knowledge base, electronic device, and storage medium | |
| CN110837365A (en) | Script aided design method and device based on root table | |
| CN112800127B (en) | Data mining analysis method and device based on transaction bill | |
| CN115495587A (en) | Alarm analysis method and device based on knowledge graph |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |