Prevalence and determinants of colonic polyps in children undergoing colonoscopy: A large hospital-based cross-sectional study

Background. Colorectal polyps are abnormal growths in the wall of the colon including the rectum. The study aims to estimate the prevalence and type of colonic polyps in children undergoing colonoscopic examination at Texas Children's Hospital (TCH) in Houston, Texas during 2000-2007. Also, to examine the factors associated with colonic polyps and the potential determinants of colonic polyps in children undergoing colonoscopy and compare those who had colonic polyps with those who did not on colonoscopy, and determine the significant risk factors of colonic polyps in these children. ^ Methods. We conducted a cross sectional study to analyze data collected at TCH. We obtained demographic, clinical, and histopathology information on consecutive patients who underwent colonoscopy during 2000-2007 from endoscopic records contained in the PEDS-CORI registry (Pediatric Endoscopy Database System-Clinical Outcomes Research Initiative), and abstracted data from the accompanying histopathology reports. ^ Results. We identified 2,693-unique patients, under 18 years of age, who underwent colonoscopy. Approximately 65.5% were white non-Hispanic, and 10.8% African-American. The mean age was 8.7 years and 51.8% were female patients. Polyps were present in 174 patients (6.5%). The most common two histological types were juvenile (60.6%), inflammatory (17.4%). We found that the prevalence of polyps was higher in younger aged children (12.9% in 0-5 years) than in older aged children (4% in 15-17 years), and slightly higher in males than in females (7.9% and 5.4% respectively). For males only, the odds of polyps were statistically significantly higher in Blacks and Hispanics compared to white non Hispanics (OR of 2.2 and 2.1, respectively, and 95% CI of 1.3, 3.9 and 1.3, 3.5 respectively). The indications for colonoscopy were different for children with polyps compared to those without polyps, i.e., 47.0% vs. 19.8% respectively for lower GI bleeding, 2.7% vs. 21.4% respectively for abdominal pain/bloating, and, or 0.9% vs. 9.6% respectively for diarrhea. ^ Conclusion. Colorectal polyps occur in about 1 in 15 children and adolescents undergoing first colonoscopy. The demographic variable of younger age is strongly associated with having polyps irrespective of ethnicity. Lower GI bleeding is strongly related to the presence of colorectal polyps in children and adolescents undergoing colonoscopy.^

NFC based remote control of services for interactive spaces

Ubiquitous computing (one person, many computers) is the third era in the history of computing. It follows the mainframe era (many people, one computer) and the PC era (one person, one computer). Ubiquitous computing empowers people to communicate with services by interacting with their surroundings. Most of these so called smart environments contain sensors sensing users’ actions and try to predict the users’ intentions and necessities based on sensor data. The main drawback of this approach is that the system might perform unexpected or unwanted actions, making the user feel out of control. In this master thesis we propose a different procedure based on Interactive Spaces: instead of predicting users’ intentions based on sensor data, the system reacts to users’ explicit predefined actions. To that end, we present REACHeS, a server platform which enables communication among services, resources and users located in the same environment. With REACHeS, a user controls services and resources by interacting with everyday life objects and using a mobile phone as a mediator between himself/herself, the system and the environment. REACHeS’ interfaces with a user are built upon NFC (Near Field Communication) technology. NFC tags are attached to objects in the environment. A tag stores commands that are sent to services when a user touches the tag with his/her NFC enabled device. The prototypes and usability tests presented in this thesis show the great potential of NFC to build such user interfaces.

Aplicación móvil multiplataforma para el aprendizaje de lenguajes de programación. Caso práctico con Swift

En este proyecto se ha estudiado el abanico de posibilidades que las plataformas web y móviles ofrecen para aprender lenguajes de programación compilados. A continuación, se ha realizado el diseño y la implementación de una plataforma para el aprendizaje de lenguajes de programación desde dispositivos móviles, con posibilidad de compilación remota desde la aplicación desarrollada, analizando el proceso y las elecciones de desarrollo tomadas. Así, se ha desarrollado una app mediante la plataforma de desarrollo Cordova, que puede ser distribuida para todas las plataformas móviles que esta soporta, incluyendo las más populares: iOS y Android. Para la parte servidora se ha utilizado un servidor Apache (PHP) y el sistema NoSQL MongoDB para la base de datos. Para mayor facilidad en la gestión del contenido de la app, se ha desarrollado en paralelo un gestor web de la base de datos, el cual permite añadir, editar y eliminar contenido de la misma a través de una interfaz agradable y funcional. ABSTRACT. In this project I have studied the range of possibilities that web and mobile platforms offer to learn compiled programming languages. Next, I have designed and implemented a platform for learning programming languages from mobile devices, giving the possibility of remote compilation within the developed application. In this terms, I have developed an app with the Cordova development platform, which can be distributed for all the mobile platforms Cordova supports, including the most popular ones: iOS and Android. For the server part, I have used an Apache (PHP) server and the NoSQL database system MongoDB. In order to offer a more usable system and a better database management, I have also developed a web manager for the database, from which database content can be added, edited and removed, through a clear and functional interface.

Methods and Techniques for the Generation and Eficient Exploitation of RDB2RDF Mappings

RDB to RDF Mapping Language (R2RML) es una recomendación del W3C que permite especificar reglas para transformar bases de datos relacionales a RDF. Estos datos en RDF se pueden materializar y almacenar en un sistema gestor de tripletas RDF (normalmente conocidos con el nombre triple store), en el cual se pueden evaluar consultas SPARQL. Sin embargo, hay casos en los cuales la materialización no es adecuada o posible, por ejemplo, cuando la base de datos se actualiza frecuentemente. En estos casos, lo mejor es considerar los datos en RDF como datos virtuales, de tal manera que las consultas SPARQL anteriormente mencionadas se traduzcan a consultas SQL que se pueden evaluar sobre los sistemas gestores de bases de datos relacionales (SGBD) originales. Para esta traducción se tienen en cuenta los mapeos R2RML. La primera parte de esta tesis se centra en la traducción de consultas. Se propone una formalización de la traducción de SPARQL a SQL utilizando mapeos R2RML. Además se proponen varias técnicas de optimización para generar consultas SQL que son más eficientes cuando son evaluadas en sistemas gestores de bases de datos relacionales. Este enfoque se evalúa mediante un benchmark sintético y varios casos reales. Otra recomendación relacionada con R2RML es la conocida como Direct Mapping (DM), que establece reglas fijas para la transformación de datos relacionales a RDF. A pesar de que ambas recomendaciones se publicaron al mismo tiempo, en septiembre de 2012, todavía no se ha realizado un estudio formal sobre la relación entre ellas. Por tanto, la segunda parte de esta tesis se centra en el estudio de la relación entre R2RML y DM. Se divide este estudio en dos partes: de R2RML a DM, y de DM a R2RML. En el primer caso, se estudia un fragmento de R2RML que tiene la misma expresividad que DM. En el segundo caso, se representan las reglas de DM como mapeos R2RML, y también se añade la semántica implícita (relaciones de subclase, 1-N y M-N) que se puede encontrar codificada en la base de datos. Esta tesis muestra que es posible usar R2RML en casos reales, sin necesidad de realizar materializaciones de los datos, puesto que las consultas SQL generadas son suficientemente eficientes cuando son evaluadas en el sistema gestor de base de datos relacional. Asimismo, esta tesis profundiza en el entendimiento de la relación existente entre las dos recomendaciones del W3C, algo que no había sido estudiado con anterioridad. ABSTRACT. RDB to RDF Mapping Language (R2RML) is a W3C recommendation that allows specifying rules for transforming relational databases into RDF. This RDF data can be materialized and stored in a triple store, so that SPARQL queries can be evaluated by the triple store. However, there are several cases where materialization is not adequate or possible, for example, if the underlying relational database is updated frequently. In those cases, RDF data is better kept virtual, and hence SPARQL queries over it have to be translated into SQL queries to the underlying relational database system considering that the translation process has to take into account the specified R2RML mappings. The first part of this thesis focuses on query translation. We discuss the formalization of the translation from SPARQL to SQL queries that takes into account R2RML mappings. Furthermore, we propose several optimization techniques so that the translation procedure generates SQL queries that can be evaluated more efficiently over the underlying databases. We evaluate our approach using a synthetic benchmark and several real cases, and show positive results that we obtained. Direct Mapping (DM) is another W3C recommendation for the generation of RDF data from relational databases. While R2RML allows users to specify their own transformation rules, DM establishes fixed transformation rules. Although both recommendations were published at the same time, September 2012, there has not been any study regarding the relationship between them. The second part of this thesis focuses on the study of the relationship between R2RML and DM. We divide this study into two directions: from R2RML to DM, and from DM to R2RML. From R2RML to DM, we study a fragment of R2RML having the same expressive power than DM. From DM to R2RML, we represent DM transformation rules as R2RML mappings, and also add the implicit semantics encoded in databases, such as subclass, 1-N and N-N relationships. This thesis shows that by formalizing and optimizing R2RML-based SPARQL to SQL query translation, it is possible to use R2RML engines in real cases as the resulting SQL is efficient enough to be evaluated by the underlying relational databases. In addition to that, this thesis facilitates the understanding of bidirectional relationship between the two W3C recommendations, something that had not been studied before.

Edinburgh, Scotland, United Kingdom, 1825 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Plan of Edinburgh and its environs, from a survey by James Knox ; engd. by R. Scott. It was published by John Fairbairn 13, Waterloo Place, Manners & Miller, ... and John Anderson, Junr. in 1825. Scale [ca. 1:6,000]. The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as roads, drainage, built-up areas and selected buildings, selected names of property owners, parks, ground cover, and more. Relief shown by hachures and spot heights. Includes population statistics from 1821 and note.This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

United Kingdom, 1826 (Image 1 of 3) (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Cary's six sheet map of England and Wales, with part of Scotland : on which are carefully laid down all the direct and principal cross roads, the course of the rivers, and navigable canals, cities, market and borough towns, the principal villages, parks, &c., compiled from the most recent surveys. It was published by J. Cary in 1826. Scale [ca. 1:510,000]. This layer is image 1 of 3 total images of the three sheet source map, representing the northern portion of the map. Covers portions of England, Scotland, North Ireland, and Isle of Man.The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as drainage, cities and other human settlements, mail roads, turnpike roads, bye roads, territorial and administrative boundaries, parks, shoreline features, and more. Relief shown by hachures.This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

United Kingdom, 1826 (Image 2 of 3) (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Cary's six sheet map of England and Wales, with part of Scotland : on which are carefully laid down all the direct and principal cross roads, the course of the rivers, and navigable canals, cities, market and borough towns, the principal villages, parks, &c., compiled from the most recent surveys. It was published by J. Cary in 1826. Scale [ca. 1:510,000]. This layer is image 2 of 3 total images of the three sheet source map, representing the southern portion of the map. Covers portions of England and Wales.The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as drainage, cities and other human settlements, mail roads, turnpike roads, bye roads, territorial and administrative boundaries, parks, shoreline features, and more. Relief shown by hachures.This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

United Kingdom, 1826 (Image 3 of 3) (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Cary's six sheet map of England and Wales, with part of Scotland : on which are carefully laid down all the direct and principal cross roads, the course of the rivers, and navigable canals, cities, market and borough towns, the principal villages, parks, &c., compiled from the most recent surveys. It was published by J. Cary in 1826. Scale [ca. 1:510,000]. This layer is image 3 of 3 total images of the three sheet source map, representing the central portion of the map. Covers portions of England, Wales, and Ireland.The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as drainage, cities and other human settlements, mail roads, turnpike roads, bye roads, territorial and administrative boundaries, parks, shoreline features, and more. Relief shown by hachures.This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

England and Wales, United Kingdom, 1774 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: The post roads thorough England and Wales, by T. Jefferys, geographer to His Majesty. It was published by Printed for Jefferys & Faden, Corner of St. Martins Lane, Charing Cross in 1774. Scale [ca. 1:1,325,000]. The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as drainage, cities and other human settlements, roads, canals, administrative boundaries, shoreline features, and more. Relief shown pictorially.This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

Military Districts, England and Wales, United Kingdom, 1804 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: A complete representation of the coast of England, together with the interior, divided into counties and military districts : also the coast of France and Holland from the Texel to Brest ... to which is annexed eighteen plans of the ports of the enemy, the principal depôts of the flotilla intended for the invasion of England, by John Luffman, Geogr. It was published by J. Luffman in 1804. Scale [ca. 1:2,500,000]. The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as drainage, cities and other human settlements, administrative and military district boundaries, shoreline features including distances between selected ports, and more. Includes insets of foreign military installations and index to the military districts. This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

Bath Region, England, 1744 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: An actual survey of the city of Bath, in the county of Somerset, and of five miles round : wherein are laid down all the villages, gentlemen's seats, farm houses, roads, high-ways, rivers, water courses, & all things worthy of observation, survey'd by Tho. Thorpe in the year 1742 ; engrav'd by James Cole. It was published by Thomas Thorpe, and Mr. Leake & Mr. Frederick Booksellers in 1743/4 [i.e. 1744]. Scale [ca. 1:16,300]. Covers the Bath Region, England.The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as roads, drainage, built-up areas and selected buildings, selected names of landowners, ground cover, parks, and more. Relief shown by hachures. Includes also index and a list of subscribers.This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

Birmingham, England, 1781 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Plan of Birmingham, survey'd by Thos. Hanson. It was published by Pearson & Rollason in 1781. Scale [ca. 1:6,900]. The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as roads, drainage, built-up areas and selected buildings, ground cover, parks, and more.This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

Brighton, England, 1820 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Plan of Brighton and its environs : including all the recent improvements by J. Sleath, sc. It was published by W. Saunders & Son in 1820. Scale [ca. 1:9,467].The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as roads, drainage, built-up areas and selected buildings, ground cover, parks, and more.This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

Bristol, England, 1890 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Plan of Bristol, drawn, engraved by G.W. Bacon & Co. New and rev. ed. It was published by James Fawn & Son, ca. 1890. Scale 1:10,560. The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as roads, railroads and stations, street railway lines, drainage, built-up areas and selected buildings, cemeteries, parks, and more. This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.

Winchester, England, 1809 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Ancient ichnography of the city of Winchester, Js. Cave delineavit ad mentem J. Milner. It was published by Jas. Robbins, March 1st, 1809. Scale [ca. 1:3,800].The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'British National Grid' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as roads, drainage, built-up areas and selected buildings, ground cover, parks, and more. Includes 2 insets: Ichnography of the environs of Winchester, Ichnography of the Cathedral Church.This layer is part of a selection of digitally scanned and georeferenced historic maps from the Harvard Map Collection. These maps typically portray both natural and manmade features. The selection represents a range of originators, ground condition dates, scales, and map purposes.