An Open Source BI Approach: Concept Proof Tracking Fleet

É possível assistir nos dias de hoje, a um processo tecnológico evolutivo acentuado por toda a parte do globo. No caso das empresas, quer as pequenas, médias ou de grandes dimensões, estão cada vez mais dependentes dos sistemas informatizados para realizar os seus processos de negócio, e consequentemente à geração de informação referente aos negócios e onde, muitas das vezes, os dados não têm qualquer relacionamento entre si. A maioria dos sistemas convencionais informáticos não são projetados para gerir e armazenar informações estratégicas, impossibilitando assim que esta sirva de apoio como recurso estratégico. Portanto, as decisões são tomadas com base na experiência dos administradores, quando poderiam serem baseadas em factos históricos armazenados pelos diversos sistemas. Genericamente, as organizações possuem muitos dados, mas na maioria dos casos extraem pouca informação, o que é um problema em termos de mercados competitivos. Como as organizações procuram evoluir e superar a concorrência nas tomadas de decisão, surge neste contexto o termo Business Intelligence(BI). A GisGeo Information Systems é uma empresa que desenvolve software baseado em SIG (sistemas de informação geográfica) recorrendo a uma filosofia de ferramentas open-source. O seu principal produto baseia-se na localização geográfica dos vários tipos de viaturas, na recolha de dados, e consequentemente a sua análise (quilómetros percorridos, duração de uma viagem entre dois pontos definidos, consumo de combustível, etc.). Neste âmbito surge o tema deste projeto que tem objetivo de dar uma perspetiva diferente aos dados existentes, cruzando os conceitos BI com o sistema implementado na empresa de acordo com a sua filosofia. Neste projeto são abordados alguns dos conceitos mais importantes adjacentes a BI como, por exemplo, modelo dimensional, data Warehouse, o processo ETL e OLAP, seguindo a metodologia de Ralph Kimball. São também estudadas algumas das principais ferramentas open-source existentes no mercado, assim como quais as suas vantagens/desvantagens relativamente entre elas. Em conclusão, é então apresentada a solução desenvolvida de acordo com os critérios enumerados pela empresa como prova de conceito da aplicabilidade da área Business Intelligence ao ramo de Sistemas de informação Geográfica (SIG), recorrendo a uma ferramenta open-source que suporte visualização dos dados através de dashboards.

A framework for real time MMO game content generation

Com o aumento de plataformas móveis disponíveis no mercado e com o constante incremento na sua capacidade computacional, a possibilidade de executar aplicações e em especial jogos com elevados requisitos de desempenho aumentou consideravelmente. O mercado dos videojogos tem assim um cada vez maior número de potenciais clientes. Em especial, o mercado de jogos massive multiplayer online (MMO) tem-se tornado muito atractivo para as empresas de desenvolvimento de jogos. Estes jogos suportam uma elevada quantidade de jogadores em simultâneo que podem estar a executar o jogo em diferentes plataformas e distribuídos por um "mundo" de jogo extenso. Para incentivar a exploração desse "mundo", distribuem-se de forma inteligente pontos de interesse que podem ser explorados pelo jogador. Esta abordagem leva a um esforço substancial no planeamento e construção desses mundos, gastando tempo e recursos durante a fase de desenvolvimento. Isto representa um problema para as empresas de desenvolvimento de jogos, e em alguns casos, e impraticável suportar tais custos para equipas indie. Nesta tese e apresentada uma abordagem para a criação de mundos para jogos MMO. Estudam-se vários jogos MMO que são casos de sucesso de modo a identificar propriedades comuns nos seus mundos. O objectivo e criar uma framework flexível capaz de gerar mundos com estruturas que respeitam conjuntos de regras definidas por game designers. Para que seja possível usar a abordagem aqui apresentada em v arias aplicações diferentes, foram desenvolvidos dois módulos principais. O primeiro, chamado rule-based-map-generator, contem a lógica e operações necessárias para a criação de mundos. O segundo, chamado blocker, e um wrapper à volta do módulo rule-based-map-generator que gere as comunicações entre servidor e clientes. De uma forma resumida, o objectivo geral e disponibilizar uma framework para facilitar a geração de mundos para jogos MMO, o que normalmente e um processo bastante demorado e aumenta significativamente o custo de produção, através de uma abordagem semi-automática combinando os benefícios de procedural content generation (PCG) com conteúdo gráfico gerado manualmente.

Shoes Closet: Entering the German market

A Work Project, presented as part of the requirements for the Award of a Masters Degree in Management from the NOVA – School of Business and Economics

Couch & Brunch: The breakfast chain business model

A Work Project, presented as part of the requirements for the Award of a Masters Degree in Management from the NOVA – School of Business and Economics

Shoes closet- Entering the German market

The purpose of this project is to prepare and help ShoesCloset company for international business activity, namely in Germany. After having a careful study on the core foundation of the company I conclude that ShoesCloset has indeed potential to succeed by offering what the target segment is looking for in footwear. Nevertheless, the firm still has to improve in areas such as marketing, management operations, distribution channels and internal structure. In relation to the German market and according to my studies the best mode of entry is through direct exports, which would be under the supervision of the CEO. Moreover, it is imperative to increase the productive capacity in order to satisfy both national and international expected demands

Laparoscopic versus open splenectomy in the management of hematologic diseases

Splenectomy is the best available treatment for severe forms of hereditary spherocytosis, idiopathic thrombocytopenic purpura, and other hematologic conditions when these prove refractory to conservative management. It has been employed for many decades with low mortality and favorable remission rates. The use of laparoscopic splenectomy in recent years has been rapidly and even enthusiastically adopted in this field. However, the exact role of laparoscopic versus open surgery for hematologic diseases is still debated. In this study of 58 adult patients, laparoscopic procedures were compared with conventional splenectomies for similar indications. METHODS: All patients were operated on within an 8-year period. Subjects underwent similar procedures under the supervision of the same surgical school and were compared regarding age, gender, body mass index, and diagnosis. Laparoscopically managed cases (Group I, n = 30) were prospectively followed according to a written protocol, whereas the same investigation was retrospectively done with regard to traditional laparotomy (Group II, n = 28). Methods included general and demographic findings, duration and technical steps of operation, blood loss, weight of spleen, need for conversion (in minimally invasive subjects), intraoperative and postoperative complications, time until realimentation, postoperative hospitalization, mortality, and late follow-up including recurrence rate. RESULTS: Idiopathic thrombocytopenic purpura was the surgical indication in over 50% of the patients in both groups, but familial spherocytosis, thalassemia, myelodysplasia, and lymphomas were also represented in this series. Laparoscopic procedures took more time to perform (P = 0.004), and postoperative hospitalization was 2 days shorter, but this difference was not statistically significant. Postoperative hematocrit and volume of blood transfusions was equivalent, although the laparoscopic cases had a somewhat lower preoperative hematocrit (NS) and displayed better recovery for this measurement (P = 0.03). More patients in Group I were able to accept oral food on the first day than subjects undergoing conventional operations (P < 0.05). Relatively few conversions were necessary during the minimally invasive surgeries (13.3%), and postoperative early and late complications as well as recurrences occurred in similar proportions. Also, the mean weight of the spleen was not statistically different between the groups, although there was a marked numerical tendency toward larger masses in conventional procedures. No spleen in Group I exceeded 2.0 kg, whereas in Group II values up to 4.0 kg occurred, and the mean weight was 50% higher in the latter group. CONCLUSIONS: 1) Minimally invasive splenectomy was essentially comparable to open surgery with regard to safety, efficacy, and late results; 2) Advantages concerning shorter postoperative hospitalization could not be shown, despite earlier food intake and a non-significant tendency toward earlier discharge; 3) This new modality should be considered an option in cases of hematologic conditions whenever the spleen is not hugely enlarged.

Learning from Shocks and the Decision to Open

Two claims pervade the literature on the political economy of market reforms: that economic crises cause reforms; and that crises matter because they bring into question the validity of the economic model held to be responsible for them. Economic crises are said to spur a process of learning that is conducive to the abandonment of failing models and to the adoption of successful models. But although these claims have become the conventional wisdom, they have been hardly tested empirically due to the lack of agreement on what constitutes a crisis and to difficulties in measuring learning from them. I propose a model of rational learning from experience and apply it to the decision to open the economy. Using data from 1964 through 1990, I show that learning from the 1982 debt crisis was relevant to the first wave of adoption of an export promotion strategy, but learning was conditional on the high variability of economic outcomes in countries that opened up to trade. Learning was also symbolic in that the sheer number of other countries that liberalized was a more important driver of others’ decisions to follow suit.

Productivity, Preferences and UIP deviations in an Open Economy Business Cycle Model

We show that a flex-price two-sector open economy DSGE model can explain the poor degree of international risk sharing and exchange rate disconnect. We use a suite of model evaluation measures and examine the role of (i) traded and non-traded sectors; (ii) financial market incompleteness; (iii) preference shocks; (iv) deviations from UIP condition for the exchange rates; and (v) creditor status in net foreign assets. We find that there is a good case for both traded and non-traded productivity shocks as well as UIP deviations in explaining the puzzles.

The Timing of Asset Trade and Optimal Policy in Dynamic Open Economies

Using a standard open economy DSGE model, it is shown that the timing of asset trade relative to policy decisions has a potentially important impact on the welfare evaluation of monetary policy at the individual country level. If asset trade in the initial period takes place before the announcement of policy, a national policymaker can choose a policy rule which reduces the work effort of households in the policymaker’s country in the knowledge that consumption is fully insured by optimally chosen international portfolio positions. But if asset trade takes place after the policy announcement, this insurance is absent and households in the policymaker’s country bear the full consumption consequences of the chosen policy rule. The welfare incentives faced by national policymakers are very different between the two cases. Numerical examples confirm that asset market timing has a significant impact on the optimal policy rule.

A New open economy macroeconomic model with endogenous portfolio diversification and firms entry

This paper provides a new benchmark for the analysis of the international diversi…cation puzzle in a tractable new open economy macroeconomic model. Building on Cole and Obstfeld (1991) and Heathcote and Perri (2009), this model speci…es an equilibrium model of perfect risk sharing in incomplete markets, with endogenous portfolios and number of varieties. Equity home bias may not be a puzzle but a perfectly optimal allocation for hedging risk. In contrast to previous work, the model shows that: (i) optimal international portfolio diversi…cation is driven by home bias in capital goods, independently of home bias in consumption, and by the share of income accruing to labour. The model explains reasonably well the recent patterns of portfolio allocations in developed economies; and (ii) optimal portfolio shares are independent of market dynamics.

Adaptive business intelligence for an open negotiation environment

Engineering of negotiation model allows to develop effective heuristic for business intelligence. Digital ecosystems demand open negotiation models. To define in advance effective heuristics is not compliant with the requirement of openness. The new challenge is to develop business intelligence in advance exploiting an adaptive approach. The idea is to learn business strategy once new negotiation model rise in the e-market arena. In this paper we present how recommendation technology may be deployed in an open negotiation environment where the interaction protocol models are not known in advance. The solution we propose is delivered as part of the ONE Platform, open source software that implements a fully distributed open environment for business negotiation

Monetary policy with signal extraction from the bond market

Monetary policy is conducted in an environment of uncertainty. This paper sets upa model where the central bank uses real-time data from the bond market togetherwith standard macroeconomic indicators to estimate the current state of theeconomy more efficiently, while taking into account that its own actions influencewhat it observes. The timeliness of bond market data allows for quicker responsesof monetary policy to disturbances compared to the case when the central bankhas to rely solely on collected aggregate data. The information content of theterm structure creates a link between the bond market and the macroeconomythat is novel to the literature. To quantify the importance of the bond market asa source of information, the model is estimated on data for the United Statesand Australia using Bayesian methods. The empirical exercise suggests that thereis some information in the US term structure that helps the Federal Reserve toidentify shocks to the economy on a timely basis. Australian bond prices seemto be less informative than their US counterparts, perhaps because Australia is arelatively small and open economy.

Laparoscopic and open colorectal surgery in everyday practice : retrospective study

Résumé Introduction: La plupart des études disponibles sur la chirurgie colorectale par laparoscopie concernent des patients hautement sélectionnés. Le but de cette étude est d'analyser les résultats à court et à long terme de l'ensemble des patients traités dans un service de chirurgie générale. Méthodes: Il s'agit d'une analyse rétrospective d'un registre prospectif interne au service, dans lequel tous les patients consécutifs opérés pour la première fois du colon et du rectum entre mars 1993 et décembre 1997 ont été enregistrés. Les informations concernant le suivi ont été collectées par questionnaire. Résultats: Un total de 187 patients ont été opérés par laparoscopie et 215 patients par chirurgie ouverte durant la période d'étude. Les informations concernant le suivi ont pu être collectées dans 95% des cas avec une évolution de 1-107 mois (médiane 59 mois), respectivement de 1-104 mois (médiane 53 mois). Une conversion fut nécessaire dans 28 cas (15%) mais ceux-ci restent inclus dans le groupe laparoscopie pour l'analyse par intention de traitement. Dans le groupe laparoscopie, les opérations ont duré plus longtemps (205 vs 150 min, p<0.001) mais l'hospitalisation a été plus courte (8 vs 13 jours, p<0.001). La reprise du transit a été plus rapide après laparoscopie, mais uniquement après intervention sur le colon gauche (3 vs 4 jours, p<0.01). Cependant, la sélection préopératoire (nombre plus élevé d'urgences et de patients avec un risque anesthésiologique élevé dans le groupe de la chirurgie ouverte) a été favorable à la laparoscopie. Le taux de complications (global ainsi que pour chaque complication chirurgicale) a été similaire dans les deux groupes, avec un taux global de 20% environ. Conclusions: Malgré une sélection favorable des cas, uniquement très peu d'avantages à la laparoscopie sur la chirurgie ouverte ont pu être observés. Abstract Background: Most studies available on laparoscopic colorectal surgery focus on highly selected patient groups. The aim of the present study was to review short- and long-term outcome of everyday patients treated in a general surgery department. Methods: Retrospective review was carried out of a prospective database of all consecutive patients having undergone primary laparoscopic (LAP) or open colorectal surgery between March 1993 and December 1997. Follow-up data were completed via questionnaire. Results: A total of 187 patients underwent LAP resection and 215 patients underwent open surgery. Follow up was complete in 95% with a median of 59 months (range, 1-107 months) and 53 months (range, 1-104 months), respectively. There were 28 conversions (15%) in the LAP group and these remained in the LAP group in an intention-to-treat analysis. The LAP operations lasted significantly longer for all types of resections (205 vs 150 min, P<0.001) and hospital stay was shorter (8 vs 13 days, P<0.001). Recovery of intestinal function was faster in the LAP group, but only after left-sided procedures (3 vs 4days, P<0.01). However, preoperative patient selection (more emergency operations and patients with higher American Society of Anesthesiologists (ASA) score in the open group) had a major influence on these elements and favours the LAP group. Surprisingly, the overall surgical complication rate (including long-term complications such as wound hernia) was 20% in both groups with rates of individual complications also being comparable in both groups. Conclusion: Despite a patient selection favourable to the laparoscopy group, only little advantage in postoperative outcome could be shown for the minimally invasive over the open approach in the everyday patient.

Composition of electricity generation portfolios, pivotal dynamics and market prices

We use a simulation model to study how the diversification of electricity generation portfoliosinfluences wholesale prices. We find that technological diversification generally leads to lower market prices but that the relationship is mediated by the supply to demand ratio. In each demand case there is a threshold where pivotal dynamics change. Pivotal dynamics pre- and post-threshold are the cause of non-linearities in the influence of diversification on market prices. The findings are robust to our choice of behavioural parameters and match close-form solutions where those are available.

The pricing of academic journals: A two-sided market perspective

More and more academic journals adopt an open-access policy, by which articlesare accessible free of charge, while publication costs are recovered through authorfees. We study the consequences of this open access policy on a journal s qualitystandard. If the journal s objective was to maximize social welfare, open accesswould be optimal as long as the positive externalities generated by its diffusionexceed the marginal cost of distribution. However, we show that if an open accessjournal has a different objective (such as maximizing readers payoffs, the impactof the journal or its profit), it tends to choose a quality standard below the sociallyefficient level.