Concept
Online analytical processing
Related publications (113)
Analytical Engines With Context-Rich Processing: Towards Efficient Next-Generation Analytics
Anastasia Ailamaki, Viktor Sanca
As modern data pipelines continue to collect, produce, and store a variety of data formats, extracting and combining value from traditional and context-rich sources such as strings, text, video, audio, and logs becomes a manual process where such formats a ...
2023Efficient Concurrent Analytical Query Processing using Data and Workload-conscious Sharing
Analytical workloads are evolving as the number of users surges and applications that submit queries in batches become popular. However, traditional analytical databases that optimize-then-execute each query individually struggle to provide timely response ...
EPFL2023Interactive-time Exploration, Querying, and Analysis of Large High-dimensional Datasets
In the current era of big data, aggregation queries on high-dimensional datasets are frequently utilized to uncover hidden patterns, trends, and correlations critical for effective business decision-making. Data cubes facilitate such queries by employing p ...
EPFL2023Algorithms push forward the application of MALDI-TOF mass fingerprinting in rapid precise diagnosis
Macromolecular mass fingerprinting using matrix-assisted laser desorption/ionization time-of-flight mass spectrometry is a quick tool for biochemical analysis. In combination with algorithms for automated data analysis and interpretation, it has wide appli ...
WILEY2023A Robust Framework for Generating Adsorption Isotherms to Screen Materials for Carbon Capture
Berend Smit, Susana Garcia Lopez, Elias Moubarak, Seyedmohamad Moosavi
To rank the performanceof materials for a given carbon captureprocess, we rely on pure component isotherms from which we predictthe mixture isotherms. For screening a large number of materials,we also increasingly rely on isotherms predicted from molecular ...
AMER CHEMICAL SOC2023Phonons, electron-phonon coupling and charge transport in low-dimensional materials
Over the past few decades, nanostructures have garnered significant attention due to their potential for embodying new physical paradigms and delivering cutting-edge technological applications. Dimensionality strongly affects the vibrational, electron-phon ...
EPFL2023Pixels: An Efficient Column Store for Cloud Data Lakes
Anastasia Ailamaki, Haoqiong Bian
To benefit from the cloud’s higher elasticity and price-efficiency, most modern data-lake engines support S3-like cloud object storage (COS) services as their optional or preferred underlying storage. Meanwhile, the widespread column stores, such as Parque ...
IEEE2022Efficient Analytical Query Processing on CPU-GPU Hardware Platforms
Timely insights lead to business growth and scientific breakthroughs but require analytical engines that cope with the ever-increasing data processing needs. Analytical engines relied on rapid CPU improvements, yet the end of Dennard scaling stopped the fr ...
EPFL2022Assortment optimization using an attraction model in an omnichannel environment
Ralf Seifert, Andrey Vasilyev, Sebastian Maier
Making assortment decisions is becoming an increasingly difficult task for many retailers worldwide as they implement omnichannel initiatives. Discrete choice modeling lies at the core of this challenge, yet existing models do not sufficiently account for ...
ELSEVIER2022High-dimensional Data Cubes
Christoph Koch, Sachin Basil John
This paper introduces an approach to supporting high-dimensional data cubes at interactive query speeds and moderate storage cost. The approach is based on binary(-domain) data cubes that are judiciously partially materialized; the missing information can ...
2022