CAJ | 학술논문

企业的信息系统是一个由传统系统、不兼容数据源、数据库与应用所共同构成的复杂数据集合，各部分之间彼此独立。为了保证智能决策的需要，对数据源中的源数据按照一定的数据转换原则进行映射和转换，通过对异构数据源的抽取、转换、装载，从已有传统环境与平台中采集数据进而形成目标数据源，并使用存储过程、触发器、中间表和动态SQL语句进行查询优化，采用哈希表存储解析后的数据，初步建立数据仓库，实现数据聚合。结合角色控制的方法对目标数据源进行多维度报表展示，将海量的应用数据转换为有价值的信息，为企业智能决策提供有效的数据支持。
기업적신식계통시일개유전통계통、불겸용수거원、수거고여응용소공동구성적복잡수거집합，각부분지간피차독립。위료보증지능결책적수요，대수거원중적원수거안조일정적수거전환원칙진행영사화전환，통과대이구수거원적추취、전환、장재，종이유전통배경여평태중채집수거진이형성목표수거원，병사용존저과정、촉발기、중간표화동태SQL어구진행사순우화，채용합희표존저해석후적수거，초보건립수거창고，실현수거취합。결합각색공제적방법대목표수거원진행다유도보표전시，장해량적응용수거전환위유개치적신식，위기업지능결책제공유효적수거지지。
Enterprise information system is a complex data set consisting of the traditional system,incompatible data sourc?es,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 exhi?bition of multidimensional report of target data source is conducted with role?based access control method to convert massive da?ta into valuable information,which can provide an effective data support for enterprise’s intelligent decision?making.