Summary of the invention
In view of this, the present invention provides a kind of collection method of statistical information and device, realize statistical information i.e.When collect, and then improve the execution efficiency of SQL.
To achieve the above object, the present invention provides the following technical solutions：
A kind of collection method of statistical information, including：
When receiving data mart modeling completion instruction, the table of statistical information to be collected is obtained；
Judge whether the table of the statistical information to be collected meets default collection condition, the default collection condition is describedThe table of statistical information to be collected is not interim table, and the statistical information of the table of the statistical information to be collected is not locked out；
If the table of the statistical information to be collected meets the default collection condition, according to default collection strategy, institute is collectedState the current statistic information of the table of statistical information to be collected.
Preferably, the default collection strategy includes：
The table of the statistical information to be collected is empty table, and collecting zone is child partition；
The table of the statistical information to be collected is empty table, and collecting zone is subregion；
The table of the statistical information to be collected is empty table, and collecting zone is whole table；
The table of the statistical information to be collected is nonempty list, and collecting zone is child partition；
The table of the statistical information to be collected is nonempty list, and collecting zone is subregion；
Wherein, the child partition belongs to the subregion, and the subregion belongs to the whole table.
Preferably, when the table that the default collection strategy is the statistical information to be collected is sky table, and collecting zone isIt is described to collect the current statistic information of the table of the statistical information to be collected according to default collection strategy when child partition, including：
Obtain the allocation list of oracle database；
Judge whether the number of processes of the table of the statistical information to be collected reaches the maximum number of processes of the allocation list；
If the number of processes of the table of the statistical information to be collected reaches the maximum number of processes of the allocation list, institute is collectedState the child partition of the table of statistical information to be collected statistical information and the child partition belonging to subregion statistical information, andUsing the statistical information of subregion belonging to the statistical information of the child partition and the child partition as the current statistic information；
If the number of processes of the table of the statistical information to be collected is not up to the maximum number of processes of the allocation list, collectThe statistical information of the child partition of the table of the statistical information to be collected, and using the statistical information of the child partition as described currentStatistical information.
Preferably, when the table that the default collection strategy is the statistical information to be collected is sky table, and collecting zone isIt is described to collect the current statistic information of the table of the statistical information to be collected according to default collection strategy when subregion, including：
Obtain the allocation list of oracle database；
Judge whether the number of processes of the table of the statistical information to be collected reaches the maximum number of processes of the allocation list；
If the number of processes of the table of the statistical information to be collected reaches the maximum number of processes of the allocation list, institute is collectedState the subregion of the table of statistical information to be collected statistical information and the subregion belonging to whole table statistical information, and by instituteState subregion statistical information and the subregion belonging to whole table statistical information as the current statistic information；
If the number of processes of the table of the statistical information to be collected is not up to the maximum number of processes of the allocation list, collectThe statistical information of the subregion of the table of the statistical information to be collected, and using the statistical information of the subregion as the current statisticInformation.
Preferably, when the table that the default collection strategy is the statistical information to be collected is sky table, and collecting zone isIt is described to collect the current statistic information of the table of the statistical information to be collected according to default collection strategy when whole table, including：
Obtain the allocation list of oracle database；
Judge whether the number of processes of the table of the statistical information to be collected reaches the maximum number of processes of the allocation list；
If the number of processes of the table of the statistical information to be collected reaches the maximum number of processes of the allocation list, institute is collectedThe statistical information of the whole table of the table of statistical information to be collected is stated, and the statistical information of the whole table is believed as the current statisticBreath.
Preferably, when the table that the default collection strategy is the statistical information to be collected is nonempty list, and collecting zoneIt is described according to default collection strategy when for child partition, collect the current statistic information of the table of the statistical information to be collected, packetIt includes：
Obtain the allocation list of oracle database；
Judge whether identify comprising forced collection in the allocation list；
If identifying in the allocation list comprising the forced collection, the child partition of the table of the statistical information to be collected is collectedStatistical information, and using the statistical information of the child partition as the current statistic information；
If not including the forced collection in the allocation list to identify, judge whether the number of the child partition is equal to 1；
If the number of the child partition is equal to 1, according to the identification information of the allocation list, judgement is described wait collect statistics letterWhether the initial statistical information of the table of breath fails；
If the initial statistical information of the table of the statistical information to be collected fails, the table of the statistical information to be collected is collectedChild partition statistical information, and using the statistical information of the child partition as the current statistic information.
Preferably, when the table that the default collection strategy is the statistical information to be collected is nonempty list, and collecting zoneIt is described to collect the current statistic information of the table of the statistical information to be collected according to default collection strategy when for subregion, including：
Obtain the allocation list of oracle database；
Judge whether identify comprising forced collection in the allocation list；
If identifying in the allocation list comprising the forced collection, the subregion of the table of the statistical information to be collected is collectedStatistical information, and using the statistical information of the subregion as the current statistic information；
If not including the forced collection in the allocation list to identify, judge whether the number of the subregion is equal to 1；
If the number of the subregion is equal to 1, according to the identification information of the allocation list, the statistical information to be collected is judgedThe initial statistical information of table whether fail；
If the initial statistical information of the table of the statistical information to be collected fails, the table of the statistical information to be collected is collectedSubregion statistical information, and using the statistical information of the subregion as the current statistic information.
A kind of collection device of statistical information, including：
Module is obtained, for obtaining the table of statistical information to be collected when receiving data mart modeling completion instruction；
Judgment module, it is described default for judging whether the table of the statistical information to be collected meets default collection conditionCollection condition is that the table of the statistical information to be collected is not interim table, and the statistical information of the table of the statistical information to be collectedIt is not locked out；
Collection module, if the table for the statistical information to be collected meets the default collection condition, according to default receiptsCollection strategy collects the current statistic information of the table of the statistical information to be collected.
Preferably, the default collection strategy includes：
The table of the statistical information to be collected is empty table, and collecting zone is child partition；
The table of the statistical information to be collected is empty table, and collecting zone is subregion；
The table of the statistical information to be collected is empty table, and collecting zone is whole table；
The table of the statistical information to be collected is nonempty list, and collecting zone is child partition；
The table of the statistical information to be collected is nonempty list, and collecting zone is subregion；
Wherein, the child partition belongs to the subregion, and the subregion belongs to the whole table.
Preferably, the collection module includes：
First acquisition unit, for being sky table when the table that the default collection strategy is the statistical information to be collected, andWhen collecting zone is child partition, the allocation list of oracle database is obtained；
First judging unit, for judging whether the number of processes of table of the statistical information to be collected reaches the configurationThe maximum number of processes of table；
First collector unit, if the number of processes of the table for the statistical information to be collected reaches the allocation list mostBig number of processes is collected belonging to statistical information and the child partition of the child partition of the table of the statistical information to be collectedThe statistical information of subregion, and using the statistical information of subregion belonging to the statistical information of the child partition and the child partition as instituteState current statistic information；
Second collector unit, if the number of processes of the table for the statistical information to be collected is not up to the allocation listMaximum number of processes, collects the statistical information of the child partition of the table of the statistical information to be collected, and by the system of the child partitionInformation is counted as the current statistic information.
Preferably, the collection module includes：
Second acquisition unit, for being sky table when the table that the default collection strategy is the statistical information to be collected, andWhen collecting zone is subregion, the allocation list of oracle database is obtained；
Second judgment unit, for judging whether the number of processes of table of the statistical information to be collected reaches the configurationThe maximum number of processes of table；
Third collector unit, if the number of processes of the table for the statistical information to be collected reaches the allocation list mostBig number of processes, collect the subregion of the table of the statistical information to be collected statistical information and the subregion belonging to whole tableStatistical information, and using the statistical information of whole table belonging to the statistical information of the subregion and the subregion as the current systemCount information；
4th collector unit, if the number of processes of the table for the statistical information to be collected is not up to the allocation listMaximum number of processes collects the statistical information of the subregion of the table of the statistical information to be collected, and the statistics of the subregion is believedBreath is used as the current statistic information.
Preferably, the collection module includes：
Third acquiring unit, for being sky table when the table that the default collection strategy is the statistical information to be collected, andWhen collecting zone is whole table, the allocation list of oracle database is obtained；
Third judging unit, for judging whether the number of processes of table of the statistical information to be collected reaches the configurationThe maximum number of processes of table；
5th collector unit, if the number of processes of the table for the statistical information to be collected reaches the allocation list mostBig number of processes, collects the statistical information of the whole table of the table of the statistical information to be collected, and by the statistical information of the whole tableAs the current statistic information.
Preferably, the collection module includes：
4th acquiring unit, for being nonempty list when the table that the default collection strategy is the statistical information to be collected,And collecting zone be child partition when, obtain the allocation list of oracle database；
4th judging unit, for whether judging in the allocation list comprising forced collection mark；
6th collector unit, if being collected described wait collect system for being identified in the allocation list comprising the forced collectionThe statistical information of the child partition of the table of information is counted, and using the statistical information of the child partition as the current statistic information；
5th judging unit judges the child partition if identifying for not including the forced collection in the allocation listNumber whether be equal to 1；
6th judging unit, according to the identification information of the allocation list, is sentenced if the number for the child partition is equal to 1Whether the initial statistical information of the table of the disconnected statistical information to be collected fails；
7th collector unit, if the initial statistical information failure of the table for the statistical information to be collected, described in collectionThe statistical information of the child partition of the table of statistical information to be collected, and using the statistical information of the child partition as the current statisticInformation.
Preferably, the collection module includes：
5th acquiring unit, for being nonempty list when the table that the default collection strategy is the statistical information to be collected,And collecting zone be subregion when, obtain the allocation list of oracle database；
7th judging unit, for whether judging in the allocation list comprising forced collection mark；
8th collector unit, if being collected described wait collect system for being identified in the allocation list comprising the forced collectionThe statistical information of the subregion of the table of information is counted, and using the statistical information of the subregion as the current statistic information；
8th judging unit judges the subregion if identifying for not including the forced collection in the allocation listWhether number is equal to 1；
9th judging unit, if the number for the subregion is equal to 1, according to the identification information of the allocation list, judgementWhether the initial statistical information of the table of the statistical information to be collected fails；
9th collector unit, if the initial statistical information failure of the table for the statistical information to be collected, described in collectionThe statistical information of the subregion of the table of statistical information to be collected, and believe the statistical information of the subregion as the current statisticBreath.
It can be seen via above technical scheme that compared with prior art, the present invention provides a kind of collections of statistical informationMethod and device, by obtaining the table of statistical information to be collected, and judge that this is due-in when receiving data mart modeling completion instructionWhether the table of collection statistical information meets default collection condition, if satisfied, collecting should be wait collect statistics then according to default collection strategyThe current statistic information of the table of information, after having carried out data mart modeling processing to the table in oracle database every time with realization, andWhen judge whether to need to collect statistical information again, to ensure the immediate updating of statistical information in oracle database；As it can be seen thatWhen receiving data mart modeling and complete instruction, and judging that table wait collect statistical information meets default collection condition, treat in timeThe recent statistics information for collecting the table of statistical information is collected, it can be ensured that CBO carries out SQL and executes road in oracle databaseStatistical information used by diameter calculates is always newest statistical information, and then ensure that calculated SQL execution route is mostShortest path improves the execution efficiency of SQL.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, completeSite preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based onEmbodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every otherEmbodiment shall fall within the protection scope of the present invention.
The embodiment of the invention discloses a kind of collection methods of statistical information, refer to attached drawing 1, the method specifically includesFollowing steps：
S101：When receiving data mart modeling completion instruction, the table of statistical information to be collected is obtained；
Refer to currently employed application system to having stored in oracle database specifically, data mart modeling completes instructionTable carried out data mart modeling processing, and changed data percentage has been more than inside oracle database in the tableWhen preset percentage threshold value (such as 10%), one automatically generated is instructed.Wherein, currently employed application system is mainly used forData mart modeling processing is carried out to table stored in oracle database, such as data addition, data merge.
It is handled when data mart modeling has occurred in table stored in oracle database, and in table shared by changed dataWhen percentage has been more than preset percentage threshold value inside oracle database, the statistical information that will lead to the table also changes therewithBecome, it is therefore desirable to which immediate updating is carried out to the statistical information of oracle database.
The table of statistical information to be collected can be according to the allocation list and dba view in oracle database, and getTable relevant to currently employed application system.Wherein, the allocation list in oracle database include essential attribute information, toCollect the relevant parameter information of the table of statistical information and the relevant parameter information of statistical information.
It should be noted that the number of the table of the statistical information to be collected got can be one, it is also possible to multiple.
S102：Judge whether the table of the statistical information to be collected meets default collection condition, the default collection conditionTable for the statistical information to be collected is not interim table, and the statistical information of the table of the statistical information to be collected is not lockedIt is fixed, if so, S103 is executed, if it is not, then executing S104.
S103：According to default collection strategy, the current statistic information of the table of the statistical information to be collected is collected；
Specifically, meet default collection condition in the table for judging statistical information to be collected, that is, statistical information to be collectedTable is not interim table, and should be when being not locked out wait collect the statistical information of table of statistical information, it was demonstrated that should statistical information be collectedThe statistical information of table need to collect again.At this point, according to default collection strategy, to the current of the table of the statistical information to be collectedStatistical information is collected, and the current statistic information being collected into is calculated SQL as CBO in subsequent oracle database and is executedUsed statistical information when path, and then efficiently solve due to CBO calculates SQL execution route using the statistical information of failureNot the problem of leading to calculated SQL execution route is not the path of least cost, seriously affects SQL execution efficiency.
It should be noted that when the table wait collect statistical information is multiple, then by each statistical information to be collectedTable is executed according to S102 and S103, to obtain the current statistic information of the table of each statistical information to be collected.
Interim table is a kind of table that data volume is little, and the statistical information of interim table can pass through oracle database dynamic collectionIt updates.
In practical applications, API (Application Programming Interface, application program volume can be passed throughJourney interface) realize that the collection for the current statistic information for treating the table for collecting statistical information operates.
Default collection strategy can be data volume in the composed structure and table of the table according to statistical information to be collected and build in advanceVertical, mainly include：" table of statistical information to be collected is empty table, and collecting zone is child partition ", " statistical information to be collectedTable is empty table, and collecting zone is subregion ", " table of statistical information to be collected is empty table, and collecting zone is whole table " is " due-inIntegrate the table of statistical information as nonempty list, and collecting zone is child partition ", and " table of statistical information to be collected is nonempty list, andCollecting zone is subregion " five kinds of strategies.
Wherein, the composed structure of the table of statistical information to be collected includes three kinds, respectively：Whole table, by least one subregionThe whole table of composition, and the whole table being made of at least one child partition.
Data volume is divided into table：Two kinds of " having data volume " and " not having data volume ".That is nonempty list and empty table.
Collecting zone, which refers to, has occurred data mart modeling processing in the table of statistical information to be collected, and changed data instituteThe region that percentage has been more than preset percentage threshold value (such as 10%) inside oracle database is accounted for, can be child partition, subregionAnd any one in whole table.
S104：Terminate；
Specifically, judging that the table of statistical information to be collected is unsatisfactory for default collection condition, that is, statistical information to be collectedTable meet " table of statistical information to be collected be interim table ", and " statistical information of the table of statistical information to be collected is locked "When any one or two kinds in both of these case, it was demonstrated that should the statistical information of table of statistical information to be collected do not need to receive againCollection terminates to collect operation at this time, and CBO uses the statistical information of initial storage still to calculate SQL and execute road in oracle databaseDiameter.
Wherein, statistical information is locked refers to that statistical information no longer changes, therefore does not need to be collected again.
A kind of collection method of statistical information disclosed in the embodiment of the present invention, by receive data mart modeling completion refer toWhen enabling, the table of statistical information to be collected is obtained, and judges whether the table of the statistical information to be collected meets default collection condition, ifMeet, then according to default collection strategy, collect the current statistic information of the table of the statistical information to be collected, to realize right every timeAfter table in oracle database has carried out data mart modeling processing, judge whether to need to collect statistical information again in time, with trueProtect the immediate updating of statistical information in oracle database；As it can be seen that completing instruction receiving data mart modeling, and judge due-inWhen the table of collection statistical information meets default collection condition, the recent statistics information for treating the table of collection statistical information in time is receivedCollection, it can be ensured that it is always newest system that CBO, which carries out statistical information used by SQL execution route calculates, in oracle databaseInformation is counted, and then ensure that calculated SQL execution route is optimal path, improves the execution efficiency of SQL.
On the basis of the embodiment corresponding to above-mentioned attached drawing 1, the embodiment of the invention discloses the receipts of another statistical informationSet method refers to attached drawing 2, and the method specifically includes following steps：
S201：When receiving data mart modeling completion instruction, the table of statistical information to be collected is obtained.
S202：Judge whether the table of the statistical information to be collected meets default collection condition, the default collection conditionTable for the statistical information to be collected is not interim table, and the statistical information of the table of the statistical information to be collected is not lockedIt is fixed, if so, S203 is executed, if it is not, then executing S204.
S203：The table of statistical information to be collected described in being when the default collection strategy is sky table, and collecting zone is sonWhen subregion, the allocation list of oracle database is obtained, and executes S205；
Specifically, since the allocation list of oracle database includes the table of essential attribute information, statistical information to be collectedThe relevant parameter information of relevant parameter information and statistical information, therefore, when default collection strategy is " statistical information to be collectedTable is empty table, and collecting zone is child partition " when, by obtaining the allocation list of oracle database, to know Oracle dataThe relevant parameter information of the table of statistical information to be collected in library.
It should be noted that when default collection strategy is that " table of statistical information to be collected is empty table, and collecting zone is sonWhen subregion ", the composed structure of the table of statistical information to be collected is the whole table being made of at least one child partition.
When collecting zone is child partition, the number of the child partition can be one or more.
S204：Terminate.
S205：Judge whether the number of processes of the table of the statistical information to be collected reaches the maximum processing of the allocation listNumber, if so, S206 is executed, if it is not, then executing S207；
Specifically, the number of processes of the table of statistical information to be collected can refer to the table of due-in collection statistical information by current instituteThe application system of use carries out data mart modeling number of processing.
S206：It collects belonging to statistical information and the child partition of the child partition of the table of the statistical information to be collectedSubregion statistical information, and using the statistical information of subregion belonging to the statistical information of the child partition and the child partition asThe current statistic information；
Specifically, being proved if the number of processes of the table of statistical information to be collected reaches the maximum number of processes of allocation listCurrently employed application system is that last time carries out data mart modeling processing to the table of the statistical information to be collected, at this point, rightSubregion belonging to child partition and the child partition in the table of the statistical information to be collected by data mart modeling processing is countedThe collection of information, to obtain newest statistical information.
It should be noted that collecting the system of each child partition when the number of the child partition in collecting zone is multipleThe statistical information for counting information and its affiliated subregion, as current statistic information.
S207：Collect the statistical information of the child partition of the table of the statistical information to be collected, and by the system of the child partitionInformation is counted as the current statistic information；
Specifically, being demonstrate,proved if the number of processes of the table of statistical information to be collected is not up to the maximum number of processes of allocation listBright currently employed application system is not that last time carries out data mart modeling processing to the table of the statistical information to be collected, thisWhen, the statistical information that can only treat the child partition in the table for collecting statistical information by data mart modeling processing is collected.
A kind of collection method of statistical information disclosed in the embodiment of the present invention, it is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is sky table, and when collecting zone is child partition, sentenceWhether the number of processes of the table of disconnected statistical information to be collected reaches the maximum number of processes in the allocation list got, if reaching,Then collect the child partition of the table of statistical information to be collected statistical information and the child partition belonging to subregion statistical information,As current statistic information, if not up to, the statistical information of the child partition of the table of statistical information to be collected only is collected, as working asPreceding statistical information；As it can be seen that being sky table in the table that default collection strategy is statistical information to be collected, and collecting zone is child partitionWhen, using the number of processes of the table of statistical information to be collected reach the maximum number of processes of allocation list as execute collect operation according toAccording to can quickly be collected into newest statistics when the table wait collect statistical information completes the processing of last time data mart modeling and believeBreath, and then ensure the real-time of statistical information.
On the basis of the embodiment corresponding to above-mentioned attached drawing 1, the embodiment of the invention discloses the receipts of another statistical informationSet method refers to attached drawing 3, and the method specifically includes following steps：
S301：When receiving data mart modeling completion instruction, the table of statistical information to be collected is obtained.
S302：Judge whether the table of the statistical information to be collected meets default collection condition, the default collection conditionTable for the statistical information to be collected is not interim table, and the statistical information of the table of the statistical information to be collected is not lockedIt is fixed, if so, S303 is executed, if it is not, then executing S304.
S303：The table of statistical information to be collected described in being when the default collection strategy is sky table, and collecting zone is pointQu Shi, obtains the allocation list of oracle database, and executes S305；
Specifically, since the allocation list of oracle database includes the table of essential attribute information, statistical information to be collectedThe relevant parameter information of relevant parameter information and statistical information, therefore, when preset collection strategy is " statistical information to be collectedTable be empty table, and collecting zone is subregion " when, by obtaining the allocation list of oracle database, to know Oracle dataThe relevant parameter information of the table of statistical information to be collected in library.
It should be noted that when default collection strategy is that " table of statistical information to be collected is empty table, and collecting zone is pointWhen area ", the composed structure of the table of statistical information to be collected is the whole table being made of at least one subregion.
When collecting zone is subregion, the number of the subregion can be one or more.
S304：Terminate.
S305：Judge whether the number of processes of the table of the statistical information to be collected reaches the maximum processing of the allocation listNumber, if so, S306 is executed, if it is not, then executing S307；
Specifically, the number of processes of the table of statistical information to be collected can refer to the table of due-in collection statistical information by current instituteThe application system of use carries out data mart modeling number of processing.
S306：It is whole belonging to the statistical information of the subregion of the table of statistical information to be collected described in collecting and the subregionThe statistical information of table, and using the statistical information of whole table belonging to the statistical information of the subregion and the subregion as described currentStatistical information；
Specifically, being proved if the number of processes of the table of statistical information to be collected reaches the maximum number of processes of allocation listCurrently employed application system is that last time carries out data mart modeling processing to the table of the statistical information to be collected, at this point, rightWhole table belonging to subregion and the subregion in the table of the statistical information to be collected by data mart modeling processing carries out statistical informationCollection, to obtain newest statistical information.
It should be noted that collecting the statistics letter of each subregion when the number of the subregion in collecting zone is multipleThe statistical information of breath and its affiliated whole table, as current statistic information.
S307：The statistical information of the subregion of the table of the statistical information to be collected is collected, and the statistics of the subregion is believedBreath is used as the current statistic information；
Specifically, being demonstrate,proved if the number of processes of the table of statistical information to be collected is not up to the maximum number of processes of allocation listBright currently employed application system is not that last time carries out data mart modeling processing to the table of the statistical information to be collected, thisWhen, the statistical information that can only treat the subregion in the table for collecting statistical information by data mart modeling processing is collected.
A kind of collection method of statistical information disclosed in the embodiment of the present invention, it is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is sky table, and when collecting zone is subregion, judgementWhether the number of processes of the table of statistical information to be collected reaches the maximum number of processes in the allocation list got, if reaching,Collect the subregion of the table of statistical information to be collected statistical information and the subregion belonging to whole table statistical information, as working asPreceding statistical information is believed if not up to, only collecting the statistical information of the subregion of the table of statistical information to be collected as current statisticBreath；It, will be wait collect as it can be seen that be sky table in the table that default collection strategy is statistical information to be collected, and when collecting zone is subregionThe number of processes of the table of statistical information reaches the maximum number of processes of allocation list as executing the foundation for collecting operation, can toWhen collecting the table completion last time data mart modeling processing of statistical information, it is quickly collected into newest statistical information, and then ensureThe real-time of statistical information.
On the basis of the embodiment corresponding to above-mentioned attached drawing 1, the embodiment of the invention discloses the receipts of another statistical informationSet method refers to attached drawing 4, and the method specifically includes following steps：
S401：When receiving data mart modeling completion, the table of statistical information to be collected is obtained.
S402：Judge whether the table of the statistical information to be collected meets default collection condition, the default collection conditionTable for the statistical information to be collected is not interim table, and the statistical information of the table of the statistical information to be collected is not lockedIt is fixed, if so, S403 is executed, if it is not, then executing S404.
S403：The table of statistical information to be collected described in being when the default collection strategy is sky table, and collecting zone is wholeWhen table, the allocation list of oracle database is obtained, and executes S405；
Specifically, since the allocation list of oracle database includes the table of essential attribute information, statistical information to be collectedThe relevant parameter information of relevant parameter information and statistical information, therefore, when preset collection strategy is " statistical information to be collectedTable be empty table, and collecting zone is whole table " when, by obtaining the allocation list of oracle database, to know Oracle dataThe relevant parameter information of the table of statistical information to be collected in library.
It should be noted that when default collection strategy is that " table of statistical information to be collected is empty table, and collecting zone is wholeWhen table ", the composed structure of the table of statistical information to be collected is whole table.
S404：Terminate.
S405：Judge whether the number of processes of the table of the statistical information to be collected reaches the maximum processing of the allocation listNumber, if so, S406 is executed, if it is not, then executing S407；
Specifically, the number of processes of the table of statistical information to be collected can refer to the table of due-in collection statistical information by current instituteThe application system of use carries out data mart modeling number of processing.
S406：The statistical information of the whole table of the table of the statistical information to be collected is collected, and the statistics of the whole table is believedBreath is used as the current statistic information；
Specifically, being proved if the number of processes of the table of statistical information to be collected reaches the maximum number of processes of allocation listCurrently employed application system is that last time carries out data mart modeling processing to the table of the statistical information to be collected, at this point, directlyThe collection that the whole table in the table to the statistical information to be collected by data mart modeling processing carries out statistical information is connect, it is newest to obtainStatistical information.
S407：Terminate.
A kind of collection method of statistical information disclosed in the embodiment of the present invention, it is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is sky table, and when collecting zone is whole table, judgementWhether the number of processes of the table of statistical information to be collected reaches the maximum number of processes in the allocation list got, if reaching,The statistical information for collecting the whole table of the table of statistical information to be collected, as current statistic information；As it can be seen that being in default collection strategyThe table of statistical information to be collected is empty table, and when collecting zone is whole table, the number of processes of the table of statistical information to be collected is reachedMaximum number of processes to allocation list collects the foundation operated as execution, can complete in the table of statistical information to be collected lastWhen data mart modeling processing, it is quickly collected into the recent statistics information of whole table, and then ensure the real-time of statistical information.
On the basis of the embodiment corresponding to above-mentioned attached drawing 1, the embodiment of the invention discloses the receipts of another statistical informationSet method refers to attached drawing 5, and the method specifically includes following steps：
S501：When receiving data mart modeling completion instruction, the table of statistical information to be collected is obtained.
S502：Judge whether the table of the statistical information to be collected meets default collection condition, the default collection conditionTable for the statistical information to be collected is not interim table, and the statistical information of the table of the statistical information to be collected is not lockedIt is fixed, if so, S503 is executed, if it is not, then executing S504.
S503：The table of statistical information to be collected described in being when the default collection strategy is nonempty list, and collecting zone isWhen child partition, the allocation list of oracle database is obtained, and executes S505；
Specifically, since the allocation list of oracle database includes the table of essential attribute information, statistical information to be collectedThe relevant parameter information of relevant parameter information and statistical information, therefore, when preset collection strategy is " statistical information to be collectedTable be nonempty list, and collecting zone be child partition " when, by obtain oracle database allocation list, to know OracleThe relevant parameter information of the table of statistical information to be collected in database.
It should be noted that when default collection strategy is that " table of statistical information to be collected is nonempty list, and collecting zone isWhen child partition ", the composed structure of the table of statistical information to be collected is the whole table being made of at least one child partition.
S504：Terminate.
S505：Judge whether identify comprising forced collection in the allocation list, if so, S506 is executed, if it is not, then executingS507。
S506：Collect the statistical information of the child partition of the table of the statistical information to be collected, and by the system of the child partitionInformation is counted as the current statistic information；
Specifically, proving that the table of statistical information to be collected must unite if identifying in allocation list comprising forced collectionCount the collection of information.At this point, directly the child partition for passing through data mart modeling processing in the table of the statistical information to be collected is unitedThe collection of information is counted, to obtain newest statistical information.
S507：Judge whether the number of the child partition is equal to 1, if so, S508 is executed, if it is not, then executing S509.
S508：According to the identification information of the allocation list, the initial statistical letter of the table of the statistical information to be collected is judgedWhether breath fails, if so, S510 is executed, if it is not, then executing S511；
Specifically, if the number of child partition is equal to 1, it was demonstrated that by data mart modeling processing in the table of statistical information to be collectedRegion is only a child partition.At this time, it may be necessary to the table of stored statistical information to be collected before in oracle databaseWhether initial statistical information, which fails, is judged, to further determine whether to need to collect statistical information again.
Wherein, the identification information of allocation list can refer to collection period in the relevant parameter information of statistical information, maximumThe information such as the relevant dba view of threshold value, Oracle.
S509：Terminate；
Specifically, if the number of child partition is greater than 1, it was demonstrated that by data mart modeling processing in the table of statistical information to be collectedRegion is multiple child partitions, that is, proves that the table of the statistical information to be collected is the huge table of data volume, when this waits collecting statistics letterWhen there are multiple child partitions to carry out data mart modeling processing in the table of breath, the statistical information of whole table is influenced less, therefore is not needed pairIts collection for carrying out statistical information.
S510：Collect the statistical information of the child partition of the table of the statistical information to be collected, and by the system of the child partitionInformation is counted as the current statistic information.
S511：Terminate；
Specifically, not needing after the initial statistical information for judging the table wait collect statistical information does not fail to it yetCarry out the collection of statistical information.
A kind of collection method of statistical information disclosed in the embodiment of the present invention, it is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is nonempty list, and when collecting zone is child partition,Judge whether identify comprising forced collection in allocation list, if comprising collecting the system of the child partition of the table of statistical information to be collectedInformation is counted, as the current statistic information, if not including, is equal to 1 in the number for judging child partition, and wait collect statisticsAfter the initial statistical information failure of the table of information, the statistical information of the child partition of the table of statistical information to be collected is collected, as working asPreceding statistical information；As it can be seen that being nonempty list in the table that default collection strategy is statistical information to be collected, and collecting zone is child partitionWhen, by allocation list whether comprising forced collection mark, whether the number of child partition is equal to 1 in collecting zone, and wait collectWhether the initial statistical information of the table of statistical information fails, and as the foundation for collecting operation is executed, can be accurately judged to due-inWhether the statistical information for collecting the table of statistical information needs to collect again, to improve collection efficiency, it is ensured that the real-time of statistical information.
On the basis of the embodiment corresponding to above-mentioned attached drawing 1, the embodiment of the invention discloses the receipts of another statistical informationSet method refers to attached drawing 6, and the method specifically includes following steps：
S601：When receiving data mart modeling completion instruction, the table of statistical information to be collected is obtained.
S602：Judge whether the table of the statistical information to be collected meets default collection condition, the default collection conditionTable for the statistical information to be collected is not interim table, and the statistical information of the table of the statistical information to be collected is not lockedIt is fixed, if so, S603 is executed, if it is not, then executing S604.
S603：The table of statistical information to be collected described in being when the default collection strategy is nonempty list, and collecting zone isWhen subregion, the allocation list of oracle database is obtained, and executes S605；
Specifically, since the allocation list of oracle database includes the table of essential attribute information, statistical information to be collectedThe relevant parameter information of relevant parameter information and statistical information, therefore, when preset collection strategy is " statistical information to be collectedTable be nonempty list, and collecting zone be subregion " when, by obtain oracle database allocation list, to know Oracle numberAccording to the relevant parameter information of the table of statistical information to be collected in library.
It should be noted that when default collection strategy is that " table of statistical information to be collected is nonempty list, and collecting zone isWhen subregion ", the composed structure of the table of statistical information to be collected is the whole table being made of at least one subregion.
S604：Terminate.
S605：Judge whether identify comprising forced collection in the allocation list, if so, S606 is executed, if it is not, then executingS607。
S606：The statistical information of the subregion of the table of the statistical information to be collected is collected, and the statistics of the subregion is believedBreath is used as the current statistic information；
Specifically, proving that the table of statistical information to be collected must unite if identifying in allocation list comprising forced collectionCount the collection of information.At this point, directly the subregion for passing through data mart modeling processing in the table of the statistical information to be collected is countedThe collection of information, to obtain newest statistical information.
S607：Judge whether the number of the subregion is equal to 1, if so, S608 is executed, if it is not, then executing S609.
S608：According to the identification information of the allocation list, the initial statistical letter of the table of the statistical information to be collected is judgedWhether breath fails, if so, S610 is executed, if it is not, then executing S609；
Specifically, if the number of subregion is equal to 1, it was demonstrated that by the area of data mart modeling processing in the table of statistical information to be collectedDomain is only a subregion.At this time, it may be necessary to before in oracle database the table of stored statistical information to be collected it is initialWhether statistical information, which fails, is judged, to further determine whether to need to collect statistical information again.
Wherein, the identification information of allocation list can refer to collection period in the relevant parameter information of statistical information, maximumThe information such as the relevant dba view of threshold value, Oracle.
S609：Terminate；
Specifically, if the number of subregion is greater than 1, it was demonstrated that by the area of data mart modeling processing in the table of statistical information to be collectedDomain is multiple subregions, that is, proves that the table of the statistical information to be collected is the huge table of data volume, when the statistical information to be collectedWhen there are multiple subregions to carry out data mart modeling processing in table, the statistical information of whole table is influenced less, therefore do not need to carry out itThe collection of statistical information.
S610：The statistical information of the subregion of the table of the statistical information to be collected is collected, and the statistics of the subregion is believedBreath is used as the current statistic information.
S611：Terminate；
Specifically, not needing after the initial statistical information for judging the table wait collect statistical information does not fail to it yetCarry out the collection of statistical information.
A kind of collection method of statistical information disclosed in the embodiment of the present invention, it is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is nonempty list, and when collecting zone is subregion, sentenceWhether identified comprising forced collection in disconnected allocation list, if comprising collecting the statistics letter of the subregion of the table of statistical information to be collectedBreath, as the current statistic information, if not including, in the number for judging subregion equal to 1, and statistical information to be collectedAfter the initial statistical information failure of table, the statistical information of the subregion of the table of statistical information to be collected is collected, is believed as current statisticBreath；As it can be seen that be nonempty list in the table that default collection strategy is statistical information to be collected, and when collecting zone is subregion, will configureWhether whether the number comprising subregion in forced collection mark, collecting zone is equal to 1, and the table of statistical information to be collected in tableInitial statistical information whether fail, as execute collect operation foundation, statistical information to be collected can be accurately judged toWhether the statistical information of table needs to collect again, to improve collection efficiency, it is ensured that the real-time of statistical information.
The embodiment of the invention discloses a kind of collection devices of statistical information, refer to attached drawing 7, including：
Module 701 is obtained, for obtaining the table of statistical information to be collected when receiving data mart modeling completion instruction；
Judgment module 702, it is described pre- for judging whether the table of the statistical information to be collected meets default collection conditionIf the table that collection condition is the statistical information to be collected is not interim table, and the statistics of the table of the statistical information to be collected is believedBreath is not locked out；
Collection module 703, if the table for the statistical information to be collected meets the default collection condition, according to defaultCollection strategy collects the current statistic information of the table of the statistical information to be collected.
It should be noted that default collection strategy can be in composed structure and table according to the table of statistical information to be collectedWhat data volume pre-established, mainly include：" table of statistical information to be collected is empty table, and collecting zone is child partition ", it is " due-inThe table for collecting statistical information is empty table, and collecting zone is subregion ", " table of statistical information to be collected is empty table, and collecting zone isWhole table ", " table of statistical information to be collected is nonempty list, and collecting zone is child partition ", the and " table of statistical information to be collectedFor nonempty list, and collecting zone is subregion " five kinds of strategies.
Wherein, the composed structure of the table of statistical information to be collected includes three kinds, respectively：Whole table, by least one subregionThe whole table of composition, and the whole table being made of at least one child partition.
Data volume is divided into table：Two kinds of " having data volume " and " not having data volume ".That is nonempty list and empty table.
Collecting zone, which refers to, occurs data mart modeling processing in the table of statistical information to be collected, and shared by changed dataPercentage has been more than the region of preset percentage threshold value (such as 10%) inside oracle, can be child partition, subregion and whole tableIn any one.
A kind of collection device of statistical information disclosed in the embodiment of the present invention is receiving number by obtaining module 701When according to completing the process instruction, the table of statistical information to be collected is obtained, judgment module 702 judges that the table of the statistical information to be collected isIt is no to meet default collection condition, if satisfied, then for collection module 703 according to default collection strategy, collecting should statistical information be collectedTable current statistic information, with realize every time to the table in oracle database carried out data mart modeling processing after, sentence in timeIt is disconnected whether to need to collect statistical information again, to ensure the immediate updating of statistical information in oracle database；As it can be seen that receivingWhen completing to instruct to data mart modeling, and judging that table wait collect statistical information meets default collection condition, collection is treated in timeThe recent statistics information of the table of statistical information is collected, it can be ensured that CBO carries out SQL execution route meter in oracle databaseStatistical information used by calculating is always newest statistical information, and then ensure that calculated SQL execution route is optimal roadDiameter improves the execution efficiency of SQL.
The course of work of modules provided in an embodiment of the present invention please refers to method flow diagram corresponding to attached drawing 1, toolBody running process repeats no more.
On the basis of the embodiment corresponding to above-mentioned attached drawing 7, the embodiment of the invention discloses the receipts of another statistical informationAcquisition means refer to attached drawing 8, including：
Obtain module 701, judgment module 702, collection module 703；
Wherein, the collection module 703 includes：
First acquisition unit 7031, for being empty when the table that the default collection strategy is the statistical information to be collectedTable, and collecting zone be child partition when, obtain the allocation list of oracle database；
First judging unit 7032, for judging whether the number of processes of table of the statistical information to be collected reaches describedThe maximum number of processes of allocation list；
First collector unit 7033, if the number of processes of the table for the statistical information to be collected reaches the allocation listMaximum number of processes, collect statistical information and the child partition institute of the child partition of the table of the statistical information to be collectedThe statistical information of the subregion of category, and the statistical information of subregion belonging to the statistical information of the child partition and the child partition is madeFor the current statistic information；
Second collector unit 7034, if the number of processes of the table for the statistical information to be collected is not up to the configurationThe maximum number of processes of table, collects the statistical information of the child partition of the table of the statistical information to be collected, and by the child partitionStatistical information as the current statistic information.
A kind of collection device of statistical information disclosed in the embodiment of the present invention is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is sky table, and when collecting zone is child partition, theOne judging unit 7032 judges whether the number of processes of the table of statistical information to be collected reaches first acquisition unit 7031 and getAllocation list in maximum number of processes, if reaching, the first collector unit 7033 collects the son of the table of statistical information to be collectedThe statistical information of subregion belonging to the statistical information of subregion and the child partition, as current statistic information, if not up to,Second collector unit 7034 collects the statistical information of the child partition of the table of statistical information to be collected, as current statistic information；It canSee, be sky table in the table that default collection strategy is statistical information to be collected, and when collecting zone is child partition, it will be wait collect statisticsThe maximum number of processes that the number of processes of the table of information reaches allocation list collects the foundation of operation as execution, can be wait collectWhen the table of statistical information completes the processing of last time data mart modeling, it is quickly collected into newest statistical information, and then ensure systemCount the real-time of information.
The course of work of modules provided in an embodiment of the present invention please refers to method flow diagram corresponding to attached drawing 2, toolBody running process repeats no more.
On the basis of the embodiment corresponding to above-mentioned attached drawing 7, the embodiment of the invention discloses the receipts of another statistical informationAcquisition means refer to attached drawing 9, including：
Obtain module 701, judgment module 702, collection module 703；
Wherein, the collection module 703 includes：
Second acquisition unit 7035, for being empty when the table that the default collection strategy is the statistical information to be collectedTable, and collecting zone be subregion when, obtain the allocation list of oracle database；
Second judgment unit 7036, for judging whether the number of processes of table of the statistical information to be collected reaches describedThe maximum number of processes of allocation list；
Third collector unit 7037, if the number of processes of the table for the statistical information to be collected reaches the allocation listMaximum number of processes, collect belonging to statistical information and the subregion of the subregion of the table of the statistical information to be collectedThe statistical information of whole table, and the statistical information of whole table belonging to the statistical information of the subregion and the subregion is worked as described inPreceding statistical information；
4th collector unit 7038, if the number of processes of the table for the statistical information to be collected is not up to the configurationThe maximum number of processes of table, collects the statistical information of the subregion of the table of the statistical information to be collected, and by the system of the subregionInformation is counted as the current statistic information.
A kind of collection method of statistical information disclosed in the embodiment of the present invention, it is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is sky table, and when collecting zone is subregion, secondJudging unit 7036 judges whether the number of processes of the table of statistical information to be collected reaches what second acquisition unit 7035 was gotMaximum number of processes in allocation list, if reaching, third collector unit 7037 collects the subregion of the table of statistical information to be collectedStatistical information and the subregion belonging to whole table statistical information, as current statistic information, if not up to, the 4th receiveCollection unit 7038 collects the statistical information of the subregion of the table of statistical information to be collected, as current statistic information；As it can be seen that defaultCollection strategy is that the table of statistical information to be collected is sky table, and when collecting zone is subregion, by the table of statistical information to be collectedThe maximum number of processes that number of processes reaches allocation list collects the foundation of operation as execution, can be in statistical information to be collectedWhen table completes the processing of last time data mart modeling, it is quickly collected into newest statistical information, and then ensure the reality of statistical informationShi Xing.
The course of work of modules provided in an embodiment of the present invention please refers to method flow diagram corresponding to attached drawing 3, toolBody running process repeats no more.
On the basis of the embodiment corresponding to above-mentioned attached drawing 7, the embodiment of the invention discloses the receipts of another statistical informationAcquisition means refer to attached drawing 10, including：
Obtain module 701, judgment module 702, collection module 703；
Wherein, the collection module 703 includes：
Third acquiring unit 7039, for being empty when the table that the default collection strategy is the statistical information to be collectedTable, and collecting zone be whole table when, obtain the allocation list of oracle database；
Third judging unit 70310, for judging whether the number of processes of table of the statistical information to be collected reaches instituteState the maximum number of processes of allocation list；
5th collector unit 70311, if the number of processes of the table for the statistical information to be collected reaches the configurationThe maximum number of processes of table, collects the statistical information of the whole table of the table of the statistical information to be collected, and by the system of the whole tableInformation is counted as the current statistic information.
A kind of collection device of statistical information disclosed in the embodiment of the present invention is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is sky table, and when collecting zone is whole table, thirdJudging unit 70310 judges whether the number of processes of the table of statistical information to be collected reaches what third acquiring unit 7039 was gotMaximum number of processes in allocation list, if reaching, the 5th collector unit 70311 collects the whole table of the table of statistical information to be collectedStatistical information, as current statistic information；As it can be seen that be sky table in the table that default collection strategy is statistical information to be collected, andWhen collecting zone is whole table, the number of processes of the table of statistical information to be collected is reached into the maximum number of processes of allocation list as holdingRow collects the foundation of operation, can quickly collect when the table wait collect statistical information completes the processing of last time data mart modelingTo the recent statistics information of whole table, and then ensure the real-time of statistical information.
The course of work of modules provided in an embodiment of the present invention please refers to method flow diagram corresponding to attached drawing 4, toolBody running process repeats no more.
On the basis of the embodiment corresponding to above-mentioned attached drawing 7, the embodiment of the invention discloses the receipts of another statistical informationAcquisition means refer to attached drawing 11, including：
Obtain module 701, judgment module 702, collection module 703；
Wherein, the collection module 703 includes：
4th acquiring unit 70312, for being non-when the table that the default collection strategy is the statistical information to be collectedEmpty table, and collecting zone be child partition when, obtain the allocation list of oracle database；
4th judging unit 70313, for whether judging in the allocation list comprising forced collection mark；
6th collector unit 70314, if being collected described due-in for being identified in the allocation list comprising the forced collectionCollect the statistical information of the child partition of the table of statistical information, and believes the statistical information of the child partition as the current statisticBreath；
5th judging unit 70315 judges the son if identifying for not including the forced collection in the allocation listWhether the number of subregion is equal to 1；
6th judging unit 70316 is believed if the number for the child partition is equal to 1 according to the identification of the allocation listBreath, judges whether the initial statistical information of the table of the statistical information to be collected fails；
7th collector unit 70317, if the initial statistical information failure of the table for the statistical information to be collected, is collectedThe statistical information of the child partition of the table of the statistical information to be collected, and using the statistical information of the child partition as described currentStatistical information.
A kind of collection device of statistical information disclosed in the embodiment of the present invention is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is nonempty list, and when collecting zone is child partition,4th judging unit 70313 judges whether identify comprising forced collection in allocation list, if including the 6th collector unit 70314The statistical information for collecting the child partition of the table of statistical information to be collected, as the current statistic information, if not including,Five judging units 70315 judge that the number of child partition is equal to 1, and the 6th judging unit 70316 is judged wait collect statistics letterAfter the initial statistical information failure of the table of breath, the 7th collector unit 70317 collects the child partition of the table of statistical information to be collectedStatistical information, as current statistic information；As it can be seen that be nonempty list in the table that default collection strategy is statistical information to be collected, andWhen collecting zone is child partition, by allocation list whether comprising forced collection mark, in collecting zone child partition number whetherEqual to 1, and whether the initial statistical information of table of statistical information to be collected fails, can as the foundation for collecting operation is executedTo be accurately judged to whether the statistical information of the table of statistical information to be collected needs to collect again, to improve collection efficiency, it is ensured thatThe real-time of statistical information.
The course of work of modules provided in an embodiment of the present invention please refers to method flow diagram corresponding to attached drawing 5, toolBody running process repeats no more.
On the basis of the embodiment corresponding to above-mentioned attached drawing 7, the embodiment of the invention discloses the receipts of another statistical informationAcquisition means refer to attached drawing 12, including：
Obtain module 701, judgment module 702, collection module 703；
Wherein, the collection module 703 includes：
5th acquiring unit 70318, for being non-when the table that the default collection strategy is the statistical information to be collectedEmpty table, and collecting zone be subregion when, obtain the allocation list of oracle database；
7th judging unit 70319, for whether judging in the allocation list comprising forced collection mark；
8th collector unit 70320, if being collected described due-in for being identified in the allocation list comprising the forced collectionCollect the statistical information of the subregion of the table of statistical information, and using the statistical information of the subregion as the current statistic information；
8th judging unit 70321, if being identified for not including the forced collection in the allocation list, described point of judgementWhether the number in area is equal to 1；
9th judging unit 70322, if the number for the subregion is equal to 1, according to the identification information of the allocation list,Judge whether the initial statistical information of the table of the statistical information to be collected fails；
9th collector unit 70323, if the initial statistical information failure of the table for the statistical information to be collected, is collectedThe statistical information of the subregion of the table of the statistical information to be collected, and using the statistical information of the subregion as the current statisticInformation.
A kind of collection device of statistical information disclosed in the embodiment of the present invention is full by the table in statistical information to be collectedThe default collection condition of foot, default collection strategy are that the table of statistical information to be collected is nonempty list, and when collecting zone is subregion, theSeven judging units 70319 judge whether identify comprising forced collection in allocation list, if comprising the 8th collector unit 70320 is receivedThe statistical information for collecting the subregion of the table of statistical information to be collected is sentenced if not including the 8th as the current statistic informationDisconnected unit 70321 judges that the number of subregion is equal to 1, and the 9th judging unit 70322 judges the table of statistical information to be collectedInitial statistical information failure after, the 9th collector unit 70323 collects the statistical information of the subregion of the table of statistical information to be collected,As current statistic information；As it can be seen that being nonempty list in the table that default collection strategy is statistical information to be collected, and collecting zone isWhen subregion, by whether comprising forced collection mark, in collecting zone, whether the number of subregion is equal to 1 and due-in in allocation listWhether the initial statistical information of table for collecting statistical information fails, as the foundation for collecting operation is executed, can be accurately judged toWhether the statistical information of table for collecting statistical information needs to collect again, to improve collection efficiency, it is ensured that statistical information it is real-timeProperty.
The course of work of modules provided in an embodiment of the present invention please refers to method flow diagram corresponding to attached drawing 6, toolBody running process repeats no more.
The foregoing description of the disclosed embodiments enables those skilled in the art to implement or use the present invention.Various modifications to these embodiments will be readily apparent to those skilled in the art, as defined hereinGeneral Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, of the inventionIt is not intended to be limited to the embodiments shown herein, and is to fit to and the principles and novel features disclosed herein phase oneThe widest scope of cause.