In the Healthcare field, Business Intelligence and Data Mining techniques have been proven efficient mainly in the fields of contagious diseases and hospital productivity, however their usage is today still very limited, specially in specific fields like chronic disease management. This paper presents a methodology to develop Data Mining and Business Intelligence based on remote chronic patient management databases. This document also introduces a technical methodology to build a conceptual Data Model for Data Mining based on HL7-v3, with the objective of analyzing patient behavior, detecting triggers for future patient crisis, predicting patient behavior and contribute to improve management plans, resource usage optimization and higher Returns on Investment. Distinciones: Graduado como mejor estudiante de la promoción.

Colombian legislation on survivors' pension is one of the most comprehensive and protective in Latin America; it won't require the economic dependence of the members of the couple, or their cohabitation until death, however, some lags in that legislation result in situations of injustice and inequality and a growing and worrisome legal uncertainty. Legislative structure and jurisprudential interpretation formed from family law elements, conservative conceptions and misinterpretations of Social Security Law, have denatured the essence of this pension for survivors of couples and have also generated chaotic solutions, in such a way that at the present there are no clear requirements in order to acquire the pension, and the fate of a claim depends on the judgement of each court. This research shows the need to retake the elements of the essence of the survivors' pension, such as the concepts of family and necessity, for this a legislative reform is required that supports the constitutionality tests and clearly draws a landscape that do not allow divergent and contrary understandings of law interpreters, in the search for legal security, equality, non-discrimination and true social security protection for survivors.