The London Creative Industries

This lecture draws from the Creative Industries Observatory research on the London creative industries and in particular provides some initial insights into the networks and relationships which exist including organisational structure, size, and location. Consideration has been given to clustering and markets. In particular attention has been paid to the levels of creativity found in the London creative industries and the possible implications for public policy intervention. These findings are based on a shared definitional framework, and can be compared with other cities

DualTable: A Hybrid Storage Model for Update Optimization in Hive

Hive is the most mature and prevalent data warehouse tool providing SQL-like interface in the Hadoop ecosystem. It is successfully used in many Internet companies and shows its value for big data processing in traditional industries. However, enterprise big data processing systems as in Smart Grid applications usually require complicated business logics and involve many data manipulation operations like updates and deletes. Hive cannot offer sufficient support for these while preserving high query performance. Hive using the Hadoop Distributed File System (HDFS) for storage cannot implement data manipulation efficiently and Hive on HBase suffers from poor query performance even though it can support faster data manipulation.There is a project based on Hive issue Hive-5317 to support update operations, but it has not been finished in Hive's latest version. Since this ACID compliant extension adopts same data storage format on HDFS, the update performance problem is not solved. In this paper, we propose a hybrid storage model called DualTable, which combines the efficient streaming reads of HDFS and the random write capability of HBase. Hive on DualTable provides better data manipulation support and preserves query performance at the same time. Experiments on a TPC-H data set and on a real smart grid data set show that Hive on DualTable is up to 10 times faster than Hive when executing update and delete operations.Comment: accepted by industry session of ICDE201

An Ontology for Product-Service Systems

Industries are transforming their business strategy from a product-centric to a more service-centric nature by bundling products and services into integrated solutions to enhance the relationship between their customers. Since Product- Service Systems design research is currently at a rudimentary stage, the development of a robust ontology for this area would be helpful. The advantages of a standardized ontology are that it could help researchers and practitioners to communicate their views without ambiguity and thus encourage the conception and implementation of useful methods and tools. In this paper, an initial structure of a PSS ontology from the design perspective is proposed and evaluated

Reports in Transition — The Case of Business Data Visualization in Ideal Keittiöt Oy

The aim of this thesis was to develop three new relevant Qlik Sense reports for Ideal Keittiöt Oy, which is a Finnish company selling kitchen and sanitary fixtures. Ideal Keittiöt Oy had been using a custom-built enterprise resource planning system named Tarla with a customized Pentaho Reporting embedded in it since 2011. In 2017, a switch to Jeeves ERP and Qlik Sense was initiated out of business needs. The end-users of the new reports were to be the management staff and a few select employees. The Jeeves ERP’s database was also to be partly documented for reporting purposes. The use statistics of Pentaho Reporting’s reports were analyzed and the end-users were interviewed about their reporting needs. In March 2018, based on this information two new reports were selected to be implemented. One new Qlik Sense report was implemented: an ABC analysis of sales deliveries using Tarla’s data, because data from Jeeves ERP was not yet available. Research on visual perception was used in the new report for the effective visualization of data. In 2019, Jeeves ERP was deployed in Ideal Keittiöt Oy. In November 2019, an internal guide for using Jeeves ERP’s database in reporting was written for Ideal Keittiöt Oy as a master’s project, which partially satisfied this thesis’s aim related to documentation. Three new reports had originally been aimed for, two had been selected to be implemented and one had been finally implemented. This new report looked quite good and was moderately easy to use, but was not useful anymore in 2020 because it did not use Jeeves ERP’s data.Tämän tutkielman tavoitteena oli kehittää kolme uutta merkityksellistä Qlik Sense -raporttia Ideal Keittiöt Oy:lle, joka on suomalainen keittiö- ja saniteettikalusteita myyvä yritys. Ideal Keittiöt Oy oli käyttänyt Tarla-nimistä erikoisvalmisteista toiminnanohjausjärjestelmää siihen sulautetun räätälöidyn Pentaho Reportingin kanssa vuodesta 2011 alkaen. Vuonna 2017 käynnistettiin liiketoiminnallisten tarpeiden perusteella vaihto Jeeves ERPiin ja Qlik Senseen. Uusien raporttien loppukäyttäjien oli tarkoitus olla johtohenkilöstö ja harvat valitut työntekijät. Tässä työssä oli tarkoituksena myös osittain dokumentoida Jeeves ERPin tietokanta raportointitarpeita varten. Pentaho Reportingin raporttien käyttötilastoja analysoitiin ja loppukäyttäjiä haastateltiin heidän raportointitarpeisiinsa liittyen. Maaliskuussa 2018 näiden tietojen perusteella valittiin kaksi uutta raporttia toteutettaviksi. Yksi uusi Qlik Sense -raportti toteutettiin: myyntitoimitusten ABC-analyysi Tarlan dataa käyttäen, koska Jeeves ERPin dataa ei ollut vielä saatavilla. Näköaistitutkimusta käytettiin uudessa raportissa datan tehokkaaseen visualisointiin. Vuonna 2019 Jeeves ERP otettiin käyttöön Ideal Keittiöt Oy:ssa. Marraskuussa 2019 kirjoitettiin erikoistyö Ideal Keittiöt Oy:n sisäinen ohje Jeeves ERP -raportointiin, mikä osittain täytti tämän tutkielman tavoitteen dokumentointiin liittyen. Alunperin oli tavoiteltu kolmea uutta raporttia, kaksi oli valittu toteutettaviksi ja lopulta yksi oli toteutettu. Tämä uusi raportti näytti melko hyvältä, oli kohtuullisen helppo käyttää, mutta ei ollut enää hyödyllinen vuonna 2020, koska se ei käyttänyt Jeeves ERPin dataa

Developing a distributed electronic health-record store for India

The DIGHT project is addressing the problem of building a scalable and highly available information store for the Electronic Health Records (EHRs) of the over one billion citizens of India