Bryce the Table King said:IOW, the exam does not really reflect common reality. Just because there are 300 setup/performance parameters that CAN be tweaked does not mean that every site tweaks them often.
First of... when a company chooses to use one of the "big three" (MSSQL, Oracle or DB2)(TB3 from here on out) they have already found that they _-*>NEED<*-_ these extended features.
Most application using TB3, need the special tables constraints and indexing and properties of relations, using stored procedures is heavily affected by NON-use of these things. Many, Many DBAs have great skill in applying these little pieces of magic doing optimizations.
They can sometimes take a query that as designed takes HOURS to complete and pegs the DB machine heavily during that time-frame, to a make it a 2 minute query and still going through the same amount of data, just by aplying those table constraints and properties.
What it comes down to Bryce on *THAT* single statement alone you made, that you really have not seen ANY ERP, MRP or CRM solution that is designed for multi-user applications. Sure ACT! is great but it ain't SHIITE compared to Learning Solutions (which is an extremely integrated CRM aimed at Educational Institutions) from Peoplesoft. Sure QuickBooks is COOL and rocks... But a typical HRM/AP/AR solution aimed at any Fortune 2000 sized company Blows it away for sheer completeness and usability.
These kinds of applications *NEED* and *WANT* those tweaks... if you can't use and/or understand them and how or when to apply them... then you won't be a successful DBA.
Bryce yon sayeth again:If performance is really that important that somebody has to tweak that huge contraption all the time, then maybe IBM should split DBA's into "Database Performance Managers", and "Database Content Managers". The skills to design a good schema are quite different than those for tweaking buffer sizes or file arrangements for performance. (In theory, schemas should not reflect performance, but in practice they do somewhat. Chris Date suggests that this is due to retarded vendors and not relational theory. Regardless, it is a controversial topic.)
One fits more of the bit-twiddler mentality, and the other more of a business analyst. In my experience, such skills tend to be somewhat mutually exclusive.
Yes, performance is really *THAT* important. DBA stands for
Data
Base
Administrator. Given that acronym, let us actually goto and find out exactly what DBA means.
As found [link|http://searchnetworking.techtarget.com/gDefinition/0,294236,sid7_gci214169,00.html|HERE], Database Administrator means:A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. A DBA is expected to stay abreast of emerging technologies and new design approaches. Typically, a DBA has either a degree in Computer Science and some on-the-job training with a particular database product or more extensive experience with a range of database products. A DBA is usually expected to have experience with one or more of the major database management products, such as Structured Query Language, SAP, and Oracle-based database management software.
Okay, anywhere in there does the definition include
BUSINESS ANALYST? No it does not. a DBA is a mechanic of the high-perfomace data-engine. a
BUSINESS ANALYST is an individual that is in essence a person that *devises* how the DB is to be used to help the company fit the ERP/CRM/HRM/MRP/BLAH to the company. NO where that *I* know of does a DBA, that is a DBA, do "content management." That would fall into the realm of a Software Analyst's job, and you seem to be co-mingling the two/three.
Bryce, you seem to not have ever been in a situation where TB3 is used this way. Until you actually *SEE* that environment you'll never know why those tweaks are needed.
[link|mailto:greg@gregfolkert.net|greg] - IT Grand-Master for Anti-President |
[link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!] |
THEY ARE WATCHING YOU.
The time has come for you to take the last step.
You must love THEM.
It is not enough to obey THEM.
You must love THEM.
PEACE BEGETS WAR, SLAVERY IS FREEDOM, STRENGTH IN IGNORANCE.