09 07 18

Pagina 1

Technologies for Information Systems Part I (10 points) prof. L. Tanca – July 9th, 2018 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ 1) Which type of data integration (materialized or virtual) is used in the case of Data Warehousing? Describe the main differences between the two approaches and justify the answer in your own words, possibly using a small example. 2) Consider the following data mining problems: frequent itemset mining and association rule discovery. Define them, discuss the differences between the two problems, and provide an application example for each of them. • During this part of the exam, students are not allowed to consult books or notes. • Students should answer the theoretical questions using their own words, in order for the teachers to be able to assess their real level of understanding. Technologies for Information Systems Part II (23 points) prof. L. Tanca – July 9th, 2018 Available Time: 2h 00m Last Name _________________________________________________________________ First Name _______________________________________________________________ Student ID ________________ Signature_______________________________________ PoliPatents is an organization granting technological patents to companies in America. Each patent may be assigned to multiple companies (i.e., the patent assignees) and is associated with one or more inventors; inventors are the people having participated in the invention that has been patented. PoliPatents stores the patent-related data in a relational database. UniPatents is a similar organization operating in…