CN106294046A - Method for testing lost data of storage system by writing data into database in real time - Google Patents
Method for testing lost data of storage system by writing data into database in real time Download PDFInfo
- Publication number
- CN106294046A CN106294046A CN201610694527.8A CN201610694527A CN106294046A CN 106294046 A CN106294046 A CN 106294046A CN 201610694527 A CN201610694527 A CN 201610694527A CN 106294046 A CN106294046 A CN 106294046A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- real time
- storage system
- data base
- 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
- 238000012360 testing method Methods 0.000 title claims abstract description 24
- 238000000034 method Methods 0.000 title claims abstract description 20
- 238000011084 recovery Methods 0.000 claims description 3
- 238000010998 test method Methods 0.000 abstract description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/22—Detection or location of defective computer hardware by testing during standby operation or during idle time, e.g. start-up testing
- G06F11/2273—Test methods
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/22—Detection or location of defective computer hardware by testing during standby operation or during idle time, e.g. start-up testing
- G06F11/2205—Detection or location of defective computer hardware by testing during standby operation or during idle time, e.g. start-up testing using arrangements specific to the hardware being tested
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/242—Query formulation
- G06F16/2433—Query languages
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention particularly relates to a method for testing data loss of a storage system by writing data into a database in real time. The method for writing data loss of a data test storage system into a database in real time comprises the steps of firstly establishing the database under the system, and storing the database on the storage system; establishing a table in a database; writing data into a database table in real time; counting the data amount written into the database table in real time; the method comprises the steps of enabling a storage system to break down when data are written into a database in real time; and after the storage system is recovered, whether the data volume is consistent with the data written in the database in real time or not is counted. The method for writing data loss of the data test storage system into the database in real time can uninterruptedly generate and write the data into the database, can count the data in real time, can be executed on various different databases, and is suitable for different database scenes; the method saves manpower, improves working efficiency and provides a feasible test method for testing the data loss of the storage system.
Description
Technical field
The present invention relates to memory system technologies field, write data test storage system in real time particularly to a kind of data base
The method losing data.
Background technology
Along with the continuous lifting of storage system business complexity, the application scenarios of data is required more and more higher by people.With
Being continuously increased of the various multi-media processing business carried out around digitized, networking, storage grid platform has become
Being a product platform, the most various application are more and more higher to the requirement of platform, the most just in memory capacity, also include number
According to access performance, data transmission performance, data managing capacity, storage extended capability etc. many aspects.It can be said that storage network
The quality of the combination property of platform, will directly influence the properly functioning of whole system.Whether lose in test storage system at present
When losing data, method is single and cannot calculate whether lose data accurately, loses data volume has how many so that test data
Result can not be convincing.
And write big data quantity by data base, and can write in real time, Realtime Statistics, in the case can be the truest
The actually used situation of analog subscriber, test storage system loss data in terms of become is easy to operation.Real-time with data base
As a kind of new method, write data can test whether storage system loses data.
Based on above-mentioned situation, in order to farthest reduce the generation of data volume loss accident, the present invention proposes one
Data base writes the method for data test storage system loss data in real time.
Summary of the invention
The present invention is in order to make up the defect of prior art, it is provided that a kind of simple efficient data base writes data in real time and surveys
The method of examination storage system loss data.
The present invention is achieved through the following technical solutions:
A kind of data base writes the method for data test storage system loss data in real time, it is characterised in that comprise the following steps:
(1) setting up data base under system, database purchase is in storage system；
(2) data base sets up table table；
(3) in database table table, data are write in real time；
(4) data volume during real-time statistics is written to database table table；
(5) storage system jam is made when data base writes data in real time；
(6) data that after storage system recovery, statistical data amount writes in real time with data base are the most consistent.
In described step (1), setting up oracle database under system, oracle database is stored in storage system.
In described step (3) and step (4), use sql statement to write data in real time in database table table, use
The data volume that sql statement real-time statistics is written in database table table.
The invention has the beneficial effects as follows: this data base writes the method for data test storage system loss data in real time, can
With continual generation data, and write into Databasce, simultaneously can also Realtime Statistics, can be on various different data bases
Perform, it is adaptable to different data base's scenes；Both saved manpower, improve again work efficiency, for test storage system loss
The test of data provides a kind of feasible method of testing.
Accompanying drawing explanation
Accompanying drawing 1 is the method schematic diagram that data base of the present invention writes data test storage system loss data in real time.
Detailed description of the invention
In order to make the technical problem to be solved, technical scheme and beneficial effect clearer, below tie
Closing drawings and Examples, the present invention will be described in detail.It should be noted that, specific embodiment described herein is only used
To explain the present invention, it is not intended to limit the present invention.
This data base writes the method for data test storage system loss data in real time, comprises the following steps:
(1) setting up data base under system, database purchase is in storage system；
(2) data base sets up table table；
(3) in database table table, data are write in real time；
declare
a number(5) := 0;
Num number(8) :=0;# defined word segment variable
begin
For a in 1..10000 loop # definition write data volume
Insert into table (field 1) values (' number');
Num:= Num+ 1;
end loop;
end;
# is different according to list structure, insert statement field adjustable #
(4) data volume during real-time statistics is written to database table table；
(5) storage system jam is made when data base writes data in real time；
(6) the storage system failure is got rid of, the data that after storage system recovery, statistical data amount and data base write in real time whether
Cause.
In described step (1), setting up oracle database under system, oracle database is stored in storage system.
In described step (3) and step (4), use sql statement to write data in real time in database table table, use
The data volume that sql statement real-time statistics is written in database table table.
This data base write in real time data test storage system loss data method, can continual generation data,
And write into Databasce, simultaneously can also Realtime Statistics, can perform on various different data bases, it is adaptable to different numbers
According to storehouse scene；Both having saved manpower, and improve again work efficiency, the test for test storage system loss data provides one
Feasible method of testing.
Claims (3)
1. the method that a data base writes data test storage system loss data in real time, it is characterised in that include following step
Rapid:
(1) setting up data base under system, database purchase is in storage system；
(2) data base sets up table table；
(3) in database table table, data are write in real time；
(4) data volume during real-time statistics is written to database table table；
(5) storage system jam is made when data base writes data in real time；
(6) data that after storage system recovery, statistical data amount writes in real time with data base are the most consistent.
Data base the most according to claim 1 writes the method for data test storage system loss data, its feature in real time
It is: in described step (1), setting up oracle database under system, oracle database is stored in storage system.
Data base the most according to claim 1 writes the method for data test storage system loss data, its feature in real time
It is: in described step (3) and step (4), uses sql statement to write data in real time in database table table, use sql
Statement real-time statistics is written to the data volume in database table table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610694527.8A CN106294046A (en) | 2016-08-19 | 2016-08-19 | Method for testing lost data of storage system by writing data into database in real time |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610694527.8A CN106294046A (en) | 2016-08-19 | 2016-08-19 | Method for testing lost data of storage system by writing data into database in real time |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106294046A true CN106294046A (en) | 2017-01-04 |
Family
ID=57661687
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610694527.8A Pending CN106294046A (en) | 2016-08-19 | 2016-08-19 | Method for testing lost data of storage system by writing data into database in real time |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106294046A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109151454A (en) * | 2018-07-26 | 2019-01-04 | 郑州云海信息技术有限公司 | A kind of test abnormal power-down loses the method and system of data volume |
| CN110427362A (en) * | 2018-04-27 | 2019-11-08 | 杭州海康威视数字技术股份有限公司 | A kind of method and device obtaining type of database |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102637197A (en) * | 2012-02-28 | 2012-08-15 | 中北大学 | File management method of real-time data acquisition and storage system |
| CN102938001A (en) * | 2012-12-10 | 2013-02-20 | 曙光信息产业(北京)有限公司 | Data loading device and data loading method |
| CN103209094A (en) * | 2013-03-11 | 2013-07-17 | 中国科学院信息工程研究所 | System and method for fault positioning on basis of events |
| CN104750774A (en) * | 2014-12-15 | 2015-07-01 | 北京星网锐捷网络技术有限公司 | Database upgrading method and device |
| CN105095393A (en) * | 2015-06-30 | 2015-11-25 | 努比亚技术有限公司 | Method and device for data storage |
| CN105302729A (en) * | 2015-12-09 | 2016-02-03 | 浪潮电子信息产业股份有限公司 | Storage system testing method based on database application |
| CN105512042A (en) * | 2015-12-22 | 2016-04-20 | 广东金赋信息科技有限公司 | Automatic generation method and device for testing data of database and testing system |
-
2016
- 2016-08-19 CN CN201610694527.8A patent/CN106294046A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102637197A (en) * | 2012-02-28 | 2012-08-15 | 中北大学 | File management method of real-time data acquisition and storage system |
| CN102938001A (en) * | 2012-12-10 | 2013-02-20 | 曙光信息产业(北京)有限公司 | Data loading device and data loading method |
| CN103209094A (en) * | 2013-03-11 | 2013-07-17 | 中国科学院信息工程研究所 | System and method for fault positioning on basis of events |
| CN104750774A (en) * | 2014-12-15 | 2015-07-01 | 北京星网锐捷网络技术有限公司 | Database upgrading method and device |
| CN105095393A (en) * | 2015-06-30 | 2015-11-25 | 努比亚技术有限公司 | Method and device for data storage |
| CN105302729A (en) * | 2015-12-09 | 2016-02-03 | 浪潮电子信息产业股份有限公司 | Storage system testing method based on database application |
| CN105512042A (en) * | 2015-12-22 | 2016-04-20 | 广东金赋信息科技有限公司 | Automatic generation method and device for testing data of database and testing system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110427362A (en) * | 2018-04-27 | 2019-11-08 | 杭州海康威视数字技术股份有限公司 | A kind of method and device obtaining type of database |
| CN110427362B (en) * | 2018-04-27 | 2022-03-08 | 杭州海康威视数字技术股份有限公司 | Method and device for acquiring database types |
| CN109151454A (en) * | 2018-07-26 | 2019-01-04 | 郑州云海信息技术有限公司 | A kind of test abnormal power-down loses the method and system of data volume |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104331487B (en) | The processing method and processing device of log | |
| CN106844507B (en) | A kind of method and apparatus of data batch processing | |
| CN104484480B (en) | Remote copy method and device based on data de-duplication | |
| WO2016004813A1 (en) | Data storage method, query method and device | |
| CN107038162A (en) | Real time data querying method and system based on database journal | |
| CN106777270A (en) | A kind of Heterogeneous Database Replication parallel execution system and method based on submission point time line locking | |
| CN102467525A (en) | Document associating method and system | |
| CN106992886A (en) | A kind of log analysis method and device based on distributed storage | |
| CN104391891B (en) | A kind of database isomery clone method | |
| CN106294046A (en) | Method for testing lost data of storage system by writing data into database in real time | |
| CN106126522A (en) | A kind of processing system of accounting statement | |
| WO2019056770A1 (en) | Method and apparatus for data processing on basis of related transactions, and computer device | |
| CN106503138A (en) | A kind of journal file processing method and processing device | |
| CN106294792B (en) | The method for building up of correlation inquiry system and establish system | |
| CN106503040B (en) | It is applicable in the KV database and its creation method of SQL query method | |
| CN107944866B (en) | Transaction record duplication elimination method and computer-readable storage medium | |
| CN104408128B (en) | A kind of reading optimization method indexed based on B+ trees asynchronous refresh | |
| CN107241231A (en) | A kind of fast accurate localization method of raw network data bag | |
| CN106776795A (en) | Method for writing data and device based on Hbase databases | |
| CN112527836A (en) | Big data query method based on T-BOX platform | |
| CN105930524A (en) | Big data aggregation method facing quick service | |
| CN106933927A (en) | The connection method of tables of data and device | |
| CN110633301A (en) | Method and system for extracting data based on engine setting | |
| CN106204252A (en) | Internal credit and debt remaining sum identification, the method and system gathering and checking | |
| CN106875275A (en) | The on-line automatic reconciliation system and method for commercial health insurance |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170104 |