Figure 4 - uploaded by Azwa Abdul Aziz
Content may be subject to copyright.
Result from stuinfo (ORACLE DBMS)  

Result from stuinfo (ORACLE DBMS)  

Source publication
Article
Full-text available
Data warehouse (DW) can be considered as the most significant tool for strategic decision making. However, in academic environment, the components of data warehouse still have not been completely utilized. The aim of this paper is to design and implement ETL processes through the data integration of heterogeneous databases using TOS in academic env...

Context in source publication

Context 1
... SQL statement can be manipulated to choose entities with particular attribute to perform analysis. Figure 4 shows the results in stuinfo table that have been generated using SQL statement to Oracle DBMS. The result is shows all data in. ...

Citations

... By doing this we are able to integrate various sources of heterogeneous academic data sample and populate them in one central repository using Talend Open Studio and Big Data (TOS). It is important to ensure the capabilities of open source ETL are equal to any commercial products available, because it will help in implementing DW project with lower costs [1]. Based on the feature of data warehouse system separation, the ETL processes have to be done on a different database, which is independent from the source and the data warehouse. ...
Article
Full-text available
Taking into account the problems and challenges which the Emergency Management Agency (EMA) is facing today, and the way operational data scattered across various institutions is being used, we have set an hypothesis to build a DataMart, which has the capability for deep and detailed data analysis. Here we shall present the step by step modeling of this DataMart, following the Kimball model, which will be useful for detailed analysis by medical, hydro-meteorological and seismic institutes. In collecting, transforming and loading the data we have applied the ETL methods, which are considered as the most critical tasks in building a DWH system. Then the development of a professional modeling in Talend Open Studio for Big Data, which enabled the integration of data from many data sources. In addition to this, we will have the possibility to synchronize and build the data in a way that DWH will be able to communicate in real time, something which has not been possible until now in the field of emergency management
... Managing an institution involves access to information in order to monitor the institution actions [1]. Growing capacities of client populations can bring difficulties to an institution due the complexity in the process of handling various data. ...
Article
Full-text available
Business Intelligence (BI) is the process of getting the right information to the right decision makers at the right time and in the right format. It is a platform that supports analysis, reporting and decision making. Educational Business Intelligence (EduBI) architecture utilizes BI technologies to integrate various sources of academic data into a single repository (Educational Data Warehouse – EDW). BI is a useful tool since it reinforces the process of performance and analysis evaluation that is required within all levels of educational environment. Nowadays, there are various BI products ranging from simple reporting technologies to sophisticated BI platforms. Selection of a BI tool deemed appropriate for a particular task may turn out to be difficult; hence careful considerations must be made in the selection process. This paper proposed an EDW architecture that employs the integration of proprietary and open source BI tools.