2 spelling and grammar
source | link

Although I agree with some posts that keys should be defindeddefined by the business case this seems to me the view from the perspective of a database administrator. From

From the perspective of data analytics where you may face a static data set you want to analyseanalyze such key combinations might be interesting and useful. Imagine Imagine a situation where you found a subset of data and you are wondering what the key fields are which determine it. For an instance letslet's assume you found a subset of orders for some combination of products and you wonder what the parameters which define these orders best. Ofc you
Of course you could define them by theretheir order ids but there might be a smaller and more interesting key combination such as the age of the customorcustomer and the time the order wherewas made. Thats

That's a typical clustering/classification problem.

Best regards, Raphael

Although I agree with some posts that keys should be definded by the business case this seems to me the view from the perspective of a database administrator. From the perspective of data analytics where you may face a static data set you want to analyse such key combinations might be interesting and useful. Imagine a situation where you found a subset of data and you are wondering what the key fields are which determine it. For an instance lets assume you found a subset of orders for some combination of products and you wonder what the parameters which define these orders best. Ofc you could define them by there order ids but there might be a smaller and more interesting key combination such as the age of the customor and the time the order where made. Thats a typical clustering/classification problem.

Best regards, Raphael

Although I agree with some posts that keys should be defined by the business case this seems to me the view from the perspective of a database administrator.

From the perspective of data analytics where you may face a static data set you want to analyze such key combinations might be interesting and useful. Imagine a situation where you found a subset of data and you are wondering what the key fields are which determine it. For instance let's assume you found a subset of orders for some combination of products and you wonder what the parameters which define these orders best.
Of course you could define them by their order ids but there might be a smaller and more interesting key combination such as the age of the customer and the time the order was made.

That's a typical clustering/classification problem.

1
source | link

Although I agree with some posts that keys should be definded by the business case this seems to me the view from the perspective of a database administrator. From the perspective of data analytics where you may face a static data set you want to analyse such key combinations might be interesting and useful. Imagine a situation where you found a subset of data and you are wondering what the key fields are which determine it. For an instance lets assume you found a subset of orders for some combination of products and you wonder what the parameters which define these orders best. Ofc you could define them by there order ids but there might be a smaller and more interesting key combination such as the age of the customor and the time the order where made. Thats a typical clustering/classification problem.

Best regards, Raphael