Integrating structured and unstructured data in a business-intelligence-system

The recent liberalization of the German energy market has forced the energy industry to develop and install new information systems to support agents on the energy trading floors in their analytical tasks. Besides classical approaches of building a data warehouse giving insight into the time series to understand market and pricing mechanisms, it is crucial to provide a variety of external data from the web. Weather information as well as political news or market rumors are relevant to give the appropriate interpretation to the variables of a volatile energy market. Starting from a multidimensional data model and a collection of buy and sell transactions a data warehouse is built that gives analytical support to the agents. Following the idea of web farming we harvest the web, match the external information sources after a filtering and evaluation process to the data warehouse objects, and present this qualified information on a user interface where market values are correlated with those external sources over the time axis.

The Care and Shelter of Children and Adolescents in Brazil: Expressions of Social Issues

The future of Brazilian children who have the protection offered by familial bonds is threatened by social inequities that force them to seek shelter and grow up in shelters. According to the Institute of Applied Economic Research, an estimated 20,000 children and adolescents are served by institutions. The majority of these children are afro-descendent males between the ages of seven and fifteen years old. Of those researched, 87.6% have families (58.2% receive visits from their families, 22.7% are rarely visited by their families and 5.8 are legally prohibited from contacting or being by their families). The percentage of children and adolescents “without families” or with “missing families” is 11.3%. There is no information available for 2% of the children and adolescents residing in shelters. The principle factors that necessitate the placement of Brazilian children in institutions that provide care and shelter include poverty (including children forced to work, sell drugs or beg, for example); domestic violence; chemical dependence of parents or guardians; homelessness; death or parents or guardian; imprisonment of their parents; and sexual abuse committed by their parents or guardians. The issue of abandoned children and adolescents and their care and shelter in the Brazilian context expresses a perverse violation of Child and Adolescent Rights.