现代电子技术

企业的信息系统是一个由传统系统、不兼容数据源、数据库与应用所共同构成的复杂数据集合,各部分之间彼此独立。为了保证智能决策的需要,对数据源中的源数据按照一定的数据转换原则进行映射和转换,通过对异构数据源的抽取、转换、装载,从已有传统环境与平台中采集数据进而形成目标数据源,并使用存储过程、触发器、中间表和动态SQL语句进行查询优化,采用哈希表存储解析后的数据,初步建立数据仓库,实现数据聚合。结合角色控制的方法对目标数据源进行多维度报表展示,将海量的应用数据转换为有价值的信息,为企业智能决策提供有效的数据支持。

Enterprise information system is a complex data set consisting of the traditional system,incompatible data sources,database and application. They are isolated with each other. In order to guarantee the need of intelligent decision-making,the metadata in data sources is mapped and transformed according to certain principle of data transformation,data is collected from traditional environment and platform by extraction,transformation and loading of heterogeneous data source,and then the target data source is generated,which is queried and optimized by using stored procedure,trigger,middle table and dynamic SQL. The resolved data is stored by hash table,and then the database is built preliminary to achieve data aggregation. The exhibition of multidimensional report of target data source is conducted with role-based access control method to convert massive data into valuable information,which can provide an effective data support for enterprise's intelligent decision-making.