CN109101541A - Newly-increased INDEX MANAGEMENT method, equipment and computer readable storage medium - Google Patents
Newly-increased INDEX MANAGEMENT method, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN109101541A CN109101541A CN201810709881.2A CN201810709881A CN109101541A CN 109101541 A CN109101541 A CN 109101541A CN 201810709881 A CN201810709881 A CN 201810709881A CN 109101541 A CN109101541 A CN 109101541A
- Authority
- CN
- China
- Prior art keywords
- index
- newly
- increased
- title
- target indicator
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of newly-increased INDEX MANAGEMENT method, equipment and computer readable storage mediums, wherein this method comprises: receiving index newly-added information;Wherein, index newly-added information includes the Name and Description information of newly-increased index;Judge in the index classification table constructed in advance with the presence or absence of primary statistics index corresponding with the title of newly-increased index;When primary statistics index corresponding with the title of newly-increased index being not present in index classification table, according to the title of newly-increased index, the determining target indicator specific name with the name-matches of newly-increased index from multiple index classification titles that index classification table records;According to the description information of target indicator specific name, the title of newly-increased index and newly-increased index, target indicator is added in index classification table, can precisely, rapidly record have primary statistics index index classification table in increase newly target indicator, it avoids omitting achievement data, promotes the comprehensive of subsequent indicator-specific statistics data.
Description
Technical field
The present invention relates to data processing field more particularly to a kind of newly-increased INDEX MANAGEMENT methods, equipment and computer-readable
Storage medium.
Background technique
With the fast development of Internet service, internet services data is increasing, simultaneously because market competition is more next
Fiercer, business event needs to carry out adjustment in real time according to market and updates, to enhance enterprise in the competitiveness in market.It certainly is increasing
Competitiveness of the strong enterprise in market, it is also necessary to index analysis be carried out according to the transaction history data that service line has generated, to industry
Business carries out targetedly adjustment and updates.Specifically, when carrying out indicator-specific statistics calculating for service line, due to being lacked in statistical indicator
The index increased newly in few updated business, and traditional INDEX MANAGEMENT method is difficult to newly-increased index, so as to cause many indexs
Data cause subsequent indicator-specific statistics data not comprehensive, it is difficult to meet business demand by omission.
Summary of the invention
The main purpose of the present invention is to provide a kind of newly-increased INDEX MANAGEMENT method, equipment and computer-readable storage mediums
Matter is difficult to newly-increased index to solve traditional INDEX MANAGEMENT method and causes subsequent finger so as to cause many achievement datas by omission
It is not comprehensive to mark statistical data, it is difficult to the problem of meeting business demand.
To achieve the above object, the present invention provides a kind of newly-increased INDEX MANAGEMENT methods, comprising:
Receive index newly-added information;Wherein, index newly-added information includes the Name and Description information of newly-increased index;
Judge in the index classification table constructed in advance with the presence or absence of primary statistics index corresponding with the title of newly-increased index;
Wherein, index classification table record has a plurality of primary statistics index, and primary statistics index includes index name and index name pair
The index classification title and various dimensions description information answered;
When primary statistics index corresponding with the title of newly-increased index being not present in index classification table, according to newly-increased index
Title, the determining target indicator with the name-matches of newly-increased index from multiple index classification titles that index classification table records
Specific name;
According to the description information of target indicator specific name, the title of newly-increased index and newly-increased index, in index classification
Target indicator is added in table.
Wherein, determining and new from multiple index classification titles that index classification table records according to the title of newly-increased index
The step of increasing the target indicator specific name of the name-matches of index, comprising:
Calculate the semantic similarity of the title of newly-increased index and each index classification title of index classification table record;
The corresponding index classification name of maximum value in calculated multiple semantic similarities is referred to as target indicator classification
Title.
Wherein, various dimensions description information include: the corresponding guideline code of index name, index interpretation, index generating mode,
Index classification mark, index mark and index unit;
Target indicator includes target indicator specific name, the title of newly-increased index, the corresponding index of title of newly-increased index
Code, index interpretation, index generating mode, index classification mark, index mark and index unit.
Wherein, according to the description information of target indicator specific name, the title of newly-increased index and newly-increased index, in index
The step of target indicator is added in classification chart, comprising:
According to the title of newly-increased index, the corresponding guideline code of title of newly-increased index is obtained;
According to the description information of newly-increased index, the corresponding index interpretation of title, the index generating mode of newly-increased index are obtained
And index unit;
According to target indicator specific name, the title for obtaining newly-increased index corresponds to index classification mark and index mark;
By the corresponding target indicator of title for adding the title and newly-increased index of newly-increased index in index classification table
Specific name, guideline code, index interpretation, index generating mode, index classification mark, index mark and index unit, are referring to
Target indicator is added in mark classification chart.
Wherein, according to the title of newly-increased index, the step of obtaining the title corresponding guideline code of newly-increased index, comprising:
It is English name by the Title Translation of newly-increased index;
According to English name, the corresponding guideline code of title of newly-increased index is obtained.
Wherein, according to the description information of newly-increased index, the corresponding index interpretation of title of newly-increased index is obtained, index generates
The step of mode and index unit, comprising:
The description information of newly-increased index is parsed, obtains the corresponding index unit of title of newly-increased index, for referring to
Show the statistical information of the targeted scope of statistics of newly-increased index and is used to indicate whether newly-increased index is the finger for adding up type index
Show information;
Using statistical information as the corresponding index interpretation of title of newly-increased index;
Information will be indicated as the corresponding index generating mode of title of newly-increased index.
Wherein, according to target indicator specific name, the title for obtaining newly-increased index corresponds to index classification mark and index mark
The step of knowledge, comprising:
The corresponding target of target indicator specific name is determined from a plurality of primary statistics index that index classification table records
Index classification mark, and index classification mark is corresponded to using target indicator class indication as the title of newly-increased index;
Configuration rule is identified according to target indicator class indication and preset index, configures correspondence to increase the title of index newly
Index mark.
Wherein, in the description information according to target indicator specific name, the title of newly-increased index and newly-increased index, referring to
After marking the step of adding target indicator in classification chart, method further include:
Generate the structured query language SQL statement for inquiring target indicator.
The present invention also provides a kind of newly-increased INDEX MANAGEMENT equipment, including memory, processor and it is stored in memory
In and the computer program that can run on a processor, the processor realize above-mentioned newly-increased index pipe when executing computer program
The step of reason method.
The present invention also provides a kind of computer readable storage medium, computer-readable recording medium storage has computer journey
The step of sequence, which realizes above-mentioned newly-increased INDEX MANAGEMENT method when being executed by processor.
Above scheme of the invention is include at least the following beneficial effects:
In an embodiment of the present invention, in the index newly-added information for receiving the Name and Description information including increasing index newly
When, by judging in the index classification table that constructs in advance with the presence or absence of primary statistics index corresponding with the title of newly-increased index,
And when primary statistics index corresponding with the title of newly-increased index being not present in index classification table, according to the name of newly-increased index
Claim, the determining target indicator with the name-matches of newly-increased index is classified from multiple index classification titles that index classification table records
Title, finally according to the description information of target indicator specific name, the title of newly-increased index and newly-increased index, can precisely,
It rapidly increases target indicator newly in the index classification table that record has primary statistics index, avoids omitting index number to reach
According to promoting the comprehensive of subsequent indicator-specific statistics data, meet the effect of business demand.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
The structure shown according to these attached drawings obtains other attached drawings.
Fig. 1 is the flow chart for increasing INDEX MANAGEMENT method in first embodiment of the invention newly;
Fig. 2 is the flow chart for adding target indicator in first embodiment of the invention in index classification table;
Fig. 3 is the corresponding index interpretation of title, the index generating mode that newly-increased index is obtained in first embodiment of the invention
With the flow chart of index unit;
Fig. 4 is the schematic diagram that the index classification table before target indicator is added in an example of the invention;
Fig. 5 is the schematic diagram that the index classification table after target indicator is added in an example of the invention;
Fig. 6 is the structural schematic diagram for increasing INDEX MANAGEMENT equipment in second embodiment of the invention newly.
Specific embodiment
The exemplary embodiment that the present invention will be described in more detail below with reference to accompanying drawings.Although showing the present invention in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the present invention without should be by embodiments set forth here
It is limited.It is to be able to thoroughly understand the present invention on the contrary, providing these embodiments, and can be by the scope of the present invention
It is fully disclosed to those skilled in the art.
First embodiment
As shown in Figure 1, specific embodiments of the present invention provide a kind of newly-increased INDEX MANAGEMENT method, comprising:
Step 11, index newly-added information is received;Wherein, index newly-added information includes the Name and Description letter of newly-increased index
Breath.
Wherein, in a specific embodiment of the present invention, the title of above-mentioned newly-increased index can start for application program (APP)
The titles such as number, new visitor's number;Foregoing description information includes: that the corresponding index unit of title of newly-increased index is (such as secondary, a
Deng), be used to indicate the statistical information of the targeted scope of statistics of newly-increased index and be used to indicate whether newly-increased index is accumulative
The instruction information of type index.It illustrates, it is assumed that the entitled APP number of starts of newly-increased index, statistical information can be default
Total opening number of period (such as one week) interior APP, instruction information can serve to indicate that the newly-increased index is accumulative type index, tool
Body, instruction information can be specifically as follows character string, such as indicate that newly-increased index is accumulative type index with 1, and 2, which indicate newly-increased, refers to
It is designated as non-accumulative type index, such as flow type index.
Specifically, in a specific embodiment of the present invention, These parameters newly-added information can be in some processing business and updates industry
After content of being engaged in, and when the corresponding transaction data of the business has variation, user inputs according to the more new content of transaction data, with
Avoid omit achievement data, it is ensured that subsequent indicator-specific statistics data it is comprehensive.
Step 12, with the presence or absence of original system corresponding with the title of newly-increased index in the index classification table that judgement constructs in advance
Count index.
Wherein, index classification table record has a plurality of primary statistics index, and primary statistics index includes index name and refers to
Entitling claims corresponding index classification title and various dimensions description information.Therefore, according to the name query index classification of newly-increased index
Table just can determine that in index classification table with the presence or absence of primary statistics index corresponding with the title of newly-increased index.
Specifically, in a specific embodiment of the present invention, above-mentioned various dimensions description information includes: the corresponding finger of index name
Mark code, index interpretation, index generating mode, index classification mark, index mark and index unit.Guideline code is for characterizing
The field of index name, and the field and achievement data warehouse table (have recorded user journal data, the i.e. behavior of user in the table
Record, such as access, the transaction history data of certain service line) field association, convenient for subsequent according to achievement data warehouse table
Interior data obtain indicator-specific statistics data;Index interpretation is used to indicate the targeted scope of statistics of primary statistics index;Quota student
It is used to indicate whether primary statistics index is accumulative type index at mode, is specifically as follows character string, such as indicate original system with 1
Counting index is accumulative type index, and 2 indicate that primary statistics index is non-accumulative type index, such as flow type index;Index classification title
For index classification belonging to primary statistics index;Index classification is identified as the character string for characteristic index specific name;Index
It is identified as the character string for characteristic index title;Index unit is the statistical unit of primary statistics index.
Step 13, when primary statistics index corresponding with the title of newly-increased index being not present in index classification table, according to
The title of newly-increased index, determining and newly-increased index the name-matches from multiple index classification titles that index classification table records
Target indicator specific name.
Step 14, according to the description information of target indicator specific name, the title of newly-increased index and newly-increased index, referring to
Target indicator is added in mark classification chart.
Wherein, in a specific embodiment of the present invention, when there is no corresponding with the title of newly-increased index in index classification table
Primary statistics index when, when to avoid subsequent each indicator-specific statistics data in index classification table, omit achievement data
Partial data in warehouse table, it is ensured that subsequent indicator-specific statistics data it is comprehensive, need to add in index classification table corresponding
Target indicator.
And in a specific embodiment of the present invention, after having executed above-mentioned steps 14, the above method further includes walking as follows
It is rapid: structured query language (SQL, Structured Query Language) sentence for inquiring target indicator is generated, with
Convenient for the subsequent query target indicator.
Wherein, in a specific embodiment of the present invention, according to the title for increasing index newly in above-mentioned steps 13, from index classification
In multiple index classification titles of table record the step of the determining target indicator specific name with the name-matches of newly-increased index
Specific implementation includes the following steps: each index classification title of the title for calculating newly-increased index and index classification table record
Semantic similarity, and the corresponding index classification name of maximum value in calculated multiple semantic similarities is referred to as target and is referred to
Mark specific name.Wherein, at present there are many kinds of the modes of computing semantic similarity, any one of them is selected to calculate, and
This does not repeat the calculating of semantic similarity excessively.
Specifically, in a specific embodiment of the present invention, above-mentioned target indicator specific name is multiple in index classification chart
The highest index classification title of title similarity of index classification title and newly-increased index, so that target indicator to be attributed to suitably
In class.Such as the entitled development expenses of newly-increased index, target indicator specific name can be popularization.
Wherein, in a specific embodiment of the present invention, above-mentioned various dimensions description information includes: the corresponding index of index name
Code, index interpretation, index generating mode, index classification mark, index mark and index unit;Target indicator includes that target refers to
Mark specific name, the title of newly-increased index, the corresponding guideline code of title of newly-increased index, index interpretation, index generating mode,
Index classification mark, index mark and index unit.It should be noted that the target indicator guideline code that is included, index are released
Justice, index generating mode, index classification mark, index identify and the various dimensions of the meaning and primary statistics index of index unit are retouched
The guideline code in information, index interpretation, index generating mode, index classification mark, index mark and index unit is stated to correspond to
Identical, only these words in target indicator are both for target indicator.
Correspondingly, in a specific embodiment of the present invention, as shown in Fig. 2, the specific implementation of above-mentioned steps 14 includes
Following steps:
Step 21, according to the title of newly-increased index, the corresponding guideline code of title of newly-increased index is obtained.
Wherein, in a specific embodiment of the present invention, the specific implementation of above-mentioned steps 21 are as follows: by the name of newly-increased index
Title is translated as English name, and according to English name, obtains the corresponding guideline code of title of newly-increased index.
Specifically, in a specific embodiment of the present invention, English name can be referred to as by the abbreviation of English name or directly
It is convenient for subsequent according to index for the corresponding guideline code of title for increasing index newly with being associated with the field of achievement data warehouse table
Data in data warehouse table obtain indicator-specific statistics data.For example, the entitled development expenses of newly-increased index, guideline code can be
spread_money;The entitled newly-increased clue number of newly-increased index, guideline code can be new_clue_num.
Step 22, according to the description information of newly-increased index, the corresponding index interpretation of title, the quota student of newly-increased index are obtained
At mode and index unit.
Specifically, in a specific embodiment of the present invention, as shown in figure 3, the specific implementation of above-mentioned steps 22 includes
Following steps:
Step 2201, the description information of newly-increased index is parsed, obtains the corresponding index list of title of newly-increased index
Position is used to indicate the statistical information of the targeted scope of statistics of newly-increased index and is used to indicate whether newly-increased index is accumulative type
The instruction information of index.
Step 2202, using statistical information as the corresponding index interpretation of title of newly-increased index.
Step 2203, information will be indicated as the corresponding index generating mode of title of newly-increased index.
Step 23, according to target indicator specific name, the title for obtaining newly-increased index corresponds to index classification mark and index
Mark.
Wherein, in a specific embodiment of the present invention, the specific implementation of above-mentioned steps 23 includes the following steps: first
The corresponding target indicator classification of target indicator specific name is determined from a plurality of primary statistics index that index classification table records
Mark, and index classification mark is corresponded to using target indicator class indication as the title of newly-increased index;Then according to target indicator
Class indication and preset index identify configuration rule, configure corresponding index mark to increase the title of index newly.Wherein, above-mentioned
Index identifies configuration rule can be with are as follows: first place correspond to index classification mark for the title of newly-increased index, and latter three are target indicator
Serial number.Such as the entitled dress of newly-increased index looks forward to income, target indicator specific name is general-circumstances, target indicator specific name
Corresponding target indicator class indication is 1, and the corresponding index mark of title for increasing index newly can be 1001.
Step 24, corresponding by the title of the newly-increased index of addition in index classification table and the title of newly-increased index
Target indicator specific name, guideline code, index interpretation, index generating mode, index classification mark, index mark and index list
Position, adds target indicator in index classification table.
To be carried out in an example of the invention to index classification table convenient for the understanding to above-mentioned newly-increased INDEX MANAGEMENT method
It illustrates.Specifically, the index classification table before assuming addition target indicator is as shown in figure 4, index name includes that dress enterprise receives
Enter, new visitor's number, development expenses, dress enterprise takes in the corresponding entitled general-circumstances of index classification, and dress enterprise takes in corresponding guideline code and is
Plat_inc, dress are looked forward to taking in corresponding index interpretation being in statistics predetermined period, and dress looks forward to platform to decoration company's fee charged
Total, it is 2 that dress enterprise, which takes in corresponding index generating mode, and dress enterprise takes in corresponding index classification and is identified as 1, and dress enterprise income corresponds to
Index be identified as 1001, it is ten thousand yuan that dress enterprise, which takes in corresponding index unit,.New visitor's number and the corresponding index classification of development expenses
Title and various dimensions description information are as shown in figure 4, herein without excessively repeating.In addition, if the entitled initiation of newly-increased index
Clue number increases index classification table after target indicator using above-mentioned newly-increased INDEX MANAGEMENT method such as in index classification table
Shown in Fig. 5.By Fig. 4 and Fig. 5 it is found that index is managed and is increased newly using above-mentioned newly-increased INDEX MANAGEMENT method, it is avoided that
When the subsequent each indicator-specific statistics data being directed in index classification table, the data in achievement data warehouse table are omitted, it is ensured that subsequent
Indicator-specific statistics data it is comprehensive, can satisfy business demand.
It can be seen that in a specific embodiment of the present invention, receiving the Name and Description information including increasing index newly
Index newly-added information when, by judging in the index classification table that constructs in advance with the presence or absence of corresponding with the title of newly-increased index
Primary statistics index, and in index classification table be not present primary statistics index corresponding with the title of newly-increased index when, according to
The title of newly-increased index, determining and newly-increased index the name-matches from multiple index classification titles that index classification table records
Target indicator specific name is finally believed according to the description of target indicator specific name, the title and newly-increased index of newly-increased index
Breath, can precisely, rapidly record have primary statistics index index classification table in increase newly target indicator, avoided to reach
Achievement data is omitted, the comprehensive of subsequent indicator-specific statistics data is promoted, meets the effect of business demand.
Second embodiment
As shown in fig. 6, specific embodiments of the present invention provide a kind of newly-increased INDEX MANAGEMENT equipment, the newly-increased INDEX MANAGEMENT
Equipment 6 is including memory 61, processor 62 and is stored in the computer journey that can be run in memory 61 and on the processor 62
The step of sequence 63, which realizes above-mentioned newly-increased INDEX MANAGEMENT method when executing computer program 63.
Specifically, processor 62 realizes following steps when executing computer program 63: receiving index newly-added information;Judgement is pre-
It whether there is primary statistics index corresponding with the title of newly-increased index in the index classification table first constructed;In index classification table
There is no when primary statistics index corresponding with the title of newly-increased index, according to the title of newly-increased index, remember from index classification table
The determining target indicator specific name with the name-matches of newly-increased index in multiple index classification titles of record;According to target indicator
The description information of specific name, the title of newly-increased index and newly-increased index, adds target indicator in index classification table.Its
In, index newly-added information includes the Name and Description information of newly-increased index;Index classification table record has a plurality of primary statistics index,
Primary statistics index includes index name and the corresponding index classification title of index name and various dimensions description information.
Optionally, following steps are also realized when processor 62 executes computer program 63: calculate the title of newly-increased index with
The semantic similarity of each index classification title of index classification table record;By the maximum in calculated multiple semantic similarities
It is worth corresponding index classification name and is referred to as target indicator specific name.
Optionally, following steps are also realized when processor 62 executes computer program 63: according to the title of newly-increased index, being obtained
Take the corresponding guideline code of the title of newly-increased index;According to the description information of newly-increased index, the title for obtaining newly-increased index is corresponding
Index interpretation, index generating mode and index unit;According to target indicator specific name, the title for obtaining newly-increased index is corresponding
Index classification mark and index mark;By adding the title of newly-increased index and the name of newly-increased index in index classification table
Claim corresponding target indicator specific name, guideline code, index interpretation, index generating mode, index classification mark, index mark
And index unit, target indicator is added in index classification table.
Optionally, following steps are also realized when processor 62 executes computer program 63: by the Title Translation of newly-increased index
For English name;According to English name, the corresponding guideline code of title of newly-increased index is obtained.
Optionally, following steps are also realized when processor 62 executes computer program 63: to the description information of newly-increased index
It is parsed, obtains the corresponding index unit of title of newly-increased index, is used to indicate the targeted scope of statistics of newly-increased index
Statistical information and be used to indicate newly-increased index whether be accumulative type index instruction information;Using statistical information as newly-increased index
The corresponding index interpretation of title;Information will be indicated as the corresponding index generating mode of title of newly-increased index.
Optionally, following steps are also realized when processor 62 executes computer program 63: being recorded from index classification table more
The corresponding target indicator class indication of target indicator specific name is determined in primary statistics index, and target indicator is classified
It identifies and corresponds to index classification mark as the title of newly-increased index;Matched according to target indicator class indication and preset index mark
Rule is set, configures corresponding index mark to increase the title of index newly.
Optionally, following steps are also realized when processor 62 executes computer program 63: being generated for inquiring target indicator
Structured query language sentence.
That is, the step of realizing above-mentioned newly-increased INDEX MANAGEMENT method when processor 62 executes computer program 63, can precisely,
It rapidly increases target indicator newly in the index classification table that record has primary statistics index, reaches and avoid omitting achievement data, mention
The comprehensive of subsequent indicator-specific statistics data is risen, the effect of business demand is met.
Illustratively, above-mentioned newly-increased INDEX MANAGEMENT equipment 6 can be desktop PC, notebook, palm PC and cloud
Server etc. is held to calculate equipment.The newly-increased INDEX MANAGEMENT equipment 6 may include, but be not limited only to processor 62, memory 61.Ability
Field technique personnel are appreciated that the schematic diagram is only the example of newly-increased INDEX MANAGEMENT equipment 6, do not constitute to newly-increased index
The restriction of management equipment 6 may include perhaps combining certain components or different portions than illustrating more or fewer components
Part, such as newly-increased INDEX MANAGEMENT equipment 6 can also include input-output equipment, network access equipment, bus etc..
It should be noted that due to being realized when the processor 62 for increasing INDEX MANAGEMENT equipment 6 newly executes computer program 63
The step of newly-increased INDEX MANAGEMENT method stated, therefore all embodiments of above-mentioned newly-increased INDEX MANAGEMENT method are newly-increased suitable for this
INDEX MANAGEMENT equipment 6, and can reach the same or similar beneficial effect.
3rd embodiment
Specific embodiments of the present invention provide a kind of computer readable storage medium, computer-readable recording medium storage
There is computer program, which realizes above-mentioned newly-increased INDEX MANAGEMENT method when being executed by processor the step of.
Specifically, realizing following steps when computer program is executed by processor: receiving index newly-added information;Judgement is preparatory
It whether there is primary statistics index corresponding with the title of newly-increased index in the index classification table of building;In index classification table not
When in the presence of primary statistics index corresponding with the title of newly-increased index, according to the title of newly-increased index, recorded from index classification table
Multiple index classification titles in the determining target indicator specific name with the name-matches of newly-increased index;According to target indicator point
The description information of class name, the title of newly-increased index and newly-increased index, adds target indicator in index classification table.Wherein,
Index newly-added information includes the Name and Description information of newly-increased index;Index classification table record has a plurality of primary statistics index, former
Beginning statistical indicator includes index name and the corresponding index classification title of index name and various dimensions description information.
Optionally, following steps are also realized when computer program is executed by processor: calculating the title and finger of newly-increased index
Mark the semantic similarity of each index classification title of classification chart record;By the maximum value in calculated multiple semantic similarities
Corresponding index classification name is referred to as target indicator specific name.
Optionally, following steps are also realized when computer program is executed by processor: according to the title of newly-increased index, being obtained
The corresponding guideline code of title of newly-increased index;According to the description information of newly-increased index, the title for obtaining newly-increased index is corresponding
Index interpretation, index generating mode and index unit;According to target indicator specific name, the title correspondence for obtaining newly-increased index refers to
Mark class indication and index mark;By adding the title of newly-increased index and the title of newly-increased index in index classification table
Corresponding target indicator specific name, guideline code, index interpretation, index generating mode, index classification mark, index mark and
Index unit adds target indicator in index classification table.
Optionally, following steps are also realized when computer program is executed by processor: the Title Translation by newly-increased index is
English name;According to English name, the corresponding guideline code of title of newly-increased index is obtained.
Optionally, following steps are also realized when computer program is executed by processor: to the description information of newly-increased index into
Row parsing obtains the corresponding index unit of title of newly-increased index, is used to indicate the system of the targeted scope of statistics of newly-increased index
It counts information and is used to indicate whether newly-increased index is the instruction information for adding up type index;Using statistical information as newly-increased index
The corresponding index interpretation of title;Information will be indicated as the corresponding index generating mode of title of newly-increased index.
Optionally, following steps are also realized when computer program is executed by processor: being recorded from index classification table a plurality of
Determine the corresponding target indicator class indication of target indicator specific name in primary statistics index, and by target indicator contingency table
Know and corresponds to index classification mark as the title of newly-increased index;According to target indicator class indication and the mark configuration of preset index
Rule configures corresponding index mark to increase the title of index newly.
Optionally, following steps are also realized when computer program is executed by processor: being generated for inquiring target indicator
Structured query language sentence.
That is, realizing above-mentioned newly-increased INDEX MANAGEMENT when the computer program of computer readable storage medium is executed by processor
The step of method, energy is accurate, rapidly increases target indicator newly in the index classification table that record has primary statistics index, reaches and keeps away
Exempt to omit achievement data, promotes the comprehensive of subsequent indicator-specific statistics data, meet the effect of business demand.
Illustratively, the computer program of computer readable storage medium includes computer program code, the computer
Program code can be source code form, object identification code form, executable file or certain intermediate forms etc..The computer can
Reading medium may include: any entity or device, recording medium, USB flash disk, mobile hard that can carry the computer program code
Disk, magnetic disk, CD, computer storage, read-only memory (ROM, Read-Only Memory), random access memory
(RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..
It should be noted that the computer program due to computer readable storage medium realized when being executed by processor it is above-mentioned
Newly-increased INDEX MANAGEMENT method the step of, therefore all embodiments of above-mentioned newly-increased INDEX MANAGEMENT method are suitable for the computer
Readable storage medium storing program for executing, and can reach the same or similar beneficial effect.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of newly-increased INDEX MANAGEMENT method characterized by comprising
Receive index newly-added information;Wherein, the index newly-added information includes the Name and Description information of newly-increased index;
Judge in the index classification table constructed in advance with the presence or absence of primary statistics index corresponding with the title of the newly-increased index;
Wherein, the index classification table record has a plurality of primary statistics index, and the primary statistics index includes index name and institute
State the corresponding index classification title of index name and various dimensions description information;
When primary statistics index corresponding with the title of the newly-increased index being not present in the index classification table, according to described
The title of newly-increased index, the determining name with the newly-increased index from multiple index classification titles that the index classification table records
Claim matched target indicator specific name;
According to the description information of the target indicator specific name, the title of the newly-increased index and the newly-increased index,
Target indicator is added in the index classification table.
2. the method according to claim 1, wherein the title according to the newly-increased index, from the finger
Mark the determining target indicator systematic name with the name-matches of the newly-increased index in multiple index classification titles of classification chart record
The step of title, comprising:
Calculate the semantic similarity of the title of the newly-increased index and each index classification title of index classification table record;
The corresponding index classification name of maximum value in calculated multiple semantic similarities is referred to as the target indicator classification
Title.
3. the method according to claim 1, wherein the various dimensions description information includes: that index name is corresponding
Guideline code, index interpretation, index generating mode, index classification mark, index mark and index unit;
The target indicator includes the target indicator specific name, the title of the newly-increased index, the name of the newly-increased index
Claim corresponding guideline code, index interpretation, index generating mode, index classification mark, index mark and index unit.
4. according to the method described in claim 3, it is characterized in that, it is described according to the target indicator specific name, it is described new
The step of increasing the title of index and the description information of the newly-increased index, target indicator added in the index classification table,
Include:
According to the title of the newly-increased index, the corresponding guideline code of title of the newly-increased index is obtained;
According to the description information of the newly-increased index, the corresponding index interpretation of title of the newly-increased index is obtained, index generates
Mode and index unit;
According to the target indicator specific name, the title for obtaining the newly-increased index corresponds to index classification mark and index mark
Know;
By added in the index classification table the newly-increased index title and the newly-increased index title it is corresponding
Target indicator specific name, guideline code, index interpretation, index generating mode, index classification mark, index mark and index list
Position, adds target indicator in the index classification table.
5. according to the method described in claim 4, it is characterized in that, the title according to the newly-increased index, described in acquisition
The step of title of newly-increased index corresponding guideline code, comprising:
It is English name by the Title Translation of the newly-increased index;
According to the English name, the corresponding guideline code of title of the newly-increased index is obtained.
6. according to the method described in claim 4, it is characterized in that, the description information according to the newly-increased index, obtains
The step of corresponding index interpretation of title of the newly-increased index, index generating mode and index unit, comprising:
The description information of the newly-increased index is parsed, the corresponding index unit of title, the use of the newly-increased index are obtained
In the statistical information for indicating the targeted scope of statistics of newly-increased index and it is used to indicate whether newly-increased index is accumulative type index
Instruction information;
Using the statistical information as the corresponding index interpretation of title of the newly-increased index;
Using the instruction information as the corresponding index generating mode of the title of the newly-increased index.
7. according to the method described in claim 4, it is characterized in that, described according to the target indicator specific name, acquisition institute
The title for stating newly-increased index corresponds to the step of index classification mark is identified with index, comprising:
Determine that the target indicator specific name is corresponding from a plurality of primary statistics index that the index classification table records
Target indicator class indication, and index classification mark is corresponded to using the target indicator class indication as the title of the newly-increased index
Know;
Configuration rule is identified according to the target indicator class indication and preset index, is that the title of the newly-increased index configures
Corresponding index mark.
8. the method according to claim 1, wherein it is described according to the target indicator specific name, it is described
The title of newly-increased index and the description information of the newly-increased index, in the index classification table the step of addition target indicator
Later, the method also includes:
Generate the structured query language SQL statement for inquiring the target indicator.
9. a kind of newly-increased INDEX MANAGEMENT equipment, including memory, processor and storage are in the memory and can be described
The computer program run on processor, which is characterized in that the processor realizes such as right when executing the computer program
It is required that the step of 1 to 8 described in any item newly-increased INDEX MANAGEMENT methods.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists
In the computer program realizes newly-increased INDEX MANAGEMENT method as claimed in any one of claims 1 to 8 when being executed by processor
The step of.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810709881.2A CN109101541B (en) | 2018-07-02 | 2018-07-02 | Newly added index management method, device and computer readable storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810709881.2A CN109101541B (en) | 2018-07-02 | 2018-07-02 | Newly added index management method, device and computer readable storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109101541A true CN109101541A (en) | 2018-12-28 |
CN109101541B CN109101541B (en) | 2022-10-04 |
Family
ID=64845379
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810709881.2A Active CN109101541B (en) | 2018-07-02 | 2018-07-02 | Newly added index management method, device and computer readable storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109101541B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110704405A (en) * | 2019-08-29 | 2020-01-17 | 南京医渡云医学技术有限公司 | Data fusion method and device based on disease indexes |
CN112037070A (en) * | 2020-09-01 | 2020-12-04 | 中国银行股份有限公司 | Flexible index configuration method and device |
CN112364134A (en) * | 2020-11-23 | 2021-02-12 | 医渡云(北京)技术有限公司 | Service index recommendation method, device, medium and electronic equipment |
Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2003108781A (en) * | 2001-09-27 | 2003-04-11 | Nec Corp | System, method and program for creating migration record |
US20080127022A1 (en) * | 2006-11-03 | 2008-05-29 | Yu-Chuan Chang | Method for managing net data of a layout |
US20120158772A1 (en) * | 2010-12-20 | 2012-06-21 | Sap Ag | Automated generation of structured service descriptions from semi-structured enterprise service repositories |
US20130031325A1 (en) * | 2011-07-29 | 2013-01-31 | The Boeing Company | System for Updating an Associative Memory |
CN104133868A (en) * | 2014-07-21 | 2014-11-05 | 厦门大学 | Strategy used for vertical crawler data classification and integration |
CN104504146A (en) * | 2015-01-05 | 2015-04-08 | 浪潮(北京)电子信息产业有限公司 | Classified management method and system for data |
CN107291745A (en) * | 2016-03-31 | 2017-10-24 | 阿里巴巴集团控股有限公司 | The management method and device of a kind of data target |
CN107302617A (en) * | 2017-05-17 | 2017-10-27 | 深圳市金立通信设备有限公司 | A kind of data managing method and terminal |
CN108074033A (en) * | 2017-10-30 | 2018-05-25 | 链家网(北京)科技有限公司 | Processing method, system, electronic equipment and the storage medium of achievement data |
CN108073720A (en) * | 2017-12-30 | 2018-05-25 | 广州明动软件股份有限公司 | Data quality management system and method applied to big data system |
-
2018
- 2018-07-02 CN CN201810709881.2A patent/CN109101541B/en active Active
Patent Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2003108781A (en) * | 2001-09-27 | 2003-04-11 | Nec Corp | System, method and program for creating migration record |
US20080127022A1 (en) * | 2006-11-03 | 2008-05-29 | Yu-Chuan Chang | Method for managing net data of a layout |
US20120158772A1 (en) * | 2010-12-20 | 2012-06-21 | Sap Ag | Automated generation of structured service descriptions from semi-structured enterprise service repositories |
US20130031325A1 (en) * | 2011-07-29 | 2013-01-31 | The Boeing Company | System for Updating an Associative Memory |
CN104133868A (en) * | 2014-07-21 | 2014-11-05 | 厦门大学 | Strategy used for vertical crawler data classification and integration |
CN104504146A (en) * | 2015-01-05 | 2015-04-08 | 浪潮(北京)电子信息产业有限公司 | Classified management method and system for data |
CN107291745A (en) * | 2016-03-31 | 2017-10-24 | 阿里巴巴集团控股有限公司 | The management method and device of a kind of data target |
CN107302617A (en) * | 2017-05-17 | 2017-10-27 | 深圳市金立通信设备有限公司 | A kind of data managing method and terminal |
CN108074033A (en) * | 2017-10-30 | 2018-05-25 | 链家网(北京)科技有限公司 | Processing method, system, electronic equipment and the storage medium of achievement data |
CN108073720A (en) * | 2017-12-30 | 2018-05-25 | 广州明动软件股份有限公司 | Data quality management system and method applied to big data system |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110704405A (en) * | 2019-08-29 | 2020-01-17 | 南京医渡云医学技术有限公司 | Data fusion method and device based on disease indexes |
CN110704405B (en) * | 2019-08-29 | 2020-11-10 | 南京医渡云医学技术有限公司 | Data fusion method and device based on disease indexes |
CN112037070A (en) * | 2020-09-01 | 2020-12-04 | 中国银行股份有限公司 | Flexible index configuration method and device |
CN112037070B (en) * | 2020-09-01 | 2023-09-19 | 中国银行股份有限公司 | Flexible index configuration method and device |
CN112364134A (en) * | 2020-11-23 | 2021-02-12 | 医渡云(北京)技术有限公司 | Service index recommendation method, device, medium and electronic equipment |
CN112364134B (en) * | 2020-11-23 | 2024-05-31 | 医渡云(北京)技术有限公司 | Service index recommendation method, device, medium and electronic equipment |
Also Published As
Publication number | Publication date |
---|---|
CN109101541B (en) | 2022-10-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107247707B (en) | Enterprise association relation information extraction method and device based on completion strategy | |
CN109359277B (en) | Data monitoring method, device and computer storage medium | |
US10664481B2 (en) | Computer system programmed to identify common subsequences in logs | |
CN109241075B (en) | Index basic data processing method and equipment and computer readable storage medium | |
CN109101541A (en) | Newly-increased INDEX MANAGEMENT method, equipment and computer readable storage medium | |
US20220052976A1 (en) | Answer text processing methods and apparatuses, and key text determination methods | |
CN109214640B (en) | Method and device for determining index result and computer readable storage medium | |
US11429652B2 (en) | Chat management to address queries | |
CN112184138A (en) | RPA and AI combined power grid work order processing method and device and electronic equipment | |
CN111125332B (en) | Method, device, equipment and storage medium for calculating TF-IDF value of word | |
CN109242690A (en) | Finance product recommended method, device, computer equipment and readable storage medium storing program for executing | |
CN109582863B (en) | Recommendation method and server | |
CN114064606A (en) | Database migration method, device, equipment, storage medium and system | |
CN113064982A (en) | Question-answer library generation method and related equipment | |
CN108711073B (en) | User analysis method, device and terminal | |
CN115344774A (en) | User account screening method and device and server | |
US9348902B2 (en) | Automated attribute disambiguation with human input | |
CN109299349B (en) | Application recommendation method and device, equipment and computer-readable storage medium | |
CN112015888B (en) | Abstract information extraction method and abstract information extraction system | |
CN111832280B (en) | Scenario information processing method and device, electronic equipment and storage medium | |
CN117874211B (en) | Intelligent question-answering method, system, medium and electronic equipment based on SAAS software | |
CN115659182B (en) | Model updating method, device and equipment | |
CN113297848B (en) | Information processing method, apparatus, device and storage medium | |
US10728118B2 (en) | Service tickets early warning system | |
CN112417124A (en) | Community question-answer processing method, device and medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB02 | Change of applicant information |
Address after: 518000 R & D building 3501, block a, building 7, Vanke Cloud City Phase I, Xingke 1st Street, Xili community, Xili street, Nanshan, Shenzhen, Guangdong Applicant after: Tubatu Group Co.,Ltd. Address before: 1001-a, 10th floor, bike technology building, No.9, Keke Road, high tech Zone, Nanshan District, Shenzhen, Guangdong 518000 Applicant before: SHENZHEN BINCENT TECHNOLOGY Co.,Ltd. |
|
CB02 | Change of applicant information | ||
GR01 | Patent grant | ||
GR01 | Patent grant |