85 results about "Database testing" patented technology

Systems and methods that create a duplicate database instance on which database testing may be performed. The techniques for creating a test database instance enable database testing to proceed without impacting other organization's access to their data in the database or corrupting an organization's data. The ability to allow one organization (“org”) to test their portion of a database without interrupting other organizations from using their portions of the database enables a database system to support more than one organization as tenants.

Test data generation and scale up for database testing using unique common factor sequencing can include selecting a column of a table for which test data is needed and generating test data for the column that replicates cardinality characteristics of an existing production dataset and that includes a local predicate of a workload.

The present invention discloses a database testing method and a system, and belongs to the technical field of databases. The method comprises: setting a corresponding test script and a test scenario according to an externally input test request, and performing simulation to generate corresponding multiple pieces of test data; in a software database system, testing the test data by applying the test script according to the test scenario to run a database test process associated with the test request; monitoring the database test process and acquiring a plurality of test indices; by using a preset policy and according to a preset standard parameter associated with the test indices, performing a screening process on the test indices and outputting a screening result; and optimizing the software database system according to the screening result, and then exiting. The system comprises an acquiring unit, a configuration unit, a testing unit, a monitoring unit, a screening unit and a processing unit. The beneficial effect of the technical scheme is that: error reasons of a database are found and analyzed, thereby facilitating error location and performance optimization.

The invention discloses a method for evaluating a pure XML engine of a relational database system, which comprises function evaluation and performance evaluation of the pure XML engine of the relational database system. The method comprises the following steps of: designing a set of complete test scene according to the characteristics of the pure XML engine on a relational database, simulating a document management system, designing and generating an XML document set serving as a test data set, designing a test transaction set comprising a query transaction set and an update transaction set according to W3C standards, operating individual query and statement update as function test and operating concurrent loads of multiple query and update transactions as performance test by using an SQL / XML language to comprehensively evaluate the storage capability, index capability, bearing capability and the like of the database system, and defining an evaluation index set. The method proved by experiments on the database of DB2 and the like has universal meaning, systematicness and completeness, and can be used in the field of database test.

A database environment that includes one or more database production servers, one or more database test servers, and a virtualization connection that provides incoming service request traffic to both the database production server and the database test server. However, the database production server responds to the database service requests, while the database test server does not. The database test server may be tested for a variety of different configurations in an attempt to find a better performing configuration. The testing is in real-time as the database test server is subjected to the same incoming service request traffic as the database production server.

A database test method and device are provided; the method comprises the following steps: stopping a backup database from copying a main database, wherein the backup database is the backup database for the main database; obtaining a first data operation request on the main database in a preset time; starting a second data operation request on the backup database according to the obtained first data operation request on the main database in the preset time; carrying out database test for the backup database when the backup database executes corresponding data operation according to the received second data operation request, thus obtaining a database test result. The method and device can effectively improve database test result accuracy.

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.

The present invention relates to the technical field of database testing, and in particular relates to a database pressure testing method. According to the present invention, a test plan is newly created and a database JDBC configuration is provided, by using a JMeter tool; then a request is sent via the JDBC for testing; and finally a test result is collected via a graphic result. The method according to the present invention can well reflect whether a database object needs to be optimized, and can be widely applied for database performance testing for a software product.

The invention provides a time sequence database testing method and system. The method comprises the following steps: setting test point types to be tested, wherein the test point types comprise a function index, an advanced function index, a performance index and availability; and testing the test point types respectively, and recording the test results of testing on each test point type. According to the scheme of the invention, the functions and performance of the time sequence database can be comprehensively tested, and the functions and performances of time sequence databases of different manufacturers can be compared conveniently, and the model selection of the time sequence database is facilitated.

The present invention aims at providing an applied data quality test method, the method is mainly used in testing and comparative analysis for a plurality of business systems, and can be used to check out illegal data appointed in a plurality of business systems of different business rules and correct the illegal data to improve the data quality of each business system. The specific steps are as follows: firstly, the complex data testing and analysis can be abstracted into concrete data testing rules, and a SQL generator which is adapted to different database testings is provided, through the SQL generator, the SQL sentences required by data testing rules can be automatically or manually generated; secondly, during the process of data testing ad comparative analysis, the SQL generator executes a single item, a plurality of items or an automatic testing to the testing rules, the testing is automatically executed to formulate an execution plan for the periodical and timing execution; thirdly, the SQL generator makes various comparative analysis for the tested out result and provides query for the tested out but not corrected data.

The invention discloses a database testing method. The testing method comprises steps of acquiring data connection configuration information of a target database and establishing a data connection relation with the target database, extracting database base scripts stored in advance and inputting the database base scripts and the configuration information of the target database into a core class, and generating a database function script based on a data structure of the core class, and configuring data contents of the database function script as a data processing step of the preset testing method to enable the preset testing method to execute the database function script in the target database when a test is required. The invention further discloses a database testing device and computer readable storage medium. Data test configuration file generation speed can be increased through construction of the core class for automatic generation of the data test function scripts, so data testingefficiency can be improved.

The embodiment of the invention discloses a database test method and device, equipment and a storage medium, and the method comprises the steps: obtaining a test case corresponding to a current to-be-tested function in a target database, the test case comprising a test statement, configuration information and an expected parameter; If it is determined that the test case meets the test requirementsof the target database based on the configuration information, executing the test statement to obtain test parameters; And comparing the test parameter with the expected parameter to obtain a test result of the current to-be-tested function. According to the embodiment of the invention, the function of judging the compatibility and accuracy of the database can be realized by comparing the test parameters obtained during the test with the expected parameters in the preset test case, so that the workload caused by the replacement or upgrading of the database is reduced, the complexity is reduced, and the accuracy is ensured.

Embodiments of the present invention provide a method, system and computer program product for test data generation using unique common factor sequencing. In an embodiment of the invention, a method for test data generation using unique common factor sequencing is provided. The method includes loading a table for population with test data in a test data generation tool executing in memory of a computer. A column set of multiple columns in the table associated with a key to the table can be selected for processing and different cardinality sequence values are assigned to the columns in the set such that the cardinality sequence values do not share a common factor except for unity as in the case of prime numbers. Thereafter, data is generated for the specified number of rows of each column in the column set according to a corresponding one of the cardinality sequence values and random data is additionally generated for other columns of the table without regard to any particular cardinality sequence value. Finally, the table can be persisted for use in database testing.

The invention discloses a fast face retrieval method based on depth learning, belonging to the application field of computer vision object recognition. The invention mainly utilizes the depth neural network and extracts the face binary features, and combines the local sensitive hashing (LSH) nearest neighbor retrieval algorithm to propose a fast and efficient face retrieval algorithm. Firstly, thedepth neural network is trained by a large number of calibrated face data, and then all the images in the database are substituted into the neural network for calculation to obtain the correspondingbinary feature library, and then the hash function is designed to construct the hash structure. For the images to be retrieved, the images to be retrieved is also substituted into the neural network to calculate the binary features, and then the LSH algorithm is used to complete the retrieval. Through a large number of database tests, it is found that this method has high retrieval accuracy, highspeed, and good robustness in the engineering environment.

The invention relates to the technical field of graph database testing, in particular to a method and a system for generating a large graph for testing. The method comprises the following steps: generating a first scale graph according to small-scale business data of an application system; analyzing and processing the first scale graph to obtain relevant statistical information of the graph; according to the expected scale and the scale of the first scale map, calculating the correlation expansion factor and transforming and expanding the correlation statistical information, generating a second scale map in accordance with the prediction result according to the correlation statistical information after the transformation expansion; Wherein the data scale of the first scale map is larger than that of the second scale map. The invention takes the small-scale service data of the application system as the input to restore the small-scale diagram, By analyzing and obtaining the distributionlaw of the small graph data, the large graph data can be generated after the expansion of the graph data, which is more consistent with the expected business data of the application system, so that the test of the graph database system software product has more pertinence and effectiveness, and lays the foundation for the smooth online and stable operation of the application system.

Testing a database is disclosed. A test description defining a test of a database is received. The test description specifies a relative timing between an issuance of a first command via a first session of the database when the test is conducted and an issuance of a second command via a second session of the database when the test is conducted. The database is configured to conduct the test defined in the test description.

The invention discloses a cross-domain image classification method based on pseudo label domain adaptation, and relates to image processing. The method comprises the following steps: A, pre-training a depth model; b, generating a target domain image pseudo label; and C, training and optimizing the depth model. The method is simple and effective, and a better effect can be obtained on a plurality of natural image data sets. The influence of false labels is avoided; the pseudo label samples are added into the training set to further train the network, so that the discrimination of the model in the target domain can be improved, and the generalization performance of the model in the target domain is improved. The target domain data without labels are fully utilized by alternately making false labels on the target domain and training the network by adopting false label samples, so that the recognition performance of the model on the target domain is effectively improved. The invention improves the generalization performance when a deep learning model is used for natural image recognition, improves the accuracy and recall rate during cross-database testing, is high in practicability and portability, and can meet the requirements of weak supervision learning under the conditions of large domain difference, unbalanced categories and the like.

The invention discloses a method for generating a complex structured query language (SQL) statement for solving the technical problem that the complex SQL statement cannot be generated according to a combined keyword by the conventional method for generating the SQL statement. The method comprises the following step of automatically generating the complex SQL statement according to a keyword specified by a user based on a Postgres database testing set through a method for classifying and combining SQL keywords, designing a basic SQL statement and generating the complex SQL statement, so that the complex SQL statement can be generated according to the combined keyword. The statement can be directly applied to the testing process of a database system, and the problems of high error rate and low efficiency caused by manually writing the combined keyword are solved.

The invention provides a distributed application scheduling method and device, which are used for optimizing a network environment and improving the processing efficiency of a target task to a certainextent when a processing task such as a database test is carried out based on a distributed framework. The task processing method provided by the invention comprises the steps that first processing device receives a task processing request, and the task processing request is used for requesting to process a target task; the first processing device splits the target task into different sub-tasks and distributes the different sub-tasks to different second processing devices through RESTFUL interfaces; the second processing device analyzes the received sub-tasks through a preset Webserver service, configures configuration files of the sub-tasks in a YAML format, and loads the configuration files through a CLI interface to execute the sub-tasks; and the first processing device generates a processing result of the target task based on task data generated by executing different tasks by the plurality of second processing devices.

The invention relates to a distributed security test system, which comprises a test template module used for providing a network test template, selecting a test template and generating a new templateaccording to a test result; a tool selection module used for sending an instruction to the control management module so as to call a test tool for selection; a progress display module used for displaying the currently collected information and the test progress information in real time and prompting the next operation; an information collection module used for collecting information of a test target; a strategy making module used for making a test strategy according to the collected information; a security test module used for sending the loopholes to the target host one by one according to aloophole analysis stage sequence; a data storage module used for storing the collected information and the whole test process log, and storing a test template generated in the test process into a database; and a test tool module integrated with a security test tool for selection and calling of the control management module.

Test data generation and scale up for database testing using unique common factor sequencing can include selecting a column of a table for which test data is needed and generating test data for the column that replicates cardinality characteristics of an existing production dataset and that includes a local predicate of a workload.

The invention discloses a database testing method and device and computer equipment. The database testing method comprises: acquiring a test case script created for a to-be-tested database; acquiringa configuration instruction input by a tester for the to-be-tested database, and injecting a test parameter into the test case script according to the configuration instruction; testing the to-be-tested database by injecting the test case script of the test parameter to obtain query data returned by the to-be-tested database in the test process; and generating a test result of the to-be-tested database according to the query data. According to the database testing method and device and the computer equipment, the problem that database testing depends on manual implementation in the prior art is solved, and the database testing method and device are particularly suitable for function testing in the testing field.

The invention discloses an industrial cluster creative platform testing device and method applied to the technical field of industrial cluster creative platforms. The device comprises an industrial cluster creative platform Web system testing module, an industrial cluster creative platform function testing module, an industrial cluster creative platform performance testing module, an industrial cluster creative platform availability testing module, an industrial cluster creative platform compatibility testing module and an industrial cluster creative platform safety testing module, and is characterized in that the industrial cluster creative platform Web system testing module comprises a link testing module, a form testing module, a data check module, a cookies testing module and a database testing and design language testing module; the industrial cluster creative platform performance testing module comprises a connecting speed testing module and a load testing and pressure testing module. The structure is simple, the testing method is practical, investment is low, the running safety of the device is ensured, the complex functions of application management and interaction of an industrial cluster creative platform Web system are more thoroughly tested, and basic problems and global deep problems of an industrial cluster creative platform can be more accurately found.

The invention discloses a method for testing the performance of a virtual platform database of a server, and relates to the field of virtual testing of the servers. The method mainly comprises the steps of 1) building a virtual testing platform; 2) creating a virtual machine; 3) configuring java environment variable to the virtual machine; 4) verifying the java environment; 5) creating a database testing environment; 6) introducing data test; 7) testing the performance. With the adoption of the testing method, the database processing performance of the server virtual platform and the utilization rate of the virtual machine resource can be effectively evaluated; whether the processing capacity of the server virtual platform database meets the customer demand can be effectively estimated.

The embodiment of the invention is suitable for the technical field of testing, and provides a database testing method and device, terminal equipment and a storage medium, and the method comprises thesteps: obtaining a testing statement for a target database, and dividing the testing statement into a plurality of statement segments; a preset regular expression is adopted to carry out regular matching on the statement segments, test information of the target database is obtained, and the test information comprises test type information; obtaining a target configuration statement matched with the test type information; generating a target test statement according to the test information and the target configuration statement; and testing the target database by adopting the target test statement. According to the embodiment, different types of databases can be tested by adopting the test statement corresponding to one grammar.

The embodiment of the invention provides a database testing method and device. The method includes obtaining a test case including a first test keyword written in a natural language; matching the first test keyword with the second test keyword in the keyword library to obtain a target test method corresponding to the first test keyword, wherein the keyword library comprises a mapping relationshipbetween a plurality of second test keywords and a corresponding test method; using the target test method to test the database to be tested. The present invention also relates to a device for performing the method described above. The embodiment of the invention obtains the first test key written in the natural language, and matches with the second test keyword in the keyword library to obtain thetarget test method corresponding to the first test keyword. The target test method is used to test the test database, so that testers do not need to have higher programming ability and to be familiarwith the database provided by the programming language.

An image memorizing degree prediction method based on a sparse low-rank regression model comprises the following steps of dividing a high-grade meaning characteristic database into a high-grade meaning characteristic database training set and a high-grade meaning characteristic database testing set, and respectively extracting image memorizing degree scores which correspond with the high-grade meaning characteristic database training set and the high-grade meaning characteristic database testing set; using the high-grade meaning characteristic database training set and the corresponding imagememorizing degree score as learning objects, solving by means of an alternative iteration method based on an augmented lagrangian method, and obtaining a relation model between the high-grade meaningcharacteristic and the image memorizing degree score through training according to an algorithm framework of the sparse low-rank regression model; and by means of the relation model which is obtainedthrough training, predicating the image memorizing degree of the high-grade meaning characteristic database testing set. The image memorizing degree prediction method has advantages of preventing image characteristic redundancy, integrating sparse regression and low-rank expression into one framework, and realizing automatic characteristic selection. Furthermore the method can be applied for predicating the image memorizing degree.

The invention provides a database testing method and system capable of avoiding database type interference, which is used for avoiding database type interference TPC-E test of a to-be-tested databasethrough setting of compatible rules.. The database testing method comprises the steps that a testing system obtains a to-be-tested database; the test system inputs a plurality of simulation transactions corresponding to the TPC-E test to the to-be-tested database; when it is detected that the database type of the to-be-tested database is a to-be-compatible database type, the test system obtains acompatibility rule corresponding to the database type of the to-be-tested database; the test system obtains response results, corresponding to the plurality of simulation transactions, of the to-be-tested database according to the compatibility rule; the test system forms the TPC-E test result of the to-be-tested database according to the response result; and the test system outputs the TPC-E test result to a management platform.

The invention discloses a database testing method and device, and relates to the field of databases. According to the specific implementation scheme, the database testing method comprises the steps oftesting a tested database comprising abnormal data to obtain a first test result; under the condition that the first test result shows that the database is normal, testing the running state of the server cluster of the tested database according to the resource allocation condition, and obtaining a second test result; and under the condition that the second test result is that the server cluster of the database is normal, monitoring a data change condition in the database to obtain a third test result. According to the database testing method, a more comprehensive and accurate database test result can be provided, and the robustness of the database can be improved.