DSP303 Technology of Large Databases

Code DSP303
Name Technology of Large Databases
Status Compulsory/Courses of Limited Choice
Level and type Undergraduate Studies, Academic
Field of study Computer Science
Academic staff Jānis Eiduks
Credit points 2.0 (3.0 ECTS)
Parts 1
Annotation The main differences of large databases (LDB) and desk-top databases. Data models of LDB. Architecture of LDB logical and physical data organization. On-line transaction management and On-line Analytical processing database systems. Instance and its structure. Database dictionary and configuration parameters. Optimisation of SQL queries. Tuning and audit. The most popular large database management systems: Oracle, MS SQL Server, DB2, Progress, Postgress. The future trends..
Goals and objectives
of the course in terms
of competences and skills
Large databases logical and physical structure building knowledge of relational and object-relational databases. Large database management system architecture and functionality understanding. Database management system functioning optimization performance understanding. Client/server database system administration knowledge. Complicated but effective large-scale database building skills. Server programming language framework knowledge and ability to create specialized unversial database system extensions. Query language SQL and object SQL latest features knowledge.
Learning outcomes
and assessment
Competence of large databases architecture - Hands-on practice, test, exam
Large spectra databases data models (relational and relational-object) and its properties knowledge - Hands-on practice, test, exam
Data definition and manipulation languages - Hands-on practice, test, exam
Database server programming languages (SQL procedural extensions and Java) - Hands-on practice, test, exam
Ability to define large database structure and perform initial data loading - Hands-on practice, test, exam
Ability to determine and if needed then correct databases and database management systems parameters - Hands-on practice, test, exam
Ability to perform database audit - Hands-on practice, test, exam
Course prerequisites Course of learning require good English language skills, interest in their speciality, ability to systematize information and make logical conclusions. Also requires following background knowledge: 1. Course of learning database technology basics (Data Base Management Systems - DB1) full acquirement. 2. Application development concept and understanding of key concepts. 3. Computers network basic principles.

[Extended course information PDF]