Welcome to this new blog that has managers as the key focus, not the great MS Access and Office programmers that have followed me for 20 years. Enough said, here is my topic for the day...
What do you do if you are a manager and you find that the application (read Access database) that has helped run your group for a long time just seems to be too comolex for developers and users alike ? I pondered this recently from two angles, first we were asked to help manage two really big MS Access databases and secondly Basecamp,a tool that we use for online times and project correspondance decided to start again.
To Basecamp first: there are a few million users of this simple project management tool that has been around since 2004. The other day they told us that they had started Basecamp again with reasons discussed in this post by Jason Fried. Wow I thought, that is a bold move and if you read the arguments of improved design and simplicity in Jason's article, you have to contemplate the approach.
But further down the article in the commencts section is a great link to an article by Joel Spolsky that takes the side of improving the software that you have. In this article Joel makes the point that software is complex becuase it took a long time for the developer to design software to match the real world.
So what do I think we should do with complex databases, rewrite or stick with it. I suggest rewrite if
If this doesnt describe your sitation, this means the database is naturally complex and worthy of further improvement.
My programmers blog is here
Garry Robinson
.
What do you do if you are a manager and you find that the application (read Access database) that has helped run your group for a long time just seems to be too comolex for developers and users alike ? I pondered this recently from two angles, first we were asked to help manage two really big MS Access databases and secondly Basecamp,a tool that we use for online times and project correspondance decided to start again.
To Basecamp first: there are a few million users of this simple project management tool that has been around since 2004. The other day they told us that they had started Basecamp again with reasons discussed in this post by Jason Fried. Wow I thought, that is a bold move and if you read the arguments of improved design and simplicity in Jason's article, you have to contemplate the approach.
But further down the article in the commencts section is a great link to an article by Joel Spolsky that takes the side of improving the software that you have. In this article Joel makes the point that software is complex becuase it took a long time for the developer to design software to match the real world.
So what do I think we should do with complex databases, rewrite or stick with it. I suggest rewrite if
- The underlying database model is poorly designed and as a consequence the software has become complex.
- Your database is really successful and should be ported to a web or blended into your larger corporate environment
- The database is pretty well designed but the developer was an amateur who never really got anything right.
If this doesnt describe your sitation, this means the database is naturally complex and worthy of further improvement.
My programmers blog is here
Garry Robinson
.
RSS Feed