9 results about "Database conversion" patented technology

The application relates to the technical field of big data, and discloses a database conversion method and device, computer equipment, a storage medium and a computer program product. The method comprises the following steps: acquiring to-be-converted database data; analyzing the to-be-converted database data to obtain a node set and hierarchical attributes of each node; performing framework updating on the node set according to the adaptation degree corresponding to the hierarchical attributes to obtain target framework database data; and performing database conversion on the target framework database data according to target data configuration information to obtain target database data. The method can more smoothly perform database conversion.

The invention discloses a multi-storage medium grammar generation method and system based on a grammar analyzer, and relates to the technical field of grammar construction.The method comprises the steps of 1, statement obtaining, 2, normal statement word screening, 3, normal statement type analysis, 4, normal statement keyword analysis and 5, target statement generation. According to the method, the statement type of the normal statement is judged by analyzing the position and the byte number of each fixed word of the normal statement, and each key word of the normal statement is further screened into a table name word, each field word, each data type word and each constraint word, so that the reference statement for database conversion is quickly positioned, and the database conversion efficiency is improved. The syntactic analyzer can conveniently carry out statement conversion of multiple databases, the operation duration of a computer is shortened, the working efficiency is improved, and therefore economic benefits are brought to companies.

The embodiment of the invention relates to a distributed database technology which can be applied to the field of finance, in particular to a heterogeneous database table structure conversion method and device, electronic equipment and a storage medium. Obtaining a middleware configuration file of the original database and a pre-defined heterogeneous mapping configuration file between the original database and the target database; analyzing the original database and the target database according to the middleware configuration file and the mapping configuration file to obtain original configuration information of the original database and heterogeneous database conversion information between the original database and the target database; and according to the database conversion information, converting the original configuration information into a table establishment statement conforming to a target database structure so as to update a table structure in the original configuration information into the target database. According to the embodiment of the invention, the migration efficiency of the heterogeneous database system is improved, and the labor cost is reduced.

The invention provides a conversion method, system and device of a vehicle diagnosis database and a medium, and belongs to the technical field of vehicles. The method comprises the following steps: initializing a data area of a data file according to a set parameter format, and writing an input diagnosis parameter into the corresponding data area; the data area is defined, the diagnosis parameters correspond to parameter interfaces in a diagnosis database, and the data file is converted into a diagnosis data file of the diagnosis database; based on a test conversion tool arranged in the diagnosis database, generating a test case and a test specification according to the diagnosis data file, and inputting a test project file; and according to the test project file, the test case and the test specification, performing a diagnostic test to obtain a test result and test data. The CDD manual development period and complexity are reduced, the accuracy is improved, and the diagnosis database development efficiency is improved.

This invention relates to the field of database technology, specifically a database conversion method, apparatus, device, medium, and program product. The method includes: obtaining a source SQL statement to be converted from a source database; obtaining conversion strategies corresponding to each keyword to be converted in the source SQL statement, and determining whether conversion strategies corresponding to all keywords to be converted can be obtained; if not, identifying a first keyword to be converted for which no conversion strategy has been obtained, and obtaining a historical conversion record corresponding to the first keyword to be converted; wherein the historical conversion record records conversion operations that convert the first keyword to be converted into a first target keyword in the target database; and converting each keyword to be converted in the source SQL statement based on the conversion strategy or the historical conversion record to obtain a target SQL statement in the target database. The conversion method of this invention can greatly improve the success rate and efficiency of automatic database conversion.

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.

The invention discloses a database pressure test evaluation method for a railway electronic payment platform. The method comprises the following steps: adding a probe between the railway electronic payment platform and a database to carry out transparent collection on full flow of the database; a multi-stage analysis architecture is adopted, database statements of the railway electronic payment platform are analyzed, and an access path and a dependency graph are constructed; aiming at a high-concurrency transaction mode, performing multi-transaction reconstruction, and constructing a transaction pedigree diagram; storing the processed structured high-concurrency data in an object storage mode; for structured high-concurrency database data, after flow reduction is carried out by adopting an automatic database conversion pipeline, through simulation playback in a target database of a railway electronic payment platform, dynamic changes of actual service high concurrency are simulated, and pressure testing and performance evaluation of the target database are executed. By means of the method, SQL statements and concurrency in actual services are truly simulated, and accurate evaluation of database performance is achieved.

The invention discloses a DCS database conversion system and method and a storage medium, and the system comprises an original data storage module, an algorithm analysis module, a rule loading module, an algorithm conversion module and a target data generation module: the original data storage module is used for storing conversion rule data and algorithm attribute data of a source DCS system; the algorithm analysis module is used for identifying algorithm attribute data of the source DCS system and generating a data list; the rule loading module is used for calling the conversion rule data to determine a rule set; the algorithm conversion module is used for converting the algorithm attribute data of the source DCS system based on the conversion rule data; and the target data generation module is used for writing the converted algorithm attribute data into a target database.

A computer-implemented method includes starting on a source database (DB), a software update manager (SUM). DB triggers and log tables are created on the source DB and by the SUM. Creation of a clone DB is initiated, where the clone DB is a clone of the source DB. Using connection data to the clone DB, a connection to the clone DB is tested. Using the SUM and the connection data to the clone DB, initial data from the clone DB is transferred to a target DB. Using the SUM, a delta replay of recorded changes made to the source DB since creation of the clone DB is initiated.