Fundamentals of Data Management
Duration:
1 Teaching Period
Unit Code:
COS20015
Contact Hours:
Recommended 10 hours of study per week
About this unit
This unit introduces students to a range of skills, techniques, technologies and fundamental computer science concepts related to managing data within software systems. Students will learn how to organise data, efficiently search and sort information, as well as apply techniques to optimise these operations. Data management is a critical component in most software systems – knowledge and skills gained in this unit can be applied to a range of different solution domains from enterprise systems to smaller desktop and mobile applications.
Content
Data Fundamentals
- Set theory
Data types, schema and validation
Ternary logic and dealing with null values
Data representation
- Tabular representation (Text, CSV)
- Hierarchical representation (XML and JSON)
- Relational representation and basics of normalisation
Data processing and retrieval
- Searching, sorting and algorithmic complexity
- Text processing tools and techniques
- Importing, exporting and transforming data
- Indexing, B+ -Trees, algorithms and trade-offs
- Querying with regular expressions, SQL and tree-matching expressions
- Transactions and concurrent data access