69 results about "Database testing" patented technology

The invention discloses a method for generating and constructing a database test knowledge base based on an open source large language model and retrieval enhancement, and relates to the technical field of database testing, and the method comprises the steps: building a local deployment system on a local computer system or server, and achieving the efficient local operation of the open source large language model and the stable output of language processing service; on a local computer system or a server, a retrieval enhancement generation framework is constructed, and accurate knowledge support and reliable content output are provided for local language processing service by integrating multi-modal knowledge, optimizing retrieval and generation processes and guaranteeing safety and compliance; on a local computer system or a server, a personalized database knowledge base is built, database related information is collected and processed from multiple channels and is output in an adaptive form, and the specified information requirement of local personalized language processing service is met. According to the method, efficient and stable operation of the open source large language model is realized, accurate and reliable language processing output is realized, and personalized services meet specific requirements.

The invention discloses a database test case extension method and device based on a large language model and a readable medium. The method comprises the following steps: constructing a feature knowledge base corresponding to each database management system; identifying an original dialect feature in an original query SQL statement of the initial database management system through an error recovery mechanism, and performing dialect mapping on the original dialect feature in a feature knowledge base corresponding to the target database management system to obtain a target dialect feature and a description and an example corresponding to the target dialect feature; inputting an original SQL (Structured Query Language) statement of the initial database management system into the conversion model, constructing a first cue word, and guiding the conversion model to generate an original SQL statement of the target database management system through the first cue word; and inputting the original query SQL statement of the target database management system into the fine-tuned variation model corresponding to the selected variation strategy, and generating the variation query SQL statement of the corresponding target database management system, thereby effectively improving the universality and reliability.

The invention relates to a database test case generation and optimization method, system and device and a storage medium. Knowledge information related to a target database is obtained, and after vectorization is conducted on the knowledge information, the knowledge information is stored in a vector database supporting vector storage and vector retrieval; obtaining test demand information, retrieving vector data related to the test demand information from the vector database, and extracting original text data corresponding to the vector data through a mapping relation of the vector database; obtaining a pre-constructed cue word template, filling the test demand information and the original text data into the cue word template to obtain cue words, analyzing the cue words through a preset large language model, and generating a test case of the target database; and sending the test case to a database server for running to obtain a running result, optimizing the cue word according to the running result, and re-inputting the cue word into the large language model until the test case generated by the large language model meets user requirements.

The invention provides a method for automatically converting a single-instance use case of a database into a high-availability use case, which comprises the following steps of: after an automatic test framework is started, performing grammatical analysis on the use case by using parser; a pre-converter is added to the high-availability converter; and calling an application method of the HaTransform to start to convert the use case. The method has the beneficial effects that the method for dynamically modifying the test case is provided, and the test case of a single instance is automatically changed into a high-availability case. The method can be applied to database test case scripts written based on DSL. The value of the method is reflected in that a large number of cases with the same test function points do not need to be written manually; the method is simple and easy to use, and dynamically converts cases according to one parameter of a command line.

The invention relates to the technical field of automatic testing in a database management system, and provides an efficient PL / SQL database test case generation method and system, and the method comprises the steps: carrying out the static analysis of a PL / SQL source code; matching a predefined test case template according to a static analysis result, and dynamically adjusting according to PL / SQL code features to obtain the test case template; performing dynamic testing according to the test case template, executing path tracking and boundary value detection, and capturing abnormity; a test case is automatically generated in combination with static and dynamic analysis results; and executing the test case, performing deep analysis on a test result through a machine learning algorithm, and adjusting the test case through a feedback optimization mechanism according to an analysis result to obtain a final test case. According to the method, the generation efficiency and quality of the PL / SQL database test case are remarkably improved, manual intervention is reduced, the error rate is reduced, and the development period is shortened.

The invention relates to the technical field of software test evaluation, and discloses a database software test result-based intelligent evaluation system, which comprises a data acquisition module, an intelligent analysis module, an evaluation decision module, a display storage module and a scene adaptation module. Multi-source test data is acquired and cleaned through the data acquisition module, the intelligent analysis module constructs a causal atlas by using time sequence grouping intervention, metadata driving association and scene clustering, the evaluation decision module forms a three-dimensional evaluation model, and the display storage module realizes natural language report and visual interaction. Meanwhile, by means of a scene adaptation module and an incremental learning ability dynamic optimization evaluation strategy, the root cause positioning efficiency can be improved, the evaluation error can be reduced, the real-time evaluation requirement can be met, multi-source data integration and model self-evolution are achieved, and a solution is provided for database test evaluation.

The invention relates to the technical field of database testing, provides a database cluster testing method, device and system, a storage medium and a program product, and can efficiently test a plurality of database clusters. The method comprises the steps of obtaining database cluster configuration parameters and test case labels according to test parameters input by a user; constructing a plurality of database clusters in a containerization mode according to the cluster configuration parameters; determining target test cases carrying test case labels in a test case library to obtain a target test case set; and testing the plurality of database clusters based on the target test case set.

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.

The invention provides a relational database testing method and device, electronic equipment, a medium and a product. The method comprises the steps of generating a structured query framework statement based on a grammar rule of a structured query statement according to a test target of a to-be-tested database; obtaining data element information of the to-be-tested database, and generating a data object relation rule of the to-be-tested database based on the data element information; the data object relation rule represents the hierarchical relation between the data objects; according to the structured query framework statement and the data object relation rule, combining to generate a structured query test statement; and sending the structured query test statement to a to-be-tested database end to execute a test, and generating a test result. According to the scheme, the accuracy of the database test result 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 present application discloses a time series database testing method, system, and device, relating to the technical field of databases. The method comprises: obtaining time series data from a target time series database, performing pattern analysis on the time series data, and obtaining time series analysis data, wherein the time series analysis data is used to characterize at least one data characteristic of the time series data; creating at least one test case based on the time series analysis data and predefined test case creation rules, wherein the test case has at least one data characteristic of the time series data; and executing the at least one test case based on a pre-set test execution engine and pre-defined test case execution rules to obtain a test result. The present application has the effect of improving testing efficiency.

The embodiment of the invention provides a database testing method and device and a database query method and device based on a virtual index, and belongs to the technical field of computers. The method comprises the following steps: obtaining index metadata based on a pre-created virtual index, extracting a target field of a query statement test instance, storing the index metadata to a system directory of a test database according to the target field, generating a query execution plan according to the query statement test instance and the index metadata of the system directory, and the target execution cost of the query execution plan is calculated through the cost calculation model, the query execution plan is screened according to the target execution cost to obtain the target execution plan of the query statement test instance, and the query performance test is performed on the test database according to the target execution plan, so that the resource consumption of the database test can be reduced.

The present invention discloses a method and system for generating and testing user-defined functions in a database. The method comprises the following steps: building a retrieval corpus containing function semantic fragments based on official documents of a database system; adopting a hierarchical strategy to build multi-layer prompt information based on the function semantic fragments, structured requirement information and example guidance templates; a function creation model adopts a streaming generation and syntax verification mechanism based on the multi-layer prompt information to generate a user-defined function creation statement; injecting the statement into a database system to execute a creation operation; if the execution is successful, performing correctness verification on the generated user-defined function; when the verification result is passed, recording metadata and a boundary value sample set of the user-defined function, and generating a corresponding user-defined function entity; constructing a database test statement group based on the metadata, boundary value sample set and target database structure of the user-defined function entity, and performing automated testing on the user-defined function entity.

The application relates to the technical field of automatic testing in a database management system, and provides a high-efficiency PL / SQL database test case generation method and system, which comprises the following steps: performing static analysis on PL / SQL source code; matching a predefined test case template according to a static analysis result, and dynamically adjusting the test case template according to PL / SQL code characteristics to obtain a test case template; performing dynamic testing according to the test case template, performing path tracking, boundary value detection, and capturing exceptions; automatically generating test cases in combination with static and dynamic analysis results; executing the test cases, performing deep analysis on test results through a machine learning algorithm, adjusting the test cases through a feedback optimization mechanism according to analysis results, and obtaining final test cases. The application significantly improves the generation efficiency and quality of PL / SQL database test cases, reduces manual intervention, reduces error rates, and shortens the development cycle.

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.

The invention provides a database-based parameter result prediction method, which belongs to the technical field of database testing, supplements the blank aspect of database parameter prediction and function verification in the prior art, and comprises the following steps of: building a prediction analysis database, embedding a prediction analysis model into the prediction analysis database, and performing function verification on the prediction analysis model. Parameters are analyzed through the prediction analysis model, judgment is made according to the analysis result after the parameters are analyzed, and the accuracy of intelligent prediction of the database 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.

The invention discloses a database testing method and device, electronic equipment and a storage medium, and the method comprises the steps: obtaining to-be-processed traffic of a target database, and determining protocol feature information corresponding to at least one data packet in the to-be-processed traffic; generating at least one to-be-injected exception script based on the protocol feature information of each data packet and a protocol state machine corresponding to the target database; determining a communication protocol layer corresponding to each abnormal script to be injected, and injecting to obtain an abnormal test model; and generating a test report according to a comparison result of the output data of the abnormal test model and the target comparison data corresponding to the target database. The corresponding exception test model is constructed according to the protocol interaction characteristics of the database, and the coverage rate of the test scene to the exception condition in the real network is improved by adding the exception scene in the exception test model, so that the security test effect is performed on the target database in a targeted manner.

The embodiment of the invention discloses a database testing method and device, equipment and a storage medium, relates to the technical field of computers, and can be used for solving the problem that a database is difficult to effectively test. The database test method comprises the following steps: acquiring a plurality of expressions and first test data; the expression comprises one or more operation elements supported by the first database; the operation elements comprise functions or operators; executing the plurality of expressions in the first database to process the first test data to obtain a plurality of pieces of execution information; the multiple pieces of execution information are in one-to-one correspondence with the multiple expressions, and the execution information is used for indicating resource consumption information when the first database executes the expressions to process the first test data; determining a test result corresponding to the first database according to the multiple pieces of execution information; the test result comprises performance parameters when the first database executes each operation element.

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.

The embodiment of the invention provides an application test method and device, equipment, a readable storage medium and a program product, and the method comprises the steps that a client selects a plurality of test cloud real machines from a plurality of cloud real machines, and stores an obtained test instruction, test configuration data and a reference program interface image into a database; the test cloud real machine obtains test data including a test code and a reference program interface image according to the related data in the database; running the to-be-tested application program according to the test code; acquiring a test interface image; determining a test result of the to-be-tested application program according to the test interface image and the reference program interface image, and storing the test result in a database; and the client determines a target test result according to the test result of the to-be-tested application returned by each test cloud real machine acquired from the database. According to the method provided by the embodiment of the invention, the application program can be tested by using the cloud real machine to obtain the test result, so that the application test efficiency is effectively improved.

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 provides a database testing method and system and related device.The testing method comprises the steps that a script to be tested is published in a testing database, then the script to be tested is tested in the testing database, and the testing result of a multi-dimensional database is determined according to the testing result of the script to be tested; the data in each cell in the multi-dimensional database can be understood as being generated by the calculation script, so that if the calculation script passes a test, it can be proved that the calculation script can output a correct result, and the data in each cell in the multi-dimensional database can also be determined as a correct result; in this way, the multidimensional database is tested in the mode of testing the calculation script, data in each cell can be prevented from being tested, then the testing efficiency is improved, and the problem that the multidimensional database is difficult to test is solved.

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.

The present invention provides a database testing method and apparatus, equipment, storage medium and program product, which can be applied to the field of database testing technology. The method includes: in response to a script execution command, installing a target version database based on a database installation script; executing a structured query language script on table data in the initial version database based on an initial server node to obtain initial query information; calling an information configuration script, modifying a target parameter file based on associated configuration information of the initial version database to obtain a configuration parameter file, wherein the target parameter file includes configuration information of the target version database associated with the target server node, and the target version database performs an access operation on the initial version database based on the configuration parameter file; performing data detection on the initial version database and the target version database based on the configuration parameter file and the initial query information to obtain a detection result.