Oracle RAC 12.1.0.1 : Alta disponibilitat per a bases de dades

Estudi sobre les funcionalitats d'alta disponibilitat (Real Application Clusters) del programari gestor de bases de dades Oracle Database 12c.

Actualización, consolidación, migración y contingencia de un entorno hardware y software para la gestión de bases de datos

[ES]El objetivo de este Trabajo es el de actualizar un entorno de gestión de bases de datos existente a la versión 11.2 del software de bases de datos Oracle y a una plataforma hardware de última generación. Se migran con tiempo de parada cero varias bases de datos dispersas en distintos servidores a un entorno consolidado de dos nodos dispuestos en alta disponibilidad tipo "activo-activo" mediante Oracle RAC y respaldado por un entorno de contingencia totalmente independiente y sincronizado en tiempo real mediante Oracle GoldenGate. Se realiza un estudio del entorno actual y, realizando una estimación de crecimiento, se propone una configuración de hardware y software mínima para implementar con garantías de éxito los requerimientos del entorno de gestión de bases de datos a corto y medio plazo. Una vez adquirido el hardware, se lleva a cabo la instalación, actualización y configuración del Sistema Operativo y el acceso redundado de los servidores a la cabina de almacenamiento. Posteriormente se instala el software de clúster de Oracle, el software de la base de datos y se crea una instancia que albergará los esquemas requeridos de las bases de datos a consolidar. Seguidamente se migran los esquemas al entorno consolidado y se establece la replicación de éstos en tiempo real con la máquina de contingencia usando en ambos casos Oracle GoldenGate. Finalmente se crea y prueba un esquema de copias de seguridad que incluye copias lógicas y físicas de la propia base de datos y de archivos de configuración del clúster a partir de los cuales será posible restaurar el entorno completamente.

Different coordination modes for disulfoxides towards diorganotin(IV) dichlorides. X-ray crystal structures of 1,2-cis-bis-(phenylsulfinyl)ethene (rac-,cis-cbpse) and adducts [{Ph2SnCl2(meso-bpse)}n] and [{n-Bu2SnCl2(pdtd)}2]

The reactions of meso-1,2-bis(phenylsulfinyl)ethane (meso-bpse) with Ph2SnCl2, 2-phenyl-1,3-dithiane trans-1-trans-3-dioxide (pdtd) with n-Bu2SnCl2 and 1,2-cis-bis-(phenylsulfinyl)ethene (rac-,cis-cbpse) with Ph2SnCl2, in 1:1 molar ratio, yielded [{Ph2SnCl2(meso-bpse)}n], [{n-Bu2SnCl2(pdtd)}2] and [{Ph2SnCl2(rac,cis-cbpse)}x] (x = 2 or n), respectively. All adducts were studied by IR, Mössbauer and 119Sn NMR spectroscopic methods, elemental analysis and single crystal X-ray diffractometry. The X-ray crystal structure of [{Ph2SnCl2(meso-bpse)}n] revealed the occurrence of infinite chains in which the tin(IV) atoms appear in a distorted octahedral geometry with Cl atoms in cis and Ph groups in trans positions. The X-ray crystal structure of [{n-Bu2SnCl2(pdtd)}2] revealed discrete centrosymmetric dimeric species in which the tin(IV) atoms possess a distorted octahedral geometry with bridging disulfoxides in cis and n-butyl moieties in trans positions. The spectroscopic data indicated that the adduct containing the rac,cis-cbpse ligand can be dimeric or polymeric. The X-ray structural analysis of the free rac-,cis-cbpse sulfoxide revealed that the crystals belong to the C2/c space group.

An oracle approach for interaction neighborhood estimation in random fields

We consider the problem of interaction neighborhood estimation from the partial observation of a finite number of realizations of a random field. We introduce a model selection rule to choose estimators of conditional probabilities among natural candidates. Our main result is an oracle inequality satisfied by the resulting estimator. We use then this selection rule in a two-step procedure to evaluate the interacting neighborhoods. The selection rule selects a small prior set of possible interacting points and a cutting step remove from this prior set the irrelevant points. We also prove that the Ising models satisfy the assumptions of the main theorems, without restrictions on the temperature, on the structure of the interacting graph or on the range of the interactions. It provides therefore a large class of applications for our results. We give a computationally efficient procedure in these models. We finally show the practical efficiency of our approach in a simulation study.

Stereoselective analysis of thioridazine-2-sulfoxide and thioridazine-5-sulfoxide: An investigation of rac-thioridazine biotransformation by some endophytic fungi

The purpose of this study was to develop a method for the stereoselective analysis of thioridazine-2-sulfoxide (THD-2-SO) and thioridazine-5-sulfoxide (THD-5-SO) in culture medium and to study the biotransformation of rac-thioridazine (THD) by some endophytic fungi. The simultaneous resolution of THD-2-SO and THD-5-SO diastereoisomers was performed on a CHIRALPAK(R) AS column using a mobile phase of hexane: ethanol: methanol (92:6:2, v/v/v) + 0.5% diethylamine; UV detection was carried out at 262 nm. Diethyl ether was used as extractor solvent. The validated method was used to evaluate the biotransformation of THD by 12 endophytic fungi isolated from Tithonia diversifolia, Viguiera arenaria and Viguiera robusta. Among the 12 fungi evaluated, 4 of them deserve prominence for presenting an evidenced stereoselective biotransformation potential: Phomopsis sp. (TD2) presented greater mono-2-sulfoxidation to the form (S)-(SE) (12.1%); Glomerella cingulata (VA1) presented greater mono-5-sulfoxidation to the forms (S)-(SE) + (R)-(FE) (10.5%); Diaporthe phaseolorum (VR4) presented greater mono-2-sulfoxidation to the forms (S)-(SE) and (R)-(FE) (84.4% and 82.5%, respectively) and Aspergillus fumigatus (VR12) presented greater mono-2-sulfoxidation to the forms (S)-(SE) and (R)-(SE) (31.5% and 34.4%, respectively). (C) 2007 Elsevier B.V. All rights reserved.

E-cadherin homophilic ligation directly signals through Rac and phosphatidylinositol 3-kinase to regulate adhesive contacts

Classical cadherins mediate cell recognition and cohesion in many tissues of the body. It is increasingly apparent that dynamic cadherin contacts play key roles during morphogenesis and that a range of cell signals are activated as cells form contacts with one another. It has been difficult, however, to determine whether these signals represent direct downstream consequences of cadherin ligation or are juxtacrine signals that are activated when cadherin adhesion brings cell surfaces together but are not direct downstream targets of cadherin signaling. In this study, we used a functional cadherin ligand (hE/Fc) to directly test whether E-cadherin ligation regulates phosphatidylinositol 3-kinase (PI 3-kinase) and Rac signaling. We report that homophilic cadherin ligation recruits Rae to nascent adhesive contacts and specifically stimulates Rae signaling. Adhesion to hE/Fc also recruits PI 3-kinase to the cadherin complex, leading to the production of phosphatidylinositol 3,4,5-trisphosphate in nascent cadherin contacts. Rae activation involved an early phase, which was PI 3-kinase-independent, and a later amplification phase, which was inhibited by wortmannin. PI 3-kinase and Rae activity were necessary for productive adhesive contacts to form following initial homophilic ligation. We conclude that E-cadherin is a cellular receptor that is activated upon homophilic ligation to signal through PI 3-kinase and Rae. We propose that a key function of these cadherin-activated signals is to control adhesive contacts, probably via regulation of the actin cytoskeleton, which ultimately serves to mediate adhesive cell-cell recognition.

Desenho e desenvolvimento de um Sistema de Informação em Oracle ADF

Um Sistema de Informação consiste num sistema capaz de armazenar, organizar e estruturar dados para ajudar a responder às necessidades das empresas, passando também pela capacidade de resposta às questões diárias das empresas. Assim, um Sistema de Informação pode ser definido como o software que ajuda a organizar e analisar dados, tendo como objetivo fornecer informação útil na altura certa para que possa ser utilizada para a tomada de decisões ou para uma gestão mais eficiente dos diversos fluxos que uma empresa pode conter. Neste sentido, o projeto apresentado centra-se no desenho e construção de um Sistema de Informação capaz de gerir o negócio de uma empresa do setor alimentar, mais propriamente do setor da transformação de carnes. Foi desenvolvido em Oracle ADF, de forma a aproveitar as vantagens inerentes à tecnologia e ao desenvolvimento web. Sendo uma tecnologia relativamente nova no mercado e dominada por poucos, a sua utilização neste momento pode tornar-se uma grande vantagem. Para o desenvolvimento da aplicação foi realizado o levantamento e análise de requisitos, foi criada a base de dados capaz de suportar o funcionamento do software e desenvolvido um sistema de login, capaz de gerir as sessões de cada utilizador. Foi implementado um processo de introdução e edição de informação, nomeadamente o registo de entradas, transformações e saídas. Contemplou-se também uma secção com dados mestre da empresa com a possibilidade de inserção, atualização e/ou remoção. Além disso, foram incorporadas validações em todos os processos que são usados pelos utilizadores, de modo a evitar a existência de dados incoerentes ou duplicados. Relativamente à lógica de negócio, foi embutida na aplicação de forma a permitir consultar a informação de forma clara, rápida e em diversos lugares, reduzindo tempo e tarefas ao colaborador/utilizador, visto que os processos foram automatizados. Com a implementação deste Sistema de Informação, a empresa pode usufruir de um sistema integrado capaz de gerir e controlar todo o seu processo produtivo, reduzindo custos e desperdícios, aumentando a produtividade e eficiência.

Oracle teleservice

Aquest projecte es basa en la implantació del mòdul Oracle Service del producte de CRM d'Oracle. Aquest mòdul ens proporciona la funcionalitat necessària per gestionar tot allò relacionat amb el Servei d’Atenció a l'Usuari. Mirarem d'oferir una visió àmplia basada en el concepte de CRM i en les seves claus d’èxit, així com en la importància de l'organització i de la reestructuració empresarial que se'n deriva. Utilitzarem l'estratègia d’implantació ràpida que proporciona Oracle i descriurem la manera de parametritzar el mòdul Oracle Service amb la finalitat de portar l’estandard a la solució desitjada pel client de manera ràpida i eficaç.

Els àngels de la "New Age" : la literatura didàctica i les cartes oracle que tracten d'ensenyar a comunicar-se amb els àngels

Una mirada des dels Estudis Culturals sobre la literatura didàctica i les cartes oracle que tracten d'ensenyar a comunicar-se amb els àngels. Són productes relativament nous en el mercat, comercialitzats per les indústries culturals i generats en el sector dels nous moviments religiosos conegut com New Age.

The Quest for the Oracle Birds: Researching the Chinese Community in Colonial Mexico (1565-1700)

The Asian Diaspora in the Americas in the 16th and 17th has been neglected by scholars for a long time. This fact is baffling, not only for the great interest of this topic in of itself, but also because it could provide new knowledge of colonial Mexico, especially in terms of the interaction among the many groups that populated the colony. This early movement of people and ideas across the largest extension of water in the planet is characteristic of what has been called the ¿archaic globalization,¿ and thus research on these matters could contribute to the history of globalization.In this presentation, I seek to further elaborate on the themes outlined by Edward Slack in The Chinos in New Spain: A Corrective Lens for a Distorted Image, an article published in 2009 in the Journal of World History. Firstly, I would like to bring forth some evidence that indicates that Asian religious practices were present in Mexico in the 1600s. Furthermore, I will argue that the traces of these practices are still visible today, in the form of a popular fortune-telling tradition. Secondly, I intend to provide some information about the arrival, settlement and distribution of the Asian Diaspora. I will focus on their distribution within Mexico City. Thirdly, I will elaborate on their occupations, social status and daily life, as well as in the patterns in marriages and relations with other groups. And lastly, I will show how the guild of barbers served as an Asian immigrant reception network.

La vil·la romana de la casa del Racó

Aquest article presenta els resultats de l'excavació arqueològica de la vil·la romana de la 'Casa del Racó', al terme municipal de Sant Julià de Ramis, entre 1991 i 1992

Rehabilitació de Cal Racó

El treball consisteix en una proposta de rehabilitació d'una casa entre mitgeres situada al poble de Llardecans, analitzant les seves lesions i adaptant-la a la normativa vigent. El treball s'organitza de la manera següent: aixecament de plànols, descripció i anàlisis de l'estat actual, estudi patològic, intervenció de les lesions i proposta de reforma.