Dr Dragoljub Pokrajac-Pokie
Assistant professor

 

 

35-371 Advanced Database Systems

Spring 2006 Schedule:        TR 3-4:15PM

syllabus

bulletOffice hours: TR 4:15-6PM
bulletAssignments
bulletHW1.doc (2004)
bulletHW2.doc (2004)
bulletHW3.doc (2004)
bulletHW4.doc (2004)
bulletHW5.doc (2004)
bulletClass Material
bulletSQL Data Definition
bulletAdvancedSQLQueries.ppt
bulletIntroduction to Normalization
bulletFunctional Dependence Theory and Applications
bulletFile and Indexing Structure in Databases
bulletProlog and normalization.pdf
bullet ProceduresFunctionsAndTriggersInSQL.ppt
bulletQueryOptimization.ppt
bullet PostgreSQLPerformanceTuning.ppt
bullet ConcurencyControlandTransactionProcessing.ppt
bulletViews.ppt

 

bulletFinal Exam

 

bulletArticles

        UpdatingOfRelationalViews.ppt

        CoddsRules.ppt

        Overview of different conversions for specialization relationship types.doc

        GeneralizationAndSpecializationConstraintsInPostgresql.pdf

bulletOn-line Resources

         INVeSTa: System for Virtual Advising

bulletPostgresql documentation 

        http://www.postgresql.org/docs/7.3/interactive/index.html