03 Sep 07 Tugas Mhs SARMAG: Talend (data integration)

Tugas Mhs SARMAG, Matakuliah SIM

1. Introduction
2. Getting started with Talend Open Studio
3. Components
4. Designing Business Model and Job Design
5. Strength and Weakness
6. Conclusion

Introduction

Talend is the first provider of Open Source software tools for the ETL market. The company provides solutions that break rank with the market by supplying open, innovative and more powerful software. Talend’s software is distributed under Open Source license. The company’s flagship product, Talend Open Studio, has been downloaded over 30,000 times since its launch four months ago.

Talend Open Studio is an Open source solution for Data Integration operations such as data warehouse feeding, database synchronization, data transformation and integrity check. Its GUI based on Eclipse. RCP is made of a metadata, repository and a graphical designer. Data related scripts and underlying programs are generated in Perl since v1.0 and also in Java. Since v2.0. Talend Open Studio is distributed under GPLv2. General function of Talend is as a business model, job design, metadata manager.

Talend’s Open Source data integration solutions cater to a broad range of data integration needs, which include:

1. Data migration: every time an application is replaced with another one, or a database is converted to a different technology or to a newer version, or a new application is deployed, data needs to be migrated and/or loaded in the new system. Along the way, because data schemas seldom match, data transformations must take place. The migrated data may also need to be enriched from external sources, and cleansed to ensure its quality.
2. Data synchronization: the vast majority of applications and databases in the information system need to exchange data with other applications or databases. Latencies can vary from infrequent batches to right-time or near-real-time updates. Complexity can range from a simple unidirectional flow of data between two systems, all the way to a multiple providers to multiple consumers mode.
3. Operational data integration: in most organizations, operational data integration is addressed by implementing custom programs or routines, completed on-demand for a specific need. Data migration/loading and data synchronization/replication are the most common applications of operational data integration.
4. ETL for Business Intelligence and Data Warehousing: ETL (Extract, Transform, Load) processes collect data from heterogeneous source systems, cleanse this data, consolidate it, apply transformations, and load it in the data warehouse, data marts, OLAP (On-Line Analytical Processing) structures, and analytical applications.

Reading the report here

03 Sep 07 Tugas Mhs Sarmag: UPPAAL

Tugas Mhs SARMAG, mata kuliah SISTEM INFORMASI MANAJEMEN

INTRODUCTION

UPPAAL is an integrated tool environment for modeling, simulation and verification of real time system modeled as network of timed automata. The first prototype of UPPAAL named TAB, was developed at Uppsala University in 1993 by Wang Yi et.al. In 1995, Aalborg University was joined the development and then TAB was renamed UPPAAL with UPP standing for Uppsala and AAL for Aalborg.

It serves as a modeling or design language to describe system behavior as networks of automata extended with clock and data variables. It used to make a simulation of the system and check if there is an error in the system.

UPPAAL’s Features

A graphical interface allowing networks of timed automata to be defined by drawing. An automatic compilation of the graphical definition into a textual format used by the model-checker, thus supporting the important principle “what you see is what your verify”. Compilation of certain types of hybrid automata into ordinary timed automata.

In case verification of a particular real-time system fails, a diagnostic trace is automatically reported by uppaal.

Reading the report here