Search results for "tietokannat"
showing 10 items of 51 documents
Atlas of Finnish bats
2019
This atlas is based on information in museum collections, literature, databases and unpublished data. In the last 150 years, the number of bat species in Finland increased from six to thirteen. Of these, five are common and regularly breeding (Eptesicus nilssonii, Myotis brandtii, Myotis daubentonii, Myotis mystacinus, Plecotus auritus), and eight rare (Eptesicus serotinus, Myotis dasycneme, Myotis nattereri, Nyctalus noctula, Pipistrellus nathusii, Pipistrellus pipistrellus, Pipistrellus pygmaeus, Vespertilio murinus), of which breeding of two (M. nattereri, P. nathusii) have been confirmed. The total number of records in the study is 11 234, of which 9717 are identified to species. The re…
Newly Digitized Database Reveals the Lives and Families of Forced Migrants from Finnish Karelia
2017
Studies on displaced persons often suffer from a lack of data on the long-term effects of forced migration. A register created during 1960s and published as a book series ‘Siirtokarjalaisten tie’ in 1970 documented the lives of individuals who fled the southern Karelian district of Finland after its first and second occupation by the Soviet Union in 1940 and 1944. To realize the potential value of these data for scientific research, we have recently scanned the register using optical character recognition (OCR) software, and developed proprietary computer code to extract these data. Here we outline the steps involved in the digitization process, and present an overview of the Migration Kare…
NewSQL Database Management System Compiler Errors : Effectiveness and Usefulness
2022
Modern database management is often faced with a high number of concurrent end-users, and the need for database distribution to ensure fault tolerance and high throughput. To flexibly address these challenges, many modern database management systems (DBMS) provide highly automated and effortless, i.e., highly usable database distribution, deployment, and maintenance. However, the usability considerations are yet to extend from the aforementioned DBMS features to query language compilers. In this study, based on participant answers (N = 157), we compare the error message qualities of four modern DBMSs (CockroachDB, SingleStore, NuoDB, and VoltDB) using one objective and three subjective metr…
What to Expect and What to Focus on in SQL Query Teaching
2019
In the process of learning a new computer language, writing erroneous statements is part of the learning experience. However, some errors persist throughout the query writing process and are never corrected. Structured Query Language (SQL) consists of a number of different concepts such as expressions, joins, grouping and ordering, all of which by nature invite different possible errors in the query writing process. Furthermore, some of these errors are relatively easy for a student to fix when compared to others. Using a data set from three student cohorts with the total of 744 students, we set out to explore which types of errors are persistent, i.e., more likely to be left uncorrected by…
The Effects of Database Complexity on SQL Query Formulation
2020
In Structured Query Language (SQL) education, students often execute queries against a simple exercise database. Recently, databases that are more realistic have been utilized to the effect that students find exercises more interesting and useful, as these databases more accurately mimic databases students are likely to encounter in their future work environments. However, using even the most engaging database can be counterproductive to learning, if a student is not able to formulate correct queries due to the complexity of the database schema. Scientific evidence on the effects of database complexity on student’s query formulation is limited, and with queries from 744 students against thr…
Relaatio- ja epärelaatiotietokantojen suorituskykyvertailu : MySQL ja MongoDB
2016
Tutkielmassa esitellään relaatio- ja epärelaatiotietokantoja sekä paneudutaan niiden ominaisuuksiin. Nykyään erilaisia tietokantahallintajärjestelmiä on paljon. Ongelmaksi tulee se, että mikä tietokantahallintajärjestelmä on järkevin valinta uudelle ohjelmistoprojektille. Valinnan tärkeyttä korostaa vielä se, että kehitettävä ohjelma tulee olemaan sidottu kyseiseen tietokantaan koko projektin aikajänteen ja sen vaihtaminen projektin edetessä tulee päivä päivältä kalliimmaksi. Alkuvaiheessa tehtävät valinnat voivat mennä hyvin helposti pieleen, koska tarpeellista toimialakohtaista osaamista ja kokonaisuuden hahmotusta ei ole välttämättä pystytty sisäistämään täydellisesti. Tutkielman tarkoit…
Understanding and analyzing SQL/CLI database usage of Java software: empirical study
2005
Avointa ja modulaarista : Koha saapui tieteellisiin kirjastoihin
2021
Kun päätös Koha-kirjastojärjestelmän valinnasta syntyi, tärkeä valintakriteeri oli se, että avoimen lähdekoodin ohjelmiston nähtiin soveltuvan parhaiten modulaariseen järjestelmäkehitykseen. Koha-kirjastot katsoivat, että kirjastot ja kirjastoteknologia ovat kypsiä aidosti modulaarisen teknisen ympäristön rakentamiseen. Koha-järjestelmän käyttöönottoa korkeakouluissa auttoi yleisissä kirjastoissa aiemmin tehty työ. Tiivis yhteistyö ja yhdessä tekeminen on kehittämisen avain jatkossakin, niin kansallisesti kuin kansainvälisesti. Tulevaisuuden suuria kehityskohteita ovat e-aineistojen hallintaan (ERM) ja kuvailuun liittyvät ratkaisut. nonPeerReviewed
Multicriteria decision making taxonomy of code recommendation system challenges: a fuzzy-AHP analysis
2022
AbstractThe recommendation systems plays an important role in today’s life as it assist in reliable selection of common utilities. The code recommendation system is being used by the code databases (GitHub, source frog etc.) aiming to recommend the more appropriate code to the users. There are several factors that could negatively impact the performance of code recommendation systems (CRS). This study aims to empirically explore the challenges that could have critical impact on the performance of the CRS. Using systematic literature review and questionnaire survey approaches, 19 challenges were identified. Secondly, the investigated challenges were further prioritized using fuzzy-AHP analys…
The Key Concepts of Ethics of Artificial Intelligence
2018
The growing influence and decision-making capacities of Autonomous systems and Artificial Intelligence in our lives force us to consider the values embedded in these systems. But how ethics should be implemented into these systems? In this study, the solution is seen on philosophical conceptualization as a framework to form practical implementation model for ethics of AI. To take the first steps on conceptualization main concepts used on the field needs to be identified. A keyword based Systematic Mapping Study (SMS) on the keywords used in AI and ethics was conducted to help in identifying, defying and comparing main concepts used in current AI ethics discourse. Out of 1062 papers retrieve…