Specialized area, Master's degree - Databases
Graduate competencies:
— Has a good command of relational and non-relational database management systems, query languages, and trends in their development.
— Can select and implement tools used for gathering and analyzing information from multiple sources and from large datasets.
— Can design a data warehouse and processes aimed at acquiring data for the warehouse from various data sources.
— Can select a database management system for a given problem and means for optimizing database access.
— Can monitor a database server and tune database performance.
— Can design a user interface for a database application.
Elective subjects required for the database area:
— Data integration and data warehouses
— Advanced modeling and analysis of IT systems
— Big data analysis
Thesis topics:
— Building, administering, and tuning databases
— Building and managing data warehouses
— NoSQL databases
— Educational support systems (e-learning)
— Interesting database applications
Sample thesis topics:
- Performance comparison of selected database servers
- Analysis of database trace files for patterns and anti-patterns
- Analysis of the database usage profile
- Analysis of database performance reports
- Performance comparison of reporting from a relational database and an OLAP cube
- Analysis of data model query coverage: how much data is in the database that no one uses?
- Statistical analysis of trace files, exploration of truly large, semi-structured data
- Analysis of query language capabilities in ORM
- Extending ORM with recursive queries in the style of SQL:1999 and Oracle
- Extending ORM with functional indexes and index advisory
- Extending ORM with partial aggregations, tree counters
- Optimization of recursive queries
- Integration of ORM with NoSQL databases
- Approximate shortest path search in a large graph
- Building an intelligent e-textbook (e-tutor) in the field of databases
Thesis supervisors:
— Prof. dr hab. Krzysztof Stencel is interested in databases, software engineering, and artificial intelligence and machine learning applied in both fields. Master's theses carried out under his supervision concern database tuning, NOSQL/NewSQL databases, object-relational mapping, as well as the analysis of profile data from Google infrastructure following his internship at the company.
— Ph.D. Eng. Paweł Lenkiewicz is interested in database administration and performance tuning. Master's theses supervised by him typically focus on comparing and examining various aspects of database server operation from a practical perspective. He is also interested in any new features implemented in modern database servers, as well as their applications in application development. He offers both implementation-heavy topics and more theoretical ones, where the practical part involves conducting research on selected database servers.
— Ph.D. Agnieszka Chądzyńska-Krasowska supervises master's theses concerning data warehouses and data mining in databases.
— Dr hab. Lech Banachowski supervises master's theses related to database applications in the fields of e-learning and knowledge representation and management.
— Ph.D. Ida Jokisz supervises master's theses related to the applications of databases in medicine.
The choice of the area at the Faculty of Computer Science is made after completing a survey.
The survey is completed by students during the application process for master's degree programs at the Department of Computer Science.
