Huong Thu Morris

Bringing Business Objects into Extract-Transform-Load (ETL) Technology

Business objects represent the key concepts that a business needs to operate such as people, services, products, etc. but transforming these objects to and from existing data models can be difficult. Business objects have traditionally been represented in a backend data store using relational databases, and techniques for transformation must work with these stores. But such access may violate the encapsulation these business objects require, and so conventional approaches may not provide an adequate solution. In this paper, we examine how to use Extract-Transform-Load (ETL) tools to provide business object transformations. We show how to solve some of these issues by using pluggable components and introduce customized operators for ETL tools. We demonstrate our solution using a commercial ETL system that allows access to several Product Data Management systems and illustrate the use of our technique with several case studies drawn from various industries.

Community Situational Awareness and Resilience through Mobile Applications

Access to social networks via portable devices promises to be especially valuable for public communities. Because smart phones increasingly accompany community members wherever they are, the social network extends into everyday interactions where location-specific, real time interactions are natural and resulting actions can be immediate. Governments and NGOs can leverage the self-organizing, collectively-intelligent community to improve situational awareness and improve the communitys resilience. At this time of limited public budgets, static but authoritative data can be combined with dynamic data provided by citizens. This paper reports our experience and challenges in building a mobile app named Yellow Button. We describe the architecture of Yellow Button and our experience in the initial applications to utilities, traffic and transportation.