Sistemas de gestión para el control de la cadena de abastecimiento que apropie características de los cubos OLAP como marco de aplicación en una empresa colombiana del sector de alimentos.

Se basa en un análisis teórico de los sistemas de información como lo es el almacenaje de datos, cubos OLAP e inteligencia de negocios. Seguidamente, se hace un análisis de los sectores económicos de Colombia con un especial interés sobre el sector de alimentos, de esta manera conceptualizar la empresa sobre la cual este trabajo se enfocara. Se encontrará un análisis del caso de éxito Summerwood Corporation, el cual brindará una justificación para la propuesta final presentada a la empresa Dipsa Food, Pyme dedicada a la producción de alimentos no perecederos ubicada en la ciudad de Bogotá D.C –Colombia, la cual tiene gran interés en cuanto al desarrollo de nuevas tecnologías que brinden información fidedigna para la toma de decisiones

Towards the design of a unified semantics model for OLTP and OLAP systems

The concepts of on-line transactional processing (OLTP) and on-line analytical processing (OLAP) are often confused with the technologies or models that are used to design transactional and analytics based information systems. This in some way has contributed to existence of gaps between the semantics in information captured during transactional processing and information stored for analytical use. In this paper, we propose the use of a unified semantics design model, as a solution to help bridge the semantic gaps between data captured by OLTP systems and the information provided by OLAP systems. The central focus of this design approach is on enabling business intelligence using not just data, but data with context.

Design of a unified data with business rules storage model for OLTP and OLAP systems

This paper reviews the literature concerning the practice of using Online Analytical Processing (OLAP) systems to recall information stored by Online Transactional Processing (OLTP) systems. Such a review provides a basis for discussion on the need for the information that are recalled through OLAP systems to maintain the contexts of transactions with the data captured by the respective OLTP system. The paper observes an industry trend involving the use of OLTP systems to process information into data, which are then stored in databases without the business rules that were used to process information and data stored in OLTP databases without associated business rules. This includes the necessitation of a practice, whereby, sets of business rules are used to extract, cleanse, transform and load data from disparate OLTP systems into OLAP databases to support the requirements for complex reporting and analytics. These sets of business rules are usually not the same as business rules used to capture data in particular OLTP systems. The paper argues that, differences between the business rules used to interpret these same data sets, risk gaps in semantics between information captured by OLTP systems and information recalled through OLAP systems. Literature concerning the modeling of business transaction information as facts with context as part of the modelling of information systems were reviewed to identify design trends that are contributing to the design quality of OLTP and OLAP systems. The paper then argues that; the quality of OLTP and OLAP systems design has a critical dependency on the capture of facts with associated context, encoding facts with contexts into data with business rules, storage and sourcing of data with business rules, decoding data with business rules into the facts with the context and recall of facts with associated contexts. The paper proposes UBIRQ, a design model to aid the co-design of data with business rules storage for OLTP and OLAP purposes. The proposed design model provides the opportunity for the implementation and use of multi-purpose databases, and business rules stores for OLTP and OLAP systems. Such implementations would enable the use of OLTP systems to record and store data with executions of business rules, which will allow for the use of OLTP and OLAP systems to query data with business rules used to capture the data. Thereby ensuring information recalled via OLAP systems preserves the contexts of transactions as per the data captured by the respective OLTP system.

Identificazione di profili di rischio cardiovascolare nel trapianto di rene: polimorfismi di geni coinvolti nei processi di infiammazione e di apoptosi

Introduction. Cardiovascular disease (CVD) represents the main cause of morbidity and mortality in kidney recipients. This study was undertaken to assess the impact of functional polymorphisms located in cytokine and apoptosis genes on CVD after kidney transplantation. Cytokine polymorphisms, generally located in gene regulatory regions, are associated with high and low cytokine production and are likely to modulate the magnitude of inflammatory responses following transplantation, depending on the balance between the levels of pro-inflammatory and antiinflammatory cytokines. The role of apoptosis in atherosclerosis has not been completely elucidated, and here we explored the hypothesis that the heterogeneity in cardiovascular risk in kidney recipients may also be linked to functional polymorphisms involved in apoptosis induction. Purpose. In the search for relevant genetic markers of predisposition to CVD after renal transplant, the present investigation was undertaken to identify the clinical impact of polymorphisms of cytokines TNF-α, TGF-β, IL-10, IL-6, IFN-γ and IL-8 and of apoptosis genes Fas and Caspase 9 in a population of kidney transplant recipients. Materials and methods. The study involved 167 patients who received cadaveric kidney transplantation at our centre between 1997 and 2005 (minimum follow-up of 12 months); 35 of them had experienced cardiovascular events (CVD group) and 132 had no cardiovascular complications (non-CVD group). Genotyping was performed using RFLP (Restriction Fragment Length Polymorphism) for RFLP per IL-8/T-251A, Fas/G-670A e Casp9/R221Q polymorphism and SSP (Sequence Specific Primer) for TNF-α/G-308A, TGF-β/L10P, TGF-β/R25P, IL-10/G-1082A, IL- 10/C-819T, IL-10/C-592A, IL-6/G-174C, IFN-γ/T+874A polymorphisms.Results. We found a significant difference in TNF-α and IL-10 genotype frequencies between the patients who had suffered cardiovascular events and those with no CVD history. The high producer genotype for proflogistic cytokine TNF-α appeared to have a significantly superior prevalence in the CVD group compared to the non-CVD group (40.0% vs 21.2%) and it resulted in a 2.4-fold increased cardiovascular risk (OR=2.361; p=0.0289). On the other hand, the high producer genotype for the antiinflammatory cytokine IL-10 was found in 2.8% of the CVD group and in 16.7% of non-CVD group; logistic regression showed a 0.3-fold reduced risk of CVD associated with genetically determined high IL-10 production (OR=0.278; p<0.0001). The other polymorphisms did not prove to have any impact on CVD. Conclusions. TNF-α and IL-10 gene polymorphisms might represent cardiovascular risk markers in renal transplant recipients.

La cessazione dell'attività economica nell'IVA: profili nazionali e comunitari

La ricerca oggetto della tesi dottorale verte sulla ricostruzione della disciplina della cessazione e delle fasi liquidatore dell’attività nell’ambito dell’imposta sul valore aggiunto, nel tentativo di individuare criteri certi ed omogenei per la sua individuazione, sia in prospettiva comunitaria che in prospettiva nazionale. In primo luogo, l’indagine si concentra sulla ricostruzione della nozione di attività economica e sui profili dinamici dell’attività in ambito comunitario, nell’intento di chiarire, sulla base della giurisprudenza, i criteri utilizzati per individuare la cessazione dell’attività rilevante ai fini dell’imposta, sfruttando in tal senso l’esperienza degli atti preparatori e l’applicabilità dell’ipotesi di applicazione dell’imposta per autoconsumo Vengono così valorizzati, accanto al profilo oggettivo costituito dalla presenza di una legame tra le operazioni della fase liquidatoria, il ruolo del soggetto passivo, quale portatore di una volontà che è in grado di influire sull’esistenza dell’attività stessa, e, conseguentemente, delle dichiarazioni formali imposte dalla Direttiva, quale manifestazione diretta di tale volontà ed elemento in grado di costituire un indice certo di cessazione. In seguito si esamina il regime impositivo nazionale ed in particolare le linee interpretative maggioritarie accolte da dottrina e giurisprudenza. Ricostruiti nozione e ruolo di attività economica, con riferimento all’esercizio d’impresa, vengono analizzati i diversi casi di cessazione contemplati dall’ordinamento –liquidazione volontaria, trasferimento dell’azienda e fallimento- analizzati sia nella prospettiva del diritto tributario che in quella del diritto commerciale. L’esame così sviluppato è volto a contestare l’interpretazione maggioritaria che vede nella sola presenza di beni residui alla liquidazione, o comunque la permanenza di un insieme di beni potenzialmente in grado di far riprendere l’esercizio, elemento sufficiente a mantenere in vita l’impresa e con essa la soggettività passiva all’imposta. Infine, vengono confrontati i risultati raggiunti nell’esame della disciplina comunitaria nazionale, ponendone in evidenza le possibilità incompatibilità ed i punti di contatto, con l’intenzione di dimostrare l’applicabilità anche a livello nazionale dei principi emersi in ambito comunitario.