Database Answers Header Extreme Conditions in a New England Winter
Extreme Data Centric Database Design
Home Ask a Question Data Models FAQs Search Site Map  
This page describes a Data-Centric approach to Database Design based on Extreme Programming.
If you would like to contribute to this subject, please Email us
Extreme Programming is a rapid approach to systems development, based on small incremental steps with collaboration where the Users play a vital part in evolutionary development.

The approach described on this page is a Data-Centric approach, and we have also established a User-Centric Approach.
In this variation, the Data Analyst plays a dominant role, where Users may not be available.
Here is a typical series of Steps :-
1 Identify the 'Things of Interest'. These are the Things that Users talk about by the coffee machine or Water Cooler.
2 Discuss the Things with the Users Define a Glossary of Terms.
3 Derive a first-cut Data Model. Use Entities and Attributes and a Modelling Tool, such as Data Architect or ERWin to generate SQL.
4 Relate Data Entities to each Step. Create Cross-reference matrix to check results.
5 Identify Life Cycle for each Entity Establish how data for each Entity is created and finally deleted,(if it is).
6 Prepare sample Data In collaboration with the Users.
7 Prepare Test Scripts Agree sign-off with the Users.
8 Define a Load Sequence Reference Data, basics such as Products, any existing Users or Customers,etc..
9 Run the Test Scripts Get User Sign-off to record progress.

[ Home Page | Ask a Question | Contact Us | FAQs | Search | Site Map ]

© IceBreaker WebDesigns 2002