HyPer-sonic combined transaction and query processing

HyPer-sonic Combined Transaction AND Query Processing

In this demo we will prove that it is – against common belief – indeed possible to build a main-memory database system that achieves world-record transaction processing throughput and best-of-breed OLAP query response times in one system in parallel on the same database state. The two workloads of online transaction processing (OLTP) and online analytical processing (OLAP) present different cha...

Multidatabase Transaction and Query Processing in Logic

Compensation-Based Query Processing in On-Line Transaction Processing Systems

One of the problems associated with running ad-hoc queries in an OLTP system is lock contention. Compensation-based query processing has been proposed as a solution to this problem. In this paper, undo/no-redo compensation is used to bring inconsistent copies of the base relations into a transaction-consistent state. Queries process the database internal log to obtain information on updates mad...

Eecient Transaction Management & Query Processing in Massive Digital Databases

We address several important issues that arise in the development of Massive Digital Database Systems (MDDSs) in which data is being added continuously and on which users pose queries on the y. News-on-demand and document retrieval systems are examples of systems that have these characteristics. Given the size of data, metadata such as index structures become even more important in these system...

On Scalable and Flexible Transaction and Query Processing in Main-Memory Database Systems

The hardware landscape for database systems has changed dramatically over the past two decades. Today, the traditional database system architecture that was pioneered by System R and is implemented by IBM DB2, Microsoft SQL Server, Oracle and Postgres, shows weaknesses in all major areas of application of commercial database systems: operational transaction processing, decision support and busi...