解释为什么“只需向数据库添加另一列"对非程序员来说是个坏主意 [英] Explaining why "Just add another column to the DB" is a bad idea, to non programmers

问题描述

我有销售人员和专柜正试图向客户销售定制产品，这很好.但是当收到一个复杂的变更请求，我发回了一个很大的估计时，他们会感到困惑.他们经常回我说你为什么不能添加另一列?"换句话说，它们是指每个客户端的十几个自定义列.

I have sales people and bean counters who are trying to sell customizations to clients, which is fine. But when a complex change request comes in that I send back a large estimate for, they get confused. Often they come back at me with "Why can't you just add another column?" which by another, they mean a dozen or so custom columns PER client.

到目前为止，我只能说我们正在努力使数据库保持良好的规范化"，这对他们来说毫无意义.我告诉他们我可以创建一个表格系统，允许每个客户定义他们自己的一组自定义字段，但当然这比仅添加几列"需要更多的时间和金钱.当然，他们也想吃蛋糕.

So far all I can come back with is "We are trying to keep the database well normalized" which means nothing to them. I tell them I can create a system of tables that allows each client to define their own set of custom fields, but of course that takes more time and money than "just adding a few columns". And of course they want to have their cake and eat it too.

那么我怎样才能让他们理解呢?

So how can I make them understand?

推荐答案

我发现的最好方法是展示如何根据他们的要求创建新的功能您不能仅添加几个自定义列.功能优于定制，尤其是当您可以向某人收费时.

The best way I've found is to show how you can create a new feature out of what they're asking for that you couldn't add with just a couple customized columns. Features are better than customizations, especially when you can charge someone for it.

在进入技术领域之前，尝试为您的一方制定一个好的商业案例.

Try to make a good business case for your side before you get into the technical stuff.

这篇关于解释为什么“只需向数据库添加另一列"对非程序员来说是个坏主意的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！