Using relational algebra on the specification of real world ETL processes

Modeling Extract-Transform-Load (ETL) processes of a Data Warehousing System has always been a challenge. The heterogeneity of the sources, the quality of the data obtained and the conciliation process are some of the issues that must be addressed in the design phase of this critical component. Commercial ETL tools often provide proprietary diagrammatic components and modeling languages that are not standard, thus not providing the ideal separation between a modeling platform and an execution platform. This separation in conjunction with the use of standard notations and languages is critical in a system that tends to evolve through time and which cannot be undermined by a normally expensive tool that becomes an unsatisfactory component. In this paper we demonstrate the application of Relational Algebra as a modeling language of an ETL system as an effort to standardize operations and provide a basis for uncommon ETL execution platforms.

The real economic effects of cross-delistingfrom the united states: evidence on post-operating performance, financial constraints and stock crash risk

Tese de Doutoramento em Ciências Empresariais.

On the cost of rent-seeking by government bureaucrats in a Real-Business-Cycle framework

This paper studies the wasteful e ffect of bureaucracy on the economy by addressing the link between rent-seeking behavior of government bureaucrats and the public sector wage bill, which is taken to represent the rent component. In particular, public o fficials are modeled as individuals competing for a larger share of those public funds. The rent-seeking extraction technology in the government administration is modeled as in Murphy et al. (1991) and incorporated in an otherwise standard Real-Business-Cycle (RBC) framework with public sector. The model is calibrated to German data for the period 1970-2007. The main fi ndings are: (i) Due to the existence of a signi ficant public sector wage premium and the high public sector employment, a substantial amount of working time is spent rent-seeking, which in turn leads to signifi cant losses in terms of output; (ii) The measures for the rent-seeking cost obtained from the model for the major EU countries are highly-correlated to indices of bureaucratic ineffi ciency; (iii) Under the optimal scal policy regime,steady-state rent-seeking is smaller relative to the exogenous policy case, as the government chooses a higher public wage premium, but sets a much lower public employment, thus achieving a decrease in rent-seeking.

On the current existence of a coccidial line of development in the malaria parasites: a theory

Most opinion favors the origin of the malaria parasites from a coccidial ancestor. It is assumed that whatever the process through which the coccidia differentiated into a Plasmodium this phenomenon very probably occured millions of year ago, and during that differentiation process the original coccidia vanished. Therefore it has never repeated. At the light of some experiments the existence, at the present time, of a coccidial cycle of development in the malaria parasites, is proposed. The conection routes and mechanisms through which the malaria parasite changes to a coccidial life, and the routes in reverse are exposed. Transmission of the malaria-coccidial forms is suggested.

On the zeroes of Goss polynomials

"Vegeu el resum a l'inici del document del fitxer adjunt."

Characterization of the effects of IL-17F on CHO cell line generation

CHO is the most commonly used mammalian host for the generation of cell lines allowing for the production of high quality therapeutic proteins. The generation of such cell lines is a lengthy and resource-intensive process requiring extensive screening in order to isolate candidates with optimal characteristics, such as growth, stability and productivity. For this reason, the biotechnology industry invests much effort in attempts to optimize CHO expression systems in order to streamline and shorten the cell line selection process. Based on preliminary observations of a facilitated selection of CHO-GS cell lines expressing members of the IL-17 cytokine family, this study investigates the use of IL-17F as a novel enhancing factor for CHO cell line generation. Using two different CHO expression systems (exploiting GS and DHFR-based selection), we demonstrated that IL-17F expression caused a significant increase in the occurrence of colonies during the selection process. All colonies selected produced substantial amounts of IL-17F, suggesting that benefits were conferred, during selection, to those cells expressing the cytokine. Furthermore, transgene expression levels were significantly increased when the selection pressure was raised to a level that would not normally be permissive for colony selection (i.e. 100 |o.M MSX for the CHO-GS expression system or 1000 nM MTX for the CHO-DHFR system). Finally, IL-17F expression was also found to enhance the rate of appearance of clones during single cell subcloning in the absence of selection pressure. Overall, these benefits have the potential to allow a substantial reduction in the length of cell line generation while significantly increasing cell line productivity. Nevertheless, we found that the high IL-17F expression levels required to convey enhancing effects was a limitation when attempting to co-express IL-17F and a recombinant soluble protein of therapeutic interest from independent CMV promoters within the same expression vector. In order to understand and overcome this limitation, studies were designed to characterize the IL-17F enhancing effect at the molecular and cellular level. Regular supplementation of recombinant biologically-active IL-17F into the culture medium during cell line selection was not able to reproduce the enhancing effects of endogenous IL-17F expression. In addition, increased IL-17F expression correlated with increased CHO-GS selection transgene expression at the single cell level. This data suggested a possible effect of IL-17F on viral promoter activity or transgene mRNA stability. It also provided direct evidence that the cells expressing the highest amounts of IL-17F obtained the most benefit. Overall data obtained from these study implied that IL-17F may act through an intracellular mechanism, possibly exerted during secretion. We therefore initiated experiments designed to determine the specific compartment(s) within which IL-17F triggers its effect. This work has identified IL-17F as a potentially powerful tool to optimize the CHO cell line generation process. The characterization of this enhancing effect at the molecular level has given us several insights into overcoming the current limitations, thus paving the way for the development of a viable technology that can be exploited within the biotechnology industry. - La CHO est la cellule hôte de mammifere la plus couramment utilisée dans la création de lignée cellulaire produisant des protéines thérapeutiques de haute qualité. La génération de ces lignées cellulaires est un processus long et exigeant l'utilisation de techniques de sélection robustes afin d'isoler des candidats possédants les caractéristiques optimales de croissance, de productivité et de stabilité d'expression. Les industries biopharmaceutiques ont investi beaucoup d'efforts afin d'optimiser les systèmes d'expression CHO dans le but raccourcir la longueur du procédé de sélection de lignées cellulaires et aussi d'en augmenter l'efficacité. A partir d'observations préliminaires obtenues lors de la génération de lignées cellulaires CHO- GS exprimant une cytokine appartenant à la famille des IL-17, nous avons réalisé une étude portant sur l'utilisation de l'IL-17F humaine (IL-17F) comme nouveau facteur d'optimisation pour la génération de lignées cellulaires CHO. Nous avons démontré, en utilisant les deux systèmes de sélection et d'expression CHO couramment utilisés (le premier exploitant la GS et l'autre basée sur la DHFR), que l'expression de l'IL-17F permet une augmentation significative de la fréquence d'apparition de colonies durant le processus de sélection de lignées cellulaires. Les différentes colonies sélectionnées expriment des quantités substantielles d'IL-17F, suggérant un effet bénéfique lors de la sélection qui serait exclusivement conféré aux cellules exprimant la cytokine. En outre, le niveau d'expression du transgene se trouve significativement augmenté lorsque la pression de sélection est portée à un niveau habituellement trop élevé pour permettre la sélection de colonies (soit 100 |JM MSX pour le système d'expression CHO-GS ou 1000 nM MTX pour le système CHO- DHFR). Enfin, l'expression d'IL-17F permet également d'améliorer la vitesse d'apparition de clones pendant une étape de sous-clonage en l'absence de pression de sélection. L'ensemble de ces effets bénéfiques permettent une réduction substantielle de la durée de génération de lignées cellulaires tout en augmentant considérablement la productivité des lignées obtenues. Néanmoins, nous avons constaté que la nécessité d'exprimer des niveaux élevés d'IL-17F afin obtenir l'ensemble de ses effets bénéfiques devient une contrainte lors de l'utilisation d'un vecteur d'expression composé de deux promoteurs CMV indépendants pour la co-expression de la cytokine et d'une protéine soluble présentant un intérêt thérapeutique. Afin de mieux comprendre et de surmonter cette limitation, plusieurs études ont été effectuées dans le but de mieux caractériser l'effet de IL-17F au niveau subcellulaire. L'apport régulier en IL-17F recombinante et biologiquement active dans le milieu de culture lors de la sélection de lignées cellulaires ne permet pas de reproduire les effets bénéfiques observés par l'expression endogène d'IL-17F. En outre, nous avons constaté que, lors de l'utilisation du système CHO- GS, l'augmentation d'expression de 1TL-17F est corrélée à un accroissement de l'expression du marqueur de sélection au niveau cellulaire. Ces résultats suggèrent un possible effet d'IL- 17F sur l'activité des promoteurs viraux et ainsi fournissent une preuve directe que les cellules exprimant de haut niveau d'IL-17F sont celles qui en profitent le plus. L'ensemble de ces observations mettrait en avant que l'effet d'IL-17F se ferait selon un mécanisme intracellulaire. Nous avons donc étudié le(s) compartiment(s) spécifique(s) dans lequel IL-17F pourrait exercer son effet. Ce travail a permis de définir IL-17F comme un puissant outil pour l'optimisation des procédés de génération de lignées cellulaires CHO. La caractérisation de cette amélioration de l'effet au niveau moléculaire nous a donné plusieurs indications sur la manière de dépasser les limitations actuelles, ouvrant ainsi la voie au développement d'une technologie viable qui peut être exploitée pars l'industrie biotechnologique.

Detection of replication-defective hepatitis A virus based on the correlation between real-time polymerase chain reaction and ELISA in situ results

ELISA in situ can be used to titrate hepatitis A virus (HAV) particles and real-time polymerase chain reaction (RT-PCR) has been shown to be a fast method to quantify the HAV genome. Precise quantification of viral concentration is necessary to distinguish between infectious and non-infectious particles. The purpose of this study was to compare cell culture and RT-PCR quantification results and determine whether HAV genome quantification can be correlated with infectivity. For this purpose, three stocks of undiluted, five-fold diluted and 10-fold diluted HAV were prepared to inoculate cells in a 96-well plate. Monolayers were then incubated for seven, 10 and 14 days and the correlation between the ELISA in situ and RT-PCR results was evaluated. At 10 days post-incubation, the highest viral load was observed in all stocks of HAV via RT-PCR (10(5) copies/mL) (p = 0.0002), while ELISA revealed the highest quantity of particles after 14 days (optical density = 0.24, p < 0.001). At seven days post-infection, there was a significant statistical correlation between the results of the two methods, indicating equivalents titres of particles and HAV genome during this period of infection. The results reported here indicate that the duration of growth of HAV in cell culture must be taken into account to correlate genome quantification with infectivity.

Estimation of the real population and its impact on the utilisation of healthcare services in Mediterranean resort regions: an ecological study.

BACKGROUND The demographic structure has a significant influence on the use of healthcare services, as does the size of the population denominators. Very few studies have been published on methods for estimating the real population such as tourist resorts. The lack of information about these problems means there is a corresponding lack of information about the behaviour of populational denominators (the floating population or tourist load) and the effect of this on the use of healthcare services. The objectives of the study were: a) To determine the Municipal Solid Waste (MSW) ratio, per person per day, among populations of known size; b) to estimate, by means of this ratio, the real population in an area where tourist numbers are very significant; and c) to determine the impact on the utilisation of hospital emergency healthcare services of the registered population, in comparison to the non-resident population, in two areas where tourist numbers are very significant. METHODS An ecological study design was employed. We analysed the Healthcare Districts of the Costa del Sol and the island of Menorca. Both are Spanish territories in the Mediterranean region. RESULTS In the two areas analysed, the correlation coefficient between the MSW ratio and admissions to hospital emergency departments exceeded 0.9, with p < 0.001. On the basis of MSW generation ratios, obtained for a control zone and also measured in neighbouring countries, we estimated the real population. For the summer months, when tourist activity is greatest and demand for emergency healthcare at hospitals is highest, this value was found to be double that of the registered population. CONCLUSION The MSW indicator, which is both ecological and indirect, can be used to estimate the real population in areas where population levels vary significantly during the year. This parameter is of interest in planning and dimensioning the provision of healthcare services.

Further evidence on the statistical properties of real GNP

The well-known lack of power of unit root tests has often been attributed to the shortlength of macroeconomic variables and also to DGP s that depart from the I(1)-I(0)alternatives. This paper shows that by using long spans of annual real GNP and GNPper capita (133 years) high power can be achieved, leading to the rejection of both theunit root and the trend-stationary hypothesis. This suggests that possibly neither modelprovides a good characterization of these data. Next, more flexible representations areconsidered, namely, processes containing structural breaks (SB) and fractional ordersof integration (FI). Economic justification for the presence of these features in GNP isprovided. It is shown that the latter models (FI and SB) are in general preferred to theARIMA (I(1) or I(0)) ones. As a novelty in this literature, new techniques are appliedto discriminate between FI and SB models. It turns out that the FI specification ispreferred, implying that GNP and GNP per capita are non-stationary, highly persistentbut mean-reverting series. Finally, it is shown that the results are robust when breaksin the deterministic component are allowed for in the FI model. Some macroeconomicimplications of these findings are also discussed.

Quasi real-time Raman studies on the growth of Cu-In-S thin films

In this work annealing and growth of CuInS2 thin films is investigated with quasireal-time in situ Raman spectroscopy. During the annealing a shift of the Raman A1 mode towards lower wave numbers with increasing temperature is observed. A linear temperature dependence of the phonon branch of ¿2 cm¿1/100 K is evaluated. The investigation of the growth process (sulfurization of metallic precursors) with high surface sensitivity reveals the occurrence of phases which are not detected with bulk sensitive methods. This allows a detailed insight in the formation of the CuInS2 phases. Independent from stoichiometry and doping of the starting precursors the CuAu ordering of CuInS2 initially forms as the dominating ordering. The transformation of the CuAu ordering into the chalcopyrite one is, in contrast, strongly dependent on the precursor composition and requires high temperatures.

On the interplay between Q^2 and t dependence in exclusive diffractive production of real photons and vector mesons in ep collisions

We show how the familiar phenomenological way of combining the Q2 (photon virtuality) and t (squared momentum transfer) dependences of the scattering amplitude in Deeply Virtual Compton Scattering (DVCS) [1, 2] and Vector Meson Production (VMP) [2] processes can be understood in an off-mass-shell generalization of dual amplitudes with Mandelstam analyticity [3]. By comparing different approaches, we managed also to constrain the numerical values of the free parameters.

Synergistic antitumor effect of TRAIL and adriamycin on the human breast cancer cell line MCF-7

The aim of the present study was to determine the effect of the combination of tumor necrosis factor-related apoptosis-inducing ligand (TRAIL) and adriamycin (ADM) on the human breast cancer cell line MCF-7 and to identify potential mechanisms of apoptosis. Cell viability was analyzed by the MTT assay and the synergistic effect was assessed by the Webb coefficient. Apoptosis was quantified using the annexin V-FITC and propidium iodide staining flow cytometry. The mRNA expression of TRAIL receptors was measured by RT-PCR. Changes in the quantities of Bax and caspase-9 proteins were determined by Western blot. MCF-7 cells were relatively resistant to TRAIL (IC50 >10 µg/mL), while MCF-7 cells were sensitive to ADM (IC50 <10 µg/mL). A subtoxic concentration of ADM (0.5 µg/mL) combined with 0.1, 1, or 10 µg/mL TRAIL had a synergistic cytotoxic effect on MCF-7 cells, which was more marked with the combination of TRAIL (0.1 µg/mL) and ADM (0.5 µg/mL). In addition, the combined treatment with TRAIL and ADM significantly increased cell apoptosis from 9.8% (TRAIL) or 17% (ADM) to 38.7%, resulting in a synergistic apoptotic effect, which is proposed to be mediated by up-regulation of DR4 and DR5 mRNA expression and increased expression of Bax and caspase-9 proteins. These results suggest that the combination of TRAIL and ADM might be a promising therapy for breast cancer.

Memorandum of material furnished for superstructure on the line of the Port Dalhousie Thorold Railway by contract

Memorandum of material furnished for superstructure on the line of the Port Dalhousie Thorold Railway by contract. This document includes: Bills of timber, memorandums of planking, fencing, ties, track laying, masonry and bolts and spikes. There are also diagrams of culverts. One of the pages is loose and the outer pages are somewhat discoloured (32 pages, handwritten and bound with ribbon, n.d.