This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
teaching:infoh419 [2018/09/17 18:34] ezimanyi [Group Project] |
teaching:infoh419 [2018/09/17 18:39] ezimanyi [Group Project] |
||
---|---|---|---|
Line 91: | Line 91: | ||
===== Group Project ===== | ===== Group Project ===== | ||
- | The project is carried out in groups of 3 to 4 people. Before you can submit assignment part I, you will have to register in a group. For registering a group send an email to the lecturer. Please to select your group before or on 1/10/2018. | + | The [[http://www.tpc.org|TPC]]TPC is a non-profit corporation that defines transaction processing and database benchmarks and disseminates objective, verifiable TPC performance data to the industry. Regarding data warehouses, two TPC benchmarks are relevant: |
+ | * [[http://www.tpc.org/tpcds/|TPC-DS]], the Decision Support Benchmark, which models the decision support functions of a retail product supplier. | ||
+ | * [[http://www.tpc.org/tpcdi/|TPC-DI]], the Data Integration Support Benchmark, which models a typical ETL process that loads a data warehouse. | ||
- | The project consist of 2 parts: | + | The project of the course consist of 2 parts: |
+ | * Part I: Implement the TPC-DS benchmark (deadline 1/11/2018) | ||
+ | * Part II: Implement the TPC-DI benchmark (deadline 20/12/2018) | ||
+ | You will have free choice to use the tools on which the two benchmarks will be built. For example, the TPC-DS benchmark can be implemented on SQL Server Analysis Services, Pentaho Analysis Services (aka Mondrian), etc. Similarly, the TPC-DI could be implemented on SQL Server Integration Services, Pentaho Data Integration, Talend Data Studio, or even SQL scripts. | ||
- | * Part I: Implement the [[http://www.tpc.org/tpcds/|TPC-DS benchmark]] (deadline 1/11/2018) | + | The project is carried out in groups of 3 to 4 people. Before you can submit assignment part I, you will have to register in a group. For registering a group send an email to the lecturer. Please to select your group before or on 1/10/2018. The submission deadlines for parts I and II are strict. |
- | * Part II: Implement the [[http://www.tpc.org/tpcdi/|TPC-DI benchmark]] (deadline 20/12/2018) | + | |
- | + | ||
- | The submission deadlines for parts I and II are strict. | + | |
The project evaluation will count for 30% of your total grade. This may seem undervalued, however, putting effort in the project will definitely help you in achieving a better understanding of the course material which will result in a better score in the paper exam which amounts for 70% of the grade. | The project evaluation will count for 30% of your total grade. This may seem undervalued, however, putting effort in the project will definitely help you in achieving a better understanding of the course material which will result in a better score in the paper exam which amounts for 70% of the grade. |