UnivIS
Information system of Friedrich-Alexander-University Erlangen-Nuremberg © Config eG 
FAU Logo
  Collection/class schedule    module collection Home  |  Legal Matters  |  Contact  |  Help    
search:      semester:   
 Lectures   Staff/
Facilities
   Room
directory
   Research-
report
   Publications   Internat.
contacts
   Thesis
offers
   Phone
book
 
 
 Layout
 
printable version

 
 
Departments >> Faculty of Engineering >> Department of Computer Science >> Chair of Computer Science 6 (Data Management) >>
Know Your Queries (KYQ)

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.

Project manager:
Prof. i. R. Dr. Klaus Meyer-Wegener

Project participants:
Dr.-Ing. Peter Schwab

Keywords:
Database Queries, Data Integration, Database Design

Start: 1.4.2015

Sponsored by:
Haushalt

Contact:
Schwab, Peter
E-Mail: peter.schwab@fau.de
Publications
Schwab, Peter ; Wahl, Andreas Maximilian ; Lenz, Richard ; Meyer-Wegener, Klaus: Query-driven Data Integration (Short Paper). In: Krestel, Ralf ; Mottin, Davide ; Müller, Emmanuel (Ed.) : Proc. Conf. "Lernen, Wissen, Daten, Analysen" (LWDA Potsdam, Germany 12. - 14.09.2016). 2016, pp 206-211. (CEUR Workshop Proceedings Vol. 1670)
UnivIS is a product of Config eG, Buckenhof