Computer Tips and Tricks Newsletter, October, 2005

Performance & Development Solutions (PDS) publishes a variety of newsletters that include some great information about our programs and services. Some of the topics you may find include: Upcoming Seminars Current events or news related to training Recognition of achievements How-to section

Domo Hogar, Automatització de l'habitatge

En aquest projecte crearem un sistema per automatitzar els diferents dispositius que podem trobar en una casa. En primer lloc dissenyarem el hardware que serà el sistema nerviós des del que controlarem els dispositius a través del port USB d’un ordinador. Aquest sistema nerviós serà el punt d’interconnexió entre els dispositius de la casa i l’ordinador central que els controlarà. A nivell de hardware, a més a més del mòdul d’entrades i sortides d’interconnexió amb els dispositius que hem esmentat, ens trobem amb la necessitat d’instal•lar un ordinador central i diferents aparells repartits per la casa per poder realitzar les nostres necessitats (accions dels diferents dispositius) des de qualsevol punt de la casa. Amb aquests requeriments haurem d’estudiar les diferents possibilitats per fer el nostre sistema el màxim d’eficaç possible. Finalitzat l’estudi del hardware necessari pel nostre projecte, el següent pas és dissenyar el software. Aquest software serà l’aplicació encarregada de controlar tot el maquinari que hem dissenyat anteriorment i rebrà el nom de DOMO HOGAR. Aquest estarà format per dos programes diferents, DOMO HOGAR SERVER i DOMO HOGAR TERMINAL, cadascun d’ells amb unes funcions específiques. DOMO HOGAR SERVER serà l’aplicació que residirà a l’ordinador central i que permetrà a l’administrador gestionar totes les parts de les que forma part el nostre sistema: dispositius, tasques, pre-condicions, etc... També des d’aquesta aplicació editarem el panell tàctil que mostrarem des dels diferents terminals de l’habitatge. Per últim, aquesta aplicació també s’encarregarà de resoldre les peticions que farem, tant de l’ordinador central com dels terminals, i gestionar les diferents sortides en funció de l’acció a realitzar. Paral•lelament ens trobarem l’aplicació DOMO HOGAR TERMINAL que residirà en cada un dels terminals que hi hagi a la casa. Aquesta aplicació s’inicialitzarà llegint la configuració del panell tàctil de la base de dades de l’aplicació servidor resident a l’ordinador central i reconstruint una rèplica d’aquest panell tàctil. Finalment des d’aquesta aplicació terminal podrem donar ordres que seran emmagatzemades a la llista de tasques pendents de l’ordinador central perquè les resolgui des de l’aplicació del servidor. DOMO HOGAR ha estat creat per facilitar i confortar la vida quotidiana de les persones agilitzant el nostre dia a dia i permetent-nos invertir el nostre temps en les coses realment importants.

Maintenance Asset Management Project -- Phase II, July 31, 2013

Expanded abstract: Iowa Department of Transportation (IA DOT) is finalizing research to streamline field inventory/inspection of culverts by Maintenance and Construction staff while maximizing the use of tablet technologies. The project began in 2011 to develop some new best practices for field staff to assist in the inventory, inspection and maintenance of assets along the roadway. The team has spent the past year working through the complexities of identifying the most appropriate tablet hardware for field data collection. A small scale deployment of tablets occurred in spring of 2013 to collect several safety related assets (culverts, signs, guardrail, and incidents). Data can be collected in disconnected or connected modes and there is an associated desktop environment where data can be viewed and queried after being synced into the master database. The development of a deployment plan and related workflow processes are underway; which will eventually feed information into IA DOTs larger asset management system and make the information available for decision making. The team is also working with the IA DOT Design Office on Computer Aided Drafting (CAD) data processing and the IA DOT Construction office with a new digital As-Built plan process to leverage the complete data life-cycle so information can be developed once and leveraged by the Maintenance staff farther along in the process.

Management of hepatitis C virus (HCV) infection in drug substitution programs.

BACKGROUND: In Switzerland, intravenous drug use (IDU) accounts for 80% of newly acquired hepatitis C virus (HCV) infections. Early HCV treatment has the potential to interrupt the transmission chain and reduce morbidity/mortality due to decompensated liver cirrhosis and hepatocellular carcinoma. Nevertheless, patients in drug substitution programs are often insufficiently screened and treated. OBJECTIVE/METHODS: With the aim to improve HCV management in IDUs, we conducted a cross sectional chart review in three opioid substitution programs in St. Gallen (125 methadone and 71 heroin recipients). Results were compared with another heroin substitution program in Bern (202 patients) and SCCS/SHCS data. RESULTS: Among the methadone/heroin recipients in St. Gallen, diagnostic workup of HCV was better than expected: HCV/HIV-status was unknown in only 1% (2/196), HCV RNA was not performed in 9% (13/146) of anti-HCV-positives and the genotype missing in 15% (12/78) of HCV RNA-positives. In those without spontaneous clearance (two thirds), HCV treatment uptake was 23% (21/91) (HIV-: 29% (20/68), HIV+: 4% (1/23)), which was lower than in methadone/heroin recipients and particularly non-IDUs within the SCCS/SHCS, but higher than in the, mainly psychiatrically focussed, heroin substitution program in Bern (8%). Sustained virological response (SVR) rates were comparable in all settings (overall: 50%, genotype 1: 35-40%, genotype 3: two thirds). In St. Gallen, the median delay from the estimated date of infection (IDU start) to first diagnosis was 10 years and to treatment was another 7.5 years. CONCLUSIONS: Future efforts need to focus on earlier HCV diagnosis and improvement of treatment uptake among patients in drug substitution programs, particularly if patients are HIV-co-infected. New potent drugs might facilitate the decision to initiate treatment.

ABS: a database of Annotated regulatory Binding Sites from orthologous promoters

Information about the genomic coordinates and the sequence of experimentally identified transcription factor binding sites is found scattered under a variety of diverse formats. The availability of standard collections of such high-quality data is important to design, evaluate and improve novel computational approaches to identify binding motifs on promoter sequences from related genes. ABS (http://genome.imim.es/datasets/abs2005/index.html) is a public database of known binding sites identified in promoters of orthologous vertebrate genes that have been manually curated from bibliography. We have annotated 650 experimental binding sites from 68 transcription factors and 100 orthologous target genes in human, mouse, rat or chicken genome sequences. Computational predictions and promoter alignment information are also provided for each entry. A simple and easy-to-use web interface facilitates data retrieval allowing different views of the information. In addition, the release 1.0 of ABS includes a customizable generator of artificial datasets based on the known sites contained in the collection and an evaluation tool to aid during the training and the assessment of motif-finding programs.

XML-based information management environment for PE technologies

Printed electronics is an emerging concept in electronics manufacturing and it is in very early development stage. The technology is not stable, design kits are not developed, and flows and Computer Aided Design (CAD) tools are not fixed yet. The European project TDK4PE addresses all this issues and this PFC has been realized on this context. The goal is to develop an XML-based information system for the collection and management of information from the technology and cell libraries developed in TDK4PE. This system will ease the treatment of that information for a later generation of specific Design Kits (DK) and the corresponding documentation. This work proposes a web application to generate technology files and design kits in a formatted way; it also proposes a structure for them and a database implementation for storing the needed information. The application will allow its users to redefine the structure of those files, as well as export and import XML files, between other formats.

Segmentation model for small and medium size business sector: Case Oy Compaq Computer Ab

Markkinasegmentointi nousi esiin ensi kerran jo 50-luvulla ja se on ollut siitä lähtien yksi markkinoinnin peruskäsitteistä. Suuri osa segmentointia käsittelevästä tutkimuksesta on kuitenkin keskittynyt kuluttajamarkkinoiden segmentointiin yritys- ja teollisuusmarkkinoiden segmentoinnin jäädessä vähemmälle huomiolle. Tämän tutkimuksen tavoitteena on luoda segmentointimalli teollismarkkinoille tietotekniikan tuotteiden ja palveluiden tarjoajan näkökulmasta. Tarkoituksena on selvittää mahdollistavatko case-yrityksen nykyiset asiakastietokannat tehokkaan segmentoinnin, selvittää sopivat segmentointikriteerit sekä arvioida tulisiko tietokantoja kehittää ja kuinka niitä tulisi kehittää tehokkaamman segmentoinnin mahdollistamiseksi. Tarkoitus on luoda yksi malli eri liiketoimintayksiköille yhteisesti. Näin ollen eri yksiköiden tavoitteet tulee ottaa huomioon eturistiriitojen välttämiseksi. Tutkimusmetodologia on tapaustutkimus. Lähteinä tutkimuksessa käytettiin sekundäärisiä lähteitä sekä primäärejä lähteitä kuten case-yrityksen omia tietokantoja sekä haastatteluita. Tutkimuksen lähtökohtana oli tutkimusongelma: Voiko tietokantoihin perustuvaa segmentointia käyttää kannattavaan asiakassuhdejohtamiseen PK-yritys sektorilla? Tavoitteena on luoda segmentointimalli, joka hyödyntää tietokannoissa olevia tietoja tinkimättä kuitenkaan tehokkaan ja kannattavan segmentoinnin ehdoista. Teoriaosa tutkii segmentointia yleensä painottuen kuitenkin teolliseen markkinasegmentointiin. Tarkoituksena on luoda selkeä kuva erilaisista lähestymistavoista aiheeseen ja syventää näkemystä tärkeimpien teorioiden osalta. Tietokantojen analysointi osoitti selviä puutteita asiakastiedoissa. Peruskontaktitiedot löytyvät mutta segmentointia varten tietoa on erittäin rajoitetusti. Tietojen saantia jälleenmyyjiltä ja tukkureilta tulisi parantaa loppuasiakastietojen saannin takia. Segmentointi nykyisten tietojen varassa perustuu lähinnä sekundäärisiin tietoihin kuten toimialaan ja yrityskokoon. Näitäkään tietoja ei ole saatavilla kaikkien tietokannassa olevien yritysten kohdalta.

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.

Domo Hogar, Automatització de l'habitatge

En aquest projecte crearem un sistema per automatitzar els diferents dispositius que podem trobar en una casa. En primer lloc dissenyarem el hardware que serà el sistema nerviós des del que controlarem els dispositius a través del port USB d’un ordinador. Aquest sistema nerviós serà el punt d’interconnexió entre els dispositius de la casa i l’ordinador central que els controlarà. A nivell de hardware, a més a més del mòdul d’entrades i sortides d’interconnexió amb els dispositius que hem esmentat, ens trobem amb la necessitat d’instal•lar un ordinador central i diferents aparells repartits per la casa per poder realitzar les nostres necessitats (accions dels diferents dispositius) des de qualsevol punt de la casa. Amb aquests requeriments haurem d’estudiar les diferents possibilitats per fer el nostre sistema el màxim d’eficaç possible. Finalitzat l’estudi del hardware necessari pel nostre projecte, el següent pas és dissenyar el software. Aquest software serà l’aplicació encarregada de controlar tot el maquinari que hem dissenyat anteriorment i rebrà el nom de DOMO HOGAR. Aquest estarà format per dos programes diferents, DOMO HOGAR SERVER i DOMO HOGAR TERMINAL, cadascun d’ells amb unes funcions específiques. DOMO HOGAR SERVER serà l’aplicació que residirà a l’ordinador central i que permetrà a l’administrador gestionar totes les parts de les que forma part el nostre sistema: dispositius, tasques, pre-condicions, etc... També des d’aquesta aplicació editarem el panell tàctil que mostrarem des dels diferents terminals de l’habitatge. Per últim, aquesta aplicació també s’encarregarà de resoldre les peticions que farem, tant de l’ordinador central com dels terminals, i gestionar les diferents sortides en funció de l’acció a realitzar. Paral•lelament ens trobarem l’aplicació DOMO HOGAR TERMINAL que residirà en cada un dels terminals que hi hagi a la casa. Aquesta aplicació s’inicialitzarà llegint la configuració del panell tàctil de la base de dades de l’aplicació servidor resident a l’ordinador central i reconstruint una rèplica d’aquest panell tàctil. Finalment des d’aquesta aplicació terminal podrem donar ordres que seran emmagatzemades a la llista de tasques pendents de l’ordinador central perquè les resolgui des de l’aplicació del servidor. DOMO HOGAR ha estat creat per facilitar i confortar la vida quotidiana de les persones agilitzant el nostre dia a dia i permetent-nos invertir el nostre temps en les coses realment importants.

MODELING A COMPUTER APPLICATION FOR MANAGEMENT OF MAINTENANCE ACTIVITIES OF UNPAVED ROADS

ABSTRACTThis study presents a contribution to the modeling of a computer application employing a method of serviceability performance for unpaved roads, aiming the management of maintenance/restoration activities of the primary surface layer. The proposed methodology consisted of field inspections during dry (April to September) and rainy (October to March) periods, during which objective evaluations were performed to survey of defects and their densities and degrees of severity. To aid the functional classification of analyzed road sections and the determination of the defect with major influence on the serviceability of these roads, the method of serviceability performance proposed by Silva (2009)was implemented in the Visual Basic for Applications (VBA) language in Microsoft Excel software. With the use of the computer application proposed it was possible to identify among the defects analyzed in field, through the index of serviceability of the sampling unit per defect type (ISUdef), which one had the greatest influence on determining the relative serviceability index per road section (IST). The results allow us to conclude that the computer application Road achieved satisfactory results, since the objective evaluation criteria applied to road sections denotes consistency regarding their serviceability.

Memory Usage Inference for Object-Oriented Programs

We present a type-based approach to statically derive symbolic closed-form formulae that characterize the bounds of heap memory usages of programs written in object-oriented languages. Given a program with size and alias annotations, our inference system will compute the amount of memory required by the methods to execute successfully as well as the amount of memory released when methods return. The obtained analysis results are useful for networked devices with limited computational resources as well as embedded software.

A scaled-down conference model for courses covering ever-changing fields in computer science undergraduate degree programs

Resumen tomado de la publicación

An ontological approach to competency management

Competency management is a very important part of a well-functioning organisation. Unfortunately competency descriptions are not uniformly specified nor defined across borders: National, sectorial or organisational, leading to an opaque competency description market with a multitude of competency frameworks and competency benchmarks. An ontology is a formalised description of a domain, which enables automated reasoning engines to be built which by utilising the interrelations between entities can make “intelligent” choices in different situations within the domain. Introducing formalised competency ontologies automated tools, such as skill gap analysis, training suggestion generation, job search and recruitment, can be developed, which compare and contrast different competency descriptions on the semantic level. The major problem with defining a common formalised ontology for competencies is that there are so many viewpoints of competencies and competency frameworks. Work within the TRACE project has focused on finding common trends within different competency frameworks in order to allow an intermediate competency description to be made, which other frameworks can reference. This research has shown that competencies can be divided up into “knowledge”, “skills” and what we call “others”. An ontology has been created based on this with a simple structure of different “kinds” of “knowledges” and “skills” using semantic interrelations to define the basic semantic structure of the ontology. A prototype tool for analysing a skill gap analysis has been developed. Personal profiles can be produced using the tool and a skill gap analysis is performed on a desired competency profile by using an ontologically based inference engine, which is able to list closest fit and possible proficiency gaps

Adaptive project planning and management based on best practices - COBRA system

Planning a project with proper considerations of all necessary factors and managing a project to ensure its successful implementation will face a lot of challenges. Initial stage in planning a project for bidding a project is costly, time consuming and usually with poor accuracy on cost and effort predictions. On the other hand, detailed information for previous projects may be buried in piles of archived documents which can be increasingly difficult to learn from the previous experiences. Project portfolio has been brought into this field aiming to improve the information sharing and management among different projects. However, the amount of information that could be shared is still limited to generic information. This paper, we report a recently developed software system COBRA to automatically generate a project plan with effort estimation of time and cost based on data collected from previous completed projects. To maximise the data sharing and management among different projects, we proposed a method of using product based planning from PRINCE2 methodology. (Automated Project Information Sharing and Management System -�COBRA) Keywords: project management, product based planning, best practice, PRINCE2