Open AccessProceedings Article
Towards a One Size Fits All Database Architecture.
Jens Dittrich,Alekh Jindal +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
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
Jens Krueger,Changkyu Kim,Martin Grund,Nadathur Satish,David Schwalb,Jatin Chhugani,Hasso Plattner,Pradeep Dubey,Alexander Zeier +8 more
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
Franz Tödtling,Michaela Trippl +1 more
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
Michael Stonebraker,Samuel Madden,Daniel J. Abadi,Stavros Harizopoulos,Nabil Hachem,Pat Helland +5 more
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
Robert Kallman,Hideaki Kimura,Jonathan Natkins,Andrew Pavlo,Alexander Rasin,Stanley B. Zdonik,Evan P. C. Jones,Samuel Madden,Michael Stonebraker,Yang Zhang,John Hugg,Daniel J. Abadi +11 more
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.