Technical report idea, other misc.

[superliuxz]

• How Hillview enforces extra constrains on the relational data model, aka how we discovered Hillview is not quite suitable for this assignment (relational data model) @superliuxz
  • data does not change while Hillview is running -> the data needs to be immutable. But when we de-duplicate the data from the universal model, we want to take the advantage that we can add a row in the student table easily.
  • no join support. To fully take advantage of Hillview, we actually need to put everything into a single table -> a universal model (bad)

[superliuxz]

https://developers.sap.com/tutorials/hxe-aa-movielens-sql-03.html

[superliuxz]

https://stackoverflow.com/questions/105400/what-are-indexes-and-how-can-i-use-them-to-optimize-queries-in-my-database/105661#105661

[superliuxz]

https://docs.google.com/document/d/1tm1ZX_tZss-qPf29NMMd8__LcSgCuNDAAt-zgE9r3W0/edit?usp=sharing