Waiting for validation
Your application is a directory of addresses saved in a single database table / document. Each entry contains:
-
A name, address (number and street name) and a postal code
-
The name of the entry creator (unique).
All users of your application can access all addresses in the database.
Users can only request all entries with a certain postal code.
You are asked to partition this table.
That means
-
Replicating the table on multiple slave servers to distribute queries
-
Splitting the table into multiple sub-tables, with each entry appearing in only one table
What are the possible partitioning keys to ensure that each query only reaches one table:
0
Community EvaluationsNo one has reviewed this question yet, be the first!
Similar QuestionsMore questions about IS Architecture
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
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 operations