期刊名称：Journal of Theoretical and Applied Information Technology
印刷版ISSN：1992-8645
电子版ISSN：1817-3195
出版年度：2014
卷号：67
期号：3
出版社：Journal of Theoretical and Applied
摘要：Established in 17 July 2013, Telkom University was formed from various faculties from Telkom Education Foundation, such as Faculty of Engineering (TES), Faculty of Management (TEBS), Faculty of Applied Sciences (TASS) and the Faculty of Creative Industries (TCIS). Each faculty has the Academic Information Systems. When it became a university, problems faced is how to do the integration strategy of academic data from the different data structure and data sources of academic information system at each faculty into one new scheme of University database. The challenge is the old academic system is still running for one semester, which means the data will still moving. Therefore, this study focuses on both strategic and technical concepts to integrate academic data base on that condition. A major strategy is using web services for data interchange and PL SQL Scheduler to process transaction data which still moving. Meanwhile, master data is loaded only once with flat files format. The conclusions obtained from this research are 1) to integrate academic data, logic data needed to be split into master data and transaction data, 2) the strategy for integrate master data are loaded only once with flat files format, meanwhile the transaction data is loaded many times via web services (JSON), 3) transaction data from web services will be loaded and mapping into destination database using JSON PL SQL package which run periodically.
关键词：Academic Data Integration; Web Services; JSON; PL SQL; DBMS Scheduler
