Database and Information Systems
Term project
If it is not specified in other way, there is one task per one student. Minimal number of pages per student is 10. The tasks are available here. Send me an email with a number of selected topic. Solution will have the following parts:
- Description of a problem, methods, implementation and evaluation of results and conclusion.
- Creation of testing example with source codes attached.
- 5 minute presentation at the last exercise.
Maximal number of points is 20, minimal 10.
Resources: oracle documentation
Lectures and Exercises
| Week | Lecture | Exercise |
| 1. | Introduction, recovery, transactions (last change: 16.9.2009) | SQL, transactions tasks, Insert SQL script (last change: 16.9.2009) |
| 2. | Concurency I (last change: 23.9.2009) | SQL, transactions, LIKE, NULL, CASE, CHECK, Views tasks (last change: 23.9.2009) |
| 3. | - | SQL, comprehensive example tasks (last change: 28.9.2009) |
| 4. | PL/SQL | PL/SQL scripts, Procedures, Functions, Variables, Cursors tasks |
| 5. | Concurency II (last change: 13.10.2009) | PL/SQL scripts, Procedures, Exceptions, Triggers, Package tasks |
| 6. | Transactions in host languages (last change: 20.10.2009) | PL/SQL |
| 7. | Distributed database management systems (last change: 4.11.2009) | PL/SQL |
| 8. | Query processing and optimizations (last change: 11.11.2009) | Examination |
| 9. | - | Databases in a host languages. Object-relational mapping tasks NetBeans project last change: 18.11.2009) |
| 10. | Data structures and indexes (last change: 24.11.2009) | - |
| 11. | Database system modeling (last change: 1.12.2009) | Databases and in a host languages. Transactions tasks (last change: 2.12.2009) |
| 12. | Data structures and indexes II (last change: 6.1.2010) | - |
PL/SQL Documentation