How to prove it?

It seems commonsense to most database specialists that, for data-centric applications where the application does not need to be database independent*, for logic that is close to your data – data logic – and data-intensive operations, it’s likely to be more efficient for that to be in the database, to be quicker in the database, to be cheaper in the database (by dint of the database having already been purchased and therefore just being a proxy of time to develop), to be less complex in the database, to be faster to write in the database, to have less lines of code and to be just as reusable in the database**

But how to prove it?

Many of us have no doubt written plenty of demos and proofs of concepts that validate the approach of on particular approach/solution over another in specific circumstances.

But is there any mileage in a set of benchmarks, similar perhaps to the TPC benchmarks used to compare hardware and database vendors? Maybe this already exists? Maybe this is exactly what the TPC benchmarks could also be used for. But I’d be interested in a focus broader than just speed including complexity, lines of code, testability, etc.

Ignoring my particular database-centric interest, how useful would it be to have a set of benchmarks that could be used to compare languages or new features in a language?

It would certainly make for an interesting challenge for those looking to fight the corner for their particular favorite. It would be useful information for a new project trying to justify which technology / features / architecture to go with and would make a change from the just “let’s use feature X because it’s new and exciting”.


*I’m thinking here about vendor applications that need to be database independent to support N different databases rather than a misguided notions that it’s general best practice and it’s more likely that you might change from Oracle to SQL Server than rip out your C# and go all Groovy.
**When written by someone who knows what their doing, obviously.

About these ads

2 Responses to How to prove it?

  1. tlt says:

    If you plan to compare the cost of an application running in the DB Vs one running on an application server or a client PC you also need to take into account the extra load you’ll be placing on the DB.

    In some other post someone mentioned an Oracle Enterprise license costing 320k for a 4 CPU box costing 20k. Now if your business logic runs on thick clients on PCs you’ll pay a total of 340k for hardware and licensing (you have the PCs anyway). If your business logic runs on IIS or Tomcat on a separate application server you’ll pay an additional 20k, so 360k in total. But if you move all your business logic to the DB and you need 2 DB servers to cope with the extra load, then you’re looking at 680k.

  2. chet says:

    @tlt

    Good point. But who really needs an 8 CPU database server? Million of hits an second? Minute? Hour?

    AskTom, according to his own posts receives about 40K hits a day. It’s hosted on a 4 CPU box running Linux. Apparently it registers as a minor blip. That tells me that if you need 8 CPU either you have hundreds of thousands of users logging into the database itself, or your application is poorly designed.

    The database was meant to deal with data, relational data. Business logic, 90% of the time belongs there.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 68 other followers

%d bloggers like this: