An automatic tool to Extract, Transform and Load data from real electricity markets

The study of Electricity Markets operation has been gaining an increasing importance in the last years, as result of the new challenges that the restructuring produced. Currently, lots of information concerning Electricity Markets is available, as market operators provide, after a period of confidentiality, data regarding market proposals and transactions. These data can be used as source of knowledge, to define realistic scenarios, essential for understanding and forecast Electricity Markets behaviour. The development of tools able to extract, transform, store and dynamically update data, is of great importance to go a step further into the comprehension of Electricity Markets and the behaviour of the involved entities. In this paper we present an adaptable tool capable of downloading, parsing and storing data from market operators’ websites, assuring actualization and reliability of stored data.

Preliminary inventory of published and unpublished sediment load data /

Mode of access: Internet.

Connection design without accurate LV feeder load data:an argument for LV monitoring

Since privatisation, maintenance of DNO LV feeder maximum demand information has gradually demised in some Utility Areas, and it is postulated that lack of knowledge about 11kV and LV electrical networks is resulting in a less economical and energy efficient Network as a whole. In an attempt to quantify the negative impact, this paper examines ten postulated new connection scenarios for a set of real LV load readings, in order to find the difference in design solutions when LV load readings were and were not known. The load profiles of the substations were examined in order to explore the utilisation profile. It was found that in 70% of the scenarios explored, significant cost differences were found. These cost differences varied by an average of 1000%, between schemes designed with and without load readings. Obviously, over designing a system and therefore operating more, underutilised transformers becomes less financially beneficial and less energy efficient. The paper concludes that new connection design is improved in terms of cost when carried out based on known LV load information and enhances the case for regular maximum feeder demand information and/or metering of LV feeders. © 2013 IEEE.

Preprocessing data for short-term load forecasting with a general regression neural network and a moving average filter

This paper proposes a filter based on a general regression neural network and a moving average filter, for preprocessing half-hourly load data for short-term multinodal load forecasting, discussed in another paper. Tests made with half-hourly load data from nine New Zealand electrical substations demonstrate that this filter is able to handle noise, missing data and abnormal data. © 2011 IEEE.

Design of a unified data with business rules storage model for OLTP and OLAP systems

This paper reviews the literature concerning the practice of using Online Analytical Processing (OLAP) systems to recall information stored by Online Transactional Processing (OLTP) systems. Such a review provides a basis for discussion on the need for the information that are recalled through OLAP systems to maintain the contexts of transactions with the data captured by the respective OLTP system. The paper observes an industry trend involving the use of OLTP systems to process information into data, which are then stored in databases without the business rules that were used to process information and data stored in OLTP databases without associated business rules. This includes the necessitation of a practice, whereby, sets of business rules are used to extract, cleanse, transform and load data from disparate OLTP systems into OLAP databases to support the requirements for complex reporting and analytics. These sets of business rules are usually not the same as business rules used to capture data in particular OLTP systems. The paper argues that, differences between the business rules used to interpret these same data sets, risk gaps in semantics between information captured by OLTP systems and information recalled through OLAP systems. Literature concerning the modeling of business transaction information as facts with context as part of the modelling of information systems were reviewed to identify design trends that are contributing to the design quality of OLTP and OLAP systems. The paper then argues that; the quality of OLTP and OLAP systems design has a critical dependency on the capture of facts with associated context, encoding facts with contexts into data with business rules, storage and sourcing of data with business rules, decoding data with business rules into the facts with the context and recall of facts with associated contexts. The paper proposes UBIRQ, a design model to aid the co-design of data with business rules storage for OLTP and OLAP purposes. The proposed design model provides the opportunity for the implementation and use of multi-purpose databases, and business rules stores for OLTP and OLAP systems. Such implementations would enable the use of OLTP systems to record and store data with executions of business rules, which will allow for the use of OLTP and OLAP systems to query data with business rules used to capture the data. Thereby ensuring information recalled via OLAP systems preserves the contexts of transactions as per the data captured by the respective OLTP system.

A novel neural model to electrical load forecasting in transformers

The paper describes a novel neural model to electrical load forecasting in transformers. The network acts as identifier of structural features to forecast process. So that output parameters can be estimated and generalized from an input parameter set. The model was trained and assessed through load data extracted from a Brazilian Electric Utility taking into account time, current, tension, active power in the three phases of the system. The results obtained in the simulations show that the developed technique can be used as an alternative tool to become more appropriate for planning of electric power systems.

MRKAd5 HIV-1 Gag/Pol/Nef Vaccine-Induced T-Cell Responses Inadequately Predict Distance of Breakthrough HIV-1 Sequences to the Vaccine or Viral Load

Background: The sieve analysis for the Step trial found evidence that breakthrough HIV-1 sequences for MRKAd5/HIV-1 Gag/Pol/Nef vaccine recipients were more divergent from the vaccine insert than placebo sequences in regions with predicted epitopes. We linked the viral sequence data with immune response and acute viral load data to explore mechanisms for and consequences of the observed sieve effect. Methods: Ninety-one male participants (37 placebo and 54 vaccine recipients) were included; viral sequences were obtained at the time of HIV-1 diagnosis. T-cell responses were measured 4 weeks post-second vaccination and at the first or second week post-diagnosis. Acute viral load was obtained at RNA-positive and antibody-negative visits. Findings: Vaccine recipients had a greater magnitude of post-infection CD8+ T cell response than placebo recipients (median 1.68% vs 1.18%; p = 0.04) and greater breadth of post-infection response (median 4.5 vs 2; p = 0.06). Viral sequences for vaccine recipients were marginally more divergent from the insert than placebo sequences in regions of Nef targeted by pre-infection immune responses (p = 0.04; Pol p = 0.13; Gag p = 0.89). Magnitude and breadth of pre-infection responses did not correlate with distance of the viral sequence to the insert (p. 0.50). Acute log viral load trended lower in vaccine versus placebo recipients (estimated mean 4.7 vs 5.1) but the difference was not significant (p = 0.27). Neither was acute viral load associated with distance of the viral sequence to the insert (p>0.30). Interpretation: Despite evidence of anamnestic responses, the sieve effect was not well explained by available measures of T-cell immunogenicity. Sequence divergence from the vaccine was not significantly associated with acute viral load. While point estimates suggested weak vaccine suppression of viral load, the result was not significant and more viral load data would be needed to detect suppression.

Assessments of training load in elite youth soccer

One of the most popular sports globally, soccer has seen a rise in the demands of the game over recent years. An increase in intensity and playing demands, coupled with growing social and economic pressures on soccer players means that optimal preparation is of paramount importance. Recent research has found the modern game, depending on positional role, to consist of approximately 60% more sprint distance in the English Premier League, which was also found to be the case for frequency and success of discrete technical actions (Bush et al., 2015). As a result, the focus on soccer training and player preparedness is becoming more prevalent in scientific research. By designing the appropriate training load, and thus periodization strategies, the aim is to achieve peak fitness in the most efficient way, whilst minimising the risk of injury and illness. Traditionally, training intensity has been based on heart rate responses, however, the emergence of tracking microtechnology such as global positioning system (GPS) and inertial sensors are now able to further quantify biomechanical load as well as physiological stress. Detailed pictures of internal and external loading indices such as these then combine to produce a more holistic view of training load experience by the player during typical drills and phases of training in soccer. The premise of this research is to gain greater understanding of the physical demands of common training methodologies in elite soccer to support optimal match performance. The coaching process may then benefit from being able to prescribe the most effective training to support these. The first experimental chapter in this thesis began by quantify gross training loads of the pre-season and in-season phases in soccer. A broader picture of the training loads inherent in these distinct phases brought more detail as to the type and extent of external loading experienced by soccer players at these times, and how the inclusion of match play influences weekly training rhythms. Training volume (total distance) was found to be high at the start compared to the end of pre-season (37 kilometres and 28 kilometres), where high cardiovascular loads were attained as part of the conditioning focus. This progressed transiently, however, to involve higher-speed, acceleration and change-of-direction stimuli at the end of pre-season compared to the start and to that in-season (1.18 kilometres, 0.70 kilometres and 0.42 kilometres high-intensity running; with 37, 25 and 23 accelerations >3m/s2 respectively) . The decrease in volume and increase in maximal anaerobic activity was evident in the training focus as friendly matches were introduced before the competitive season. The influence of match-play as being a large physical dose in the training week may then determine the change in weekly periodisation and how resulting training loads applied and tapered, if necessary. The focus of research was then directed more specifically to the most common mode of training in soccer, that also featured regularly in the pre-season period in the present study, small-sided games (SSG). The subsequent studies examined numerous manipulations of this specific form of soccer conditioning, such as player numbers as well as absolute and relative playing space available. In contrast to some previous literature, changing the number of players did not seem to influence training responses significantly, although playing format in the possession style brought about larger effects for heart rate (89.9%HRmax) and average velocity (7.6km/h-1). However, the following studies (Chapters 5, 6 and 7) revealed a greater influence of relative playing space available to players in SSG. The larger area at their disposal brought about greater aerobic responses (~90%HRmax), by allowing higher average and peak velocities (>25km/h-1), as well as greater distance acceleration behaviour at greater thresholds (>2.8m/s2). Furthermore, the data points towards space as being a large determinant in strategy of the player in small-sided games (SSG), subsequently shaping their movement behaviour and resulting physical responses. For example, higher average velocities in a possession format (8km/h-1) reflects higher work rate and heart rate load but makes achieving significant neuromuscular accelerations at a high level difficult given higher starting velocities prior to the most intense accelerations (4.2km/h-1). By altering space available and even through intentional numerical imbalances in team numbers, it may be easier for coaches to achieve the desired stimulus for the session or individual player, whether that is for aerobic and neuromuscular conditioning. Large effects were found for heart rate being higher in the underloaded team (85-90%HRmax) compared to the team with more players (80-85%HRmax) as well as for RPE (5AU versus 7AU). This was also apparent for meterage and therefore average velocity. It would also seem neuromuscular load through high acceleration and deceleration efforts were more pronounced with less numbers (given the need to press and close down opponents, and in a larger area relative to the number of players on the underloaded team. The peak accelerations and deceleration achieved was also higher when playing with less players (3-6.2m/s2 and 3-6.1m/s2) Having detailed ways in which to reach desired physical loading responses in common small training formats, Chapter 8 compared SSG to larger 9v9 formats with full-size 11v11 friendly matches. This enabled absolute and relative comparisons to be made and to understand the extent to which smaller training formats are able to replicate the required movements to be successful in competition. In relative terms, it was revealed that relative acceleration distance and Player Load were higher in smaller 4v4 games than match-play (1.1m.min-1 and 0.3m.min-1 >3m/s2; 16.9AU versus 12AU). Although the smallest format did not replicate the high-velocity demands of matches, the results confirmed their efficacy in providing significant neuromuscular load during the training week, which may then be supplemented by high-intensity interval running in order to gain exposure to more maximal speed work. In summary, the data presented provide valuable information from GPS and inertial sensor microtechnology which may then be used to understand training better to manipulate types of load according to physical conditioning objectives. For example, a library of resources to direct planning of drills of varying cardiovascular, neuromuscular and perceptual load can be created to give more confidence in session outcomes. Combining external and internal load data of common soccer training drills, and their application across different phases and training objectives may give coaches a powerful tool to plan and periodize training.

Marcador in vitro da resposta glicêmica dos alimentos como ferramenta de auxílio à prescrição e avaliação de dietas

As dietas de baixo índice glicêmico e baixa carga glicêmica têm sido associadas à redução do risco de doenças crônicas. Por esse motivo há um interesse crescente na sua aplicação para avaliação e orientação nutricional. No entanto, existem limitações quanto ao uso de dados publicados de índice glicêmico e carga glicêmica, pela variedade e formas de processamento dos alimentos vegetais existentes. Devido à dificuldade de realização de ensaios in vivo, uma vez que são custosos, trabalhosos, invasivos e necessitam de período considerável de experimentação, foram desenvolvidas metodologias in vitro que, a partir da velocidade de digestão dos carboidratos, permitem estimar o índice glicêmico dos alimentos de forma prática, simples e econômica. O presente trabalho apresenta o uso de um marcador in vitro, o índice de hidrólise, na estimativa do índice glicêmico e da carga glicêmica, o método mais empregado por pesquisadores brasileiros, visando à sua aplicação por profissionais da área de Nutrição. Os cálculos e as interpretações para estimativa do Índice glicêmico e da carga glicêmica são apresentados por meio de um exemplo prático com alguns alimentos brasileiros e com o grão de amaranto submetido a diferentes processamentos. Na ausência de dados referentes à resposta glicêmica do alimento de interesse, os valores do marcador in vitro podem ser utilizados para estimar o índice glicêmico e a carga glicêmica dos alimentos. Porém, este marcador não deve ser utilizado indiscriminadamente, uma vez que leva em consideração apenas os fatores intrínsecos aos alimentos que influenciam o aproveitamento dos carboidratos disponíveis.

Sediment yield and impacts from river catchments to the Great Barrier Reef lagoon

Land use intensification is estimated to result in an overall increase in sediment delivery to the Great Barrier Reef lagoon by a factor of approximately four. Modelling suggests that, following land use intensification, croplands cause the greatest increase of sediment yield and sediment concentration, whereas erosion of grazing land is the main contemporary source of sediments, primarily owing to the large spatial extent of this land use. The spatial pattern of sediment yield to the coast after land use intensification is strongly correlated with the pattern under natural conditions, although the greatest increase is estimated to have occurred in the wet-dry catchments. Sediment transport and resuspension processes have led to the development of a strongly sediment-partitioned shelf, with modern mud-rich sediments almost exclusively restricted to the inner and inner-middle shelf, northward-facing embayments and in the lee of headlands. Elevated sediment concentrations increase the potential transport rates of nutrients and other pollutants. Whether increased sediment supply to the coastal zone has impacted on reefs remains a point of contention. More sediment load data need to be collected and analysed in order to make detailed estimates of catchment yields and establish the possible sediment impact on the Great Barrier Reef.

Previsão do Diagrama de Carga de Subestações da REN utilizando Redes Neuronais

A presente dissertação apresenta o estudo de previsão do diagrama de carga de subestações da Rede Elétrica Nacional (REN) utilizando redes neuronais, com o intuito de verificar a viabilidade do método utilizado, em estudos futuros. Atualmente, a energia elétrica é um bem essencial e desempenha um papel fundamental, tanto a nível económico do país, como a nível de conforto e satisfação individual. Com o desenvolvimento do setor elétrico e o aumento dos produtores torna-se importante a realização da previsão de diagramas de carga, contribuindo para a eficiência das empresas. Esta dissertação tem como objetivo a utilização do modelo das redes neuronais artificiais (RNA) para criar uma rede capaz de realizar a previsão de diagramas de carga, com a finalidade de oferecer a possibilidade de redução de custos e gastos, e a melhoria de qualidade e fiabilidade. Ao longo do trabalho são utilizados dados da carga (em MW), obtidos da REN, da subestação da Prelada e dados como a temperatura, humidade, vento e luminosidade, entre outros. Os dados foram devidamente tratados com a ajuda do software Excel. Com o software MATLAB são realizados treinos com redes neuronais, através da ferramenta Neural Network Fitting Tool, com o objetivo de obter uma rede que forneça os melhores resultados e posteriormente utiliza-la na previsão de novos dados. No processo de previsão, utilizando dados reais das subestações da Prelada e Ermesinde referentes a Março de 2015, comprova-se que com a utilização de RNA é possível obter dados de previsão credíveis, apesar de não ser uma previsão exata. Deste modo, no que diz respeito à previsão de diagramas de carga, as RNA são um bom método a utilizar, uma vez que fornecem, à parte interessada, uma boa previsão do consumo e comportamento das cargas elétricas. Com a finalização deste estudo os resultados obtidos são no mínimo satisfatórios. Consegue-se alcançar através das RNA resultados próximos aos valores que eram esperados, embora não exatamente iguais devido à existência de uma margem de erro na aprendizagem da rede neuronal.

HLA-C cell surface expression and control of HIV/AIDS correlate with a variant upstream of HLA-C.

A variant 35 kb upstream of the HLA-C gene (-35C/T) was previously shown to associate with HLA-C mRNA expression level and steady-state plasma HIV RNA levels. We genotyped this variant in 1,698 patients of European ancestry with HIV. Individuals with known seroconversion dates were used for disease progression analysis and those with longitudinal viral load data were used for viral load analysis. We further tested cell surface expression of HLA-C in normal donors using an HLA-C-specific antibody. We show that the -35C allele is a proxy for high HLA-C cell surface expression, and that individuals with high-expressing HLA-C alleles progress more slowly to AIDS and control viremia significantly better than individuals with low HLA-C expressing alleles. These data strongly implicate high HLA-C expression levels in more effective control of HIV-1, potentially through better antigen presentation to cytotoxic T lymphocytes or recognition and killing of infected cells by natural killer cells.

Viabilitat i rendiment d'un sistema d'informació geogràfica en dispositius mòbils per realitzar càlculs LCP en zona de muntanya sense connexió de xarxa

The aim of this research paper is to present a macroscopic study about the feasibility and the efficiency of mobile devices in computing Least-Cost Path (LCP). This kind of artifact must work in off-line mode and must allow to load data from a mountain zone like digital terrain models and meteorological data.The research strategy has two steps:- First of all, we need to identify the set of software components in order to implement them inside the IT artifact. This set of components should have to be able to do LCP calculations, visualize results and present a well adapted human interface. The main goal of this first steep is to demonstrate the feasibility of a mobile geographic information system by following the ¿Design & Creation¿ research strategy.- In a second time, the goal is to evaluate the reliability and usability of this IT artifact by an ¿Experiments¿ research approach. In this step we want to characterize the behavior of the artifact in terms of fidelity and LCP process speed. This evaluation will be carried out by some external users.During the reading of this paper, we will see that this kind of geographic information system (the IT artifact) has the minimal requirements needed to carry out LCP calculations in mobile devices although it has several limitations and constraints in terms of useability and reliability. We will point out qualitative and quantitative elements related to the IT artifact performances while doing this kind of computations.

Viabilitat i rendiment d'un sistema d'informació geogràfica en dispositius mòbils per realitzar càlculs LCP en zona de muntanya sense connexió de xarxa

The aim of this research paper is to present a macroscopic study about the feasibility and the efficiency of mobile devices in computing least-cost path (LCP). This kind of artifact must work in off-line mode and must allow to load data from a mountain zone like digital terrain models and meteorological data.

Sellupesurin rakenteellinen kehittäminen

Tämä diplomityö on tehty Andritz Oy:lle Washers & Filters tuoteryhmään. Työ on osa pienten sellupesureiden tuotekehitysprojektia. Tavoitteena on vertailla olemassa olevaa tuotekehitysaineistoa ja tuoda esiin suunnitteluprosessi, jolla DD – sellupesurin osien rakenteita voidaan järjestelmällisesti kehittää. Diplomityössä tutkittuja osia ovat tiiviste–elementti, päätypalkki ja rumpu. Tiiviste–elementtejä vertailtiin olemassa olevan tuotekehitysaineiston osalta, sekä tutkittiin geneettisiin algoritmeihin pohjautuvan topologian optimoinnin soveltuvuutta tiiviste-elementin suunnitteluun. Päätypalkin ja rummun optimaaliset geometriat selvitettiin geneettisiä algoritmejä hyödyntävällä topologisella optimoinnilla. Optimaalisten topologioiden perusteella suunniteltiin valmistettavissa olevat rakenteet joiden ainevahvuudet määrättiin alustavasti vakion variointiin perustuvalla optimoinnilla. Tällä menettelyllä saatiin päätypalkista ja rummusta aikaiseksi aikaisempaa kevyemmät rakenteet. Topologian optimointi huomattiin soveltuvan rakenteisiin, joiden kuormitus- ja kiinnitystiedot ovat yksiselitteisesti määrätyt.