SQL front-end pro systém Bobox
| Thesis title in Czech: | SQL front-end pro systém Bobox |
|---|---|
| Thesis title in English: | A SQL front-end for the Bobox system |
| Key words: | SQL, relační algebra, frontend, XML |
| English key words: | SQL, relational algebra, frontend, XML |
| Academic year of topic announcement: | 2013/2014 |
| Thesis type: | diploma thesis |
| Thesis language: | čeština |
| Department: | Department of Software Engineering (32-KSI) |
| Supervisor: | RNDr. David Bednárek, Ph.D. |
| Author: | hidden - assigned and confirmed by the Study Dept. |
| Date of registration: | 03.11.2013 |
| Date of assignment: | 07.11.2013 |
| Confirmed by Study dept. on: | 18.11.2013 |
| Date and time of defence: | 09.09.2015 11:00 |
| Date of electronic submission: | 31.07.2015 |
| Date of submission of printed version: | 31.07.2015 |
| Date of proceeded defence: | 09.09.2015 |
| Opponents: | doc. RNDr. Jakub Lokoč, Ph.D. |
| Guidelines |
| Cílem práce je návrh a implementace překladače SQL dotazů pro netradiční databázový systém. V rámci této práce je obsažen syntaktický a sémantický analyzátor jazyka SQL a překladač do relační algebry. Tento front-end bude spojen s optimalizujícím back-endem vyvíjeným v rámci diplomové práce Vyhodnocování relačních dotazů v proudově orientovaném prostředí. Dotazy přeložené tímto řetězcem budou vyhodnocovány systémem Bobox [Bednárek et al. 2012]. |
| References |
| - Silberschatz, A., Korth, H., Sudarshan, S., Database System Concepts (6th ed.), McGraw-Hill, 2010. ISBN 978-0-07-352332-3.
- Grune, D., Modern compiler design. Wiley, 2002. ISBN 0471976970. - Garcia-Molina, H., Ullman, J. D., and Widom, J., Database systems: the complete book. Prentice-Hall, 2002. ISBN 0-13-031995-3. - Bednárek D., Dokulil J., Yaghob J., Zavoral F.: Data-Flow Awareness in Parallel Data Processing, in Intelligent Distributed Computing VI, Springer, ISBN: 978-3-642-32523-6, ISSN: 1860-949X, pp. 149-154, 2012. |
| Preliminary scope of work in English |
| The goal is the implementation of a SQL front-end for a non-traditional database system. The project of this thesis includes a SQL parser, a semantic checker, and a translator into relational algebra. The front-end will be connected to an optimizing back-end being created within the thesis Evaluating relational queries in pipeline-based environment. The queries translated by the pipeline will be executed in the BoBoX system. |