Search

Hierarchical count histograms involve the publication of count statistics at various granularities based on a predefined hierarchy within a dimension table in a data warehouse. This task finds extensive applications in on-line analytical processing (OLAP) scenarios. This paper focuses on the rigorous privacy-preserving constraint when dealing with an untrusted server. We conduct a systematic investigation of this task and uncover the limitations of the straightforward baseline approach using local differential privacy, as it fails to strike an optimal balance between privacy and utility. We are thus motivated to propose DP-HORUS, a novel crypto-assisted Differentially Private framework for Hierarchical cOunt histogRams under Untrusted Server. DP-HORUS consists of a series of novel designs, including (1) Encrypted hierarchical tree (EHT) structure, which maintains the concept hierarchy in the input data; (2) Random matrix (RM), which reduces communication and computational cost; (3) To further boosted the utility, we propose DP-HORUS+ encompassing two additional modules of histograms structure (HS) and hierarchical consistency (HC), which are respectively introduced to reduce the noise caused by data sparsity and to ensure the hierarchy consistency; (4) To further boost the robust performance, we propose a series of schemes for workload queries based on DP-HORUS. We provide both theoretical analysis and extensive empirical study on both real-world and synthetic datasets, which demonstrates the superior utility of the proposed methods over the state-of-the-art solutions while ensuring strict privacy guarantee. [ABSTRACT FROM AUTHOR]

A Data Warehouse (DW) is a centralized database that stores large volumes of historical data for analysis and reporting. In a world where enterprise data grows exponentially, new architectures are being investigated to overcome the deficiencies of traditional Database Management Systems (DBMSs), driving a shift towards more modern, cloud-based solutions that provide resources such as distributed processing, columnar storage, and horizontal scalability without the overhead of physical hardware management, i.e., a Database as a Service (DBaaS). Choosing the appropriate class of DBMS is a critical decision for organizations, and there are important differences that impact data volume and query performance (e.g., architecture, data models, and storage) to support analytics in a distributed cloud environment efficiently. In this sense, we carry out an experimental evaluation to analyze the performance of several DBaaS and the impact of data modeling, specifically the usage of a partially normalized Star Schema and a fully denormalized Flat Table Schema, to further comprehend their behavior in different configurations and designs in terms of data schema, storage form, memory availability, and cluster size. The analysis is done in two volumes of data generated by a well-established benchmark, comparing the performance of the DW in terms of average execution time, memory usage, data volume, and loading time. Our results provide guidelines for efficient DW design, showing, for example, that the denormalization of the schema does not guarantee improved performance, as solutions performed differently depending on its architecture. We also show that a Hybrid Processing (HTAP) NewSQL solution can outperform solutions that support only Online Analytical Processing (OLAP) in terms of overall execution time, but that the performance of each query is deeply influenced by its selectivity and by the number of join functions. [ABSTRACT FROM AUTHOR]

The potential of focused beam reflectance measurement (FBRM) and electrical resistance tomography (ERT) was evaluated as on‐line process analytical technologies (PAT) for monitoring powder rehydration. Skim milk powder (SMP) and stage one infant formulas were evaluated. Among all samples, SMP had the greatest conductivity by ERT (P < 0.05), this was confirmed by off‐line methods, that is, SMP had a higher solubility, whereas infant formulas had lower solubility. Particle counts for fines of all samples reached peak values ~450 s. Results demonstrated PAT tools offer capability for rehydration characterisation of dairy and non‐dairy powders. [ABSTRACT FROM AUTHOR]

The growing importance of data analytics is leading to a shift in data management strategy at many companies, moving away from simple data storage towards adopting Online Analytical Processing (OLAP) query analysis. Concurrently, NoSQL databases are gaining ground as the preferred choice for storing and querying analytical data. This article presents a comprehensive, systematic mapping, aiming to consolidate research efforts related to the integration of OLAP with NoSQL databases in Big Data environments. After identifying 1646 initial research studies from scientific digital repositories, a thorough examination of their content resulted in the acceptance of 22 studies. Utilizing the snowballing technique, an additional three studies were selected, culminating in a final corpus of twenty-five relevant articles. This review addresses the growing importance of leveraging NoSQL databases for OLAP query analysis in response to increasing data analytics demands. By identifying the most commonly used NoSQL databases with OLAP, such as column-oriented and document-oriented, prevalent OLAP modeling methods, such as Relational Online Analytical Processing (ROLAP) and Multidimensional Online Analytical Processing (MOLAP), and suggested models for batch and real-time processing, among other results, this research provides a roadmap for organizations navigating the integration of OLAP with NoSQL. Additionally, exploring computational resource requirements and performance benchmarks facilitates informed decision making and promotes advancements in Big Data analytics. The main findings of this review provide valuable insights and updated information regarding the integration of OLAP cubes with NoSQL databases to benefit future research, industry practitioners, and academia alike. This consolidation of research efforts not only promotes innovative solutions but also promises reduced operational costs compared to traditional database systems. [ABSTRACT FROM AUTHOR]

In process analytical chemistry, mass spectrometry analysis using a soft electron ionization (EI) source has qualitative advantages. However, the relatively small ionization cross-section of soft EI leads to lower sensitivity. To address this issue, a novel method has been developed to enhance the sensitivity of soft EI by utilizing a dual electron repeller and an ionization chamber to form a U-shaped electric field, causing electrons to oscillate within the field and effectively increasing the electron collision cross-sectional area. By combining with an electron lens, the virtual cathode effect at low electron energy can be reduced or even eliminated, thereby improving ionization efficiency. This method has resulted in a significant increase in signal intensity for m/z 18(H2O), with a factor of 4.2 at an electron energy of 25 eV and a factor of 3.75 at 20 eV, compared to the electron receiving mode. Additionally, it reduces the required emission current, which is beneficial for prolonging the life of the filament. The proposed technique is expected to expand the application of soft EI, particularly for rapid online analysis in process analytical chemistry such as catalyst research and chemical reaction process monitoring. [ABSTRACT FROM AUTHOR]

The Earth Observation (EO) analytics are moving from local systems to online cloud computing platforms such as Google Earth Engine (GEE) and Open Geospatial Engine (OGE). A typical approach in existing efforts is to leverage geospatial data cubes with cloud computing to support large-scale big EO data analytics in Digital Earth systems. While online analytical processing (OLAP) can be enabled using the cube approach, it is still not clear how geospatial artificial intelligence (GeoAI) can be incorporated in data cubes to benefit the cube infrastructure. Such an investigation can consolidate the vision of an AI-ready SDI (Spatial Data Infrastructure). The paper presents a systematic approach to incorporate GeoAI models into geospatial data cubes to help create an AI Cube. It covers on-demand model retrieval, cube data and model integration, and distributed model inference. The approach is demonstrated in OGE, which is an EO cloud computing platform layered on the GeoCube implementation. The results show that such an AI Cube enriches a cube infrastructure with GeoAI capabilities, facilitates the on-demand coupling of cube data and GeoAI models, and improves the performance of GeoAI inference. [ABSTRACT FROM AUTHOR]

Query-time Exploratory Data Analysis (qEDA) is an increasingly demanding aspect of the data analysis process that entails visually and quantitatively summarizing, comprehending, and interpreting the primary characteristics of a dataset. Nowadays, an imperative procedure is popular in relational databases for EDA because it enables us to write multiple dependent declarative queries with imperative logic. As online analytical processing (OLAP) systems contain extremely large datasets, data scientists often need quick visualizations of data, using approximate processing of imperative procedures, before analyzing them in their entirety. We identify gaps in the existing techniques, in that they are unable to sample both declarative-dependent statements and control logic at the same time and perform multi-dependent sampling-based approximate processing within the permitted time in qEDA. Traditional approximate query processing (AQP) involves tuple sampling for a single query approximation and enables queries to be executed over arbitrary random samples of tables. However, available AQP methods cannot produce a further representative sample of the data distribution for the dependent statements to estimate accurately and quickly for multiple dependent statements. On the other hand, sampling control structures, like loops and conditional statements, are discussed separately, without regard to the imperative structure of statements in a procedure. In this study, we propose Forester, a novel agile approximate processing method for imperative procedures that performs imperative program-aware sampling, which includes both statements with control regions (i.e., branch and loop) and processes them approximately within the permitted time in qEDA. Our method produces more targeted samples for each relation, while maintaining the data and control flow of dependent queries and imperative logic and determining all the conditions for a relation across all the statements in the sample that guarantee the existence of relevant data for dependent data distribution. Utilizing a workload of multi-statement imperative procedures from the Transaction Processing Performance Council Decision Support (TPC-DS) database, our experiment demonstrates that Forester outperforms the existing system in sampling, producing minimum error, and improving response time. [ABSTRACT FROM AUTHOR]

The main objective of this article is to implement business intelligence (BI) technology to improve incident management in the control center of a security company; making use of the Ralph Kimball method for the development of the data mart, contemplating the phases: planning of projects, definition of requirements, design of technological architecture, performing a dimensional modeling a star with 9 dimensions and 1 table made, also used the structured query language (MySQL) database, extract, transform, and load (ETL). Development the pentaho data integration, which allowed the migration, transformation and cleaning of the data from the online transaction processing (OLTP) and online analytical processing (OLAP) database, obtaining as a result that the BI managed to increase the level of the service by 28.42% and reducing the frequency index by 25%. [ABSTRACT FROM AUTHOR]

Continuous manufacturing is becoming increasingly important in the (bio-)pharmaceutical industry, as more product can be produced in less time and at lower costs. In this context, there is a need for powerful continuous analytical tools. Many established off-line analytical methods, such as mass spectrometry (MS), are hardly considered for process analytical technology (PAT) applications in biopharmaceutical processes, as they are limited to at-line analysis due to the required sample preparation and the associated complexity, although they would provide a suitable technique for the assessment of a wide range of quality attributes. In this study, we investigated the applicability of a recently developed micro simulated moving bed chromatography system (µSMB) for continuous on-line sample preparation for MS. As a test case, we demonstrate the continuous on-line MS measurement of a protein solution (myoglobin) containing Tris buffer, which interferes with ESI-MS measurements, by continuously exchanging this buffer with a volatile ammonium acetate buffer suitable for MS measurements. The integration of the µSMB significantly increases MS sensitivity by removing over 98% of the buffer substances. Thus, this study demonstrates the feasibility of on-line µSMB-MS, providing a versatile PAT tool by combining the detection power of MS for various product attributes with all the advantages of continuous on-line analytics. [ABSTRACT FROM AUTHOR]

The health and societal impacts of COVID-19 have created tremendous interest in the scientific community, resulting in interdisciplinary research teams that combine their expertise to provide new insights into the epidemic. However, spatial computation, exploratory data analysis, and spatial data exploration tools have yet to be integrated into these dashboards. We present a Spatial Online Analytical Platform that integrates spatial analysis tools that enable users to explore and learn more about spatial patterns of COVID-19. We present three interaction classes to support users needs. Our first class allows users to apply userdefined data classifications and custom map color choices. The second class applies a risk index across the time series, informing users of the recent temporal trends. The third class allows users to hypothesize about the presence of spatial clusters and receive results on demand. Our SOLAP platform supports the data analysis and exploration needs of big spatial-temporal data. [ABSTRACT FROM AUTHOR]

Due to the amount of data emerging, it is necessary to use an online analytical processing (OLAP) framework capable of responding to the needs of industries. Processes such as drill-down, roll-up, three-dimensional analysis, and data filtering are fundamental for the perception of information. This article demonstrates the OLAP framework developed as a valuable and effective solution in decision making. To develop an OLAP framework, it was necessary to create the extract, transform and load the (ETL) process, build a data warehouse, and develop the OLAP via cube.js. Finally, it was essential to design a solution that adds more value to the organizations and presents several characteristics to support the entire data analysis process. A backend API (application programming interface) to route the data via MySQL was required, as well as a frontend and a data visualization layer. The OLAP framework was developed for the ioCity project. However, its great advantage is its versatility, which allows any industry to use it in its system. One ETL process, one data warehouse, one OLAP model, six indicators, and one OLAP framework were developed (with one frontend and one API backend). In conclusion, this article demonstrates the importance of a modular, adaptable, and scalable tool in the data analysis process and in supporting decision making. [ABSTRACT FROM AUTHOR]

The editorial in the International Journal of Dairy Technology highlights recent studies by Chinese researchers on testing dairy products for safety, new product development, and future industry trends in China. Starting in January 2025, the journal will introduce structured abstracts and continuous publication, replacing the Early View workflow. Free format submissions will also be offered to simplify the submission process. Additionally, the Editor's Choice Article for November 2024 discusses the rehydration characteristics of dairy and infant formula powders, emphasizing the importance of monitoring powder rehydration for product quality. [Extracted from the article]

Updating the most recent set of point cloud data is critical in autonomous driving environments. However, existing systems for point cloud data management often fail to ensure real-time updates or encounter situations in which data cannot be effectively refreshed. To address these challenges, this study proposes a distributed hybrid transactional/analytical processing architecture designed for the efficient management and real-time processing of point cloud data. The proposed architecture leverages both columnar and row-based tables, enabling it to handle the substantial workloads associated with its hybrid architecture. The construction of this architecture as a distributed database cluster ensures real-time online analytical process query performance through query parallelization. A dissimilarity analysis algorithm for point cloud data, built by utilizing the capabilities of the spatial database, updates the point cloud data for the relevant area whenever the online analytical process query results indicate high dissimilarity. This research contributes to ensuring real-time hybrid transactional/analytical processing workload processing in dynamic road environments, helping autonomous vehicles generate safe, optimized routes. [ABSTRACT FROM AUTHOR]

Information Technology (IT) and its advancements change the education environment. Conventional classroom education has been transformed into a modernized form. Education field decision-makers are always searching for new technologies that provide fast solutions to support Education Decision Support Systems (EDSS). There is a significant need for an effective decision support system to utilize student data which helps the university in making the right decisions. The Electronic learning system (e-learning) provides a live forum for faculties and students to connect with learning portals and virtually execute educational activities. Even though these modern approaches support the education system, active student participation still needs to be improved. Moreover, accurately measuring student performance using collected attributes remains difficult for parents and teachers. Therefore, this paper seeks to understand and predict student performance using effective data processing and a deep learning-based decision model. The implementation of EDSS starts with data preprocessing, Extraction-Transformation-Load (ETL), a data mart area to store the extracted data with Online Analytical Processing (OLAP) processing, and decision-making using Deep Graph Convolutional Neural Network (DGCNN). The statistical evaluation is based on the student dataset from the Kaggle repository. The analyzed results depict that the proposed EDSS model on an independent data mart with efficient decision support and OLAP provides a better platform to make academic decisions and help educators to make necessary decisions notified to the students. [ABSTRACT FROM AUTHOR]

The study purpose is to investigate the impact of Business Intelligence within its domains "Data Warehouse, Data Mining, Online Analytical Processing, Report Preparation" in the effectiveness of decision making within it domains "Proper timing of decision making, Ease of implementing the decision, and Accepting the decision from the concerned employee" at the Islamic International Arab Bank. To achieve the aim of the study, the quantitative descriptive approach was adopted, by comprehensive sampling to collect data. The questionnaire was administrated manually consisting of (28) items on the sample; which consisted of high management mangers totaling (50) managers, all questionnaires were valid for analysis. A set of statistical methods were used to analyze the data, including the mean and simple and multiple regression coefficient through the statistical analysis program (SPSS). Based on the statistical analysis, several findings were concluded, the most important are: - "The levels of importance for each of the two domains of Business Intelligence, and the Effectiveness of Decision Making in their domains, in the International Arab Islamic Bank were high for all domains." - "There is a significant statistical effect of Business Intelligence on the Effectiveness of Decision Making at the International Arab Islamic Bank. Based on the findings, the study presented several recommendations, those are: - Increasing interest in Business Intelligence in all its domains at the Islamic International Arab Bank; since it has an impact on achieving competitive advantage, through interest in strengthening the infrastructure; and using the best technology; so that Business Intelligence is at the highest level at the bank since there is a large number of competitors in the banking sector. - Enhancing interest in the Effectiveness of Decision Making, because of the sensitivity of decision making, the proper timing for implementing the decision, the ease of implementing the decision, and the acceptance of the concerned employee help to strengthen trust between the decision makers and those affected by the decision, through the participation of subordinates in decisions making through brainstorming sessions; and processes. Persuasion and activating dialogue in the bank to improve transparency. [ABSTRACT FROM AUTHOR]

In order to effectively extract the multi-dimensional data of teaching quality evaluation and accurately evaluate the quality of network distance teaching quality in universities, an optimal classification algorithm for network distance teaching quality evaluation is proposed. From the perspectives of teaching attitude, teaching skill, teaching skill, teaching content, teaching method and means, the quality evaluation indices of network distance teaching is designed. Combined with the evaluation indices, the multi-dimensional data mining method based on OLAP technology is used to mine the required multi-dimensional data of teaching quality evaluation in the distance teaching data warehouse of universities, the required multi-dimensional data is input into SVM algorithm to solve the optimal classification hyperplane of multi-dimensional data and implement the optimal classification of multi-dimensional data. The quality of distance teaching is evaluated by improving the salp group algorithm and setting the penalty factor and kernel function of SVM algorithm. The experimental results show that the classification accuracy of this method for multidimensional data is over 90%, and the evaluation accuracy is as high as 99%, it can extract multi-dimensional teaching quality evaluation from the network distance teaching data, which has good classification effect and can improve the accuracy of network distance teaching quality evaluation. [ABSTRACT FROM AUTHOR]

The work presented in this paper focuses on the modeling and implementation of business intelligence processes, specifically how to apply model-driven architecture (MDA) throughout the entire development process of a data warehouse to automatically generate the multidimensional schema. As a result, this work specifies different rules for automating the process of obtaining an online analytical processing (OLAP) cube and implementing it using a collection of metamodels and automatic transformations. The data warehouse relational and OLAP cube models are then created using a model transformation from the conceptual model (class diagram). Finally, the XML file and SQL code are generated for creating the OLAP cubes and relational data warehouse, respectively. Using transformation languages like query-view-transformation (QVT) and Acceleo, all model transformations are performed. [ABSTRACT FROM AUTHOR]

The automation of traditional Chinese medicine (TCM) pharmaceuticals has driven the development of process analysis from offline to online. Most of common online process analytical technologies are based on spectroscopy, making the identification and quantification of specific ingredients still a challenge. Herein, we developed a quality control (QC) system for monitoring TCM pharmaceuticals based on paper spray ionization miniature mass spectrometry (mini-MS). It enabled real-time online qualitative and quantitative detection of target ingredients in herbal extracts using mini-MS without chromatographic separation for the first time. Dynamic changes of alkaloids in Aconiti Lateralis Radix Praeparata (Fuzi) during decoction were used as examples, and the scientific principle of Fuzi compatibility was also investigated. Finally, the system was verified to work stably at the hourly level for pilot-scale extraction. This mini-MS based online analytical system is expected to be further developed for QC applications in a wider range of pharmaceutical processes. [Display omitted] • The PSI-mini-MS has been developed as a PAT for online quality monitoring of TCM pharmaceuticals. • PSI-mini-MS allows real-time monitoring of TCM pharmaceutical processes without LC separation. • PSI-mini-MS enables identification and quantification of target ingredients in TCM extracts. • Changes of Fuzi alkaloids during decoction monitored by PSI-mini-MS were used as examples. • The scientific principle of Fuzi compatibility was demonstrated by PSI-mini-MS online analysis. [ABSTRACT FROM AUTHOR]

In order to effectively obtain the electric power emergency command plan and reasonably dispatch emergency resources, the electric power emergency command system architecture based on association rule algorithm is designed according to the modularization idea. In the hardware part, the sensing layer is used to collect operation data, and the service layer is used to analyze and mine the data. The tool layer establishes the basic component library and the power industry component library. The network layer transmits relevant information to the application layer. The application layer realizes the three-dimensional simulation and visual operation of power emergency command such as resource scheduling and fault repair by calling the tool set. In the software part, the association rule algorithm combined with online analytical processing technology is used to mine the effective data in the collected data set to realize the analysis and processing of emergency command related work. Experiments show that the system can effectively command the output of the generator and obtain higher transmission margin when the fault occurs. And reasonably and evenly dispatch emergency resources to avoid resource waste. [ABSTRACT FROM AUTHOR]

The exponential growth of business data coming from heterogeneous sources imposes the use of new generations of database management systems and new data storage architectures. The major players in the big data market have turned to NoSQL (Not only SQL) technology, which provides a flexible data model and high scalability. In this paper, we investigate OLAP (Online Analytical Processing) implementation using columnar databases (a type of NoSQL system). We provide a set of formal transformation rules in order to map the multidimensional conceptual model to a target model that is suitable for the column-oriented model. Then, we propose two OLAP cube operators called MRC-Cube and SC-Cube, which allow to build the OLAP cube using the MapReduce paradigm and Spark respectively. We conduct an experimental comparison of their performance to analogous relational implementation using Oracle OLAP, we focus particularly on read latency metric under different experimental configurations. The obtained results show a clear difference when performing the OLAP cube building between the relational implementation and the columnar one. [ABSTRACT FROM AUTHOR]

In our article, we present the structure of a process-oriented data warehouse created according to the OLAP (online analytical processing) principle that enables simple process controlling in crop production with 1 hectare process cost and time. To identify the sequence of operations and parallelism of the processes, we used interval ranking theory, which was implemented in the Power Query M formula language. The data available at the right time and in the right way and the economic calculations that can be produced from them, as well as the presentation of the produced information to managers, are crucial in the decision-making process for the organizations. Wide range of digital solutions has an important role to support the business activities and the decision making in the case of farm management as well. It is important to determine the structure of the data required to base the economic calculations, build a data model and create a multidimensional database, this lays the foundation for the calculation of economic and financial indicators, which can help in making economic decisions. [ABSTRACT FROM AUTHOR]

The development of cloud technologies enables companies to actively implement technologies for cost management and risk reduction in their financial and economic activities. The use of cloud-based models of risk management in the financial and economic activities of the enterprise will help small and medium-sized companies in the agro-industrial sector in Russia to make structural and strategic changes, as well as discover new opportunities for business expansion. The purpose of the study is to develop models for cost management and reduction of risks in the financial and economic activities of companies based on the OLAP technology for application in Russian agro-industrial enterprises. The study employs a qualitative approach based on the case study methodology. The paper discloses and substantiates the authors' conceptual model of a cost management system that allows executives to make decisions proceeding from four types of cost prices. The distinguishing feature of the management system is the use of a digital twin, which makes it possible to manage risks at the early stages of decision-making. The application of OLAP systems improves the quality of analysis and visualization methods as part of the cost management system. In addition, the study provides practical insight into how the applied model will help small and medium-sized agro-industrial enterprises to develop different business vision strategies based on cost reduction, manage the level of risk at the early stages of decision-making, and analyze information from a geographically dispersed logistics chain of divisions (production facilities, warehouses, stores). [ABSTRACT FROM AUTHOR]

Business Intelligence is the key technology for users to effectively extract valuable information from oceans of data for decision-making. Data warehouses and on-line analytical processing systems have therefore been developed to contribute effectively to the decision-making process. To extract information that is useful to decision-making, decision-makers express their needs in natural language. Such requirements may be formulated in natural language interfaces in free syntax, avoiding unfamiliar language (SQL, MDX). Natural Language queries can stand for WH-questions ("What, Who, Where, Why, etc.") or a set of Keywords. In this paper, we emphasize on the "Why-Question". This type of question provides answers that help in the diagnosis analysis of the data Warehouse. To deal with a Why-Question, we propose a model that mainly captures the components that reflect the multidimensional aspect of the Data Warehouse. When a decision-maker formulates his Why-Question in natural language, he uses his own terms. This decisional need can be not precise because the decision-maker is not always aware of the Data Warehouse's lexicon as well as the Why-Question's model. Consequently, the decision-maker must reformulate his initial question. Otherwise, the Why-Question's answering process will not be triggered. This situation is not obvious for a decision-maker, especially when the reformulation of the question becomes iterative. To handle these issues, we lean towards a Why-Question's recommendation approach based on both the Data Warehouse's content and the decision maker's requirement. This proposal aims to recommend to the decision-maker a set of natural language Why-Questions instead of rephrasing his initial question. To guide the recommendation process, we rely on a grammar that formalizes the Why-Question's model. To validate our approach, a tool called "WQ-Recommender" is developed. An experimental study is presented to evaluate the relevance of the proposal. [ABSTRACT FROM AUTHOR]

Data warehousing gives frameworks and means for enterprise administrators to methodically prepare, comprehend, and utilize the data to improve strategic decision-making skills. One of the principal challenges to data warehouse designers is fragmentation. Currently, several fragmentation approaches for data warehouses have been developed since this technique can decrease the OLAP (online analytical processing) query response time and it provides considerable benefits in table loading and maintenance tasks. In this paper, a horizontal fragmentation method, called FTree, that uses decision trees to fragment data warehouses is presented to take advantage of the effectiveness that this technique provides in classification. FTree determines the OLAP queries with major relevance, evaluates the predicates found in the workload, and according to this, builds the decision tree to select the horizontal fragmentation scheme. To verify that the design is correct, the SSB (star schema benchmark) was used in the first instance; later, a tourist data warehouse was built, and the fragmentation method was tested on it. The results of the experiments proved the efficacy of the method. [ABSTRACT FROM AUTHOR]

Data management and analysis are challenging with big Earth observation (EO) data. Expanding upon the rising promises of data cubes for analysis-ready big EO data, we propose a new geospatial infrastructure layered over a data cube to facilitate big EO data management and analysis. Compared to previous work on data cubes, the proposed infrastructure, GeoCube, extends the capacity of data cubes to multi-source big vector and raster data. GeoCube is developed in terms of three major efforts: formalize cube dimensions for multi-source geospatial data, process geospatial data query along these dimensions, and organize cube data for high-performance geoprocessing. This strategy improves EO data cube management and keeps connections with the business intelligence cube, which provides supplementary information for EO data cube processing. The paper highlights the major efforts and key research contributions to online analytical processing for dimension formalization, distributed cube objects for tiles, and artificial intelligence enabled prediction of computational intensity for data cube processing. Case studies with data from Landsat, Gaofen, and OpenStreetMap demonstrate the capabilities and applicability of the proposed infrastructure. [ABSTRACT FROM AUTHOR]

This paper proposes Read-Safe Snapshots (RSS), a concurrency control method that ensures reading the latest serializable version on multiversion concurrency control (MVCC) for read-only transactions without creating any serializability anomaly, thereby enhancing the transaction processing throughput under mixed workloads of online transactional processing (OLTP) and online analytical processing (OLAP). Ensuring serializability for data consistency between OLTP and OLAP is vital to prevent OLAP from obtaining nonserializable results. Existing serializability methods achieve this consistency by making OLTP or OLAP transactions aborts or waits, but these can lead to throughput degradation when implemented for large read sets in read-only OLAP transactions under mixed workloads of the recent real-time analysis applications. To deal with this problem, we present an RSS construction algorithm that does not affect the conventional OLTP performance and simultaneously avoids producing additional aborts and waits. Moreover, the RSS construction method can be easily applied to the read-only replica of a multinode system as well as a single-node system because no validation for serializability is required. Our experimental findings showed that RSS could prevent read-only OLAP transactions from creating anomaly cycles under a multinode environment of master-copy replication, which led to the achievement of serializability with the low overhead of about 15% compared to baseline OLTP/OLAP throughputs under snapshot isolation (SI). The OLTP throughput under our proposed method in a mixed OLTP/OLAP workload was about 45% better than SafeSnapshots, a serializable snapshot isolation (SSI) equipped with a read-only optimization method, and did not degrade the OLAP throughput. [ABSTRACT FROM AUTHOR]

Absenteeism and early school leaving (ESL) constitute two main problems in education with a significant impact on adolescents' life. Early leavers from education and training may face considerable difficulties in the labor market later as adults. Motivated by the necessity of minimizing this phenomenon, we developed a novel application that uses big data, generated from a student attendance management system in a vocational senior high school in Greece. This application first automatically conducts data preprocessing and data transformation and saves the processed data on a cloud data warehouse. Then, an online analytical processing (OLAP) analysis is performed, resulting in a real-time visualization that provides a variety of different graphs. In this study, we demonstrate the need for real-time visualization of the analyzed data. Such a type of presentation provides information on the spot regarding potential early leavers' behavior, helping school administrators gain time for prompt and effective actions. Through the data processing and analysis, the application provides instructors with constant information, in addition to those acquired by the formal student attendance management systems. Our research provides indicative evidence in favor of the use of such applications, as by adequately reacting to the observed patterns in real-time, we observed a significant decrease in students' unnecessary absences and a reduction of the ELS phenomenon in a three-year school period. [ABSTRACT FROM AUTHOR]

Nowadays data analytics OLAP (online Analytical Processing) is mostly accepted domain of current researchers and the concept of data mining serves better for the same. There are so many data mining methodologies defined for data analytics. Mining Association rule is widely used in data mining methods for data categorization. Apriori Algorithm is popular method for defining n-element. Frequent item set form k number of huge transactional data set online transaction processing (OLTP) using Association Mining rule (AMR). In this paper, researchers executed original Apriori on transactional data set containing 35039 number of transactions, divided into three data sets DS-1 to DS-3 with 20039, 12000, 5000 number of transactions with variable length with minimum support of 30%, 60% and 80% respectively. Researchers carried out experimental work and compared results of Apriori Algorithm with our proposed algorithm (enhanced version of Apriori algorithm) on the same perimeter and state improvement with 11%, 30% and 27% of Rate of Improvements in DS-1 to Ds-3 respectively for 30% minimum support. Our proposed algorithm is working far much better then Apriori algorithm at each parameter which was included to conclude the results. [ABSTRACT FROM AUTHOR]

Senior management in tertiary institutions desires an efficient system that could help them assess and evaluate learning outcomes so that effective policies can be implemented to enhance teaching and learning. This gets intensified as broader issues arise and higher expectations are put on tertiary education—build a creative workforce and adapt to new technologies to analyze the large volume of teaching and learning data. Government and higher education policymakers have to rapidly adjust relevant policies to surmount the challenges from the pandemic and also to keep up with technological advancement. This demands a novel and efficient way for policymakers and senior management to see and gain insights from a large volume of data (e.g., student course and teacher evaluation). In this study, the researchers present such a system through various examples. The findings generated from this study contribute to the scholarship, and they provide a solution to senior management in tertiary institutions wanting to implement effective policies efficiently. The use of online analytical processing, virtual campus, online, and machine learning in education is growing. However, the use of these technology-enhanced approaches is rare in performing arts education. There has been no in-depth study, especially on technology-enhanced learning that leads to the improvement of teaching. This study utilizes a multi-dimensional analysis approach on the course student evaluation, a key aspect of the teaching and learning quality assurance for higher education. A novel analytical framework is developed and implemented at a leading performing arts university in Asia. It analyzes the course evaluation data of all courses (669 courses and 2664 responses) in the academic year 2018/2019 to make evidence-based recommendations. Such a framework provides an easy and effective visualization for senior management to identify courses that need closer scrutiny to ascertain whether and what areas of course enhancement measures are warranted. [ABSTRACT FROM AUTHOR]

Due to unstructured and large amounts of data, relational databases are no longer suitable for data management. As a result, new databases known as NOSQL have been introduced. The issue is that such a database is difficult to analyze. Online analytical processing (OLAP) is the foundational technology for data analysis in business intelligence. Because these technologies were designed primarily for relational database systems, performing OLAP in NOSQL is difficult. We present a model for extracting OLAP cubes from a document-oriented NOSQL database in this article. A scalable Naïve Bayes classifier method was used for this purpose. The proposed solution is divided into three stages of preparation, Naïve Bayes, and NBMR. Our proposed algorithm, NBMR, is based on the Naïve Bayes classifier (NBC) and the MapReduce (MR) programming model. Each NOSQL database document with nearly the same attribute will belong to the same class, and as a result, OLAP cubes can be used to perform data analysis. Because the proposed model allows for distributed and parallel Naïve Bayes Classifier computing, it is appropriate and suitable for large-scale data sets. Our proposed model is a proper and efficient approach when considering the speed and reduced the number of required comparisons. [ABSTRACT FROM AUTHOR]

Nowadays, with the rise of sensor technology, the amount of spatial and temporal data is increasing day by day. Modeling data in a structured way and performing effective and efficient complex queries has become more essential than ever. Online analytical processing (OLAP), developed for this purpose, provides appropriate data structures and supports querying multidimensional numeric and alphanumeric data. However, uncertainty and fuzziness are inherent in the data in many complex database applications, especially in spatiotemporal database applications. Therefore, there is always a need to support flexible queries and analyses on uncertain and fuzzy data, due to the nature of the data in these complex spatiotemporal applications. FSOLAP is a new framework based on fuzzy logic technologies and spatial online analytical processing (SOLAP). In this study, we use crisp measures as input for this framework, apply fuzzy operations to obtain the membership functions and fuzzy classes, and then generate fuzzy association rules. Therefore, FSOLAP does not need to use predefined sets of fuzzy inputs. This paper presents the method used to model the FSOLAP and manage various types of complex and fuzzy spatiotemporal queries using the FSOLAP framework. In this context, we describe how to handle non-spatial and fuzzy spatial queries, as well as spatiotemporal fuzzy query types. Additionally, while FSOLAP primarily includes historical data and associated queries and analyses, we also describe how to handle predictive fuzzy spatiotemporal queries, which typically require an inference mechanism. [ABSTRACT FROM AUTHOR]

The article is devoted to the description of the method of multidimensional database, which is an effective method of data storage, which allows analyzing data qualitatively, and most importantly in a short time. The article discusses the capabilities of multidimensional databases, in particular, multidimensional OLAP (On-Line Analytical Processing) cubes when analyzing large amounts of data. Provides an overview and features of a multidimensional database and discusses the steps you need to take with a multidimensional database to understand the structure and capabilities of an OLAP cube. To create a knowledge base, it describes the steps you can take to create and execute a multidimensional database that you can collect from various sources, save to a database, and then prepare a report using OLAP analysis. Various information system data processing technologies such as OLTP and OLAP were considered. The algorithm of the data storage process for analysis purposes was studied. A model of a multidimensional database in the form of a three-dimensional cube was presented. Examples of analysis and ways of obtaining information from the data cube were also given. The use of a multidimensional database in higher education institutions as a simple and effective method of data storage is considered. There are also illustrations of the structure of a higher educational institution to see the bulkiness of information, and what kind of information database operates in the educational institution. [ABSTRACT FROM AUTHOR]

The antibiotic resistance crisis has prompted research into alternative candidates such as antimicrobial peptides (AMPs). However, the demand for such molecules can only be met by continuous production processes, which achieve high product yields and offer compatibility with the Quality-by-Design initiative by implementing process analytical technologies such as turbidimetry and dielectric spectroscopy. We developed batch and perfusion processes at the 2-L scale for the production of BR033, a cecropin-like AMP from Lucilia sericata, in stably-transformed polyclonal Sf-9 cells. This is the first time that BR033 has been expressed as a recombinant peptide. Process analytical technology facilitated the online monitoring and control of cell growth, viability and concentration. The perfusion process increased productivity by ~ 180% compared to the batch process and achieved a viable cell concentration of 1.1 × 107 cells/mL. Acoustic separation enabled the consistent retention of 98.5–100% of the cells, viability was > 90.5%. The recombinant AMP was recovered from the culture broth by immobilized metal affinity chromatography and gel filtration and was able to inhibit the growth of Escherichia coli K12. These results demonstrate a successful, integrated approach for the development and intensification of a process from cloning to activity testing for the production of new biopharmaceutical candidates. [ABSTRACT FROM AUTHOR]

The university conducts a tracer study to obtain information about job search and the work situation of alumni after graduating from university. So the university will collect tracer study data from year to year. Therefore, the data integration is carried out so that the use of tracer study alumni data as material for analysis becomes more effective. By using the concept of a data warehouse, it will simplify the process of integrating tracer study data. With the implementation of OLAP technology can generate data analysis reports as a basis for decision-making. The data in data warehouse tracer study will be input data in the OLAP (online analytical processing) application. This study designs a multidimensional schema model with a snowflake schema for a data warehouse tracer study. By determining a sample attribute based on predetermined criteria, it can be a measure for making dimensions. Based on the results of the analysis obtained one fact table and nine dimension tables. [ABSTRACT FROM AUTHOR]

The popularity of the Semantic Web (SW) encourages organizations to organize and publish semantic data using the RDF model. This growth poses new requirements to Business Intelligence technologies to enable On-Line Analytical Processing (OLAP)-like analysis over semantic data. The incorporation of semantic data into a Data Warehouse (DW) is not supported by the traditional Extract-Transform-Load (ETL) tools because they do not consider semantic issues in the integration process. In this paper, we propose a layer-based integration process and a set of high-level RDF-based ETL constructs required to define, map, extract, process, transform, integrate, update, and load (multidimensional) semantic data. Different to other ETL tools, we automate the ETL data flows by creating metadata at the schema level. Therefore, it relieves ETL developers from the burden of manual mapping at the ETL operation level. We create a prototype, named Semantic ETL Construct (SETLCONSTRUCT), based on the innovative ETL constructs proposed here. To evaluate SETLCONSTRUCT, we create a multidimensional semantic DW by integrating a Danish Business dataset and an EU Subsidy dataset using it and compare it with the previous programmable framework SETLPROG in terms of productivity, development time, and performance. The evaluation shows that 1) SETLCONSTRUCT uses 92% fewer Number of Typed Characters (NOTC) than SETLPROG, and SETLAUTO (the extension of SETLCONSTRUCT for generating ETL execution flows automatically) further reduces the Number of Used Concepts (NOUC) by another 25%; 2) using SETLCONSTRUCT, the development time is almost cut in half compared to SETLPROG, and is cut by another 27% using SETLAUTO; and 3) SETLCONSTRUCT is scalable and has similar performance compared to SETLPROG. We also evaluate our approach qualitatively by interviewing two ETL experts. [ABSTRACT FROM AUTHOR]

Large volumes of spatial data and multidimensional data are being published on the Semantic Web, which has led to new opportunities for advanced analysis, such as Spatial Online Analytical Processing (SOLAP). The RDF Data Cube (QB) and QB4OLAP vocabularies have been widely used for annotating and publishing statistical and multidimensional RDF data. Although such statistical data sets might have spatial information, such as coordinates, the lack of spatial semantics and spatial multidimensional concepts in QB4OLAP and QB prevents users from employing SOLAP queries over spatial data using SPARQL. The QB4SOLAP vocabulary, on the other hand, fully supports annotating spatial and multidimensional data on the Semantic Web and enables users to query endpoints with SOLAP operators in SPARQL. To bridge the gap between QB/QB4OLAP and QB4SOLAP, we propose an RDF2SOLAP enrichment model that automatically annotates spatial multidimensional concepts with QB4SOLAP and in doing so enables SOLAP on existing QB and QB4OLAP data on the Semantic Web. Furthermore, we present and evaluate a wide range of enrichment algorithms and apply them on a non-trivial real-world use case involving governmental open data with complex geometry types. [ABSTRACT FROM AUTHOR]

A query application for On-Line Analytical Processing (OLAP) examines various kinds of data stored in a Data Warehouse (DW). There have been no systematic studies that look at the impact of query optimizations on performance and energy consumption in relational and NoSQL databases. Indeed, due to a lack of precise power calculation techniques in various databases and queries, the energy activity of several basic database operations is mostly unknown, as are the queries themselves, which are very complicated, extensive, and exploratory. As a result of the rapidly growing size of the DW system, query response times are regularly increasing. To improve decision-making performance, the response time of such queries should be as short as possible. To resolve these issues, multiple materialized views from individual database tables have been collected, and queries have been handled. Similarly, due to overall maintenance and storage expenses, as well as the selection of an optimal view set to increase the data storage facility's efficacy, materializing all conceivable views is not viable. Thus, to overcome these issues, this paper proposed the method of energy-aware query optimization and processing, on materialized views using enhanced simulated annealing (EAQO-ESA). This work was carried out in four stages. First, a Simulated Annealing (SA) based meta-heuristic approach was used to pre-process the query and optimize the scheduling performance. Second, the optimal sets of views were materialized, resulting in enhanced query response efficiency. Third, the authors assessed the performance of the query execution time and computational complexity with and without optimization. Finally, based on processing time, efficiency, and computing cost, the system's performance was validated and compared to the traditional technique. [ABSTRACT FROM AUTHOR]

Structured Query Language (SQL) is commonly used in Relational Database Management Systems (RDBMS) and is currently one of the most popular data definition and manipulation languages. Its core functionality is implemented, with only some minor variations, throughout all RDBMS products. It is an effective tool in the process of managing and querying data in relational databases. This paper describes a method to effectively automate the conversion of a data query from a Natural Language Query (NLQ) to Structured Query Language (SQL) with Online Analytical Processing (OLAP) cube data warehouse objects. To obtain or manipulate the data from relational databases, the user must be familiar with SQL and must also write an appropriate and valid SQL statement. However, users who are not familiar with SQL are unable to obtain relevant data through relational databases. To address this, we propose a Natural Language Processing (NLP) model to convert an NLQ into an SQL query. This allows novice users to obtain the required data without having to know any complicated SQL details. The model is also capable of handling complex queries using the OLAP cube technique, which allows data to be pre-calculated and stored in a multi- dimensional and ready-to-use format. A multi-dimensional cube (hypercube) is used to connect with the NLP interface, thereby eliminating long-running data queries and enabling self-service business intelligence. The study demonstrated how the use of hypercube technology helps to increase the system response speed and the ability to process very complex query sentences. The system achieved impressive performance in terms of NLP and the accuracy of generating different query sentences. Using OLAP hypercube technology, the study achieved distinguished results compared to previous studies in terms of the speed of the response of the model to NLQ analysis, the generation of complex SQL statements, and the dynamic display of the results. As a plan for future work, it is recommended to use infinite-dimension (n-D) cubes instead of 4-D cubes to enable ingesting as much data as possible in a single object and to facilitate the execution of query statements that may be too complex in query interfaces running in a data warehouse. The study demonstrated how the use of hypercube technology helps to increase system response speed and process very complex query sentences. [ABSTRACT FROM AUTHOR]

Decision makers in the educational field always seek new technologies and tools, which provide solid, fast answers that can support decision-making process. They need a platform that utilize the students’ academic data and turn them into knowledge to make the right strategic decisions. In this paper, a roadmap for implementing a data driven decision support system (DSS) is presented based on an educational data mart. The independent data mart is implemented on the students’ degrees in 8 subjects in a private school (Al-Iskandaria Primary School in Basrah province, Iraq). The DSS implementation roadmap is started from pre-processing paper-based data source and ended with providing three categories of online analytical processing (OLAP) queries (multidimensional OLAP, desktop OLAP and web OLAP). Key performance indicator (KPI) is implemented as an essential part of educational DSS to measure school performance. The static evaluation method shows that the proposed DSS follows the privacy, security and performance aspects with no errors after inspecting the DSS knowledge base. The evaluation shows that the data driven DSS based on independent data mart with KPI, OLAP is one of the best platforms to support short-tolong term academic decisions. [ABSTRACT FROM AUTHOR]

The article explores big data refers to data that is so large, fast, or complex that it's difficult or impossible to process using traditional methods. With the increased use of social media and digitization, massive amounts of big data are getting generated daily. This has opened vast opportunities with regards to artificial intelligence and associated applications such as robotics and virtual reality.

Designing a star schema is a complex and time-consuming process requiring an expert to perform several tasks such as denormalization, dimension design, and construction of fact tables. This study presents a method to automatically design and generate star schema models, or so-called multidimensional models. We first introduce a method to incorporate a novel knowledge-based framework to enable an automation system to construct dimensional and fact tables as well as measures, which are the key elements of star schema models. The proposed framework provides a capability of column name identification using the arithmetic coding approach and measures identification using a natural language processing framework (NLP), resulting in dimensions and fact tables being constructed automatically without human intervention. Although the current version of our system is limited to reading data from semi-structured datasets such as CSV files and spreadsheets, the experimental results demonstrate that our framework can generate a star schema effectively, and can support online analytical processing (OLAP) operations. The experimental results show that our method is superior to other conventional approaches, achieving 96.67% accuracy for numerical data, higher than any of the prior models used for comparison. [ABSTRACT FROM AUTHOR]