Method and device for processing data

Abstract

An embodiment of the invention discloses a method and a device for processing data. The method and the device are used for supporting authorization of data from a plurality of systems or databases, reducing maintenance costs of the systems, embodying data update in real time and increasing the data processing speed. The method includes receiving dimension entity data in the various databases via preset database interfaces of various data sources; generating authorization dimension data of the dimension entity data according to preliminarily determined data dimensions, and storing the authorization dimension data in an authorization dimension data set; converting feature information of users into character string formats, and corresponding the character string formats to the authorization dimension data in the authorization dimension data set; reading the authorization dimension data corresponding to feature information in the authorization dimension data set according to the feature information inputted when users log in; and reading the dimension entity data corresponding to the read authorization dimension data.

Description

technical field [0001] The present invention relates to the field of information technology, in particular to a data processing method and device. Background technique [0002] In the field of information technology, there are many data sources for data analysis, which may come from the enterprise resource planning (ERP, Enterprise Resource Planning) system that supports the SQL Server relational database management system, or manually maintained Excel tables, or groups, The company supports different data types of the ERP system of the Oracle database, and the basic data information is not uniform. [0003] In the information system data authorization system, if data outside the system is to be supported to participate in the data authorization of the system itself, the data outside the system must first be converted into internal data of the system before data authorization can be performed. At present, the solution to transform the external data of the system into the in...

AI Technical Summary

Problems solved by technology

[0004] In the above technical solution, the external data of the system must be converted into the internal data of the system before data authorization can be performed. When the external data of the system is updated, it must be re-imported into the system for authorization. The entire import and authorization process requires fixed personnel to spend a fixed amount of time Maintenance costs are relatively high, and data updates cannot be reflected in real time

Images