Implementation Of Database Research Articles

Prosopographic Database "Victims of the Holodomor of 1932–1933 in Dnipropetrovsk Region": Theoretical, Methodological and Technological Aspects

The aim of the article is to represent the idea of a roll-call database about the victims of the 1932-1933 Holodomor and the scientific perspectives of its use in historical research. Research methods: logical-linguistic, comparative, system-structural; database technology. The main results: the article highlights the theoretical, methodological and technological principles of projecting a relational database of prosopographic data of victims of the Dnipropetrovsk region during the Holodomor; the main directions of its use for studying social and demographic consequences of the mortality of the population of the region are indicated. Practical importance: the experience of forming a database can be extended to data from other regions of Ukraine; the use of a database management system will allow relevant search of data by different criteria (age, gender, social origin, ethnicity, causes of death); the database can be used as factual material in genealogical research. Originality: generalized experience of designing relevant databases; the author's conceptual model of the prosopographic database was developed taking into account the specificity of the source database of the problem. Scientific novelty: the conceptual model and practical implementation of the prosopographic database about victims of the 1932-1933 Holodomor according to archival and published sources were first proposed. Article type:analitycal-applied.

APPLICATION OF NON-RELATIONAL DATABASES IN THE SOCIAL NETWORKS

The purpose of this research is to present knowledge in the field of work of databases that contain semi-structured data, also known as NoSQL, in applications using large array data structures. The characteristics of the main categories of the non-relational databases and some of their typical representatives (MongoDB, Redis) have been reviewed from the point of view of using them for saving and analysis of data in the social networks. The article presents a study, conducted on the already existing studies in regards to the implementation of the non-relational databases in social networks. Some of the perspectives of the future research are outlined as well.

Mortadelo: Automatic generation of NoSQL stores from platform-independent data models

In the last decade, several NoSQL systems have emerged as a response to the scalability problems manifested by classical relational databases when used in Big Data contexts. These NoSQL systems appeared first as physical-level solutions, initially lacking any design methodologies. After this initial batch of systems, several design methodologies for NoSQL have been recently created. Nevertheless, most of these methodologies target just one NoSQL paradigm. In addition, as each methodology uses a different conceptual modeling approach, NoSQL database designers would need to remake conceptual models as they switch from one NoSQL paradigm to another. Moreover, most of these design processes provide just a set of design heuristics and guidelines that database designers need to apply manually, which can be a time-consuming and error-prone process. To overcome these limitations, this article presents Mortadelo, a model-driven NoSQL database design process where, from a high-level conceptual model, independent of any specific NoSQL paradigm, an implementation for a concrete NoSQL database system can be automatically generated. Moreover, this database generation process can be customized, so that some design trade-offs can be managed differently according to each context needs. We evaluated Mortadelo’s capabilities by generating database implementations for several typical NoSQL case studies. In these cases, Mortadelo was able to generate implementations for the Cassandra and MongoDB NoSQL systems from the same conceptual data model. These implementations were similar to the ones generated by design methodologies specifically developed for a single paradigm. Therefore, design quality is not sacrificed by our approach in favor of generality.

Implementation of a New Food Picture Database in the Context of fMRI and Visual Cognitive Food-Choice Task in Healthy Volunteers

This pilot study aimed at implementing a new food picture database in the context of functional magnetic resonance imaging (fMRI) cognitive food-choice task, with an internal conflict or not, in healthy normal-weight adults. The database contains 170 photographs including starters, main courses, and desserts; it presents a broad-spectrum of energy content and is provided with portion weight and nutritional information. It was tested in 16 participants who evaluated the energy density and gave a liking score for all food pictures via numerical scales. First, volunteers were segregated into two groups according to their eating habits according to a food consumption frequency questionnaire (FCFQ) to assess whether the database might elicit different appreciations according to individual eating habits. Second, participants underwent fMRI cognitive food-choice task (van der Laan et al., 2014), using our picture database, in which they had to choose between high-energy (HE) and low-energy (LE) foods, under a similar liking (SL, foods with similar hedonic appraisals) condition or a different liking (DL, foods with different hedonic appraisals) condition. Participants evaluated correctly the caloric content of dishes (from r = 0.72 to r = 0.79, P < 0.001), confirming a good perception of the caloric discrepancies between food pictures. Two subgroups based on FCFQ followed by a principal component analysis (PCA) and a hierarchical ascendant classification (HAC) were defined, that is, Prudent-type (PTc, N = 9) versus Western-type (WTc, N = 7) consumers, where the WTc group showed higher consumption of HE palatable foods than PTc (P < 0.05). The WTc group showed a higher correlation between liking and caloric evaluation of the food pictures as compared to PTc (r = 0.77 and r = 0.36, respectively, P < 0.001), confirming that food pictures elicited variable responses according to contrasted individual eating habits. The fMRI analyses showed that the DL condition elicited the activation of dorsal anterior cingulate cortex (dACC), involved in internal conflict monitoring, whereas SL condition did not, and that LE food choice involved high-level cognitive processes with higher activation of the hippocampus (HPC) and fusiform gyrus compared to HE food choice. Overall, this pilot study validated the use of the food picture database and fMRI-based procedure assessing decision-making processing during a food choice cognitive task with and without internal conflict.

Fluid-mediated carbon release from serpentinite-hosted carbonates during dehydration of antigorite-serpentinite in subduction zones

Subduction of serpentinite-hosted carbonate rocks formed during the oceanic stage in the oceanic lithosphere (ophicalcite) or by metasomatism at the slab mantle-wedge interface (hybrid carbonate–talc rocks) constitute important fluxes of carbon in subduction zones. If hosted in the hydrated mantle lithosphere of the slab, these carbonate-rocks may be preserved from the infiltration of fluids produced by prograde metamorphism of the overlying meta-sediments and the hydrated oceanic crust to subarc depths, where they are fluxed by fluids derived from dehydration of their host serpentinite. Because the dissolution of carbonate in aqueous fluids is enhanced at high P and T, fluid-mediated carbon release at subarc depth is critical to understand the global carbon balance and magnitude of carbon fluxes from the subducting plate into the deep mantle. This contribution presents thermodynamic modelling —using the implementation of the DEW aqueous database in Perple_X— of prograde devolatilization reactions (solid = fluid + solid) and infiltration-driven devolatilization reactions (external fluid + solid = fluid + solid) of serpentinite-hosted carbonate rocks. In line with previous studies of prograde devolatilization of carbon-bearing oceanic crust, our models show that, in warm and cold subductions zones, the carbon released into fluids produced by prograde devolatilization reactions of meta-ophicalcite and carbonate-talc rocks is limited even if electrolytic complexing in the fluid phase is taken into account. Therefore, serpentinite-hosted meta-carbonate rocks are likely to be preserved to subarc depths, where they undergo infiltration-driven devolatilization by fluids derived from Atg-serpentinite dehydration. At the P–T conditions of Atg-breakdown in cold to warm subduction zones, our models of infiltration-driven devolatilization of meta-ophicalcite and carbonate-talc rocks indicate that carbon release is accompanied by significant Ca loss, particularly at high pressures (P>3.5 GPa), due to the high concentration of CaHCO+3 in the fluid. The carbon solubility in fluids equilibrated with meta-ophicalcite and carbonate–talc rocks is markedly higher than for pure aragonite. Mass balance considerations combined with the parameterization of the P–T conditions of Atg-serpentinite dehydration as a function of the thermal parameter of subduction zones allow us to investigate the carbon loss caused by infiltration of serpentinite dehydration fluids. Unlike the dissolution of pure CaCO3, carbonate dissolution in serpentinite-hosted meta-carbonate rocks is highest at the slab surface of warm subduction zones and lowest at Moho depths of cold subduction zones, where Atg-serpentinite dehydration occurs at greater depths. Carbon in subducted meta-ophicalcite —with thicknesses of up to 70 m typically found in oceanic ophicalcite— will be preserved beyond the subarc depths of cold and hot subduction zones, and recycled into the deep mantle as carbonate-garnet-clinopyroxene-olivine rocks. At the subarc depths of most subduction zone regimes, infiltration-driven devolatilization of subducted carbonate-talc rocks is a highly efficient decarbonation mechanism transforming these rocks into carbon-free orthopyroxenite.

Standardizing Safety Assessment and Reporting for Neonatal Clinical Trials

Standardizing Safety Assessment and Reporting for Neonatal Clinical Trials

221 Implementation of a Prospective Multidisciplinary Clinical Database for Head and Neck Cancer at the Ottawa Hospital

221 Implementation of a Prospective Multidisciplinary Clinical Database for Head and Neck Cancer at the Ottawa Hospital

SEISMIC DAMAGE ASSESSMENT OF LIFELINES BASED ON GEOSPATIAL ANALYSIS

Abstract. The main purpose of this study is to develop a Geospatial Information System (GIS) model with the ability to assess the seismic damage to lifelines for two well-known hazards, including ground shaking and ground failure simultaneously. The model that is developed and used in this study includes four main parts of database implementation, seismic hazard analysis, vulnerability assessment and seismic damage assessment to determine the lifeline’s damage probability. To consider uncertainty analysis in the model, Monte Carlo simulation is used based on 10,000 iterations. The results of hazard analysis indicated that peak ground acceleration is about 0.03 g to 0.3 g and there is slight to moderate damages to the desired infrastructure in the study area.

Community-Based Cooperatives as an innovative partnership to contrast inner areas decline

The paper aims to describe the main characteristics of CBCs, and to highlight their outcomes in economics and social terms. The data, referring to year 2016, originates from the aida database of Bureau van Dijk. However, the sample construction took a number of steps: 1) interviews with privileged witnesses, 2) web search, 3) aida database interrogation; selection of the cooperative enterprises and checking their features, and 4) final database implementation. Our sample, consisting of 32 observations, has been segmented by means of a cluster analysis, with the aim of subdividing the CBCs in homogeneous groups on the basis of the variables under consideration. The results show that CBCs may contribute to prevent inner areas decline, mainly by the provision of essential services to the whole community; this is a benefit created by means of business activity and the participation of its members to its management. Nevertheless, the results also show a limited ability of CBCs to make investments on the areas in which they operate. As a consequence, CBCs have a low employment capacity. In every case, uncertainty on the real CBCs number and the limited sample size do not allow for a generalisation of these results.

A Revised Cross-Section Database for Gas Retrieval in the UV-Visible-Near IR Range, Applied to the GOMOS Retrieval Algorithm AerGOM

In this paper, we present the revision of the cross-section database used for the retrieval of aerosol and gas species from remote sensing measurements by the GOMOS instrument onboard ENVISAT. The absorption cross-section spectra concern ozone, nitrogen dioxide and nitrogen trioxide, for which improved datasets have been published since the implementation of the original GOMOS cross-section database in preparation of the ENVISAT mission. We evaluate the molecular absorption cross-section spectra currently available for O3, NO2 and NO3, and we present and discuss our selection of datasets and the set-up of the revised absorption cross-section database, with the focus on these three gases. The objective is to provide an optimal characterization of their absorption spectrum over the UV-visible-near IR range used by AerGOM, a retrieval algorithm that was designed to optimize the retrieval of aerosol species from GOMOS measurements. Despite its application to the specific case of GOMOS, it is the aim of this work to cover a more general scope than this particular mission, and to provide an evaluation applicable to any other case of remote sensing experiment covering the UV to near IR range, possibly with a high spectral resolution.

A New Relational Database Including Clinical Data and Myocardial Perfusion Imaging Findings in Coronary Artery Disease.

The aim of this study was to test a relational database including clinical data and imaging findings in a large cohort of subjects with suspected or known Coronary Artery Disease (CAD) undergoing stress single-photon emission computed tomography (SPECT) myocardial perfusion imaging. We developed a relational database including clinical and imaging data of 7995 subjects with suspected or known CAD. The software system was implemented by PostgreSQL 9.2, an open source object-relational database, and managed from remote by pgAdmin III. Data were arranged according to a logic of aggregation and stored in a schema with twelve tables. Statistical software was connected to the database directly downloading data from server to local personal computer. There was no problem or anomaly for database implementation and user connections to the database. The epidemiological analysis performed on data stored in the database demonstrated abnormal SPECT findings in 46% of male subjects and 19% of female subjects. Imaging findings suggest that the use of SPECT imaging in our laboratory is appropriate. The development of a relational database provides a free software tool for the storage and management of data in line with the current standard.

Building a database for curriculum mapping and analytics

This article was migrated. The article was marked as recommended. Curriculum mapping of an outcomes-based programme using a database was developed using a relational database structure, and it functions as a searchable database by the use of keywords. Factors such as the framework of the programme, the database entity relationship diagram (ERD), benchmarking, terminology and nomenclature, analytics and integration with the learning management system requires careful consideration before implementation. Built into the structure of the curriculum database are the analytics features which identifies the curricula data using defined keywords. This enables staff and students to search through any programme or subject of interest to track a subject or keyword to the point of delivery with the use of the analytics feature. This results in the curricula information being transparent for all stakeholders, ensuring curriculum mapping and blueprinting of assessments are readily available.This paper reports on the implementation of a university-wide curricula database which includes multiple undergraduate and postgraduate programmes, including chronological versions of a programme at an institution with diverse health professions programmes, including medicine, dentistry, pharmacy. Additionally, this paper outlines the steps to design the curricula database, the development of the framework of the database and the analytics, the challenges in implementation, the results that can be obtained from such a database and the lessons learnt.

Design and Implementation of Yunnan Province Soil Environmental Quality Database Based on ArcSDE for Oracle

The environmental quality monitoring work in Yunnan Province began in the 1970s. After 40 years of development, the Yunnan Province Environmental Monitoring System was initially established. However, the soil environmental monitoring data of the province lacks a unified warehousing standard, and a spatial database of soil environmental quality has not been established to integrate and standardize the data. Based on the research and reference to the relevant standards of soil database construction method and management at home and abroad, GeoDatabase is used as the spatial data model, and the conceptual model, logical organization model and storage model of Yunnan Province soil environmental quality database are designed by using Oracle and ArcSDE technologies. In order to accurately reflect the spatial location of the soil sampling points and the characteristic properties of the samples, and to ensure the uniqueness and rationality of the primary key in the data table, this paper designs the coding of the soil environmental quality database. The construction of soil environmental quality database in Yunnan Province realized the seamless integration of spatial data and attribute data, and provided comprehensive and accurate basic data and scientific decision support for soil pollution prevention and soil ecological restoration in Yunnan Province.

DESAIN DAN IMPLEMENTASI PEMODELAN DATABASE INDUSTRI KECIL MENENGAH KOTA PALEMBANG

The focus of this research is to design and implement a small medium industry database for the Palembang City Government . The database needs of small and medium industries due to the unavailability of data quickly and accurately when it requires information by the Department of Industry in policy making. The design and implementation of the IKM database has stages carried out starting from the needs analysis, database formation, information modeling, dashboard manufacturing, to testing. The resulting dashboard can provide data in the form of graphs and tables relating to small and medium industries either through the criteria of the region or type of industry. The layout and presentation of the data has been validated using a heuristic evaluation approach involving three experts. The validation results show that all experts agree that the results of the design and implementation of small medium industry databases do not have usability problems as evidenced by the results of the average expert testing giving a value of 0. Keywords — Database, heuristic evaluation, industry, IKM

Implementasi Aplikasi Database Untuk Mendukung Sistem Smart card Di STKIP Muhammadiyah Bone

Smart campus refers to campus facilities which are supporting all activities of the academics in carrying out the obligations of the Tridarma Perguruan Tinggi using information technology as the backbone. STKIP Muhammadiyah Bone was chosen as a partner in the community service program. In order to welcome a transformation, the campus will direct its services with technology. Currently services such as student registration, attendance input is still done mannually, in the future it will be converted into an electronic system. However, in STKIP Muhammadiyah Bone, it has not applied smart campus system. The proposed solution is to make Smart cards socialization and training and database implementation. After thorough socialization and training which includes hardware, software, procedures and work procedures, furthermore, independent development is carried out by the campus itself. This activity was held for one day and went smoothly judging from the enthusiasm of the staff and students who participated in this activity and the installation of two smartcard systems in the rector and vice rector rooms.

Malta’s ISBN Database and the Benefits of Open Data

In 2016, the National Book Council, the ISBN agency for Malta, released its ISBN database online. A few months later, the ISBN database was enhanced with an open-data feature that enables users to download the search results in a single file with read and write access. The database includes all the ISBN data of Malta except for some records and data that were lost during the period before 2013 when paper data storage of ISBN records was the common practice. The implementation of an ISBN electronic database now ensures that no data go missing and facilitates the preservation of metadata. As added value, the open-data system provides access to all of the ISBN records as listed in the database, which means that virtually all of the ISBN data elements can be downloaded from the database. Researchers, publishers, authors, and booksellers all stand to benefit from this open ISBN data system.

Nucleic Acid Databases and Molecular-Scale Computing.

DNA outperforms most conventional storage media in terms of information retention time, physical density, and volumetric coding capacity. Advances in synthesis and sequencing technologies have enabled implementations of large synthetic DNA databases with impressive storage capacity and reliable data recovery. Several robust DNA storage architectures featuring random access, error correction, and content rewritability have been constructed with the potential for scalability and cost reduction. We survey these recent achievements and discuss alternative routes for overcoming the hurdles of engineering practical DNA storage systems. We also review recent exciting work on in vivo DNA memory including intracellular recorders constructed by programmable genome editing tools. Besides information storage, DNA could serve as a versatile molecular computing substrate. We highlight several state-of-the-art DNA computing techniques such as strand displacement, localized hybridization chain reactions, and enzymatic reaction networks. We summarize how these simple primitives have facilitated rational designs and implementations of in vitro DNA reaction networks that emulate digital/analog circuits, artificial neural networks, or nonlinear dynamic systems. We envision these modular primitives could be strategically adapted for sophisticated database operations and massively parallel computations on DNA databases. We also highlight in vivo DNA computing modules such as CRISPR logic gates for building scalable genetic circuits in living cells. To conclude, we discuss various implications and challenges of DNA-based storage and computing, and we particularly encourage innovative work on bridging these two areas of research to further explore molecular parallelism and near-data processing. Such integrated molecular systems could lead to far-reaching applications in biocomputing, security, and medicine.

Benchmarking Graph Database Backends—What Works Well with Wikidata?

Knowledge bases often utilize graphs as logical model. RDF-based knowledge bases (KB) are prime examples, as RDF (Resource Description Framework) does use graph as logical model. Graph databases are an emerging breed of NoSQL-type databases, offering graph as the logical model. Although there are specialized databases, the so-called triple stores, for storing RDF data, graph databases can also be promising candidates for storing knowledge. In this paper, we benchmark different graph database implementations loaded with Wikidata, a real-life, large-scale knowledge base. Graph databases come in all shapes and sizes, offer different APIs and graph models. Hence we used a measurement system, that can abstract away the API differences. For the modeling aspect, we made measurements with different graph encodings previously suggested in the literature, in order to observe the impact of the encoding aspect on the overall performance.&#x0D;

Novel Mobile Device-Based Tool to Document Sideline Evaluation of Athletes.

We describe the implementation of the Athletic Injury Database (AID), a mobile device-based tool for documenting sideline encounters with athletes. Primary measures of the implementation process were: 1) patterns of AID use, 2) nature of sideline encounters captured, and 3) providers' reported satisfaction. Over 2 yr, the AID captured 6237 sideline encounters by athletic trainers and physicians. Most encounters were among athletes participating in football (51%), soccer (15%), and basketball (12%). Knee and ankle injuries were most common. A total of 77% of sports medicine providers were satisfied with the AID. Providers can use information gleaned from a tool like the AID to improve documentation of care provided to athletes.

Conceptualisation of an Information Analytical Database of Reference Standards

The article summarises the main results of a study investigating integrated development and implementation of an information analytical database of reference standards in the Federal State Budgetary Institution «Scientific Centre for Expert Evaluation of Medicinal Products» of the Ministry of Health of Russia (FSBI «SCEEMP»). The subject of the research is an information analytical database of reference standards designed to assess the quality, efficacy and safety of medicines. The aim of the study was to create the concept of an information analytical database of reference standards based on object-oriented approaches. The database was created in response to the need for improving the efficiency of certain types of activities of the FSBI «SCEEMP» which has already automated some of its processes. The paper discusses the key prerequisites for the creation of an integrated specialised information technology product as a way to improve overall performance. A general procedure for the development of an information and analytical database is presented, taking into account the tasks set and the established requirements for the functionality of the information and analytical system. The paper describes the implemented solutions, as well as strategies for their improvement. The operation algorithms of the information-analytical database of reference materials allow for its further modernisation, as well as greater automation of actions with documents and data, incorporation of new standardised reference books, ready-made templates, as well as modification in case any changes are made to business processes, legislation or technical and technological aspects of using reference standards.