Heterogeneous information system data analysis and integration method with high self-control performance

Abstract

The invention relates to a heterogeneous information system data analysis and integration method with high self-control performance. A main control module is deployed on a server and consists of a Website and a data processing service; the Web site is used for providing a visual operation interface; a data processing service in the main control module is used for providing database creation, datatable creation, data table deletion, data insertion, data deletion, data updating and data query operation; the central database is deployed on the server and used for storing data extracted from theservice system; the agent service module is deployed on a server where a to-be-integrated business system is located and is composed of a data processing service and a configuration file. A data processing service in the agent service module provides data source detection, database table query and data extraction operation. In the invention, all people of the service system can effectively control whether the data is shared or not and who share and share the contents, and do not need to provide a database user name and a password to the outside, so that dangerous operation is avoided.

Description

technical field [0001] The invention belongs to the field of information technology, and in particular relates to a highly self-controlling heterogeneous information system data analysis and integration method. Background technique [0002] With the development and application of cloud computing and big data technology, more and more enterprises and institutions realize the importance of data assets. Collecting and analyzing data to dig out the important information contained in the data has become the priority of information management departments of many units. important work tasks. After years of informatization construction, there are currently a large number of information systems in each unit, and various business data, asset data, and personnel data are stored in various systems. Due to the system architecture, development language, and database of these systems during research and development The designs are all different, and there is a lack of a unified top-level ...

AI Technical Summary

Problems solved by technology

[0003] At present, there are already many data integration software that can realize the analysis and integration of heterogeneous data. The method adopted is to deploy data analysis and integration software on the main server, and then remotely connect to the database of the business system to be integrated, and perform data extraction remotely. and mining, this method has the following deficiencies: first, the analysis and integration software on the server side needs to obtain the user name and password of the business system database, and all operation rights to the business database will affect the data security of the business system; The business system to be integrated loses the right to manage its own data, and does not know who extracted its own data, what data was extracted, and how much data

Images