Praktiska effekter av begreppsförvirring för en databas konceptuella design : En fallstudie om databas- och begreppsmodellering

Company X develops a laboratory information system (LIS) called System Y. The informationsystem has a two-tier database architecture consisting of a production database and a historicaldatabase. A database constitutes the backbone of a IS, which makes the design of the databasevery important. A poorly designed database can cause major problems within an organization.The two databases in System Y are poorly modeled, particularly the historical database. Thecause of the poor modeling was unclear concepts. The unclear concepts have remained in thedatabase and in the company organization and caused a general confusion of concepts. The splitdatabase architecture itself has evolved into a bottleneck and is the cause of many problemsduring the development of System Y.Company X investigates the possibility of integrating the historical database with the productiondatabase. The goal of our thesis is to conduct a consequence analysis of such integration andwhat the effects would be on System Y, and to create a new design for the integrated database.We will also examine and describe the practical effects of confusion of concepts for a databaseconceptual design.To achieve the goal of the thesis, five different method steps have been performed: a preliminarystudy of the organization, a change analysis, a consequence analysis and an investigation of theconceptual design of the database. These method steps have helped identify changes necessaryfor the organization, a new design proposal for an integrated database, the impact of theproposed design and a number of effects of confusion for the database.

Studies of Design and Assembly Defects on Integrated and Modular Architectures

It is known that despite companies’ efforts to improve the quality of their products, design and assembly defects results in large repair costs both in terms of repair and providing feedback to the origin of the defect. The purpose of this paper is to study these types of defects and the defect rates in design and assembly. The paper presents a web based questionnaire answered by 29 companies. The result shows that the defect rate (defects per product) spanned from 0.01 to 10. Also, design and assembly defects covered 46%, 23% respectively, of all occurred defects. A case study is also presented, performed at a company who recently implemented a modular architecture. In this company, defects from 5 700 integrated product architectures are compared with defects from 431 modular architectures. The average defect rate increased by 21.5% – from 0.65 to 0.79 – when a more modular architecture has been implemented. Furthermore, the study showed that the assembly defects have decreased while the design defects increased. The results presented in this paper will also support the development of the MPV (Module Property Verification) method which is briefly described.

Integrated Product Development in Truck Industry - A Case Study on Product Development Processes

This paper presents the result from a case study at Scania on product development processes. The objective with the case study was to gather information on Scania’s product development process (PDP) including the use of CAD and simulation tools, and project work. The objective was also to find any deviations or different interpretations among the employees on the PDP. To gather the information, semi-structured tape-recorded interviews have been used to ensure that individual interpretations from the interviewees could be gathered. Scania uses a defined and structured PDP which facilitates concurrent and cross-functional work. The PDP is implemented and followed to various degrees. The newly employed personnel may have difficulties with communication, both to find and to give information. Although, newly graduated personnel may find it easier to adapt to changes, and also to use a structured process which they have studied at universities. It was also known during the case study that the PDP is a major support for the newly employed personnel, which in turn decreases the time to get into the same working process as the more experienced personnel. Employees with decades of experience know the right sources from which to both give and gather information. Also, the terminology and definitions in the product development process may not be used as intended. This makes it difficult for other project members or teams who need to interpret the information received. At the same time, the routines among the more experienced personnel, which have been set-up throughout the years, make them more inflexible in adapting changes. The findings in the case study as well as challenges with implementing the PDP are known to Scania and are a part of the continuing work with improvement.

From the road network database to a graph for localization purposes

The problems of finding best facility locations require complete and accurate road network with the corresponding population data in a specific area. However the data obtained in road network databases usually do not fit in this usage. In this paper we propose our procedure of converting the road network database to a road graph which could be used in localization problems. The road network data come from the National road data base in Sweden. The graph derived is cleaned, and reduced to a suitable level for localization problems. The population points are also processed in ordered to match with that graph. The reduction of the graph is done maintaining most of the accuracy for distance measures in the network.

Sustainability and research integrated in engineering courses at Dalarna University, Sweden

Högskolepedagogik, högskolepedagogisk utbildning, BHU

Demonstration of Solar Heating and Cooling System using Sorption Integrated Solar Thermal Collectors

Producing cost-competitive small and medium-sized solar cooling systems is currently a significant challenge. Due to system complexity, extensive engineering, design and equipment costs; the installation costs of solar thermal cooling systems are prohibitively high. In efforts to overcome these limitations, a novel sorption heat pump module has been developed and directly integrated into a solar thermal collector. The module comprises a fully encapsulated sorption tube containing hygroscopic salt sorbent and water as a refrigerant, sealed under vacuum with no moving parts. A 5.6m2 aperture area outdoor laboratory-scale system of sorption module integrated solar collectors was installed in Stockholm, Sweden and evaluated under constant re-cooling and chilled fluid return temperatures in order to assess collector performance. Measured average solar cooling COP was 0.19 with average cooling powers between 120 and 200 Wm-2 collector aperture area. It was observed that average collector cooling power is constant at daily insolation levels above 3.6 kWhm-2 with the cooling energy produced being proportional to solar insolation. For full evaluation of an integrated sorption collector solar heating and cooling system, under the umbrella of a European Union project for technological innovation, a 180 m2 large-scale demonstration system has been installed in Karlstad, Sweden. Results from the installation commissioned in summer 2014 with non-optimised control strategies showed average electrical COP of 10.6 and average cooling powers between 140 and 250 Wm-2 collector aperture area. Optimisation of control strategies, heat transfer fluid flows through the collectors and electrical COP will be carried out in autumn 2014.

Steel Sheet Applications and Integrated Heat Management

Increasing energy use has caused many environmental problems including global warming. Energy use is growing rapidly in developing countries and surprisingly a remarkable portion of it is associated with consumed energy to keep the temperature comfortable inside the buildings. Therefore, identifying renewable technologies for cooling and heating is essential. This study introduced applications of steel sheets integrated into the buildings to save energy based on existing technologies. In addition, the proposed application was found to have a considerable chance of market success. Also, satisfying energy needs for space heating and cooling in a single room by using one of the selected applications in different Köppen climate classes was investigated to estimate which climates have a proper potential for benefiting from the application. This study included three independent parts and the results related to each part have been used in the next part. The first part recognizes six different technologies through literature review including Cool Roof, Solar Chimney, Steel Cladding of Building, Night Radiative Cooling, Elastomer Metal Absorber, and Solar Distillation. The second part evaluated the application of different technologies by gathering the experts’ ideas via performing a Delphi method. The results showed that the Solar Chimney has a proper chance for the market. The third part simulated both a solar chimney and a solar chimney with evaporation which were connected to a single well insulated room with a considerable thermal mass. The combination was simulated as a system to estimate the possibility of satisfying cooling needs and heating needs in different climate classes. A Trombe-wall was selected as a sample design for the Solar Chimney and was simulated in different climates. The results implied that the solar chimney had the capability of reducing the cooling needs more than 25% in all of the studied locations and 100% in some locations with dry or temperate climate such as Mashhad, Madrid, and Istanbul. It was also observed that the heating needs were satisfied more than 50% in all of the studied locations, even for the continental climate such as Stockholm and 100% in most locations with a dry climate. Therefore, the Solar Chimney reduces energy use, saves environment resources, and it is a cost effective application. Furthermore, it saves the equipment costs in many locations. All the results mentioned above make the solar chimney a very practical and attractive tool for a wide range of climates.

Manager's task to support integrated autonomy at the workplace : Results from an intervention

A new managerial task arises in today’s working life: to provide conditions for and influence interaction between actors and thus to enable the emergence of organizing structure in tune with a changing environment. We call this the enabling managerial task. The goal of this paper is to study whether training first line managers in the enabling managerial task could lead to changes in the work for the subordinates. This paper presents results from questionnaires answered by the subordinates of the managers before and after the training. The training was organized as a learning network and consisted of eight workshops carried out over a period of one year (September 2009–June 2010), where the managers met with each other and the researchers once a month. Each workshop consisted of three parts, during three and a half hours. The first hour was devoted to joint reflection on a task that had been undertaken since the last workshop; some results were presented from the employee pre-assessments, followed by relevant theory and illuminating practices, finally the managers created new tasks for themselves to undertake during the following month. The subordinates’ answers show positive change in all of the seventeen scales used to assess it. The improvements are significant in scales measuring the relationship between the manager and the employees, as well as in those measuring interaction between employees. It is concluded that the result was a success for all managers that had the possibility of using the training in their management work.