Know Your Queries!

Know Your Queries!

(Own Funds)

Project leader:
Project members:
Start date: 01/04/2015
End date: 31/12/2018
Acronym: KYQ

Abstract

The project aims at the management of database queries for a number of different purposes. A simple form is the use for the optimization of a given database instance. This is done by database administrators anyway, and often the database systems helps them in storing the queries and making suggestions for optimizations.

If you know your queries, however, you can do much more. You can check whether some of them would be executed more efficiently by a datastream system. Or by a NoSQL system. In both cases the queries must be translated into the languages understood by the resp. system.

And finally one can take queries also when the system needed to execute them does not even exist. One reason can be that the data needed to respond to the query are locally stored in your own system, but are available in external sources that still need to be attached. Another reason can be that there is no database system yet. Designing it could benefit substantially from knowing the queries that it is to execute later on. One can even try to generate parts of the database schema automatically from the queries.

Publications


People

Project Heads

Dr.-Ing. Peter Schwab

Lehrbeauftragter

Prof. i. R. Dr. Klaus Meyer-Wegener

Further Participants