33 results about "Database conversion" patented technology

A database conversion engine comprising a method and system to convert business information residing on one system to another system. A generic, extensible, scalable conversion engine may perform conversion of source data to target data as per mapping instructions / specifications, target schema specifications, and a source extract format specification without the need for code changes to the engine itself for subsequent conversions. A scheduler component may implement a scalable architecture capable of voluminous data crunching operations. Multi-level validation of the incoming source, data may also be provided by the system. A mechanism may provide data feeds to third-party systems as a part of business data conversion. An English-like, XML-based (extensible markup language), user-friendly, extensible data markup language may be further provided to specify the mapping instructions directly or via a GUI (graphical user interface). The system and method employs a business-centric approach to data conversion that determines the basic business object that is the building block of a given conversion. This approach facilitates identification of basic minimum required data for conversion leading to efficiencies in volume of data, performance, validations, reusability, and conversion turnover time.

The embodiment of the invention discloses a heterogeneous database conversion method apparatus and device and a storage medium. The method comprises the steps of obtaining a to-be-converted DDL statement and a to-be-converted DML statement associated with a source data table in a source database; respectively converting the to-be-converted DDL statement and the to-be-converted DML statement into atarget DDL statement and a target DML statement which conform to a target database grammar rule; and synchronizing the source data table in the target database according to the target DDL statement and the target DML statement to obtain a converted target data table. According to the embodiment of the invention, different types of database operation languages are converted. Mutual conversion between various types of databases can be supported. CAn independent database conversion service is provided outwards so that compatibility and flexibility of database conversion are improved. Limits of database types and conversion directions iare avoided, dual conversion of the source data table, the grammatical rules and the data content of the source database is achieved, and conversion efficiency of the database is improved.

The invention discloses an engineering application oriented body establishment management and body data automatic obtaining method. The method comprises a reasoning module, a body establishment module, a database conversion module, a database storage module and a body knowledge invoking service module. The body establishment module stores and manages bodies by using distributed body storage files, wherein the distributed body storage files comprise logic layer body files, data layer body files and management layer body files. After the reasoning module obtains a search request sent by the body knowledge invoking service module, the management layer files of the body establishment module screen data body files in a body library by management logic and provides the screened data body files for the logic layer body files. The logic layer files search demanded information from the screened body files according to reasoning logic and provide the demanded information for the reasoning module. According to the method, the data management efficiency can be improved, and an effective method is provided to engineering application of a semantic web technique.

The invention relates to a database conversion and cleaning information processing method, which comprises the following steps of: 1) connecting a target database to a data source; 2) selecting a target data table to be cleaned in the target database; 3) selecting an update mode, executing the fourth step if the incremental update is adopted, and executing the tenth step if the total update is adopted; 4) obtaining the maximum update time last_update in the target data table, and defaulting the last_update as the set time if the target data table is null; 5) screening all records with the update time greater than the last_update in the data source to a temporary table temp_table; 6) deleting repeated records in the temp_table by restraining fields in the target data table; 7) comparing the target data table and the temp_table and obtaining the records of the temp_table in the target data table, and the like. Compared with the prior art, the method has the advantages that the problems of data repetitiveness and omission in the data cleaning process are effectively avoided, the data consistency and the completeness are ensured, and the like.

Methods, apparatus, and other embodiments facilitate transitioning a database between two modes. The two modes include a mode where table information for separate tables in the database is stored in a single monolithic file and a mode where the table information for separate tables is stored in separate files. Conventional attempts to make this type of transition lock the database for an unacceptable amount of time. Example methods and apparatus make a copy of a database that is to be transitioned, lock the copy, make a second instance of the copy, and then perform the work necessary for the transition in the second instance. This allows the original database to remain running. When the second instance is complete, the second instance is synchronized to the original database and then the transition is completed by copying the second instance to the original or failing the original over to the second instance.

The present invention provides an automatic conversion method of a track line database which can be updated in real time. The method comprises that: a line database automatic conversion platform transmits an LKJ line data request to an LKJ host; the LKJ host receives the request from the line database automatic conversion platform, and transmits LKJ line data to the line database automatic conversion platform; the line database automatic conversion platform receives the LKJ line data transmitted by the LKJ host; the line database automatic conversion platform reads a pre-set LKJ line data conversion configuration file, wherein the LKJ line data conversion configuration file comprises a train running area index table and an area line parameter table; the line database automatic conversion platform converts the LKJ line data according to the train running area index table and the area line parameter table; and the line database automatic conversion platform carries out sorted storing on the converted train running area line data. According to the method and system provided by the present invention, the database conversion update efficiency is improved and the data error risk is reduced.

The invention relates to a general FC-AE-ASM data analysis method based on product interface control files. The general FC-AE-ASM data analysis method comprises an interface control file database conversion method, wherein the database conversion method comprises the steps of data type partitioning, general message name table creating, data information table creating and discrete signal table creating; and a data analysis method, wherein the data analysis method comprises the steps of structure array creating, MsgID reading, MsgID and message number field comparing, data length acquiring according to element types, discrete signal data value acquiring and data signal data value acquiring. The eneral FC-AE-ASM data analysis method can be applied to an automated testing system for all products containing FC-AE-ASE data and is high in generality; and when the product state changes, only corresponding content of an interface control file database needs to be changed, and no influence can be caused on the automated testing system.

The invention discloses a database visit method and system. The database visit method comprises steps of arranging a database agent, receiving a database visit request sent by a client end via the database agent, visit the database, controlling the database agent to dynamically change a database practically visited by the client end, converting master and spare databases, and transmitting the database visit request to a normally-working master database or a spare database. Master and spare database conversion can be realized when the database practically visited by the client end is dynamically changed by the database agent. Without the use of virtual network addresses, network address conflicts due to failures of unload of the virtual network address, or faults due to failures of reception of address resolution protocols by the client end can be prevented; and database visit reliability can be greatly enhanced.

A system and method for converting legacy program code to up to date program code is provided. The system and method includes a compiler having four modules—a parser, a transformer, an optimizer, and a code generator. The parser reads the code and analyzes the code by identifying key words, identifying key contextual indicators, and identifying inefficiencies in the code. The transformer translates the legacy program code to the up to date program code using a translation table. The optimizer reduces inefficiencies in the transformed code.

The invention discloses a mixed backup restoration management system used for database version control and virtualization and having a database conversion capability, and a backup method and a restoration method therefor. The mixed backup restoration management system comprises at least one piece of original storage equipment, at least one piece of target storage equipment, a database management sub system and a conversion module. Based on the advantage of high data transmission speed in a volume level format, habitual backup restoration programs and interfaces can be seem by a database administrator; and through certain insertion modules, the existing database management system is maintained, so that rapid backup restoration is achieved.

The present invention relates to a multiplanguage multiple inner code type database conversion method. Said method includes the following steps: firstly, polling original database archive and defining its type, then analyzing field of said original database archive and inner code type, and respectively extracting data of said original database archive according to the field, then making the data of extracted every field generate a new data file and converting it into local code to make storage.

The invention discloses an IEC61850-based distributed power supply monitoring management system comprising an IEC61850 standard database. A first communication interface of the IEC61850 standard database is connected with an intelligent equipment communication module capable of compatible with an IEC61850 standard; a second communication interface of the IEC61850 standard database is connected with a traditional universal database conversion module and is connected with a non-IEC61850-standard intelligent equipment communication interface by the traditional universal database conversion module. With different communication media and communication protocols, information collection and processing of various power generating devices, control devices, and monitoring devices in a power station; information is gathered and process and then is uploaded to an access control main station; various scheduling instructions sent by the access control main station are received simultaneously; and a corresponding control sequence is generated automatically according to the scheduling instructions. Therefore, automatic controlling of various devices in a distributed power station is completed.

A system and method to automatically generate source code for moving and transforming data stored in a source database defined according to a first data model to a target database defined according to a second data model. At least one data mapping expression between the first data model to a conceptual module and at least one mapping and transformation definition between the conceptual model and the second data model are provided. Data Definition Language code is automatically generated for defining the target database based on the at least one data mapping expression and the second data model. Extract, Transform, Load (ETL) code is automatically generated for extracting data from the source database, transforming the data, and loading the transformed data into the target database. The ETL code based on the at least one mapping expression and the at least one mapping and transformation definition.

A system, method and article of formatted information and data exchange for universal, modular, data conversion from one relational database to another, while bypassing any formatting on the source database.

A system, method and article of formatted information and data exchange for universal, modular, data conversion from one relational database to another, while bypassing any formatting on the source database.

The invention relates to the field of database conversion, in particular to a database data conversion method based on quantum computing. A quantum cloud platform manager comprises a memory, a processor, a security module, an identification module and a decoding module, the memory is used for storing data, when the number of databases is large, part of the data can be stored firstly, next identification and decoding are carried out after identification and decoding are completed, and the risk of omission is reduced; meanwhile, the security module comprises a detection unit and a processing unit, the detection unit is used for detecting data, and when dangerous data or data with viruses are detected, the processing unit processes the dangerous data or the data with the viruses, so that thedangerous data or the data with the viruses are prevented from entering a database conversion tool. When the converted data is analyzed, a target database architecture is reshaped, a standard data file is generated, data output is carried out, and after data output fails, the data is returned to the database conversion tool until data output succeeds, so that the phenomenon of output failure is avoided.

The invention discloses a universal database conversion device, which comprises a database creation module, an analysis module and a reverse module. The database creation module receives an edited database design file, calls the analysis module to analyze design statements in the database design file line by line and generates corresponding SQL statements, and executes the SQL statements to create a database object; the reverse module reversely generates the database design file from a target database. The device can be compatible with various database types, can be repeatedly executed when the database is created, can automatically judge whether a database object exists or not, and does not create existing database objects any more, so that execution errors are avoided. An instance database can be converted into a design document, and the original design is compared with a reversely generated document, so that the data standard implementation of each industry is further checked. Therefore, the efficiency of creating the database is improved, and the maintenance cost is also reduced.

The invention relates to the field of CAN communication, in particular to a self-adaptive conversion method and device for converting a CAN communication matrix database into a DBC file. According tothe self-adaptive database conversion method and device, the method comprises the following steps: (1) reading a target communication matrix database file; (2) identifying a target communication matrix database architecture; (3) remodeling a target communication matrix database; and (4) analyzing the database information and generating a corresponding standard DBC file. The device is system software which is based on computer programming, combines technologies of multi-target recognition, architecture recognition, architecture remodeling and the like, and realizes adaptive conversion of CAN communication databases with different architectures. The method has the characteristics of good architecture adaptability, friendly GUI interface, simple operation, high conversion quality and efficiency and the like. Compared with the prior art, the method has the advantages that manual modification or adjustment of CAN communication database information is reduced as much as possible, manual editing errors are avoided to the maximum extent, the DBC manufacturing time is greatly saved, the DBC manufacturing efficiency is better improved, and the professional labor cost is reduced.

The invention relates to a system and a method for generating a digital word database. The generation system comprises a first digital word database, a second digital word database, a first chosen module, a second chosen module, a temporary storage module, a judgment module, a part-of-speech analysis module and an integrate module, wherein the first chosen module selects a second language vocabulary entry from the first digital word database; a word meaning analyzing module selects a first language word meaning as at least a first language vocabulary entry according to the second language vocabulary entry; the judgment module judges whether all second language vocabulary entries in the first digital word database are selected as the chosen second language vocabulary entries by the first chosen module; the second chosen module selects at least chosen first language vocabulary entry when the first chosen module selects all second language vocabulary entries in the first digital word database as the chosen second language vocabulary entries; the integrate module carries out integration after the part-of-speech analysis module completes classified ordering; and the second digital worddatabase is generated by storing the integrated vocabulary entries. When used, the generation system can solve the problems of digital word database conversion and generation so as to increase the generation efficiency of digital word databases and the utilization rate of data in the digital word databases.

The invention discloses a parallel processing method for industrial big data heterogeneous data. The method comprises the following steps: firstly, performing type conversion through a database conversion tool, accessing a source database system, and then performing data recombination; after data conversion is carried out, converting all information needing to be shared in the source database modeinto a target database, wherein the conversion cannot contain redundant associated information; adopting a heterogeneous database system constructed by a database conversion tool to realize combination and sharing of data information, equipment resources and human resources among different databases; adopting a distributed database system to solve the problem of data parallel processing; and finally, adopting a multi-database management system to operate and maintain a database system. The invention relates to the technical field of industrial big data. According to the parallel processing method for the industrial big data heterogeneous data, the problem of heterogeneous big data parallel processing in the existing industrial field is solved, and the reliability and expandability of dataprocessing are ensured.

The invention provides a database conversion method. The method comprises the following steps: acquiring a first database, a second database and to-be-converted data, and respectively extracting a first data record and a second data record from the first database and the second database; constructing an intermediate database according to the first data record and the second data record, converting the first database according to the intermediate database, storing the converted data into a second database, and generating a corresponding data conversion comparison table; acquiring a data conversion comparison table of the second database, converting the to-be-converted data according to the data conversion comparison table and saving the data into the second database. The first database is converted by constructing the intermediate database, the to-be-converted data is stored in the second database, and meanwhile the corresponding data conversion comparison table is generated; the conversion efficiency of the to-be-converted data can be effectively improved, and meanwhile the database conversion speed when multiple databases exist is increased.

The invention relates to a database conversion method, which is suitable for converting a first database of a host computer into a second database of a mobile electronic device, wherein the first database is provided with a plurality of initial fields. The method comprises: firstly, newly adding a plurality of main fields and a composite filed into the second database, wherein the main fields correspond to at least one among the initial fields respectively; the main fields and the composite field are used for displaying data in the initial fields; and data displayed in the composite field is mutually distinguished through a separator; and secondly, writing data of various fields of the first database into corresponding main fields or the composite field of the second database. From another angle, the invention also discloses a compressible database structure and a database conversion system.

The invention discloses a multi-tenant database system supporting data model switching. The multi-tenant database system is divided into three layers: a database driving layer, a database conversion layer and a database storage layer, the database storage layer is provided with a plurality of database instance storage spaces containing different data models and tenant metadatabase instances; the database conversion layer mainly comprises two functional entities: a data model conversion module and a database management monitoring module; the database management monitoring module comprises a manager and a monitor; the manager has the functions of tenant demand management and database instance space management; the monitor has a database instance monitoring function and a tenant data monitoring function; the data model conversion module adopts data thermal migration; the database driving layer mainly comprises a data query rewriting module which provides a query rewriting function for data query applied by tenants. According to the method, the fine-grained data storage requirements of different tenants are met, flexible change of the requirements is supported, and meanwhile the operation cost of service providers is reduced.

The invention relates to the technical field of data joint query, in particular to a multi-data-source joint query method based on a global data dictionary, which comprises the following steps of: pre-corresponding to different types of databases, connecting data sources by using drivers corresponding to the databases in a driver layer, and performing primary data integration and cleaning on a data layer; the method comprises the following steps of: selecting a data layer, extracting a data dictionary in the data layer, taking the data dictionary extracted from the data layer as a layer higher than the data layer, uniformly managing and controlling data tables in different data sources by the data dictionary, and adding corresponding indexes to the data tables of the different data sources by an application layer by controlling the data dictionary; according to the data source joint query method based on the data dictionary, global data can be integrally managed, the problems of database conversion and query waiting are avoided, and various different data sources are conveniently and quickly managed through a unified application layer, so that the query speed is high, and the data analysis effect is good.

The invention provides a database conversion device, which comprises a statement acquisition module for acquiring source SQL statements of a storage process and a non-storage process of a to-be-converted database table; a storage process conversion module used for converting the source SQL statement of the to-be-converted database table storage process into a target SQL statement of a target database table storage process; a non-storage process conversion module used for converting the source SQL statement of the non-storage process of the to-be-converted database table into a target SQL statement of the non-storage process of the target database table; and a data migration module used for generating the target database according to the target SQL statements of the storage process and the non-storage process of the target database table. The invention further discloses a database conversion method, a computer system and a storage medium.