CN106777147A - A kind of optimization method of spot database - Google Patents
A kind of optimization method of spot database Download PDFInfo
- Publication number
- CN106777147A CN106777147A CN201611179456.4A CN201611179456A CN106777147A CN 106777147 A CN106777147 A CN 106777147A CN 201611179456 A CN201611179456 A CN 201611179456A CN 106777147 A CN106777147 A CN 106777147A
- Authority
- CN
- China
- Prior art keywords
- optimization method
- data block
- preset value
- spot database
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
Abstract
The present invention relates to database technical field, more particularly to a kind of optimization method of spot database, including：Judge the size and frequency of use of the data block in spot database, when the size of all data blocks is more than second preset value less than the frequency of use of one first preset value and data block, query optimization is carried out to spot database；Above-mentioned technical scheme can be judged and be classified to the data block in spot database, and query optimization is carried out to field data according to judgement and classification situation, and then improve the stability and the speed of service of spot database.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of optimization method of spot database.
Background technology
Because a factory is increasingly automated, possessing numerous data bank needs management, and the data block stored in database is past
Toward a lot, such as many tables of data are stored, the workload that result in spot database is overweight.Due to existing spot database
It is called using functional module, view shows, the operation such as data storage, can take more processing resource, this is likely to result in number
There is exception according to storehouse, cause production line cisco unity malfunction.
The content of the invention
Regarding to the issue above, the present invention proposes a kind of optimization method of spot database, is wrapped in the spot database
Include multiple data blocks；Including：
The size and frequency of use of the data block in the spot database are judged, in the big of all data blocks
When being less than the frequency of use of one first preset value and the data block more than second preset value, to the spot database
Carry out query optimization.
Above-mentioned optimization method, wherein, also include：
Will determine that the frequency of use for obtaining is deleted less than or equal to the data block of second preset value.
Above-mentioned optimization method, wherein, also include：
One historical data base is provided, and the historical data base is connected with the spot database；
Will determine that the size for obtaining is transferred to the historical data more than or equal to the data block of first preset value
In storehouse.
Above-mentioned optimization method, wherein, the query optimization includes：
Calling for the view relevant with the data block is carried out by the way of distal end is called or is directly connected to call.
Above-mentioned optimization method, wherein, the view is the view of the data block of series connection.
Above-mentioned optimization method, wherein, the query optimization includes：
The data block is stored by the way of remote storage.
Above-mentioned optimization method, wherein, the query optimization includes：
Pair event related to the data block is triggered by the way of distal end is triggered.
Above-mentioned optimization method, wherein, the query optimization includes：
Data are sent into the spot database by the way of transmission or timed task transmission is directly connected to.
Above-mentioned optimization method, wherein, the storage time limit of the historical data base is set as one the 3rd preset value, in institute
The storage time for stating the data stored in historical data base is deleted when exceeding three preset value.
Beneficial effect：A kind of optimization method of spot database proposed by the present invention enters to the data block in spot database
Row judges and classifies, and query optimization is carried out to field data according to judgement and classification situation, and then improves spot database
Stability and the speed of service.
Brief description of the drawings
The step of Fig. 1 is the optimization method of spot database in one embodiment of the invention flow chart.
Specific embodiment
The present invention is further described with reference to the accompanying drawings and examples.
In a preferred embodiment, as shown in Figure 1, it is proposed that a kind of optimization method of spot database, live number
Include multiple data blocks according to storehouse, can include：
Judge the size and frequency of use of the data block in spot database, one first is less than in the size of all data blocks
When the frequency of use of preset value and data block is more than second preset value, query optimization is carried out to spot database.
Specifically, data block can be tables of data, and the first preset value can be such as 1 gigabyte, or such as 100
The corresponding size of data of tables of data of ten thousand rows；Second preset value can be 1 times/year, but this is a kind of preferred situation, should not
It is considered as limitation of the present invention.
In a preferred embodiment, can also include：
Will determine that the frequency of use for obtaining is deleted less than or equal to the data block of the second preset value.
In a preferred embodiment, also include：
One historical data base is provided, and historical data base is connected with spot database；
Will determine that the size for obtaining is transferred in historical data base more than or equal to the data block of the first preset value.
In a preferred embodiment, query optimization includes：
Calling for the view relevant with data block is carried out by the way of distal end is called or is directly connected to call.
In a preferred embodiment, view is the view of the data block of series connection.
In a preferred embodiment, query optimization includes：
Data block is stored by the way of remote storage.
In a preferred embodiment, query optimization includes：
Pair event related to data block is triggered by the way of distal end is triggered.
In a preferred embodiment, query optimization includes：
Data are sent into spot database by the way of transmission or timed task transmission is directly connected to.
In above-described embodiment, it is preferable that are set as into one the 3rd preset value, in history number the storage time limit of historical data base
Deleted during according to the storage time of the data stored in storehouse more than three preset values, such as the number for storage time being exceeded 3 years
According to being deleted.
In sum, a kind of optimization method of spot database proposed by the present invention enters to the data block in spot database
Row judges and classifies, and query optimization is carried out to field data according to judgement and classification situation, and then improves spot database
Stability and the speed of service.
By explanation and accompanying drawing, the exemplary embodiments of the ad hoc structure of specific embodiment are given, based on essence of the invention
God, can also make other conversions.Although foregoing invention proposes existing preferred embodiment, however, these contents are not intended as
Limitation.
For a person skilled in the art, after reading described above, various changes and modifications undoubtedly will be evident that.
Therefore, appending claims should regard the whole variations and modifications for covering true intention of the invention and scope as.In power
Any and all scope and content of equal value, are all considered as still belonging to the intent and scope of the invention in the range of sharp claim.
Claims (9)
1. a kind of optimization method of spot database, the spot database includes multiple data blocks；Characterized in that, bag
Include：
The size and frequency of use of the data block in the spot database are judged, in the total size of all data blocks
Less than one first preset value and data block described at least one frequency of use be more than second preset value when, to the scene
Database carries out query optimization.
2. optimization method according to claim 1, it is characterised in that also include：
Will determine that the frequency of use for obtaining is deleted less than or equal to the data block of second preset value.
3. optimization method according to claim 1, it is characterised in that also include：
One historical data base is provided, and the historical data base is connected with the spot database；
Will determine that the size for obtaining is transferred in the historical data base more than or equal to the data block of first preset value.
4. optimization method according to claim 1, it is characterised in that the query optimization includes：
Calling for the view relevant with the data block is carried out by the way of distal end is called or is directly connected to call.
5. optimization method according to claim 4, it is characterised in that the view is regarding for the data block of series connection
Figure.
6. optimization method according to claim 1, it is characterised in that the query optimization includes：
The data block is stored by the way of remote storage.
7. optimization method according to claim 1, it is characterised in that the query optimization includes：
Pair event related to the data block is triggered by the way of distal end is triggered.
8. optimization method according to claim 1, it is characterised in that the query optimization includes：
Data are sent into the spot database by the way of transmission or timed task transmission is directly connected to.
9. optimization method according to claim 3, it is characterised in that be set as the storage time limit of the historical data base
One the 3rd preset value, the storage time of the data stored in the historical data base is deleted when exceeding three preset value
Remove.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611179456.4A CN106777147A (en) | 2016-12-19 | 2016-12-19 | A kind of optimization method of spot database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611179456.4A CN106777147A (en) | 2016-12-19 | 2016-12-19 | A kind of optimization method of spot database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106777147A true CN106777147A (en) | 2017-05-31 |
Family
ID=58890624
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611179456.4A Pending CN106777147A (en) | 2016-12-19 | 2016-12-19 | A kind of optimization method of spot database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106777147A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101110074A (en) * | 2007-01-30 | 2008-01-23 | 浪潮乐金信息系统有限公司 | Data speedup query method based on file system caching |
| CN102456048A (en) * | 2010-10-28 | 2012-05-16 | 无锡江南计算技术研究所 | Method and system for processing mass data |
| CN102663110A (en) * | 2012-04-17 | 2012-09-12 | 苏州风采信息技术有限公司 | Method for optimizing outpatient process database |
| CN103593460A (en) * | 2013-11-25 | 2014-02-19 | 方正国际软件有限公司 | Data hierarchical storage system and data hierarchical storage method |
| CN104636502A (en) * | 2015-03-10 | 2015-05-20 | 浪潮集团有限公司 | Accelerated data query method of query system |
-
2016
- 2016-12-19 CN CN201611179456.4A patent/CN106777147A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101110074A (en) * | 2007-01-30 | 2008-01-23 | 浪潮乐金信息系统有限公司 | Data speedup query method based on file system caching |
| CN102456048A (en) * | 2010-10-28 | 2012-05-16 | 无锡江南计算技术研究所 | Method and system for processing mass data |
| CN102663110A (en) * | 2012-04-17 | 2012-09-12 | 苏州风采信息技术有限公司 | Method for optimizing outpatient process database |
| CN103593460A (en) * | 2013-11-25 | 2014-02-19 | 方正国际软件有限公司 | Data hierarchical storage system and data hierarchical storage method |
| CN104636502A (en) * | 2015-03-10 | 2015-05-20 | 浪潮集团有限公司 | Accelerated data query method of query system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102377790B (en) | A kind of method and apparatus of propelling data | |
| WO2015195830A3 (en) | Data query method and apparatus | |
| CN106202569A (en) | A kind of cleaning method based on big data quantity | |
| CN106557494B (en) | Update the method and device of column storage table | |
| CN104992240B (en) | A kind of method and device in optimization picking path | |
| CN107832440B (en) | Data mining method, device, server and computer readable storage medium | |
| WO2013119469A3 (en) | System, method, and interfaces for work product management | |
| CN105956669A (en) | Vehicle maintenance strategy pushing method and device | |
| CN106383776A (en) | Monitoring and self-healing method and apparatus for distributed search cluster system | |
| CN105512267A (en) | Method and device for adjusting configuration file | |
| CN106020421A (en) | Application management method and terminal | |
| CN106933935A (en) | task storage method and device | |
| CN103345523B (en) | A kind of peer review system based on cloud computing | |
| CN105511946A (en) | Intelligent home appliance equipment active degree statistic method and device and internet gateway | |
| JP2015525956A5 (en) | ||
| CN106373279B (en) | The communication means of intelligent IC card water meter for multilist centralized meter-reading system | |
| CN106777147A (en) | A kind of optimization method of spot database | |
| CN105868365A (en) | Hadoop-based traditional network management data processing method | |
| CN105160003A (en) | Geographic position-based APP retrieving and ordering method and system | |
| CN104933178A (en) | Official website determining method and system | |
| CN104714875A (en) | Distributed automatic collecting method | |
| CN105024989A (en) | Malicious URL heuristic detection method and system based on abnormal port | |
| CN104463627B (en) | Data processing method and device | |
| CN106776255A (en) | The log extracting method and device of intelligent television system | |
| EP2645312A3 (en) | Granularity-adaptive extraction of correlation structures in databases |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 401331 No. 25 Xiyong Avenue, Xiyong Town, Shapingba District, Chongqing Applicant after: Huarun Microelectronics (Chongqing) Co., Ltd. Address before: 401331 No. 25 Xiyong Avenue, Xiyong Town, Shapingba District, Chongqing Applicant before: China Aviation (Chongqing) Microelectronics Co., Ltd. |
|
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Zhu Jinyi Inventor after: Qiu Shitu Inventor after: Tan Li Inventor after: Huang Qian Inventor before: Zhu Jinyi Inventor before: Qiu Shitu Inventor before: Tan Li Inventor before: Huang Qian |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170531 |