29 results about "Database testing" patented technology

The invention relates to the technical field of software testing, in particular to a test item generation system based on large model and retrieval enhancement generation, which comprises a test item knowledge base construction module and a test item generation module which work cooperatively, the test item knowledge base construction module comprises a document analysis unit, a table extraction unit, a table standardization processing unit and a vectorization unit which are in cascade connection, and is used for analyzing a test outline document and constructing a test item vector database supporting semantic retrieval; the test item generation module comprises a double-document analysis unit, a large model cleaning unit, a test demand alignment unit and a retrieval enhancement generation unit which are connected in sequence, and is used for performing joint semantic analysis on a demand document and a task book, and retrieving a data volume library based on a test item to generate an optimized test item; according to the method, the understanding capability of a large model on task books and demand documents is effectively enhanced, the reuse rate of historical test items is improved, and the completeness and accuracy of test item generation are improved.

The invention provides a data query method and device based on natural language recognition, equipment and a medium, and belongs to the technical field of data query. The method comprises the steps that an extended keyword is obtained based on natural language query of a user; obtaining mode information and business knowledge based on the extended keyword, user natural language query and a vector database; generating a target cue word based on the mode information, the business knowledge, the user natural language query and the system cue word template; generating a plurality of candidate query statements through the target large language model based on the target cue word and the model generation parameter, and determining an optimal query statement; executing the optimal query statement in a database test environment to obtain an execution result set and capture abnormal information; verifying the execution result set to obtain a verification result; and if the abnormal information is empty and the verification result is qualified, executing the result set based on the extended keyword, the optimal query statement and the qualified result set to generate a visual chart. The power data query accuracy can be improved.

This application belongs to the field of database testing and relates to a data testing method. The method includes acquiring a task to be tested, importing the task into a preset database test model, analyzing the business load type through a monitoring analyzer to obtain business monitoring indicators, performing stress testing on the business database through a test resource pool to obtain target test results, performing sliding window parsing on the target test results based on the business monitoring indicators, and outputting a data test report. This application also provides a data testing device, computer equipment, and storage medium. This application can achieve stability testing for various business databases without requiring manual customization for specific databases. It reflects the responsiveness and processing capacity of the business database under different load conditions in real time, promptly identifies performance bottlenecks and potential anomalies, and helps technical teams optimize database configuration and business logic, improving the overall efficiency and reliability of the system.

The invention provides an integration test method and device, equipment, a medium and a product, and relates to the technical field of automatic testing, and the specific technical scheme is as follows: obtaining an action library corresponding to a test object of an integration test service, and screening a target action from test actions in the interface test dimension, the file test dimension, the database test dimension and the script test dimension of the action library, and generating a test case based on the target action. And performing collection processing according to the test case and a preset case to obtain a test task, and running the integrated test task based on the execution dependency relationship to obtain an integrated test result of the test object. According to the method, on one hand, the action library comprises the test actions under multiple test dimensions, and the test applicability is wider; and on the other hand, based on the execution dependency relationship, the integration test task is automatically operated, the integration test result of the test object is obtained, manual intervention on triggering and sequence control between cases is not needed, automatic test is achieved, and the test efficiency is improved.

The invention discloses a multi-environment consistency database script execution structure verification method, relates to computer and database technologies, is applied to database script consistency verification in a multi-database environment, and comprises the following steps: acquiring a request instruction by utilizing an agent program, and generating a standardized request object based on the request instruction; sending the standardized request object to each database environment; performing data source switching based on the standardized request object in any database environment, and executing the standardized request object after switching; and comparing the execution results returned by the database environments, and judging that the database script execution structure passes verification under the condition that the execution results are consistent. The method is used for database script consistency verification in a multi-database environment, the script consistency verification efficiency is improved, and the database test development efficiency is improved.

This invention discloses a method, apparatus, and readable medium for expanding database test cases based on a large language model. The method includes: constructing a feature knowledge base corresponding to each database management system; identifying original dialect features in the original query SQL statement of the initial database management system through an error recovery mechanism; mapping the original dialect features to the feature knowledge base corresponding to the target database management system to obtain target dialect features and their corresponding descriptions and examples; inputting the original query SQL statement of the initial database management system into a transformation model to construct a first prompt word; using the first prompt word to guide the transformation model to generate the original query SQL statement of the target database management system; and inputting the original query SQL statement of the target database management system into a finely tuned mutation model corresponding to the selected mutation strategy to generate the corresponding mutated query SQL statement of the target database management system, effectively improving universality and reliability.

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.

The application discloses an urban waterlogging intelligent prediction method considering sewer pipe silting, constructs a sewer pipe silting considered underground pipe network and two-dimensional surface coupling waterlogging numerical simulation model by using underground drainage pipe network data; by using the stormwater monitoring data of the application area, the constructed underground pipe network and the numerical simulation model are subjected to model calibration and verification; a storm event data set is constructed, and storm events of different rainfall types and different return periods are designed; an urban waterlogging intelligent prediction model is fused by an improved convolutional neural network, a bidirectional long short-term memory neural network and a Bayesian optimization algorithm, a rainfall time sequence of a database is taken as input of the model, a flooded time sequence is taken as output of the model, a training set of the database is used for training and parameter optimization of the urban waterlogging intelligent prediction model; and the rainfall time sequence in the test set of the database is taken as input, and urban waterlogging intelligent prediction under a pipe silting scenario is realized by the constructed urban waterlogging intelligent prediction model.

The invention discloses an automatic database testing method and device based on a cloud environment, equipment and a medium, and relates to the technical field of database testing. The method comprises the following steps: receiving a test request based on Web service; based on a CI / CD tool, executing the Pipeline script; the script is configured to execute the following steps: dynamically creating and configuring a virtual machine instance for testing in a cloud environment; deploying a target database, a test environment and a system monitoring agent on the virtual machine instance; calling the standardized test interface packaged by the construction tool to execute the test case through a Pipeline script; wherein the calling process of the standardized test interface is configured as pre-processing, test execution and post-processing tasks which are executed in sequence; in the test execution process, performance index data reported by the system monitoring agent are obtained and visually displayed; after the execution of the test is finished, calling an arrangement workflow predefined by Prefect; the orchestration workflow comprises a task for collecting original test results and a task for analyzing data and generating reports. The database testing efficiency is improved.

The invention relates to the technical field of database testing, in particular to a database testing method, system and equipment based on knowledge distillation and a medium, and the method comprises the following steps: constructing a multi-modal feature extractor, and performing multi-dimensional feature extraction on an input structured query statement and an execution context thereof; training the first network model based on a multi-modal feature sample generated by executing the historical test case in the reference database and execution behavior data corresponding to the multi-modal feature sample to obtain a teacher model; training the second network model according to the output probability distribution of the teacher model and the middle layer features to obtain a student model; and processing the structured query statement query of the to-be-tested database by the multi-modal feature extractor, respectively inputting the processed structured query statement query into the trained teacher model and student model, and judging whether functional abnormality exists in the current query or not according to the difference of output prediction results. The objective of the invention is to realize database function testing with high coverage rate, low manual intervention and interpretability.

The application relates to the field of database testing, and discloses an SQL generation method based on operator combination for database kernel testing, which comprises the following steps: defining a group of database query execution operators, generating a query plan tree based on the combination of the operators, and automatically constructing an effective SQL query statement, and the method is particularly suitable for testing of database function expansion, especially when new functions are introduced and compatible with original functions, and the method can efficiently detect whether the introduction of new functions has an impact on the original functions, performance and stability of the database, and help verify the correctness and compatibility of the expanded functions of the database. The method improves the testing efficiency, expands the testing coverage, and ensures that the new functions do not introduce unnecessary side effects or performance problems in the process of database function expansion.

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.

The invention discloses a database testing method and device, a medium and a product, and the method comprises the steps: obtaining a table list file of each to-be-tested data table in a target database, and obtaining a table name list in the table list file; aiming at each table name in the table name list, connecting a target database, and obtaining table information corresponding to each table name from the target database; according to each table name and the table information corresponding to each table name, constructing a test script corresponding to each data table; by executing each test script, generating a batch test instruction corresponding to each data table, executing each batch test instruction, testing each data table, and forming standardized construction logic based on table information, the reusability of the method is enhanced, and the generated test data conforms to actual design specifications and business constraints of a database, so that the test efficiency is improved. A real business scene can be accurately simulated, potential problems of the distributed database in links such as data synchronization and processing can be tested and identified, and the reliability is improved.

The application relates to the technical field of database testing, in particular to a database stored procedure accurate testing method and related equipment, which comprises the following steps: connecting a target database, installing a database debugging interface package in a stored procedure to be tested, and creating a tracking table; parsing a plurality of program objects in the stored procedure to be tested, determining start code lines, call code lines and end code lines of the plurality of program objects; inserting tracking probes after the start code lines, the call code lines and the end code lines, loading and running a test case, and recording code line numbers output by the tracking probes into the tracking table; performing left outer association on the tracking table and a database static system view of the stored procedure, complementing code texts in the database static system view according to the code line numbers, and determining a coverage rate according to the complemented code texts; thus, the application restores specific line numbers into specific code contents, and determines accurate code coverage conditions through a semantic complementing rule, so that the calculation accuracy of the coverage rate can be improved.

Methods, systems, and apparatus, including computer-readable storage media for testing features of a database management system (DBMS). A DBMS testing framework generates new random test cases for testing database features on the system. The framework receives a query grammar specifying the structure of queries to generate and generates the queries randomly. The framework executes the queries with database features randomly enabled or disabled and generates performance data from the results of executing those queries. The framework identifies points of failure in the performance data, corresponding to instances in which queries executed with certain combinations of database features result in incorrect output, or degraded performance relative to executing the queries without the database features enabled. The testing framework divides the database preparation, query generation, and query execution parts of a test pipeline into separate components, which can be modified separately or left to proceed in a default operating mode.

The application discloses a database testing method, a database system, an electronic device and a storage medium. The method comprises the following steps: obtaining a data variation guide file; the data variation guide file comprises the composition, field type, range and check value information of a test message; based on the data variation guide file, each field in the test message is varied by using a variation rule; each field after variation is combined to obtain a test case message; and the distributed database is tested by using the test case message. The scheme provided by the application models the test message, so that the data variation is miniaturized and comprehensive, the generation of invalid test case messages is reduced, the combined test case message can be applied to different test scenes, the comprehensiveness of the test data is ensured, and the diversification of the test scene is ensured.

The invention discloses a data processing method, device and equipment and a computer readable storage medium, and the method comprises the steps: constructing an initial prompt according to a grammar analysis file of a test database and database information of the test database, inputting the initial prompt into a pre-training model, carrying out the recognition processing of the initial prompt through the pre-training model, and obtaining a recognition result of the initial prompt; obtaining a first test case; obtaining a mutation operator, and performing mutation processing on the first test case through the pre-training model and the mutation operator to obtain a second test case different from the first test case; executing the test cases in the test case library through the test database to obtain a first execution result output by the test database, and determining a test report of the test database according to the first execution result; the test case library comprises a first test case and a second test case. By adopting the method and the device, the expandability and the coverage rate of database testing are improved.

The invention discloses a database migration test method and system based on multiple agents, and belongs to the field of database migration tests.The method comprises the steps that S100, an original database code analysis agent obtains DDL codes of a to-be-tested storage process or function in an original database and analyzes the DDL codes; s200, the original database case writing agent generates a test case covering all logic branches in an original database environment; s300, the original database test execution agent runs the generated test case in the original database environment, the grammar correctness of the SQL statement is verified, and an execution result is captured; s400, the target database case writing agent generates a test case version adapted to the target environment by referring to the original library test case and the DDL code of the target database; s500, the target database test execution agent executes the adapted test case; and S600, the result evaluation agent receives the test result and finally generates a migration quality evaluation report. According to the invention, the test efficiency can be improved.

The invention discloses a fault diagnosis method and system for a Beidou short message communication module. The method comprises the following steps: presetting a diagnosis sample database; testing environment diagnosis: based on the diagnosis sample database, using a first receiving system to diagnose the electromagnetic environment of the working frequency of the Beidou short message communication module, using a second receiving system to diagnose the satellite signal quality of the Beidou short message communication module, and generating a testing environment diagnosis report based on the diagnosis result; diagnosis of the Beidou short message communication module: diagnosing configuration parameters, transmitting offset frequency, a receiving link and a transmitting link of the Beidou short message communication module in combination with the diagnosis sample database, the first receiving system and the second receiving system, and generating a diagnosis report based on a diagnosis result. The device can improve the working efficiency, save manpower and material resources and reduce the production cost.

The application discloses a method for manufacturing a photonuclear database for improving the calculation precision of a reactor photonuclear, and the method comprises the following steps: obtaining photonuclear data of a first plurality of nuclides and performing format conversion to obtain photonuclear data in a first data format; performing calculation on the photonuclear data of a second plurality of nuclides in the first plurality of nuclides, and comparing the photonuclear data of the second plurality of nuclides according to the photonuclear calculation results; obtaining photonuclear data in a second data format according to the comparison results of the photonuclear data and the photonuclear data in the first data format, obtaining a first photonuclear database according to the photonuclear data in the first data format and an index file, and obtaining a second photonuclear database according to the photonuclear data in the second data format; and performing reactor data test on the first and second photonuclear databases respectively to obtain corresponding database test results. Through iterative feedback, the application obtains a continuous-energy photonuclear database with high precision and high reliability, and can significantly improve the calculation precision and efficiency of the neutron-photon coupling transport in a reactor.

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.

The invention provides a database test scene playback method and device, equipment, a storage medium and a program product, and relates to the technical field of database test. The method comprises the following steps: acquiring a target database log in the database; under the condition that a structured query language (SQL) statement bound with a binding variable exists in the target database log, the binding variable in the SQL statement is replaced with a corresponding parameter value in the database log, and a target SQL statement with complete semantics is obtained; sorting the target SQL statement to obtain an executable SQL file; and playing back the test environment according to the SQL file. The method is used for improving the playback efficiency and the reliability of the test result.

The invention discloses a database automatic testing method and device, equipment and a storage medium. The method comprises the steps of splitting a to-be-tested database into a plurality of data tables based on a preset configuration file in response to a database conversion instruction; each data table is in one-to-one correspondence with one system, and each data table stores a plurality of data types of the corresponding system and data parameters corresponding to each data type; in response to a target inspection instruction, based on a target inspection parameter input by a user, performing a comparison test on a target data table in the plurality of data tables and a test case corresponding to a test case path in the target inspection parameter, and determining a target test result; the target checking comprises variable information checking, hard wiring checking and alarm card checking, automatic testing of the database is achieved, and therefore the efficiency and accuracy of database testing are improved.

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.

The invention discloses an unsupervised deeply-forged video detection method based on wavelet transform and a Mama state space, and belongs to the technical field of multimedia information security, and the method comprises the steps: carrying out the face image detection and cutting of an original video, decomposing a face image, and constructing a multi-channel frequency domain input tensor; extracting spatial domain features and frequency domain features of the face images, and distributing an initial pseudo tag for a sample of each face image; constructing a deep neural network model containing dynamic contour convolution and a visual state space module; constructing a positive and negative sample pair by using the initial pseudo tag, and training a deep neural network model through comparative learning; and extracting feature vectors of all frames of the test video by using the trained model, calculating a time sequence consistency feature, comparing the time sequence consistency feature with a judgment threshold, and judging whether the video is forged or not. According to the method, manual data annotation is not needed, the calculation efficiency is high, and excellent generalization ability and robustness are shown in a cross-library test.

The invention relates to a database test case generation method and device and electronic equipment. The method comprises the following steps: acquiring a natural language test demand input by a user, and converting the natural language test demand into an internal instruction language; performing syntactic analysis on the original test case, and establishing a case model; determining a target transformation template from a transformation template library according to the internal instruction language; and transforming the original test case by utilizing the target transformation template and the case model to generate a new test case. The technical problem that a systematic mechanism for converting natural language requirements into standard test cases does not exist is solved.

The invention discloses a die casting defect prediction method based on an integrated machine learning method, and belongs to the field of die casting defect prediction. The method comprises the steps that firstly, an original database is formed by collecting and storing technological parameter data in the die casting process, and a historical database is formed by generating synthetic samples to balance the number of samples of different categories; secondly, testing the performance of different classification algorithms in die-casting defect classification based on a historical database, and selecting three classification algorithms as optimal classifiers by using the optimal performance calculated by f-measure; and finally, the selected optimal classifier is subjected to soft voting fusion, weighted average fusion is carried out on probability outputs of the three models, and a category with the maximum probability is selected as a final prediction result according to probability distribution after fusion. According to the method, multiple machine learning models (such as a random forest, a support vector machine and a neural network) are integrated, and feature engineering and a hyper-parameter optimization technology are combined, so that the accuracy and robustness of defect prediction are remarkably improved.

The invention relates to the technical field of database test and performance evaluation, and discloses a database test result intelligent evaluation system based on big data, which comprises a data acquisition module, an intelligent analysis module, a scene adaptation module, an evaluation decision module and a display storage module. Executing double-flow parallel acquisition of multi-source heterogeneous data by the system, and aligning a performance index and a static execution plan by using a nearest neighbor maintenance strategy; constructing a fuzzy physical topological mask matrix by analyzing operator dependency and a state during operation, and generating a causal atlas by combining statistical association strength; a variational auto-encoder is used to identify a current service scene type to dynamically adjust an analysis strategy, and a root cause probability of an abnormal index is calculated based on a causal atlas. According to the method, by fusing physical topology prior and statistical causal inference, the problems of single test data dimension and difficulty in causal relationship identification are solved, and high-precision evaluation and adaptive tuning of database performance are realized.