| Advanced Database Systems |
| Abbreviation: NAPBAZ
|
Load: 30(L)
+ 0(E)
+ 30(LE)
+ 0(S)
+ 0(FLE)
+ 0(PEE)
|
| Lecturers in charge: |
dr. sc. Tonči Carić |
| Lecturers: |
Martina Erdelić mag. ing. traff.
(
Laboratory exercises
)
Tomislav Erdelić mag. ing. el. techn. inf.
(
Laboratory exercises
)
|
| Course description: An introduction to T-SQL and the use of SQL scripts. Query execution flow control and error management. Using views like data
protection and simplifying data access. Creating and using of the stored procedure, creating user-defined functions. Using
derived and temporary tables. Retrieving data using the cursor. Creating a trigger and referential integrity protection. Manipulation
of XML data in a database, and export and import of data in XML format. Multi-user database operation (competitiveness issues
and transaction-based solutions). Backup and recovery. Security levels and assignment/revocation of access to individual database
objects. Examples of connecting a database to Internet applications. Data Warehouse. Basics of working with spatial databases,
Spatio-temporal databases and moving object databases.
|
| Compulsory literature: |
| 1. |
Elmasri, R., Navathe, S., B.: Fundamentals of Database Systems 5th Edition, Addison-Wesley, 2006. |
| 2. |
Varga, M.: Baze podataka, konceptualno, logičko i fizičko modeliranje podataka. DRIP, 1994. |
| 3. |
Güting, R., H., Schneider, M.: Moving Objects Databases, Morgan Kaufmann, 2005. |
| Recommended literature: |
| 4. |
Date, C. J.: The SQL Standard, Addison Wesley, 1996. |
| 5. |
Teorey, T.J., Lightstone, S.S., Nadeau, T.: Database modeling and design: Logical design 4th Edition, Morgan Kaufmann, 2005.
|
|