CN106776704A - Statistical information collection method and device - Google Patents
Statistical information collection method and device Download PDFInfo
- Publication number
- CN106776704A CN106776704A CN201611003385.2A CN201611003385A CN106776704A CN 106776704 A CN106776704 A CN 106776704A CN 201611003385 A CN201611003385 A CN 201611003385A CN 106776704 A CN106776704 A CN 106776704A
- Authority
- CN
- China
- Prior art keywords
- statistical information
- change operation
- change
- index
- action type
- 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
- 238000000034 method Methods 0.000 title claims abstract description 22
- 230000008859 change Effects 0.000 claims abstract description 360
- 230000009471 action Effects 0.000 claims abstract description 105
- 230000000875 corresponding effect Effects 0.000 claims abstract description 105
- 238000012217 deletion Methods 0.000 claims description 30
- 230000037430 deletion Effects 0.000 claims description 30
- 238000005194 fractionation Methods 0.000 claims description 7
- 230000006399 behavior Effects 0.000 description 12
- 238000005192 partition Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 241001269238 Data Species 0.000 description 2
- 230000001419 dependent effect Effects 0.000 description 2
- 238000009472 formulation Methods 0.000 description 2
- 238000003780 insertion Methods 0.000 description 2
- 230000037431 insertion Effects 0.000 description 2
- 230000014759 maintenance of location Effects 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000005070 sampling Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of statistical information collection method and device.The above method includes：Obtain change operation note；The change operation note is analyzed, the corresponding action type of the change operation note is obtained；Obtain default change operation corresponding with the action type；When comprising the default change operation, then obtained in the change operation note with comprising the change collection template that match of operation, and collect the template new statistical information of collection according to described.Above-mentioned statistical information collection method and device, have refined the collection mode of statistical information, can effectively improve the accuracy of the statistical information of collection.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of statistical information collection method and device.
Background technology
In database, statistical information generally refers to size, the scale for table in descriptive data base and index, and
One category information of data distribution situation etc., for example, the line number of table, the block number of table, average often capable size, the root block number of index,
The line number of index field and the maximum of index, minimum value etc., belong to statistical information.Database can be according to the statistical information collected
The cost of each executive plan under different access path and join (connection) mode is calculated, so that it is determined that going out the execution of minimum cost
Plan, for performing SQL (Structured Query Language, SQL) sentence.Traditional statistical information
Collection mode, the statistical information sampling instrument for typically all being carried using database is collected, and the mode of collection is relatively simple, leads
The statistical information collected is caused to be likely to occur inaccurate situation.
The content of the invention
Based on this, it is necessary to provide a kind of statistical information collection method, can effectively improve collection statistical information it is accurate
Property.
Additionally, there is a need to a kind of statistics gatherer means of offer, can effectively improve collection statistical information it is accurate
Property.
A kind of statistical information collection method, including：
Obtain change operation note；
The change operation note is analyzed, the corresponding action type of the change operation note is obtained；
Obtain default change operation corresponding with the action type；
When it is described change operation note in comprising it is described it is default change operation, then obtain with comprising change operate match
Collection template, and new statistical information is collected according to the collection template.
Wherein in one embodiment, the action type includes table handling；
It is described when it is described change operation note in comprising it is described it is default change operation, then obtain with comprising change operation
The collection template of matching, and new statistical information is collected according to the collection template, including：
Newly-built table handling is included in the action type is for the change operation note of table handling, is then judged comprising described new
Whether carry out data initialization, if carrying out, collect corresponding with the newly-built table handling if building in the change operation note of table handling
Tables of data new statistical information；
And/or
Comprising deleting, all rows of table are operated or table structure exists in the action type is for the change operation note of table handling
Line redefines operation, then back up and redefine the tables of data that operation is associated online with all row operations of the deletion table or table structure
Old statistical information, and collection redefines the new of the tables of data that operation is associated online with all rows operations of the deletion table or table structure
Statistical information.
Wherein in one embodiment, the action type includes table handling；
It is described when it is described change operation note in comprising it is described it is default change operation, then obtain with comprising change operation
The collection template of matching, and new statistical information is collected according to the collection template, including：
If the action type judges the table to change operation comprising table structure in the change operation note of table handling
Whether structure change operation is field change operation；
If the table structure change operation is field change operation, backs up and change the corresponding data of operation with the field
The old statistical information of table, and collect the new statistical information that the corresponding tables of data of operation is changed with the field；
If the table structure change operation is table division operation, when the table division operation is newly-increased division operation, then receive
The new statistical information of the subregion that collection is associated with the newly-increased division operation, when the table division operation is for merging division operation or tears open
Divide division operation, then back up the old statistical information of the subregion associated with the merging division operation or fractionation division operation, and receive
Collect with the merging division operation or split the new statistical information of the subregion that division operation is associated.
Wherein in one embodiment, it is described when it is described change operation note in comprising it is described it is default change operation,
Then obtain with comprising the change collection template that match of operation, and according to it is described collect template collection new statistical information the step of it
Afterwards, also include：
According to the action type for the change operation included in the change operation note of table handling determines DML objects；
File according to record DML implementation status judges whether the DML quantity for belonging to the DML objects reaches present count
Value；
If reaching, judged whether to enable new statistical information according to default configuration item, if so, then enabling the new system of collection
Meter information, if it is not, then recovering the old statistical information of backup.
Wherein in one embodiment, the action type includes index operation；
It is described when it is described change operation note in comprising it is described it is default change operation, then obtain with comprising change operation
The collection template of matching, and new statistical information is collected according to the collection template, including：
If the action type for index operation change operation note in include newly-built index operation, collect with it is described
The new statistical information of the corresponding index of newly-built index operation；
And/or
If the action type for index operation change operation note in comprising rebuild index operation, back up with it is described
The old statistical information of the corresponding index of index operation is rebuild, and collects the new statistics of index corresponding with the reconstruction index operation
After information, recover the old statistical information.
A kind of statistics gatherer means, including：
Record acquisition module, for obtaining change operation note；
Analysis module, for analyzing the change operation note, obtains the corresponding action type of the change operation note；
Operation acquisition module, for obtaining default change operation corresponding with the action type；
Collection module, for when it is described change operation note in comprising it is described it is default change operation, then obtain with comprising
Change operation matching collection template, and new statistical information is collected according to the collection template.
Wherein in one embodiment, the action type includes table handling；
The collection module, including：
Newly-built table collector unit, for being grasped comprising newly-built table when in the change operation note that the action type is table handling
Make, then judge comprising the newly-built table handling change operation note in whether carry out data initialization, if carrying out, collect with
The new statistical information of the corresponding tables of data of the newly-built table handling；
And/or
Table structure redefines collector unit, for when the action type for the change operation note of table handling in comprising deleting
Except all row operations of table or table structure redefine operation online, then back up online with all row operations of the deletion table or table structure
The old statistical information of the tables of data of operation association is redefined, and collection is weighed online with all rows operations of the deletion table or table structure
The new statistical information of the tables of data of defining operation association.
Wherein in one embodiment, the action type includes table handling；
The collection module, including：
Table structure change collector unit, if for the action type for table handling change operation note in include table knot
Structure change operation, then judge whether the table structure change operation is field change operation；If the table structure change operation is
Field change operation, then back up the old statistical information that the corresponding tables of data of operation is changed with the field, and collect and the word
Duan Biangeng operates the new statistical information of corresponding tables of data；If the table structure change operation is table division operation, when the table
Division operation is newly-increased division operation, then the new statistical information of the subregion associated with the newly-increased division operation is collected, when described
Table division operation is then backed up and merges division operation or fractionation division operation with described to merge division operation or splitting division operation
The old statistical information of the subregion of association, and collect with the merging division operation or split the new system of the subregion that division operation is associated
Meter information.
Wherein in one embodiment, described device also includes：
Determining module, for true for the change included in the change operation note of table handling is operated according to the action type
Determine DML objects；
Judge module, for judging that the DML quantity for belonging to the DML objects is according to the file of record DML implementation status
It is no to reach default value；
Module is enabled, if reaching institute for belonging to the DML quantity of the DML objects in the databases comparison peration data
Default value is stated, is then judged whether to enable new statistical information according to default configuration item, if so, then enabling the new statistics letter of collection
Breath, if it is not, then recovering the old statistical information of backup.
Wherein in one embodiment, the action type includes index operation；
The collection module, including：
Collector unit newly is indexed, if newly-built to be included in the change operation note of index operation for the action type
Index operation, then collect the new statistical information of index corresponding with the newly-built index operation；
And/or
Index collector unit is rebuild, if being rebuild to be included in the change operation note of index operation for the action type
Index operation, then back up the old statistical information of index corresponding with the reconstruction index operation, and collects and the reconstruction index
After operating the new statistical information of corresponding index, recover the old statistical information.
Above-mentioned statistical information collection method and device, by analyzing the change operation note for obtaining, obtain change operation note
Record corresponding action type, when change operation note in comprising it is default it is corresponding with action type change operation, then basis with
Comprising the collection template of change operation matching collect new statistical information, be directed to corresponding from different action types different
Change operation, can collect new statistical information according to the collection template of different matchings, refine the collection mode of statistical information, energy
Effectively improve the accuracy of the statistical information of collection.Additionally, DBA can be directed to not according to different business demands
Same change operation is formulated different collection templates and is collected, and improves the flexibility for formulating statistical information collection mode.
Brief description of the drawings
Fig. 1 is the internal structure schematic diagram of server in one embodiment；
Fig. 2 is the schematic flow sheet of statistical information collection method in one embodiment；
Fig. 3 be one embodiment in when change operation note in comprising it is default change operation, then obtain with comprising change
The collection template of matching is more operated, and the schematic flow sheet of new statistical information is collected according to collection template；
Fig. 4 be another embodiment in when change operation note in comprising it is default change operation, then obtain with comprising
The collection template of change operation matching, and the schematic flow sheet of new statistical information is collected according to collection template；
Fig. 5 be one embodiment in judge whether to enable the schematic flow sheet of new statistical information；
Fig. 6 be another embodiment in when change operation note in comprising it is default change operation, then obtain with comprising
The collection template of change operation matching, and the schematic flow sheet of new statistical information is collected according to collection template；
Fig. 7 is the structural representation of statistics gatherer means in one embodiment；
Fig. 8 is the internal structure schematic diagram of collection module in one embodiment；
Fig. 9 is the structural representation of statistics gatherer means in another embodiment；
Figure 10 is the internal structure schematic diagram of collection module in another embodiment.
Specific embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the present invention, not
For limiting the present invention.
Fig. 1 is the internal structure schematic diagram of server in one embodiment.As shown in figure 1, the server is included by being
Processor, non-volatile memory medium, built-in storage and network interface that system bus is connected.Wherein, the server is non-volatile
Property storage medium be stored with operating system, database and statistics gatherer means, the statistics of database that is stored with database letter
Breath, the statistics gatherer means are used to realize a kind of statistical information collection method suitable for server.The place of the server
Reason device is used to provide calculating and control ability, supports the operation of whole server.The built-in storage of the server is non-volatile
The operation of the statistics gatherer means in storage medium provides environment, computer-readable can be stored in the built-in storage and is referred to
Order, when the computer-readable instruction is by the computing device, may be such that the computing device statistical information collection method.Should
The network interface of server is used to be communicated by network connection with outside terminal according to this, such as the data that receiving terminal sends are looked into
Ask request etc..Server can with independent server or multiple server groups into server cluster realize.Ability
Field technique personnel are appreciated that the structure shown in Fig. 1, only the block diagram of the part-structure related to application scheme, and
Do not constitute the restriction of the server being applied thereon to application scheme, specific server can include than shown in figure more
Many or less parts, or some parts are combined, or arranged with different parts.
As shown in Figure 2, there is provided a kind of statistical information collection method, comprise the following steps：
Step S210, obtains change operation note.
Specifically, the operation of change each time that change operation note is used in database of record, changes operation and refers to
The operation that the statistical information of database can be made to change, for example, newly-built table handling, newly-built index operation, newly-increased division operation
Operated etc. the change belonged in database.Include the SQL statement of execution, operating time, operation in change operation note
The information such as tables of data, user.
Before step S210 obtains change operation note, also include：Become according to default acquisition mode acquisition database
More peration data.
Specifically, server can acquisition database change be grasped from the journal file of database according to default acquisition mode
Make data, one or more change operation note is included in databases comparison peration data.For example, can every Preset Time from
In journal file acquisition database change peration data, or according to user list collection journal file in the user list in
ID association tables of data, index etc. databases comparison peration data, but not limited to this.
Step S220, analysis change operation note obtains the corresponding action type of change operation note.
Specifically, change operation note can be obtained from the databases comparison peration data of collection, and to change operation note
Record is analyzed, and the corresponding action type of change operation note is judged according to default character string, and action type may include that table is grasped
Work, index operation etc., for example, whether " table " character string is included in detectable change operation note, if comprising, it is believed that
Whether it is table handling, can detect and include " index " character string in change operation note, if comprising being regarded as index operation
Deng, however it is not limited to this.
Step S230, obtains default change operation corresponding with action type.
Specifically, predeterminable set the corresponding change operation of different action types, for example, action type is table handling,
Corresponding default change operation may include that all row operations of newly-built table handling, deletion table, table structure redefine behaviour online
Make, field changes operation etc., action type is index operation, corresponding default change operation may include newly to index behaviour
Make and rebuild index operation etc..
Step S240, when change operation note in comprising it is default change operation, then obtain with comprising change operation
The collection template matched somebody with somebody, and collect new statistical information according to template is collected.
Specifically, default change operation corresponding with the action type of change operation note can be obtained, and detect change
Whether comprising default change operation corresponding with action type, different change operations may correspond to different receipts for operation note
Collection template, often set collect template formulated it is a set of collection statistical information specific rules flow, can according to change operation note
In include change operation matching collection template, collect database perform change operation after related tables of data or index
New statistical information.DBA can pre-establish and collect template from the statistical information of different change operation matchings, can
After flexibly formulation database performs each change operation, different statistical information collection modes.In other embodiments, service
Device can also set up a plurality of collection thread, make each bar collect thread respectively according to the change operation that includes in change operation note
The collection template matched somebody with somebody collects new statistical information, and statistical information can be collected by the way of parallel processing, improves collection efficiency.
Above-mentioned statistical information collection method, by analyzing the change operation note for obtaining, obtains change operation note correspondence
Action type, when change operation note in comprising it is default it is corresponding with action type change operation, then basis with comprising
The collection template of change operation matching collects new statistical information, is directed to different change behaviour corresponding from different action types
Make, new statistical information can be collected according to the collection template of different matchings, refined the collection mode of statistical information, can effectively carry
The accuracy of the statistical information that height is collected.Additionally, DBA can be directed to different changes according to different business demands
More operation is formulated different collection templates and is collected, and improves the flexibility for formulating statistical information collection mode.
As shown in figure 3, in one embodiment, step S240 is operated in operation note is changed comprising default change,
Then obtain with comprising the change collection template that match of operation, and according to the collection template new statistical information of collection, it may include below
Step：
Step S302, newly-built table handling is included in action type is for the change operation note of table handling, then judge to include
Whether data initialization is carried out in the change operation note of newly-built table handling, if so, step S304 is then performed, if it is not, then performing
Step S306.
Specifically, with action type be table handling it is corresponding it is default change operation may include newly-built table handling.Newly-built table
Operation, creates a new tables of data as in database, can be according to action type in the change operation note of table handling
Whether the SQL statement of execution, detect in the change operation note comprising newly-built table handling, if comprising determining whether to perform
Whether data initialization is carried out after newly-built table handling, and data initialization is mainly used for initializing the parameters of newly-built table, can
Size, owning user, foreign key relationship including table etc..
Step S304, collects the new statistical information of tables of data corresponding with newly-built table handling.
If specifically, being also carried out data initialization after performing newly-built table handling, illustrating to newly-built tables of data
Parameters are set, and can be used Cascade (cascade is deleted) to collect the new statistical information of newly-built tables of data, specifically may be used
Line numbers, block number, average often capable size including newly-built tables of data etc., new statistical information is collected using Cascade, i.e., can be right
The statistical information of column and row and index in tables of data etc. is collected.
Step S306, does not deal with.
In one embodiment, step S240 is then obtained and bag when being operated comprising default change in change operation note
The collection template of the change operation matching for containing, and collect new statistical information according to template is collected, it may include：When action type is table
Operation is redefined online comprising all row operations of deletion table or table structure in the change operation note of operation, then backup and deletion table
All row operations or table structure redefine the old statistical information of the tables of data of operation association online, and collect and delete all rows of table
Operation or table structure redefine the new statistical information of the tables of data of operation association online.
Specifically, with action type be the corresponding default change operation of table handling may include the operation of deletion table all rows and
Table structure redefines operation online.All row operation (truncate table) operations of table are deleted, it is as quick to delete tables of data
In all record datas, but retention data table structure.Table structure, generally refers to field, type, the master in tables of data
The base attributes such as key, external key, table structure redefines refer to not influenceed during table structure is redefined the database make online
User, database user still can enter the operation such as line access, newly-increased, modification, deletion.Can be table handling according to action type
Change operation note in the SQL statement that performs, detect in the change operation note whether comprising all rows operations of deletion table or
Table structure redefines operation online, if comprising backup redefines operation and close online with all row operations of deletion table or table structure
The old statistical information of the tables of data of connection, i.e. backup storage perform all row operations of deletion table or table structure redefines operation online
Before, the statistical information of tables of data, when old statistical information is needed to use, can directly be called.After the completion of backup, can be used
Cascade collects all rows operations of execution deletion table or table structure is redefined after operating online, the new system of the database of association
Meter information.
In the present embodiment, it is the corresponding different change operation of table handling to be directed to from action type, there is different systems
Meter information mode, has refined the collection mode of statistical information, can effectively improve the accuracy of the statistical information of collection.
As shown in figure 4, in one embodiment, step S240 is operated in operation note is changed comprising default change,
Then obtain with comprising the change collection template that match of operation, and according to the collection template new statistical information of collection, it may include below
Step：
Step S402, if action type judges to change operation comprising table structure in the change operation note of table handling
Whether table structure change operation is field change operation, if so, step S404 is then performed, if it is not, then performing step S406.
Specifically, with action type be table handling it is corresponding it is default change operation may include table structure change operation.Table
Structure change operation, the operation such as refers to table structure is increased newly, deleted and change, can be table handling according to action type
Whether the SQL statement performed in change operation note, detect to be changed comprising table structure in the change operation note and operate, if bag
Contain, then can further detect whether the table structure for including change operation is field change operation, field change operation may include newly
Increase field, delete field and change field etc..
The old statistical information of the corresponding tables of data of operation is changed in step S404, backup with field, and is collected and field change
Operate the new statistical information of corresponding tables of data.
If specifically, change operation note in include table structure change operation for field change operation, can back up with
The corresponding tables of data of field change operation, the old statistical information before execution field change operation, and collected using Cascade
Perform the new statistical information after field change operation.
Step S406, if the change operation of table structure is table division operation, judges whether table division operation is newly-increased subregion behaviour
Make, if so, step S408 is then performed, if it is not, then performing step S410.
If specifically, change operation note in include table structure change operation be not field change operation, can be further
Detect whether table structure change operation that this includes is table division operation, table division operation may include newly-increased subregion, merge subregion,
Delete subregion, partition table is converted into common table, and common table is converted into the operation such as partition table.
Step S408, the new statistical information of the subregion that collection is associated with newly-increased division operation.
Specifically, multiple subregions can be included in tables of data, again can be comprising multiple data blocks, when change is grasped under each subregion
The table division operation included in noting down is newly-increased division operation, then collect the new statistical information of newly-increased subregion, it may include should
The information such as line number, block number, the average often capable size of newly-increased piecemeal.
Step S410, judges whether table division operation is to merge division operation or split division operation, if so, then performing step
Rapid S412, if it is not, then performing step S414.
Step S412, the old statistical information of the subregion that backup is associated with merging division operation or fractionation division operation, and receive
Collect and merge division operation or split the new statistical information of the subregion that division operation is associated.
If specifically, in change operation note the table division operation that includes to merge division operation or splitting division operation,
Storage can first be backed up and merged division operation or split the subregion for associating of division operation, division operation or fractionation are merged performing
Old statistical information before division operation, regathers the new statistics letter for performing and merging after division operation or fractionation division operation
Breath.
Step S414, does not deal with.
In the present embodiment, different table structure change operations are directed to, there are different statistical information collection modes, optimized
The statistical information collection mode of partition table, has refined the collection mode for having arrived statistical information significantly, can effectively improve collection
The accuracy of statistical information.
As shown in figure 5, in one embodiment, being grasped comprising default change in operation note is changed in step S240
Make, then obtain with comprising the change collection template that match of operation, and according to the collection template new statistical information of collection after, also wrap
Include following steps：
Step S502, according to action type for the change operation included in the change operation note of table handling determines DML couples
As.
Specifically, DML (Data Manipulation Language, DML) is one of classification of SQL, its
Mainly include select (selection), update (renewal), insert (insertion), four kinds of grammers of delete (deletion).DML objects refer to
Be class belonging to the DML for performing, database can record the implementation status of the DML of each tables of data, and server can root
According to the execution of DML object acquisition DML corresponding with the change operation included in the change operation note that action type is table handling
Amount, so that it is determined that the data variation amount of DML objects.If for example, change operation changes operation, corresponding DML objects for field
It is to change DML with the field in the field change corresponding tables of data of operation, it is corresponding if change operation is to shrink table handling
DML objects are all execution DML of Database Systems file, if change operation is not belonging to newly-built table handling or table structure change behaviour
Make, then corresponding DML corresponds to all execution DML of database work file.
Step S504, it is pre- that the file according to record DML implementation status judges whether the DML quantity for belonging to DML objects reaches
If numerical value, if so, step S508 is then performed, if it is not, then performing step S506.
Specifically, determining that with action type be the corresponding DML of change operation included in the change operation note of table handling
After object, can be obtained from the file of record DML implementation status and belong to the DML quantity of the DML objects, when belonging to the DML objects
DML quantity reach default value, then can determine whether to enable the new statistical information of collection.For example, being wrapped in change operation note
Changed containing field and operated, its corresponding DML object is to change DML with the field in the field change corresponding tables of data of operation, then
Can be obtained from the file of record DML implementation status with the field change corresponding tables of data of operation in Preset Time, field becomes
The quantity of more DML, and judge whether to reach 10%, wherein, Preset Time and acquisition database change peration data it is default when
Between it is consistent.
In other embodiments, not comprising default change behaviour corresponding with action type in operation note is changed
Make, judging whether to statistical information also dependent on the DML quantity for performing collects, the DML of the execution according to record, it may be determined that number
According to the data situation of table, useful data foundation is provided for the collection of statistical information updates.
Step S506, does not deal with.
Step S508, judges whether to enable new statistical information according to default configuration item, if so, step S510 is then performed,
If it is not, then performing step S512.
Specifically, default configuration item may include database version number, memory parameters, CPU (Central Processing
Unit, central processing unit) parameter, I/O (input/output) loading condition etc., influence point can be carried out according to default configuration item
Analysis, judges whether new statistical information can cause performance impact to database, if obtaining new statistical information pair after carrying out impact analysis
The performance impact of database is smaller, then can enable new statistical information, if obtaining new statistical information after carrying out impact analysis to data
The performance impact in storehouse is larger, then do not enable new statistical information, can import the old statistical information of backup, database is still used old
Statistical information calculates the executive plan for determining SQL.
Step S510, enables the new statistical information of collection.
Step S512, recovers the old statistical information of backup.
In the present embodiment, impact analysis can be carried out according to default configuration item, judges whether to enable new statistical information, subtracted
Few new statistical information is impacted to the performance of whole database, can effectively ensure that the stability of database.
As shown in fig. 6, in one embodiment, step S240 is operated in operation note is changed comprising default change,
Then obtain with comprising the change collection template that match of operation, and according to the collection template new statistical information of collection, including step
S602 and/or step S604.
Step S602, if action type is collected to include newly-built index operation in the change operation note of index operation
The new statistical information of index corresponding with newly-built index operation.
Specifically, index is a kind of structure being ranked up to the value of one or more columns per page in database table, can using index
The quick customizing messages accessed in database table.With action type be index operation it is corresponding it is default change operation may include newly
Index operation.Newly-built index operation, i.e., create a new index in tables of data, can be index operation according to action type
Change operation note in the SQL statement that performs, detect whether comprising newly-built index operation in the change operation note, if bag
Contain, then can collect the new statistical information of newly-built index, specifically may include root block number, the line number of index field of newly-built index
And maximum, the minimum value of index etc..
Step S604, if action type rebuilds index operation to be included in the change operation note of index operation, backs up
The old statistical information of index corresponding with index operation is rebuild, and collect the new statistics letter of index corresponding with index operation is rebuild
After breath, recover old statistical information.
Specifically, with action type be index operation it is corresponding it is default change operation may include rebuild index operation, when
The structure of one index there occurs deviation, cause to incline, and so as to cause space waste when data query is carried out, then can perform weight
Operation is indexed to rebuild index.It is to rebuild index operation to be with the difference of newly-built index operation to rebuild index operation
Rebuild (rebuild) on the basis of original index, and newly-built index operation is then directly to create (create)
Individual new index.Can be the SQL statement of execution in the change operation note of index operation according to action type, detect that the change is grasped
Whether comprising index operation is rebuild in noting down, if comprising can back up needs the index rebuild performing reconstruction index
Old statistical information before operation, and the new statistical information of the index after rebuilding is collected, after being backed up to new statistical information, can
The old statistical information backed up before importing, it is ensured that the stability after index reconstruction.
In the present embodiment, it is the corresponding different change operation of index operation to be directed to from action type, there is different
Statistical information collection mode, has refined the collection mode of statistical information, can effectively improve the accuracy of the statistical information of collection.
As shown in Figure 7, there is provided a kind of statistics gatherer means, including record acquisition module 710, analysis module 720, behaviour
Make acquisition module 730 and collection module 740.
Record acquisition module 710, for obtaining change operation note.
Specifically, the operation of change each time that change operation note is used in database of record, changes operation and refers to
The operation that the statistical information of database can be made to change, for example, newly-built table handling, newly-built index operation, newly-increased division operation
Operated etc. the change belonged in database.Include the SQL statement of execution, operating time, operation in change operation note
The information such as tables of data, user.
Record acquisition module 710, is additionally operable to change peration data according to default acquisition mode acquisition database.
Specifically, server can acquisition database change be grasped from the journal file of database according to default acquisition mode
Make data, one or more change operation note is included in databases comparison peration data.For example, can every Preset Time from
In journal file acquisition database change peration data, or according to user list collection journal file in the user list in
ID association tables of data, index etc. databases comparison peration data, but not limited to this.
Analysis module 720, for analyzing change operation note, obtains the corresponding action type of change operation note.
Specifically, change operation note can be obtained from the databases comparison peration data of collection, and to change operation note
Record is analyzed, and the corresponding action type of change operation note is judged according to default character string, and action type may include that table is grasped
Work, index operation etc., for example, whether " table " character string is included in detectable change operation note, if comprising, it is believed that
Whether it is table handling, can detect and include " index " character string in change operation note, if comprising being regarded as index operation
Deng, however it is not limited to this.
Operation acquisition module 730, for obtaining default change operation corresponding with action type.
Specifically, predeterminable set the corresponding change operation of different action types, for example, action type is table handling,
Corresponding default change operation may include that all row operations of newly-built table handling, deletion table, table structure redefine behaviour online
Make, field changes operation etc., action type is index operation, corresponding default change operation may include newly to index behaviour
Make and rebuild index operation etc..
Collection module 740, for when change operation note in comprising it is described it is default change operation, then obtain with comprising
The collection template of change operation matching, and collect new statistical information according to template is collected.
Specifically, default change operation corresponding with the action type of change operation note can be obtained, and detect change
Whether comprising default change operation corresponding with action type, different change operations may correspond to different receipts for operation note
Collection template, often set collect template formulated it is a set of collection statistical information specific rules flow, can according to change operation note
In include change operation matching collection template, collect database perform change operation after related tables of data or index
New statistical information.DBA can pre-establish and collect template from the statistical information of different change operation matchings, can
After flexibly formulation database performs each change operation, different statistical information collection modes.In other embodiments, service
Device can also set up a plurality of collection thread, make each bar collect thread respectively according to the change operation that includes in change operation note
The collection template matched somebody with somebody collects new statistical information, and statistical information can be collected by the way of parallel processing, improves collection efficiency.
Above-mentioned statistics gatherer means, by analyzing the change operation note for obtaining, obtain change operation note correspondence
Action type, when change operation note in comprising it is default it is corresponding with action type change operation, then basis with comprising
The collection template of change operation matching collects new statistical information, is directed to different change behaviour corresponding from different action types
Make, new statistical information can be collected according to the collection template of different matchings, refined the collection mode of statistical information, can effectively carry
The accuracy of the statistical information that height is collected.Additionally, DBA can be directed to different changes according to different business demands
More operation is formulated different collection templates and is collected, and improves the flexibility for formulating statistical information collection mode.
As shown in figure 8, in one embodiment, collection module 740 includes that newly-built table collects single 742 and/or with structure weight
Define collector unit 744 and/or table structure change collector unit 746.
Newly-built table collects single 742, for when action type for the change operation note of table handling in include newly-built table handling,
Then judge whether carry out data initialization in the change operation note comprising newly-built table handling, if carrying out, collect and newly-built table
Operate the new statistical information of corresponding tables of data.
Specifically, with action type be table handling it is corresponding it is default change operation may include newly-built table handling.Newly-built table
Operation, creates a new tables of data as in database, can be according to action type in the change operation note of table handling
Whether the SQL statement of execution, detect in the change operation note comprising newly-built table handling, if comprising determining whether to perform
Whether data initialization is carried out after newly-built table handling, and data initialization is mainly used for initializing the parameters of newly-built table, can
Size, owning user, foreign key relationship including table etc..If being also carried out data initialization after performing newly-built table handling, illustrate
The parameters to newly-built tables of data are set, can be used Cascade to collect the new statistics letter of newly-built tables of data
Breath, specifically may include line number, block number, average often capable size of newly-built tables of data etc., and new statistics letter is collected using Cascade
Breath, i.e., can be collected to the statistical information of the column and row and index in tables of data etc..
Table structure redefines collector unit 744, for when action type for the change operation note of table handling in comprising deleting
Except all row operations of table or table structure redefine operation online, then backup resets online with all row operations of deletion table or table structure
The old statistical information of the tables of data of justice operation association, and collection redefines operation online with all row operations of deletion table or table structure
The new statistical information of the tables of data of association.
Specifically, with action type be the corresponding default change operation of table handling may include the operation of deletion table all rows and
Table structure redefines operation online.All row operation (truncate table) operations of table are deleted, it is as quick to delete tables of data
In all record datas, but retention data table structure.Table structure, generally refers to field, type, the master in tables of data
The base attributes such as key, external key, table structure redefines refer to not influenceed during table structure is redefined the database make online
User, database user still can enter the operation such as line access, newly-increased, modification, deletion.Can be table handling according to action type
Change operation note in the SQL statement that performs, detect in the change operation note whether comprising all rows operations of deletion table or
Table structure redefines operation online, if comprising backup redefines operation and close online with all row operations of deletion table or table structure
The old statistical information of the tables of data of connection, i.e. backup storage perform all row operations of deletion table or table structure redefines operation online
Before, the statistical information of tables of data, when old statistical information is needed to use, can directly be called.After the completion of backup, can be used
Cascade collects all rows operations of execution deletion table or table structure is redefined after operating online, the new system of the database of association
Meter information.
Table structure change collector unit 746, if for action type for table handling change operation note in include table knot
Structure change operation, then judge whether table structure change operation is field change operation；If the change operation of table structure is field change
Operation, then the old statistical information of the corresponding tables of data of operation is changed in backup with field, and collects corresponding with field change operation
The new statistical information of tables of data；If the change operation of table structure is table division operation, when table division operation is newly-increased division operation, then
The new statistical information of the subregion that collection is associated with newly-increased division operation, when table division operation is for merging division operation or splits subregion
Operation, then backup with merge division operation or split the old statistical information of subregion that division operation is associated, and collection with merge point
Area operates or splits the new statistical information of the subregion of division operation association.
Specifically, with action type be table handling it is corresponding it is default change operation may include table structure change operation.Table
Structure change operation, the operation such as refers to table structure is increased newly, deleted and change, can be table handling according to action type
Whether the SQL statement performed in change operation note, detect to be changed comprising table structure in the change operation note and operate, if bag
Contain, then can further detect whether the table structure for including change operation is field change operation, field change operation may include newly
Increase field, delete field and change field etc..
If the table structure change operation included in change operation note can be backed up and changed with field for field changes operation
Corresponding tables of data is operated, the old statistical information before execution field change operation, and collect execution field using Cascade
New statistical information after change operation.
If the table structure change operation included in change operation note is not field change operation, the bag can be further detected
Whether the table structure change operation for containing is table division operation, and table division operation may include newly-increased subregion, merge subregion, deletion point
Area, partition table is converted into common table, and common table is converted into the operation such as partition table.Multiple points can be included in tables of data
Area, again can be comprising multiple data blocks under each subregion, and the table division operation included in operation note is changed is newly-increased subregion behaviour
Make, then collect the new statistical information of newly-increased subregion, it may include the line number of the newly-increased piecemeal, block number, average often capable size
Etc. information.If the table division operation included in change operation note can be backed up first to merge division operation or splitting division operation
Store and and merge division operation or split the subregion for associating of division operation, performing merging division operation or splitting division operation
Old statistical information before, regathers the new statistical information for performing and merging after division operation or fractionation division operation, optimizes
The statistical information collection mode of partition table.
In the present embodiment, it is the corresponding different change operation of table handling to be directed to from action type, there is different systems
Meter information mode, has refined the collection mode of statistical information, can effectively improve the accuracy of the statistical information of collection.
As shown in figure 9, in one embodiment, above-mentioned statistics gatherer means, except including record acquisition module
710th, analysis module 720, operation acquisition module 730 and collection module 740, also including determining module 750, judge module 760 and
Enable module 770.
Determining module 750, for true for the change included in the change operation note of table handling is operated according to action type
Determine DML objects.
Specifically, DML is one of classification of SQL, it mainly includes select (selection), update (renewal), insert
(insertion), four kinds of grammers of delete (deletion).DML objects refer to the class belonging to the DML of execution, and database can record
The implementation status of the DML of each tables of data, server can according to action type for table handling change operation note in include
The corresponding DML object acquisitions DML of change operation execution amount, so that it is determined that the data variation amount of DML objects.If for example, becoming
More operation changes operation for field, then corresponding DML objects are to be changed with the field in the field change corresponding tables of data of operation
DML, if change operation is to shrink table handling, corresponding DML objects are all execution DML of Database Systems file, if becoming
More operation is not belonging to newly-built table handling or the change operation of table structure, then corresponding DML corresponds to all of database work file
Perform DML.
Judge module 760, for according to record DML implementation status file judge belong to DML objects DML quantity whether
Reach default value.
Specifically, determining that with action type be the corresponding DML of change operation included in the change operation note of table handling
After object, can be obtained from the file of record DML implementation status and belong to the DML quantity of the DML objects, when belonging to the DML objects
DML quantity reach default value, then can determine whether to enable the new statistical information of collection.For example, being wrapped in change operation note
Changed containing field and operated, its corresponding DML object is to change DML with the field in the field change corresponding tables of data of operation, then
Can be obtained from the file of record DML implementation status with the field change corresponding tables of data of operation in Preset Time, field becomes
The quantity of more DML, and judge whether to reach 10%, wherein, Preset Time and acquisition database change peration data it is default when
Between it is consistent.
In other embodiments, not comprising default change behaviour corresponding with action type in operation note is changed
Make, judging whether to statistical information also dependent on the DML quantity for performing collects, the DML of the execution according to record, it may be determined that number
According to the data situation of table, useful data foundation is provided for the collection of statistical information updates.
Module 770 is enabled, if reaching institute for belonging to the DML quantity of the DML objects in databases comparison peration data
Default value is stated, is then judged whether to enable new statistical information according to default configuration item, if so, then enabling the new statistics letter of collection
Breath, if it is not, then recovering the old statistical information of backup.
Specifically, default configuration item may include database version number, memory parameters, CPU parameters, I/O loading conditions etc.,
Impact analysis can be carried out according to default configuration item, judge whether new statistical information can cause performance impact to database, if entering
The performance impact that new statistical information is obtained after row impact analysis to database is smaller, then can enable new statistical information, if carrying out shadow
New statistical information is obtained after sound analysis larger to the performance impact of database, then do not enable new statistical information, backup can be imported
Old statistical information, makes database that the executive plan for determining SQL is still calculated using old statistical information.
In the present embodiment, impact analysis can be carried out according to default configuration item, judges whether to enable new statistical information, subtracted
Few new statistical information is impacted to the performance of whole database, can effectively ensure that the stability of database.
As shown in Figure 10, in one embodiment, collection module 740 includes newly indexing collector unit 741 and/or rebuilds
Index collector unit 743.
Collector unit 741 newly is indexed, if newly-built to be included in the change operation note of index operation for action type
Index operation, then collect the new statistical information of index corresponding with newly-built index operation.
Specifically, index is a kind of structure being ranked up to the value of one or more columns per page in database table, can using index
The quick customizing messages accessed in database table.With action type be index operation it is corresponding it is default change operation may include newly
Index operation.Newly-built index operation, i.e., create a new index in tables of data, can be index operation according to action type
Change operation note in the SQL statement that performs, detect whether comprising newly-built index operation in the change operation note, if bag
Contain, then can collect the new statistical information of newly-built index, specifically may include root block number, the line number of index field of newly-built index
And maximum, the minimum value of index etc..
Index collector unit 743 is rebuild, if being rebuild to be included in the change operation note of index operation for action type
Index operation, then back up the old statistical information of index corresponding with index operation is rebuild, and collects corresponding with index operation is rebuild
Index new statistical information after, recover old statistical information.
Specifically, with action type be index operation it is corresponding it is default change operation may include rebuild index operation, when
The structure of one index there occurs deviation, cause to incline, and so as to cause space waste when data query is carried out, then can perform weight
Operation is indexed to rebuild index.It is to rebuild index operation to be with the difference of newly-built index operation to rebuild index operation
Rebuild (rebuild) on the basis of original index, and newly-built index operation is then directly to create (create)
Individual new index.Can be the SQL statement of execution in the change operation note of index operation according to action type, detect that the change is grasped
Whether comprising index operation is rebuild in noting down, if comprising can back up needs the index rebuild performing reconstruction index
Old statistical information before operation, and the new statistical information of the index after rebuilding is collected, after being backed up to new statistical information, can
The old statistical information backed up before importing, it is ensured that the stability after index reconstruction.
In the present embodiment, it is the corresponding different change operation of index operation to be directed to from action type, there is different
Statistical information collection mode, has refined the collection mode of statistical information, can effectively improve the accuracy of the statistical information of collection.
One of ordinary skill in the art will appreciate that all or part of flow in realizing above-described embodiment method, can be
The hardware of correlation is instructed to complete by computer program, described program can be stored in a non-volatile computer and can read
In storage medium, the program is upon execution, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, described storage is situated between
Matter can be magnetic disc, CD, read-only memory (Read-Only Memory, ROM) etc..
Each technical characteristic of embodiment described above can be combined arbitrarily, to make description succinct, not to above-mentioned reality
Apply all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, the scope of this specification record is all considered to be.
Embodiment described above only expresses several embodiments of the invention, and its description is more specific and detailed, but simultaneously
Can not therefore be construed as limiting the scope of the patent.It should be pointed out that coming for one of ordinary skill in the art
Say, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to protection of the invention
Scope.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (10)
1. a kind of statistical information collection method, including：
Obtain change operation note；
The change operation note is analyzed, the corresponding action type of the change operation note is obtained；
Obtain default change operation corresponding with the action type；
When comprising the default change operation, then obtained in the change operation note with comprising change operate the receipts that match
Collection template, and new statistical information is collected according to the collection template.
2. statistical information collection method according to claim 1, it is characterised in that the action type includes table handling；
It is described when it is described change operation note in comprising it is described it is default change operation, then obtain with comprising change operate match
Collection template, and new statistical information is collected according to the collection template, including：
Newly-built table handling is included in the action type is for the change operation note of table handling, then judges to include the newly-built table
Whether data initialization is carried out in the change operation note of operation, if carrying out, collect number corresponding with the newly-built table handling
According to the new statistical information of table；
And/or
Weighed online comprising all row operations of deletion table or table structure in the action type is for the change operation note of table handling
Defining operation, then back up the old system for redefining the tables of data that operation is associated online with all row operations of the deletion table or table structure
Meter information, and collect the new statistics for redefining the tables of data that operation is associated online with all row operations of the deletion table or table structure
Information.
3. statistical information collection method according to claim 1 and 2, it is characterised in that the action type includes table behaviour
Make；
It is described when it is described change operation note in comprising it is described it is default change operation, then obtain with comprising change operate match
Collection template, and new statistical information is collected according to the collection template, including：
If the action type judges the table structure to change operation comprising table structure in the change operation note of table handling
Whether change operation is field change operation；
If the table structure change operation is field change operation, back up and the field change corresponding tables of data of operation
Old statistical information, and collect the new statistical information that the corresponding tables of data of operation is changed with the field；
If table structure change operation is table division operation, when the table division operation is newly-increased division operation, then collect with
The new statistical information of the subregion of the newly-increased division operation association, when the table division operation divides to merge division operation or splitting
Area operates, then back up and the merging division operation or split the old statistical information of subregion that division operation associate, and collect and
The new statistical information of the subregion for merging division operation or splitting division operation association.
4. statistical information collection method according to claim 3, it is characterised in that described when the change operation note
In comprising the default change operation, then obtain with comprising change operate the collection template that matches, and according to the collection
After the step of template collects new statistical information, also include：
According to the action type for the change operation included in the change operation note of table handling determines DML objects；
File according to record DML implementation status judges whether the DML quantity for belonging to the DML objects reaches default value；
If reaching, judged whether to enable new statistical information according to default configuration item, if so, then enabling the new statistics letter of collection
Breath, if it is not, then recovering the old statistical information of backup.
5. statistical information collection method according to claim 1, it is characterised in that the action type includes that index is grasped
Make；
It is described when it is described change operation note in comprising it is described it is default change operation, then obtain with comprising change operate match
Collection template, and new statistical information is collected according to the collection template, including：
If the action type collects newly-built with described to include newly-built index operation in the change operation note of index operation
The new statistical information of the corresponding index of index operation；
And/or
If the action type rebuilds index operation to be included in the change operation note of index operation, back up and the reconstruction
The old statistical information of the corresponding index of index operation, and collect the new statistical information of index corresponding with the reconstruction index operation
Afterwards, the old statistical information is recovered.
6. a kind of statistics gatherer means, it is characterised in that including：
Record acquisition module, for obtaining change operation note；
Analysis module, for analyzing the change operation note, obtains the corresponding action type of the change operation note；
Operation acquisition module, for obtaining default change operation corresponding with the action type；
Collection module, for when it is described change operation note in comprising it is described it is default change operation, then obtain with comprising change
The collection template of matching is more operated, and new statistical information is collected according to the collection template.
7. statistics gatherer means according to claim 6, it is characterised in that the action type includes table handling；
The collection module, including：
Newly-built table collector unit, for when the action type for table handling change operation note in include newly-built table handling,
Then judge whether carry out data initialization in the change operation note comprising the newly-built table handling, if carrying out, collect and institute
State the new statistical information of the corresponding tables of data of newly-built table handling；
And/or
Table structure redefines collector unit, for when the action type for table handling change operation note in comprising delete table
All row operations or table structure redefine operation online, then back up and reset online with all row operations of the deletion table or table structure
The old statistical information of the tables of data of justice operation association, and collection is operated with all rows of the deletion table or table structure is redefined online
Operate the new statistical information of the tables of data of association.
8. statistics gatherer means according to claim 6 or 7, it is characterised in that the action type includes table behaviour
Make；
The collection module, including：
Table structure change collector unit, if for the action type for table handling change operation note in comprising table structure change
More operate, then judge whether the table structure change operation is field change operation；If the table structure change operation is field
Change operation, then back up the old statistical information that the corresponding tables of data of operation is changed with the field, and collect and field change
More operate the new statistical information of corresponding tables of data；If the table structure change operation is table division operation, when the table subregion
Operate to increase division operation newly, then collect the new statistical information of the subregion associated with the newly-increased division operation, when the table point
Area is operated to merge division operation or splitting division operation, then back up and associated with the merging division operation or fractionation division operation
Subregion old statistical information, and collect and described merge division operation or split the new statistics letter of the subregion that associate of division operation
Breath.
9. statistics gatherer means according to claim 8, it is characterised in that described device also includes：
Determining module, for being determined for the change included in the change operation note of table handling is operated according to the action type
DML objects；
Judge module, for judging whether the DML quantity for belonging to the DML objects reaches according to the file of record DML implementation status
To default value；
Enable module, if for belong in the databases comparison peration data DML quantity of the DML objects reach it is described pre-
If numerical value, then judged whether to enable new statistical information according to default configuration item, if so, the new statistical information of collection is then enabled,
If it is not, then recovering the old statistical information of backup.
10. statistics gatherer means according to claim 6, it is characterised in that the action type includes that index is grasped
Make；
The collection module, including：
Collector unit newly is indexed, if newly being indexed to be included in the change operation note of index operation for the action type
Operation, then collect the new statistical information of index corresponding with the newly-built index operation；
And/or
Index collector unit is rebuild, if being indexed to include to rebuild in the change operation note of index operation for the action type
Operation, then back up the old statistical information of index corresponding with the reconstruction index operation, and collects and the reconstruction index operation
After the new statistical information of corresponding index, recover the old statistical information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611003385.2A CN106776704B (en) | 2016-11-14 | 2016-11-14 | Statistical information collection method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611003385.2A CN106776704B (en) | 2016-11-14 | 2016-11-14 | Statistical information collection method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106776704A true CN106776704A (en) | 2017-05-31 |
| CN106776704B CN106776704B (en) | 2020-03-06 |
Family
ID=58968410
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611003385.2A Active CN106776704B (en) | 2016-11-14 | 2016-11-14 | Statistical information collection method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106776704B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108255925A (en) * | 2017-11-10 | 2018-07-06 | 平安普惠企业管理有限公司 | A kind of display methods and its terminal of data list structure alteration |
| CN109614398A (en) * | 2018-11-02 | 2019-04-12 | 阿里巴巴集团控股有限公司 | The variation and device of table structure in database |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739439A (en) * | 2009-11-30 | 2010-06-16 | 中兴通讯股份有限公司 | Method and system for dynamically customizing statistical object based on template |
| CN102346784A (en) * | 2011-11-14 | 2012-02-08 | 苏州阔地网络科技有限公司 | Database backup method and system |
| CN102480385A (en) * | 2010-11-26 | 2012-05-30 | 北京启明星辰信息技术股份有限公司 | Database security protection method and device |
| CN103345470A (en) * | 2013-05-31 | 2013-10-09 | 深圳市沃信科技有限公司 | Database disaster tolerance method, database disaster tolerance system and server |
| CN105069096A (en) * | 2015-08-06 | 2015-11-18 | 厦门二五八集团有限公司 | Architecture method and architecture system for user-defined worksheet |
| CN105069134A (en) * | 2015-08-18 | 2015-11-18 | 上海新炬网络信息技术有限公司 | Method for automatically collecting Oracle statistical information |
| CN105117457A (en) * | 2015-08-20 | 2015-12-02 | 中国人民解放军国防科学技术大学 | Index rebuilding method of fictitious asset preservation system |
-
2016
- 2016-11-14 CN CN201611003385.2A patent/CN106776704B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739439A (en) * | 2009-11-30 | 2010-06-16 | 中兴通讯股份有限公司 | Method and system for dynamically customizing statistical object based on template |
| CN102480385A (en) * | 2010-11-26 | 2012-05-30 | 北京启明星辰信息技术股份有限公司 | Database security protection method and device |
| CN102346784A (en) * | 2011-11-14 | 2012-02-08 | 苏州阔地网络科技有限公司 | Database backup method and system |
| CN103345470A (en) * | 2013-05-31 | 2013-10-09 | 深圳市沃信科技有限公司 | Database disaster tolerance method, database disaster tolerance system and server |
| CN105069096A (en) * | 2015-08-06 | 2015-11-18 | 厦门二五八集团有限公司 | Architecture method and architecture system for user-defined worksheet |
| CN105069134A (en) * | 2015-08-18 | 2015-11-18 | 上海新炬网络信息技术有限公司 | Method for automatically collecting Oracle statistical information |
| CN105117457A (en) * | 2015-08-20 | 2015-12-02 | 中国人民解放军国防科学技术大学 | Index rebuilding method of fictitious asset preservation system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108255925A (en) * | 2017-11-10 | 2018-07-06 | 平安普惠企业管理有限公司 | A kind of display methods and its terminal of data list structure alteration |
| CN108255925B (en) * | 2017-11-10 | 2021-12-10 | 平安普惠企业管理有限公司 | Method and terminal for displaying data table structure change condition |
| CN109614398A (en) * | 2018-11-02 | 2019-04-12 | 阿里巴巴集团控股有限公司 | The variation and device of table structure in database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106776704B (en) | 2020-03-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP3581831B2 (en) | Searching, tabulating and sorting methods and devices for tabular data | |
| CN110292775B (en) | Method and device for acquiring difference data | |
| JP6029951B2 (en) | Time series database setting automatic generation method, setting automatic generation system and monitoring server | |
| US7499944B2 (en) | Method and apparatus for processing a dimension table and deriving a hierarchy therefrom | |
| US10452625B2 (en) | Data lineage analysis | |
| EP3456360B1 (en) | Device and method for tuning relational database | |
| CN105022739B (en) | The storage method and device of data | |
| CN104424360A (en) | Method and system for accessing a set of data tables in a source database | |
| JP6242540B1 (en) | Data conversion system and data conversion method | |
| US4967348A (en) | Data name standardizing system | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| JP4383484B2 (en) | Message analysis apparatus, control method, and control program | |
| US11321359B2 (en) | Review and curation of record clustering changes at large scale | |
| CN106776704A (en) | Statistical information collection method and device | |
| JP6244274B2 (en) | Correlation rule analysis apparatus and correlation rule analysis method | |
| JP2013029891A (en) | Extraction program, extraction method and extraction apparatus | |
| CN117093556A (en) | Log classification method, device, computer equipment and computer readable storage medium | |
| RU2433467C1 (en) | Method of forming aggregated data structure and method of searching for data through aggregated data structure in data base management system | |
| Alapati et al. | Oracle Database 12c Performance Tuning Recipes: A Problem-Solution Approach | |
| JP2012212304A (en) | Retrieval result output device, retrieval result output control program, and retrieval result output method | |
| JP5332918B2 (en) | Classification data recommendation method, program, and apparatus | |
| US7818534B2 (en) | Determination of sampling characteristics based on available memory | |
| JP4767389B2 (en) | Logging device and recording medium | |
| US7996366B1 (en) | Method and system for identifying stale directories | |
| JP2020166443A (en) | Data processing method recommendation system, data processing method recommendation method, and data processing method recommendation program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |