SQL Query Completion for Data Exploration

Within the big data tsunami, relational databases and SQL are still there and remain mandatory in most of cases for accessing data. On the one hand, SQL is easy-to-use by non specialists and allows to identify pertinent initial data at the very beginning of the data exploration process. On the other hand, it is not always so easy to formulate SQL queries: nowadays, it is more and more frequent to have several databases available for one application domain, some of them with hundreds of tables and/or attributes. Identifying the pertinent conditions to select the desired data, or even identifying relevant attributes is far from trivial. To make it easier to write SQL queries, we propose the notion of SQL query completion: given a query, it suggests additional conditions to be added to its WHERE clause. This completion is semantic, as it relies on the data from the database, unlike current completion tools that are mostly syntactic. Since the process can be repeated over and over again -- until the data analyst reaches her data of interest --, SQL query completion facilitates the exploration of databases. SQL query completion has been implemented in a SQL editor on top of a database management system. For the evaluation, two questions need to be studied: first, does the completion speed up the writing of SQL queries? Second , is the completion easily adopted by users? A thorough experiment has been conducted on a group of 70 computer science students divided in two groups (one with the completion and the other one without) to answer those questions. The results are positive and very promising

ROR1 and ROR2 in Human Malignancies: Potentials for Targeted Therapy

Targeted therapies require cellular protein expression that meets specific requirements that will maximize effectiveness, minimize off-target toxicities, and provide an opportunity for a therapeutic effect. The receptor tyrosine kinase-like orphan receptors (ROR) are possible targets for therapy that may meet such requirements. RORs are transmembrane proteins that are part of the receptor tyrosine kinase (RTK) family. The RORs have been shown to play a role in tumor-like behavior, such as cell migration and cell invasiveness and are normally not expressed in normal adult tissue. As part of the large effort in target discovery, ROR proteins have recently been found to be expressed in human cancers. Their unique expression profiles may provide a novel class of therapeutic targets for small molecules against the kinase or for antibody-based therapies against these receptors. Being restricted on tumor cells and not on most normal tissues, RORs are excellent targets for the treatment of minimal residual disease, the final hurdle in the curative approach to many cancers, including solid tumors such as neuroblastoma. In this review, we summarize the biology of RORs as they relate to human cancer, and highlight the therapeutic approaches directed toward them

The Way to Spray: Modeling Nasal Spray Deposition

Intranasal drug delivery is an alternative method in addition to traditional oral and intravenous doses. Nasal drug delivery has proven to be a very effective technique for nicotine cessation (Hjalmarson et al., 1994), the influenza vaccine (Jackson et al. 1999), and drugs that need to be take continuously, such as insulin (Dondeti et al., 1995). Studies have found that for effective fast-acting body response, the drug needs to be deposited in the highly vascularized mucosal tissue lining the bony turbinates in the nasal cavity. Commercial nasal sprays are continuously optimizing parameters to develop the most effective deposition patterns. In this project, drug deposition is modeled using a simplified 2D depiction of the nasal passageway with uniformly-shaped, spherical spray particles. This problem is implemented in COMSOL by using 2D Navier Stokes fluid flow equations to model the airflow through the nose, and the Particle Tracing module to model the spray trajectory and deposition. The model output was validated by determining the percentages of particles in each region of the nasal passage - anterior, turbinate, posterior, and outlet - and comparing with published experimental data by Cheng et al (2001). A sensitivity analysis was done on the following parameters: particle density, particle size, nozzle spray angle, and nozzle penetration depth. It was found that this model was sensitive to only penetration depth. As penetration depth through the nostril increased, there was a decrease in the particle deposition in the anterior region of the nasal cavity and an increase in the percentage of particles that exited through the outlet. Deposition in the middle and posterior regions was not affected by variation in penetration depth. Our sensitivity analysis demonstrated that variations in spray angle, particle size, and density of the nasal spray fluid do not significantly affect deposition pattern. Therefore, when designing nasal sprays, as long as these parameters remain within the specified ranges, consistent deposition patterns will be achieved. This result also allows for further research on creating sprays that are more concentrated and have encapsulated drugs

La erradicación de las peores formas de trabajo infantil

La presente Tesis es el resultado de una investigación realizada basa ala realidad, cuyo objetivo principal fue el de llegar a establecer si la legislación peruana regula de una manera adecuada sobre la Erradicación de las Peores Formas trabajo infantil. A través del marco referencial y las bases teóricas, se busca lograr tener una concepción más clara de lo que es el trabajo infantil, causas, consecuencias, sus peores formas; los organismos e instituciones involucrados y ciertos aspectos relacionados con los mismos, permitiendo conocer otras legislaciones Internacionales relacionadas a la Erradicación de la Peores Formas de Trabajo Infantil y los instrumentos internacionales que regulan dicha temática, encontrándose entre los más importantes, el Convenio 138 de la OIT: Convenio sobre la Edad Mínima de Admisión al Empleo, y el Convenio 182 de la OIT: Convenio sobre la Prohibición de las Peores Formas de Trabajo Infantil y la Acción Inmediata para su Eliminación. Por ello es necesario mencionar que el trabajo infantil, afecta negativamente el óptimo desarrollo de los menores y puede convertirse en un factor de riesgo si el Estado a través de la legislación nacional no se adecuada a las normas internacionales para tratar de combatir las Peores Formas de Trabajo Infantil, los cuales ponen en peligro derechos fundamentales de los menores, quienes son el futuro del mañana

Duchenne de boulogne: Electrodiagnosis of poliomyelitis

Duchenne de Boulogne was among the first to investigate neuromuscular diseases. He stimulated muscle and nerve with moistened surface electrodes, thereby avoiding tissue necrosis. Technique and self-designed equipment are discussed in his first major work de I'electrisation localisee . During his 30 years of practice, he examined several hundred patients with poliomyelitis. With electrodiagnostic evaluation, he focused on “electrocontractility,” the intensity of muscle contraction elicited by electrical stimulation. Based on his electrophysiologic findings, Duchenne suggested that the responsible lesion resided within the spinal cord. He used electrical stimulation for treatment and recognized prognostic features.Peer Reviewedhttp://deepblue.lib.umich.edu/bitstream/2027.42/50146/1/880130111_ftp.pd

PARP-1 cooperates with Ptc1 to suppress medulloblastoma and basal cell carcinoma

n/