On-Line Analytical Processing of Inventory Turnover

Operatiivisen tiedon tuottaminen loppukäyttäjille analyyttistä tarkastelua silmällä pitäen aiheuttaa ongelmia useille yrityksille. Diplomityö pyrkii ratkaisemaan ko. ongelman Teleste Oyj:ssä. Työ on jaettu kolmeen pääkappaleeseen. Kappale 2 selkiyttää On-Line Analytical Processing (OLAP)- käsitteen. Kappale 3 esittelee muutamia OLAP-tuotteiden valmistajia ja heidän arkkitehtuurejaan sekä tyypillisten sovellusalueiden lisäksi huomioon otettavia asioita OLAP käyttöönoton yhteydessä. Kappale 4, tuo esille varsinaisen ratkaisun. Teknisellä arkkitehtuurilla on merkittävä asema ratkaisun rakenteen kannalta. Tässä on sovellettu Microsoft:n tietovarasto kehysrakennetta. Kappaleen 4 edetessä, tapahtumakäsittelytieto muutetaan informaatioksi ja edelleen loppukäyttäjien tiedoksi. Loppukäyttäjät varustetaan tehokkaalla ja tosiaikaisella analysointityökalulla moniulotteisessa ympäristössä. Vaikka kiertonopeus otetaan työssä sovellusesimerkiksi, työ ei pyri löytämään optimaalista tasoa Telesten varastoille. Siitä huolimatta eräitä parannusehdotuksia mainitaan.

A comparative study of ballpoint ink ageing parameters using GC/MS

For more than a decade scientists tried to develop methods capable of dating ink by monitoring the loss of phenoxyethanol (PE) over time. While many methods were proposed in the literature, few were really used to solve practical cases and they still raise much concern within the scientific community. In fact, due to the complexity of ink drying processes it is particularly difficult to find a reliable ageing parameter to reproducibly follow ink ageing. Moreover, systematic experiments are required in order to evaluate how different factors actually influence the results over time. Therefore, this work aimed at evaluating the capacity of four different ageing parameters to reliably follow ink ageing over time: (1) the quantity of solvent PE in an ink line, (2) the relative peak area (RPA) normalising the PE results using stable volatile compounds present in the ink formulation, (3) the solvent loss ratio (R%) calculated from PE results obtained by the analyses of naturally and artificially aged samples, (4) a modified solvent loss ratio version (R%*) calculated from RPA results. After the determination of the limits of reliable measurements of the analytical method, the repeatability of the different ageing parameters was evaluated over time, as well as the influence of ink composition, writing pressure and storage conditions on the results. Surprisingly, our results showed that R% was not the most reliable parameter, as it showed the highest standard deviation. Discussion of the results in an ink dating perspective suggests that other proposed parameters, such as RPA values, may be more adequate to follow ink ageing over time.

Multifactor Performance Study on Complex Systems for the Benefit of Management

The primary objective is to identify the critical factors that have a natural impact on the performance measurement system. It is important to make correct decisions related to measurement systems, which are based on the complex business environment. The performance measurement system is combined with a very complex non-linear factor. The Six Sigma methodology is seen as one potential approach at every organisational level. It will be linked to the performance and financial measurement as well as to the analytical thinking on which the viewpoint of management depends. The complex systems are connected to the customer relationship study. As the primary throughput can be seen in a new well-defined performance measurement structure that will also be facilitated as will an analytical multifactor system. These critical factors should also be seen as a business innovation opportunity at the same time. This master's thesis has been divided into two different theoretical parts. The empirical part consists of both action-oriented and constructive research approaches with an empirical case study. The secondary objective is to seek a competitive advantage factor with a new analytical tool and the Six Sigma thinking. Process and product capabilities will be linked to the contribution of complex system. These critical barriers will be identified by the performance measuring system. The secondary throughput can be recognised as the product and the process cost efficiencies which throughputs are achieved with an advantage of management. The performance measurement potential is related to the different productivity analysis. Productivity can be seen as one essential part of the competitive advantage factor.

Compressive neuropathy of the first branch of the lateral plantar nerve: a study by magnetic resonance imaging

Abstract Objective: To assess the prevalence of isolated findings of abnormalities leading to entrapment of the lateral plantar nerve and respective branches in patients complaining of chronic heel pain, whose magnetic resonance imaging exams have showed complete selective fatty atrophy of the abductor digiti quinti muscle. Materials and Methods: Retrospective, analytical, and cross-sectional study. The authors selected magnetic resonance imaging of hindfoot of 90 patients with grade IV abductor digiti quinti muscle atrophy according to Goutallier and Bernageau classification. Patients presenting with minor degrees of fatty muscle degeneration (below grade IV) and those who had been operated on for nerve decompression were excluded. Results: A female prevalence (78.8%) was observed, and a strong correlation was found between fatty muscle atrophy and plantar fasciitis in 21.2%, and ankle varices, in 16.8% of the patients. Conclusion: Fatty atrophy of the abductor digiti quinti muscle is strongly associated with neuropathic alterations of the first branch of the lateral plantar nerve. The present study showed a significant association between plantar fasciitis and ankle varices with grade IV atrophy of the abductor digiti quinti muscle.

Analytical procedures for determining Pb and Sr isotopic compositions in water samples by ID-TIMS

Few articles deal with lead and strontium isotopic analysis of water samples. The aim of this study was to define the chemical procedures for Pb and Sr isotopic analyses of groundwater samples from an urban sedimentary aquifer. Thirty lead and fourteen strontium isotopic analyses were performed to test different analytical procedures. Pb and Sr isotopic ratios as well as Sr concentration did not vary using different chemical procedures. However, the Pb concentrations were very dependent on the different procedures. Therefore, the choice of the best analytical procedure was based on the Pb results, which indicated a higher reproducibility from samples that had been filtered and acidified before the evaporation, had their residues totally dissolved, and were purified by ion chromatography using the Biorad® column. Our results showed no changes in Pb ratios with the storage time.

Determination of phenobarbital in human plasma by a specific liquid chromatography method: application to a bioequivalence study

A liquid chromatography method was developed and validated for the determination of phenobarbital in human plasma using phenytoin as internal standard. The drugs were extracted from plasma by liquid-liquid extraction and separated isocratically on a C12 analytical column, maintained at 35 ºC, with water:acetonitrile:methanol (58.8:15.2:26, v/v/v) as mobile phase, run at a flow rate of 1.2 mL/min with detection at 205 nm. The method was linear in the range of 0.1-4 μg/mL (r²=0.9999) and demonstrated acceptable results for the precision, accuracy and stability studies. The method was successfully applied for the bioequivalence study of two tablet formulations (test and reference) of phenobarbital 100 mg after single oral dose administration to healthy human volunteers.

Determination of levodopa in human plasma by high performance liquid chromatography-tandem mass spectrometry (HPLC-MS/MS): application to a bioequivalence study

A sensitive, accurate and simple method using HPLC-MS/MS was developed and validated for levodopa quantitation in human plasma. Analysis was achieved on a pursuit® C18 analytical column (5 µm; 150 x 4.6 mm i.d.) using a mobile phase (methanol and water , 90:10, v/v) containing formic acid 0.5% v/v, after extracting the samples using a simple protein plasma precipitation with perchloric acid. The developed method was validated in accordance with ANVISA guidelines and was successfully applied to a bioequivalence study in 60 healthy volunteers demonstrating the feasibility and reliability of the proposed method.

DEVELOPMENT AND VALIDATION OF ANALYTICAL METHOD FOR PALM OIL DETERMINATION IN MICROCAPSULES PRODUCED BY COMPLEX COACERVATION

The microencapsulation of palm oil may be a mechanism for protecting and promoting the controlled release of its bioactive compounds. To optimize the microencapsulation process, it is necessary to accurately quantify the palm oil present both external and internal to the microcapsules. In this study, we developed and validated a spectrophotometric method to determine the microencapsulation efficiency of palm oil by complex coacervation. We used gelatin and gum arabic (1:1) as wall material in a 5% concentration (w/v) and palm oil in the same concentration. The coacervates were obtained at pH 4.0 ± 0.01, decanted for 24 h, frozen (−40 ºC), and lyophilized for 72 h. Morphological analyzes were then performed. We standardized the extraction of the external palm oil through five successive washes with an organic solvent. We then explored the best method for rupturing the microcapsules. After successive extractions with hexane, we determined the amount of palm oil contained in the microcapsules using a spectrophotometer. The proposed method was shown to be of low cost, fast, and easy to implement. In addition, in the validation step, we confirmed the method to be safe and reliable, as it proved to be specific, accurate, precise, and robust.

Modeling study of limestone reactions in fluidized bed conditions

Traditionally limestone has been used for the flue gas desulfurization in fluidized bed combustion. Recently, several studies have been carried out to examine the use of limestone in applications which enable the removal of carbon dioxide from the combustion gases, such as calcium looping technology and oxy-fuel combustion. In these processes interlinked limestone reactions occur but the reaction mechanisms and kinetics are not yet fully understood. To examine these phenomena, analytical and numerical models have been created. In this work, the limestone reactions were studied with aid of one-dimensional numerical particle model. The model describes a single limestone particle in the process as a function of time, the progress of the reactions and the mass and energy transfer in the particle. The model-based results were compared with experimental laboratory scale BFB results. It was observed that by increasing the temperature from 850 °C to 950 °C the calcination was enhanced but the sulfate conversion was no more improved. A higher sulfur dioxide concentration accelerated the sulfation reaction and based on the modeling, the sulfation is first order with respect to SO2. The reaction order of O2 seems to become zero at high oxygen concentrations.

Warning system based on theoretical-experimental study of dispersion of soluble pollutants in rivers

Information about capacity of transport and dispersion of soluble pollutants in natural streams are important in the management of water resources, especially in planning preventive measures to minimize the problems caused by accidental or intentional waste, in public health and economic activities that depend on the use of water. Considering this importance, this study aimed to develop a warning system for rivers, based on experimental techniques using tracers and analytical equations of one-dimensional transport of soluble pollutants conservative, to subsidizing the decision-making in the management of water resources. The system was development in JAVA programming language and MySQL database can predict the travel time of pollutants clouds from a point of eviction and graphically displays the temporal distribution of concentrations of passage clouds, in a particular location, downstream from the point of its launch.

Fatigue study of the fillet weld waving on weld toe and the penetration in the weld root based on the effective notch stress approach

The fatigue failure of structures under fluctuating loads in fillet weld joints raises a demand to determine the parameters related to this type of loading. In this study, the stress distribution in the susceptible area of weld toe and weld root in fillet welded models analyzed by finite element method applying FEMAP software. To avoid the geometrical singularity on the path of analytical stress analysis in the toe and root area of a weld model the effective notch stress approach applied by which a proper fictitious rounding that mostly depend on the material of structure is applied. The models with different weld toe waving width and radius are analyzed while the flank angle of weld varied in 45 and 30 degrees. The processed results shows that the waving compare to the straight weld toe makes differences in the value of stress and consequently the stress concentration factor between the tip and depth of the waves in the weld toe which helps to protect the crack of propagation and gives enough time and tools to be informed of the crack initiation in the structure during the periodical observation of structure. In the weld root study the analyses among the models with the welding penetration percentage from non-penetration to the full-penetration shows a slightly increase in the root area stress value which comparing with the stiffening effect of penetration conclude that the half-penetration can make an optimization between the stress increase and stiffening effect of deep penetration.

Exploring relationship between marketing and sales - a case study of B2B ICT solution sales

Following the current trend of companies in changing and developing their businesses from transactional approach to relationship and solution oriented approach has set new requirements to internal cooperation of companies too. The relationship between marketing and sales has been identified to be critical to company's success here, but surprisingly little is known about it. The purpose of this study was to deepen understanding of the relationship between sales and marketing in business-to-business sales from operative sales employees' perspectives in solution selling context. The aim was to develop an explorative analytical construction and framework of the interface. The study was conducted as a literature review and an empirical qualitative explorative single case study. The data was collected by conducting six thematic interviews with sales employees of the case company. Observing sales and marketing, written documents and other materials used in sales were used as secondary source of information. The data was analyzed using qualitative case study analysis methods. The findings of the study support previous research findings of the interface between marketing and sales but also bring new propositions as analytical framework to construct the interface. As such, the interface was found to be a multi-dimensional and complex dynamic construction. As results of this study, there was an exploratory framework constructed. The construction consists of three explorative contexts of the interface: internal context, relationship emphasizing context and solution selling context. These contexts are further divided into lower levels as an outcome of the analysis. In addition the identified contexts, there are also conceptual domains identified, which are common to all the contexts. The role of mutual, cross-functional knowledge creation was found to be central in the interface.

Analytical methods for analyzing organic peroxides

Työn tarkoituksena oli kehittää analyyttinen erotusmenetelmä eräässä valmistusprosessissa käytettävän hapettavan aineen ja liuottimen välillä syntyvien reaktiotuotteiden tutkimiseen ja analysoimiseen. Lisäksi tarkoituksena oli tutkia prosessiolosuhteiden turvallisuutta. Kirjallisuusosassa käsitellään erilaisia orgaanisia peroksideja, niiden käyttötarkoituksia ja niiden käyttöön liittyviä huomioitavia asioita. Lisäksi tarkastellaan yleisimpiä analyysimenetelmiä, joita on käytetty erilaisten peroksidien analysoinnissa. Näitä analyysimenetelmiä on useimmiten käytetty nestemäisten näytteiden tutkimuksissa. Harvemmin on analysoitu kaasu- ja kiintoainenäytteitä. Kokeellisessa osassa kehitettiin kirjallisuuden perusteella peroksidiyhdisteille identifiointimenetelmä ja tutkittiin prosessin näytteet. Analyysimenetelmiksi valittiin iodometrinen titraus ja HPLC-UV-MS-menetelmä. Lisäksi käytettiin peroksidimittaukseen soveltuvia testiliuskoja. Tutkimus osoitti, että iodometrisen titrauksen ja testiliuskojen perusteella näytteissä oli vähäisiä määriä peroksideja viikon jälkeen peroksidilisäyksestä. HPLC-UV-MS-analyysien perusteella näytteiden analysointia häiritsi selluloosa, jota löytyi jokaisesta näytteestä.

Flows of Bingham Materials Through Ideal Porous Media: an Experimental and Theoretical Study

The flow of Bingham liquids through porous media has been studied. Experiments have been performed to determine the flow rate / pressure drop relationship for the flow of a grease of Binghamian rheological behavior through an array of rods of circular cross section. The yield stress and plastic viscosity of the grease have been determined with the aid of a controlled stress rotational rheometer. To investigate a wider range of the flow parameters, the mass and momentum conservation equations have been solved numerically, in conjunction with the generalized Newtonian constitutive law and the bi-viscosity model. The finite volume method has been employed to obtain the numerical solution. These numerical results also yielded a flow rate / pressure drop relationship, which is in very good agreement with the experimental results. A capillaric theory has been developed to determine an analytical relationship between the flow rate and pressure drop for flows of Bingham liquids through porous media. It is shown that the predictions of this theory are in good agreement with the experimental and numerical results.