Vertical and Horizontal partitions allow database administrators (DBAs) to considerably
improve the performance of business intelligence applications. However, finding and …

A fundamental problem in database systems is choosing the best physical design, ie, a
small set of auxiliary structures that enable the fastest execution of future queries. Almost all …

A fully self-managed DBMS which does not require administrator intervention is the ultimate
goal of database developers. This system should automate deploying, configuration …

Data clouds in general, and cloud data warehouses (CDWs) in particular, have lowered the
upfront expertise and infrastructure barriers, making it easy for a wider range of users to …

Selective materialization of intermediate query results as views is an effective method for
improving query performance. In this paper, we extend this technique to adaptively partition …

Physical design for shared-nothing databases includes decisions regarding the placement
of data across a cluster of database servers. In particular, for each table in the database a …

In this paper, we discuss a self-managed distributed column-store system which would
adapt its physical design to changing workloads. Architectural novelties of column-stores …

ABSTRACT A fundamental problem in database systems is choosing the best physical
design, ie, a small set of auxiliary structures that enable the fastest execution of future …

There is an increasing demand to visualize large datasets as human observable reports in
order to quickly draw insights and gain timely awareness from the data. An interactive user …

It is well-known that fine tuning in database physical design is an important strategy for
speeding up data access. In this paper, we introduce a new approach, denoted HypoPlans …