Few database projects start with a clean slate. Many operational applications have legacy databases as a source of data and ideas. Analytical applications have the operational databases that are feeding data. Developers often encounter existing databases that are poorly documented and need to figure them out. We use the term database archaeology to refer to the study of database artefacts
Continue reading here on +DATAVERSITY .
I've had to do this many times myself. You have to scour for documentation, find long standing employees, and worst case scenario reverse engineer data models and read through code to work out what is going on. There is a way to get 80% fairly easily and the rest you have to work out using data and traces ad comments in the code.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.