Implementation Of Database Research Articles

Benchmarking top-[formula omitted] keyword and top-[formula omitted] document processing with T[formula omitted]K[formula omitted] and T[formula omitted]K[formula omitted]D[formula omitted

Top-k keyword and top-k document extraction are very popular text analysis techniques. Top-k keywords and documents are often computed on-the-fly, but they exploit weighted vocabularies that are costly to build. To compare competing weighting schemes and database implementations, benchmarking is customary. To the best of our knowledge, no benchmark currently addresses these problems. Hence, in this paper, we present T2K2, a top-k keywords and documents benchmark, and its decision support-oriented evolution T2K2D2. Both benchmarks feature a real tweet dataset and queries with various complexities and selectivities. They help evaluate weighting schemes and database implementations in terms of computing performance. To illustrate our benchmarks’ relevance and genericity, we successfully ran performance tests on the TF-IDF and Okapi BM25 weighting schemes, on one hand, and on different relational (Oracle, PostgreSQL) and document-oriented (MongoDB) database implementations, on the other hand.

Implementation of Database Massively Parallel Processing System to Build Scalability on Process Data Warehouse

The problem with telecommunications companies today is that transactional data is more extensive than existing source tables. This makes business reporting less efficient and overwhelms query processing results in data warehouses so that they do not meet business requirements. The fast and complex evolution of the digital world must be scalable to the data warehouse process, so that the authors implement it in the data warehouse using massive parallel processing (MPP) with the Greenplum database, so that business users can get reports faster and more optimally. This case study explains how the MPP system implements and measures the performance of the Greenplum database by performing complex queries in the data warehouse with parallel processing. Therefore, this case study analyzes whether the use of MPP systems can measure the scalability of throughput and the response time in the data warehouse so that system performance in the Greenplum database remains stable for daily, weekly, and monthly operations.

Creation and Implementation of an Electronic Database and Marking System for Identifying and Obtaining Information on Plant Species in Botanical Gardens, Dendrological Parks and Park Monuments of the Landscape Art

Creation and Implementation of an Electronic Database and Marking System for Identifying and Obtaining Information on Plant Species in Botanical Gardens, Dendrological Parks and Park Monuments of the Landscape Art

USING GEOMATICS FOR ASSESSING VULNERABILITY TO CUTANEOUS LEISHMANISAIS. APPLICATION TO THE WILAYA OF BATNA (ALGERIA)

If the typology of epidemics varies considerably, their causes remain substantially related tomany physical environment factors. The fact remains that the problem of vector-borne diseases is complex in view of the diversity of these diseases, the large number of vulnerabilities associated with them, and also the objective assessment of the impact of each of these factors. The use of geomatic tools, such as geographical information systems (GIS) and remote sensing techniques as spatial environmental phenomena and through the implementation of a GIS database, has enabled us to highlight the spatial distribution of these diseases and their magnitude, and has allowed us to subsequently relate them to some environmental factors that might explain the emergence of the disease and its importance. The results clearly show that approximately 48.89% of the total area of the province was found to be highly vulnerable, 2.83% at moderate vulnerability, while 48.28% of the province had low vulnerability.

La ciudad cerrada y su diversificación como reto del Área Metropolitana de Guadalajara, México

The phenomenon of gated communities has evolved into a dynamic and complex object that has transformed Latin American Cities over the last decades. The Metropolitan Area of Guadalajara, Mexico, is also undergoing a retransformation of this concept. The success” of gated residential areas in Guadalajara has been defined by the inclusion of a new economic strata into this fortified housing scheme. Fifteen percent of the built city are characterized by the modality of limited access due to physical barriers that have caused a fragmentation of this territory. Through the implementation of a geo-referenced database, a spatial analysis of the phenomenon has been accomplished in this Mexican city, showing results that confirm the conceptual modifications that several researchers have identified and that are causing a stratification of this housing model.

Створення та впровадження системи електронної бази даних і маркування для ідентифікації та отримання інформації про види рослин у ботанічних садах, дендрологічних парках та парках-пам’ятках садовопаркового мистецтва

Роботу виконано в рамках науково-технічного проекту «Створення та впровадження системи електронної бази даних і маркування для ідентифікації та отримання інформації по видах рослин у ботанічних садах, дендрологічних парках та парках-пам'ятках садово-паркового мистецтва» (Розпорядження Президії НАН України від 31.03.2016 р. № 197) в 2016 році.

Database design and implementation of CSR functions: a case study of Saudi Arabian banking environment

Efficient organisation of business, small, medium or large, is to combine management concepts with information technology. This is what Business informatics is all about. These days it is unimaginable to have a successful business without the use of information technology. If an organisation wants to achieve business intelligence, there is no way to avoid the use of management information systems. Most medium to large organisations have social and community initiatives and programs as part of their Corporate Social Responsibility (CSR) division. However, its functionality and reach in many organisations lacks use of available technology and systems. As a result, the response to and delivery of community and social services is often slow rendering the services ineffective and times obsolete. Aim of this article is to demonstrate how CSR functions can be designed and implemented as database solutions to make their delivery effective and efficient. Our description CSR is provided mainly in the case of the National Commercial Bank, a well-known and major bank of Saudi Arabia. However the business database solutions are generic and may be applicable in many providers be they banks or other institutions.

The Effect of Prescription Drug Monitoring Programs on Opioid Prescriptions and Heroin Crime Rates

In response to growing abuse of prescription opioid painkillers, 50 U.S. states have implemented electronic prescription drug monitoring programs (PDMPs) that record patients into a state-wide registry when a prescription opioid is received. This paper uses a difference-in-differences regression framework and interactive fixed effects factor models to identify the effect of PDMPs and two related programs on the types and strengths of opioid painkiller prescriptions filled and on rates of heroin crimes. The implementation of PDMP databases caused an 10% decrease in the amount of oxycodone shipments, with results from Medicaid prescription data pointing to larger decreases within high dosage pills. PDMPs have heterogeneous effects on heroin crime incidents across counties depending on the county's pre-policy level of prescription opioid milligrams per capita, with an 49-89% increase in heroin crime within the most opioid-dense counties, depending on model specification.

Querying clinical data in HL7 RIM based relational model with morph-RDB

BackgroundSemantic interoperability is essential when carrying out post-genomic clinical trials where several institutions collaborate, since researchers and developers need to have an integrated view and access to heterogeneous data sources. One possible approach to accommodate this need is to use RDB2RDF systems that provide RDF datasets as the unified view. These RDF datasets may be materialized and stored in a triple store, or transformed into RDF in real time, as virtual RDF data sources. Our previous efforts involved materialized RDF datasets, hence losing data freshness.ResultsIn this paper we present a solution that uses an ontology based on the HL7 v3 Reference Information Model and a set of R2RML mappings that relate this ontology to an underlying relational database implementation, and where morph-RDB is used to expose a virtual, non-materialized SPARQL endpoint over the data.ConclusionsBy applying a set of optimization techniques on the SPARQL-to-SQL query translation algorithm, we can now issue SPARQL queries to the underlying relational data with generally acceptable performance.

Geographic information systems for mapping the National Exam Result of Junior High School in 2014 at West Java Province

National Exam level of schooling is implemented by the Ministry of Education and Culture for the development of education in Indonesia. The national examinations are centrally evaluated by the National Education Standards Agency, and the expected implementation of the national exams can describe the successful implementation of education at the district, municipal, provincial, or national level. In this study, we evaluate, analyze, and explore the implementation of the national exam database of the results of the Junior High School in 2014, with the Junior High School (SMP/MTs) as the smallest unit of analysis at the district level. The method used in this study is a data mining approach using the methodology of Knowledge Discovery in Databases (KDD) using descriptive analysis and spatial mapping of national examinations. The results of the classification of the data mining process to national exams of Junior High School in 2014 using data 6,878 SMP/MTs in West Java showed that 81.01 % were at moderate levels. While the results of the spatial mapping for SMP/MTs in West Java can be explained 36,99 % at the unfavorable level. The evaluation results visualization in graphic is done using ArcGIS to provide position information quality of education in municipal, provincial or national level. The results of this study can be used by management to make decision to improve educational services based on the national exam database in West Java. Keywords: KDD, spatial mapping, national exam.

Recording the LHCb data and software dependencies

In recent years awareness of the importance of preserving the experimental data and scientific software at CERN has been rising. To support this effort, we are presenting a novel approach to structure dependencies of the LHCb data and software to make it more accessible in the long-term future. In this paper, we detail the implementation of a graph database of these dependencies. We list the implications that can be deduced from the graph mining (such as a search for the legacy software), with emphasis on data preservation. Furthermore, we introduce a methodology of recreating the LHCb data, thus supporting reproducible research and data stewardship. Finally, we describe how this information is made available to the users on a web portal that promotes data and analysis preservation and good practise with analysis documentation.

Assessment of Optical Coherence Tomography Color Probability Codes in Myopic Glaucoma Eyes After Applying a Myopic Normative Database

To evaluate the optical coherence tomography (OCT) color probability codes based on a myopic normative database and to investigate whether the implementation of the myopic normative database can improve the OCT diagnostic ability in myopic glaucoma. Comparative validity study. In this study, 305 eyes (154 myopic healthy eyes and 151 myopic glaucoma eyes) were included. A myopic normative database was obtained based on myopic healthy eyes. We evaluated the agreement between OCT color probability codes after applying the built-in and myopic normative databases, respectively. Another 120 eyes (60 myopic healthy eyes and 60 myopic glaucoma eyes) were included and the diagnostic performance of OCT color codes using a myopic normative database was investigated. The mean weighted kappa (Kw) coefficients for quadrant retinal nerve fiber layer (RNFL) thickness, clock-hour RNFL thickness, and ganglion cell-inner plexiform layer (GCIPL) thickness were 0.636, 0.627, and 0.564, respectively. The myopic normative database showed a higher specificity than did the built-in normative database in quadrant RNFL thickness, clock-hour RNFL thickness, and GCIPL thickness (P < .001, P< .001, and P < .001, respectively). The receiver operating characteristic curve values increased when using the myopic normative database in quadrant RNFL thickness, clock-hour RNFL thickness, and GCIPL thickness (P= .011, P= .004, P < .001, respectively). The diagnostic ability of OCT color codes for detection of myopic glaucoma significantly improved after application of the myopic normative database. The implementation of a myopic normative database is needed to allow more precise interpretation of OCT color probability codes when used in myopic eyes.

Scalable Directory Service for IoT Applications

Unprecedentedly, a massive number of devices are getting connected to the network in the new era of the Internet of Things. For the discovery, authentication,, secure access and management of these Internet of Things devices, an Internet of Things directory service is needed. Its responsibility would be to store and provide the attributes of Internet of Things devices, such as identifier, location, owner's name, generated data types, and security parameters. In this article, we present the architectural design of an Internet of Things directory service that is capable of storing a huge number of records and providing functions for their fast lookup (latency of a few milliseconds) and dynamic update (latency of a few seconds), while fully complying with owner-centric security and privacy policies. To demonstrate its feasibility and overall quality, we also discuss the experimental results obtained from a proof-of-concept implementation of the record database and related communication interfaces.

Evaluation of MALDI-TOF mass spectrometry and MALDI BioTyper in comparison to 16S rDNA sequencing for the identification of bacteria isolated from Arctic sea water.

MALDI-TOF Mass Spectrometry in association with the MALDI BioTyper 3.1 software has been evaluated for the identification and classification of 45 Arctic bacteria isolated from Kandalaksha Bay (White Sea, Russia). The high reliability of this method has been already demonstrated, in clinical microbiology, by a number of studies showing high attribution concordance with other credited analyses. Recently, it has been employed also in other branches of microbiology with controversial performance. The phyloproteomic results reported in this study were validated with those obtained by the “gold standard” 16S rDNA analysis. Concordance between the two methods was 100% at the genus level, while at the species level it was 48%. These percentages appeared to be quite high compared with other studies regarding environmental bacteria. However, the performance of MALDI BioTyper changed in relation to the taxonomical group analyzed, reflecting known identification problems related to certain genera. In our case, attribution concordance for Pseudomonas species was rather low (29%), confirming the problematic taxonomy of this genus, whereas that of strains from other genera was quite high (> 60%). Among the isolates tested in this study, two strains (Exiguobacterium oxidotolerans and Pseudomonas costantinii) were misidentified by MALDI BioTyper due to absence of reference spectra in the database. Accordingly, missing spectra were acquired for the database implementation.

Database Implementation and Testing of Dynamic Credit Card Fraud Detection System

Database Implementation and Testing of Dynamic Credit Card Fraud Detection System

The Research on On-Line Car Service Platform for Mobile Internet

With the rapid development of mobile internet technology and mobile intelligent device, the online business service platform has been extensively applied. Meanwhile, due to the increase of private cars, it requires the related sales, maintenance and training promptly and accurately. In this paper, we proposed a novel online car service platform (OCSP) and the corresponding application (APP) based on iOS. The OCSP adopts the iOS system and “Internet+” model, and realizes some online functions, such as the vehicles query, vehicle information management, display, shopping cart, order management, user management, etc. The operation results show that the platform is stable, and the user experience is good and full-featured. Furthermore, this system will adopt the SQLite database and PC server implementation to establish a wider range of people-car interaction platform.

Geospatial Analysis of Earthquake Damage Probability of Water Pipelines Due to Multi-Hazard Failure

The main purpose of this study is to develop a Geospatial Information System (GIS) model with the ability to assess the seismic damage to pipelines 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 pipeline’s damage probability. This model was implemented for main water distribution pipelines of Iran and tested for two different earthquake scenarios. The final damage probability of pipelines was estimated to be about 74% for water distribution pipelines of Mashhad including 40% and 34% for leak and break, respectively. In the next step, the impact of each earthquake input parameter on this model was extracted, and each of the three parameters had a huge impact on changing the results of pipelines’ damage probability. Finally, the dependency of the model in liquefaction susceptibility, landslide susceptibility, vulnerability functions and segment length was checked out and specified that the model is sensitive just to liquefaction susceptibility and vulnerability functions.

Evaluating the accuracy of amplicon-based microbiome computational pipelines on simulated human gut microbial communities

BackgroundMicrobiome studies commonly use 16S rRNA gene amplicon sequencing to characterize microbial communities. Errors introduced at multiple steps in this process can affect the interpretation of the data. Here we evaluate the accuracy of operational taxonomic unit (OTU) generation, taxonomic classification, alpha- and beta-diversity measures for different settings in QIIME, MOTHUR and a pplacer-based classification pipeline, using a novel software package: DECARD.ResultsIn-silico we generated 100 synthetic bacterial communities approximating human stool microbiomes to be used as a gold-standard for evaluating the colligative performance of microbiome analysis software. Our synthetic data closely matched the composition and complexity of actual healthy human stool microbiomes. Genus-level taxonomic classification was correctly done for only 50.4–74.8% of the source organisms. Miscall rates varied from 11.9 to 23.5%. Species-level classification was less successful, (6.9–18.9% correct); miscall rates were comparable to those of genus-level targets (12.5–26.2%). The degree of miscall varied by clade of organism, pipeline and specific settings used. OTU generation accuracy varied by strategy (closed, de novo or subsampling), reference database, algorithm and software implementation. Shannon diversity estimation accuracy correlated generally with OTU-generation accuracy. Beta-diversity estimates with Double Principle Coordinate Analysis (DPCoA) were more robust against errors introduced in processing than Weighted UniFrac. The settings suggested in the tutorials were among the worst performing in all outcomes tested.ConclusionsEven when using the same classification pipeline, the specific OTU-generation strategy, reference database and downstream analysis methods selection can have a dramatic effect on the accuracy of taxonomic classification, and alpha- and beta-diversity estimation. Even minor changes in settings adversely affected the accuracy of the results, bringing them far from the best-observed result. Thus, specific details of how a pipeline is used (including OTU generation strategy, reference sets, clustering algorithm and specific software implementation) should be specified in the methods section of all microbiome studies. Researchers should evaluate their chosen pipeline and settings to confirm it can adequately answer the research question rather than assuming the tutorial or standard-operating-procedure settings will be adequate or optimal.

An efficient algorithm for bulk-loading xBR[formula omitted]-trees

A major part of the interface to a database is made up of the queries that can be addressed to this database and answered (processed) in an efficient way, contributing to the quality of the developed software. Efficiently processed spatial queries constitute a fundamental part of the interface to spatial databases due to the wide area of applications that may address such queries, like geographical information systems (GIS), location-based services, computer visualization, automated mapping, facilities management, etc. Another important capability of the interface to a spatial database is to offer the creation of efficient index structures to speed up spatial query processing. The xBR+-tree is a balanced disk-resident quadtree-based index structure for point data, which is very efficient for processing such queries. Bulk-loading refers to the process of creating an index from scratch, when the dataset to be indexed is available beforehand, instead of creating the index gradually (and more slowly), when the dataset elements are inserted one-by-one. In this paper, we present an algorithm for bulk-loading xBR+-trees for big datasets residing on disk, using a limited amount of main memory. The resulting tree is not only built fast, but exhibits high performance in processing a broad range of spatial queries, where one or two datasets are involved. To justify these characteristics, using real and artificial datasets of various cardinalities, first, we present an experimental comparison of this algorithm vs. a previous version of the same algorithm and STR, a popular algorithm of bulk-loading R-trees, regarding tree creation time and the characteristics of the trees created, and second, we experimentally compare the query efficiency of bulk-loaded xBR+-trees vs. bulk-loaded R-trees, regarding I/O and execution time. Thus, this paper contributes to the implementation of spatial database interfaces and the efficient storage organization for big spatial data management.

Implementation of a Web-Based Electronic Database for Healthcare-Associated Infection Case Reviews

Implementation of a Web-Based Electronic Database for Healthcare-Associated Infection Case Reviews