Application first database second

“Application first database second” said the scrum master. I had an interesting conversation with a colleague about the philosophy underpinning his development methodology. We were discussing the merits of solid data modelling underpinning the agile method. I’d been considering this topic in Agile DBA His criticism of spending an excessive time creating the ideal data model – impinged upon the project deadlines. Data Architects were spending so much time gathering and analysing requirements , they weren’t able to shift product and new functionality to customers. His mantra of “Application first database second” focused his developers on developing quickly – usually... Read more →

DB2 process model

There’s a good article on http://www.ibm.com/developerworks/data/library/techarticle/dm-0807kharche/ outlining the DB2 9.5 process model. Key Points 1) New memory model 2) Increased automatic configurations . According to the article , less is required of the DBA. Based on my experience since DB2 9.5 – there’s some truth in this point. The focus is now more on architecture and DB2 performance tuning. Designing for scaling is a critcal part of designing the database server system 3) Process model is the same for : Linux,Unix and Windows 4) Context Switching between threads is quicker than process switching. Less resource is required . One process... Read more →