Towards a GIS-T database design and implementation for public transit planning: the case study of Dar-Es-salaam metropolitan city, Tanzania.

Dissertation submitted in partial fulfilment of the requirements for the Degree of Master of Science in Geospatial Technologies

Design and evaluation of a consulting system for database design

Database design is a difficult problem for non-expert designers. It is desirable to assist such designers during the problem solving process by means of a knowledge based (KB) system. A number of prototype KB systems have been proposed, however there are many shortcomings. Few have incorporated sufficient expertise in modeling relationships, particularly higher order relationships. There has been no empirical study that experimentally tested the effectiveness of any of these KB tools. Problem solving behavior of non-experts, whom the systems were intended to assist, has not been one of the bases for system design. In this project a consulting system for conceptual database design that addresses the above short comings was developed and empirically validated.^ The system incorporates (a) findings on why non-experts commit errors and (b) heuristics for modeling relationships. Two approaches to knowledge base implementation--system restrictiveness and decisional guidance--were used and compared in this project. The Restrictive approach is proscriptive and limits the designer's choices at various design phases by forcing him/her to follow a specific design path. The Guidance system approach which is less restrictive, provides context specific, informative and suggestive guidance throughout the design process. The main objectives of the study are to evaluate (1) whether the knowledge-based system is more effective than a system without the knowledge-base and (2) which knowledge implementation--restrictive or guidance--strategy is more effective. To evaluate the effectiveness of the knowledge base itself, the two systems were compared with a system that does not incorporate the expertise (Control).^ The experimental procedure involved the student subjects solving a task without using the system (pre-treatment task) and another task using one of the three systems (experimental task). The experimental task scores of those subjects who performed satisfactorily in the pre-treatment task were analyzed. Results are (1) The knowledge based approach to database design support lead to more accurate solutions than the control system; (2) No significant difference between the two KB approaches; (3) Guidance approach led to best performance; and (4) The subjects perceived the Restrictive system easier to use than the Guidance system. ^

Design and evaluation of a consulting system for database design

Database design is a difficult problem for non-expert designers. It is desirable to assist such designers during the problem solving process by means of a knowledge based (KB) system. Although a number of prototype KB systems have been proposed, there are many shortcomings. Firstly, few have incorporated sufficient expertise in modeling relationships, particularly higher order relationships. Secondly, there does not seem to be any published empirical study that experimentally tested the effectiveness of any of these KB tools. Thirdly, problem solving behavior of non-experts, whom the systems were intended to assist, has not been one of the bases for system design. In this project, a consulting system, called CODA, for conceptual database design that addresses the above short comings was developed and empirically validated. More specifically, the CODA system incorporates (a) findings on why non-experts commit errors and (b) heuristics for modeling relationships. Two approaches to knowledge base implementation were used and compared in this project, namely system restrictiveness and decisional guidance (Silver 1990). The Restrictive system uses a proscriptive approach and limits the designer's choices at various design phases by forcing him/her to follow a specific design path. The Guidance system approach, which is less restrictive, involves providing context specific, informative and suggestive guidance throughout the design process. Both the approaches would prevent erroneous design decisions. The main objectives of the study are to evaluate (1) whether the knowledge-based system is more effective than the system without a knowledge-base and (2) which approach to knowledge implementation - whether Restrictive or Guidance - is more effective. To evaluate the effectiveness of the knowledge base itself, the systems were compared with a system that does not incorporate the expertise (Control). An experimental procedure using student subjects was used to test the effectiveness of the systems. The subjects solved a task without using the system (pre-treatment task) and another task using one of the three systems, viz. Control, Guidance or Restrictive (experimental task). Analysis of experimental task scores of those subjects who performed satisfactorily in the pre-treatment task revealed that the knowledge based approach to database design support lead to more accurate solutions than the control system. Among the two KB approaches, Guidance approach was found to lead to better performance when compared to the Control system. It was found that the subjects perceived the Restrictive system easier to use than the Guidance system.

Diseño e implementación de un sistema de control del consumo energético

Implementación de una base de datos transaccional para el control del consumo eléctrico mediante contadores inteligentes. La base de datos propuesta permite desarrollar los diferentes compromisos de gestión de las compañías suministradoras, consumidores, contadores, consumos y núcleos energéticos (smart cities), proporcionando los procedimientos almacenados necesarios para su gestión. También se desarrolla la implementación de una base de datos analítica, data warehouse, para la explotación de los datos almacenados en la primera parte del proyecto. El objetivo es la implementación de las entidades necesarias para la explotación analítica de los datos mediante consultas sencillas.

Sistema BBDD : Gestión del consumo energético

El trabajo propuesto consiste en implementar un sistema de BD para dar respuesta a una necesidad planteada para la Comisión Europea de la energía que necesita tener controlada la gestión del consumo energético que hacen las diferentes compañías implicadas en el suministro y control de este servicio.

Disseny i implementació d'un sistema de control del grau de satisfacció dels clients dels serveis de restauració

Diseño de un sistema de control de la satisfacción a partir de las valoraciones a distintas empresas de restauración emitidas por clientes, inspectores y recopiladas de otras aplicaciones externas, que calcula una puntuación mensual a partir de una fórmula matemática que puede ir variando. Permite realizar consultas estadísticas relacionadas con las distintas valoraciones emitidas y las puntuaciones mensuales.

Audit management

El present document recull la memòria que descriu el meu treball de final de grau d'enginyeria informàtica del àrea de bases de dades. Aquest projecte es centra en la realització del disseny, implementació i validació d'una base de dades relacional que donarà resposta a la necessitat de les empreses certificades amb l'ISO 9001, 13485 o que treballin sota la regulació GxP, de portar una gestió i control de les accions correctives i accions preventives, des d'ara anomenades CAPA, resultats d'observacions detectades en auditories de qualitat tant internes com externes. La validació d'aquesta base de dades s'ha realitzat sota l'estàndard quemarquen les GAMP5.

An integrated database on ticks and tick-borne zoonoses in the tropics and subtropics with special reference to developing and emerging countries

Tick-borne zoonoses (TBZ) are emerging diseases worldwide. A large amount of information (e.g. case reports, results of epidemiological surveillance, etc.) is dispersed through various reference sources (ISI and non-ISI journals, conference proceedings, technical reports, etc.). An integrated database-derived from the ICTTD-3 project (http://www.icttd.nl)-was developed in order to gather TBZ records in the (sub-)tropics, collected both by the authors and collaborators worldwide. A dedicated website (http://www.tickbornezoonoses.org) was created to promote collaboration and circulate information. Data collected are made freely available to researchers for analysis by spatial methods, integrating mapped ecological factors for predicting TBZ risk. The authors present the assembly process of the TBZ database: the compilation of an updated list of TBZ relevant for (sub-)tropics, the database design and its structure, the method of bibliographic search, the assessment of spatial precision of geo-referenced records. At the time of writing, 725 records extracted from 337 publications related to 59 countries in the (sub-)tropics, have been entered in the database. TBZ distribution maps were also produced. Imported cases have been also accounted for. The most important datasets with geo-referenced records were those on Spotted Fever Group rickettsiosis in Latin-America and Crimean-Congo Haemorrhagic Fever in Africa. The authors stress the need for international collaboration in data collection to update and improve the database. Supervision of data entered remains always necessary. Means to foster collaboration are discussed. The paper is also intended to describe the challenges encountered to assemble spatial data from various sources and to help develop similar data collections.

Database repairs with answer set programming

Dissertação para obtenção do Grau de Mestre em Engenharia Informática

Sistema de control de registros sanitarios de productos cosméticos

El presente TFG versa sobre el análisis, diseño e implementación en Oracle de una base de datos y almacén de datos (actualizable en tiempo real) para gestionar un sistema de control de registros sanitarios de productos cosméticos.

A design for an advanced architecture of satellite ground segments

This project proposes a preliminary architectural design for a control and data processing center, also known as 'ground segment', for Earth observation satellites.

Breast, colorectal, and prostate cancer risk in the European Prospective Investigation into Cancer and Nutrition–Norfolk in relation to phytoestrogen intake derived from an improved database

Background: The characterization of phytoestrogen intake and cancer risk has been hindered by the absence of accurate dietary phytoestrogen values. Objective: We examined the risk of breast, colorectal, and prostate cancers relative to phytoestrogen intake on the basis of a comprehensive database. Design: Demographic and anthropometric characteristics, a medical history, and 7-d records of diet were collected prospectively from participants (aged 40–79 y) in the European Prospective Investigation into Cancer and Nutrition–Norfolk (EPIC-Norfolk). Five hundred nine food items were analyzed by liquid chromatography–mass spectrometry/mass spectrometry, and 13C3-labeled internal standards were analyzed for isoflavones (genistein, daidzein, glycitein, biochanin A, and formononetin), lignans (secoisolariciresinol and matairesinol), and enterolignans from gut microbial metabolism in animal food sources (equol and enterolactone). From the direct analysis, values for 10,708 foods were calculated. Odds ratios (ORs) for breast (244 cases, 941 controls), colorectal (221 cases, 886 controls), and prostate (204 cases, 812 controls) cancers were calculated relative to phytoestrogen intake. Results: Phytoestrogen intake was not associated with breast cancer among women or colorectal cancer among men. Among women, colorectal cancer risk was inversely associated with enterolactone (OR: 0.33; 95% CI: 0.14, 0.74) and total enterolignans (OR: 0.32; 95% CI: 0.13, 0.79), with a positive trend detected for secoisolariciresinol (OR: 1.60; 95% CI: 0.96, 2.69). A positive trend between enterolignan intake and prostate cancer risk (OR: 1.27; 95% CI: 0.97, 1.66) was attenuated after adjustment for dairy intake (OR: 1.19; 95% CI: 0.77, 1.82). Conclusion: Dietary phytoestrogens may contribute to the risk of colorectal cancer among women and prostate cancer among men.

An integrated database on ticks and tick-borne zoonoses in the tropics and subtropics with special reference to developing and emerging countries

Tick-borne zoonoses (TBZ) are emerging diseases worldwide. A large amount of information (e.g. case reports, results of epidemiological surveillance, etc.) is dispersed through various reference sources (ISI and non-ISI journals, conference proceedings, technical reports, etc.). An integrated database-derived from the ICTTD-3 project (http://www.icttd.nl)-was developed in order to gather TBZ records in the (sub-)tropics, collected both by the authors and collaborators worldwide. A dedicated website (http://www.tickbornezoonoses.org) was created to promote collaboration and circulate information. Data collected are made freely available to researchers for analysis by spatial methods, integrating mapped ecological factors for predicting TBZ risk. The authors present the assembly process of the TBZ database: the compilation of an updated list of TBZ relevant for (sub-)tropics, the database design and its structure, the method of bibliographic search, the assessment of spatial precision of geo-referenced records. At the time of writing, 725 records extracted from 337 publications related to 59 countries in the (sub-)tropics, have been entered in the database. TBZ distribution maps were also produced. Imported cases have been also accounted for. The most important datasets with geo-referenced records were those on Spotted Fever Group rickettsiosis in Latin-America and Crimean-Congo Haemorrhagic Fever in Africa. The authors stress the need for international collaboration in data collection to update and improve the database. Supervision of data entered remains always necessary. Means to foster collaboration are discussed. The paper is also intended to describe the challenges encountered to assemble spatial data from various sources and to help develop similar data collections.

AgroDB - integration of database management systems with crop models.

2016