54 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 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 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 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.

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.

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.

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 invention provides a cross-database access test method and device of a database and electronic equipment, and relates to the technical field of database testing.The method comprises the steps that when it is monitored that a cross-database associated query statement containing a different-database pointing label exists in a script, a DBLink request is initiated to a heterogeneous database corresponding to the different-database pointing label through a pre-established DBLink link, and the database corresponding to the different-database pointing label is obtained; initiating a cross-library data query request; and triggering the heterogeneous database to execute the local associated query statement to obtain a first query result, receiving a second query result returned by the heterogeneous database; and comparing the first query result with the second query result, and testing the cross-database access function of the database according to the comparison result. According to the cross-database access testing method and device of the database and the electronic equipment, cross-database testing of the local database can be effectively achieved, manual participation is not needed in the testing process, and the cross-database access testing efficiency of the database can be effectively 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.

The invention provides a test case generation method for a database, which can be applied to the field of database testing. The method comprises the steps that description documents corresponding to a database are matched according to key fields, function attribute information of multiple functions is obtained, and the function attribute information comprises at least one parameter and at least one use case sample corresponding to the functions; according to the function attribute information of the multiple functions, attribute mapping of the multiple functions is constructed, and the attribute mapping comprises the corresponding relation between each parameter and the parameter attribute information of the multiple parameter attribute items; and generating a plurality of test cases of each function according to the respective parameter attribute information for the plurality of parameter attribute items and the case samples corresponding to the functions. The invention also provides a test method, equipment and a medium.

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 provides a cross-database access test method and device of a database and electronic equipment, and relates to the technical field of database testing. The method comprises the following steps: when it is monitored that a cross-database association query statement containing a cross-database pointing label is included in a script, initiating a DBLink request to a heterogeneous database corresponding to the cross-database pointing label through a pre-established DBLink link to initiate a cross-database data query request; triggering the heterogeneous database to execute a local association query statement to obtain a first query result; receiving a second query result returned by the heterogeneous database; comparing the first query result and the second query result, and testing the cross-database access function of the database according to the comparison result. The cross-database access test method and device of the database and the electronic equipment can effectively realize cross-database testing of a local database, and the testing process does not require manual participation, thereby effectively improving the cross-database access test efficiency of the database.

The invention discloses a database testing method and device, electronic equipment and a storage medium. The method comprises the following steps: in response to a test setting operation, determining a to-be-tested database, a target text case set and a file output path; and in response to a test starting operation, testing the to-be-tested database based on the target text case set to obtain a target test result, generating a target test file based on the target test result, and outputting the target test file based on the file output path. According to the invention, the effects of one-key automatic database detection and test file output are realized. According to the method and the device, the test file recording the test result of the text case set can be automatically output, so that the test result can be conveniently traced in the later period.