Question : Join and de-normalization:
Answered by : sumit-rawal-ig4gaypbyn28
{"tags":[{"tag":"p","content":"Join and de-normalization: Once a database has been sharded across multiple servers, it is hard to perform join operations across database shards. A common workaround is to de-normalize the database so that queries can be performed in a single table.\n "},{"tag":"p","content":"\n "},{"tag":"p","content":"In Figure 23, we shard databases to support rapidly increasing data traffic. At the same time, some of the non-relational functionalities are moved to a NoSQL data store to reduce the database load. Here is an article that covers many use cases of NoSQL [14]. "}]}
Source : | Last Update : Sat, 27 May 23