30 results about "Heterogeneous database system" patented technology

The invention relates to a method for achieving automatic synchronization of multi-source heterogeneous data resources. A metadata service node, a service node and a production node are related in the method, the metadata service node is responsible for storing a data dictionary in a distributed heterogeneous database system, the service node is responsible for analyzing user requests in the distributed heterogeneous database system and carrying out synchronization with a database on the production node periodically, and the production node is responsible for requests such as inquiring and updating in a corresponding production application system, wherein the service node is formed by a configuration recognizer, a blog parser and a data synchronizer, the configuration recognizer is used for analyzing the configuration of a source database on the production node and selecting a feasible synchronizing mode, the blog parser is used for analyzing blogs of different dataset systems and is a component for first-phase preparing work of an increment synchronization mode, and the data synchronizer carries out data synchronization according to the synchronizing mode of the configuration recognizer. The method for achieving the automatic synchronization of the multi-source heterogeneous data resources enables the automatic synchronization of the multi-source heterogeneous data resources to be achieved, and can be used in data resource processing.

The invention discloses a database data synchronization method and device and a storage medium, and the method comprises the steps: receiving a transaction submission request message sent by a client under the condition that transaction response results fed back by a plurality of data nodes are successful, and writing a global transaction ID into a transaction processing table; sending the transaction submission request message to the plurality of data nodes; receiving transaction submission results fed back by the plurality of data nodes; and under the condition that transaction submission results fed back by the plurality of data nodes are all successful, applying for releasing the global transaction ID from a global transaction manager. According to the method, data synchronization between the distributed database and the stand-alone database in the heterogeneous database system can be realized, and the problem of inconsistency caused by sending requests to the two databases at the same time is solved by adopting a way of unidirectional synchronization and binding whether the transaction information to be processed is successfully submitted or not with the transaction, and the reliability of data synchronization is greatly improved.

The invention discloses a data format conversion method between isomerous database systems. The method comprises the following steps that 1, network communication among an IBA database, an interface machine and a PI real-time database is set up, and a station number written in the PI real-time database after being converted is defined; 2, a collecting period is set for data of PDA files needing to be collected in the IBA database according to a temporal mode, and a data collecting template is built; 3, a file directory of reading the PDA files in the IBA database is set in IBA datcoordinator software, a file directory where text files are stored is guided out, and the data needing to be collected are converted into the text files; 4, an installation directory of an IBA database file conversion function service program is set up; 5, the text files are converted into text files capable of being recognized by a PI-batch file interface of the PI real-time database, and the final files are transmitted to an output directory and written in the PI real-time database. Through data format conversion between an IBA server and the PI real-time database, data sharing between the isomerous database systems is achieved.

The invention relates to a method for synchronizing real-time data in a heterogeneous database system. The system designs an integrated data layer, a real-time synchronization function between data sources is provided for data from heterogeneous data sources, the heterogeneous data source realizes real-time synchronization in the integrated system structure of the heterogeneous data source, and anexisting heterogeneous data source integration mode is not affected.

The invention discloses a method for processing a task through different workflows among heterogeneous systems. The method includes that a uniform task framework is built between a main system and an auxiliary system in advance, and the uniform task frame packages task basic attributes and is provided with a task registration application programming interface (API), a task obtaining API and a task logout API. The method overcomes the defects of complex experience of users to switch and log in back and forth among a plurality of systems, achieves task uniform revealing, inquiring and calculating among a plurality of heterogeneous systems, and greatly reduces integrating difficulty by calling processing of an original system to process business of a task.

Systems and methods described herein provide heterogeneous access to tenant databases. A delegator intermediary to clients and tenant database receives a request from a client to perform a database related action. The request identifies a query type and tenant identifier. The tenant databases include a first tenant database of a first database type and a second tenant database of a second type. The delegator identifies a tenant database using the tenant identifier from the request. The delegator determines a database type corresponding to the identified tenant database. The delegator selects, from a plurality of drivers corresponding to respective database types, a driver based on a database type for the identified tenant database. The delegator establishes a database connection using the selected driver between the delegator and identified tenant database. The delegator uses the database connection for performing the database related action from the request.

The invention relates to the technical field of cloud databases, in particular to a virtual access management method of a heterogeneous database. According to the virtual access management method of the heterogeneous database, a data control processing framework which comprises a client, a front end and a server side and a functional unit which is oriented to the process and is based on components are provided, component access control management of a heterogeneous database system based on users, roles and the permission is introduced, the process of platforms, the process of resources, the process of channels and the like are accomplished, heterogeneous data source registration, virtual database object registration and virtual resource access are achieved, sharing access management of the heterogeneous database is accomplished, database access details and heterogeneous system multi-source performance are shielded, the uniform data standards and uniform access interfaces are provided, transparent access to data sources is supported, and sharing and uniform management of data resources of a plurality of independent service systems are achieved. The virtual access management method of the heterogeneous database solves the data sharing access problem caused by heterogeneous factors such as the server side, an operating system, a database management system and data structures, and can be used for virtual access management of the heterogeneous database.

The present invention proposes a monitoring system and monitoring method for a heterogeneous database oriented to industrial big data, including a heterogeneous database system, a middleware server, and a Web monitoring platform; the heterogeneous database system and the middleware server communicate with each other , the middleware server communicates data with the Web monitoring platform through a database. The present invention uses a visual interactive mode combined with a data analysis format with low learning costs, allowing managers to quickly access new data sources by themselves, reducing the number of secondary developments of the system, and improving the practicability and stability of online information sex.

The invention discloses a data format conversion method between isomerous database systems. The method comprises the following steps that 1, network communication among an IBA database, an interface machine and a PI real-time database is set up, and a station number written in the PI real-time database after being converted is defined; 2, a collecting period is set for data of PDA files needing to be collected in the IBA database according to a temporal mode, and a data collecting template is built; 3, a file directory of reading the PDA files in the IBA database is set in IBA datcoordinator software, a file directory where text files are stored is guided out, and the data needing to be collected are converted into the text files; 4, an installation directory of an IBA database file conversion function service program is set up; 5, the text files are converted into text files capable of being recognized by a PI-batch file interface of the PI real-time database, and the final files are transmitted to an output directory and written in the PI real-time database. Through data format conversion between an IBA server and the PI real-time database, data sharing between the isomerous database systems is achieved.

The object of the present application is to provide a CPU-GPU based load balancing method and apparatus. A pipelined query execution model is constructed on the GPU-GPU heterogeneous database system,so that CPU-GPU heterogeneous data analysis system can support query analysis in big data scenario; determining the total number of pipelines to be executed; starting the pipeline query execution model to allocate the pipeline corresponding to the total number to the CPU and the GPU, and calculating the system execution time corresponding to all load distribution strategies according to the determined execution time of a single pipeline on the CPU and the GPU respectively; finally, the load distribution strategy corresponding to the minimum value of the execution time of all the systems is determined as the optimal CPU-GPU allocation strategy,the load balancing strategy of the CPU-GPU heterogeneous data analysis system can reasonably distribute pipeline load to different processors, make full use of processor computing resources, not only improve the system performance, but also make the system achieve the best overall performance.