Navigation

Know Your Queries!

Know Your Queries!

(Own Funds)

Project leader:
Project members:
Start date: 04/01/15
End date: 12/31/18
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

Dipl.-Inf. Peter Schwab

  • Address:
    Martensstraße 3
    91058 Erlangen
  • Phone number: +49 9131 85-27902
  • Email: peter.schwab@fau.de

Prof. Dr. Klaus Meyer-Wegener

  • Job title: Holder of Chair
  • Address:
    Martensstraße 3
    91058 Erlangen
  • Phone number: +49 9131 85-27892
  • Email: klaus.meyer-wegener@fau.de

Outer office

  • Cécile Astor
    • Phone number: +49 9131 85-27893
    • Fax number: +49 9131 85-28854
    • Email: cs6-office@fau.de
    • Office hours: Weekly Mon, 8:30 - 14:00, Room 08.139,
      Weekly Tue, Wed, Thu, 8:30 - 13:30, Room 08.139,

Further Participants

Julian Matschinske, Florian Kronberger