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) |
|