Code | DSP303 |
Name | Technology of Large Databases |
Status | Compulsory/Courses of Limited Choice |
Level and type | Undergraduate Studies, Academic |
Field of study | Computer Science |
Faculty | |
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. |