|
|
|
|
Browse by Tags
All Tags » Database Design (RSS)
-
I have gotten a few more reviews in, and interestingly I appreciate the negative ones almost as much as the positive ones. I prefer the negative ones that have decent star ratings better… but what are you going to do. The most recent review was critical Read More...
|
-
This blog probably won’t stir up a hornet’s nest or anything, but I would also expect that it would be the least popular in practice. The person who feels they can disagree with the need for a reasonable amount of documentation is probably nuts. In the Read More...
|
-
Okay, so on the first look this sounds like the most boring Japanese action movie ever. Requirements is tearing through the village, and Architecture is in the city. Developers by the horde are trying to code both of these into oblivion…Maybe not. Read More...
|
-
This one should be simple to anyone who sees it (once I decode what I mean by fundamentally… and sound…by then for sure!) In the initial post I defined this as – fundamental rules enforced such that you don’t have to check datatypes, base domains, relationships, Read More...
|
-
You know how when you go to a session and there is always this person who is heckling the presenter? Well, it isn’t that often that this person is authorized to be annoying people/answering questions at the request of the main presenter. Well, Read More...
|
-
The first pillar was easy, since no reasonable person is going to argue that having a design that is not coherent is desirable. No matter what the type of system, any design that isn’t easy to understand is likely to be a bad design (obvious caveats are Read More...
|
-
I know this is a topic that could cause a few heads to spin around uncontrollably if taken the wrong way, but I preserve. Today I was having a conversation with an end user, an influential one at that, about a business rule that was needed for the Read More...
|
-
One of the definitions on wiktionary.org for coherence is “a logical arrangements of parts ”. In my initial post, I defined “coherent” for database designs in the following manner: cohesive, comprehendible, standards based, names/datatypes all make sense, Read More...
|
-
Before I get started with the pillars of a well built database, I want to reply (in long form) to a comment on the last post. I see the phases of the project to have five distinct phases (again trying to make memorable lists that an stick in your mind): Read More...
|
-
As I am starting the process of writing my next edition of the database design book (over the next 3+ years) I am starting to try to come up with some catchy way of stating that a database is well designed and implemented. So I started to think of some Read More...
|
-
As I have been walking around Disney World this week, my mind starts to wander to matters of database design. Sad, perhaps, but I will guess that most people who read this blog do the same much the same thing with whatever technology they are good at Read More...
|
-
As I am easing back into real life from writing the book, I am in search of easy targets for blogging. My boss mentioned this blog over on Jeff Atwood's Coding Horror Blog and it got me thinking about commenting. His advice is to only comment Read More...
|
-
Starts out like this: "I’ve been designing relational databases since the mid 80’s. My conclusion is that the relational model is weak and lacking. Specifically, the foreign key – that simple DRI constraint which is the keystone of the relational model Read More...
|
-
I have been struggling to find a way to describe the fundamentals of first normal form for my PASS presentation, and this came to mind last night. SQL works in a very constructive way, meaning that if you have base values (commonly referred to as atomic, Read More...
|
-
Oh no, you may be thinking, he has gone off the deep end. Preparing for his talk on normalization at PASS this year he has finally cracked and said "to heck with it, just denormalize..." If you thought that, shame on you, and minus 10 points for you. Read More...
|
|
|
|
|
|