Medium
Your application is an address directory saved in a single database table/document. Each entry contains:
A name, an address (street number and name), and a postal code
The name of the entry's creator (unique).
All users of your application can access all addresses in the database.
Users can only request entries with a specific postal code.
You are asked to partition this table.
This means:
Replicating the table across multiple slave servers to distribute the requests
Splitting the table into multiple sub-tables, with each entry appearing in only one table.
Which partitioning keys would ensure that each query reaches only one table:
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
1
Explain the different types of caching in the context of an information system architecture.1
How long does it take to build a data warehouse?1
Explain the difference between a distribution group and a security group in Active Directory.0
If the data to be validated does not depend on other data in the database, performing data validation in the server application reduces the number of database queries compared to validation only in the database.0
A is faster than B, C is as fast as A, C is faster than B0
In a distributed system, it is possible to guarantee consistency (that all nodes in the system have access to the same data at the same time), it is possible to guarantee the atomicity of some operations0
What are the characteristics of a data warehouse?