This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
teaching:infoh419 [2022/09/19 15:28] ezimanyi [Groups of the current year] |
teaching:infoh419 [2022/09/19 15:37] ezimanyi [Course Summary] |
||
|---|---|---|---|
| Line 35: | Line 35: | ||
| For these reasons, data to be analyzed is typically collected into a data warehouse with Online Analytical Processing support. Online here refers to the fact that the answers to the queries should not take too long to be computed. Collecting the data is often referred to as Extract-Transform-Load (ELT). The data in the data warehouse needs to be organized in a way to enable the analytical queries to be executed efficiently. For the relational model star and snowflake schemes are popular designs. Next to OLAP on top of a relational database (ROLAP), also native OLAP solutions based on multidimensional structures (MOLAP) exist. In order to further improve query answering efficiency, some query results can already be materialized in the database, and new indexing techniques have been developped. | For these reasons, data to be analyzed is typically collected into a data warehouse with Online Analytical Processing support. Online here refers to the fact that the answers to the queries should not take too long to be computed. Collecting the data is often referred to as Extract-Transform-Load (ELT). The data in the data warehouse needs to be organized in a way to enable the analytical queries to be executed efficiently. For the relational model star and snowflake schemes are popular designs. Next to OLAP on top of a relational database (ROLAP), also native OLAP solutions based on multidimensional structures (MOLAP) exist. In order to further improve query answering efficiency, some query results can already be materialized in the database, and new indexing techniques have been developped. | ||
| - | In the course, the main concepts of multidimensional databases will be covered and illustrated using the SQL Server tools. Complimentary to the course, IBM and Teradata will give invited lectures. | + | In the course, the main concepts of multidimensional databases will be covered and illustrated using the SQL Server tools. |
| ===== Books ===== | ===== Books ===== | ||
| Line 115: | Line 115: | ||
| ===== Groups of the current year ===== | ===== Groups of the current year ===== | ||
| - | * SparSQL: Luis Alfredo Leon, Satria Bagus Wicaksono, Jezuela Gega, Isabella Forero | + | * Spark SQL: Luis Alfredo Leon, Satria Bagus Wicaksono, Jezuela Gega, Isabella Forero |
| ===== Examinations from Previous Years ===== | ===== Examinations from Previous Years ===== | ||