One of the biggest open problems in databases is materialised views. Imagine you are repeatedly querying a database after any change. The result of your queries is the materialised view. This view must update as new data streams in. You shouldn’t have to pay the cost of a full query each time. The database should be clever enough to compute a minimal incremental change from the current state of your view. It seems reasonable, yet it’s too much to ask of current databases.
Share this post
The future is seamless and collaborative
Share this post
One of the biggest open problems in databases is materialised views. Imagine you are repeatedly querying a database after any change. The result of your queries is the materialised view. This view must update as new data streams in. You shouldn’t have to pay the cost of a full query each time. The database should be clever enough to compute a minimal incremental change from the current state of your view. It seems reasonable, yet it’s too much to ask of current databases.