An enhanced model to deal with large/complex data queries

When talking about Big data, most people think of data in the volume perspective, which is essentially true, but there are also other dimensions such as data variaty and data relationships.

 

Just like other alternative solutions in the internet industry, CURD is the basic operations for data, then we also know that queries happen much more offen then data modifications. In terms of storage, the data is centralized, while in terms of usage, data can be analysised from different angles.

 

For the triditional Oracle DB, we can also take advantage of this idea - make pre-compiled batched queried plus the delta data changes using materialized views and in-time queries. The pic attached describes the idea.