Data Consistency by a Metadata Management Solution

This thesis consists of three main theoretical themes: quality of data, success of information systems, and metadata in data warehousing. Loosely defined, metadata is descriptive data about data, and, in this thesis, master data means reference data about customers, products etc. The objective of the thesis is to contribute to an implementation of a metadata management solution for an industrial enterprise. The metadata system incorporates a repository, integration, delivery and access tools, as well as semantic rules and procedures for master data maintenance. It targets to improve maintenance processes and quality of hierarchical master data in the case company’s informational systems. That should bring benefits to whole organization in improved information quality, especially in cross-system data consistency, and in more efficient and effective data management processes. As the result of this thesis, the requirements for the metadata management solution in case were compiled, and the success of the new information system and the implementation project was evaluated.

Estimation of existing cable systems in generator-busbar unit and choice the optimal solution for its modernization

The aim of this master’s thesis is to develop an algorithm to calculate the cable network for heat and power station CHGRES. This algorithm includes important aspect which has an influence on the cable network reliability. Moreover, according to developed algorithm, the optimal solution for modernization cable system from economical and technical point of view was obtained. The conditions of existing cable lines show that replacement is necessary. Otherwise, the fault situation would happen. In this case company would loss not only money but also its prestige. As a solution, XLPE single core cables are more profitable than other types of cable considered in this work. Moreover, it is presented the dependence of value of short circuit current on number of 10/110 kV transformers connected in parallel between main grid and considered 10 kV busbar and how it affects on final decision. Furthermore, the losses of company in power (capacity) market due to fault situation are presented. These losses are commensurable with investment to replace existing cable system.

Solution marketing characteristics and practices

The first objective of this master's thesis is to find out how the concepts solution and solution marketing are defined in the literature. In order to do so, solution marketing literature is reviewed widely. Another target is to identify the characteristics of solution marketing and to explain how solution marketing can be carried out. The final objective is to determine how well the described solution marketing practices are executed in the target company, and this will be studied with a survey. A solution can be described as a co-created and customized combination of products and services. Solution marketing aims at developing and anticipating customer's business needs and it involves close collaboration between customer and supplier. Solution marketing communication is targeted to a specific audience. It entails deep customer intimacy and is focused on understanding customer's business problem. Solution marketing also requires close collaboration between sales and marketing as well as customer focused mindset. Solution marketing can be executed by promoting thought leadership, presenting solution offering, creating close customer relationships and treating customers as individuals. Solution provider's whole organization must engage customer focus.

The concept of solution: Industry’s insights compared to theoretical views

Many manufacturing companies have started to offer complete solutions to their customers’ unique needs due to toughening competition and customer demand. Discourse on this kind of solution business is still developing, hence, there is not an established definition for the concept of solution. The aim of the study is to profoundly identify the concept of solution and to understand how the industry’s current views differ from the theoretical concepts. The describing dimensions are identified from selected 13 theoretical notions, and from responses, that the employees of five different companies have given. The 32 interview transcripts are analyzed with thematic analysis and qualitative content analysis. According to the findings, the concept of solution is characterized by integration, customization, risk-sharing, value co-creation, long-term orientation, and desired outcomes. The industry’s insights differ in terms of them all. The results illustrate, that a solution is a bundle, and the whole solution is customized on some level for a client. A solution supplier needs to be customer-focused, in which value co-creation is only a part. The solution solves the customer’s problem, and improves both the customer’s, and the supplier’s business. Neither long-term focus nor risks-sharing were directly employed to characterize the concept of solution. Differences are mainly due to the different approaches to the definitions and inexperience of the companies.

Evaluating the Advantages of Implementing a CRM solution

CRM-järjestelmän avulla pyritään yleisesti tehostamaan liiketoimintaprosesseja. Yrityksestä, kuin myös toimialasta riippuen hyödyt sekä tavoitteet vaihtelevat jonkin verran. Usein CRM-järjestelmän avulla saavutettavien hyötyjen mittaaminen ja arviointi organisaatiossa koetaan hankalaksi ja täten todellinen hyötyjen arviointi jää suppeaksi. Tämän tutkimuksen tavoitteena oli kartoittaa etuja, joita CRM-järjestelmän käyttöönotto on todellisuudessa tuonut yrityksille. Tutkimus kulminoituu laskentamalliin, jonka avulla CRM käytön hyödyt konvertoidaan konkreettiseksi rahasummaksi. Tutkimuksessa pyritään vastaamaan seuraaviin tutkimuskysymyksiin: 1. Kun yritys suunnitteli CRM-sovelluksen käyttöönottoa, mitkä olivat järjestelmälle asetetut tavoitteet? 2. Onko yritys saavuttanut CRM-järjestelmälle asetetut tavoitteet? 3. Onko yritys saavuttanut odottamattomia hyötyjä CRM-järjestelmän käytön avulla? 4. Mitkä ovat CRM-järjestelmän tärkeimmät kehityskohteet käyttökokemusten perusteella? Tutkimus perustuu CRM-kirjallisuuden avulla luotuun teoriaviitekehykseen. Teoriaviitekehyksen pohjalta luotiin ideaalimalli ja mallin pohjalta web-survey -kysely. Kyselyn tulosten perusteella toteutettiin haastatteluja, joilla pyrittiin saamaan tutkimustuloksiin syvyyttä.

Algorithmic Solutions for Combinatorial Problems in Resource Management of Manufacturing Environments

This thesis studies the use of heuristic algorithms in a number of combinatorial problems that occur in various resource constrained environments. Such problems occur, for example, in manufacturing, where a restricted number of resources (tools, machines, feeder slots) are needed to perform some operations. Many of these problems turn out to be computationally intractable, and heuristic algorithms are used to provide efficient, yet sub-optimal solutions. The main goal of the present study is to build upon existing methods to create new heuristics that provide improved solutions for some of these problems. All of these problems occur in practice, and one of the motivations of our study was the request for improvements from industrial sources. We approach three different resource constrained problems. The first is the tool switching and loading problem, and occurs especially in the assembly of printed circuit boards. This problem has to be solved when an efficient, yet small primary storage is used to access resources (tools) from a less efficient (but unlimited) secondary storage area. We study various forms of the problem and provide improved heuristics for its solution. Second, the nozzle assignment problem is concerned with selecting a suitable set of vacuum nozzles for the arms of a robotic assembly machine. It turns out that this is a specialized formulation of the MINMAX resource allocation formulation of the apportionment problem and it can be solved efficiently and optimally. We construct an exact algorithm specialized for the nozzle selection and provide a proof of its optimality. Third, the problem of feeder assignment and component tape construction occurs when electronic components are inserted and certain component types cause tape movement delays that can significantly impact the efficiency of printed circuit board assembly. Here, careful selection of component slots in the feeder improves the tape movement speed. We provide a formal proof that this problem is of the same complexity as the turnpike problem (a well studied geometric optimization problem), and provide a heuristic algorithm for this problem.

Solution Business Model for Energy Efficiency

This study examined solution business models and how they could be applied into energy efficiency business. The target of this study was to find out, what a functional solution business model applied to energy efficiency improvement projects is like. The term “functionality” was used to refer not only to the economic viability but to environmental and legal aspects and also to the implement of Critical Success Factors (CSFs) and the ability to overcome the most important market barriers and risks. This thesis is based on a comprehensive literature study on solution business, business models and energy efficiency business. This literature review was used as a foundation to an energy efficiency solution business model scheme. The created scheme was tested in a case study which studied two different energy efficiency improvement projects, illustrated the functionality of the created business model and evaluated their potential as customer targets. Solution approach was found to be suitable for energy efficiency business. The most important characteristics of a good solution business model were identified to be the relationship between the supplier and customer, a proper network, knowledge on the customer’s process and supreme technological expertise. Thus the energy efficiency solution business was recognized to be particularly suitable for example for energy suppliers or technological equipment suppliers. Because the case study was not executed from a certain company’s point of view, the most important factors such as relationships and the availability of funding could not be evaluated. Although the energy efficiency business is recognized to be economically viable, the most important factors influencing the profitability and the success of energy efficiency solution business model were identified to be the proper risk management, the ability to overcome market barriers and the realization of CSFs.

High-speed solid-rotor induction machine – calculation program

The aim of this thesis is to utilize the technology developed at LUT and to provide an easy tool for high-speed solid-rotor induction machine preliminary design. Computer aided design tool MathCAD has been chosen as the environment for realizing the calculation program. Four versions of the design program have been made depending on the motor rotor type. The first rotor type is an axially slitted solid-rotor with steel end rings. The next one is an axially slitted solid-rotor with copper end rings. The third machine type is a solid rotor with deep, rectangular copper bars and end rings (squirrel cage). And the last one is a solid-rotor with round copper bars and end rings (squirrel cage). Each type of rotor has its own specialties but a general thread of design is common. This paper follows the structure of the calculating program and explains some features and formulas. The attention is concentrated on the difference between laminated and solid-rotor machine design principles. There is no deep analysis of the calculation ways are presented. References for all solution methods appearing during the design procedure are given for more detailed studying. This thesis pays respect to the latest innovations in solid-rotor machines theory. Rotor ends’ analytical calculation follows the latest knowledge in this field. Correction factor for adjusting the rotor impedance is implemented. The purpose of the created design program is to calculate the preliminary dimensions of the machine according to initial data. Obtained results are not recommended for exact machine development. Further more detailed design should be done in a finite element method application. Hence, this thesis is a practical tool for the prior evaluating of the high-speed machine with different solid-rotor types parameters.

Survey of transportation of liquid bulk chemicals in the Baltic Sea

This study is made as a part of the Chembaltic (Risks of Maritime Transportation of Chemicals in Baltic Sea) project which gathers information on the chemicals transported in the Baltic Sea. The purpose of this study is to provide an overview of handling volumes of liquid bulk chemicals (including liquefied gases) in the Baltic Sea ports and to find out what the most transported liquid bulk chemicals in the Baltic Sea are. Oil and oil products are also viewed in this study but only in a general level. Oils and oil products may also include chemical-related substances (e.g. certain bio-fuels which belong to MARPOL annex II category) in some cargo statistics. Chemicals in packaged form are excluded from the study. Most of the facts about the transport volumes of chemicals presented in this study are based on secondary written sources of Scandinavian, Russian, Baltic and international origin. Furthermore, statistical sources, academic journals, periodicals, newspapers and in later years also different homepages on the Internet have been used as sources of information. Chemical handling volumes in Finnish ports were examined in more detail by using a nationwide vessel traffic system called PortNet. Many previous studies have shown that the Baltic Sea ports are annually handling more than 11 million tonnes of liquid chemicals transported in bulk. Based on this study, it appears that the number may be even higher. The liquid bulk chemicals account for approximately 4 % of the total amount of liquid bulk cargoes handled in the Baltic Sea ports. Most of the liquid bulk chemicals are handled in Finnish and Swedish ports and their proportion of all liquid chemicals handled in the Baltic Sea is altogether over 50 %. The most handled chemicals in the Baltic Sea ports are methanol, sodium hydroxide solution, ammonia, sulphuric and phosphoric acid, pentanes, aromatic free solvents, xylenes, methyl tert-butyl ether (MTBE) and ethanol and ethanol solutions. All of these chemicals are handled at least hundred thousand tonnes or some of them even over 1 million tonnes per year, but since chemical-specific data from all the Baltic Sea countries is not available, the exact tonnages could not be calculated in this study. In addition to these above-mentioned chemicals, there are also other high volume chemicals handled in the Baltic Sea ports (e.g. ethylene, propane and butane) but exact tonnes are missing. Furthermore, high amounts of liquid fertilisers, such as solution of urea and ammonium nitrate in water, are transported in the Baltic Sea. The results of the study can be considered indicative. Updated information about transported chemicals in the Baltic Sea is the first step in the risk assessment of the chemicals. The chemical-specific transportation data help to target hazard or e.g. grounding/collision risk evaluations to chemicals that are handled most or have significant environmental hazard potential. Data gathered in this study will be used as background information in later stages of the Chembaltic project when the risks of the chemicals transported in the Baltic Sea are assessed to highlight the chemicals that require special attention from an environmental point of view in potential marine accident situations in the Baltic Sea area.

Designing the transformation from a boiler supplier into a solution seller

Competition for customers in business-to-business markets is rough, and in order to survive a seller has to be able to deliver more value to its customers than its competitors. This thesis is done for the sales department of an energy technology company operating in business-to-business markets. The company is a relatively small in its field, and it aims to expand internationally and differ itself from its competitors by providing better service for its customers and selling solutions. This study aims to design the transformation from a product seller into a solution seller by defining what is a solution and how solutions are sold, and creating an action plan for sales. Data for the study is collected in ten theme interviews, and analyzed with thematic and content analysis. The action plan is constructed based both on the data and theory. According to the findings of the study, solution is defined as a specially designed unique combination of elements – such as products, services, knowledge, experience and thinking – that work with and complement each other, and bring value to a particular customer. Solution sales requires capabilities to anticipate; build relationships with customers; identify needs and define requirements; cocreate solutions by customizing and integrating elements; and provide postdeployment support. Vision for the change is to sell solution through sensing customers’ needs and responding to them, and the steps of the action plan are to (1) cascade customer-focus, (2) involve other departments in solution sales, (3) develop customer relationship management, and (4) involve the whole organization in solution business.

Business on demand and its mobile solution - study with SAP ByDesign

Business On-Demand solutions are widely used by SMEs in the world today. When I started working in SAP, SAP had just launched its first version mobile solutions for Business On-Demand solutions. SAP ByDesign mobile solution is great, but I believe we could do something even better on mobile phones. My job is focusing on mobile application development. Therefore, I have lots of thoughts about how we could make the mobile solutions better serve desktop solutions and how to distinguish the mobile solutions. Finally I decide to have a further research into this area. The purpose of this thesis is trying to find out how to improve the mobile solutions for Business On-Demand, find out its benefit and limits, and distinguish SaaS mobile solutions from desktop ones. In order to conduct this research, I had some online literature search to find out the Business On-Demand market and major players in this area. I compare the materials from public internet with the ones that are used internally in SAP. I had some interviews with SAP solution manager and SAP‟s potential customers. I finally made some pro-posals for mobile SaaS solutions which I believe will make the solutions better present and much helpful to the customers.

Qualitative Characteristics and Quantitative Measures of Solution's Reliability in Discrete Optimization: Traditional Analytical Approaches, Innovative Computational Methods and Applicability

The purpose of this thesis is twofold. The first and major part is devoted to sensitivity analysis of various discrete optimization problems while the second part addresses methods applied for calculating measures of solution stability and solving multicriteria discrete optimization problems. Despite numerous approaches to stability analysis of discrete optimization problems two major directions can be single out: quantitative and qualitative. Qualitative sensitivity analysis is conducted for multicriteria discrete optimization problems with minisum, minimax and minimin partial criteria. The main results obtained here are necessary and sufficient conditions for different stability types of optimal solutions (or a set of optimal solutions) of the considered problems. Within the framework of quantitative direction various measures of solution stability are investigated. A formula for a quantitative characteristic called stability radius is obtained for the generalized equilibrium situation invariant to changes of game parameters in the case of the H¨older metric. Quality of the problem solution can also be described in terms of robustness analysis. In this work the concepts of accuracy and robustness tolerances are presented for a strategic game with a finite number of players where initial coefficients (costs) of linear payoff functions are subject to perturbations. Investigation of stability radius also aims to devise methods for its calculation. A new metaheuristic approach is derived for calculation of stability radius of an optimal solution to the shortest path problem. The main advantage of the developed method is that it can be potentially applicable for calculating stability radii of NP-hard problems. The last chapter of the thesis focuses on deriving innovative methods based on interactive optimization approach for solving multicriteria combinatorial optimization problems. The key idea of the proposed approach is to utilize a parameterized achievement scalarizing function for solution calculation and to direct interactive procedure by changing weighting coefficients of this function. In order to illustrate the introduced ideas a decision making process is simulated for three objective median location problem. The concepts, models, and ideas collected and analyzed in this thesis create a good and relevant grounds for developing more complicated and integrated models of postoptimal analysis and solving the most computationally challenging problems related to it.

One chip solution for low-cost active magnetic bearing system

In this work the implementation of the active magnetic bearing control system in a single FPGA is studied. Requirements for the full magnetic bearing control system are reviewed. Different control methods for active magnetic bearings are described shortly. Flux and the current base controllers are implemented in a FPGA. Suitability of the con-trollers for a low-cost magnetic bearing application is studied. Floating-point arithmetic’s are used in the controllers to ease designing burden and improve calculation precision. Per-formance of the flux controller is verified with simulations.