Database Systems - Science topic

The rapid evolution of data-intensive applications has intensified the need for efficient and adaptive database systems. Traditional database tuning methods, relying on manual interventions and rule-based optimizations, often fall short in handling dynamic workloads and complex parameter interdependencies. This paper introduces a novel approach to...

This study comprehensively evaluated and compared the nutrient contents, total phenolic content, total flavonoid content, antioxidant activity, and anti-nutritional factors of three passion fruit species, namely purple passion fruit (Passiflora edulis f. edulis), yellow passion fruit ( Passiflora edulis var. flavicarpa), and sweet granadilla fruit...

The increasing prevalence of data breaches and cyberattacks underscores the urgent need for enhanced security and transparency in database management systems (DBMS). This paper explores the integration of blockchain technology into DBMS to address these challenges, leveraging the inherent features of blockchain-decentralization, immutability, and t...

This paper presents an experimental framework for implementing Decentralized Autonomous Database Systems (DADBS) using the Rust programming language. As traditional centralized databases face challenges in scalability, security, and autonomy, DADBS emerge as a promising solution, using blockchain principles to create distributed, self-governing dat...

This paper introduces a novel one-hop sub-query result cache for processing graph read transactions, gR-Txs, in a graph database system. The one-hop navigation is from a vertex using either its in-coming or out-going edges with selection predicates that filter edges and vertices. Its cache entry identifies a unique one-hop sub-query (key) and its r...

This paper discusses the representation of ontologies in the first-order logical environment FOLE (Kent [11]). An ontology defines the primitives with which to model the knowledge resources for a community of discourse (Gruber [7]). These primitives, consisting of classes, relationships and properties, are represented by the entity-relationship-att...

Using cloud Database as a Service (DBaaS) offerings instead of on-premise deployments is increasingly common. Key advantages include improved availability and scalability at a lower cost than on-premise alternatives. In this paper, we describe the design of Taurus, a new multi-tenant cloud database system. Taurus separates the compute and storage l...

Fault-tolerant replicated database systems consume less energy than the compute-intensive proof-of-work blockchain. Thus, they are promising technologies for the building blocks that assemble global financial infrastructure. To facilitate global scaling, clustered replication protocols are essential in orchestrating nodes into clusters based on pro...

Trees provide numerous benefits to humans and other living organisms, making accurate tree species identification essential for their management and conservation. Identifying and describing tree species is also critical for genetic studies, biodiversity conservation, management practices, and regeneration strategies. Traditional methods of tree ide...

Blockchain technology is proving to be a disruptive technology in many areas of supply chain, manufacturing, medical, agriculture, and so on. Warehouses are an inevitable part of the supply chain. Issues like space optimization, route optimization, quick item pick-up, demand forecasting, and transaction management are of importance to address in wa...

In the modern era, information technology in education is becoming increasingly important. This is why creating a desktop-based database learning media application using Microsoft Visual Basic Net 8.0 is a strategic step to improve the efficiency and quality of education. Additional application programs that can be used to design and create learnin...

In the catering sector, document management is often hindered by the presence of unstructured data, which negatively impacts operational efficiency. This research develops a document-based database system for managing contracts and work agreements using MongoDB. The designed schema uses the JSON format to store complex information, and its implemen...

In an era of rapid digital transformation, databases have evolved significantly to meet the growing demands of modern applications. With advancements in cloud computing, big data, and artificial intelligence, today's database landscape is marked by an array of diverse, specialized solutions designed to handle various data models, scalability requir...

In modern database systems, efficient log management is crucial for ensuring data integrity and facilitating swift recovery from potential data corruption or system failures. Traditional log structures, which store operations sequentially as they occur, often lead to significant delays in accessing and recovering specific data objects due to their...

This research paper explores strategies for enhancing database efficiency in complex IT infrastructures, emphasizing the critical importance of database performance for application responsiveness, scalability, resource utilization, user experience, and competitiveness. The study identifies key challenges such as system heterogeneity, growing data v...

This study examines the structure of geothermal geochemisty data in India using k-means and hierarchical cluster analyses. The first attempt to list hot springs in India was made by Schlagintweit in 1852. The Geological Survey of India published a special publication titled 'Geothermal Atlas of India', and the government of India constituted a 'Hot...

3-1) With the increasing demand for large-scale data management and analytics, applications have diverse I/O needs, and various storage devices are being adapted for database systems to meet these specific I/O requirements. For example, traditional Hard Disk Drives (HDDs), known for their cost-efficiency and high capacity, are used to store cold da...

The rapid evolution of cloud technology has given rise to autonomous databases, which leverage artificial intelligence and machine learning to automate management tasks, optimize performance, and ensure robust security. This paper provides a comprehensive benchmarking analysis of three leading autonomous database systems: Oracle Autonomous Database...

Order-preserving encryption (OPE) is a fundamental cryptographic tool for enabling efficient range queries on encrypted data in outsourced databases. Despite its importance, existing OPE schemes face critical limitations that hinder their practicality. Stateful designs require clients to maintain plaintext-to-ciphertext mappings, imposing significa...

Skyline queries are one of the most widely adopted tools for Multi-Criteria Analysis, with applications covering diverse domains, including, e.g., Database Systems, Data Mining, and Decision Making. Skylines indeed offer a useful overview of the most suitable alternatives in a dataset, while discarding all the options that are dominated by (i.e., w...

Selecting indexes capable of reducing the cost of query processing in database systems is a challenging task, especially in large-scale applications. Quantum computing has been investigated with promising results in areas related to database management, such as query optimization, transaction scheduling, and index tuning. Promising results have als...

Database systems have consistently been prime targets for cyber-attacks and threats due to the critical nature of the data they store. Despite the increasing reliance on database management systems, this field continues to face numerous cyber-attacks. Database management systems serve as the foundation of any information system or application. Any...

This study aims to analyze the issues in the evaluation process of history learning, especially in the assessment stage within historiographical practices, specifically the heuristic stage that requires digital technology tools during the source-searching process. Additionally, it seeks to assess the effectiveness of blockchain technology in suppor...

Lung adenocarcinoma (LUAD) is one of the most common malignant tumors. Although several treatments have been proposed, the long-term prognosis of this cancer is poor. Lipid droplets and mitochondria are important organelles that regulate energy metabolism in cells and are postulated to promote the occurrence and progression of tumors. However, few...

This tutorial serves as a comprehensive guide for understanding graph databases, focusing on the fundamentals of graph theory while showcasing practical applications across various fields. It starts by introducing foundational concepts and delves into the structure of graphs through nodes and edges, covering different types such as undirected, dire...

With the exponential growth of data, traditional database management systems (DBMSs) face unprecedented challenges in scalability, performance, and flexibility. This paper surveys key developments in scalable database systems, focusing on their evolution and integration with modern distributed architectures such as MapReduce, HadoopDB, alongside sy...

This study is designed to survey and analyze the data requirements for the Sakaerat Biosphere Reserve's database system. An open questionnaire was used with 423 people in online form and in meetings, including students, university students, teachers, researchers, and ordinary people. The answers from the questionnaire were categorized by keywords a...

Background and Aim: The undergraduate database system principles and applications course grapples with issues such as the gap between theory and practice, outdated content, and limited teaching methods. Addressing these challenges necessitates a comprehensive reform to enhance students' practical skills and adaptability to technological advancement...

The construction industry is experiencing high demand for workers. Apprenticeship programmes are essential pipelines of skilled workers into the construction industry; however, apprenticeship completion rates are only around 25%. To promote apprenticeship retention and increase the number of apprentices, it is necessary to identify factors that rel...

The rise of cyberattacks and evolving artificial intelligence (AI) technologies have introduced new security challenges for traditional database systems used in higher education institutions. While these systems have served as the backbone for managing institutional data for decades, their centralized structure and vulnerability to advanced threats...

The COVID-19 outbreak from China has infected more than 573.8 million people all over the world including more than 6.3 million deaths. In Sri Lanka, there are more than 670,000 cases including 16,770 deaths up to now. Many studies have been conducted on this global epidemic, with a focus on analyzing the spatial and temporal spread of the virus, w...

The publication discusses the issue of the scope of responsibilities of the Online Transaction Processing system administrator (hereinafter referred to as: "OLTP"). The methodological basis used in the work was the qualitative method, the essence of which consisted in the comparison of two systems – the OLTP database system and the information secu...

This paper presents a computer system capable of analyzing the databases of the results of the elections in Mexico, using genetic algorithms to achieve efficient analyses that will serve for the creation of reports with the information generated, in a shorter time than it can take to perform a manual analysis. The developed system implements the Wi...

Background: This chapter gives an analysis of AI methods used in healthcare. The simplification of healthcare database in cloud storage mechanisms and the harsher reality behind it. Methods: To locate all relevant studies, a PubMed literature search was carried out. Additionally, research articles were manually selected from the article reference l...

The f-fault-tolerant connectivity labeling (f-FTC labeling) is a scheme of assigning each vertex and edge with a small-size label such that one can determine the connectivity of two vertices s and t under the presence of at most f faulty edges only from the labels of s, t, and the faulty edges. This paper presents a new deterministic f-FTC labeling...

Data-driven decision-making is integral to modern businesses, relying heavily on Business Intelligence (BI) systems to analyze vast and complex datasets for actionable insights. Traditional BI systems often struggle with high query latency, limited scalability, insufficient predictive capabilities, and inadequate security measures, hindering their...

Many current and upcoming laser facilities used to study high-energy-density (HED) physics and inertial fusion energy (IFE) support operating at high rep-rates (HRRs) of ∼0.1–10 Hz, yet many diagnostics, target-fielding strategies, and data storage methods cannot support this pace of operation. Therefore, established experimental paradigms must cha...

This article is concentrated on the study of use of technology in HR management system in Nepalese organizations. At present most of the most of the corporate organizations of Nepal use different forms of related software for managing human resource in an effective way to bring effectiveness in performance outcomes. They use technology in various H...

Database Management System (DBMS) developers have implemented extensive test suites to test their DBMSs. For example, the SQLite test suites contain over 92 million lines of code. Despite these extensive efforts, test suites are not systematically reused across DBMSs, leading to wasted effort. Integration is challenging, as test suites use various...

Databases are a fundamental element of contemporary software applications. The most widely used and recognized type in practice is the relational database, valued for its ability to store and organize data in tabular structures, its emphasis on data consistency and integrity, and its use of a standardized query language, SQL. However, with the rapi...

This project is an exploratory task on using semantic and AI driven technologies for journalistic purposes in the context of Italian newsrooms. The main research question that the project aims to answer is how could AI tools be used for data management in Italian journalism. Within this scope, the focus will be on knowledge graphs and graph databas...

Objective This study aimed to develop predictive models both for viral suppression and immunological reconstitution using a standard set of reported variables in a nationwide database system (SISCAC) from a cohort of patients living with HIV in Colombia. Materials and Methods We included 2.182 patients with no missing data related to the outcomes o...

This paper talks about the methodologies for selecting the most appropriate database systems tailored to specific application needs, addressing aspects such as scalability, performance, security, and cost-efficiency. As data-driven technologies continue to evolve and become increasingly central to applications across industries, the need for strate...

Deadlocks are considered to be significant problems in distributed systems when two or more processes are struggling for resources that they need to execute their operations. This mini-research aims to examine problems and pitfalls associated with deadlocks in the context of Distributed Systems, including definition, required conditions, and differ...

This paper explores the application of computer technology in biostatistics, focusing on the technological advancements and their impact on data management, data processing and analysis, and data visualization. With the development of computer technology, data storage and management methods have significantly improved, particularly with the introdu...

This review paper explores the optimization of talent management in creative industries through the utilization of advanced database systems. Traditional talent management methods often lack the structure and objectivity provided by modern database-driven approaches, which leverage comprehensive talent profiles, advanced search algorithms, and robu...

The study examined the effect of management information systems on the growth of agro-firms in Anambra State. The objectives were to: determine the effect of decision-making information systems on the Return on Investment (ROI) of agro-businesses in Anambra State, Nigeria, and ascertain the extent to which database management systems affect the ROI...

This study aims to develop an MRPII device that utilizes internet technology for inventory management control processes, using case studies from pharmacutical companies in Indonesia. The research was conducted using field observation methods and system development, then comparing the manual system and MRPII. An internet-based inventory management s...

Large-scale data-intensive applications need massive real-time data processing.Recent hybrid DRAM-PM main memory database systems provide an effective approach by persisting data to persistent memory (PM) in an append-based manner for efficient storage while maintaining the primary database copy in DRAM for high throughput rates.However, they can n...

In database systems the roles of data storage and organization are crucial, for secure and high performing solutions. This research explores two methods of file storage: Basic File and Secure File. The Basic File method offers a way to store data that’s suitable for applications with moderate performance requirements. However, as the volume of data...

In database systems the roles of data storage and organization are crucial, for secure and high performing solutions. This research explores two methods of file storage: Basic File and Secure File. The Basic File method offers a way to store data that's suitable for applications with moderate performance requirements. However, as the volume of data...

This research paper explores the privacy and security threats posed to an Agentic AI system with direct access to database systems. Such access introduces significant risks, including unauthorized retrieval of sensitive information, potential exploitation of system vulnerabilities, and misuse of personal or confidential data. The complexity of AI s...

This course provides students with theoretical knowledge and practical skills on advanced topics in database systems and big data. The main focus of this course is to broaden the students' vision and introduce advanced subjects, including oriented extensions object, relational-object, deductive databases and appropriate query languages, the semi-st...

Large-scale data-intensive applications need massive real-time data processing. Recent hybrid DRAM-PM main memory database systems provide an effective approach by persisting data to persistent memory (PM) in an append-based manner for efficient storage while maintaining the primary database copy in DRAM for high throughput rates. However, they fai...

This comprehensive article explores the critical role of high-availability (HA) database systems in global banking operations, focusing on their impact on continuous service delivery, data integrity, and regulatory compliance. The article examines the challenges faced by financial institutions in maintaining reliable database systems, including the...

Although database systems perform well in data access and manipulation, their relational model hinders data scientists from formulating machine learning algorithms in SQL. Nevertheless, we argue that modern database systems perform well for machine learning algorithms expressed in relational algebra. To overcome the barrier of the relational model,...

This research explores innovative approaches to enhancing the performance of enterprise databases, which are critical for managing extensive data storage, retrieval, and real-time access in large organizations. Addressing current performance challenges such as handling big data, query optimization, hardware constraints, and security, the study exam...

Relational databases have been around for many decades and are the database technology of choice for most traditional data-intensive storage and retrieval applications. Retrievals are usually accomplished using SQL, a declarative query language. Relational database systems are generally efficient unless the data contains many relationships requirin...

Background Healthcare-related adverse events directly impact patient safety. Effective reporting of adverse events and workplace factors affecting the quality and quantity of reporting has been a recent focus. In Nova Scotia, pharmacists have been required to report quality-related events (QREs), errors, and near misses since 2010 through the Canad...

Efficient data storage and retrieval are critical components of modern database systems, directly influencing application performance and user experience. This paper examines the design of data structures and indexing strategies that optimize query performance across various database environments. By exploring fundamental data structures, such as a...

Over the last decades, various cost-based optimizers have been proposed to generate optimal plans for SQL queries. These optimizers are key to achieving good performance in database systems and can speed up query execution. Still, they may need enormous expert efforts and perform poorly on complicated queries. Learning-based optimizers have been sh...

The CDIO (Conceive, Design, Implement, Operate) concept is a teaching methodology aimed at cultivating engineering talent, emphasizing the integration of theoretical knowledge and practical skills, and focusing on the comprehensive development of students' abilities. Traditional teaching methods for the Database System Concepts course have issues s...

Anomaly detection is an important process in many domains like industrial control networks, database systems, system level radiation testing, where the detection of abnormal behaviour indicates a problem such as system failure, intrusion or degradation in performance. With increasing levels of complexity of modern databases, it has become increasin...

OBJECTIVE: Drug-drug interactions (DDIs) occur when one drug alters the effect of another drug. The aim of this study was to evaluate potential drug-drug interactions (pDDIs) associated with the use of systemic antibiotics in hospitalized patients. METHODS: The study included patients over the age of 18 who were hospitalized in our hospital on 12.0...

Indexing has long been used to improve the speed of relational database systems, and choosing an adequate index at design time is critical to the database's efficiency. In this study, it was demonstrated empirically that data access time and data insertion time for moderately large datasets are influenced by the index chosen at design time. However...

One of the most critical challenges in model-driven research area is the automatic generation of the well-known CRUD (Create/Read/Update/Delete) functionalities form models. This work exploits the Model-driven Requirements Engineering (MDRE) approach that relies on requirements modelling to automate the production of a software application. An UML-...

The aim of this meta-analysis was to evaluate the efficacy and safety of robotic pancreaticoduodenectomy (RPD) in improving perioperative aspects and postoperative complications in patients. Methods We searched PubMed, Embase, Web of Science, and the Cochrane Library database systems for studies that compared RPD with laparoscopic pancreaticoduode...

A metodologia Building Information Modelling (BIM) constitui actualmente o principal suporte ao desenvolvimento de projetos integrados e colaborativos no âmbito da indústria da Arquitecturo, Engenharia, Construção e Operações (AECO), tendo vindo a ser implementada em todos os sectores da atividade e a um nível mundial. O presente estudo pretende di...

In the rapidly evolving landscape of database management, maintaining optimal performance and reliability is increasingly challenging due to the growing complexity of database systems and the sheer volume of data transactions. This paper explores the implementation of advanced Artificial Intelligence (AI) and Machine Learning (ML) techniques to enh...

Background Recognizing the limitations of pre-market clinical data, regulatory authorities have embraced total product lifecycle management with post-market surveillance (PMS) data to assess medical device safety and performance. One method of proactive PMS involves the analysis of real-world data (RWD) through retrospective review of electronic he...

The increasing complexity of managing modern database systems, particularly in terms of optimizing query performance for large datasets, presents significant challenges that traditional methods often fail to address. This paper proposes a comprehensive framework for integrating advanced machine learning (ML) models within the architecture of a data...

Introduction Hyponatremia is one of the commonly inquired adverse effects related to Chinese herbal medicine (CHM) received by the Hong Kong Poison Information Center. However, it has never been investigated or reviewed systemically. The purpose of this review is to look into the relationship between CHM and hyponatremia. Method Databases, includi...

Approximate nearest neighbor (ANN) query in high-dimensional Euclidean space is a key operator in database systems. For this query, quantization is a popular family of methods developed for compressing vectors and reducing memory consumption. Recently, a method called RaBitQ achieves the state-of-the-art performance among these methods. It produces...

Penelitian ini bertujuan untuk mengimplementasikan sistem Go-Laundry berbasis web menggunakan metode pengembangan perangkat lunak Waterfall pada YumiLaundry Klari Karawang . Sistem ini dirancang untuk memudahkan pelanggan dalam melakukan pemesanan layanan laundry secara online. Metode Waterfall dipilih karena kejelasan dalam tahapan pengembangan ya...

The integration of Explainable AI (XAI) with distributed databases, enhanced by reinforcement learning (RL) and generative models, offers a novel approach to predictive scaling and query optimization. This study explores how these advanced AI techniques can address the challenges of managing and optimizing distributed database systems. Generative m...

Optimizing query performance in distributed databases is a complex challenge that involves managing vast amounts of data across multiple nodes while ensuring efficient query execution. Recent advancements in Autonomous AI, Reinforcement Learning (RL), and Explainable AI (XAI) offer a promising approach to addressing this challenge. This paper prese...

The authors provide an overview of the process of building a computerised information map database system based on photos of the extensive farm network around Csongrád town, established with the help of the local neighbourhood watch organisations.

RESUMEN: La acelerada producción de datos georreferenciados en la Empresa GEODESA, perteneciente al Grupo Empresarial Geocuba, ha hecho impostergable la necesidad de estructurar dichos datos de manera que se garantice una gestión eficiente de los mismos. En línea con la situación anterior, el presente resultado expone la implementación de una Infra...