Database test data generation method and system thereof

A technology for testing data and databases, applied in the field of database applications, can solve problems such as rigidity, low data authenticity, and inability to simulate real user usage habits, to achieve the effect of increasing authenticity and enhancing business pertinence

Inactive Publication Date: 2012-10-10
SUZHOU CODYY NETWORK SCI & TECH
View PDF3 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In terms of test data generation, currently it mainly relies on data generation devices such as gen-data, but its disadvantage is that it is too rigid and cannot simulate the usage habits of real users, and the data authenticity is not high
On the other hand, for different types of business operations, the existing technology cannot automatically generate data according to the scenarios expected by users

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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database test data generation method and system thereof
  • Database test data generation method and system thereof
  • Database test data generation method and system thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0010] Hereinafter, the present invention will be described in detail with reference to the drawings and examples. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other.

[0011] figure 1 Shown is a flow chart of a method for generating database test data according to a preferred embodiment of the present invention. Such as figure 1 As shown, the method for generating database test data provided by the preferred embodiment of the present invention includes steps 101-102.

[0012] Step 101: Obtain the program statement corresponding to the user operation, and acquire the field information of the data table according to the data table name included in the program statement.

[0013] Specifically, the data tables may be data tables in all relational databases, and the corresponding programming language may be any structured query language. When the user performs an op...

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 provides a database test data generation method and a system thereof. The method of the invention comprises the following steps of: acquiring a program statement corresponding to a user operation, acquiring the field information of a data sheet according to a data sheet name contained in the program statement, and respectively generating a specified number of test data in normal distribution for the different fields of the data sheet according to the field information and the user-specified number.

Description

technical field [0001] The invention belongs to the field of database applications, in particular to a method and system for generating database test data. Background technique [0002] With the rapid development of the information society, databases have been widely used in enterprises, schools and libraries. In daily applications, the database system needs to store a large amount of data. With the continuous development of business, the amount of data continues to increase, and the load on the database is increasing. In order to ensure the robustness of the database operation, maintenance personnel need to perform stress tests on the database with a large amount of data during the process from database establishment to modification. In terms of test data generation, at present, it mainly relies on data generation devices such as gen-data, but its disadvantage is that it is too rigid and cannot simulate the usage habits of real users, and the authenticity of the data is no...

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
IPC IPC(8): G06F17/30
Inventor 胡加明刘晓东
Owner SUZHOU CODYY NETWORK SCI & TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap