Concept
Traitement analytique en ligne
Publications associées (113)
High-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 ...
ASSOC COMPUTING MACHINERY2022Efficient GPU-accelerated Join Optimization for Complex Queries
Anastasia Ailamaki, Bikash Chandra, Srinivas Karthik Venkatesh, Riccardo Mancini, Vasileios Mageirakos
Analytics on modern data analytic and data warehouse systems often need to run large complex queries on increasingly complex database schemas. A lot of progress has been made on executing such complex queries using techniques like scale out query processin ...
IEEE2022Columnar Storage Optimization and Caching for Data Lakes
As a unified data repository, data lake plays a vital role in enterprise data management and analysis. It composes the raw files into tables that are processed in-situ by various computation engines and applications. Therefore, the read performance of the ...
2022Boosting Efficiency of External Pipelines by Blurring Application Boundaries
Anastasia Ailamaki, Periklis Chrysogelos, Anna Patricia Herlihy
Modern application development addresses increasingly specialized problems using domain-specific utilities, such as Optical Code Recognition and standalone statistical tools. The diversity of tooling, combined with the ever-growing volume of data, requires ...
2022Efficient Massively Parallel Join Optimization for Large Queries
Anastasia Ailamaki, Bikash Chandra, Srinivas Karthik Venkatesh, Riccardo Mancini, Vasileios Mageirakos
Modern data analytical workloads often need to run queries over a large number of tables. An optimal query plan for such queries is crucial for being able to run these queries within acceptable time bounds. However, with queries involving many tables, find ...
2022Performance Characterization of HTAP Workloads
Anastasia Ailamaki, Sandhya Dwarkadas, Utku Sirin
Hybrid Transactional and Analytical Processing (HTAP) systems have become popular in the past decade. HTAP systems allow running transactional and analytical processing workloads on the same data and hardware. As a result, they suffer from workload interfe ...
IEEE COMPUTER SOC2021Micro-architectural Analysis of Database Workloads
Database workloads have significantly evolved in the past twenty years. Traditional database systems that are mainly used to serve Online Transactional Processing (OLTP) workloads evolved into specialized database systems that are optimized for particular ...
EPFL2021Scalable Multi-Query Execution using Reinforcement Learning
Anastasia Ailamaki, Panagiotis Sioulas
The growing demand for data-intensive decision support and the migration to multi-tenant infrastructures put databases under the stress of high analytical query load. The requirement for high throughput contradicts the traditional design of query-at-a-time ...
Association for Computing Machinery2021Proof-of-concept analytical instrument for label-free optical deconvolution of protein species in a mixture
The adoption of process analytical technologies by the biopharmaceutical industry can reduce the cost of therapeutic drugs and facilitate investigation of new bioprocesses. Control of critical process parameters to retain critical product quality attribute ...
ELSEVIER2021Micro-architectural analysis of in-memory OLTP: Revisited
Anastasia Ailamaki, Danica Porobic, Utku Sirin
Micro-architectural behavior of traditional disk-based online transaction processing (OLTP) systems has been investigated extensively over the past couple of decades. Results show that traditional OLTP systems mostly under-utilize the available micro-archi ...
2021