Page 1 of 1

Database Efficiency?

Posted: Fri Mar 02, 2007 6:59 pm
by pcmattman
Does anyone here remember the equation for database efficiency? I know it's something like Efficiency = Data / Time or something like that.

Posted: Fri Mar 02, 2007 7:27 pm
by Tyler
Depends what action your talking about it really?

Posted: Fri Mar 02, 2007 7:30 pm
by pcmattman
Well for a database system where the user is searching the database for data...

It's a project for school, we're doing expert systems and I want to throw in the database efficiency equation to justify several (seemingly pointless) parts of the system's design.

Posted: Fri Mar 02, 2007 8:14 pm
by Tyler
Then yeah Search Efficiency can be expressed as such. If you are testing numerous algorithms against each other i would use a system where by all data in the system is searched for and average times per search are correlated.

Posted: Tue Mar 06, 2007 6:34 am
by Solar
Efficiency is in the eye of the beholder. Or: Database efficiency is whatever the marketing department claims it to be. 8)

Perhaps, for a given application, absolute search-time is crucial. Another app might require that search time scales well for huge databases. Another app might require that search time scales well for concurrency. Another app might require all three.

And that is not taking into account storage efficiency, reliability etc...