Multi-source multi-base enterprise innovation monitoring big-data standard database construction method

Abstract

The invention provides a multi-source multi-base enterprise innovation monitoring big-data standard database construction method. The method includes the steps of: carrying out multi-source multi-base index screening; establishing a standardized comprehensive index dictionary according to multi-source multi-base index connotations and characterization contents to enable the standardized index dictionary to cover all multi-source multi-base indexes; constructing one-to-one correspondence relationships between the multi-source multi-base indexes and the standard index dictionary; and collecting and importing multi-source multi-base data information according to the standardized comprehensive index dictionary and the constructed one-to-one correspondence relationships between the multi-source multi-base indexes and the standard index dictionary, and establishing a complete big-data information index database. The construction method is simple and flexible, and is high in adaptability.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for constructing a multi-source and multi-database enterprise innovation monitoring big data standard database. Background technique [0002] For enterprise information databases, different government departments have different statistical calibers, and the same department also has multiple data sources. A high-tech enterprise information exists in multiple departments, multiple information systems, and multiple information tables. In order to establish a high-tech enterprise Information big data information database, to carry out operation information monitoring, it is necessary to extract multiple forms of data information, the existing method is to establish a big data information database containing all indicators of all forms of all information system databases. [0003] This method needs to establish a large number of cross-repeated index data in the database. Th...

AI Technical Summary

Problems solved by technology

[0003] This method needs to establish a large number of cross-repeated index data in the database. The database index dictionary is huge. On this basis, the data information of the corresponding index is extracted according to the monitoring requirements for calculation and monitoring. The database monitoring calculation module designs multiple extraction table indicators. Information, the form where the index information is extracted is dynamically changing, the connotation of the same index is not exactly the same, and the index monitoring and calculation function is solidified across multiple form modules. For an annual form data, it is necessary to develop an index calculation and monitoring module. The index calculation and monitoring function The modules are complex and cannot adapt to the adjustment of form structure and form indicators that may occur at any time in the future

Images