MS SQL Application Development Framework
| Thesis title in Czech: | MS SQL Application Development Framework |
|---|---|
| Thesis title in English: | MS SQL Application Development Framework |
| Key words: | vývoj aplikací, nástroje, modulární design, bezpečné výrazy, omezení |
| English key words: | application development, framework, modular design, safe statements, constraints |
| Academic year of topic announcement: | 2010/2011 |
| Thesis type: | diploma thesis |
| Thesis language: | angličtina |
| Department: | Department of Software Engineering (32-KSI) |
| Supervisor: | RNDr. Michal Kopecký, Ph.D. |
| Author: | hidden - assigned and confirmed by the Study Dept. |
| Date of registration: | 09.11.2010 |
| Date of assignment: | 09.11.2010 |
| Date and time of defence: | 05.09.2011 11:00 |
| Date of electronic submission: | 04.08.2011 |
| Date of submission of printed version: | 05.08.2011 |
| Date of proceeded defence: | 05.09.2011 |
| Opponents: | doc. RNDr. David Hoksza, Ph.D. |
| Guidelines |
| The goal of this thesis is to design and develop a modular framework that simplifies a database application development and prevent inexperienced users using unsafe SQL statements and/or expressions. The example of such an statements can be insert statements without explicit column list, but also unsafe XPath expressions etc.
While the complete list of features is an object of the design, the framework should among others provide - manipulation with history tables to allow versioning of data and reverting unwanted data changes - asynchronous and parallel SQL execution support - error management and logging support - monitoring of schema changes - procedure and function debugging Together with means of data manipulation, the framework should provide the simple way of publishing stored procedure as web service as well. The framework should be accompanied by well written programmers and users guide to allow its further development. |
| References |
| [1] Sledge O., Spenik M.: Microsoft SQL Server 7.0 DBA Survival Guide; Amazon; 1999; ISBN 978-0672312267
[2] Comingore D., Hinson D.: Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates, and Types; 2006; ISBN 978-0-470-05403-1 [3] Ben-Gan I., Kollar L., Sarka D., Kass S.: Inside Microsoft SQL Server 2008: T-SQL Querying; Microsoft Press; 2009; ISBN 978-0735626034 |