CN101667180A - System and method for space management of database - Google Patents
System and method for space management of database Download PDFInfo
- Publication number
- CN101667180A CN101667180A CN200810196023A CN200810196023A CN101667180A CN 101667180 A CN101667180 A CN 101667180A CN 200810196023 A CN200810196023 A CN 200810196023A CN 200810196023 A CN200810196023 A CN 200810196023A CN 101667180 A CN101667180 A CN 101667180A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- module
- management system
- deleted
- 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 description 13
- 238000007726 management method Methods 0.000 claims description 23
- 238000012217 deletion Methods 0.000 claims description 11
- 230000037430 deletion Effects 0.000 claims description 11
- 230000005540 biological transmission Effects 0.000 claims description 4
- 238000013500 data storage Methods 0.000 claims description 3
- 230000002123 temporal effect Effects 0.000 claims description 2
- 238000004519 manufacturing process Methods 0.000 description 3
- 230000007774 longterm Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 230000037361 pathway Effects 0.000 description 1
- 230000000153 supplemental effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a system for space management of a database, which is suitable for a management system for automatically deleting data in the database, and is characterized in that the management system comprises a starting module, a searching module, a deleting module and a recording module, wherein the starting module is used for starting the management system; the searching module is used for searching the data to be deleted, and judges whether the searched data is the data to be deleted when searching the data in the database; the deleting module is used for deleting the data searched in the database; and the recording module is used for recording information of the data deleted at a certain time. The system for the space management of the database is automatically started to delete the data to be deleted in the database in background when a machine works normally, and can perform deleting actions continuously according to the position of the data deleted last time.
Description
[technical field]
The present invention relates to a kind of database space management system, particularly a kind of management system that is applied to data in the automatic delete database.
[background technology]
Have some machinery and equipment in commercial production, this machinery and equipment can produce some some data about finished product after producing finished product, and these data are transmitted automatically with certain store path and are stored on the machinery and equipment server.General, this data volume is big, and more data are arranged is gibberish, and the data that produce as OMRON AOI machine comprise: finished product view data, finished product generation time data, finished product supplemental characteristic.Machinery and equipment will be stored lot of data on the server after long-term use, be a kind of challenge to the server of finite capacity.
Find that in the long-term production process only need to keep the view data of some finished products, other data are redundant data, the producer only wishes to keep view data after producing finished product.So just can the deletion data for the producer, but in delete procedure, to find each finished product to produce the file of data, and distinguish useful data and useless data, the workload of searching so for the user and deleting is very big, and machinery and equipment need be suspended use in delete procedure, get off to influence production output for a long time like this, delay the finished product shipment.If in delete procedure directly all data Delete Alls, like this in the test process afterwards because of no related data compares, in the bad tracing process of finished product, cause great inconvenience.
[summary of the invention]
The object of the invention is to provide a kind of database space management system, particularly a kind of management system that is applied to data in the automatic delete database.
The invention provides a kind of database space management system, this system comprises:
One starts module, and it is used to start this system;
One searches module, and it is used for searching the data that database will be deleted, and this is searched module and during data, judge that whether the data of searching are for wanting deleted data in searching database;
One removing module, it is used for deleting the data that will delete that above-mentioned database finds out;
One logging modle, it is used for writing down the information of the database data of a certain moment deletion.
Specifically, the described module of searching is carried out sequential search according to the path keyword of storage data and the temporal information of data storage in the database.
Specifically, the keyword of described data routing comprises storage area, machinery and equipment title, finished product title, and this is searched module and positions in conjunction with data in the described crucial word pair database.
Specifically, described logging modle recorded information be current deleted data time and routing information.
The present invention also proposes a kind of method of the SPACE/MA that is used to control database, and this method comprises the following steps:
(1) opens this system by starting module;
(2) search the information of deleting the last time of writing down on the module reading and recording module;
(3) search module and continue to search and want deleted data, and the transmission delete instruction is to removing module;
(4) removing module receives delete instruction, directly deletes the above-mentioned deleted data of wanting;
(5) judging whether to have deleted the data that will delete, is "Yes" as judged result, then enters step (6), is "No" as judged result, then returns step (3) and proceeds to search.
(6) time of logging modle record deletion data and routing information.
Compared with prior art, database space management system of the present invention is provided with one and starts module, when the machinery and equipment operate as normal, opens operation automatically on the backstage; This system is provided with one in addition and searches module, a removing module, a logging modle, make that whether data are for wanting deleted data in this system automatic judgment data storehouse, and directly delete, and when begin to carry out in the delete database data next time, can proceed the deletion action according to deleted data position last time.
[description of drawings]
Fig. 1 is a database space management system structural representation of the present invention.
Fig. 2 is a database space management method schematic flow sheet of the present invention.
[embodiment]
Join shown in Figure 1ly, be database space management system structural representation of the present invention.
The invention provides a kind of database space management system, particularly a kind of management system that is applied to data in the automatic delete database, in present embodiment, data are arranged according to the regular hour order in this database, and this system comprises:
One starts module 1, and it is used to start this system, and in present embodiment, this startup module 1 is provided with a timing unit, and it is used for opening and move this system automatically at setting-up time;
One searches module 2, it is used for searching the data that database will be deleted, this is searched module 2 and carries out sequential search according to the time of data routing of storing in the database and data storage, in present embodiment, the keyword in this path comprises storage area, machinery and equipment title, finished product title, this is searched module 2 and positions in conjunction with data in the described crucial word pair database, this searches module 2 in searching database during data, judge and whether search data for wanting deleted data, in present embodiment, search module 2 and set non-picture data for wanting deleted data;
One removing module 3, it is used for deleting the deleted data of wanting that above-mentioned database finds out, in present embodiment, data in these removing module 3 direct delete database;
One logging modle 4, it is used for writing down the database data message of a certain moment deletion, and in present embodiment, these logging modle 4 recorded informations are the time and the routing information of a certain moment deleted data.
Join shown in Figure 2ly, be database space management method schematic flow sheet of the present invention.The present invention also proposes a kind of method of the SPACE/MA that is used to control database, and this method comprises the following steps:
Step 100: on the timing unit of this system start-up module 1, set the opening time,, on timing unit, set every day in a certain moment and open this system in present embodiment;
Step 101: system opened automatically in the opening time of setting, and on the backstage, move, above-mentioned searching deleted information the last time that module 2 reads on the described logging modle 4 record, and in present embodiment, this searches time and data associated pathway that module 2 reads deleted data last time;
Step 102: above-mentioned search module 2 according to last time deleted data time and path continue to search the data that will delete, and the transmission delete instruction is to removing module 3, this delete command is searched the order of wanting deleted data that module 2 is judged for deletion, in present embodiment, this is searched module 2 and carries out sequential search according to time and path that data in the database generate, judge non-picture data for wanting deleted data, and should want the deleted data information transmission to removing module 3;
Step 103: above-mentioned removing module 3 receives above-mentioned module 2 delete instructions of searching, and directly deletes above-mentioned data;
Step 104: the described module 2 of searching judges whether to have deleted the data that will delete, in present embodiment, this is searched module 2 and judges whether the data that generate between rise time of data of deletion this moment and current time have deleted and want deleted data, as judged result is "Yes", searching module 2 and think to have deleted and want deleted data in the database, then enter step 105, is "No" as judged result, search module 2 and think that data need deletion in addition, then return step 102 and proceed to search.
Step 105: above-mentioned logging modle 4 writes down last deleted data time and routing information after removing module 3 has been deleted data, in present embodiment, the information stores of these logging modle 4 records is a text, the above-mentioned module 2 of searching is when searching data next time, directly read text file, the time and the routing information of the data of the last deletion of text file logging.
Claims (8)
1, a kind of database space management system is applicable to the management system of data in the automatic delete database to it is characterized in that this system comprises:
One starts module, and it is used to start this management system;
One searches module, and it is used for searching the data that database will be deleted, and this is searched module and during data, judge that whether the data of searching are for wanting deleted data in searching database;
One removing module, it is used for deleting the deleted data of wanting that above-mentioned database finds out;
One logging modle, it is used for writing down the information of the database data of a certain moment deletion.
2, database space management system as claimed in claim 1 is characterized in that: data are arranged according to the regular hour order in the described database.
3, database space management system as claimed in claim 1 is characterized in that: described startup module is provided with a timing unit, and it is used for opening this management system automatically at setting-up time.
4, database space management system as claimed in claim 1 is characterized in that: the described module of searching is carried out sequential search according to the path keyword of storage data and the temporal information of data storage in the database.
5, database space management system as claimed in claim 4 is characterized in that: the keyword of described data routing comprises storage area, machinery and equipment title, finished product title, and this is searched module and positions in conjunction with data in the described crucial word pair database.
6, database space management system as claimed in claim 5 is characterized in that: the described module settings non-picture data of searching is for wanting deleted data.
7, database space management system as claimed in claim 1 is characterized in that: the information of described logging modle record is the time and the routing information of a certain moment deleted data.
8, a kind of method of the SPACE/MA that is used to control database is characterized in that this method comprises the following steps:
(1) opens this system by starting module;
(2) search the information of deleting the last time of writing down on the module reading and recording module;
(3) search module and continue to search and want deleted data, and the transmission delete instruction is to removing module;
(4) removing module receives delete instruction, directly deletes the above-mentioned deleted data of wanting;
(5) judging whether to have deleted the data that will delete, is "Yes" as judged result, then enters step (6), is "No" as judged result, then returns step (3) and proceeds to search.
(6) time of logging modle record deletion data and routing information.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200810196023A CN101667180B (en) | 2008-09-03 | 2008-09-03 | System and method for space management of database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200810196023A CN101667180B (en) | 2008-09-03 | 2008-09-03 | System and method for space management of database |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101667180A true CN101667180A (en) | 2010-03-10 |
CN101667180B CN101667180B (en) | 2012-10-17 |
Family
ID=41803798
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN200810196023A Expired - Fee Related CN101667180B (en) | 2008-09-03 | 2008-09-03 | System and method for space management of database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101667180B (en) |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101976254A (en) * | 2010-10-26 | 2011-02-16 | 青岛海信移动通信技术股份有限公司 | Database recovering method and device based on mobile communication terminal |
CN101980195A (en) * | 2010-10-26 | 2011-02-23 | 青岛海信移动通信技术股份有限公司 | Mobile communication terminal-based database index repair method and device |
CN102279881A (en) * | 2011-07-28 | 2011-12-14 | 南京中兴新软件有限责任公司 | Junk data clearing method and file access server |
CN104348939A (en) * | 2013-08-07 | 2015-02-11 | 联想(北京)有限公司 | Information storage method and electronic equipment |
CN104599341A (en) * | 2013-10-31 | 2015-05-06 | 深圳市赛格导航科技股份有限公司 | Car positioning information storage method and apparatus thereof |
CN106294809A (en) * | 2016-08-16 | 2017-01-04 | 成都鼎昊科技有限公司 | A kind of terminal management method |
CN106776846A (en) * | 2016-11-28 | 2017-05-31 | 桂林远望智能通信科技有限公司 | A kind of method and system for discharging database space |
CN106776847A (en) * | 2016-11-28 | 2017-05-31 | 广东欧珀移动通信有限公司 | Delete the method for media file, device and move on to terminal |
CN112666897A (en) * | 2019-10-15 | 2021-04-16 | 纮织国际有限公司 | System combining dynamic production and braiding machine work management |
TWI824473B (en) * | 2022-04-08 | 2023-12-01 | 鴻海精密工業股份有限公司 | Method and device for deleting data by visual detection, electronic device, and computer-readable storage medium |
Family Cites Families (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2000148548A (en) * | 1998-11-17 | 2000-05-30 | Nec Corp | Unnecessary record deleting device |
JP2001084259A (en) * | 1999-09-13 | 2001-03-30 | Mitsubishi Electric Corp | Database system |
CN100403436C (en) * | 2003-12-05 | 2008-07-16 | 上海乐金广电电子有限公司 | Playing programme managment method of recordable recording medium |
KR101058007B1 (en) * | 2004-05-18 | 2011-08-19 | 삼성전자주식회사 | How to delete data stored on a recording medium and how to restore deleted data |
US20060117008A1 (en) * | 2004-11-17 | 2006-06-01 | Kabushiki Kaisha Toshiba | File management apparatus and file management program |
CN100367278C (en) * | 2004-11-29 | 2008-02-06 | 中兴通讯股份有限公司 | Device and method for archiving and inquiry historical data |
CN100466717C (en) * | 2005-09-19 | 2009-03-04 | 海信集团有限公司 | Automatic clear, adding recording and searching acquiring method for digital TV EPG information |
-
2008
- 2008-09-03 CN CN200810196023A patent/CN101667180B/en not_active Expired - Fee Related
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101976254A (en) * | 2010-10-26 | 2011-02-16 | 青岛海信移动通信技术股份有限公司 | Database recovering method and device based on mobile communication terminal |
CN101980195A (en) * | 2010-10-26 | 2011-02-23 | 青岛海信移动通信技术股份有限公司 | Mobile communication terminal-based database index repair method and device |
CN101980195B (en) * | 2010-10-26 | 2012-08-01 | 青岛海信移动通信技术股份有限公司 | Mobile communication terminal-based database index repair method and device |
CN102279881A (en) * | 2011-07-28 | 2011-12-14 | 南京中兴新软件有限责任公司 | Junk data clearing method and file access server |
CN104348939B (en) * | 2013-08-07 | 2018-12-14 | 联想(北京)有限公司 | A kind of information storage means and electronic equipment |
CN104348939A (en) * | 2013-08-07 | 2015-02-11 | 联想(北京)有限公司 | Information storage method and electronic equipment |
CN104599341A (en) * | 2013-10-31 | 2015-05-06 | 深圳市赛格导航科技股份有限公司 | Car positioning information storage method and apparatus thereof |
CN106294809A (en) * | 2016-08-16 | 2017-01-04 | 成都鼎昊科技有限公司 | A kind of terminal management method |
CN106776846A (en) * | 2016-11-28 | 2017-05-31 | 桂林远望智能通信科技有限公司 | A kind of method and system for discharging database space |
CN106776847A (en) * | 2016-11-28 | 2017-05-31 | 广东欧珀移动通信有限公司 | Delete the method for media file, device and move on to terminal |
CN106776847B (en) * | 2016-11-28 | 2020-01-14 | Oppo广东移动通信有限公司 | Method and device for deleting media file and mobile terminal |
CN112666897A (en) * | 2019-10-15 | 2021-04-16 | 纮织国际有限公司 | System combining dynamic production and braiding machine work management |
TWI824473B (en) * | 2022-04-08 | 2023-12-01 | 鴻海精密工業股份有限公司 | Method and device for deleting data by visual detection, electronic device, and computer-readable storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN101667180B (en) | 2012-10-17 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101667180B (en) | System and method for space management of database | |
CN103530290B (en) | Data migration method and system between database | |
KR101346731B1 (en) | Method and apparatus for synchronizing feed information | |
CN103793479A (en) | Log management method and log management system | |
JP4354441B2 (en) | Video data management apparatus, method and program | |
CN102244758A (en) | Video-recording-file-based data acquisition method and equipment | |
CN103631827A (en) | Method and system for synchronizing webpage information | |
CN104270605A (en) | Method and device for processing video monitoring data | |
CN101909189B (en) | File recovery method, system and DVR (Digital Video Recorder) | |
CN103226965A (en) | Time-bitmap-based audio/video data access method | |
CN104008207A (en) | Optical disc based external data storage system for database and data storage method | |
WO2020016526A4 (en) | Method implemented by computer for the creation of contents comprising synthesis images | |
CN110377598B (en) | Multi-source heterogeneous data storage method based on intelligent manufacturing process | |
CN102075670B (en) | Log recording method and device for broadcast machine | |
CN104834738A (en) | Record file storage method and device | |
CN110162563B (en) | Data warehousing method and system, electronic equipment and storage medium | |
CN106855890B (en) | Method for realizing final consistency full-text retrieval of high-performance database | |
CN104899249A (en) | Reliable index update system and method under mass data | |
CN101350031A (en) | Method for storing data, method and system for searching data | |
CN110032586B (en) | Storage method, query method and acquisition and storage system for energy storage cell data | |
CN103490923A (en) | Log file reading and writing method, device and system | |
CN104572464A (en) | Automated test state saving method and device of Android platform | |
CN104301491B (en) | A kind of data processing method and device of smart phone | |
CN113609245B (en) | Method and system for expanding capacity of index by fragments | |
CN114741552A (en) | Video file storage method and medium with custom format |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20121017 |