33 results about "Database conversion" patented technology

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 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 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 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, 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 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 present invention relates to the general analysis method of FC-AE-ASM data based on the product interface control file, including the interface control file database conversion method, the data analysis method, the database conversion method includes the steps of dividing the data type, establishing the general list of message names, and establishing data information Table, establishment of discrete signal table, data parsing method, including steps: establishing structure array, reading MsgID, comparing MsgID and message number field, obtaining data length according to element type, obtaining discrete signal data value, obtaining data signal data value. The present invention can be applied to all product automatic test systems containing FC-AE-ASM data, and has strong versatility; when the product state changes, only the corresponding content of the interface control file database needs to be changed, and the automatic test system will not be affected.

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.

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 discloses a big data system and method for converting traditional database scripts to the cloud in batches. The system includes: a syntax parser module, a conversion mapping module between heterogeneous databases, and a script conversion module. Beneficial effects: the present invention quickly and accurately identifies and extracts the business SQL that needs to be transformed, and converts and recognizes the syntax on the cloud according to the needs, and performs syntax reconstruction and transformation on the SQL, with a success rate of over 96.7%, and an accuracy rate of semantic extraction, recognition, and syntax transformation of up to More than 85.4%.

The present invention provides a real-time updateable automatic conversion method of the track line database, comprising: the line database automatic conversion platform sends a LKJ line data request to the LKJ host; the LKJ host receives the request from the line database automatic conversion platform, and sends The line database automatic conversion platform sends LKJ line data; the line database automatic conversion platform receives the LKJ line data sent by the LKJ host; the line database automatic conversion platform reads the preset LKJ line data conversion configuration file, and the LKJ The line data conversion configuration file includes: a train operation area index table, an area line parameter table; the line database automatic conversion platform converts the LKJ line data according to the train operation area index table and the area line parameter table; the line database automatically The conversion platform classifies and stores the converted train operation area line data. The invention improves the conversion and updating efficiency of the database and reduces the risk of data errors.

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 discloses a synchronizing system for database conversion and a method for the same. The system comprises a database converter and a data network bridge, wherein the database converter can convert tables in a source database to a target database. The data network bridge comprises an instruction analysis unit, a storage unit and a synchronous control unit, wherein the instruction analysis unit receives a database query instruction and analyzes the enquired table related to the database query instruction; the storage unit temporarily stores the database query instruction; and the synchronous control unit decides a query mechanism and receives a conversion state of the inquired table returned by the database converter, and the synchronous control unit executes the database query instruction to the source database or the target database of both the two databases according to the query mechanism and the conversion state.