5 results about "Database testing" patented technology

This invention provides a database testing method, apparatus, electronic device, and storage medium based on protocol layer interaction. It generates test SQL statements, performs parameterization to form parameter placeholder structures, and extracts parameter constraint information. Based on the parameter placeholder structures, parameter constraint information, and the current session state, it generates protocol test cases, sequentially sends multiple protocol data packets, receives and parses response data packets returned by the database system, records communication error information during response reading, and updates the current session state based on the parsing results of the response data packets. When the communication error information is detected during response reading, if a crash occurs or the verification results are inconsistent, an error report is generated. This invention can cover protocol processing paths under different execution stages and interaction sequences, reduce invalid requests with semantically invalid or easily rejected requests, improve the validity of test input, and enhance the coverage depth and defect detection capability of database protocol testing.

This invention relates to the field of database testing technology and discloses a database fuzzing method based on copy-on-write. The method includes: initializing a persistent layer to obtain a baseline storage state; creating a temporary layer and associating it with the persistent layer to form a union storage view; during test case execution, redirecting write operations to the temporary layer via copy-on-write, while read operations are read from either the temporary or persistent layer depending on whether the data exists; after testing, deleting and rebuilding the temporary layer to quickly restore the initial state; and repeating this process until all test cases are completed. This application constructs a two-layer storage structure consisting of a persistent layer and a temporary layer, recording all test changes in the temporary layer. After testing, only deleting and rebuilding the temporary layer is needed to quickly reset the repository, avoiding a complete initialization process and significantly improving the efficiency of database fuzzing.

This application provides a data query method, apparatus, device, and medium based on natural language recognition, belonging to the field of data query technology. The method includes: obtaining extended keywords based on user natural language queries; obtaining pattern information and business knowledge based on the extended keywords, user natural language queries, and a vector database; generating target prompt words based on the pattern information, business knowledge, user natural language queries, and system prompt word templates; generating multiple candidate query statements through a target large language model based on the target prompt words and model generation parameters, and determining the optimal query statement; executing the optimal query statement in a database test environment, obtaining an execution result set and capturing abnormal information; validating the execution result set and obtaining a verification result; if the abnormal information is empty and the verification result is qualified, then generating a visualization chart based on the extended keywords, the optimal query statement, and the qualified result set. This application can improve the accuracy of power data queries.

This invention discloses a method for simplifying large-scale test cases with test anomalies in transactional databases, comprising the following steps: Step 1: Extract test case information. For a given initial test case, based on the corresponding test database table structure and execution information, encode the operation information in the test case, organizing it into a matrix by transaction; Step 2: Aggregate related transactions based on the data access correlation and session correlation of each transaction. Combining the data access characteristics of each transaction and its associated session, use an inverted index to aggregate the transactions in the initial test case to obtain a transaction set; Step 3: Prune the test cases. Iteratively prune to gradually reduce the transaction set in the test cases to obtain simplified test cases. This invention also discloses the application of the above method in test case simplification during database test development.

This disclosure provides a distributed database testing method, related apparatus, and medium. The method includes: determining the initial configuration state of the distributed database as the current configuration state; acquiring multiple test cases; executing the multiple test cases in the distributed database under the current configuration state, and after the test cases are executed, setting the call status flag of the underlying logic block called by the test cases to a first status value; adjusting the configuration parameters of the distributed database to update the current configuration state, updating the multiple test cases, and returning to the steps of executing the multiple test cases in the distributed database under the current configuration state, until the number of underlying logic blocks whose call status flags are set to the first status value reaches a predetermined condition. This disclosure improves the coverage of distributed database testing and more accurately detects vulnerabilities in the distributed database. This disclosure can be applied to distributed database testing scenarios.