Method, device and heterogeneous database system for generating heterogeneous database report

Abstract

The embodiment of the invention provides a method for generating a heterogeneous database report, which is used for solving the problem that because the prior art can not support the connection of heterogeneous databases or the single connection type consumes resources, report data can not be acquired from service scenes of multi-dimensional application. The method comprises the following steps: establishing database connection with each heterogeneous database, and saving the database connection in the database connection pool of each heterogeneous database as a database connection object; acquiring data in each heterogeneous database through the database connection pool of each heterogeneous database; and integrating the data in each heterogeneous database into a data model which can be recognized by the report, and then, showing the data. The invention can efficiently acquire the data in each heterogeneous database, save the server resources and reduce the system overhead, and the integration of the data in each heterogeneous database can also enable the data to be synchronously shown in the report through the same model.

Description

technical field [0001] The invention relates to the computer field, in particular to a heterogeneous database report generation method, device and heterogeneous database system. Background technique [0002] A conglomerate organization has branches in many locations, each branch has its own information data in the database, or, in order to maintain the relative independence of its operation, each functional department often establishes a own database. The databases established by various branches or functional departments can be regarded as heterogeneous databases, that is, each database may run on different computer architectures, such as mainframes, minicomputers, workstations, personal computers or embedded It is also possible that the operating system of each database is different, for example, Unix, Windows NT, Linux, etc.; or, the database management system (DBMS, DataBase Management System) of each database itself has heterogeneity, for example, each database can be ...

AI Technical Summary

Problems solved by technology

[0005] Embodiments of the present invention provide a heterogeneous database report generation method, device, and heterogeneous database system to solve the problem that the prior art cannot meet the requirement that the report data come from multiple dimensions because it does not support the connection of heterogeneous databases or consumes resources in a single connection mode. The problem of the business scenario of the application

Images