Disseny i implementació de la base de dades d'un sistema centralitzat de control de despesa pública dels parlaments europeus

Disseny d'una base de dades per controlar la despesa pública dels parlaments i dels parlamentaris dels diferents països membres, i poder mostrar-la de forma on-line en un exercici de transparència que ajudi a reduir la corrupció.

Disseny i implementació d'una base de dades per a un sistema centralitzat de control de la despesa pública de les cambres parlamentàries europees

Disseny i implementació d'una base de dades per a un sistema centralitzat de control de la despesa pública de les cambres parlamentàries europees.

Disseny i implementació d'una base de dades relacional per a la gestió d'un videojoc

Projecte de final de carrera d'enginyeria en informàtica. Consisteix en la creació d'una base de dades relacional per donar suport a un videojoc. La base de dades inclou la implementació de tots els procediments emmagatzemats per accedir i gestionar la informació. El projecte també inclou el disseny d'un magatzem de dades per explotar estadísticament la informació continguda.

Disseny i implementació d'una base de dades relacional per a la gestió d'un videojoc

El projecte ha consistit en el disseny, implementació i desenvolupament d'un videojoc en el qual s'ha d'incorporat un sistema per obtenir dades d'ús dels usuaris. En aquest treball s'ha utilitzat el llenguatge PL/SQL i l'eina Oracle, versió 10, que és un modern SGBD. En aquest TFC s'han exposat els passos que s'han dut a terme per a l'elaboració del projecte.

Disseny i implementació de la base de dades d'un sistema centralitzat de control de despesa pública dels parlaments europeus

La Comunitat Europea ha decidit realitzar una base de dades per controlar la despesa pública parlamentària, tant dels parlaments com dels seus parlamentaris, i que les dades puguin ser consultades on line. L'objectiu del present treball és realitzar la base de dades on es guardarà la informació indicada pel client, així com un seguit de consultes i dades estadístiques que es podran consultar a través d'una plana web.

Disseny i implementació d'una base de dades relacional per a la gestió d'un videojoc

Disseny i implementació d'una base de dades relacional per a la gestió d'ús d'un videojoc.

Disseny i implementació de la base de dades d'un sistema centralitzat de control de despesa pública dels parlaments europeus

El projecte consisteix en la creació d'una base de dades per controlar la despesa pública dels parlaments europeus.

Portland Cement Concrete Curing Compound Performance Phase I and Phase II, MLR-02-03, 2003

Testing the efficiency of Portland Cement Concrete (PCC) curing compounds is currently done following Test Method Iowa 901-D, May 2002. Concrete test specimens are prepared from mortar materials and are wet cured 5 hours before the curing compound is applied. All brands of curing compound submitted to the Iowa Department of Transportation are laboratory tested for comparative performance under the same test conditions. These conditions are different than field PCC paving conditions. Phase I tests followed Test Method Iowa 901-D, but modified the application amounts of the curing compound. Test results showed that the application of two coats of one-half thickness each increased efficiency compared to one full thickness coat. Phase II tests also used the modified application amounts, used a concrete mix (instead of a mortar mix) and applied curing compound a few minutes after molding. Measurements of losses, during spraying of the curing compound, were noted and were found to be significant. Test results showed that application amounts, testing techniques, concrete specimen mix design and spray losses do influence the curing compound efficiency. The significance of the spray losses indicates that the conventional test method being used (Iowa 901 D) should be revised.

Investigation of PCC Pavement Sections from I-29 Pottawattamie County, MLR-06-01, 2007

Early deterioration has shown up in a number of Iowa PCC pavements placed between 1986 and 1994. Research has shown that inadequate air content and spacing factors have contributed to the deterioration. Ettringite infilling of air voids is nearly always noted in cores obtained from pavements exhibiting deterioration. This research is to document the early deterioration on I-29 in Pottawattamie county from MP 59 to 72 in both directions.

Field Testing of Railroad Flatcar Bridges Volume I: Single Spans, TR-498, 2007

Based on the conclusions of IHRB Project TR-444, Demonstration Project Using Railroad Flat Car Bridges for Low Volume Road Bridges, additional research on the use of RRFC bridges was undertaken. This portion of the project investigated the following: (1) Different design and rating procedures; (2) Additional single span configurations plus multiple span configurations; (3) Different mechanisms for connecting adjacent RRFCs and the resulting lateral load distribution factors; (4) Sheet pile abutments; and (5) Behavior RRFCs that had been strengthened so that they could be used on existing abutments. A total of eight RRFC bridges were tested (five single span bridges, two two-span bridges, and one three-span bridge). Based on the results of this study a simplified design and rating procedure has been developed for the economical replacement bridge alternative. In Volume 1, this volume, the results from the testing of four single span RRFC bridges are presented, while in Volume 2 the results from the testing of the strengthened single span bridge plus the three multiple span bridges are presented.

Investigation of Steel-Stringer Bridges: Superstructures and Substructures, Volume I, TR-522, 2007

There are hundreds of structurally deficient or functionally obsolete bridges in the state of Iowa. With the majority of these bridges located on rural county roads where there is limited funding available to replace the bridges, diagnostic load testing can be utilized to determine the actual load carrying capacity of the bridge. One particular family or fleet of bridges that has been determined to be desirable for load testing consists of single-span bridges with non-composite, cast-in-place concrete decks, steel stringers, and timber substructures. Six bridges with poor performing superstructure and substructure from the aforementioned family of bridges were selected to be load tested. The six bridges were located on rural roads in five different counties in Iowa: Boone, Carroll, Humboldt, Mahaska, and Marshall. Volume I of this report focuses on evaluating the superstructure for this family of bridges. This volume discusses the behavior characteristics that influence the load carrying capacity of this fleet of bridges. In particular, the live load distribution, partial composite action, and bearing restraint were investigated as potential factors that could influence the bridge ratings. Implementing fleet management practices, the bridges were analyzed to determine if the load test results could be predicted to better analyze previously untested bridges. For this family of bridges it was found that the ratings increased as a result of the load testing demonstrating a greater capacity than determined analytically. Volume II of this report focuses on evaluating the timber substructure for this family of bridges. In this volume, procedures for detecting pile internal decay using nondestructive ultrasonic stress wave techniques, correlating nondestructive ultrasonic stress wave techniques to axial compression tests to estimate deteriorated pile residual strength, and evaluating load distribution through poor performing timber substructure elements by instrumenting and load testing the abutments of the six selected bridges are discussed. Also, in this volume pile repair methods for restoring axial and bending capacities of pile are developed and evaluated.

Fly Ash Soil Stabilization for Non-Uniform Subgrade Soils, Volume I: Engineering Properties and Construction Guidelines, TR-461, 2005

Soil treated with self-cementing fly ash is increasingly being used in Iowa to stabilize fine-grained pavement subgrades, but without a complete understanding of the short- and long-term behavior. To develop a broader understanding of fly ash engineering properties, mixtures of five different soil types, ranging from ML to CH, and several different fly ash sources (including hydrated and conditioned fly ashes) were evaluated. Results show that soil compaction characteristics, compressive strength, wet/dry durability, freeze/thaw durability, hydration characteristics, rate of strength gain, and plasticity characteristics are all affected by the addition of fly ash. Specifically, Iowa selfcementing fly ashes are effective at stabilizing fine-grained Iowa soils for earthwork and paving operations; fly ash increases compacted dry density and reduces the optimum moisture content; strength gain in soil-fly ash mixtures depends on cure time and temperature, compaction energy, and compaction delay; sulfur contents can form expansive minerals in soil–fly ash mixtures, which severely reduces the long-term strength and durability; fly ash increases the California bearing ratio of fine-grained soil–fly ash effectively dries wet soils and provides an initial rapid strength gain; fly ash decreases swell potential of expansive soils; soil-fly ash mixtures cured below freezing temperatures and then soaked in water are highly susceptible to slaking and strength loss; soil stabilized with fly ash exhibits increased freeze-thaw durability; soil strength can be increased with the addition of hydrated fly ash and conditioned fly ash, but at higher rates and not as effectively as self-cementing fly ash. Based on the results of this study, three proposed specifications were developed for the use of self-cementing fly ash, hydrated fly ash, and conditioned fly ash. The specifications describe laboratory evaluation, field placement, moisture conditioning, compaction, quality control testing procedures, and basis of payment.

Field Instrumentation, Testing, and Long-Term Monitoring of High-Mast Lighting Tower No. 1 at the I-35/US 18 Interchange Near Clear Lake in the State of Iowa Phase 3, TR-562, 2009

The current study was initiated to quantify the stresses induced in critical details on the reinforcing jacket and the tower itself through the use of field instrumentation, load testing, and long-term monitoring. Strain gages were installed on the both the tower and the reinforcing jacket. Additional strain gages were installed on two anchor rods. Tests were conducted with and without the reinforcing jacket installed. Data were collected from all strain gages during static load testing and were used to study the stress distribution of the tower caused by known loads, both with and without the reinforcing jacket. The tower was tested dynamically by first applying a static load, and then quickly releasing the load causing the tower to vibrate freely. Furthermore, the tower was monitored over a period of over 1 year to obtain stress range histograms at the critical details to be used for a fatigue evaluation. Also during the long-term monitoring, triggered time-history data were recorded to study the wind loading phenomena that excite the tower.

Development of LRFD Procedures for Bridge Pile Foundations in Iowa, Volume I: An Electronic Database for PIle LOad Tests (PILOT), TR-573, 2011

For well over 100 years, the Working Stress Design (WSD) approach has been the traditional basis for geotechnical design with regard to settlements or failure conditions. However, considerable effort has been put forth over the past couple of decades in relation to the adoption of the Load and Resistance Factor Design (LRFD) approach into geotechnical design. With the goal of producing engineered designs with consistent levels of reliability, the Federal Highway Administration (FHWA) issued a policy memorandum on June 28, 2000, requiring all new bridges initiated after October 1, 2007, to be designed according to the LRFD approach. Likewise, regionally calibrated LRFD resistance factors were permitted by the American Association of State Highway and Transportation Officials (AASHTO) to improve the economy of bridge foundation elements. Thus, projects TR-573, TR-583 and TR-584 were undertaken by a research team at Iowa State University’s Bridge Engineering Center with the goal of developing resistance factors for pile design using available pile static load test data. To accomplish this goal, the available data were first analyzed for reliability and then placed in a newly designed relational database management system termed PIle LOad Tests (PILOT), to which this first volume of the final report for project TR-573 is dedicated. PILOT is an amalgamated, electronic source of information consisting of both static and dynamic data for pile load tests conducted in the State of Iowa. The database, which includes historical data on pile load tests dating back to 1966, is intended for use in the establishment of LRFD resistance factors for design and construction control of driven pile foundations in Iowa. Although a considerable amount of geotechnical and pile load test data is available in literature as well as in various State Department of Transportation files, PILOT is one of the first regional databases to be exclusively used in the development of LRFD resistance factors for the design and construction control of driven pile foundations. Currently providing an electronically organized assimilation of geotechnical and pile load test data for 274 piles of various types (e.g., steel H-shaped, timber, pipe, Monotube, and concrete), PILOT (http://srg.cce.iastate.edu/lrfd/) is on par with such familiar national databases used in the calibration of LRFD resistance factors for pile foundations as the FHWA’s Deep Foundation Load Test Database. By narrowing geographical boundaries while maintaining a high number of pile load tests, PILOT exemplifies a model for effective regional LRFD calibration procedures.

Insights into the Design and Characteristics of the Sedimentation Process at Multi-Barrel Culverts in Iowa, TR-596, 2010

The present study is an integral part of a broader study focused on the design and implementation of self-cleaning culverts, i.e., configurations that prevent the formation of sediment deposits after culvert construction or cleaning. Sediment deposition at culverts is influenced by many factors, including the size and characteristics of material of which the channel is composed, the hydraulic characteristics generated under different hydrology events, the culvert geometry design, channel transition design, and the vegetation around the channel. The multitude of combinations produced by this set of variables makes the investigation of practical situations a complex undertaking. In addition to the considerations above, the field and analytical observations have revealed flow complexities affecting the flow and sediment transport through culverts that further increase the dimensions of the investigation. The flow complexities investigated in this study entail: flow non-uniformity in the areas of transition to and from the culvert, flow unsteadiness due to the flood wave propagation through the channel, and the asynchronous correlation between the flow and sediment hydrographs resulting from storm events. To date, the literature contains no systematic studies on sediment transport through multi-box culverts or investigations on the adverse effects of sediment deposition at culverts. Moreover, there is limited knowledge about the non-uniform, unsteady sediment transport in channels of variable geometry. Furthermore, there are few readily useable (inexpensive and practical) numerical models that can reliably simulate flow and sediment transport in such complex situations. Given the current state of knowledge, the main goal of the present study is to investigate the above flow complexities in order to provide the needed insights for a series of ongoing culvert studies. The research was phased so that field observations were conducted first to understand the culvert behavior in Iowa landscape. Modeling through complementary hydraulic model and numerical experiments was subsequently carried out to gain the practical knowledge for the development of the self-cleaning culvert designs.