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.

Hiontarobotti-solun tietojärjestelmä

Hiontarobotteja käytetään nopeuttamaan hiontaprosessia ja vähentämään henkilöiden tarvetta tehdä kuluttavaa ja raskasta työtä. Yleensä hiottavat kappaleet ovat suuria, jolloin hionta robotillakin kestää kauan. Kun hiottavat kappaleet ovat pieniä, robotti hioo kappaleen nopeasti. Tällöin tarvitaan automaattinen varastointi, jotta hiontarobotti pystyy jatkamaan nopeasti seuraavan kappaleen hiontaa. Automaattinen varastointi tarvitsee tiedonhallintajärjestelmän, jolla hallitaan varastossa olevien kappaleiden tietoja. Hiottava kappale täytyy esimerkiksi pystyä tunnistamaan ennen hionnan aloittamista. Yhtenä tunnistusmenetelmänä voidaan käyttää radiotaajuudella toimivia RFID-tunnisteita. Kun kappale tunnistetaan ennen hiontaa niin voidaan varmistua, että robotti suorittaa oikean hiontaohjelman kappaleelle. Diplomityö liittyy Master Automation Groupin ensimmäiseen automaattista varastoa hyödyntävään FlexMill™-hiontarobotti-soluun. Työssä on suunniteltu ja toteutettu tietokanta ja siihen liittyvä tietojärjestelmä. Kehitettävä ohjelma toimii solun toiminnasta vastaavan soluohjaimen tiedonhallintaosana. Ohjelma hyödyntää RFID-laitteita kappaleiden tunnistuksessa.

Tietojärjestelmien tietokantojen jatkuva tietojen varmistaminen

Tietokantoja käyttävien tietojärjestelmien kriittisyys tietoyhteiskunnan eri osille ja toiminnalle on merkittävä. Tietojenkäsittelyn jatkuvuus ja tietojärjestelmien korkea käytettävyys on pyrittävä turvaamaan mahdollisimman kattavasti joka hetkellä ja vikatilanteista on kyettävä toipumaan työskentelyn ja liiketoiminnan jatkamiseksi. Työn tarkoituksena oli selvittää erilaisia menetelmiä näiden tietokantojen jatkuvaan tiedonvarmistukseen sekä paikallisilla palvelinjärjestelmillä että tietoverkon välityksellä ylläpidettävillä varajärjestelmillä. Paikallisella hyvin suunnitellulla tiedonvarmistuksella vikaantunut tietokanta ja sen tietosisältö kyetään palauttamaan mihinkä tahansa ajanhetkeen ennen vikaantumista. Varajärjestelmät puolestaan voidaan ottaa välittömästi käyttöön kokonaisen konesalin käytön estyessä tai vikaantuessa. Lisäksi useammat konesalit ratkaisusta riippuen voivat palvella käyttäjiään samanaikaisesti tasaten tietojärjestelmän kuormaa, tarjoten lisämahdollisuuksia tietojenkäsittelyyn ja niiden avulla sama tieto voidaan tuoda lähemmäksi palvelemaan käyttäjiään. Työn mielenkiinto kohdistuu lähinnä Oracle-tietokantoja käyttävien tieto-järjestelmien tarjoamiin varmistusvaihtoehtoihin. Kyseiset tietokantajärjestelmät ovat laajassa käytössä niin yritysmaailmassa kuin julkisellakin sektorilla.

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.

Sorption kinetics and intrapaticulate diffusivity of As(III) bioremediation from aqueous solution, using modified and unmodified coconut fiber

The pollution and toxicity problems posed by arsenic in the environment have long been established. Hence, the removal and recovery remedies have been sought, bearing in mind the efficiency, cost effectiveness and environmental friendliness of the methods employed. The sorption kinetics and intraparticulate diffusivity of As (III) bioremediation from aqueous solution using modified and unmodified coconut fiber was investigated. The amount adsorbed increased as time increased, reaching equilibrium at about 60 minutes. The kinetic studies showed that the sorption rates could be described by both pseudo-first order and pseudo-second order process with the later showing a better fit with a value of rate constant of 1.16 x 10-4 min-1 for the three adsorbent types. The mechanism of sorption was found to be particle diffusion controlled. The diffusion and boundary layer effects were also investigation. Therefore, the results show that coconut fiber, both modified and unmodified is an efficient sorbent for the removal of As (III) from industrial effluents with particle diffusion as the predominant mechanism.

Immersion enthalpy variation of surface-modified mineral activated carbon in lead (II) aqueous solution adsorption: the relation between immersion enthalpy and adsorption capacity

An activated carbon was obtained by chemical activation with phosphoric acid, CM, from a mineral carbon. Afterwards, the carbon was modified with 2 and 5 molL-1, CMox2 and CMox5 nitric acid solutions to increase the surface acid group contents. Immersion enthalpy at pH 4 values and Pb2+ adsorption isotherms were determined by immersing activated carbons in aqueous solution. The surface area values of the adsorbents and total pore volume were approximately 560 m².g-1 and 0.36 cm³g-1, respectively. As regards chemical characteristics, activated carbons had higher acid sites content, 0.92-2.42 meq g-1, than basic sites, 0.63-0.12 meq g-1. pH values were between 7.4 and 4.5 at the point of zero charge, pH PZC. The adsorbed quantity of Pb2+ and the immersion enthalpy in solution of different pH values for CM activated carbon showed that the values are the highest for pH 4, 15.7 mgg-1 and 27.6 Jg-1 respectively. Pb2+ adsorption isotherms and immersion enthalpy were determined for modified activated carbons and the highest values were obtained for the activated carbon that showed the highest content of total acid sites on the surface.

Adsorption isotherm studies of Cd (II), Pb (II) and Zn (II) ions bioremediation from aqueous solution using unmodified and EDTA-modified maize cob

The need to clean-up heavy metal contaminated environment can not be over emphasized. This paper describes the adsorption isotherm studies of Cd (II), Pb (II) and Zn (II) ions from aqueous solution using unmodified and EDTA-modified maize cob. Maize cob was found to be an excellent adsorbent for the removal of these metal ions. The amount of metal ions adsorbed increased as the initial concentration increased. Also, EDTA - modification enhanced the adsorption capacity of maize cob probably due to the chelating ability of EDTA. Among the three adsorption isotherm tested, Dubinin-Radushkevich gave the best fit with R² value ranging from 0.9539 to 0.9973 and an average value of 0.9819. This is followed by Freundlich isotherm (Ave. 0.9783) and then the Langmuir isotherm (Ave. 0.7637). The sorption process was found to be a physiosorption process as seen from the apparent energy of adsorption which ranged from 2.05KJ\mol to 4.56KJ\mol. Therefore, this study demonstrates that maize cob which is an environmental pollutant could be used to adsorb heavy metals and achieve cleanliness thereby abating environmental nuisance caused by the maize cob.

A fluorescence probe study of gemini surfactants in aqueous solution: a comparison between n-2-n and n-6-n series of the alkanediyl-a,w-bis (dimethylalkylammonium bromides)

Two series of alkanediyl-a,w-bis (dimethylalkylammonium bromide (n-2-n and n-6-n; n=8, 10,12, and 16) have been synthesized and their micelles properties studied in aqueous solution using pyrene, pyrenecarboxaldehyde (PCA) and 1,8 anilinonaphtalene sulfonic acid sodium salt (ANS) as fluorescent probes. The micelles from these surfactants have been characterized on the basis of the information provided by micelle-solubilized fluorescent probes. The obtained results indicated that the surfactant concentration at which a marked decrease in l max parameter of pyrenecarboxaldehyde (PCA) occurs corresponds to the CMC determined by conductimetric measurements. Changes in the emission spectra of ANS and PCA observed in the submicellar range for both surfactants series (n-2-n and n-6-n) were interpreted as formation of pre-aggregates. It was found that the dimeric surfactants with long spacer (s= 6) form more hydrated aggregates when compared with those formed by the n-2-n and CnTAB surfactants series. This was attributed to a more difficult packing of n-6-n surfactant molecules to form micelles.

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ä.

A quasi-materialist, quasi-dualist solution to the mind-body problem

If the mental can affect, or be affected by, the physical, then the mental must itself be physical. Otherwise the physical world would not be explanatorily closed. But it is closed. There are reasons to hold that materialism (in both its reductive and non-reductive varieties) is false. So how are we to explain the apparent responsiveness of the physical to the mental and vice versa? The only possible solution seems to be this: physical objects are really projections or isomorphs of objects whose essential properties are mental. (A slightly less accurate way of putting this would be to say: the constitutive - i.e. the non-structural and non-phenomenal - properties of physical objects are mental, i.e. are such as we are used to encountering only in "introspection".) The chair, qua thing that I can know through sense perception, and through hypotheses based strictly thereupon, is a kind of shadow of an object that is exactly like it, except that this other objects essential properties are mental. This line of thought, though radically counterintuitive, explains the apparent responsiveness of the mental to the physical, and vice versa, without being open to any of the criticisms to which materialism, dualistic interaction ism, and epiphenomenalism are open.

Eye Fundus Image Analysis for Automatic Detection of Diabetic Retinopathy

Diabetes is a rapidly increasing worldwide problem which is characterised by defective metabolism of glucose that causes long-term dysfunction and failure of various organs. The most common complication of diabetes is diabetic retinopathy (DR), which is one of the primary causes of blindness and visual impairment in adults. The rapid increase of diabetes pushes the limits of the current DR screening capabilities for which the digital imaging of the eye fundus (retinal imaging), and automatic or semi-automatic image analysis algorithms provide a potential solution. In this work, the use of colour in the detection of diabetic retinopathy is statistically studied using a supervised algorithm based on one-class classification and Gaussian mixture model estimation. The presented algorithm distinguishes a certain diabetic lesion type from all other possible objects in eye fundus images by only estimating the probability density function of that certain lesion type. For the training and ground truth estimation, the algorithm combines manual annotations of several experts for which the best practices were experimentally selected. By assessing the algorithm’s performance while conducting experiments with the colour space selection, both illuminance and colour correction, and background class information, the use of colour in the detection of diabetic retinopathy was quantitatively evaluated. Another contribution of this work is the benchmarking framework for eye fundus image analysis algorithms needed for the development of the automatic DR detection algorithms. The benchmarking framework provides guidelines on how to construct a benchmarking database that comprises true patient images, ground truth, and an evaluation protocol. The evaluation is based on the standard receiver operating characteristics analysis and it follows the medical practice in the decision making providing protocols for image- and pixel-based evaluations. During the work, two public medical image databases with ground truth were published: DIARETDB0 and DIARETDB1. The framework, DR databases and the final algorithm, are made public in the web to set the baseline results for automatic detection of diabetic retinopathy. Although deviating from the general context of the thesis, a simple and effective optic disc localisation method is presented. The optic disc localisation is discussed, since normal eye fundus structures are fundamental in the characterisation of DR.

Equivalence and translation strategies in multilingual thesaurus construction

In the present dissertation, multilingual thesauri were approached as cultural products and the focus was twofold: On the empirical level the focus was placed on the translatability of certain British-English social science indexing terms into the Finnish language and culture at a concept, a term and an indexing term level. On the theoretical level the focus was placed on the aim of translation and on the concept of equivalence. In accordance with modern communicative and dynamic translation theories the interest was on the human dimension. The study is qualitative. In this study, equivalence was understood in a similar way to how dynamic, functional equivalence is commonly understood in translation studies. Translating was seen as a decision-making process, where a translator often has different kinds of possibilities to choose in order to fulfil the function of the translation. Accordingly, and as a starting point for the construction of the empirical part, the function of the source text was considered to be the same or similar to the function of the target text, that is, a functional thesaurus both in source and target context. Further, the study approached the challenges of multilingual thesaurus construction from the perspectives of semantics and pragmatics. In semantic analysis the focus was on what the words conventionally mean and in pragmatics on the ‘invisible’ meaning - or how we recognise what is meant even when it is not actually said (or written). Languages and ideas expressed by languages are created mainly in accordance with expressional needs of the surrounding culture and thesauri were considered to reflect several subcultures and consequently the discourses which represent them. The research material consisted of different kinds of potential discourses: dictionaries, database records, and thesauri, Finnish versus British social science researches, Finnish versus British indexers, simulated indexing tasks with five articles and Finnish versus British thesaurus constructors. In practice, the professional background of the two last mentioned groups was rather similar. It became even more clear that all the material types had their own characteristics, although naturally not entirely separate from each other. It is further noteworthy that the different types and origins of research material were not used to represent true comparison pairs, and that the aim of triangulation of methods and material was to gain a holistic view. The general research questions were: 1. Can differences be found between Finnish and British discourses regarding family roles as thesaurus terms, and if so, what kinds of differences and which are the implications for multilingual thesaurus construction? 2. What is the pragmatic indexing term equivalence? The first question studied how the same topic (family roles) was represented in different contexts and by different users, and further focused on how the possible differences were handled in multilingual thesaurus construction. The second question was based on findings of the previous one, and answered to the final question as to what kinds of factors should be considered when defining translation equivalence in multilingual thesaurus construction. The study used multiple cases and several data collection and analysis methods aiming at theoretical replication and complementarity. The empirical material and analysis consisted of focused interviews (with Finnish and British social scientists, thesaurus constructors and indexers), simulated indexing tasks with Finnish and British indexers, semantic component analysis of dictionary definitions and translations, coword analysis and datasets retrieved in databases, and discourse analysis of thesauri. As a terminological starting point a topic and case family roles was selected. The results were clear: 1) It was possible to identify different discourses. There also existed subdiscourses. For example within the group of social scientists the orientation to qualitative versus quantitative research had an impact on the way they reacted to the studied words and discourses, and indexers placed more emphasis on the information seekers whereas thesaurus constructors approached the construction problems from a more material based solution. The differences between the different specialist groups i.e. the social scientists, the indexers and the thesaurus constructors were often greater than between the different geo-cultural groups i.e. Finnish versus British. The differences occurred as a result of different translation aims, diverging expectations for multilingual thesauri and variety of practices. For multilingual thesaurus construction this means severe challenges. The clearly ambiguous concept of multilingual thesaurus as well as different construction and translation strategies should be considered more precisely in order to shed light on focus and equivalence types, which are clearly not self-evident. The research also revealed the close connection between the aims of multilingual thesauri and the pragmatic indexing term equivalence. 2) The pragmatic indexing term equivalence is very much context-depended. Although thesaurus term equivalence is defined and standardised in the field of library and information science (LIS), it is not understood in one established way and the current LIS tools are inadequate to provide enough analytical tools for both constructing and studying different kinds of multilingual thesauri as well as their indexing term equivalence. The tools provided in translation science were more practical and theoretical, and especially the division of different meanings of a word provided a useful tool in analysing the pragmatic equivalence, which often differs from the ideal model represented in thesaurus construction literature. The study thus showed that the variety of different discourses should be acknowledged, there is a need for operationalisation of new types of multilingual thesauri, and the factors influencing pragmatic indexing term equivalence should be discussed more precisely than is traditionally done.