Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Storage system testing method based on database application

A technology of storage system and testing method, applied in the direction of software testing/debugging, etc.

Inactive Publication Date: 2016-02-03
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF3 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical task of the present invention is to provide a storage system testing method based on database application, to solve the problem that in the application combined with the database, the storage system abnormality is very likely to cause data Lost, causing huge losses, that is, the stability of the storage system

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The present invention will be further described below by specific examples.

[0017] A storage system testing method based on a database application of the present invention, a storage system testing method based on a database application comprises the following steps:

[0018] (1) Build an OracleRAC application environment or a DataGuard application environment; build a corresponding test system for a specific application environment. Make sure the data files are stored on a logical volume that is mapped to the host. The specific topology is as close as possible to the actual application.

[0019] (2) Write test scripts, execute script automation tests; write sql scripts, including data batch insertion scripts, user batch creation scripts, batch export scripts, and batch import scripts. By running scripts, it can automate batch operations and verify the data consistency of the system.

[0020] (3) Configure swingbench, execute swingbench simulation business test; ru...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a storage system testing method based on an database application and belongs to the field of storage system detection. The method aims at solving the technical problems that abnormity of a storage system is very likely to cause data loss when the storage system is combined with a database for application, and huge loss is caused, that is, stability of the storage system is reduced. According to the technical scheme, the method includes the following steps that firstly, a database application environment is built, wherein a storage system to be tested is used, the specific database application environment is built to simulate an actual user implementation environment, and accordingly the storage system can expose the stability problem as much as possible under the complex application environment; secondly, a sql script is automatically compiled, wherein the testing script includes batch building of new users, batch building of tables and batch exporting and importing, an Oracle log is observed by running the script, and data consistency of the storage system is verified under pressure of the database application; thirdly, a tool is tested through swingbench; fourthly, testing results are output.

Description

technical field [0001] The present invention relates to the field of storage system testing, specifically a storage system testing method based on database applications. Background technique [0002] With the continuous expansion of key data volumes in different industries, the combination of database applications and storage systems has gradually attracted people's attention. Among them, Oracle is favored by users in key industries because of its RAC, DataGuard cluster high availability and RMAN backup functions. In the application combined with the database, the abnormality of the storage system is very likely to cause data loss and cause huge losses. Therefore, the test of the stability of the storage system and data consistency in this implementation is particularly important. [0003] Stability problems of the storage system are more likely to occur under high pressure and long-term running conditions. Therefore, in the test, we need to simulate this kind of environme...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/36
Inventor 王少磊
Owner LANGCHAO ELECTRONIC INFORMATION IND CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com