New Trends in Database and Information Systems: ADBIS 2023 Short Papers, Doctoral Consortium and Workshops: AIDMA, DOING, K-Gals, MADEISD, PeRS, ... in Computer and Information Science, 1850)

This book constitutes the refereed proceedings of the Doctoral Consortium and Workshops on New Trends in Database and Information Systems, ADBIS 2023, held in Barcelona, Spain, during September 4–7, 2023. The 29 full papers, 25 short papers and 7 doctoral consortium included in this book were carefully reviewed and selected from 148. They were organized in topical sections as follows: ADBIS Short Papers: Index Management & Data Reconstruction, ADBIS Short Papers: Query Processing, ADBIS Short Papers: Advanced Querying Techniques, ADBIS Short Papers: Fairness in Data Management, ADBIS Short Papers: Data Science, ADBIS Short Papers: Temporal Graph Management, ADBIS Short Papers: Consistent Data Management, ADBIS Short Papers: Data Integration, ADBIS Short Papers: Data Quality, ADBIS Short Papers: Metadata Management, Contributions from ADBIS 2023 Workshops and Doctoral Consortium, AIDMA: 1st Workshop on Advanced AI Techniques for Data Management, Analytics, DOING: 4th Workshop on Intelligent Data - From Data to Knowledge, K-Gals: 2nd Workshop on Knowledge Graphs Analysis on a Large Scale, MADEISD: 5th Workshop on Modern Approaches in Data Engineering, Information System Design, PeRS: 2nd Workshop on Personalization, Recommender Systems, Doctoral Consortium. Preface Organization Contents Index Management and Data Reconstruction Estimating iSAX Parameters for Efficiency 1 Introduction 2 Preliminaries and Related Work 2.1 Time Series and the SAX Representation 2.2 The iSAX Index 2.3 Using iSAX 2.4 Related Work 3 Overview of iSAX Parameters 4 Evaluating iSAX Performance 4.1 Methodology 4.2 Test Datasets 5 Experimental Evaluation 5.1 Experimenting with iSAX Parameters 5.2 Optimizing iSAX Parameters 6 Conclusions and Future Work References RILCE: Resource Indexing in Large Connected Environments*-10pt 1 Introduction 2 Related Work 3 Definitions and Assumptions 4 Proposed Approach 4.1 Global Index Generation 4.2 Query Execution Illustration 5 Experiments 6 Conclusion and Future Works References Query Processing A Cost-Effective Query Optimizer for Multi-tenant Parallel DBMSs 1 Introduction 2 Related Work 3 Overview of the Extended Query Optimizer 3.1 Architecture Description 3.2 Workload-Aware Execution Plan Selection 3.3 Execution Plans’ Queue Management System 4 Experiments and Discussion 4.1 Experimental Setting 4.2 Results and Discussions 5 Conclusion References Video Situation Monitoring to Improve Quality of Life 1 Introduction 2 Challenges 3 Relevant Work 4 Proposed Framework 5 Query Processing Architecture 6 CQL-VA Query Processing or Graph Analysis 7 Conclusions and Future Work References Remembering the Forgotten: Clustering, Outlier Detection, and Accuracy Tuning in a Postdiction Pipeline 1 Introduction 2 Our Approach: Postdiction Pipeline 3 Experimental Evaluation 3.1 Experimental Setup 3.2 Experiment 1: Cluster and Outlier Detection Impact 3.3 Experiment 2: Optimizing Multi-Column Storage Performance 4 Conclusion References Advanced Querying Techniques Diversification of Top-k Geosocial Queries 1 Introduction 2 Problem Formulation 2.1 Basic Definitions 2.2 Problem Definition 3 Proposed Heuristics 3.1 Fetch and Refine 3.2 Best Neighbour Search 4 Experimental Evaluation 4.1 Data 4.2 Baselines 4.3 Settings 4.4 Evaluation Metrics 4.5 Results 4.6 Discussion 5 Related Work 6 Conclusion References Multi-disciplinary Research: Open Science Data Lake 1 Introduction 2 Related Works 3 OSDL: Functional Architecture 3.1 OSDL: Interoperability 3.2 OSDL: Data Security 4 OSDL: Technical Architecture 5 Evaluation 6 Conclusion References Be High on Emotion: Coping with Emotions and Emotional Intelligence when Querying Data*-1pc 1 Introduction and Motivation 2 Related Work 3 The AUDE Model 3.1 Modeling Emotions 3.2 Modeling Domains 3.3 Modeling Users 3.4 Modeling Actions 3.5 The AUDE Model at Work 4 Conclusions and Open Issues References Fairness in Data Management Exploring Biases for Privacy-Preserving Phonetic Matching 1 Introduction 2 Related Work 3 Methodology 3.1 Problem Formulation 3.2 Phonetic Codes for String Matching 3.3 Protocol Operation 4 Empirical Assessment 4.1 Experimental Setup 4.2 Experimental Results 5 Conclusions References Multi-Objective Fairness in Team Assembly*-1pc 1 Introduction 2 Related Work 3 Motivation 4 Problem Formulation 4.1 Multi-Objective Fairness in Team Assembly 5 Experiments 6 Conclusions References Data Science A Comparative Study of Assessment Metrics for Imbalanced Learning 1 Introduction 2 Problem Definition 3 Assessment Metrics for Imbalance Learning 3.1 Threshold Metrics 3.2 Ranking Metrics 3.3 Probabilistic Metrics 4 Experiments 4.1 Binary Classification 4.2 Multi-class Classification 4.3 Summary 5 Conclusion References A Hybrid GNN Approach for Predicting Node Data for 3D Meshes*-1pc 1 Introduction 2 Related Work 3 Methodology 3.1 Dataset 3.2 Deep Learning Models 4 Results and Discussions 4.1 Results for EDGE and SAGE Model Convolution with Linear Layer 4.2 Time Cost Analysis for the Hybrid Process 5 Conclusion and Future Work References Transformers and Attention Mechanism for Website Classification and Porn Detection*-1pc 1 Introduction 2 Related Work 3 Page-Level Attention-Based Solution for Web Textual Porn Detection 3.1 Data Collection and Preparation 3.2 Classification Methodology 4 Experimental Results 5 Conclusion and Perspectives References Analysing Robustness of Tiny Deep Neural Networks 1 Introduction 2 Related Works 2.1 Adversarial Data and Defences 2.2 Robustness from Architectural Perspective 2.3 Tiny Deep Learning 3 Exploring Robustness 3.1 Baseline Network and Evaluation Metrics 3.2 Experimental Setting 3.3 Exploring Different Width-Multipliers 3.4 Exploring Different Expand-Ratios 3.5 Theoretical and Empirical Lipschitz Constant 4 Conclusion References Temporal Graph Management Semantic Centrality for Temporal Graphs 1 Introduction 2 Related Work 3 Proposition 3.1 Preliminaries 3.2 Centrality Metrics 4 Experimental Evaluation 4.1 Technical Environment 4.2 Datasets 4.3 Experimental Methodology and Results 5 Conclusion and Future Work References A Knowledge Graph for Query-Induced Analyses of Hierarchically Structured Time Series Information 1 Introduction 2 Graph-Based Management of Time Series Knowledge 2.1 Knowledge Graph Construction and Ontology 2.2 Incremental Query-Induced Knowledge Graph Expansion 2.3 Classification of Graph Knowledge and Analysis Methods 3 Knowledge Propagation Example 4 Conclusion and Future Work References Consistent Data Management Eventually-Consistent Replicated Relations and Updatable Views 1 Introduction 2 Technical Background 2.1 CRDT 2.2 CRR 3 Approach Overview 4 Translation of View-Update Delta States 5 Related Work 6 Conclusion References Mining Totally Ordered Sequential Rules to Provide Timely Recommendations*-1pc 1 Introduction 2 Aged LookBackApriori 2.1 Aging Mechanism 3 Recommender System 3.1 Rule Ordering 4 Running Example 5 Conclusions and Future Work References Data Integration Streaming Approach to Schema Profiling 1 Introduction 2 Basic Concepts 3 Real-Time Schema Profiling 3.1 Clustering Schemas with Summaries 3.2 Incremental Schema Profiling 4 Experiments 5 Conclusions References Using ChatGPT for Entity Matching*-1pc 1 Introduction 2 Experimental Setup 3 General Prompt Design 4 In-Context Learning 5 Providing Matching Knowledge 6 Conclusion References CONSchema: Schema Matching with Semantics and Constraints 1 Introduction 2 Related Work 3 CONSchema 3.1 Problem Statement 3.2 Model 4 Experiments 5 Results 5.1 Unseen Partition Evaluation 5.2 Explaining CONSchema Matching Decisions 5.3 CMS Case Study 6 Conclusion References Data Quality Context-Aware Data Quality Management Methodology 1 Introduction 2 Related Work 3 A Context-Aware DQM Methodology 3.1 DQ Planning Phase 3.2 DQ Assessment Phase 3.3 DQ Improvement Phase 4 Case Study 5 Conclusions References Thesaurus-Based Transformation: A Classification Method for Real Dirty Data 1 Introduction 2 The Store Classification Problem 3 Related Work 4 Thesaurus-Based Transformation 5 Experimental Design 6 Results and Discussion 7 Conclusion References Metadata Management Mobile Feature-Oriented Knowledge Base Generation Using Knowledge Graphs 1 Introduction 2 Background 3 Research Method 3.1 Project Vision 3.2 Research Plan 3.3 Sample Study: Multicategory Android Mobile Apps 4 Knowledge Graph Completion 5 Knowledge Generation 5.1 KG Definitions 5.2 Deductive Knowledge: Extracting Features 5.3 Inductive Knowledge: Finding Apps 6 Evaluation 7 Discussion 8 Conclusions References NoSQL Schema Extraction from Temporal Conceptual Model: A Case for Cassandra 1 Introduction 2 Related Work 3 Model Transformation 3.1 Source Metamodel: Temporal UML Class Diagram 3.2 Target Metamodel: Temporal Cassandra Model 3.3 Mapping Rules from Temporal UML Diagrams to Cassandra 4 Experimental Evaluation 5 Conclusion References Contributions from ADBIS 2023 Workshops and Doctoral Consortium Databases and Information Systems: Contributions from ADBIS 2023 Workshops and Doctoral Consortium*-12pt 1 Introduction 2 AIDMA 2023: 1st Workshop on Advanced AI Techniques for Data Management and Analytics 2.1 Description 2.2 Keynote Speaker 2.3 Selected Papers 3 DOING 2023: 4th Workshop on Intelligent Data – From Data to Knowledge 3.1 Description 3.2 Selected Papers 4 K-Gals 2023: 2nd Workshop on Knowledge Graphs Analysis on a Large Scale 4.1 Description 4.2 Selected Papers 5 MADEISD 2023: 5th Workshop on Modern Approaches in Data Engineering and Information System Design 5.1 Description 5.2 Selected Papers 6 PeRS 2023: 2nd Workshop on Personalization and Recommender Systems 6.1 Description 6.2 Selected Papers 6.3 Acknowledgments 7 DC 2023: ADBIS Doctoral Consortium 7.1 Description 7.2 Selected Papers References AIDMA: 1st Workshop on Advanced AI Techniques for Data Management, Analytics Data Exploration Based on Local Attribution Explanation: A Medical Use Case 1 Introduction and Related Work 2 Methods 2.1 Dataset 2.2 Modelling 3 Results 3.1 Raw Data Analysis 3.2 XAI Analysis 4 Discussion and Perspectives References Explainability Based on Feature Importance for Better Comprehension of Machine Learning in Healthcare*-1pc 1 Introduction 2 Related Work 3 Methodology 3.1 Dataset 3.2 Feature Extraction 3.3 ML Model 3.4 Feature Importance (FI) 4 Results 5 Conclusions References An Empirical Study on the Robustness of Active Learning for Biomedical Image Classification Under Model Transfer Scenarios 1 Introduction 2 Active Learning Foundations 2.1 Active Learning Cycle 2.2 Types of Queries 2.3 Query Strategies 3 Experimental Setup 3.1 AL Setup 3.2 Acquisition and Successor Models 3.3 Data Sets 4 Results 5 Discussion 6 Related Work 7 Conclusion References Evaluating the Robustness of ML Models to Out-of-Distribution Data Through Similarity Analysis 1 Introduction 2 Related Work 3 Method 3.1 Sampling Methods 3.2 Environment Parameter Variations 3.3 Similarity Measures 4 Results 4.1 Sampling Method 4.2 Environment Parameter Variations 4.3 Similarity Measures 5 Discussion 6 Conclusions References Holistic Analytics of Sensor Data from Renewable Energy Sources: A Vision Paper 1 Introduction 2 The Envisioned System 3 Related Work 4 Conclusion References DOING: 4th Workshop on Intelligent Data - From Data to Knowledge Labeling Portuguese Man-of-War Posts Collected from Instagram 1 Introduction 2 Related Work 3 Dataset Construction 4 Data Annotation 5 Exploratory and Experimental Study 5.1 Distribution by Label 5.2 Experimental Study 6 Conclusion References Semantic Business Trajectories Modeling and Analysis 1 Introduction 2 Background 2.1 From Business Concepts to Business Trajectories 2.2 From Business Trajectories to Semantic Business Trajectories 3 Semantic Business Trajectories 4 Discussion 5 Conclusion References A Text Mining Pipeline for Mining the Quantum Cascade Laser Properties 1 Introduction 2 Literature Review 3 Methodology 3.1 Document Retrieval and Processing 3.2 Natural Language Processing 3.3 Information Extraction 4 Results and Discussions 4.1 Evaluation Metrics 4.2 Discussions 5 Conclusion References Ensemble Learning Based Quantum Text Classifiers 1 Introduction 2 Related Work 3 Methodology 3.1 Dataset 3.2 Baseline Classifiers 3.3 Comparative Evaluation 4 Ensemble Learning 4.1 Results and Discussion 5 Conclusion References Exploring the Capabilities and Limitations of VQC and QSVC for Sentiment Analysis on Real-World and Synthetic Datasets 1 Introduction 2 Background on Quantum Machine Learning 3 Motivation and Scope of the Study 4 Datasets and Preprocessing 4.1 Real-World Dataset: IMDB Movie Reviews 4.2 Synthetic Dataset: Generated Sentiment Analysis Data 4.3 Data Preprocessing and Encoding for Quantum Classifiers 5 Experimental Setup 6 Results and Discussion 6.1 QSVC Performance on Real-World and Synthetic Datasets 6.2 VQC Performance on Real-World and Synthetic Datasets 7 Comparison Between QSVC's and VQC's Results 8 Conclusion References K-Gals: 2nd Workshop on Knowledge Graphs Analysis on a Large Scale P2KG: Declarative Construction and Quality Evaluation of Knowledge Graph from Polystores*-1pc 1 Introduction 2 Preliminaries 3 Running Example 4 The P2KG Mapping Language and Mapping Rules 4.1 Mapping from Relations 4.2 Mapping from Graph Source 4.3 Mapping from Multiple Sources 5 Constraints 5.1 Source Constraints 5.2 General Rule Constrains 5.3 Constraints from Users 5.4 Evaluation of Constraints 6 Conclusion and Future Work References Using Knowledge Graphs to Model Green Investment Opportunities 1 Introduction 2 Background 3 Describing Investment Opportunities Using Knowledge Graphs 4 Objective 4.1 A Knowledge Graph Representation for Green Investment Opportunities 5 Case Study: Analyzing Green Investments in African Countries Through the AIGreet Knowledge Graph 5.1 The AIGreet Green Investments Dataset 5.2 Degree Distribution Analysis 5.3 Community Detection 6 Future Directions References Knowledge Graphs Embeddings for Link Prediction in the Context of Sustainability*-1pc 1 Introduction 2 Proposed Approach 2.1 Application Context 3 Experiments 3.1 Results Analysis 4 Conclusion References An ArchiMate-Based Thematic Knowledge Graph for Low-Code Software Development Domain 1 Introduction 2 Research Approach 3 Knowledge About Low-Code Development 4 Amalgamating Low-Code Development Knowledge in ArchiMate-Based Knowledge Graph 5 Practical Application of the Proposed Knowledge Graph 6 Conclusion References A Knowledge Graph to Analyze Clinical Patient Data*-1pc 1 Introduction 2 The Proposed Knowledge Graph 3 Implementation and Analysis 4 Conclusion References MADEISD: 5th Workshop on Modern Approaches in Data Engineering, Information System Design Towards Automatic Conceptual Database Design Based on Heterogeneous Source Artifacts*-1pc 1 Introduction 2 Related Work 2.1 (Semi-)automatic CDM Design 2.2 Schema Matching and Integration 3 Motivating Example 4 Approach and Open Issues 5 Implemented Tool 6 Motivating Example with DBomnia 7 Conclusion References Lightweight Aspect-Oriented Software Product Lines with Automated Product Derivation 1 Introduction 2 Software Product Lines and Aspect-Oriented Modularization 3 Establishing a Software Product Line 4 Product Derivation 4.1 Annotating Variation Points 4.2 Product Derivation 5 Discussion 6 Related Work 7 Conclusions and Future Work References Comparison of Selected Neural Network Models Used for Automatic Liver Tumor Segmentation*-1pc 1 Introduction 2 Related Works 2.1 UNet++ 2.2 QUA-net 2.3 Polar Image Transformations 2.4 Vision Transformer 3 Method and Materials 3.1 Data Set 3.2 Data Preprocessing 3.3 Selected Metric 3.4 Training 4 Results and Discussion 4.1 Discussion 5 Future Works References Intelligent Index Tuning Using Reinforcement Learning 1 Introduction 2 Related Work and Contribution 2.1 Smart-IX 2.2 The Case for Automatic Database Administration using Deep Reinforcement Learning 3 Background 3.1 TPC-H 4 Methodology 4.1 Agent and Environment 4.2 Markov Decision Process 4.3 Algorithm 5 Experiments 5.1 Training in Simulated Environment 5.2 Training in Database Environment 5.3 Indexes Configuration Evaluation 6 Discussion 7 Conclusion References Automatic Indexing for MongoDB 1 Introduction 2 Related Work 3 The Indexing Solution 4 Evaluation 4.1 Results: Index Validity Experiment 4.2 Results: Performance Experiment 5 Conclusions References From High-Level Language to Abstract Machine Code: An Interactive Compiler and Emulation Tool for Teaching Structural Operational Semantics*-1pc 1 Introduction 2 Educational Abstract and Virtual Machines 3 Short Overview of Abstract Machine for Operational Semantics 4 An Environment for a Visualization of Abstract Implementation of a Language 4.1 Editor Module 4.2 Compiler Module 4.3 Visualizer Module 4.4 User Experience Using the Tool 5 Conclusion References Decentralised Solutions for Preserving Privacy in Group Recommender Systems 1 Introduction 2 State-of-the Art 2.1 Privacy in Recommender Systems 2.2 Group Recommender Systems 2.3 Decentralisation in Recommender Systems 3 Discussion and Architecture Overview 4 Conclusion References PeRS: 2nd Workshop on Personalization, Recommender Systems A Recommendation System for Personalized Daily Life Services to Promote Frailty Prevention 1 Introduction 2 Background 2.1 Well-Being 2.2 Existing Recommender Systems 3 Proposed Recommender System 3.1 Profile and Service Models 3.2 The Rules Base 4 Recommender Engine 4.1 Personal Characteristics Identification 4.2 Need Identification 4.3 Service Types Identification 4.4 Services Recommendation 5 Use Case 6 Conclusion References Design-Focused Development of a Course Recommender System for Digital Study Planning 1 Introduction 2 Method 3 Requirements 4 Design and Evaluation of the CRS 5 Discussion 6 Conclusion References Systematic Literature Review on Click Through Rate Prediction 1 Introduction 2 Literature Review Process Design and Execution 3 Results 3.1 Datasets 3.2 Type of Data 3.3 Feature Transformation 3.4 Metrics 3.5 Models 4 Summary References Overcoming the Cold-Start Problem in Recommendation Systems with Ontologies and Knowledge Graphs 1 Introduction 2 Background 3 Our Approach 4 Related Work 5 Offline Experiments 6 Discussion 7 Conclusion References Recommender Chatbot as a Tool for Collaborative Business Intelligence in Tourism Domain 1 Introduction 2 Background 3 The State of the Art 4 Methods and Materials 5 Results 6 Conclusion and Discussion References Neural Graph Collaborative Filtering: Analysis of Possibilities on Diverse Datasets*-1pc 1 Introduction 2 Input Data 3 Models and Evaluation Metrics 4 Computational Resources 5 Results 6 Conclusions and Future Work References Performance and Reproducibility of BERT4Rec 1 Introduction 2 Background 2.1 Traditional Recommendation Models 2.2 Transformer-Based Sequential Recommendations Models 2.3 BERT4Rec 3 Experimental Setup 3.1 Datasets Used 3.2 Procedure 3.3 Metrics 4 Results 5 Discussion and Conclusions 6 Future Work References Doctoral Consortium Towards Reliable Machine Learning 1 Introduction 2 Related Work 2.1 Model Explainability 2.2 Data Explainability 3 Methods and Results 3.1 Model Explainability 3.2 Data Explainability 4 Conclusion References Tackling the RecSys Side Effects via Deep Learning Approaches 1 Introduction and Motivation 2 Related Work 2.1 RecSys Influence over Users 2.2 Bias in Recommendations 3 Ongoing Research 3.1 Algorithmic Drift 3.2 Popularity Bias 4 Conclusions and Future Works References Towards a Researcher-in-the-loop Driven Curation Approach for Quantitative and Qualitative Research Methods*-1pc 1 Introduction 2 Background and Related Work 3 Modelling Qualitative Research Phases 4 Researcher-in-the-Loop Driven Curation for Hybrid Research Methods 5 Expected Results and Future Work References Deep Learning Techniques for Television Broadcast Recognition 1 Introduction 2 State of the Art 3 Methodology 3.1 SSIM 3.2 ShotBoundary Detection 4 Experimental Results 4.1 Performance Evaluation Metrics 4.2 Evaluation of the Proposed Methods 5 Conclusion References Process Mining Solutions for Public Administration*-1pc 1 Introduction 2 Research Objectives 3 Related Work 3.1 Artificial Intelligence for Public Administration 3.2 Process Mining in Public Administration 4 Method 4.1 Process Mining Technique 4.2 Process Discovery 5 Future Work 6 Conclusion References Intelligent Technologies for Urban Progress: Exploring the Role of AI and Advanced Telecommunications in Smart City Evolution*-1pc 1 Introduction 2 Smart City 3 AI and Advanced Telecommunications in Smart Cities 3.1 AI in Smart Cities 3.2 Advanced Telecommunications in Smart Cities 4 Future Directions and Research Opportunities 5 Conclusion References Automatic Discovery of Zones of Interests with Maritime Trajectory Mining*-1pc 1 Problem Statement 2 Related Works 3 Proposed Approach References Author Index