I have recently started reading Applied Mathematics for Database Professionals by Lex de Haan, and it is so far a very interesting book, but despite the title seems more theoretical than applied so far. But is there a real need for a DBA to have a deep understanding of mathematics? If there is, what other good resources are there for this?
(comments are locked)

I'd say... drumroll... It depends. It depends a lot on what you call mathemathics. When I studied "Algorithms and datastructures" we did learn a lot about efficiency calculations. It was officially a course in Computer Science, but in reality it was very mathematical. At my first university, Automata Theory was considered mathemathics, at other universities the same course would have been a computer science course. Generally, I'd say at least a basic understanding of Algebra and Logics is a must for any database professional. Depending on what you put into the profession "DBA" you might or might not need knowledge about algoritm efficiency. Not a deep knowledge, but you need to intuitively know which is the more efficient of two algorithms if you're going to study and understand execution plans. Finally: You always need to know about mathematics. It makes life easier, regardless of you profession. But that goes for a lot of academic disciplines, so if you're going to follow the rule "learn whatever you will later find useful" you would study a lot and work very little. I think you more eloquently explained my point of view, of course you need basic math skills to function daytoday. How would you calculate storage requirements without it, but are you doing any heavy lifting with mathematics on a regular basisprobably not (pun not intended) Your ability to think on your feet and function in highpressure situations where the Clevel staff is looking over your shoulder while you get the missioncritical production system back online is more valuable than anything you are going to learn from a book on theory
Jul 10, 2010 at 02:56 PM
Scot Hauder
@Scot: Understanding the basic theory is what helps you get the correct results from your databases. I would suggest that is MORE valuable, not less valuable than getting a "missioncritical production system back online". The latter is merely a tactical, productspecific skill that will be relearnt many times during a career. Database principles on the other hand are fundamentally useful knowledge that will probably endure for at least another generation.
Jul 10, 2010 at 11:48 PM
David 1
Ok. basic theory of what helps get the correct results? I agree database principles are important, but how are they mathematically intensive?
Jul 11, 2010 at 01:41 AM
Scot Hauder
For example dependency theory. Understanding join dependency and how to analyse dependencies will help you eliminate redundancy in database design. Knowing about the relational algebra and calculus will help you understand problems, communicate your ideas and understand the solutions produced by others. How much that requires a "deep" knowledge of math is subjective I suppose. For example I would say that some of the material in the Alice Book (Abiteboul et al) is pretty mathematically intensive  but maybe that's just because my own maths isn't so good!
Jul 11, 2010 at 10:25 AM
David 1
You make good points, the line between theoretical computer science and mathematics is a very blurry one indeed. Holding both a math degree and going through the book I mentioned right now, I obviously think there is value in knowing mathematics, but I was very interested in seeing if that was the consensus view or if I was in a minority. From the answers and the upvotes here, it looks like most people think you need to know math to be a good DBA, but the exact types and amounts seemed to be highly debated and largely sensitive to the individuals exact position.
Jul 14, 2010 at 10:12 AM
TimothyAWiseman
(comments are locked)

I'd say it's essential. An understanding of set theory, an particularly algorithmic maths is absolutely invaluable. For example, understanding how hash tables work, how indexes really work  they're not things that come naturally without an understanding of the basics. Absolutely, I agree you need to understand the basics. I haven't read the book Timothy cites but figured he was wondering about higher mathematics
Jul 09, 2010 at 04:54 PM
Scot Hauder
@Scot  well, when I did Alevels I took 3 pure maths modules, 2 statistics modules and 1 decision maths module. I have used the pure maths twice (once to solve a quadratic equation that makes the tooltips in my apps appear as close to the golden ratio as possible, and once for my asyetunreleased data exploration app). However, decision maths I use all the time. Stats  well, I haven't used that very much that's for sure!
Jul 09, 2010 at 04:56 PM
Matt Whitfield ♦♦
@Matt from a developer perspective, which I know you do a lot of, we definitely run into these problems. If you want to do more statistics get into datamining algorithms. Lots of probability and integrals!
Jul 09, 2010 at 05:21 PM
Scot Hauder
(comments are locked)

I would say yes. Set theory (obviously), and an understanding of probability is necessary. For example, how do you know how many database restores from your thousand databases do you need to do in order to be, say, 95% confident that they all work? See Thomas "Rockstar" LaRock's article Statistical Sampling for Verifying Database Backups and if you fully understand the maths behind it, then you're a better man than me. Thanks for the link,, it was very enlightening. Sometime soon I need to learn more statistics.
Jul 14, 2010 at 10:12 AM
TimothyAWiseman
(comments are locked)

I've read the book and it is theory laden. Some of it takes second readings to wrap your head around the authors' mindset. The title, Applied Mathematics for Database Professionals, sums it up  dB PROFESSIONALS. In this case I choose to view professionals as individuals determined to know their craft and focused on continuous improvement. de Haan and Koppelaars provide an excellent treatise on Set Theory with a goal of using it to perform dB design and, as it says on the cover, "communicate precisely about those designs with other stakeholders.". This is the sort of book that can take an accidental DBA from thinking of SQL as merely a series of Excel rows and columns to seeing just how complicated  yet simple  the reality is. As for the average dB Pro requiring Hawkinslevel mathematics skill... generally  no.
(comments are locked)

Yes. Relational database design is based in logic and mathematics. So are the building blocks of database queries. So those mathematical concepts are the toolkit you can use to solve database problems. Knowledge of the underlying principles is particularly relevant to SQL because SQL is a rather flawed attempt to imitate a relational database language. If you truly understand the relational foundations on which SQL was supposed to be based then you'll be more likely to avoid some of the pitfalls of working with SQL. I'm sorry  but I have to ask  How come you've only voted 14 times, with 5 of those times to vote someone down?
Jul 10, 2010 at 11:35 AM
Matt Whitfield ♦♦
Maybe because voting down bad answers is more important than voting up good ones. And there just aren't that many really bad answers on here.
Jul 10, 2010 at 12:11 PM
David 1
Interesting, do you short all of your investments too?
Jul 10, 2010 at 12:20 PM
Scot Hauder
(comments are locked)

1 2 next page »