High performance computer clusters have become popular as they are more scalable, affordable and reliable than their centralized counterparts. Database management systems are particularly suitable for distributed architectures / however distributed DBMS are still not used widely because of the design difficulties. In this study, we aim to help overcome these difficulties by implementing a simulation testbed for a distributed query plan processor. This testbed works on our departmental HPC cluster machine and is able to perform select, project and join operations. A data generation module has also been implemented which preserves the foreign key and primary key constraints in the database schema. The testbed has capability to measure, simulate and estimate the response time of a given query execution plan using specified communication network parameters. Extensive experimental work is performed to show the correctness of the produced results. The estimated execution time costs are also compared with the actual run-times obtained from the testbed to verify the proposed estimation functions. Thus, we make sure that these estimation iv functions can be used in distributed database query optimization and distributed database design tools.

<p>Most aircraft component are currently being manufactured by machining, forging, welding and also assembling such parts. However, the possibilities of cutting cost from a single component has brought about a growing trend towards looking into casting as a possible option for manufacturing aircraft parts.</p><p>This thesis was done at the request of Saab Avitronics. It evaluates the possibilities of one aircraft part, a chassis for an electronic unit that was first designed to be machined from a blank, to be cast. The thesis goes through the multifaceted tasks of product development. Casting process selection, cast alloy selection as well as geometry modification were some of these tasks that were performed in this thesis. It also evaluates the performances of chosen casting processes, the design of gating systems as well as various process parameters set, by simulating the casting processes.</p><p>The alloy chosen was A356.0 with a T6 temper and the casting processes chosen were plaster mold casting and rheocasting. The geometry of the original chassis, which had very thin sections and undercuts which were complex to cast, was modified and made easier to cast with an acceptable slight increase of mass and size. The modification done on the geometry as well as the gating systems used had proven to be worthwhile, as the simulation of both process showed that such a part can be casted with no crucial defects foreseen. However, probable cavities might occur at the very tip of the chassis’s thin-fins – that it has for carrying away heat. Minor subsurface porosities might also be formed, which would not impair the function of the chassis. The modified chassis was made as close to as finished piece as possible, for the purpose of reducing machining costs. The cost of producing such a part by casting was also seen to be much less than machining it from blank. This could be taken as rationale for casting the chassis with thicker sections, to avoid problems that may arise in casting, and to subsequently machine these faces later, as it would still be cheaper than machining the chassis from a blank.</p>

<p>To be more competitive in the market, many companies are trying to speed up the quotation process and quote more attractive prices. Therefore, they have identified a need for support in the quotation process in order to reduce the quotation lead-time and ensure a higher level of accuracy in the cost estimations. The Quotation Calculator, an application program, has been developed as part of the degree thesis which was carried out at AB Norrahammars Mekaniska Verkstad, NMW 2006/07. This Quotation Calculator can be operated to calculate the material and manufacturing costs of a new product.</p><p>NMW has recently acquired licenses for CATIA V5, Dassault Systems, for the purpose of making process planning and NC-programming more efficient. NMW wants to generate the data needed from the machining module for the cost calculations. Hence this project was initiated in order to extract data from CATIA V5 for further use in Quotation Calculator or other computer system in NMW.</p><p>This work has resulted in a system developed with a common hosted programming language to extract and transfer information. The system retrieves model geometry from CAD and information on process planning from CAM, then matches the information in the application for the purpose of cost estimation. The system once developed, is supposed to be used for every new product. For this approach, the relationship of the data from CATIA V5 and the Quotation Calculator has been analyzed.</p><p>Within this thesis, the focus is on production cost estimation. The method used here is programming in Visual Basic Editor to extract information from the machining module in CATIA V5 and then import them to Microsoft Excel. With standard operations, tables of data and several inputs, the cost calculation and hence the quotation process can be automatically implemented. This work has been generated with the Quotation Calculator. With the correct input data to process planning and this new quotation system, the machining time and the costs can be estimated more accurately and easier. The time and cost information is made available for decision making. As a result, the lead time for the quotation process will be shortened and a relatively more attractive price can be quoted to the customers.</p>

To be more competitive in the market, many companies are trying to speed up the quotation process and quote more attractive prices. Therefore, they have identified a need for support in the quotation process in order to reduce the quotation lead-time and ensure a higher level of accuracy in the cost estimations. The Quotation Calculator, an application program, has been developed as part of the degree thesis which was carried out at AB Norrahammars Mekaniska Verkstad, NMW 2006/07. This Quotation Calculator can be operated to calculate the material and manufacturing costs of a new product. NMW has recently acquired licenses for CATIA V5, Dassault Systems, for the purpose of making process planning and NC-programming more efficient. NMW wants to generate the data needed from the machining module for the cost calculations. Hence this project was initiated in order to extract data from CATIA V5 for further use in Quotation Calculator or other computer system in NMW. This work has resulted in a system developed with a common hosted programming language to extract and transfer information. The system retrieves model geometry from CAD and information on process planning from CAM, then matches the information in the application for the purpose of cost estimation. The system once developed, is supposed to be used for every new product. For this approach, the relationship of the data from CATIA V5 and the Quotation Calculator has been analyzed. Within this thesis, the focus is on production cost estimation. The method used here is programming in Visual Basic Editor to extract information from the machining module in CATIA V5 and then import them to Microsoft Excel. With standard operations, tables of data and several inputs, the cost calculation and hence the quotation process can be automatically implemented. This work has been generated with the Quotation Calculator. With the correct input data to process planning and this new quotation system, the machining time and the costs can be estimated more accurately and easier. The time and cost information is made available for decision making. As a result, the lead time for the quotation process will be shortened and a relatively more attractive price can be quoted to the customers.

Conceptual cost estimates play a crucial role on initial project decisions although scope is not finalized and very limited design information is available during early project stages. At these stages, cost estimates are needed by the owner, contractor, designer or the lending organization for several purposes including / determination of feasibility of a project, financial evaluation of a number of alternative projects or establishment of an initial budget. Conceptual cost estimates are not expected to be precise, since project scope is not finalized and very limited design information is available during the pre-design stages of a project. However / a quick, inexpensive and reasonably accurate estimate is needed based on the available information. In this study, conceptual cost estimating models will be developed for urban railway systems using data of projects from Turkey. The accuracy of the models and advantages of the study will be discussed.

Existe uma noção intuitiva de que os custos associados a ações de suporte de projetos de gerenciamento de Tecnologia da Informação (TI), muitas vezes considerados já muito elevados e em crescimento, possuem forte vinculação com esforços empreendidos nas fases de desenvolvimento/implantação e teste. Apesar da importância de caracterizar e compreender a sistemática dessa relação, pouco tem sido feito neste domínio, principalmente devido à falta de mecanismos adequados tanto para o compartilhamento de informações entre as fases de um projeto de TI, quanto para aprender com experiências passadas. Para lidar com essa problemática, propõe-se nesta dissertação uma abordagem para estimar dinamicamente os custos de suporte de projetos de gerenciamento de TI à luz de informações provenientes das fases de desenvolvimento/implantação e teste. As estimativas de custos são calculadas a partir da integração de informações produzidas ao longo do ciclo de vida de projetos (passados). O núcleo da solução presente neste trabalho conta com um modelo Bayesiano para realizar previsão de custos de suporte, apoiado em um modelo de informação usado para persistir informações históricas. Para provar conceito e viabilidade técnica da solução proposta considerou-se, como estudo de caso, a predição de custos associados com projetos de implantação de infraestrutura de redes sem fio. Durante a avaliação é demonstrada a eficácia e eficiência do modelo, bem como discutido suas potencialidades e limitações para auxiliar no entendimento do compromisso entre custos de desenvolvimento/ implantação, teste e suporte. A avaliação conduzida fez uso de dados reais/sintéticos produzidos a partir de projetos do ISBSG e apresenta resultados próximos dos encontrados em cenários reais. Nossa abordagem obteve cerca de 80% de acerto na estimativa dos custos de suporte para os cenários avaliados. / There is an intuitive notion that the costs associated with IT management project support actions, often deemed extremely high and increasing, are directly related to the effort spent during their development/deployment and test phases. Despite the importance of systematically characterizing and understanding this relationship, little has been done in this realm mainly due to the lack of proper mechanisms for both sharing information between IT project phases and learning from past experientes. To tackle this issue, in this dissertation we proposed an approach for dynamically predicting IT management project support costs taking into account information gathered from the development/deployment and test phases. Support cost estimates are computed by integrating existing information from the lifecycle of (past) projects. The core of the solution in this work relies on a Bayesian model to perform support cost predictions, supported by an information model employed to persist historical information gathered from past projects. To prove the concept and technical feasibility of our solution we consider as a case study the prediction of costs (either development/test/support) associated with projects for the deployment of wireless network infrastructures. During the evaluation is demonstrated the effectiveness and efficiency of the model and discussed its potential and limitations in order to help understanding the trade-offs between development/deployment, test, and support costs. Our solution has been evaluated based on real/synthetics data gathered from the ISBSG dataset, and presents results similar to those found in real-life scenarios. Our solution has provided correct estimates for around 80% of the support costs for the scenarios evaluated.

Over the last few decades the design of high lift devices has become a very important part of the total aircraft design process. Reviews of the design process are performed on a regular basis, with the intent to improve and optimize the design process. This thesis describes a new and innovative methodology for the design and evaluation of mechanisms for Trailing Edge High-Lift devices. The initial research reviewed existing High-Lift device design methodologies and current flap systems used on existing commercial transport aircraft. This revealed the need for a design methodology that could improve the design process of High-Lift devices, moving away from the conventional "trial and error" design approach, and cover a wider range of design attributes. This new methodology includes the use of the innovative design tool called SYNAMEC. This is a state-of-the-art engineering design tool for the synthesis and optimizations of aeronautical mechanisms. The new multidisciplinary design methodology also looks into issues not usually associated with the initial stages of the design process, such as Maintainability, Reliability, Weight and Cost. The availability of the SYNAMEC design tool and its ability to perform Synthesis and Optimization of mechanisms led to it being used as an important module in the development of the new design methodology. The SYNAMEC tool allows designers to assess more mechanisms in a given time than the traditional design methodologies. A validation of the new methodology was performed and showed that creditable results were achieved. A case study was performed on the ATRA - Advance Transport Regional Aircraft, a Cranfield University design project, to apply the design methodology and select from within a group of viable solutions the most suitable type of mechanism for the Variable Camber Wing concept initially defined for the aircraft. The results show that the most appropriate mechanism type for the ATRA Variable Camber Wing is the Link /Track Mechanism. It also demonstrated how a wide range of design attributes can now be considered at a much earlier stage of the design.

Existe uma noção intuitiva de que os custos associados a ações de suporte de projetos de gerenciamento de Tecnologia da Informação (TI), muitas vezes considerados já muito elevados e em crescimento, possuem forte vinculação com esforços empreendidos nas fases de desenvolvimento/implantação e teste. Apesar da importância de caracterizar e compreender a sistemática dessa relação, pouco tem sido feito neste domínio, principalmente devido à falta de mecanismos adequados tanto para o compartilhamento de informações entre as fases de um projeto de TI, quanto para aprender com experiências passadas. Para lidar com essa problemática, propõe-se nesta dissertação uma abordagem para estimar dinamicamente os custos de suporte de projetos de gerenciamento de TI à luz de informações provenientes das fases de desenvolvimento/implantação e teste. As estimativas de custos são calculadas a partir da integração de informações produzidas ao longo do ciclo de vida de projetos (passados). O núcleo da solução presente neste trabalho conta com um modelo Bayesiano para realizar previsão de custos de suporte, apoiado em um modelo de informação usado para persistir informações históricas. Para provar conceito e viabilidade técnica da solução proposta considerou-se, como estudo de caso, a predição de custos associados com projetos de implantação de infraestrutura de redes sem fio. Durante a avaliação é demonstrada a eficácia e eficiência do modelo, bem como discutido suas potencialidades e limitações para auxiliar no entendimento do compromisso entre custos de desenvolvimento/ implantação, teste e suporte. A avaliação conduzida fez uso de dados reais/sintéticos produzidos a partir de projetos do ISBSG e apresenta resultados próximos dos encontrados em cenários reais. Nossa abordagem obteve cerca de 80% de acerto na estimativa dos custos de suporte para os cenários avaliados. / There is an intuitive notion that the costs associated with IT management project support actions, often deemed extremely high and increasing, are directly related to the effort spent during their development/deployment and test phases. Despite the importance of systematically characterizing and understanding this relationship, little has been done in this realm mainly due to the lack of proper mechanisms for both sharing information between IT project phases and learning from past experientes. To tackle this issue, in this dissertation we proposed an approach for dynamically predicting IT management project support costs taking into account information gathered from the development/deployment and test phases. Support cost estimates are computed by integrating existing information from the lifecycle of (past) projects. The core of the solution in this work relies on a Bayesian model to perform support cost predictions, supported by an information model employed to persist historical information gathered from past projects. To prove the concept and technical feasibility of our solution we consider as a case study the prediction of costs (either development/test/support) associated with projects for the deployment of wireless network infrastructures. During the evaluation is demonstrated the effectiveness and efficiency of the model and discussed its potential and limitations in order to help understanding the trade-offs between development/deployment, test, and support costs. Our solution has been evaluated based on real/synthetics data gathered from the ISBSG dataset, and presents results similar to those found in real-life scenarios. Our solution has provided correct estimates for around 80% of the support costs for the scenarios evaluated.

Energy and cost performance optimization for commercial building system design is growing in popularity, but it is often criticized for its time consuming process. Moreover, the current process lacks integration, which not only affects time performance, but also investors’ confidence in the predicted performance of the generated design. Such barriers keep building owners and design teams from embracing life cycle cost consideration. This thesis proposes a computationally efficient design optimization platform to improve the time performance and to streamline the workflow in an integrated multi-objective building system design optimization process. First, building system cost estimation is typically completed through a building information model based quantity take-off process, which does not provide sufficient design decision support features in the design process. To remedy this issue, an automatic cost estimation framework that integrates EnergyPlus with an external database to perform building systems’ capital and operation costs is proposed. Optimization, typically used for building system design selection, requires a large amount of computational time. The optimization process evaluates building envelope, electrical and HVAC systems in an integrated system not only to explore the cost-saving potential from a single high performance system, but also the interrelated effects among different systems. An innovative optimization strategy that integrates machine learning techniques with a conventional evolutionary algorithm is proposed. This strategy can reduce run time and improve the quality of the solutions. Lastly, developing baseline energy models typically takes days or weeks depending on the scale of the design. An automated system for generating baseline energy model according to ANSI/ASHRAE/IESNA Standard 90.1 performance rating method is thus proposed to provide a quick appraisal of optimal designs in comparison with the baseline energy requirements. The main contribution of this thesis is the development of a new design optimization platform to expedite the conventional decision making process. The platform integrates three systems: (1) cost estimation, (2) optimization and (3) benchmark comparison for minimizing the first cost and energy operation costs. This allows designers to confidently select an optimal design with high performance building systems by making a comparison with the minimum energy baseline set by standards in the building industry. Two commercial buildings are selected as case studies to demonstrate the effectiveness of this platform. One building is the Center for Sustainable Landscapes in Pittsburgh, PA. This case study is used as a new construction project. With 54 million possible design solutions, the platform is able to identify optimal designs in four hours. Some of the design solutions not only save the operation costs by up to 23% compared to the ASHRAE baseline design, but also reduce the capital cost ranging from 5% to 23%. Also, compared with the ASHRAE baseline design, one design solution demonstrates that the high investment of a product, building integrative photovoltaic (BiPV) system, can be justified through the integrative design optimization approach by the lower operation costs (20%) as well as the lower capital cost (12%). The second building is the One Montgomery Plaza, a large office building in Norristown, PA. This case study focuses on using the platform for a retrofit project. The calibrated energy model requires one hour to complete the simulation. There are 4000 possible design solutions proposed and the platform is able to find the optimal design solution in around 50 hours. Similarly, the results indicate that up to 25% capital cost can be saved with $1.7 million less operation costs in 25 years, compare to the ASHRAE baseline design.

Notorious for its high poverty levels and low socio-economic status, the Navajo Nation’s socio-economic well-being is hindered greatly in part by the lack of an adequate potable water infrastructure which has resulted in health disparities and has attributed to stunted economic growth within the Nation. Large candidate regional water transmission pipelines projects aimed to meet these needs have been identified. With capital costs exceeding their fiscal capability, decision-makers must choose projects that generate the most bang for the buck. To address these challenges, three (3) interconnected planning tools have been developed: (1) a water pipe installation construction cost estimation model (WaterCOSTE) to improve the accuracy of capital cost estimates; (2) a hydraulic optimization model (WaterTRANS) that improves design efficiency for branched water transmission systems; and (3) a decision support system (DSS) that allows candidate water transmission projects to be ranked while considering economic development, health improvement and environmental protection objectives. Estimates derived from WaterCOSTE are used as input into WaterTRANS to find least-cost system designs. The system costs along with other project data are then input into the DSS to determine project rankings. To demonstrate how the DSS can be used and applied, two candidate projects on the Navajo Nation are evaluated. The tools developed will enable decision-makers to improve planning processes and make wiser investment decisions that will lead to expanding the water infrastructure coverage and living conditions on the Navajo Nation.