Automatic generation of ETL physical systems from BPMN conceptual models

ETL conceptual modeling is a very important activity in any data warehousing system project implementation. Owning a high-level system representation allowing for a clear identification of the main parts of a data warehousing system is clearly a great advantage, especially in early stages of design and development. However, the effort to model conceptually an ETL system rarely is properly rewarded. Translating ETL conceptual models directly into something that saves work and time on the concrete implementation of the system process it would be, in fact, a great help. In this paper we present and discuss a hybrid approach to this problem, combining the simplicity of interpretation and power of expression of BPMN on ETL systems conceptualization with the use of ETL patterns to produce automatically an ETL skeleton, a first prototype system, which has the ability to be executed in a commercial ETL tool like Kettle.

BiYacc: Roll your parser and reflective printer into one

In: A. Cunha, E. Kindler (eds.): Proceedings of the Fourth International Workshop on Bidirectional Transformations (Bx 2015), L’Aquila, Italy, July 24, 2015, published at http://ceur-ws.org

Embedding, evolution, and validation of model-driven spreadsheets

This paper proposes and validates a model-driven software engineering technique for spreadsheets. The technique that we envision builds on the embedding of spreadsheet models under a widely used spreadsheet system. This means that we enable the creation and evolution of spreadsheet models under a spreadsheet system. More precisely, we embed ClassSheets, a visual language with a syntax similar to the one offered by common spreadsheets, that was created with the aim of specifying spreadsheets. Our embedding allows models and their conforming instances to be developed under the same environment. In practice, this convenient environment enhances evolution steps at the model level while the corresponding instance is automatically co-evolved.Finally,wehave designed and conducted an empirical study with human users in order to assess our technique in production environments. The results of this study are promising and suggest that productivity gains are realizable under our model-driven spreadsheet development setting.

Towards an engine for coordination-based architectural reconfigurations

Software reconfigurability became increasingly relevant to the architectural process due to the crescent dependency of modern societies on reliable and adaptable systems. Such systems are supposed to adapt themselves to surrounding environmental changes with minimal service disruption, if any. This paper introduces an engine that statically applies reconfigurations to (formal) models of software architectures. Reconfigurations are specified using a domain specific language— ReCooPLa—which targets the manipulation of software coordinationstructures,typicallyusedinservice-orientedarchitectures(soa).Theengine is responsible for the compilation of ReCooPLa instances and their application to the relevant coordination structures. The resulting configurations are amenable to formal analysis of qualitative and quantitative (probabilistic) properties.

Metodologies de Desenvolupament Dirigides per Models

En aquest treball, s'introduiran dos de les metodologies de desenvolupament dirigides per models més significatives: Model Driven Architecture (MDA) i Domain Specific Modeling (DSM). Així mateix, es presentarà un estudi comparatiu d'algunes de les diferents eines existents actualment al mercat que els hi donen suport.

Body context and posture affect mental imagery of hands.

Different visual stimuli have been shown to recruit different mental imagery strategies. However the role of specific visual stimuli properties related to body context and posture in mental imagery is still under debate. Aiming to dissociate the behavioural correlates of mental processing of visual stimuli characterized by different body context, in the present study we investigated whether the mental rotation of stimuli showing either hands as attached to a body (hands-on-body) or not (hands-only), would be based on different mechanisms. We further examined the effects of postural changes on the mental rotation of both stimuli. Thirty healthy volunteers verbally judged the laterality of rotated hands-only and hands-on-body stimuli presented from the dorsum- or the palm-view, while positioning their hands on their knees (front postural condition) or behind their back (back postural condition). Mental rotation of hands-only, but not of hands-on-body, was modulated by the stimulus view and orientation. Additionally, only the hands-only stimuli were mentally rotated at different speeds according to the postural conditions. This indicates that different stimulus-related mechanisms are recruited in mental rotation by changing the bodily context in which a particular body part is presented. The present data suggest that, with respect to hands-only, mental rotation of hands-on-body is less dependent on biomechanical constraints and proprioceptive input. We interpret our results as evidence for preferential processing of visual- rather than kinesthetic-based mechanisms during mental transformation of hands-on-body and hands-only, respectively.

Knowledge management for systems biology a general and visually driven framework applied to translational medicine

Background: To enhance our understanding of complex biological systems like diseases we need to put all of the available data into context and use this to detect relations, pattern and rules which allow predictive hypotheses to be defined. Life science has become a data rich science with information about the behaviour of millions of entities like genes, chemical compounds, diseases, cell types and organs, which are organised in many different databases and/or spread throughout the literature. Existing knowledge such as genotype - phenotype relations or signal transduction pathways must be semantically integrated and dynamically organised into structured networks that are connected with clinical and experimental data. Different approaches to this challenge exist but so far none has proven entirely satisfactory. Results: To address this challenge we previously developed a generic knowledge management framework, BioXM™, which allows the dynamic, graphic generation of domain specific knowledge representation models based on specific objects and their relations supporting annotations and ontologies. Here we demonstrate the utility of BioXM for knowledge management in systems biology as part of the EU FP6 BioBridge project on translational approaches to chronic diseases. From clinical and experimental data, text-mining results and public databases we generate a chronic obstructive pulmonary disease (COPD) knowledge base and demonstrate its use by mining specific molecular networks together with integrated clinical and experimental data. Conclusions: We generate the first semantically integrated COPD specific public knowledge base and find that for the integration of clinical and experimental data with pre-existing knowledge the configuration based set-up enabled by BioXM reduced implementation time and effort for the knowledge base compared to similar systems implemented as classical software development projects. The knowledgebase enables the retrieval of sub-networks including protein-protein interaction, pathway, gene - disease and gene - compound data which are used for subsequent data analysis, modelling and simulation. Pre-structured queries and reports enhance usability; establishing their use in everyday clinical settings requires further simplification with a browser based interface which is currently under development.

Summarization of specialized discourse: the case of medical articles in Spanish

In this article, we present the current state of our work on a linguistically-motivated model for automatic summarization of medical articles in Spanish. The model takes into account the results of an empirical study which reveals that, on the one hand, domain-specific summarization criteria can often be derived from the summaries of domain specialists, and, on the other hand, adequate summarization strategies must be multidimensional, i.e., cover various types of linguistic clues. We take into account the textual, lexical, discursive, syntactic and communicative dimensions. This is novel in the field of summarization. The experiments carried out so far indicate that our model is suitable to provide high quality summarizations.

Lats2, a novel regulator of Elongin BC ubiquitin ligase

Résumé : Le Large tumor suppressor, Lats2, est une protéine humaine homologue au suppresseur de tumeur Warts (Lats) de Drosophila melanogaster, qui réprime la prolifération des cellules en altérant leur cycle au niveau des transitions Gl/S et G2/M, et en induisant l'apoptose. Pourtant, la voie moléculaire par laquelle Lats2, une sériase-thréonine kinase, déclenche l'arrêt du cycle cellulaire, est toujours inconnue. Notre équipe a d'abord déterminé que Lats2 était un gène de réponse à la protéine p53 (Kostic et al., 2000). Par la suite, nous avons identifié des protéines interagissant avec Lats2, notamment les modules de reconnaissance du substrat des ligases Colline E3 (des protéines contenant Socs box ou F box) ainsi que deux Bous-unités du Signalosome CSN: CSN4 et CSNS. En outre, Lats2 est connue pour s'associer au Super-complexe composé de CSN et des ligases Colline E3 (Rongere, thesis, 2004; Rongere, unpublished results, 2005). Le travail présenté ici sur Lats2 a confirmé que cette protéine est une kinase associée à CSN. Nous avons caractérisé les interactions spécifiques de domaines de Lats2 avec hSocs3, hWsb 1 (des protéines Socs box) et hFBX-7 (une protéine F box), ainsi que les conséquences physiologiques des interactions avec hSocs3, hWsb1 et hSocs1. Des expériences de GST pull-down ont montré que les deux domaines, N-terminal et kinase, de Lats2 interagissent avec hSocs3, hWsb1 et hFBX-7, ce qui suggère aussi que l'ensemble de la protéine Lats2 est impliqué dans ces interactions. Une étude approfondie des interactions entre Lats2 et hSocs3 indique que le domaine kinase de Lats2 interagit avec la région de hSocs3 contenant un domaine SH2, situé en amont du domaine Socs box de hSocs3. Par ailleurs, Lats2 phosphoryle des régions spécifiques entre les domaines N-terminal et SH2 (Sl), et, entre les domaines SH2 et Socs box (S3) de la protéine hSocs3. Ces résultats révèlent que hSocs3 est un.nouveau substrat de Lats2. Des modifications de l'activité kinase ont aussi révélé que la protéine sauvage Lats2 (wt Lats2) était capable de phosphoryler hSocs3, alors qu'un mutant dead du domaine kinase Lats (poche ATP délétée, Lats2OATP) non. L'analyse des mutations a permis d'identifier deux résidus sériase situés aux positions 1441145 (S3), spécifiquement phosphorylés par wt Lats2. La phosphorylation des protéines représentant un signal de dégradation protéolytique, nous avons envisagé que Lats2 pouvait cibler hSocs3 pour une dégradation protéasomale. Lorsque wt Lats2 est surexprimée dans des cellules HEK293T et COS7, la demi-vie de hSocs3, un élément de la ligase Elongine BC-Colline É3 (ligase EBC), diminue significativement, effet que n'a pas la surexpression de Lats2OATP. De plus, la stabilité de hSocs3 dépend de la phosphorylation des résidus sériase aux positions 144/145 par wt Lats2. Bien que les sites de phosphorylation ne soient pas définis pour les deux autres modules de reconnaissance du substrat de la ligase EBC: hWsb 1 et hSocsl, leurs demi-vies diminuent également quand wt Lats2 est surexprimée. Pour les tests in vivo, nous avons synthétisé des esiRNA pour diminuer l'expression du gène endogène lats2, ce qui a entraîné une augmentation d'un facteur 2 de la demi-vie de hSocs3 et de hWsbl dans les cellules HEK293T. En conclusion, nos résultats suggérent que Lats2, une kinase associée au CSN, est un nouveau régulateur de la fonction des ligases EBC, agissant sur le renouvellement des protéines hSocs3, hSocs1 et hWsb1. Ainsi, Lats2 altère la spécificité et la capacité des ligases EBC, régulant par là même la stabilité de nombreuses protéines, ciblées par les ligases EBC pour une dégradation protéasomale. D'autres études devraient révéler si la modification observée de la fonction de la ligase EBC par Lats2, associée au Super-complexe, est également responsable du renouvellement des régulateurs du cycle cellulaire et des changements dans ce même cycle observés lors de la surexpression de Lats2. Summary : The Large tumor suppressor 2 (Lats2) is a human homologue of the Drosophila melanogaster tumor suppressor Warts (Cats) who negatively regulates cell proliferation by altering cell cycle Gl/S and G2/M transition and inducing apoptosis. However, the molecular pathway by which Lats2, a serine-threonine kinase, mediates cell cycle arrest is still unknown. Lats2 was initially identified to be a p53 response gene by our group (Kostic et al., 2000). Subsequently, our group identified interacting candidates of Lats2, including substrate recognition modules of Cullin-based E3 ligases (Socs box or F-box containing proteins) as well as two subunits of the Signalosome (CSN), CSN4 and CSNS. Additionally, Lats2 was shown to associate with a Super-complex, composed of CSN and Cullin-based E3 ligases (Rongere, thesis, 2004; Rongere, unpublished results, 2005) We hypothesized that Lats2 may perform its physiological function through interaction with CSN and Cullin-based E3 ligases. The present work on Lats2 has confirmed that Lats2 is a CSN associated kinase. We defined the domain specific interactions of Lats2 with hSocs3, hWsb1 (Sots box proteins) and hFBX-7 (F box protein), as well as the physiological consequences of interaction with hSocs3, hWsb1 and hSocs1. Both the N-terminal and the kinase domains of Lats2 interact with full-length hSocs3, hWsb1 and hFBX-7, determined in GST pull-down assays suggesting that full-length Lats2 protein is involved in interactions. Refinement of the Lats2 interaction with hSocs3 indicated that the kinase domain of Lats2 interacts with a region of hSocs3 containing a SH2 domain located upstream of the Socs box domain of the hSocs3. Moreover, Lats2 phosphorylated specific regions between the N-terminal and SH2 domain (S l) as well as between the SH2 domain and Socs box domain of hSocs3 (S3).These results indicate that hSocs3 is a novel Lats2 substrate. The kinase assay has also demonstrated that wt Lats2 was able to phosphorylate hSocs3, but not Lats2 kinase dead mutant (deleted ATP pocket, Lats20ATP). Mutational analysis identified two serine residues located at positions 144/145 (S3) to be specifically phosphorylated by wt Lats2. Phosphorylation of proteins has been shown to be a signal for proteolytic degradation of many characterized proteins. Thus we hypothesized that Lats2 could target hSocs3 for proteasomal degradation. When wt Lats2 was over-expressed in HEK293T cells and COST cells, the half-life of hSocs3, as a component of Elongin BC Cullin-based E3 ubiquitin ligase (EBC ligase), decreased significantly. In contrast, aver-expression of the Lats2OATP did not alter the half-life of hSocs3. Furthermore, the stability of hSocs3 depended on phosphorylation of serine residues at positions 144/145 by wt Lats2. Although the sites of phosphorylation were not defined for two other substrate recognition modules of EBC ligasehWsbl and hSocsl, their half-lives also decreased when wt Lats2 was over-expressed. To test in vivo, we synthesized esiRNA to knock-down endogenous Lats2 and subsequently we measured the half-lives of hSocs3 and hVVsb l . Here we demonstrated that the half-lives of hSocs3 and hWsbl were increased by the factor of two in Lats2-depleted HEK293T cells. In conclusion, our findings suggest that Lats2, a CSN associated kinase, is a novel regulator of EBC ligase function by regulating the turn-over of hSocs3, hSocs1 and hWsb1. Thus, Lats2 alters the specificity and capacity of EBC ligases regulating thereby the stability of numerous proteins which are targeted by EBC ligases for proteasomal degradation. Further studies should reveal whether the observed modulation of EBC ligase function by Lats2 associated with a Super-complex is also responsible for the turn-over of cell cycle regulators and the observed alteration in cell cycle by Lats2 over-expression.

Performance evaluation of MPEG-4 Video encoder on Adres

Actualment un típic embedded system (ex. telèfon mòbil) requereix alta qualitat per portar a terme tasques com codificar/descodificar a temps real; han de consumir poc energia per funcionar hores o dies utilitzant bateries lleugeres; han de ser el suficientment flexibles per integrar múltiples aplicacions i estàndards en un sol aparell; han de ser dissenyats i verificats en un període de temps curt tot i l’augment de la complexitat. Els dissenyadors lluiten contra aquestes adversitats, que demanen noves innovacions en arquitectures i metodologies de disseny. Coarse-grained reconfigurable architectures (CGRAs) estan emergent com a candidats potencials per superar totes aquestes dificultats. Diferents tipus d’arquitectures han estat presentades en els últims anys. L’alta granularitat redueix molt el retard, l’àrea, el consum i el temps de configuració comparant amb les FPGAs. D’altra banda, en comparació amb els tradicionals processadors coarse-grained programables, els alts recursos computacionals els permet d’assolir un alt nivell de paral•lelisme i eficiència. No obstant, els CGRAs existents no estant sent aplicats principalment per les grans dificultats en la programació per arquitectures complexes. ADRES és una nova CGRA dissenyada per I’Interuniversity Micro-Electronics Center (IMEC). Combina un processador very-long instruction word (VLIW) i un coarse-grained array per tenir dues opcions diferents en un mateix dispositiu físic. Entre els seus avantatges destaquen l’alta qualitat, poca redundància en les comunicacions i la facilitat de programació. Finalment ADRES és un patró enlloc d’una arquitectura concreta. Amb l’ajuda del compilador DRESC (Dynamically Reconfigurable Embedded System Compile), és possible trobar millors arquitectures o arquitectures específiques segons l’aplicació. Aquest treball presenta la implementació d’un codificador MPEG-4 per l’ADRES. Mostra l’evolució del codi per obtenir una bona implementació per una arquitectura donada. També es presenten les característiques principals d’ADRES i el seu compilador (DRESC). Els objectius són de reduir al màxim el nombre de cicles (temps) per implementar el codificador de MPEG-4 i veure les diferents dificultats de treballar en l’entorn ADRES. Els resultats mostren que els cícles es redueixen en un 67% comparant el codi inicial i final en el mode VLIW i un 84% comparant el codi inicial en VLIW i el final en mode CGA.

A further examination of the distinction between dependency-oriented and achievement-oriented parental psychological control: Psychometric properties of the DAPCS with French-speaking late adolescents

Psychological control refers to parental behaviors that intrude on the psychological and emotional development of the child. In 2010, Soenens and colleagues proposed a distinction between two domain-specific expressions of psychological control, that is, Dependency-oriented Psychological Control (DPC) and Achievement-oriented Psychological Control (APC). The aim of this study was to evaluate the factor structure, reliability, and convergent validity of the French form of the Dependency-oriented and Achievement-oriented Psychological Control Scale (DAPCS; Soenens, Vansteenkiste, and Luyten, 2010) in a sample of late adolescents (N = 291, mean age = 21.65). Confirmatory factor analyses confirmed the hypothesized two-factor solution of the DAPCS for paternal as well as for maternal ratings. Moreover, high indices of internal consistency indicated that both subscales produced reliable scores. Further, convergent validity was confirmed by theoretically consistent associations between the DAPCS' subscales and well-established assessments of general parenting style dimensions. Finally, results evidenced gender specific patterns supporting the relevance of domain differentiation in the assessment of psychological control. Overall, the results of this study indicated that the French form of the DAPCS might be a useful instrument to assess two domainspecific types of parental psychological control among French-speaking adolescents.

Recommended Practice for Accepting New Concrete Pavement Surfaces for Tire/Pavement Noise, March 2, 2011

This practice provides guidance and example specification language intended for use by Owner-Agencies in development of specific contract language when requiring the evaluation of tire/pavement noise for new concrete pavement surfaces. The overall sound intensity level is designated as the quality characteristic used for pay adjustment.

Spatial learning by rats across visually disconnected environments

Two spatial tasks were designed to test specific properties of spatial representation in rats. In the first task, rats were trained to locate an escape hole at a fixed position in a visually homogeneous arena. This arena was connected with a periphery where a full view of the room environment existed. Therefore, rats were dependent on their memory trace of the previous position in the periphery to discriminate a position within the central region. Under these experimental conditions, the test animals showed a significant discrimination of the training position without a specific local view. In the second task, rats were trained in a radial maze consisting of tunnels that were transparent at their distal ends only. Because the central part of the maze was non-transparent, rats had to plan and execute appropriate trajectories without specific visual feedback from the environment. This situation was intended to encourage the reliance on prospective memory of the non-visited arms in selecting the following move. Our results show that acquisition performance was only slightly decreased compared to that shown in a completely transparent maze and considerably higher than in a translucent maze or in darkness. These two series of experiments indicate (1) that rats can learn about the relative position of different places with no common visual panorama, and (2) that they are able to plan and execute a sequence of visits to several places without direct visual feed-back about their relative position.

Data Collection Agent Framework

Ohjelmistoteollisuudessa pitkiä ja vaikeita kehityssyklejä voidaan helpottaa käyttämällä hyväksi ohjelmistokehyksiä (frameworks). Ohjelmistokehykset edustavat kokoelmaa luokkia, jotka tarjoavat yleisiä ratkaisuja tietyn ongelmakentän tarpeisiin vapauttaen ohjelmistokehittäjät keskittymään sovelluskohtaisiin vaatimuksiin. Hyvin suunniteltujen ohjelmistokehyksien käyttö lisää suunnitteluratkaisujen sekä lähdekoodin uudelleenkäytettävyyttä enemmän kuin mikään muu suunnittelulähestymistapa. Tietyn kohdealueen tietämys voidaan tallentaa ohjelmistokehyksiin, joista puolestaan voidaan erikoistaa viimeisteltyjä ohjelmistotuotteita. Tässä diplomityössä kuvataan ohjelmistoagentteihin (software agents) perustuvaa ohjelmistokehyksen suunnittelua toteutusta. Pääpaino työssä on vaatimusmäärittelyä vastaavan suunnitelman sekä toteutuksen kuvaaminen ohjelmistokehykselle, josta voidaan erikoistaa erilaiseen tiedonkeruuseen kykeneviä ohjelmistoja Internet ympäristöön. Työn kokeellisessa osuudessa esitellään myös esimerkkisovellus, joka perustuu työssä kehitettyyn ohjelmistokehykseen.

Searching electronic marketplaces

The main objective of this thesis was to analyze the usability of registers and indexes of electronic marketplaces. The work is focused on UDDI-based electronic marketplaces, which are standardized by the W3C. UDDI-registers are usable in intranets, extranets and in Internet. Using UDDI-registers Web-services can be searched in many ways, including alphabetical and domain specific searches. Humans and machines can use the features UDDI-registers. The thesis deals the design principles, architectures and specifications of UDDI-registers. In addition, the thesis includes the design and the specifications of an electronic marketplace developed for supporting electronic logistics services.