Database Systems

Database systems allow the efficient management of structured data. However, in dealing with time-stamped, incrementally arriving records that must be analysed as soon as possible they reach their limits.

Projects

KYQ: Know Your Queries!

"You should know your queries!" is the long version of the project title.  It means that you should not just want tho have a database, but you should also think about the evaluations (which are written down as queries) that you actually would like to do with that database.  The creation of a database is quite an effort, regarding not only the deployment of the software on a computer, but even more the capture of all the data to fill it.  This effort should be spent with a goal in mind.  The project will therefore collect queries, which can then even be used to automatically design a database.  This saves resources on one hand, but on the other also supports the privacy goal of data minimization.

More information

DAMSEL: Assessment of Data Management Systems

The world of data-management systems has become a bit confusing during the last years.  Next to the well-established relational database systems, so-called NoSQL systems have been developed, which pretend to cope with much larger data volumes.  At the same time, they can only offer limited functionality with respect to efficient data access and can only give reduced consistency guarantees.  That raises the question when to stick to a relational database and when to move to a NoSQL system.  This project collects the criteria that allow to make such a decision on a well-founded basis.

More information

E|ASY-Opt INF6: REAPER: A Framework for Materializing and Reusing Deep-Learning Models

Within the framework of the EFRE-E|ASY-Opt subproject, the potential of data mining methods in the area of manufacturing is being investigated. Especially the training of Deep-Learning models is a computationally intensive task, which may take hours or several days. The training time can be shortened considerably by using an already trained model, as long as the goal and source task are closely related. This connection is not yet fully understood.

The aim of this research project is to implement a system called REAPER (Reusable Neural Network Pattern Repository) to support data scientists in storing and reusing already trained deep learning models.

More information

ReProVide: Query Optimisation and Near-Data Processing on Reconfigurable SoCs for Big Data Analysis

This project is funded by the German Research Foundation (DFG) within the Priority Program SPP 2037 "Scalable Data Management for Future Hardware".

The goal of this project is to provide novel hardware and optimisation techniques for scalable, high-performance processing of Big Data. We particularly target huge datasets with flexible schemas (row-oriented, column-oriented, document-oriented, irregular, and/or non-indexed) as well as data streams as found in click-stream analysis, enterprise sources like e-mails, software logs and discussion-forum archives, as well as produced by sensors in the Internet of Things (IoT) and in Industrie 4.0. In this realm, the project investigates the potential of hardware-reconfigurable, FPGA-based Systems-on-Chip (SoCs) for near-data processing where computations are pushed towards such heterogeneous data sources. Based on FPGA technology and in particular thier dynamic reconfiguration, we propose a generic architecture called ReProVide for low-cost processing of database queries.

More information

SIML: Schema Inference and Machine Learning

Within the project SIML (Schema Inference and Machine Learning), methods of topological data analysis and unsupervised learning are combined, applied and further developed in order to derive a conceptual schema from unstructured, multivariant data.

More information

ANANIA: Architecture of Non-Multiple Autoencoders for Non-Lossy Information Agglomeration (working title, preliminary)

The compression of data has played a decisive role in data management for a long time. Compressed data can be permanently stored in a more space-saving manner and sent over the network more efficiently. However, the ever-increasing volumes of data mean that the importance of good compression methods is growing all the time.

Within the scope of project Anania (Architecture of Non-Multiple Autoencoders for Non-Lossy Information Agglomeration), we are investigating to what extent classical…

More information

ReProVide II INF6: Query Optimisation and Near-Data Processing on Reconfigurable SoCs for Big Data Analysis (Phase II)

Analysing petabytes of data in an affordable amount of time and energy requires massively parallel processing of data at their source. Active research is therefore directed towards emerging hardware architectures to reduce the volume of data close to their source and towards sound query analysis and optimisation techniques to exploit such novel architectures. The goal of the ReProVide project is to investigate FPGA-based solutions for smart storage and near-data processing together with novel query-optimisation…

More information

FST: Generation of Symbol Tables for String Compression with Frequent-Substring Trees

With the ongoing rise in global data volumes, database compression is becoming increasingly relevant. While the compression of numeric data types has been extensively researched, the compression of strings has only recently received renewed scientific attention.

A promising approach to string compression is the use of symbol tables, where recurring substrings within a database are substituted with short codes. A corresponding table enables the smooth reconstruction of the original data.…

More information

SKYSHARK: SKYSHARK -Benchmarking Data Processing Systems Using Real-Time Flight Data

To test and evaluate a heterogeneous stream-processing system consisting of an FPGA-based systemon-chip and a host, we develop a benchmark called SKYSHARK. It uses real-world data from air-traffic control that is publicly available. These data are enhanced for the purpose of the benchmark without changing their characteristics. They are further enriched with aircraft and airport data. We define 14 queries with respect to the particular requirements of our system. They should be useful for other…

More information

Participating Scientists

Publications