scispace - formally typeset
Open AccessProceedings Article

Towards a One Size Fits All Database Architecture.

Jens Dittrich, +1 more
- pp 195-198
TLDR
This work proposes a new type of database system coined OctopusDB, which uses a logical event log as its primary storage structure and introduces the concept of Storage Views (SV), i.e. secondary, alternative physical data representations covering all or subsets of the primary log.
Abstract
We propose a new type of database system coined OctopusDB. Our approach suggests a unified, one size fits all data processing architecture for OLTP, OLAP, streaming systems, and scan-oriented database systems. OctopusDB radically departs from existing architectures in the following way: it uses a logical event log as its primary storage structure. To make this approach efficient we introduce the concept of Storage Views (SV), i.e. secondary, alternative physical data representations covering all or subsets of the primary log. OctopusDB (1) allows us to use different types of SVs for different subsets of the data; and (2) eliminates the need to use different types of database systems for different applications. Thus, based on the workload, OctopusDB emulates different types of systems (row stores, column stores, streaming systems, and more importantly, any hybrid combination of these). This is a feature impossible to achieve with traditional DBMSs.

read more

Content maybe subject to copyright    Report

Citations
More filters
Proceedings ArticleDOI

Overview of Data Exploration Techniques

TL;DR: This tutorial surveys recent developments in the emerging area of database systems tailored for data exploration as well as new ideas on how to interact with a data system to enable users and applications to quickly figure out which data parts are of interest.
Proceedings ArticleDOI

Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems

TL;DR: This work presents a novel MVCC implementation for main-memory database systems that has very little overhead compared to serial execution with single-version concurrency control and verifies that the (extensional) writes of recently committed transactions do not intersect with the (intensional) read predicate space of a committing transaction.
Journal ArticleDOI

Fast updates on read-optimized databases using multi-core CPUs

TL;DR: This work presents an optimized merge process reducing the merge overhead of current systems by a factor of 30 and enables compressed in-memory column stores to handle the transactional update rate required by enterprise applications, while keeping properties of read-optimized databases for analytic-style queries.
Proceedings ArticleDOI

H2O: a hands-free adaptive store

TL;DR: It is demonstrated that while existing systems cannot achieve maximum performance across all workloads, H2O can always match the best case performance without requiring any tuning or workload knowledge.
Patent

Hybrid database table stored as both row and column store

TL;DR: In this article, a hybrid database table is stored as both a row and a column store, and a hybrid table manager may control movement of data to the column store based upon considerations such as frequency of access, or underlying business logic.
References
More filters
Journal ArticleDOI

One size fits all?: Towards a differentiated regional innovation policy approach

TL;DR: In this article, the authors analyse different types of regions with respect to their preconditions for innovation, networking and innovation barriers and develop different policy options and strategies based on this classification.
Proceedings ArticleDOI

Pig latin: a not-so-foreign language for data processing

TL;DR: A new language called Pig Latin is described, designed to fit in a sweet spot between the declarative style of SQL, and the low-level, procedural style of map-reduce, which is an open-source, Apache-incubator project, and available for general use.
Journal ArticleDOI

ARIES: a transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging

TL;DR: ARIES as discussed by the authors is a database management system applicable not only to database management systems but also to persistent object-oriented languages, recoverable file systems and transaction-based operating systems.
Book ChapterDOI

The end of an architectural era: it's time for a complete rewrite

TL;DR: The current RDBMS code lines, while attempting to be a "one size fits all" solution, in fact, excel at nothing and should be retired in favor of a collection of "from scratch" specialized engines.
Journal ArticleDOI

H-store: a high-performance, distributed main memory transaction processing system

TL;DR: The demonstration presented here provides insight on the development of a distributed main memory OLTP database and allows for the further study of the challenges inherent in this operating environment.
Related Papers (5)