Good database design is crucial to obtain a sound, consistent database, and — in turn — good database design methodologies are the best way to achieve the right design. These methodologies are taught to most Computer Science undergraduates, as part of any Introduction to database class. They can be considered part of the “canon”, and indeed, the overall approach to database design has been unchanged for years. Should we conclude that database design is a solved problem?
The problem of database design is difficult, and it encompasses issues that may not be amenable to formalization. Hence, any method is likely to have some limitations and drawbacks. However, this is not a reason to ignore the serious problems that the traditional approach is running into:
- the traditional approach is not followed in practice;
- we ask practitioners to follow a model that is demanding and yields, in return, some very limited results.
- Users are faceless objects for whom the systems are designed. It’s “everything for the people, but without the people”. (IT people, like communists, love central planning.)
- The information system is strongly consistent. (There is no such thing in practice.)
- Our semantics is absolute. There is a single valid point of view. (Maybe if you live in a cave…)
- Our models are static. Changes are uncommon. (Nonsense. The world is changing at a break-neck pace.)
- a distributed world and
- imperfect knowledge.