| Code |
14736
|
| Year |
3
|
| Semester |
S2
|
| ECTS Credits |
6
|
| Workload |
PL(30H)/T(30H)
|
| Scientific area |
Informatics
|
|
Entry requirements |
Skills on algorithms development and codification.
(Skills on) Data modeling and database applications development.
|
|
Mode of delivery |
Face-to-face instruction.
|
|
Work placements |
Not applicable.
|
|
Learning outcomes |
This curricular unit increase the knowledge acquired in the Database curricular unit, to new domains, namely, Temporal Databases, Data Warehousing, and multilevel applications (n-tier).
After completing this course, the student should be able to design and implement information systems supported by a database management system. In particular, should be able to design databases from the information system requirements; design temporal and multidimensional databases; populate the data warehouse with data converted from the conventional databases and explore them (cube and related operations); perform complex SQL (and TSQL-2) queries; and develop multilevel database applications (n-tier and n-layer), including web database applications.
|
|
Syllabus |
1. Relational model
1.1 Entity-relationship diagram
1.2 Conceptual, logical and physical database models
1.3 Advanced SQL: views, cursors, triggers and stored procedures
1.4 Transactions (ACID, Locks, Isolation levels, Phenomena, Deadlock, Checkpoint)
2. Data warehousing
2.1 Concepts (DW, Data mart, ETL)
2.2 Data models
2.3 OLAP
2.3.1 OLAP vs OLTP
1.3.2 MOLAP, ROLAP, and HOLAP
2.2.3 Schemas: star, fact constellation, amd Snowflake
2.3.4 Operations: Slicing, Dicing, Roll-up/Drill-Down,...
2.4 Data mining
2.4.1 Definition
2.4.2 Techniques
3. Temporal databases
3.1 Concepts
3.2 Types of time (instantaneous, transaction, validity, bitemporal)
3.3 Time orders (linear, branching, circular)
3.4 Granularity
3.5 Temporal data models
3.6 Query languages (TSQL-2)
3.7 Examples
4. Developing advanced database applications
4.1 Client/server applications
4.2 Multilevel (n-tier) applications
4.3 Web applications
4.4 Transaction processing
4.5 Data reconciliation
|
|
Main Bibliography |
Thomas Connolly, Carolyn Begg. “Database Systems, A Practical Approach to Design, Implementation and Management”, 6th Edition, 2015. Pearson, ISBN: 978-1-292-06118-4.
Feliz Gouveia, “Bases de Dados – Fundamentos e Aplicações”, 2ª Edição, FCA, 2021, ISBN: 978-972-722-901-7.
Claudia Imhoff, Nicholas Galemmo, Jonathan G. Geiger. “Mastering Data Warehouse Design”, 2003, Wiley (ISBN: 978-047134218).
Abraham Silberschatz, Henry Korth, S. Sudarshan. “Database System Concepts”, 7th Edition , 2020, McGraw-Hill (ISBN: 978-0-07-802215-9)
Ramez Elmasri, Shamkant B. Navathe. “Fundamentals of Database Systems”, 6th Edition. 2011, Addison-Wesley (ISBN: 978-0-136-08620-8).
C.J.Date, Hugh Darwen, Nikos A. Lorentzos. "Temporal Data and the Relational Model". 2003, Morgan Kaufmann Publishers, ISBN: 1-55860-855-9.
Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker. “The Data Warehouse Lifecycle Toolkit”, 2nd Edition, 2008, Wiley (ISBN: 978-0470149775).
|
|
Language |
Portuguese. Tutorial support is available in English.
|